1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
| import dbi, odbc, psycopg2
#connection a acucobol
conn = odbc.odbc('local_HER//')
c = conn.cursor()
#Connection a postgresql
connpg = psycopg2.connect("host=192.168.200.3 dbname=InfocentreV6 user=postgres")
curspg1=connpg.cursor()
#Select sur acucobol
c.execute('''SELECT CLIAV_NCLI, CLIAV_NABR, CLIAV_DESI, CLIAV_FAMI, CLIAV_SFAM,
CLIAV_REPR,'direct' FROM cliav where CLIAV_NCLI<> 4100000''')
client=c.fetchall()
for i in client:
print i
curspg1.execute('''Insert into clients
values (%s, %s, %s, %s, %s, %s, %s)''',i) |
