Product Documentation

FairCom SQL for Python

Previous Topic

Next Topic

Usage Example

import pyctree

conn = pyctree.connect( host='localhost', port='6597', user='admin', password='ADMIN', database='ctreeSQL' )

conn._set_autocommit(True)

curs = conn.cursor()

curs.execute( "SELECT * FROM admin.syscolumns" )

results = curs.fetchall()

for r in results:

print r[1]

curs.close()

conn.close()

TOCIndex