Advertisement
Guest User

Untitled

a guest
Mar 20th, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. def check_column_existence(dbHost, dbPort, dbName, dbUser, dbPassword, table_name, column_name):
  2. sqlQuery="""select count(*) from
  3. INFORMATION_SCHEMA.columns
  4. where table_name='{}' and column_name='{}';""".format(table_name, column_name)
  5. conn = pymssql.connect(host=dbHost, port=dbPort, user=dbUser, password=dbPassword, database=dbName)
  6. cursor = conn.cursor()
  7. sql = sqlQuery.encode('utf-8')
  8. cursor.execute(sql)
  9. for row in cursor:
  10. if row[0] == 1:
  11. result = True
  12. else:
  13. result = False
  14. print(result)
  15. return result
  16.  
  17. def populate_db_attribute_existence(input_csv_file_path):
  18. input_csv_file_path = os.path.abspath(input_csv_file_path)
  19. df = pd.read_csv(input_csv_file_path)
  20. df['DB_Entity'] = df['DB_Entity'].str.replace(' ', '')
  21. df['DB_Attributes'] = df['DB_Attributes'].str.replace(' ', '')
  22. print(df[['DB_Entity', 'DB_Attributes']])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement