[Checkins] SVN: z3c.sqlalchemy/trunk/src/z3c/sqlalchemy/tests/testSQLAlchemy.py savepoint
Andreas Jung
andreas at andreas-jung.com
Tue Aug 4 02:29:36 EDT 2009
Log message for revision 102476:
savepoint
Changed:
U z3c.sqlalchemy/trunk/src/z3c/sqlalchemy/tests/testSQLAlchemy.py
-=-
Modified: z3c.sqlalchemy/trunk/src/z3c/sqlalchemy/tests/testSQLAlchemy.py
===================================================================
--- z3c.sqlalchemy/trunk/src/z3c/sqlalchemy/tests/testSQLAlchemy.py 2009-08-04 06:17:03 UTC (rev 102475)
+++ z3c.sqlalchemy/trunk/src/z3c/sqlalchemy/tests/testSQLAlchemy.py 2009-08-04 06:29:35 UTC (rev 102476)
@@ -36,7 +36,7 @@
def setUp(self):
self.dsn = os.environ.get('TEST_DSN', 'sqlite:///test')
- wrapper = createSAWrapper(self.dsn)
+ self.db = wrapper = createSAWrapper(self.dsn)
metadata = MetaData(bind=wrapper.engine)
users = Table('users', metadata,
@@ -48,9 +48,16 @@
Column('user_id', Integer, primary_key=True),
Column('name', String(255)))
- metadata.drop_all()
+ import pdb; pdb.set_trace()
metadata.create_all()
+ def tearDown(self):
+ import pdb; pdb.set_trace()
+ self.dsn = os.environ.get('TEST_DSN', 'sqlite:///test')
+ wrapper = createSAWrapper(self.dsn)
+ metadata = MetaData(bind=wrapper.engine)
+ metadata.drop_all()
+
def testIFaceZopePostgres(self):
verifyClass(ISQLAlchemyWrapper , ZopePostgresWrapper)
@@ -72,7 +79,7 @@
session.add(User(id=2, firstname='heino', lastname='n/a'))
session.flush()
- rows = session.query(User).order_by(User.c.id).all()
+ rows = session.query(User).order_by(User.id).all()
self.assertEqual(len(rows), 2)
row1 = rows[0]
d = row1.asDict()
@@ -133,7 +140,7 @@
wrapper2 = getSAWrapper('test.wrapper1')
self.assertEqual(wrapper, wrapper2)
-
+
def testWrapperRegistrationFailing(self):
wrapper = createSAWrapper(self.dsn)
self.assertRaises(ValueError, getSAWrapper, 'test.wrapperNonExistant')
@@ -150,29 +157,7 @@
wrapper2 = getSAWrapper('test.wrapper3')
self.assertEqual(wrapper, wrapper2)
-
- def testXXMapperGetMapper(self):
- def getModel(md):
- model = Model()
- model.add('users', table=sqlalchemy.Table('users', md, autoload=True), relations=('skills',))
- model.add('skills', table=sqlalchemy.Table('skills',
- md,
- sqlalchemy.ForeignKeyConstraint(('user_id',), ('users.id',)),
- autoload=True,
- ))
- return model
-
- db = createSAWrapper(self.dsn, model=getModel)
- User = db.getMapper('users')
- session = db.session
- session.add(User(id=1,firstname='foo', lastname='bar'))
- session.flush()
- user = session.query(User).filter_by(firstname='foo')[0]
- Skill = user.getMapper('skills')
- user.skills.append(Skill(id=1, name='Zope'))
- session.flush()
-
def testCheckConnection(self):
""" Check access to low-level connection """
db = createSAWrapper(self.dsn)
@@ -184,15 +169,14 @@
def testConnectionPlusSession(self):
""" Check access to low-level connection """
- db = createSAWrapper(self.dsn)
- User = db.getMapper('users')
- session = db.session
+ User = self.db.getMapper('users')
+ session = self.db.session
session.add(User(id=1, firstname='udo', lastname='juergens'))
session.add(User(id=2, firstname='heino', lastname='n/a'))
- session.flush()
- conn = db.connection
+ conn = self.db.connection
+ import pdb; pdb.set_trace()
cursor = conn.cursor()
cursor.execute('select * from users')
rows = cursor.fetchall()
More information about the Checkins
mailing list