class Pusher: def __init__ (self, config): self.c1 = Collector(config.DB) self.c2 = Collector(config.DB2) self.s1 = SheetItf(config.GOOGLE['credentials'], config.GOOGLE['scope'], config.GOOGLE['key'], config.GOOGLE['sheet']) def push(self): self.s1.addToRow([str(time.strftime("%d/%m/%Y")), str(time.strftime("%H:%M:%S"))]) self.s1.addToRow(self.c1.collect()) self.s1.addToRow(self.c2.collect()) print("pushing:", self.s1.nextRow) self.s1.pushRow()
import configparser import os from Database.DBManager import DBManager from Collector import Collector SOURCE_PATH = os.path.dirname(os.path.abspath(__file__)) CONFIG_FILE_NAME = SOURCE_PATH + "/settings.env" print(CONFIG_FILE_NAME) # Starting point config = configparser.ConfigParser() config.read(CONFIG_FILE_NAME) config_raw = configparser.RawConfigParser() config_raw.read(CONFIG_FILE_NAME) TIME_FORMAT = config_raw.get("Common", "TIME_FORMAT") DB_HOST = config.get("Database", "DB_HOST") DB_DATABASE = config.get("Database", "DB_DATABASE") DB_USERNAME = config.get("Database", "DB_USERNAME") DB_PASSWORD = config.get("Database", "DB_PASSWORD") db_manager = DBManager(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_DATABASE) Collector.collect(db_manager, TIME_FORMAT)
def data(): session = boto3.Session(region_name='us-west-2') collector = Collector(session) headers = {'Content-Type': 'application/json'} return (collector.collect(), 200, headers)