molder is a tool to manage the database table structure with yaml
molder [command] [option]
| Command | Description |
|---|---|
| extract | Connect to the database and export the tables as yaml |
| create | Create tables from yaml |
| recreate | drops the existing tables and reconstructs the tables from yaml |
| update | Compare the differences between yaml and the database and update tables and columns |
| diff | Display difference between yaml and database |
| Options | Description | Examples etc. | |
|---|---|---|---|
| --hosts <hosts> | Connection information to the database yaml file path | hosts.yml | |
| --host <host> | database host (connection destination name when -f is specified) | localhost | * |
| --type <type> | database type | mysql, pgsql, mssql | * |
| --user <user> | users connecting to the database | * | |
| --password <password> | Password for connecting to the database | * | |
| --database <database> | database name | * | |
| --input <input> | input yaml file path | db.yml | |
| --output <output> | output directory of extract directory | ||
| --query | Output to screen without executing query at create, recreate, update | ||
| --dry-run | executing query withount committing at create, recreate, update | ||
| --over-write | after createing, recreating, updating, extracting and overwriting input file | ||
| --help | show help |
*--hosts option is required for unspecified
When specifying connection information with argument
molder extract --host localhost --type mysql --user root --password password --database molder --output .
When setting connection information in a file
molder extract --hosts hosts.yml --output .
When specifying connection information with argument
molder create --host localhost --type mysql --user root --password password --database molder --input db.yml
When setting connection information in a file
molder create --hosts hosts.yml --input db.yml
When query is displayed
molder create --hosts hosts.yml --input db.yml --query
When specifying connection information with argument
molder recreate --host localhost --type mysql --user root --password password --database molder --input db.yml
When setting connection information in a file
molder recreate --hosts hosts.yml --input db.yml
When query is displayed
molder recreate --hosts hosts.yml --input db.yml --query
When specifying connection information with argument
molder update --hosts localhost --type mysql --user root --password password --database molder --input db.yml
When setting connection information in a file
molder update --hosts hosts.yml --input db.yml
When query is displayed
molder update --hosts hosts.yml --input db.yml --query
When specifying connection information with argument
molder diff --host localhost --type mysql --user root --password password --database molder --input db.yml
When setting connection information in a file
molder diff --hosts hosts.yml --input db.yml
You can list multiple connection information in yml
You can mix different types of databases as follows
If you do not specify a name with the --host option, the command is executed for all destinations
server 1:
type: mysql
host: localhost
user: db_user_1
password: password
database: molder
server 2:
type: pgsql
host: localhost
user: db_user_2
password: password
database: molder
server3:
type: mssql
host: localhost
user: sa
password: !Passw0rd
database: molder
When doing to all connection destinations
A file is created for server1.yml, server2.yml, server3.yml and connection destination
molder extract --input hosts.yml --output .
When specifying the connection destination name
It extracts only 'server1' and creates server1.yml
molder extract --input hosts.yml --host server1 --output .