-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathadd_data.py
executable file
·17 lines (15 loc) · 1.06 KB
/
add_data.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
import sqlite3
conn=sqlite3.connect('database.db')
c=conn.cursor()
# c.execute('insert into client values (1234567899,"Akul Agrawal","[email protected]",7096717330,5000,"akul")')
# c.execute('insert into client values (1234567890,"Naman Kabra","[email protected]",8032145682,5000,"naman")')
# c.execute('insert into client values (1234567880,"Megh Patel","[email protected]",8578213654,5000,"megh")')
c.execute('insert into user_qr values (1,"ABC",1234567880,"available")')
c.execute('insert into user_qr values (2,"DEF",1234567880,"available")')
c.execute('insert into user_qr values (3,"GHI",1234567890,"available")')
c.execute('insert into user_qr values (4,"JKL",1234567890,"available")')
c.execute('insert into user_qr values (5,"MNO",1234567899,"available")')
c.execute('insert into user_qr values (6,"PQR",1234567899,"available")')
c.execute('insert into user_qr values (7,"XYZ",1234567899,"available")')
# c.execute('insert into sent_cheque (qr_id,sender_name,receiver_name,dated,amount) values(5,"Akul Agrawal","Naman Kabra","4/08/2019",3000)')
conn.commit()