Friendsnippets

 1 # -*- coding:Utf-8 -*-
 2 
 3 import sqlite3
 4 import os
 5 
 6 def main():
 7 	if not os.path.isfile("juzam51.db"):
 8 		conn = sqlite3.connect("juzam51.db")
 9 		c = conn.cursor()
10 		"""
11 		c.execute("create table employe (numero integer, nom text, prenom text)")
12 		for t in ((1, "Dupond", "La joie"), (2, "DERE", "Armel"), (3, "Duval", "Leroy")):
13 			c.execute("insert into employe (numero, nom, prenom) values (?, ?, ?)", t)
14 			conn.commit()
15 		"""
16 	else:
17 		conn = sqlite3.connect("base.db")
18 		c = conn.cursor()
19 		c.execute("select * from employe")
20 		print c.fetchall()
21 		
22 if __name__ == "__main__":
23 	main()