Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- user_id = '3'
- departure = 'Пенза'
- landing = 'Питер'
- data = '25.07.2018'
- def verification_id():
- with sqlite3.connect("mydatabase_users.db") as con:
- cur = con.cursor()
- cur.execute("SELECT user_id FROM id_departure_landing_data")
- return [x[0] for x in cur.fetchall()]
- def update_bd():
- connection = sqlite3.connect("mydatabase_users.db")
- cursor = connection.cursor()
- if user_id in verification_id():
- cursor.execute("UPDATE id_departure_landing_data SET departure='Пенза' WHERE departure='Киров'")
- connection.commit()
- connection.close()
- else:
- cursor.execute("INSERT INTO id_departure_landing_data VALUES(?,?,?,?)",
- (user_id, departure, None, None))
- connection.commit()
- connection.close()
- update_bd()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement