Opened 12 years ago

Closed 12 years ago

#381 closed defect (fixed)

SQL Migrations

Reported by: Christopher Allan Webber Owned by: Christopher Allan Webber
Priority: major Milestone: 0.3.0
Component: programming Keywords: sql
Cc: Parent Tickets:

Description (last modified by Christopher Allan Webber)

Minish SQL migrations support (as in, database migrations, not
mongo->SQL conversion, that's a different bug.)

I'm close to being done with this. Track progress here:

[https://gitorious.org/\ :sub:`cwebber/mediagoblin/cwebbers-mediagoblin/commits/sqlmigrate](https://gitorious.org/`\ cwebber/mediagoblin/cwebbers-mediagoblin/commits/sqlmigrate)



Change History (5)

comment:1 by Will Kahn-Greene, 12 years ago

The original url for this bug was http://bugs.foocorp.net/issues/740 .
Relations:
#379: blocks

comment:2 by Christopher Allan Webber, 12 years ago

Here's a status report.

  • I've written a migration system that should be extensible enough to handle multiple SQL database types and extensible stuff like plugins, etc. Tests are currently passing in it.
  • Except! I had to comment out one test. It seems that sqlite support for dropping certain types of columns leads to errors, but that's really not our fault, but another bug
  • This stuff still needs to be hooked up to the ./bin/gmg metacommand. It technically is, but I haven't checked if it works.

comment:3 by Christopher Allan Webber, 12 years ago

Keywords: sql added

comment:4 by Elrond, 12 years ago

Milestone: 0.2.10.2.2

I guess, we will get sql migrations ready in 0.2.2.

comment:5 by Christopher Allan Webber, 12 years ago

Description: modified (diff)
Resolution: fixed
Status: acceptedclosed

The only thing missing from this is that we have tests, but I wanted to do a couple more tests, but mostly variations on the same thing. So I guess it's safe to close this since it's done and it has reasonably good (but not absolutely amazingly stellar) tests.

Note: See TracTickets for help on using tickets.