def manualStoreRevisedForecast(startTime: dt.datetime, endTime: dt.datetime) -> None: x = 11 # x should be in range 1 to 15, stimulating dt.now() currTime = endTime + dt.timedelta(minutes=x) configDict = getAppConfigDict() startTime = currTime.replace(hour=0, minute=0, second=0, microsecond=0) endTime = startTime + dt.timedelta(hours=1, minutes=30) #checking dt.now() i.e currTime falls in which revision revisionNo = 0 for i in range(1, 17): if startTime <= currTime < endTime: revisionNo = i break else: startTime = startTime + dt.timedelta(hours=1, minutes=30) endTime = endTime + dt.timedelta(hours=1, minutes=30) startTime = currTime.replace(hour=0, minute=0, second=0, microsecond=0) endTime = startTime + dt.timedelta(hours=23, minutes=59) revisionNoStr = "R" + str(revisionNo) isRevisionStorageSuccess = storeRevisedForecast(startTime, endTime, revisionNoStr, configDict) if isRevisionStorageSuccess: print(f'revision number {revisionNoStr} storage successfull') else: print(f'revision number {revisionNoStr} storage unsuccessfull')
from datetime import datetime as dt import argparse from src.appConfig import getAppConfigDict from src.raw_table_creators.voltageMappingTable import voltageMappingTable from src.fetchers.freqDbFetcherServer import getFreqFromDb # from src.raw_table_creators.voltageRawTableCreator import voltageRawTableCreator from src.raw_table_creators.freqRawTableCreator import freqRawTableCreator from src.derived_table_creators.freqDerivedTableInsertion import freqDerivedTableInsertion from src.derived_table_creators.voltageDerivedTableInsertion import voltageDerivedTableInsertion from src.derived_table_creators.VDIDerivedTableInsertion import VDIDerivedTableInsertion configDict=getAppConfigDict() # parser = argparse.ArgumentParser() # parser.add_argument('--start_date', help="Enter Start date in yyyy-mm-dd format") # parser.add_argument('--end_date', help="Enter end date in yyyy-mm-dd format") # args = parser.parse_args() # startDate = dt.strptime(args.start_date, '%Y-%m-%d') # endDate = dt.strptime(args.end_date, '%Y-%m-%d') # 1-frequency # print(freqRawTableCreator(startDate,endDate,configDict)) # print(freqDerivedTableInsertion(startDate,endDate,configDict)) # 2-voltage # voltageMappingTable(configDict) # print(voltageRawTableCreator(startDate,configDict)) # print(voltageDerivedTableInsertion(startDate,endDate,configDict))
This is the web server that acts as a service that creates raw/derived data of voltage and frequency ''' import datetime as dt from src.appConfig import getAppConfigDict from src.raw_table_creators.freqRawTableCreator import freqRawTableCreator from src.derived_table_creators.freqDerivedTableInsertion import freqDerivedTableInsertion from src.raw_table_creators.voltageRawTableCreator import voltageRawTableCreator from src.derived_table_creators.voltageDerivedTableInsertion import voltageDerivedTableInsertion from src.derived_table_creators.VDIDerivedTableInsertion import VDIDerivedTableInsertion from src.fetchersForUi.derFrequencyFetchers import DerivedFrequencyFetch from flask import Flask, request, jsonify app = Flask(__name__) # get application config appConfig = getAppConfigDict() # Set the secret key to some random bytes app.secret_key = appConfig['flaskSecret'] # creating instance of classes of fetchers for UI con_string = appConfig['con_string_mis_warehouse'] @app.route('/') def hello(): return "This is the web service that acts as a service that creates raw/derived data of voltage and frequency" @app.route('/rawFrequency', methods=['POST']) def create_raw_frequency():
def setUp(self): self.appConfig = getAppConfigDict()