Skip to content
Database schema loader
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
bin
example
src
tests
.editorconfig
.gitignore
LICENSE.md
README.md
composer.json
composer.lock
phpunit.xml.dist

README.md

schema-loader

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!

You can’t perform that action at this time.