Untitled
unknown
python
3 years ago
999 B
5
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...