Warning: Can't synchronize with repository "(default)" (Unsupported version control system "svn": No module named svn). Look in the Trac log for more information.

Ticket #737 (closed task: fixed)

Opened 8 years ago

Last modified 7 years ago

[RESOURCE] SQL command set to migrate from identity in TG 0.9a4 (and before) to 0.9a5

Reported by: godoy Owned by: anonymous
Priority: high Milestone: 0.9a5
Component: Identity Version:
Severity: major Keywords: identity, sqlobject, migration, script
Cc:

Description

Since the identity model was changed and to avoid having to recreate all tables, this script will help with the migration of a PostgreSQL database with the standard tables at the public schema (if you don't know if this is your case, then it probably is ;-) -- if you did nothing to change identity and uses SQLObject, then run this).

Please, also note that all changes in code that you might need for your own customized user creation routines / checks will need to be updated by you. If you're using the commands shown in the wiki, you might be lucky and need no change at all.

This has been tested on two development databases and one production database (yep, running SVN code as of today ;-)).

I believe this could be included somehow in the "UPDATE" notices or in an auxiliary directory and mentioned in the docs.

Attachments

identity-migrate-09a4-to-09a5.sql Download (319 bytes) - added by godoy 8 years ago.
Table migration SQL script for PostgreSQL. Updates tables from identity in 0.9a4 (and before) to 0.9a5
identity-migrate-09a4-to-09a5-mysql.sql Download (388 bytes) - added by max 8 years ago.
sql script for MySQL
identity-migrate-09a4-to-09a5-sqlite.sql Download (1.6 KB) - added by bobkuehne@… 8 years ago.
Table migration SQL script for SQLite. Updates tables from identity in 0.9a4 (and before) to 0.9a5

Change History

Changed 8 years ago by godoy

Table migration SQL script for PostgreSQL. Updates tables from identity in 0.9a4 (and before) to 0.9a5

comment:1 Changed 8 years ago by godoy

  • Summary changed from [RESOURCE] SQL command set to migrate from identity in TG 0.9a4 to 0.9a5 in PostgreSQL to [RESOURCE] SQL command set to migrate from identity in TG 0.9a4 (and before) to 0.9a5 in PostgreSQL

Forgot the install instructions:

psql -f identity-migrate-09a4-to-09a5.sql your_database

Changed 8 years ago by max

sql script for MySQL

comment:2 Changed 8 years ago by max

  • Summary changed from [RESOURCE] SQL command set to migrate from identity in TG 0.9a4 (and before) to 0.9a5 in PostgreSQL to [RESOURCE] SQL command set to migrate from identity in TG 0.9a4 (and before) to 0.9a5

added MySQL script

comment:3 Changed 8 years ago by kevin

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

A note of this has been made in the CHANGELOG and the upgrading guide. Thanks!

Changed 8 years ago by bobkuehne@…

Table migration SQL script for SQLite. Updates tables from identity in 0.9a4 (and before) to 0.9a5

Note: See TracTickets for help on using tickets.