dbtk/schema-loader

Load Database schema from XML

v2.6.0 2018-06-22 06:52 UTC

README

Load database schema from an XML file.

Usage

You can load schema to database by:

Database url

A full URL containing username, password, hostname and dbname:

./bin/dbtk-schema-loader schema:load example/schema.xml mysql://username:password@localhost/dbname

Just a dbname

In this case linkorb/database-manager is used for loading database connection details (server, username, password, etc) from .conf files (read project readme for more details).

In a nutshell - you must have a dbname.conf file at /share/config/database/ as described at database-manager's documentation.

./bin/dbtk-schema-loader schema:load example/schema.xml dbname

Examples

See example/schema.xml or /tests/fixtures/schema.xml.

Notices

  • Don't forget to use notnull="false" for optional fields.
  • Don't use primaryKey="id" in table definition - in version ~2.0 indexes have new format.

License

Please refer to the included LICENSE file

Brought to you by the LinkORB Engineering team

687474703a2f2f7777772e6c696e6b6f72622e636f6d2f642f6d6574612f74696572312f696d616765732f6c696e6b6f7262656e67696e656572696e672d6c6f676f2e706e67
Check out our other projects at engineering.linkorb.com.

Btw, we're hiring!