[Myoledb-cvs] myoledb3/test test_dbapi.py,1.6,1.7

[David F. <dav...@us...>]

Update of /cvsroot/myoledb/myoledb3/test
In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv28418

Modified Files:
	test_dbapi.py 
Log Message:
moved other tests over from test_bugs


Index: test_dbapi.py
===================================================================
RCS file: /cvsroot/myoledb/myoledb3/test/test_dbapi.py,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- test_dbapi.py	28 Jun 2006 11:07:34 -0000	1.6
+++ test_dbapi.py	28 Jun 2006 11:27:59 -0000	1.7
@@ -70,6 +70,35 @@
         assert len(resultset1) == len(resultset2) == 5
         assert resultset1 == resultset2
 
+    def test_blobs(self):
+        """Blobs are handled correctly"""
+        self.execute_query("create table %s(x text, y text)" % self.tablename)
+        insertsql = "insert into %s(x, y) values('test', 'me')" % self.tablename
+        for n in range(5):
+            self.execute_query(insertsql)
+        selectsql = "select * from %s" % self.tablename
+        resultset = self.execute_query(selectsql).fetchall()
+        assert resultset != None
+        assert len(resultset) == 5
+        assert resultset[0][0] == 'test'
+
+    def test_alter_table(self):
+        """tests altering a table and adding new columns"""
+        self.execute_query("create table %s(x char(20), y char(20))" % self.tablename)
+        insertsql = "insert into %s(x, y) values('test', 'me')" % self.tablename
+        for n in range(5):
+            self.execute_query(insertsql)
+        selectsql = "select * from %s" % self.tablename
+        resultset = self.execute_query(selectsql).fetchall()
+        assert len(resultset) == 5
+        altersql = "alter table %s add z char(20)" % self.tablename
+        # TODO: work out why this is failing
+        self.execute_query(altersql)
+        insertsql = "insert into %s(x, y, z) values('test', 'me', 'please')" % self.tablename
+        self.execute_query(selectsql)
+        resultset2 = self.execute_query(selectsql).fetchall()
+        assert resultset1 != resultset2
+
 class Test_MySQLdb(MySqlTester):
     """Uses MySQLdb as the DBAPI provider (see http://mysql-python.sourceforge.net/) - doesn't use OLE DB, as reference
     If any tests fail here, we shouldn't expect them to neccessarily pass when using MyOleDb, it may be a mysql issue"""