Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def export_data(self, data, hour):
- """
- Метод для экспорта собранных данных по часам
- """
- sql = """DELETE FROM {hour_table} WHERE hour = '{hour}'""".format(hour_table=self.config.hour_table, hour=hour)
- self.cursor.execute(sql)
- fields = ", ".join(KEY)
- values = ", ".join(["%s" for _ in range(len(KEY))])
- sql = """INSERT INTO {hour_table} ({fields})
- VALUES ({values})""".format(fields=fields, values=values, hour_table=self.config.hour_table)
- logger = logging.getLogger("SSP-Billing")
- for key in data:
- key.extend([key[i] for i in ['exp', 'dspwinprice', 'dspexposureprice']])
- values = values % tuple(key)
- sql = """INSERT INTO {hour_table} ({fields})
- VALUES ({values})""".format(fields=fields, values=values, hour_table=self.config.hour_table)
- try:
- self.cursor.execute(sql)
- except Exception as e:
- logger.info(sql)
- raise e
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement