[python-sybase] Declaring MS SQL variables as parameters: sample script

[Charles Bearden]

Here's the script that generated the traceback I gave in the previous
message:
---------------------------------------------------------------------
import sys, os
if not os.environ.get('SYBASE'):
  os.environ['SYBASE'] =3D '/usr/local/freetds'
if not os.environ.get('ODBCINI'):
  os.environ['ODBCINI'] =3D '/usr/local/etc/odbc.ini'
import Sybase
from pyPgSQL import PgSQL

s =3D 'DBServer'
u =3D 'DOMAIN\jrandomuser'
p =3D 'securepwd'
d =3D 'DBName'

c_pg =3D PgSQL.connect(database=3Dd)
cu_pg =3D c_pg.cursor()
c_sy =3D Sybase.connect(s, u, p, d)
cu_sy =3D c_sy.cursor()

cu_pg.execute('select pmid, xmldata from pmxml limit 10')
while True:
  r =3D cu_pg.fetchone()
  if not r: break
  dct =3D { '@pmid' : r[0] , '@xmldata' : r[1] }
  cu_sy.execute('delete from fooflap')
  s =3D '''
    INSERT INTO testTable
    (PMID, XmlData)
    VALUES
    (@pmid, @xmldata)
  '''
  cu_sy.execute('declare @pmid nvarchar(10), @xmldata ntext')
  cu_sy.execute(s, dct)


c_pg.close()
c_sy.close()
---------------------------------------------------------------------

Thanks,
Chuck