vcs/_4.python/_db/PythonSQL-master/sqlite-ctrl.py at master · bunshue/vcs · GitHub

History

55 lines (46 loc) · 1.13 KB

Raw

import sqlite3

conn = sqlite3.connect('DevDb.db')

cursor = conn.cursor()

appDesc = """

Please input action code :

1 - Insert Data

2 - Update Data

3 - Delete Date

--- --- ---

0 - exit

"""

isRun = True

while isRun:

cursor.execute('SELECT * FROM `app_info`;')

records = cursor.fetchall()

for r in records:

print(r)

ctrl = input(appDesc)

if ctrl == "0":

isRun = False

elif ctrl == "1":

sql = """

INSERT INTO app_info (name, version, author, date, remark)

VALUES ('App', 'v1.0.1', 'DevAuth', '2021-11-20', 'App-v1.0.1');

"""

cursor.execute(sql)

conn.commit()

elif ctrl == "2":

row_id = input("row_id = ? ")

sql = """

update app_info

set name = 'AppNew' , version='1.0.2' , remark = 'App-v1.0.2'

WHERE id={};

""".format(row_id)

cursor.execute(sql)

conn.commit()

elif ctrl == "3":

row_id = input("row_id = ? ")

sql = """

delete from app_info

where id={};

""".format(row_id)

cursor.execute(sql)

conn.commit()

cursor.close()

conn.close()

vcs/_4.python/_db/PythonSQL-master/sqlite-ctrl.py at master · bunshue/vcs · GitHub

Expand file tree

Breadcrumbs

sqlite-ctrl.py

Latest commit

History

Breadcrumbs

sqlite-ctrl.py

File metadata and controls