Simple Migration tool intend to be used for any languages, for any db.
Please feel free to criticize, comment, etc. Currently this is working for MySQL, PostgreSQL. Soon will be available for other Databases too.
प्रवसन {pravasan} = MIGRATION(Noun)
- Choose proper OS & Download from http://pravasan.github.io/pravasan/#download
- Unzip / Untar the file downloaded
- For some OS its default but some it needs to be explicit add
chmod +x pravasan_*
- Look at the below Usage and start using it from the folder where you would like to execute & store migration files.
pravasan [<flags>] <action> <sub-action> [data input]
Usage of pravasan:
-autoAddColumns="": Add default columns when table is created
-confOutput="json": config file format: json, xml
-d="": database name
-dbType="mysql": database type
-h="localhost": database hostname
-indexPrefix="idx": prefix for creating Indexes
-indexSuffix="": suffix for creating Indexes
-migDir="./": migration file stored directory
-migFileExtn="prvsn": migration file extension
-migFilePrefix="": prefix for migration file
-migOutput="json": current supported format: json, xml
-migTableName="schema_migrations": migration table name
-p=false: database password
-port="5432": database port
-storeDirectSQL=true: Store SQL in migration file instead of XML / JSON
-u="": database username
-version=false: print Pravasan version
To create the configuration file use either of the below commands & pravasan.conf.json / pravasan.conf.xml will be created
pravasan -u="root" -p -dbType="mysql" -d="testdb" -h="localhost" -port="5433" create conf
pravasan -u=root -p -dbType=postgres -d=testdb -h=localhost -port=5433 -output=xml create conf
Assuming the pravasan.conf.json or pravasan.conf.xml file is set already
pravasan add add_column test123 id:int
pravasan a ac test123 id:int # Same as above
pravasan add add_index test123 id order name
pravasan add create_table test123 id:int name:string order:int status:bool
pravasan a ct test123 id:int name:string order:int status:bool # Same as above
pravasan add drop_column test123 id
pravasan add drop_index test123 id order name
pravasan add rename_table test123 new_test123
pravasan add sql # to add SQL statements directly.
pravasan down [-1]
pravasan up
pravasan up 20150103174227, 20150103174333
If you like not to store the credentials in file then use it like this
pravasan -u=root -p -dbType=postgres -d=testdb -h=localhost -port=5433 up 20150103174227
- Support for Oracle, MongoDB, etc.,
- Create & read from Conf file (XML / JSON)
- Output in XML, JSON format
- Support for Direct SQL Statements
- Support for MySQL, Postgres
- Temporarily SQLite3 is stopped - due to compile issue.
- moved from https://github.com/kishorevaishnav/godbmig
$ pravasan -autoAddColumns: id:int created_at:datetime modified_at:datetime create conf
The above command will add the 3 columns id
, created_at
, modified_at
will be stored in configuration & will get added during any create_table
statements.
$ pravasan -storeDirectSQL a ct test123 id:int
The above command will add (a
) a migration & will generate create_table (ct
) action with the table name test123
with only one column id
of datatype int
as SQL into the JSON (by default) or XML if there is an configuration file present and set XML to generate.
$ pravasan list datatypes # All databases
$ pravasan l dt # All databases
$ pravasan list dt postgresql # Will list datatypes supported by PostgreSQL
$ pravasan list datatypes sqlite3 # Will list datatypes supported by SQLite3
$ pravasan l dt mysql # Will list datatypes supported by MySQL
Below is the sample output for the above last command.
+-------------------+-----------------------+--------------+
| DATATYPE | SUPPORTED DATABASE(S) | ALIAS |
+-------------------+-----------------------+--------------+
| VARCHAR | MySQL | |
| VARBINARY | MySQL | |
| MEDIUMBLOB | MySQL | |
| LONGBLOB | MySQL | |
| DATE | MySQL | |
| REAL | MySQL | |
| DEC | MySQL | DECIMAL |
| NUMERIC | MySQL | DECIMAL |
| STRING | MySQL | VARCHAR(255) |