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"""
|
