Skip to content
Snippets Groups Projects

WIP adding get_generator

Merged Ismail Moumni requested to merge 003-db-generator into master
All threads resolved!
1 file
+ 4
3
Compare changes
  • Side-by-side
  • Inline
@@ -49,9 +49,9 @@ def update_database(url:str, job_id: str, before:str, after:str):
@@ -49,9 +49,9 @@ def update_database(url:str, job_id: str, before:str, after:str):
update = update.replace('{{url}}', url)
update = update.replace('{{url}}', url)
update = update.replace('{{job_id}}', job_id)
update = update.replace('{{job_id}}', job_id)
print(update)
print(update)
AM
Bonjour monsieur @Pierre Boudes , s il vous plait est ce qu'il n y'a pas de nouvelles par rapport à nos résultats? et si vous pouvez nous donner une idée sur les attestations de réussite quand est ce qu'on pourra les avoir? ( les gens qui ont déjà passé leurs soutenances) it()
mycursor.execute(update)
 
database.commit()
print(mycursor.rowcount, "record(s) affected")
print(mycursor.rowcount, "record(s) affected")
return mycursor.rowcount
return mycursor.rowcount
@@ -125,9 +125,10 @@ def db_insert(query: dict):
@@ -125,9 +125,10 @@ def db_insert(query: dict):
values = query.values()
values = query.values()
cols = query.keys()
cols = query.keys()
sql_new_job_row = "INSERT INTO jobs (%s) VALUES ('%s');" % (", ".join(cols), "','".join(values))
sql_new_job_row = "INSERT INTO jobs (%s) VALUES ('%s');" % (", ".join(cols), "','".join(values))
 
print(sql_new_job_row)
mycursor = database.cursor(buffered=True)
mycursor = database.cursor(buffered=True)
mycursor.execute(sql_new_job_row)
mycursor.execute(sql_new_job_row)
print("Records inserted in DB :", query.values())
print("Record inserteds in DB :", query.values)
database.commit()
database.commit()
mycursor.close()
mycursor.close()
except mysql.connector.Error as err:
except mysql.connector.Error as err:
Loading