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 96 attachment: ivoirdata2.py (656 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
# -*- 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
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)
csv_file.writerow(data)
if i==100:
print records.id_loca
exit()

Powered by Google Project Hosting