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")