Untitled

mail@pastecode.io avatar
unknown
python
2 years ago
999 B
2
Indexable
Never
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
                )