Sep-28-2022, 02:04 AM
Hi Team,
thanks for the information modified after suggestion,
how to put below code into class module.
thanks for the information modified after suggestion,
how to put below code into class module.
import gzip import hashlib import sqlite3 import sys from module4 import insert_Records from module1 import Create_csv from module2 import chksum from module3 import function_gzip def main(SQL_Table, Destination_path, site_Name, date) csvname = Create_csv(tblname, SQL_Table, Destination_path) x = Create_checksum(tblname, Destination_path) y = function_gzip((tblname, Destination_path) sql = f"insert into summary_table([database], tblname, Destination_path, date, chksumNo, Gzip_status) values ('{database}','{tblname}','{Destination_path'},'{date}','{x}','{y}')" if __name__ == "__main__": SQL_Table = sys.argv(1) Destination_path = sys.argv(2) site_Name = sys.argv(3) date = sys.argv(4)