[CalendarServer-changes] [7347] CalendarServer/branches/users/glyph/oracle-nulls/txdav/common/ datastore/sql_tables.py

[source_changes at macosforge.org]

Revision: 7347
          http://trac.macosforge.org/projects/calendarserver/changeset/7347
Author:   glyph at apple.com
Date:     2011-04-21 09:53:05 -0700 (Thu, 21 Apr 2011)
Log Message:
-----------
Don't bother dropping tables / sequences, since you need to drop them in a very precise order anyway.

Modified Paths:
--------------
    CalendarServer/branches/users/glyph/oracle-nulls/txdav/common/datastore/sql_tables.py

Modified: CalendarServer/branches/users/glyph/oracle-nulls/txdav/common/datastore/sql_tables.py
===================================================================
--- CalendarServer/branches/users/glyph/oracle-nulls/txdav/common/datastore/sql_tables.py	2011-04-21 16:52:59 UTC (rev 7346)
+++ CalendarServer/branches/users/glyph/oracle-nulls/txdav/common/datastore/sql_tables.py	2011-04-21 16:53:05 UTC (rev 7347)
@@ -206,14 +206,13 @@
     emit in oracle format.
     """
     for sequence in schema.model.sequences:
-        out.write('drop sequence %s; create sequence %s;\n' % (
-            sequence.name, sequence.name))
+        out.write('create sequence %s;\n' % (sequence.name,))
     for table in schema:
         # The only table name which actually exceeds the length limit right now
         # is CALENDAR_OBJECT_ATTACHMENTS_MODE, which isn't actually _used_
         # anywhere, so we can fake it for now.
-        out.write('drop table %s; create table %s (\n' % (
-            table.model.name[:30], table.model.name[:30],))
+        shortName = table.model.name[:30]
+        out.write('create table %s (\n' % (shortName,))
         first = True
         for column in table:
             if first:
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20110421/bc2d7478/attachment-0001.html>