[Checkins] SVN: z3c.sqlalchemy/branches/reusing-zalchemy/src/z3c/sqlalchemy/tests/testSQLAlchemy.py added test for passing down the engine_options

[Andreas Jung]

Log message for revision 84705:
  added test for passing down the engine_options
  

Changed:
  U   z3c.sqlalchemy/branches/reusing-zalchemy/src/z3c/sqlalchemy/tests/testSQLAlchemy.py

-=-
Modified: z3c.sqlalchemy/branches/reusing-zalchemy/src/z3c/sqlalchemy/tests/testSQLAlchemy.py
===================================================================
--- z3c.sqlalchemy/branches/reusing-zalchemy/src/z3c/sqlalchemy/tests/testSQLAlchemy.py	2008-03-16 12:16:30 UTC (rev 84704)
+++ z3c.sqlalchemy/branches/reusing-zalchemy/src/z3c/sqlalchemy/tests/testSQLAlchemy.py	2008-03-16 13:41:29 UTC (rev 84705)
@@ -17,7 +17,7 @@
 import unittest
 import sqlalchemy
 
-from sqlalchemy import MetaData, Integer, String, Column, Table
+from sqlalchemy import MetaData, Integer, String, Column, Table, Unicode
 
 from zope.interface.verify import verifyClass
 
@@ -191,7 +191,25 @@
         self.assertEqual(hasattr(conn, 'cursor'), True)
         self.assertEqual(hasattr(conn, 'execute'), True)
 
+    def testEngineOptions(self):
 
+        self.dsn = os.environ.get('TEST_DSN', 'sqlite:///test')
+        wrapper = createSAWrapper(self.dsn, engine_options={'convert_unicode' : True, 
+                                                            'assert_unicode' : True})
+        metadata = MetaData(bind=wrapper.engine)
+        users = Table('test', metadata,
+                      Column('id', Integer, primary_key=True),
+                      Column('text', Unicode))
+        metadata.create_all()      
+        self.assertEqual(wrapper.engine.dialect.convert_unicode, True)
+        Test = wrapper.getMapper('test')
+        session = wrapper.session
+        new_test = Test(id=1, text=u'foo')
+        session.save(new_test)
+        row = session.query(Test).one()
+        assert isinstance(row.text, unicode)
+
+
 def test_suite():
     from unittest import TestSuite, makeSuite
     suite = TestSuite()