Untitled

mail@pastecode.io avatarunknown
plain_text
a month ago
855 B
1
Indexable
Never
import pandas as pd

#from Axis.Code.param_config import config

def load_data_from_file(engine): #pass engine if needed

    path = config.data_path+config.data_file_name
    #df=pd.read_csv(path,encoding=config.encoding,delimiter=config.file_delimiter)
    SQL= """SELECT tenant_id, event_id, event_num, versn, event_type, event_status,
       event_start_date, event_end_date, event_prefix, event_title,
       event_desc, event_owner_id, event_owner_name, category_id, category_name,
       currency_code, region_code, supplier_id, supplier_name, award_value,
       org_id, org_name, created_date, created_by, updated_date, updated_by,
       flag
  FROM orc_train where tenant_id = 720"""
    
    df = pd.read_sql_query(SQL,con=engine)
    df.to_csv(path,sep=config.file_delimiter,encoding="utf-8",index=False)

    return df