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)
