Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ValueError: cannot set a row with mismatched columns
- def run_tests(self):
- s = self.connection()
- df = self.retrieve_sql()
- df_type = df.loc[df['STEP_TYPE'] == 'T']
- df_to_list = df_type[['TABLE_NM', 'TEST_TABLE_NM', 'SQL_SCRIPT']]
- print(df_to_list)
- for sql_script in df_to_list['SQL_SCRIPT']:
- df_to_list.loc['RESULTS'] = pd.read_sql(sql_script,s)
- print(df_to_list)
- def run_tests(self):
- s = self.connection()
- df = self.retrieve_sql()
- df_type = df.loc[df['STEP_TYPE'] == 'T']
- df_to_list = df_type[['TABLE_NM', 'TEST_TABLE_NM', 'SQL_SCRIPT']]
- print(df_to_list)
- for sql_script in df_to_list['SQL_SCRIPT']:
- s.execute(sql_script)
- def connection(self):
- con = self.load_json_file()
- cfg_dsn = con['config']['dsn']
- cfg_usr = con['config']['username']
- cfg_pwd = con['config']['password']
- udaExec = teradata.UdaExec(appName="DataAnalysis", version="1.0", logConsole=False)
- session = udaExec.connect(method="odbc", dsn=cfg_dsn, username=cfg_usr, password=cfg_pwd)
- return session
Add Comment
Please, Sign In to add comment