Code: Alles auswählen
def update_database(mydb, timestamp, card_id):
with closing(mydb.cursor()) as cursor:
cursor.execute("SELECT * FROM db where db04 = %s", [card_id])
# TODO: explicitly name the fields to query
result = cursor.fetchone()
if result is not None:
# TODO: find readable names for the fields and table.
# TODO: Remove result, due to normalization
cursor.execute("INSERT INTO iss (vsb01, vsb02, vsb03, vsb04, vsb05, vsb06, vsb07, vsb08, vsb09, vsb10, vsb11, vsb12) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",[
result[1], result[2], result[3], result[4],
timestamp.strftime('%Y-%m-%d'), # TODO: use timestamp only
"Training",
card_id,
"Weisweil",
timestamp.strftime('%Y'), # TODO: remove extra year field
timestamp.strftime('%H:%M:%S'), # TODO: remove extra time field"
"",
"",
])
mydb.commit()
print(card_id)
return "iss-Eintrag"
else:
cursor.execute("SELECT cd01 FROM cd where cd01 = %s", [card_id])
result = cursor.fetchone()
if result is not None:
print("Karte ist schon vorhanden.")
return "schon da"
else:
# TODO: find readable names for the fields and table.
cursor.execute("INSERT INTO cd (cd01, cd02, cd03) VALUES (%s, %s, %s)", [
card_id, "f", "n",
])
mydb.commit()
print(f"{card_id} wurde eingetragen")
return "cd-Eintrag"