import csv;

def read():
	with open('Table - Clients.txt') as file:
		table = csv.reader(file, delimiter=';', quotechar='"')
		for line in csv.reader(file, delimiter=';', quotechar='"'):
			yield line
def toSql(records):
	for row in records:
		sql = "insert into client('ID','prenom','nom','nomDuGroupe','adresse','ville','province','codePostal','telephoneMaison','telephoneTravail','commentaire') values('"
		sql+= row[0].replace("'","\'")
		for i in (1,2,3,4,5,6,7,8,9,12):
			sql+="','"+row[i].replace("'","\'")
		sql+= "')\n"
		yield sql

def save(sql):
	with open('client.sql','w') as file:
		for line in sql:
			file.write(line)

table = read();
sql = toSql(table)
save(sql)