conn_kws['provider'] = 'Provider=MSOLEDBSQL;DataTypeCompatibility=80;MARS Connection=True;' connStr = "%(provider)s; %(security)s; Initial Catalog=%(name)s;Data Source=%(host)s" if onWindows and node != "z-PC": pass # default should make a local SQL Server connection elif node == "xxx": # try Postgres database _computername = "25.223.161.222" _databasename='adotest' _username = '******' _password = '******' _driver="PostgreSQL Unicode" _provider = '' connStr = '%sDriver={%s};Server=%s;Database=%s;uid=%s;pwd=%s;' % \ (_provider,_driver,_computername,_databasename,_username,_password) elif node == "yyy": # ACCESS data base is known to fail some tests. if is64bit.Python(): driver = "Microsoft.ACE.OLEDB.12.0" else: driver = "Microsoft.Jet.OLEDB.4.0" testmdb = setuptestframework.makemdb(testfolder) connStr = r"Provider=%s;Data Source=%s" % (driver, testmdb) else: # try a remote connection to an SQL server conn_kws['proxy_host'] = '25.44.77.176' import adodbapi.remote db = adodbapi.remote print(('Using Connection String like=%s' % connStr)) print(('Keywords=%s' % repr(conn_kws))) class test_adodbapi(dbapi20.DatabaseAPI20Test): driver = db
import adodbapi import datetime try: import adodbapi.is64bit as is64bit is64 = is64bit.Python() except ImportError: is64 = False # in case the user has an old version of adodbapi if is64: driver = "Microsoft.ACE.OLEDB.12.0" else: driver = "Microsoft.Jet.OLEDB.4.0" filename = 'xx.xls' # file will be created if it does not exist extended = 'Extended Properties="Excel 8.0;Readonly=False;"' constr = "Provider=%s;Data Source=%s;%s" % (driver, filename, extended) conn = adodbapi.connect(constr) with conn: # will auto commit if no errors with conn.cursor() as crsr: try: crsr.execute('drop table SheetOne') except: pass # just is case there is one already there # create the sheet and the header row and set the types for the columns crsr.execute( 'create table SheetOne (Name varchar, Rank varchar, SrvcNum integer, Weight float, Birth date)' ) sql = "INSERT INTO SheetOne (name, rank , srvcnum, weight, birth) values (?,?,?,?,?)"