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()
