def add_titles():
try:
assert request.data, "there is no data"
json = request.get_json()
upsert(json, Title, ["id"])
except Exception as e:
return {"status": str(e)}
return {"status": "ok"}
def recv(code, *args):
"""
check if this track is done
No result in database would return none, so do a query and insert
:param code: express id
:param args: usually Telegram message_id and chat_id(user_id)
:return: message to be sent to the client
"""
try:
db_res = db.select("SELECT * FROM job WHERE track_id=?", (code, ))[0]
except IndexError:
db_res = db.select("SELECT * FROM job WHERE track_id=?", (code, ))
if len(db_res) == 0:
com_code, real_com_name = auto_detect(code)
if not com_code:
# TODO: Is it the pythonic way?
return utils.reply_not_found()
res = query_express_status(com_code, code)
done = 1 if (res.get('state') == '3' or res.get('state') == '4') else 0
try:
sql_cmd = "INSERT INTO job VALUES (NULL ,?,?,?,?,?,?,?,?)"
db.upsert(
sql_cmd,
(args[0], args[1], com_code, code,
res.get('data')[0].get('context'), STATE.get(
res.get('state')), res.get('data')[0].get('time'), done))
return code + ' ' + real_com_name + '\n' + res.get('data')[0].get(
'time') + ' ' + res.get('data')[0].get('context')
except IndexError:
return res.get('message')
elif db_res[8] == 0:
com_code, real_com_name = auto_detect(code)
if not com_code:
# TODO: Is it the pythonic way?
return utils.reply_not_found()
res = query_express_status(com_code, code)
done = 1 if (res.get('state') == '3' or res.get('state') == '4') else 0
try:
sql_cmd = "UPDATE job SET content=?,status=?,date=?,done=? WHERE track_id=?"
db.upsert(sql_cmd, (res.get('data')[0].get('context'),
STATE.get(res.get('state')),
res.get('data')[0].get('time'), done, code))
return code + ' ' + real_com_name + '\n' + res.get('data')[0].get(
'time') + ' ' + res.get('data')[0].get('context')
except IndexError:
return res.get('message')
else:
return db_res[4] + ' ' + PROVIDER.get(
db_res[3], 'Default') + '\n' + db_res[7] + ' ' + db_res[5]
def sync_form_entries(hash, field):
entries = get_entries_for_form(hash)
for segment in entries:
for entry in segment:
email = entry.get(field)
contact_id = find_contact_by_email(email)
data = {
'id': '%s-%s' % (hash, entry.get('EntryId')),
'hash': hash,
'entryid': entry.get('EntryId'),
'email': email,
'contactid': contact_id
}
print(data)
upsert(data)
def delete(tid):
"""
delete a track record
:param tid: express id
:return: delete result, success or fail
"""
cmd = "DELETE FROM job WHERE track_id=?"
if db.upsert(cmd, (tid, )) == 1:
return '删除成功 😋'
else:
return '那个在哪？'
def recv(code, *args):
"""
check if this track is done
No result in database would return none, so do a query and insert
:param code: express id
:param args: usually Telegram message_id and chat_id(user_id)
:return: message to be sent to the client
"""
# check the undone job length and send warning if necessary.
sql_cmd = 'SELECT track_id,message_id,chat_id,content FROM job WHERE done=?'
# recommend 4-6 hours on cron
message = ''
if len(db.select(sql_cmd, (0, ))) > 300:
message += u'由于快递100的免费版接口存在每IP每日最高2000查询的限制，查询次数即将接近上限。*您的查询可能会失败*'
try:
db_res = db.select("SELECT * FROM job WHERE track_id=?", (code, ))[0]
except IndexError:
db_res = db.select("SELECT * FROM job WHERE track_id=?", (code, ))
if len(db_res) == 0:
com_code, real_com_name = auto_detect(code)
if com_code == u'shunfeng':
return u'不好意思，快递100说顺丰的接口有一点点小问题。俺会尽快调整API的。'
if not com_code:
# TODO: Is it the pythonic way?
return utils.reply_not_found()
res = query_express_status(com_code, code)
done = 1 if (res.get('state') == '3' or res.get('state') == '4') else 0
try:
sql_cmd = "INSERT INTO job VALUES (NULL ,?,?,?,?,?,?,?,?)"
db.upsert(
sql_cmd,
(args[0], args[1], com_code, code,
res.get('data')[0].get('context'), STATE.get(
res.get('state')), res.get('data')[0].get('time'), done))
message += code + ' ' + real_com_name + '\n' + res.get('data')[
0].get('time') + ' ' + res.get('data')[0].get('context')
except IndexError:
message += res.get('message')
elif db_res[8] == 0:
com_code, real_com_name = auto_detect(code)
if com_code == u'shunfeng':
return u'不好意思，快递100说顺丰的接口有一点点小问题。俺会尽快调整API的。'
if not com_code:
return utils.reply_not_found()
res = query_express_status(com_code, code)
done = 1 if (res.get('state') == '3' or res.get('state') == '4') else 0
try:
sql_cmd = "UPDATE job SET content=?,status=?,date=?,done=? WHERE track_id=?"
db.upsert(sql_cmd, (res.get('data')[0].get('context'),
STATE.get(res.get('state')),
res.get('data')[0].get('time'), done, code))
message += code + ' ' + real_com_name + '\n' + res.get('data')[
0].get('time') + ' ' + res.get('data')[0].get('context')
except IndexError:
message += res.get('message')
else:
message += db_res[4] + ' ' + PROVIDER.get(
db_res[3], 'Default') + '\n' + db_res[7] + ' ' + db_res[5]
# TODO: 快递100的顺丰接口被废了，使用移动版
if message == u'非法访问:IP禁止访问':
message = '''由于快递100的免费版接口存在每IP每日最高2000查询的限制，目前已经超过此限制。
因此您此次的查询被取消。\n
建议稍后尝试，或者按照 https://github.com/BennyThink/ExpressBot 部署自己的机器人'''
return message
def set_counter(which=0, zval=0):
"""transactionally safe set of counter which to z,
creates entry if not available"""
db.upsert('counter', 'which', which, 'z', zval)
def persist_data(meta_class, data):
db.upsert(meta_class, engine, meta_class.parse_data(data))
def set_counter(which=0, zval=0):
"""transactionally safe set of counter which to z,
creates entry if not available"""
db.upsert('counter', 'which', which, 'z', zval)
def delete(tid):
cmd = "DELETE FROM job WHERE track_id=?"
if db.upsert(cmd, (tid, )) == 1:
return '删除成功 😋'
else:
return '那个在哪？'