My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions

Issue 41 attachment: ivoirdata2.py (668 bytes)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
# -*- coding: utf-8 -*-

import pyodbc
import csv
conn=pyodbc.connect('DSN=lintry')
sql="SELECT id_nomenclator,id_loca,collecteur,n_coll,bdcsrs,rejj,recmm,reaaaa FROM cvc414"
cursor=conn.cursor()
cursor.execute(sql)
rows=cursor.fetchall()
i=0
csv_file = csv.writer(open('file.csv', 'w'), delimiter=',')

for records in rows:
data=[]
i=i+1
print records.reaaaa
data.append(records.bdcsrs)
data.append(records.id_nomenclator)
data.append(records.collecteur)
data.append(records.n_coll)
data.append(records.id_loca)
data.append(records.rejj)
data.append(records.recmm)
data.append(records.reaaaa)
if i==100:
print data
exit()
csv_file.writerow(data)


Powered by Google Project Hosting