dbtk/schema-loader

Load Database schema from XML

v2.7.1 2020-02-18 14:27 UTC

Requires

• doctrine/dbal: ~2.5
• linkorb/connector: ~1.0
• symfony/console: ^2.4|^3.0|^4.0|^5.0

Requires (Dev)

• linkorb/conventions-checker: ~1.1
• phpunit/phpunit: ~4.6

MIT

• Joost Faassen
• LinkORB Engineering Team

• database
• xml
• schema
• loader
• linkorb

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

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

Btw, we're hiring!