Guest User

Untitled

a guest
Feb 8th, 2019
178
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. ValueError: cannot set a row with mismatched columns
  2.  
  3. def run_tests(self):
  4. s = self.connection()
  5. df = self.retrieve_sql()
  6. df_type = df.loc[df['STEP_TYPE'] == 'T']
  7. df_to_list = df_type[['TABLE_NM', 'TEST_TABLE_NM', 'SQL_SCRIPT']]
  8. print(df_to_list)
  9. for sql_script in df_to_list['SQL_SCRIPT']:
  10. df_to_list.loc['RESULTS'] = pd.read_sql(sql_script,s)
  11. print(df_to_list)
  12.  
  13. def run_tests(self):
  14. s = self.connection()
  15. df = self.retrieve_sql()
  16. df_type = df.loc[df['STEP_TYPE'] == 'T']
  17. df_to_list = df_type[['TABLE_NM', 'TEST_TABLE_NM', 'SQL_SCRIPT']]
  18. print(df_to_list)
  19. for sql_script in df_to_list['SQL_SCRIPT']:
  20. s.execute(sql_script)
  21.  
  22. def connection(self):
  23. con = self.load_json_file()
  24. cfg_dsn = con['config']['dsn']
  25. cfg_usr = con['config']['username']
  26. cfg_pwd = con['config']['password']
  27.  
  28. udaExec = teradata.UdaExec(appName="DataAnalysis", version="1.0", logConsole=False)
  29. session = udaExec.connect(method="odbc", dsn=cfg_dsn, username=cfg_usr, password=cfg_pwd)
  30.  
  31. return session
Add Comment
Please, Sign In to add comment