def update_booking_status():
"""
this method is used to update booking status for old rides.
:return:
"""
mydb = sql_connection()
c = mydb.cursor()
c.execute(
"SELECT * from bookings JOIN routes ON bookings.route_id=routes.id WHERE status=2;"
)
result = c.fetchall()
# print(result)
if len(result) > 0:
for row in result:
print('row[0]', row[0])
print('row[5]', row[5])
print('row[2]', row[2])
print('row[11]', row[11])
t = datetime.now().strftime("%H:%M:%S")
t = datetime.strptime(t, '%H:%M:%S').time()
current_time = timedelta(hours=t.hour,
minutes=t.minute,
seconds=t.second)
print(row[11] + timedelta(minutes=30))
if current_time > row[11] + timedelta(minutes=30):
c.execute("UPDATE bookings SET status=1 WHERE id={}".format(
row[0]))
c.execute(
"UPDATE routes SET seats_available=seats_available+{} WHERE id={}"
.format(row[5], row[2]))
mydb.commit()
print("\nRide complete.")
mydb.close()
def test_sql_connection_success(self, mocksql):
""" Test sql connection method."""
mocksql.connect().return_value = object
assert run.sql_connection().return_value == object
def test_sql_connection_failure(self, mocksql):
""" Test sql connection method."""
mocksql.connect().return_value = None
assert run.sql_connection().return_value is None