Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv26989/src/test/BugTracker/Tests
Added Files:
Tag: SQL_2-22
python_escape.SF-1916844.SQL.py
python_escape.SF-1916844.stable.err
python_escape.SF-1916844.stable.out
Log Message:
Test for bug [ 1916844 ] Bug in Python interface converters.py.
--- NEW FILE: python_escape.SF-1916844.SQL.py ---
import MonetSQLdb
import os
dbh = MonetSQLdb.Connection(dbname = os.environ['TSTDB'],
port = int(os.environ['MAPIPORT']))
cursor = dbh.cursor()
try:
cursor.execute('create table python_table (i smallint,s string)')
s = (0, 'row1')
try:
x = cursor.execute("insert into python_table VALUES (%s, %s)", s)
except:
print 'execute failed with tuple'
else:
print x
s = [1, 'row2']
try:
x = cursor.execute("insert into python_table VALUES (%s, %s)", s)
except:
print 'execute failed with list'
else:
print x
s = ((2, 'row3'), (3, 'row4'))
try:
x = cursor.executemany("insert into python_table VALUES (%s, %s)", s)
except:
print 'executemany failed with tuple in tuple'
else:
print x
s = [(4, 'row5'), (5, 'row6')]
try:
x = cursor.executemany("insert into python_table VALUES (%s, %s)", s)
except:
print 'executemany failed with tuple in list'
else:
print x
s = ([6, 'row7'], [7, 'row8'])
try:
x = cursor.executemany("insert into python_table VALUES (%s, %s)", s)
except:
print 'executemany failed with list in tuple'
else:
print x
s = [[8, 'row9'], [9, 'row10']]
try:
x = cursor.executemany("insert into python_table VALUES (%s, %s)", s)
except:
print 'executemany failed with list in list'
else:
print x
finally:
cursor.execute('drop table python_table')
--- NEW FILE: python_escape.SF-1916844.stable.err ---
stderr of test 'python_escape.SF-1916844` in directory 'src/test/BugTracker`
itself:
# 16:09:54 >
# 16:09:54 > mserver5
"--config=/ufs/sjoerd/Monet-virgin-stable/etc/monetdb5.conf" --debug=10 --set
"monet_mod_path=/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/src/backends/monet5/.libs:/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/src/backends/monet5:/ufs/sjoerd/Monet-virgin-stable/lib64/MonetDB5:/ufs/sjoerd/Monet-virgin-stable/lib64/MonetDB5/lib:/ufs/sjoerd/Monet-virgin-stable/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/dbfarm"
--set
"sql_logdir=/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/sql_logs"
--set
"xquery_logdir=/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=38861 --set
xrpc_port=40973 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
# 16:09:54 >
#warning: please don't forget to set your vault key!
#(see /ufs/sjoerd/Monet-virgin-stable/etc/monetdb5.conf)
# 16:09:54 >
# 16:09:54 > /usr/bin/python python_escape.SF-1916844.SQL.py
python_escape.SF-1916844
# 16:09:54 >
# 16:09:54 >
# 16:09:54 > Done.
# 16:09:54 >
--- NEW FILE: python_escape.SF-1916844.stable.out ---
stdout of test 'python_escape.SF-1916844` in directory 'src/test/BugTracker`
itself:
# 16:09:54 >
# 16:09:54 > mserver5
"--config=/ufs/sjoerd/Monet-virgin-stable/etc/monetdb5.conf" --debug=10 --set
"monet_mod_path=/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/src/backends/monet5/.libs:/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/src/backends/monet5:/ufs/sjoerd/Monet-virgin-stable/lib64/MonetDB5:/ufs/sjoerd/Monet-virgin-stable/lib64/MonetDB5/lib:/ufs/sjoerd/Monet-virgin-stable/lib64/MonetDB5/bin"
--set
"gdk_dbfarm=/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/dbfarm"
--set
"sql_logdir=/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/sql_logs"
--set
"xquery_logdir=/ufs/sjoerd/src/MonetDB/virgin-stable/sql/x86_64-unknown-linux-gnu/xquery_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=38861 --set
xrpc_port=40973 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
# 16:09:54 >
# MonetDB server v5.4.1, based on kernel v1.22.1
# Serving database 'mTests_src_test_BugTracker'
# Compiled for x86_64-unknown-linux-gnu/64bit with 32bit OIDs dynamically linked
# Copyright (c) 1993-2008 CWI, all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://hirundo.ins.cwi.nl:38861/
# MonetDB/SQL module v2.22.1 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 16:09:54 >
# 16:09:54 > /usr/bin/python python_escape.SF-1916844.SQL.py
python_escape.SF-1916844
# 16:09:54 >
1
1
2
2
2
2
# 16:09:54 >
# 16:09:54 > Done.
# 16:09:54 >
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
