MD500_Pilot

Untitled

May 21st, 2020
178
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.80 KB | None | 0 0
  1. def read_mysql_database(table, column):
  2.     log.debug( f'read_mysql_database() called with ({table}, {column})')
  3.     try:
  4.         connection = mysql.connector.connect(user=system_info.mysql_username,
  5.                                       password=system_info.mysql_password,
  6.                                       host=system_info.mysql_servername,
  7.                                       database=system_info.mysql_database)
  8.         cursor = connection.cursor(buffered=True)
  9.         cursor.execute(("SELECT %s FROM %s") % (column, table))
  10.         for data in cursor:
  11.             database_value = (data[0])
  12.             return database_value
  13.         cursor.close()
  14.         connection.close()
  15.     except Error as error :
  16.         log.warning("Failed to read record from database: {}".format(error))
  17.         exit()
Add Comment
Please, Sign In to add comment