NAME

IX::DB - database connection and schema management for IX

SYNOPSIS

  # database handle available to IX application
  $IX::DB::dbh->prepare();
  
  # command line utilities
  ./custom_app -IX::DB::dumpSchema
  
  ./custom_App -IX::DB::diffSchemas

REQUIREMENTS

IX::DB requires DBI, DBIx::Connector and the DBD::MySQL modules. It also assumes you will have put your database credentials into your Local/.secrets file.

METHODS

diffSchemas()

Compares the managed schema file ('custom_app.schema.sql') with one dumped from the current environment ('custom_app.schema.current.sql') and displays the diff output side by side.

dumpSchema()

Dumps the database schema from the current environment. Called by IX::IX::build() and by diffSchemas(), and may also be run at the command line.