dbGenerator.py

import sqlite3

conn = sqlite3.connect("database.db")
curs = conn.cursor()

curs.execute("CREATE TABLE users(id INTEGER PRIMARY KEY, login TEXT, password TEXT, nom TEXT,prenom TEXT, type INTEGER, spes INTEGER, prix INTEGER, max Integer)")
curs.execute("CREATE TABLE appoitnments(id INTEGER PRIMARY KEY, id_med INTEGER, id_pat INTEGER, date_app DATE, state INTEGER, motif TEXT)")
res = curs.execute("INSERT INTO users values (1,'m','password', 'Amine', 'Alami',0,0,300, 10)")
res = curs.execute("INSERT INTO users values (2,'m1','password', 'Yousef', 'Alami',0,1,310, 10)")
res = curs.execute("INSERT INTO users values (3,'m2','password', 'Ibrahim', 'Alami',0,2,330, 10)")
res = curs.execute("INSERT INTO users values (4,'p','password', 'Ilias', 'Amani',1,NULL,NULL,NULL)")