def db_updatevisitor(v: Visitor):
cur.execute('UPDATE Visitors SET \
fname=?, lname=?, gender=?, dob=?, mobile=?, email=? \
WHERE id = ?' ,\
(v.fname, v.lname, v.gender, v.get_strdob(), v.mobile, v.email, v.id))
def db_insertvisitor(v: Visitor):
cur.execute('INSERT INTO Visitors (fname, lname, gender, dob, mobile, email) \
VALUES (?, ?, ?, ?, ?, ?)' ,\
(v.fname, v.lname, v.gender, v.get_strdob(), v.mobile, v.email))
cur.execute('SELECT last_insert_rowid()')
v.id = cur.fetchone()[0]
