Advertisement
Guest User

Untitled

a guest
May 25th, 2016
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. def export_data(self, data, hour):
  2. """
  3. Метод для экспорта собранных данных по часам
  4. """
  5. sql = """DELETE FROM {hour_table} WHERE hour = '{hour}'""".format(hour_table=self.config.hour_table, hour=hour)
  6. self.cursor.execute(sql)
  7.  
  8. fields = ", ".join(KEY)
  9. values = ", ".join(["%s" for _ in range(len(KEY))])
  10.  
  11. sql = """INSERT INTO {hour_table} ({fields})
  12. VALUES ({values})""".format(fields=fields, values=values, hour_table=self.config.hour_table)
  13. logger = logging.getLogger("SSP-Billing")
  14. for key in data:
  15. key.extend([key[i] for i in ['exp', 'dspwinprice', 'dspexposureprice']])
  16. values = values % tuple(key)
  17. sql = """INSERT INTO {hour_table} ({fields})
  18. VALUES ({values})""".format(fields=fields, values=values, hour_table=self.config.hour_table)
  19. try:
  20. self.cursor.execute(sql)
  21. except Exception as e:
  22. logger.info(sql)
  23. raise e
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement