[Checkins]
SVN: Products.SQLAlchemyDA/trunk/Products/SQLAlchemyDA/tests/testSQLAlchemyDA.py
added
Andreas Jung
andreas at andreas-jung.com
Tue Mar 18 16:50:52 EDT 2008
Log message for revision 84762:
added
Changed:
A Products.SQLAlchemyDA/trunk/Products/SQLAlchemyDA/tests/testSQLAlchemyDA.py
-=-
Added: Products.SQLAlchemyDA/trunk/Products/SQLAlchemyDA/tests/testSQLAlchemyDA.py
===================================================================
--- Products.SQLAlchemyDA/trunk/Products/SQLAlchemyDA/tests/testSQLAlchemyDA.py (rev 0)
+++ Products.SQLAlchemyDA/trunk/Products/SQLAlchemyDA/tests/testSQLAlchemyDA.py 2008-03-18 20:50:51 UTC (rev 84762)
@@ -0,0 +1,75 @@
+###########################################################################
+# SQLAlchemyDA tests
+###########################################################################
+
+"""
+Tests for SQLAlchemyDA
+"""
+
+
+import sys, os, unittest
+from Testing import ZopeTestCase
+ZopeTestCase.installProduct('SQLAlchemyDA', 1)
+
+from Products.SQLAlchemyDA.da import SAWrapper
+from z3c.sqlalchemy import createSAWrapper
+from sqlalchemy import MetaData, Table, Column, Integer, String, Unicode
+from sqlalchemy.orm import mapper
+
+
+class SQLAlchemyDATests(ZopeTestCase.ZopeTestCase):
+
+ def afterSetUp(self):
+
+ self.dsn = os.environ.get('TEST_DSN', 'sqlite:///test')
+ wrapper = createSAWrapper(self.dsn, name='foo')
+ metadata = MetaData(bind=wrapper.engine)
+
+ test_table = Table('test', metadata,
+ Column('id', Integer, primary_key=True),
+ Column('utext', Unicode(255)),
+ Column('text', String(255)))
+
+ class Test(object): pass
+ mapper(Test, test_table)
+
+ metadata.create_all()
+ session = wrapper.session
+ session.save(Test(id=1, utext=u'Hello world', text='hello world'))
+ session.save(Test(id=2, utext=u'foo', text='far'))
+
+
+ def makeOne(self, **kw):
+ factory = self.app.manage_addProduct['SQLAlchemyDA']
+ factory.manage_addSAWrapper(id='da', title='da',
+ dsn=self.dsn,
+ **kw)
+ return self.app['da']
+
+ def test1(self):
+ da = self.makeOne()
+
+
+
+def test_suite():
+ s = unittest.TestSuite()
+ s.addTest(unittest.makeSuite(SQLAlchemyDATests))
+ return s
+
+def main():
+ unittest.TextTestRunner().run(test_suite())
+
+def debug():
+ test_suite().debug()
+
+def pdebug():
+ import pdb
+ pdb.run('debug()')
+
+if __name__=='__main__':
+ if len(sys.argv) > 1:
+ globals()[sys.argv[1]]()
+ else:
+ main()
+
+
More information about the Checkins
mailing list