[Myoledb-cvs] myoledb3/test test_bugs.py,1.4,1.5

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

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