Untitled
unknown
python
4 years ago
999 B
6
Indexable
def run_delete_bulk(download_f_name, filename):
if "BulkDelete.xlsx" in filename:
print(fname + " " + lname)
def update_timestamp_end(data_id):
with db.cursor() as cur1:
cur1.execute(
"SELECT distinct table_name "
+ "FROM information_schema.tables "
+ "where tablename like '%FPFA%' "
+ "and table_name not like '%LU%' "
+ "and table_name not like '%.%' "
+ "order by table_name"
)
for tablename in cur1:
print(tablename[0])
with db.cursor() as cur:
# update the database with timestamp_ends as bulk delete.
querytables = (
"update "
+ tablename[0]
+ " set TimeStamp_End = "
+ "'"
+ getdatevalue
+ "'"
+ " where Data_Source_ID = "
+ data_id
)Editor is loading...