def setupDatabase(self): try: config = configparser.ConfigParser() config.readfp(open('connectionmanager.ini')) host = config.get('database', 'host') database = config.get('database', 'database') user = config.get('database', 'user') password = config.get('database', 'password') self.databasePrefix = config.get('database', 'database_prefix') except Exception as e: self.logger.error("Could not fetch connectionmanager.ini: %s", e) return False self.conDatabase = mysql.Database(host, database, user, password, self.logger) if self.conDatabase.connect(): try: self.conDatabase.createTable(self.databasePrefix+"connections", ['start VARCHAR(100)', 'end VARCHAR(100)', 'starttime TIMESTAMP', 'endtime TIMESTAMP', 'next_scrape TIMESTAMP', 'active INT']) self.conDatabase.createTable(self.databasePrefix+"stations", ['name VARCHAR(100)', 'stationid VARCHAR(30)']) self.conDatabase.close() except Exception as e: self.logger.error("Could not create Tables: %s", e) return False self.logger.debug("Succesfuly connected to database.") return True else: self.logger.error("Could not connec to to Database.") return False
def __init__(self, dbHost, dbDatabase, dbDatabasePrefix, dbUser, dbPassword, mqttIp, mqttPort, mqttUser, mqttPassword): print('1') self.dbHost = dbHost self.dbDatabasePrefix = dbDatabasePrefix self.dbUser = dbUser self.dbPassword = dbPassword self.mqttIp = mqttIp self.mqttPort = mqttPort self.mqttUser = mqttUser self.mqttPassword = mqttPassword self.mqttClient = mqtt.Client() # create logger self.logger = logging.getLogger('MQTTSQLMIRROR') self.logger.setLevel(logging.DEBUG) self.ch = logging.StreamHandler() self.ch.setLevel(logging.DEBUG) self.log = logging.FileHandler('mqttsqlmirror.log') self.log.setLevel(logging.INFO) formatter = logging.Formatter( '%(asctime)s - %(name)s - %(levelname)s - %(message)s') self.ch.setFormatter(formatter) self.log.setFormatter(formatter) self.logger.addHandler(self.ch) self.logger.addHandler(self.log) # Establish mysql connection self.mysqlCon = mysql.Database(dbHost, dbDatabase, dbUser, dbPassword, self.logger)
def __init__(self, delete_before, table, host, database, user, password): # create logger self.logger = logging.getLogger('DATABASECLEARER') self.logger.setLevel(logging.DEBUG) self.ch = logging.StreamHandler() self.ch.setLevel(logging.DEBUG) self.log = logging.FileHandler('databaseclearer.log') self.log.setLevel(logging.INFO) formatter = logging.Formatter('%(asctime)s - %(name)s - %(levelname)s - %(message)s') self.ch.setFormatter(formatter) self.log.setFormatter(formatter) self.logger.addHandler(self.ch) self.logger.addHandler(self.log) self.con = mysql.Database(host, database, user, password, self.logger) curs = self.con.connect() if self.con != False and curs != False: self.con.delete(table, "DATEDIFF(NOW(), insertdatetime) > "+str(delete_before)) self.logger.info("Successfuly deleted.") self.con.close()