# *** TABLES CONTAINING DATA WHICH IS REFRESHED EACH TIME, AND THEREFORE CAN BE DROPPED SAFELY *** TABLES = {} TABLES['dailyInfected'] = ("CREATE TABLE `dailyInfected` (" " `infected` int(11) NOT NULL," " `hospitalised` int(11) DEFAULT 0 NOT NULL," " `deceased` int(11) DEFAULT 0 NOT NULL," " `date` date NOT NULL," " PRIMARY KEY (`date`)" ") ENGINE=InnoDB") # Loop over the array for table_name in TABLES: table_description = TABLES[table_name] print("Dropping table %s if it exists" % format(table_name)) db.executeQuery('DROP TABLE IF EXISTS %s' % str(table_name)) print("Creating table %s " % format(table_name)) db.executeQuery(table_description) # *** TABLES FOR WHICH DATA IS NOT REFRESHED, SO THEY CAN'T BE DROPPED *** # Array containing create statements for tables. PERSISTENTTABLES = {} PERSISTENTTABLES['temperatureLog'] = ("CREATE TABLE `temperatureLog` (" " `temperature` DECIMAL(5,1) NOT NULL," " `date` datetime NOT NULL," " `alerttext TEXT" " PRIMARY KEY (`date`)" ") ENGINE=InnoDB") # Loop over the array