Opened 4 years ago

Closed 4 years ago

#2219 closed task (fixed)

Introduce phinx as DB migration tool

Reported by: shevek Owned by:
Priority: blocker Milestone: 2.6
Component: BW Database Keywords:
Cc:

Description

Perform necessary actions to be able to use phinx (see phinx.org) for DB migrations.

This includes update of INSTALL to tell people how to get composer and use it. Define composer.json.

First migration should be to drop dbversion table if it exists (part of the new test DB effort, no longer needed with phinx).

Change History (16)

comment:1 Changed 4 years ago by shevek

Add /vendor and composer.lock to .gitignore.

comment:2 Changed 4 years ago by shevek

  • Status changed from new to local_testing

comment:3 Changed 4 years ago by crumbking

I get an error while: vendor/bin/phinx migrate

[InvalidArgumentException?]

Migration "2014061917000_drop_db_version.php" has the same name as "20140619170000_drop_db_version.php"

comment:4 Changed 4 years ago by shevek

Try again please after a pull.

comment:5 Changed 4 years ago by crumbking

works!

comment:6 Changed 4 years ago by crumbking

  • Status changed from local_testing to to_alpha

comment:7 Changed 4 years ago by shevek

  • Status changed from to_alpha to testing

Deployed to alpha.

comment:8 Changed 4 years ago by shevek

Added a RoxMigration? class to handle word code updates and additions as part of the migration. Should make it easier for devs to add these.

See https://gitorious.org/bewelcome/rox/commit/8370c18e86825e19e049e934a81c07e64cc7f4c3

comment:10 Changed 4 years ago by shevek

Works. Suggest to close it.

comment:11 Changed 4 years ago by shevek

  • Status changed from testing to needs_work

comment:12 Changed 4 years ago by shevek

  • Status changed from needs_work to to_beta

comment:13 Changed 4 years ago by shevek

The include for RoxMigration? in phinx.php used camel case which worked fine on Windows systems but fails on linux. Fixed with: https://gitorious.org/bewelcome/rox/commit/89167aad9254e98adc846e8b3369165b937068bf

comment:14 Changed 4 years ago by crumbking

worked with the last fix.

comment:15 Changed 4 years ago by shevek

  • Status changed from to_beta to testing

comment:16 Changed 4 years ago by shevek

  • Resolution set to fixed
  • Status changed from testing to closed

Database migration works now with phinx. Several deploys showed no issues.

Closing as 'fixed'.

Note: See TracTickets for help on using tickets.