How to use the pymonetdb.OperationalError function in pymonetdb
To help you get started, we’ve selected a few pymonetdb examples, based on popular ways it is used in public projects.
Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.
MonetDB / MonetDBLite-C / clients / examples / python / sqlsample.py View on Github 
import sys
dbh = pymonetdb.connect(port=int(sys.argv[1]),database=sys.argv[2],hostname=sys.argv[3],autocommit=True)
cursor = dbh.cursor();
cursor.execute('select 1;')
print(cursor.fetchall())
cursor = dbh.cursor();
cursor.execute('select 2;')
print(cursor.fetchone())
# deliberately executing a wrong SQL statement:
try:
cursor.execute('( xyz 1);')
except pymonetdb.OperationalError as e:
print(e)
cursor.execute('create table python_table (i smallint,s string);');
cursor.execute('insert into python_table values ( 3, \'three\');');
cursor.execute('insert into python_table values ( 7, \'seven\');');
cursor.execute('select * from python_table;');
print(cursor.fetchall())
s = ((0, 'row1'), (1, 'row2'))
x = cursor.executemany("insert into python_table VALUES (%s, %s);", s)
print(x);
cursor.execute('drop table python_table;');
