Changeset 49

Timestamp:

05/14/09 18:51:23 (3 years ago)

Author:

tom

Message:

Update the interactive migration tool for the RC6 schema.

This patch updates the interactive migration tool to recognise
and upgrade to the RC6 database schema.

File:

• migration/migrate.py (modified) (2 diffs)

migration/migrate.py

@@ -34 +34 @@
 V_RC4           = 1
 V_RC5           = 2
-LATEST_VERSION  = V_RC5
+V_RC6           = 3
+LATEST_VERSION  = V_RC6
 UNKNOWN_VERSION = -1
 
 version_names       = { V_RC4: "RC4",
                         V_RC5: "RC5",
+                        V_RC6: "RC6",
                         UNKNOWN_VERSION: "(unknown)" }
 
 upgrade_sql_files   = { V_RC4: "rc4-to-rc5.sql",
-                        V_RC5: None }
+                        V_RC5: "rc5-to-rc6.sql",
+                        V_RC6: None }
 
 def detect_xts_version(db):
     has_payment_type = False
+    has_online = False
     
     tables = db.query("SHOW TABLES;");
@@ -55 +59 @@
     if not has_payment_type:
         return V_RC4
-    return V_RC5
+        
+    proto_table = db.query("SHOW COLUMNS FROM snewts_ticketprototype");
+    for proto_col in proto_table:
+        if proto_col.values()[0] == "online":
+                has_online = True
+                break
+    
+    if not has_online:
+        return V_RC5
+    
+    return V_RC6
 
 def run_migrate_step(ver, db, mcb):