g4/db-tools

Database migration related tools

db-tools

Usage, _(*1)

Inside project folder, it's required to create this set of folders, _(*2)

db/
  dumps/ 
  logs/
  migrations/
    default/

Root folder may be configured with parameter ruckusing_dir., _(*3)

Command line has some required options:, _(*4)

 ini - Relative path to application.ini which contain's database configuration files
 env - Environment which will be read from application.ini
 sql-dump - Relative path to SQL file that needs to be imported
 ruckusing_dir - dir name of where database and migration related files are

Example:, _(*5)

php vendor/g4/db-tools/bin/tools.php import:data env=$(env) sql-dump=${ND_API_SQL_DUMP} ini=${APPLICATION_INI} ruckusing_dir=${RUCKUSING_DIR}

php vendor/g4/db-tools/bin/ruckus.php db:status env=$(env) ini=${APPLICATION_INI} ruckusing_dir=${RUCKUSING_DIR}

This variables should be defined inside Makefile like:, _(*6)

APPLICATION_INI  = application/setup/config/application.ini
RUCKUSING_DIR    = db
ND_API_SQL_DUMP  = $(RUCKUSING_DIR)/dumps/nd_api_v1.0.0.sql
GEONAME_SQL_DUMP = $(RUCKUSING_DIR)/dumps/geoname.compact.sql

Import db-tools makefile targets into project's Makefile with, _(*7)

include vendor/g4/db-tools/dbtools.mk