Tag: oo_pqsdbc_01 User: jbu Date: 2007-08-28 20:41:27+0000 Modified: dba/connectivity/workben/postgresql/preparedstatement.py
Log: #i80904# quoted quotes are tested + #i52352# stmt.getMetaData() is tested, which was the cause for the native sql does not work bug File Changes: Directory: /dba/connectivity/workben/postgresql/ ================================================ File [changed]: preparedstatement.py Url: http://dba.openoffice.org/source/browse/dba/connectivity/workben/postgresql/preparedstatement.py?r1=1.1.2.7&r2=1.1.2.8 Delta lines: +17 -3 -------------------- --- preparedstatement.py 2006-05-27 11:33:11+0000 1.1.2.7 +++ preparedstatement.py 2007-08-28 20:41:25+0000 1.1.2.8 @@ -2,9 +2,9 @@ # # $RCSfile: preparedstatement.py,v $ # -# $Revision: 1.1.2.7 $ +# $Revision: 1.1.2.8 $ # -# last change: $Author: jbu $ $Date: 2006/05/27 11:33:11 $ +# last change: $Author: jbu $ $Date: 2007/08/28 20:41:25 $ # # The Contents of this file are made available subject to the terms of # either of the following licenses @@ -69,6 +69,7 @@ suite.addTest(TestCase("testQuery",ctx,dburl)) suite.addTest(TestCase("testGeneratedResultSet",ctx,dburl)) suite.addTest(TestCase("testUpdateableResultSet",ctx,dburl)) + suite.addTest(TestCase("testQuoteQuote",ctx,dburl)) return suite def realEquals( a,b,eps ): @@ -106,6 +107,8 @@ rs = prepstmt.executeQuery( ) self.failUnless( rs.getMetaData().getColumnCount() == 1 ) self.failUnless( rs.getMetaData().getColumnName(1) == "id") + self.failUnless( prepstmt.getMetaData().getColumnCount() == 1 ) + self.failUnless( prepstmt.getMetaData().getColumnName(1) == "id" ) self.failUnless( rs.next() ) self.failUnless( rs.getString( 1 ).strip() == "PZZ2" ) self.failUnless( rs.next() ) @@ -168,7 +171,6 @@ self.failUnless( rs.getString(2) == "Norah Jones" ) self.failUnless( rs.getString(1) == "1" ) - def testUpdateableResultSet( self ): stmt = self.connection.createStatement() stmt.ResultSetConcurrency = UPDATABLE @@ -191,5 +193,17 @@ rs = stmt.executeQuery( "SELECT * FROM \"public\".\"orderpos\"" ) # ddl.dumpResultSet( rs ) + def testQuoteQuote( self ): + stmt = self.connection.prepareStatement( "select 'foo''l'" ) + rs = stmt.executeQuery() + self.failUnless( rs ) + self.failUnless( rs.next() ) + self.failUnless( rs.getString(1) == "foo'l" ) + + stmt = self.connection.prepareStatement( "select 'foo''''l'" ) + rs = stmt.executeQuery() + self.failUnless( rs ) + self.failUnless( rs.next() ) + self.failUnless( rs.getString(1) == "foo''l" ) --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
