def question():
ques = input("Question: ")
app_id = "P3Y74H-APQLLLRWTG"
client = wolframalpha.Client(app_id)
res = client.query(ques)
answer = next(res.results).text
print(answer)
welcomeuser()
def remove_if_not_complete(content_owner, table, _date):
try:
query_job = client.query('''DELETE FROM `pops-204909.''' +
content_owner + "." + table + "`" +
" WHERE date='" + _date.replace("-", "") +
"'")
rows = query_job.result()
except:
pass
def remove_if_not_complete_month(content_owner, table, _date):
try:
query_job = client.query(
'''DELETE FROM `pops-204909.''' + content_owner + "." + table +
"`" + " WHERE PARSE_DATE('%Y%m%d',date) >= PARSE_DATE('%Y%m%d','" +
_date.replace("-", "") + "')")
rows = query_job.result()
except:
pass
async def ask(self, ctx, *, query):
res = client.query(query)
if res['@success'] == 'false':
strRes = "Couldn't find an answer"
else:
strRes = next(res.results).text
answer = '**' + query + '**' + '\n```' + strRes + '```'
await self.bot.say(answer)
def get_lastest_month_func(content_owner, table):
query_job = client.query(
'''SELECT MAX( PARSE_DATE('%Y%m%d',date)) AS `newest_month_BG`
FROM `pops-204909.''' + content_owner + "." +
table + "`")
rows = query_job.result()
for i_row in rows:
_newest_month_BG = i_row.get('newest_month_BG')
return datetime(int(str(_newest_month_BG).split("-")[0]),
int(str(_newest_month_BG).split("-")[1]), 1)
def datetime_to_utc(timedate):
app_id = 'L3J57Q-TWXW7R75RT'
client = wolframalpha.Client(app_id)
res = client.query('timestamp of ' + timedate)
answer = next(res.results).text
unix = int(re.sub('\(.*?\)', '', answer))
utc = pytz.utc
a_date = datetime.utcfromtimestamp(unix)
utc_date = utc.localize(a_date).isoformat()
return utc_date
def get_latest_date_func(content_owner, table):
query_job = client.query(
'''SELECT MAX( PARSE_DATE('%Y%m%d',date)) AS `lastest_date_BQ`
FROM `pops-204909.''' + content_owner + "." +
table + "`")
rows = query_job.result()
for i_row in rows:
_lastest_date_BQ = i_row.get('lastest_date_BQ')
try:
_date = datetime(_lastest_date_BQ.year, _lastest_date_BQ.month,
_lastest_date_BQ.day)
return _date
except AttributeError:
pass
def check_upload(file_name, content_owner, table, _date):
data = pd.read_table(file_name, sep=",")
data = data.replace(np.nan, '', regex=True)
try:
query_job = client.query(
'''SELECT count(*) as `row_number` FROM `pops-204909.''' +
content_owner + "." + table + "`" + " WHERE date='" +
_date.replace("-", "") + "'")
rows = query_job.result()
for i_row in rows:
row_number = i_row.get('row_number')
print("row_number = ", int(row_number), " ", "len(data)= ",
len(data))
if int(row_number) == len(data):
os.remove(file_name)
else:
remove_if_not_complete(content_owner=content_owner,
table=table,
_date=_date)
except (ValueError, KeyError) as e:
print("Could not remove the file!")