| 123456789101112131415161718192021222324252627 |
- import sys
- import pyodbc
- from datetime import datetime, timedelta
- def main(server, user, password):
- dsn = f"dsn={server};uid={user};pwd={password}"
- query = "SELECT value_numeric FROM public.configuration WHERE type IN ('created_end')"
- try:
- conn = pyodbc.connect(dsn)
- cursor = conn.cursor()
- cursor.execute(query)
- row = cursor.fetchone()
- if row[0] > 0:
- dt = datetime.fromtimestamp(row[0])
- print("Zeit seit letzter Aktualisierung: ", end="")
- print(str(datetime.now() - dt)[:-10] + " Std")
- sys.exit(0)
- except pyodbc.InterfaceError as e:
- print(e.args[1])
- print("Datenbank unvollständig! Import-Prozess abgebrochen")
- sys.exit(1)
- if __name__ == '__main__':
- main("Locosoft", "loco_auswertung_benutzer", "loco")
|
