Read schema from file

[renne]

Currently a database container has to be started and the SQL-schema has to be imported to read the SQL-schema with sql-ts.
This is quite time consuming in software development.

I suggest an option to read the SQL-schema directly from a file including CREATE TABLE statements.

[rmp135]

I have no intention of importing directly from CREATE statements. However it does support reading from a definition object file so the database doesn't have to be online. This is really meant for an intermediary step, not as the primary way of generating the definitions.

// Fetch database schema once using a config.

const asObject = await Client
  .fromConfig(config)
  .fetchDatabase()
  .toObject()

// Serialise the output, then the file can be modified and reimported without the db.

const definition = await Client
  .fromObject(asObject, config)
  .toTypescript()