Opened 9 years ago

Closed 8 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)



Subtickets

Change History (5)

comment:1 Changed 9 years ago by Will Kahn-Greene

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

comment:2 Changed 9 years ago by Christopher Allan Webber

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 Changed 9 years ago by Christopher Allan Webber

Keywords: sql added

comment:4 Changed 8 years ago by Elrond

Milestone: 0.2.10.2.2

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

comment:5 Changed 8 years ago by Christopher Allan Webber

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.