28 lines
715 B
Python
28 lines
715 B
Python
from i7lib.dbutils import Database
|
|
from i7lib.timeutils import to_datetime
|
|
|
|
|
|
def main():
|
|
db = Database()
|
|
rows = db.query(
|
|
"oven_bar",
|
|
filters=[
|
|
{"column": "exited_time", "op": "eq", "value": 0},
|
|
{"column": "deleted", "op": "eq", "value": 0},
|
|
],
|
|
)
|
|
if not rows:
|
|
print("no orphan bars to close")
|
|
return
|
|
|
|
for row in rows:
|
|
db.update("oven_bar", row["id"], {"exited_time": row["entered_time"]})
|
|
dt = to_datetime(row["entered_time"]).strftime("%Y-%m-%d %H:%M:%S")
|
|
print(f"closed orphan bar id={row['id']}, entered_time={dt}")
|
|
|
|
print(f"closed {len(rows)} orphan bar(s)")
|
|
|
|
|
|
if __name__ == "__main__":
|
|
main()
|