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]