def dailyCases(datajson):
month = {
'January': '01',
'February': '02',
'March': '03',
'April': '04',
'May': '05',
'June': '06'
}
for key in datajson['cases_time_series']:
try:
y = 2020
d, m = key['date'].strip().split(' ')
#latestDay = "{0}/{1}/{2}".format(d,month[m],y)
announcedate = (datetime.datetime(int(y), int(month[m]), int(d), 0,
0).strftime('%s')) + "000000000"
totalactive = int(key['totalconfirmed']) - int(
key['totalrecovered']) - int(key['totaldeceased'])
postQuery = "{0} dailyconfirmed={1},dailyrecovered={2},dailydeceased={3},totalconfirmed={4},totalactive={5},totalrecovered={6},totaldeceased={7} {8}".format(
table, key['dailyconfirmed'], key['dailyrecovered'],
key['dailydeceased'], key['totalconfirmed'], totalactive,
key['totalrecovered'], key['totaldeceased'], announcedate)
#print(postQuery)
influx.Post(db, postQuery)
except Exception as e:
print(e)
sys.exit(1)
def dataProcess(datajson):
#state_dict = {'JammuandKashmir' : 'JammuKashmir', 'DadraandNagarHaveli' : 'DadraNagarHaveli', 'AndamanandNicobarIslands' : 'AndamanNicobar'}
state_dict = {
'Jammu_and_Kashmir': 'Jammu_Kashmir',
'Dadra_and_Nagar_Haveli': 'Dadra_Nagar_Haveli',
'Andaman_and_Nicobar_Islands': 'Andaman_Nicobar'
}
for key in datajson['states_tested_data']:
try:
if key['totaltested'] != "":
#statename = '_'.join(key['state'].split(' '))
#statename = ''.join(key['state'].split(' '))
#if statename in state_dict.keys():
# state = state_dict[statename]
#else:
# state = statename
state = '\ '.join(key['state'].strip().split(' '))
d, m, y = key['updatedon'].split('/')
date = (datetime.datetime(int(y), int(m), int(d), 0,
0).strftime('%s')) + "000000000"
postQuery = "{0},state={1} sampleTestsdone={2} {3}".format(
table, state, key['totaltested'], int(date))
influx.Post(db, postQuery)
except Exception as e:
print(e)
sys.exit(1)
def totalTests(datajson):
yesterday = (datetime.datetime.now() -
datetime.timedelta(days=1)).strftime("%d/%m")
for key in datajson['tested']:
try:
if yesterday in key['updatetimestamp']:
postQuery = "{0} totalsamplestested={1}".format(
table, key['totalsamplestested'])
influx.Post(db, postQuery)
except Exception as e:
print(e)
sys.exit(1)
def dailyCases(datajson):
month = {'January': '01', 'February': '02', 'March': '03', 'April': '04'}
for key in datajson['cases_time_series']:
try:
y = 2020
d, m = key['date'].strip().split(' ')
announcedate = (datetime.datetime(int(y), int(month[m]), int(d), 0,
0).strftime('%s')) + "000000000"
dailyactive = int(key['dailyconfirmed']) - int(
key['dailyrecovered']) - int(key['dailydeceased'])
postQuery = "{0} dailyactive={1},dailyrecovered={2},dailydeceased={3} {4}".format(
table, dailyactive, key['dailyrecovered'],
key['dailydeceased'], announcedate)
influx.Post(db, postQuery)
except Exception as e:
print(e)
sys.exit(1)
def dataProcess():
startHr = 1
flag = 0
FH = open('/mnt/covid/deathRecoverdata', 'r')
for line1 in FH:
try:
line = line1.replace('#', '')
city = 'Details_Awaited'
district = 'Details_Awaited'
state = 'Details_Awaited'
statecode = 'Details_Awaited'
pArray = line.split(',')
if pArray[4] != "" and pArray[1] != "Date" and pArray[7] not in [
'Kerala/Puducherry?'
]:
flag += 1
startHr += 1
if startHr > 23:
startHr = 1
d, m, y = pArray[1].split('/')
date = (datetime.datetime(int(y), int(m), int(d), startHr,
0).strftime('%s')) + "000000000"
if pArray[5] != "":
city = '_'.join(pArray[5].split(' '))
if pArray[6] != "":
district = '_'.join(pArray[6].split(' '))
if pArray[7] != "":
#### Condition due to wrong data in sheet 159 line in recovery sheet
state = '_'.join(pArray[7].split(' '))
if state == "Hyderabad":
state = 'Andhra_Pradesh'
district = 'Hyderabad'
if pArray[8] != "":
statecode = '_'.join(pArray[8].split(' '))
postQuery = "{0},city={1},detecteddistrict={2},detectedstate={3},statecode={4} {5}=1".format(
table, city, district, state, statecode, pArray[4])
if int(d) == int(
datetime.datetime.now().day) and int(m) == int(
datetime.datetime.now().month):
postQuery = postQuery + ",new{0}=1".format(pArray[4])
postQuery = postQuery + " {0}".format(int(date) + flag)
influx.Post(db, postQuery)
except Exception as e:
print(e)
sys.exit(1)
def state_district_wise(datajson, zonejson):
color = {'Green': 1, 'Orange': 3, 'Red': 5}
zoneDict = {}
for key in zonejson['zones']:
if key['zone'] != '':
zoneDict[key['district']] = key['zone']
for key in datajson.keys():
try:
for key2 in datajson[key]['districtData']:
if key2 in zoneDict.keys():
zonecode = color[zoneDict[key2]]
else:
zonecode = 7
state = '\ '.join(key.strip().split(' '))
district = '_'.join(key2.split(' '))
active = abs(datajson[key]['districtData'][key2]['active'])
confirmed = abs(
datajson[key]['districtData'][key2]['confirmed'])
deceased = abs(datajson[key]['districtData'][key2]['deceased'])
recovered = abs(
datajson[key]['districtData'][key2]['recovered'])
deltaconfirmed = abs(
datajson[key]['districtData'][key2]['delta']['confirmed'])
deltadeaths = abs(
datajson[key]['districtData'][key2]['delta']['deceased'])
deltarecovered = abs(
datajson[key]['districtData'][key2]['delta']['recovered'])
if state != 'Delhi':
postQuery = '{0},state={1},district={2} district=\"{3}\",dactive={4},dconfirmed={5},ddeaths={6},drecovered={7},ddeltaconfirmed={8},ddeltadeaths={9},ddeltarecovered={10},zone={11}'.format(
table, state, district, key2, active, confirmed,
deceased, recovered, deltaconfirmed, deltadeaths,
deltarecovered, zonecode)
#print(postQuery)
influx.Post(db, postQuery)
except Exception as e:
print(e)
sys.exit(1)
def dataProcess(textdata):
startHr = 1
flag = 0
for line1 in textdata.split('\n'):
try:
line = line1.replace('#', '')
city = 'UnKnown'
district = 'UnKnown'
state = 'UnKnown'
#pDict = {'city' : 5, 'b_district' : 6, 'a_state' : 7}
pArray = line.split(',')
if pArray[4] != "" and pArray[1] != "Date" and pArray[7] not in [
'Kerala/Puducherry?'
]:
flag += 1
startHr += 1
if startHr > 23:
startHr = 1
d, m, y = pArray[1].split('/')
date = (datetime.datetime(int(y), int(m), int(d), startHr,
0).strftime('%s')) + "000000000"
if pArray[5] != "":
city = '_'.join(pArray[5].split(' '))
if pArray[6] != "":
district = '_'.join(pArray[6].split(' '))
if pArray[7] != "":
state = '_'.join(pArray[7].split(' '))
#postQuery = "{0},city={1},bdistrict={2},state={3} {4}=1".format(table,city,district,state,pArray[4])
postQuery = "{0},city={1},bdistrict={2},detectedstate={3} {4}=1".format(
table, city, district, state, pArray[4])
if int(d) == int(
datetime.datetime.now().day) and int(m) == int(
datetime.datetime.now().month):
postQuery = postQuery + ",new{0}=1".format(pArray[4])
postQuery = postQuery + " {0}".format(int(date) + flag)
influx.Post(db, postQuery)
except Exception as e:
print(e)
sys.exit(1)
import influx
### Variables ####
url = "https://docs.google.com/spreadsheets/d/e/2PACX-1vSc_2y5N0I67wDU38DjDh35IZSIS30rQf7_NYZhtYYGU1jJYT6_kDx4YpF-qw0LSlGsBYP8pqM_a1Pd/pub?output=csv&gid=200733542"
db = sys.argv[1]
table = 'covid_india'
dummyData = [
'Assam', 'Jharkhand', 'Andaman_and_Nicobar_Islands', 'Arunachal_Pradesh',
'Chandigarh', 'Chhattisgarh', 'Dadra_and_Nagar_Haveli', 'Goa', 'Ladakh',
'Manipur', 'Uttarakhand', 'Tripura', 'Puducherry', 'Mizoram'
]
for case in ['Recovered', 'Deceased']:
for state in dummyData:
postQuery = "{0},detectedstate={1} {2}=0".format(table, state, case)
influx.Post(db, postQuery)
#for case in ['newConfirmed', 'newRecovered','newDeceased']:
# postQuery = "{0},detectedstate=Arunachal_Pradesh {1}=0".format(table,case)
# influx.Post(db,postQuery)
def dataProcess(textdata):
startHr = 1
flag = 0
for line1 in textdata.split('\n'):
try:
line = line1.replace('#', '')
city = 'UnKnown'
district = 'UnKnown'
state = 'UnKnown'
patientDict[k] = '_'.join(patient[k].split(' '))
if flag != 0:
if patientDict['detectedstate'] in ['Kerala/Puducherry','Details_Awaited']:
continue
#print(patientDict['detectedstate'])
totalConfirm += 1
startHr += 1
if startHr > 23:
startHr = 1
d,m,y = patient['dateannounced'].split('/')
announcedate = (datetime.datetime(int(y), int(m), int(d), startHr, 0).strftime('%s')) + "000000000"
for k,v in patientDict.items():
postQuery = "{0},{1}={2}".format(postQuery,k,v)
if int(d) == int(datetime.datetime.now().day) and int(m) == int(datetime.datetime.now().month):
postData = "{0} Confirmed=1,NewConfirmed=1 {1}".format(postQuery,int(announcedate) + totalConfirm)
else:
postData = "{0} Confirmed=1 {1}".format(postQuery,int(announcedate) + totalConfirm)
influx.Post(db,postData)
except Exception as e:
print(e)
for k,v in ages.items():
postQuery="{0},age_bracket={1} count={2}".format(table,k,v)
influx.Post(db,postQuery)
def statewise(datajson):
state_dict = {
'Jammu_and_Kashmir': 'Jammu_Kashmir',
'Dadra_and_Nagar_Haveli': 'Dadra_Nagar_Haveli',
'Andaman_and_Nicobar_Islands': 'Andaman_Nicobar'
}
for key in datajson['statewise']:
try:
if key['state'] != 'Total':
state = '\ '.join(key['state'].strip().split(' '))
if int(key['deltadeaths']) < 0:
key['deltadeaths'] = 0
print(key['deltadeaths'])
if int(key['deltaconfirmed']) != 0 or int(
key['deltarecovered']) != 0 or int(
key['deltadeaths']) != 0:
if int(key['deltaconfirmed']) > 0:
postQuery = "{0},state={1} homedeltaconfirmed={2},homedeltadeaths={3},homedeltarecovered={4}".format(
table, state, key['deltaconfirmed'],
key['deltadeaths'], key['deltarecovered'])
influx.Post(db, postQuery)
#print(postQuery)
if key['state'] == 'Delhi':
postQuery = "{0},state={1},district=Delhi district=\"{2}\",ddeltaconfirmed={3},ddeltadeaths={4},ddeltarecovered={5},sactive={6},sconfirmed={7},sdeaths={8},srecovered={9},sdeltaconfirmed={10},sdeltadeaths={11},sdeltarecovered={12},dactive={13},drecovered={14},ddeaths={15}".format(
table, state, 'Delhi', key['deltaconfirmed'],
key['deltadeaths'], key['deltarecovered'],
key['active'], key['confirmed'], key['deaths'],
key['recovered'], key['deltaconfirmed'],
key['deltadeaths'], key['deltarecovered'],
key['active'], key['recovered'], key['deaths'])
#print(postQuery)
influx.Post(db, postQuery)
else:
postQuery = "{0},state={1} sactive={2},sconfirmed={3},sdeaths={4},srecovered={5},sdeltaconfirmed={6},sdeltadeaths={7},sdeltarecovered={8}".format(
table, state, key['active'], key['confirmed'],
key['deaths'], key['recovered'], key['deltaconfirmed'],
key['deltadeaths'], key['deltarecovered'])
influx.Post(db, postQuery)
### put data for state graph
y = 2020
d = int(datetime.datetime.now().day)
m = int(datetime.datetime.now().month)
announcedate = (datetime.datetime(
int(y), int(m), int(d), 0, 0).strftime('%s')) + "000000000"
activeindicator = int(key['deltaconfirmed']) - int(
key['deltadeaths']) - int(key['deltarecovered'])
postQuery = "{0},state={1} sgconfirmed={2},sgrecovered={3},sgdeaths={4},sgactiveindicator={5} {6}".format(
table, state, key['deltaconfirmed'], key['deltarecovered'],
key['deltadeaths'], activeindicator, announcedate)
influx.Post(db, postQuery)
else:
y = 2020
d, m, rest = key['lastupdatedtime'].strip().split('/')
announcedate = (datetime.datetime(
int(y), int(m), int(d), 0, 0).strftime('%s')) + "000000000"
postQuery = "{0} dailyconfirmed={1},dailyrecovered={2},dailydeceased={3},totalconfirmed={4},totalactive={5},totalrecovered={6},totaldeceased={7} {8}".format(
table, key['deltaconfirmed'], key['deltarecovered'],
key['deltadeaths'], key['confirmed'], key['active'],
key['recovered'], key['deaths'], announcedate)
influx.Post(db, postQuery)
#print(postQuery)
except Exception as e:
print(e)
sys.exit(1)
