'how do i skip empty values supplied to %s in python flask mysql connector
For example im doing a query to my database
try:
dbConn = DatabasePool.getConnection()
cursor = dbConn.cursor(dictionary=True)
sqlquery = f"update table set name=%s if(name=%s is not null),description=%s if(description=%s is not null) where jsonid=%s"
cursor.execute(
sqlquery, (JSON['name'], JSON['description'], jsonid))
dbConn.commit()
rows = cursor.rowcount
return rows
finally:
dbConn.close()
if i leave the name field blank. i will still be able to update my description likewise for my name.
how do i go about it doing it with the %s
i have also tried another way
sql = f"update table set name=if(name is null, name, %s), description = if(description is null, description, %s) where jsonID=%s"
cursor.execute(
sql, (JSON['name'], JSON['description'], jsonid))
i have to provide the 2 fields, if not it will throw me an 500 internal server error if one of the field is less.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
