Creating Records

note

Creating records is a fundamental operation when working with any data-driven application. The Model class provides methods to create single or multiple records in the database.

Table of Contents

• Creating a Single Record
• Creating Multiple Records

We will use the Author model defined earlier to demonstrate these operations.

const Author = new Model('author', {
  name: { type: 'string' },
  email: { type: 'string', uniq: true }
});

create

The create method is used to create a single record.

Signature:

create(
  record: InferSchemaTypesWrite<S>,
  transaction?: Transaction | string,
  options?: { validate: boolean }
): Promise<DBRecordInstance<InferSchemaTypesWrite<S>>>;

Parameters:

• record: An object that adheres to the schema defined for the model.
• transaction (optional): A transaction object or string to include the operation within a transaction.
• options (optional): An object to specify additional options, such as whether to validate the record before creating it.

Returns:

• A promise that resolves to a DBRecordInstance containing the created record.

Examples:

Basic Example:

const newAuthor = {
  name: 'John Doe',
  email: 'john.doe@example.com'
};

const createdAuthor = await Author.create(newAuthor);
console.log(createdAuthor);

/*
{
  data: {
    __id: 'generated_id',
    __label: 'author',
    name: 'John Doe',
    email: 'john.doe@example.com'
  }
}
*/

Complex Example:

const newAuthor = {
  name: 'Jane Smith',
  email: 'jane.smith@example.com'
};

const transaction = await db.tx.begin();
try {
  const createdAuthor = await Author.create(newAuthor, transaction);
  await transaction.commit();
  console.log(createdAuthor);

  /*
  {
    data: {
      __id: 'generated_id',
      __label: 'author',
      name: 'Jane Smith',
      email: 'jane.smith@example.com'
    }
  }
  */
} catch (error) {
  await transaction.rollback();
  throw error;
}

createMany

The createMany method is used to create multiple records in a single operation.

Signature:

createMany(
  records: InferSchemaTypesWrite<S>[],
  transaction?: Transaction | string,
  options?: { validate: boolean }
): Promise<DBRecordsArrayInstance<S>>;

Parameters:

• records: An array of objects, each adhering to the schema defined for the model.
• transaction (optional): A transaction object or string to include the operation within a transaction.
• options (optional): An object to specify additional options, such as whether to validate the records before creating them.

Returns:

• A promise that resolves to a DBRecordsArrayInstance containing the created records.

Examples:

Basic Example:

const authors = [
  { name: 'Alice Johnson', email: 'alice.johnson@example.com' },
  { name: 'Bob Brown', email: 'bob.brown@example.com' }
];

const createdAuthors = await Author.createMany(authors);
console.log(createdAuthors);
/*
{
  data: [
    {
      __id: 'generated_id_1',
      __label: 'author',
      name: 'Alice Johnson',
      email: 'alice.johnson@example.com'
    },
    {
      __id: 'generated_id_2',
      __label: 'author',
      name: 'Bob Brown',
      email: 'bob.brown@example.com'
    }
  ],
  total: 2
}
*/

Complex Example:

const authors = [
  { name: 'Charlie Green', email: 'charlie.green@example.com' },
  { name: 'David Blue', email: 'david.blue@example.com' }
];

const transaction = await db.tx.begin();
try {
  const createdAuthors = await Author.createMany(authors, transaction);
  await transaction.commit();
  console.log(createdAuthors);
  /*
  {
    data: [
      {
        __id: 'generated_id_1',
        __label: 'author',
        name: 'Charlie Green',
        email: 'charlie.green@example.com'
      },
      {
        __id: 'generated_id_2',
        __label: 'author',
        name: 'David Blue',
        email: 'david.blue@example.com'
      }
    ],
    total: 2
  }
  */
} catch (error) {
  await transaction.rollback();
  throw error;
}