Feature: Automatically create/update records of child based on definition in parent or id in child

[Micnubinub]

Is your feature request related to a problem?

No

Describe the solution

Say we have this schema below

DEFINE TABLE IF NOT EXISTS user SCHEMAFULL;

DEFINE FIELD name ON user TYPE string;
DEFINE FIELD address ON user TYPE record<address>;


DEFINE TABLE IF NOT EXISTS address SCHEMAFULL;

DEFINE FIELD street ON address TYPE string;
DEFINE FIELD number ON address TYPE string;

At the moment if we want to create a user with a address we have to:

LET $address = (CREATE address CONTENT {
  street: "test",
  number: "123"
})[0].id

CREATE user CONTENT {
  name: "Test User",
  address: $address
}

Proposing auto create/update like so:

CREATE user CONTENT {
  name: "Test User",
  address: { # line picks up that this is address from the schema
  street: "test",
  number: "123"
}
}

CREATE|Update user CONTENT {
  name: "Test User",
  address: { 
  id: address:1, # line picks up that this is address from the id
  street: "test",
  number: "123"
}
}

Alternative methods

Just doing it manually

SurrealDB version

1.4.2

Contact Details

lindelwencube.ln@gmail.com

Is there an existing issue for this?

• I have searched the existing issues

Code of Conduct

• I agree to follow this project's Code of Conduct