@databases/[email protected]

New Features

• Initial release (#240)

@databases/[email protected]

Breaking Changes

• Update sqlite3 to v5 (#244)

@databases/[email protected]

Bug Fixes

• Transactions that were retried due to serialization failures were not handled correctly (#242)

@databases/[email protected]

New Features

• Added .bulkInsertOrIgnore(options) (#229)

  Like bulkInsert except it will ignore conflicting inserts.

• Added .bulkInsertOrUpdate(options) (#229)

  Like bulkInsert except it will update records where insert would conflict.

  async function setUserFavoriteColors(
    users: {
      email: string;
      favorite_color: string;
    }[],
  ) {
    await tables.users(db).bulkInsertOrUpdate({
      columnsToInsert: [`email`, `favorite_color`],
      columnsThatConflict: [`email`],
      columnsToUpdate: [`favorite_color`],
      records: users,
    });
  }

@databases/[email protected]

New Features

• Add --schemaName parameter (#238)

@databases/[email protected]

New Features

• Added bulkInsertStatement utility (#229)

  This returns the SQL statement, rather than immediately executing it. This can be useful because it lets you add ON CONFLICT handlers.

@databases/[email protected]

Bug Fixes

• An error was thrown when a query returns NULL in a column of type TIMESTAMP (#235)

@databases/[email protected]

New Features

• Add --schemaName parameter (#238)

@databases/[email protected]

Bug Fixes

• pg-test run some-command always exited with code 0, even if the command failed (#227)

• Help text for sub-commands was not shown correctly (#227)

@databases/[email protected]

Bug Fixes

• Fix error message typo (#226)