[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