[Checkins] SVN: relstorage/trunk/ added to changelog and clarified
the migration scripts
Shane Hathaway
shane at hathawaymix.org
Wed Feb 27 14:49:56 EST 2008
Log message for revision 84350:
added to changelog and clarified the migration scripts
Changed:
U relstorage/trunk/CHANGELOG.txt
U relstorage/trunk/notes/migrate-1.0-beta.txt
-=-
Modified: relstorage/trunk/CHANGELOG.txt
===================================================================
--- relstorage/trunk/CHANGELOG.txt 2008-02-27 19:39:04 UTC (rev 84349)
+++ relstorage/trunk/CHANGELOG.txt 2008-02-27 19:49:55 UTC (rev 84350)
@@ -1,6 +1,13 @@
-RelStorage 1.0 beta 1
+RelStorage 1.0
+- The previous fix for non-ASCII characters was incorrect. Now transaction
+ metadata is stored as raw bytes. A schema migration is required; see
+ notes/migrate-1.0-beta.txt.
+
+
+RelStorage 1.0 beta
+
- Renamed to reflect expanding database support.
- Added support for Oracle 10g.
Modified: relstorage/trunk/notes/migrate-1.0-beta.txt
===================================================================
--- relstorage/trunk/notes/migrate-1.0-beta.txt 2008-02-27 19:39:04 UTC (rev 84349)
+++ relstorage/trunk/notes/migrate-1.0-beta.txt 2008-02-27 19:49:55 UTC (rev 84350)
@@ -1,13 +1,19 @@
1.0 Beta Migration
+Use one of the following scripts to migrate from RelStorage 1.0 beta to
+RelStorage 1.0. Alter the scripts to match the Python default encoding.
+For example, if 'import sys; print sys.getdefaultencoding()' says the
+encoding is "iso-8859-1", change all occurrences of 'UTF-8' or 'UTF8'
+to 'ISO-8859-1'.
-PostgreSQL 8.3:
+PostgreSQL 8.3 (using the psql command):
+
ALTER TABLE transaction
ALTER username TYPE BYTEA USING (convert_to(username, 'UTF-8')),
ALTER description TYPE BYTEA USING (convert_to(description, 'UTF-8'));
-PostgreSQL 8.2 and below:
+PostgreSQL 8.2 and below (using the psql command):
ALTER TABLE transaction
ALTER username TYPE BYTEA USING
@@ -15,13 +21,13 @@
ALTER description TYPE BYTEA USING
(decode(replace(convert(description, 'UTF-8'), '\\', '\\\\'), 'escape'));
-MySQL:
+MySQL (using the mysql command):
ALTER TABLE transaction
MODIFY username BLOB NOT NULL,
MODIFY description BLOB NOT NULL;
-Oracle:
+Oracle (using the sqlplus command):
ALTER TABLE transaction ADD (
new_username RAW(255),
More information about the Checkins
mailing list