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
| import gadfly
baseDonn = gadfly.gadfly()
baseDonn.startup("mydata","C:/")
cur = baseDonn.cursor()
cur.execute("create table membres (age integer, nom varchar, taille float)")
cur.execute("insert into membres(age, nom, taille) values (21,'Dupont',1.83)")
cur.execute("INSERT INTO MEMBRES(AGE, NOM, TAILLE) VALUES (15,'Suleau',1.57)")
cur.execute("Insert Into Membres(Age, Nom, Taille) Values (18,'Forcas',1.69)")
baseDonn.commit()
baseDonn.close()
baseDonn = gadfly.gadfly("mydata","C:/")
cur = baseDonn.cursor()
cur.execute("select * from membres")
a = cur.pp()
"""print a
for x in cur.fetchall():
print x, x[0], x[1], x[2]"""
baseDonn.close()
f = open("c:/Fichiertexte.txt", "w")
f.write(a)
f.close() |
Partager