Update of /cvsroot/myoledb/myoledb3/test
In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv8808
Modified Files:
test_bugs.py
Log Message:
added test for altering tables which currently fails through MyOLEDB
note that QTADO just stays open on the failing statements...
Index: test_bugs.py
===================================================================
RCS file: /cvsroot/myoledb/myoledb3/test/test_bugs.py,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- test_bugs.py 17 Jan 2006 12:00:46 -0000 1.4
+++ test_bugs.py 21 Jun 2006 09:55:24 -0000 1.5
@@ -73,6 +73,25 @@
assert resultlength == 5
assert resultset[:4] == 'test'
+ def test_alter_table(self):
+ """tests altering a table and adding new columns"""
+ tablename = "test_alter_table"
+ createsql = "create table %s(x char(20), y char(20));" % tablename
+ self.teardownsql = "drop table %s;" % tablename
+ self.runsql(createsql)
+ insertsql = "insert into %s(x, y) values('test', 'me');" % tablename
+ self.runsql(insertsql)
+ selectsql = "select * from %s;" % tablename
+ resultset = self.runsql(selectsql)
+ assert resultset.count("\n") == 1
+ print resultset
+ altersql = "alter table %s add z char(20)" % tablename
+ self.runsql(altersql)
+ insertsql = "insert into %s(x, y, z) values('test', 'me', 'please');" % tablename
+ resultset2 = self.runsql(selectsql)
+ print resultset2
+ assert resultset2 != resultset
+
class TestQTADO(BaseTestMySQL):
"""tests running queries through qtado"""
qtadopath = "c:\\Tools\\QTADO40\\"
|
