Changeset 946 for trunk/packages/sipb-xen-database/python/database

Timestamp:

Sep 29, 2008, 2:21:34 AM (16 years ago)

Author:

price

Message:

port sipb-xen-database to sqlalchemy-0.4

Apparently they like breaking old interfaces (e.g. DynamicMetaData?,
sqlalchemy.create_session, sqlalchemy.relation) when they add new ones.
Also letting other old interfaces (e.g. meta.connect) bitrot even
while still present.

Location:

trunk/packages/sipb-xen-database/python/database

Files:

• __init__.py (modified) (1 diff)
• models.py (modified) (2 diffs)

trunk/packages/sipb-xen-database/python/database/__init__.py

@@ -1 +1 @@
 from invirt.config import structs as config
 from models import *
+import sqlalchemy
 
 def connect(uri = config.db.uri):
     """ Connect to a given database URI"""
-    meta.connect(uri)
+    meta.bind = sqlalchemy.create_engine(uri)

trunk/packages/sipb-xen-database/python/database/models.py

@@ -1 +1 @@
 from sqlalchemy import *
+from sqlalchemy.orm import create_session, relation
 
 from sqlalchemy.ext.sessioncontext import SessionContext
@@ -24 +25 @@
            ]
 
-meta = DynamicMetaData()
+meta = ThreadLocalMetaData()
 ctx = SessionContext(create_session)