def sent():
con = db.createCon()
# Validate and Get POST data
keys = request.form.keys()
has_key = has_name = has_ids = False
for key in keys:
if key == 'key':
has_key = True
if key == 'name':
has_name = True
if key == 'ids':
has_ids = True
if not has_key or not has_name:
return json.dump({'error': "NO, Input Error!"})
mobile_key = request.form['key']
mobile_name = request.form['name']
if not db.isMobileValid(con, mobile_name, mobile_key):
con.close()
return json.dump({'error': "NO! your name and/or key is not here!"})
if has_ids:
success_ids = request.form['ids']
db.setSentTime(con, success_ids)
con.close()
return json.dumps({'success': 'success'})
else:
con.close()
return json.dumps({'error': 'NO! success'})
def rang():
con = db.createCon()
json_data = json.loads(request.data)
keys = json_data.keys()
has_key = has_name = has_from = True
for k in keys:
if k == 'key':
has_key = True
if k == 'name':
has_name = True
if k == 'from':
has_from = True
if not has_key or not has_name or not has_from:
con.close()
return json.dumps({'error': "NO, Input Error!"})
mobile_key = json_data['key']
mobile_name = json_data['name']
mobile_from = json_data['from']
if not db.isMobileValid(con, mobile_name, mobile_key):
con.close()
return json.dump({'error': "NO! your name and/or key is not here!"})
status = db.handelRing(mobile_from)
return status
def sent():
con = db.createCon()
# Validate and Get POST data
keys = request.form.keys()
has_key = has_name = has_ids = False
for key in keys:
if key == 'key':
has_key = True
if key == 'name':
has_name = True
if key == 'ids':
has_ids = True
if not has_key or not has_name:
return json.dump({'error': "NO, Input Error!"})
mobile_key = request.form['key']
mobile_name = request.form['name']
if not db.isMobileValid(con, mobile_name, mobile_key):
con.close()
return json.dump({'error': "NO! your name and/or key is not here!"})
if has_ids:
success_ids = request.form['ids']
db.setSentTime(con, success_ids)
con.close()
return json.dumps({'success': 'success'})
else:
con.close()
return json.dumps({'error': 'NO! success'})
def rang():
con = db.createCon()
json_data = json.loads(request.data)
keys = json_data.keys()
has_key = has_name = has_from = True
for k in keys:
if k == 'key':
has_key = True
if k == 'name':
has_name = True
if k == 'from':
has_from = True
if not has_key or not has_name or not has_from:
con.close()
return json.dumps({'error': "NO, Input Error!"})
mobile_key = json_data['key']
mobile_name = json_data['name']
mobile_from = json_data['from']
if not db.isMobileValid(con, mobile_name, mobile_key):
con.close()
return json.dump({'error': "NO! your name and/or key is not here!"})
status = db.handelRing(mobile_from)
return status
def get():
arr = []
con = db.createCon()
LIMIT = 3 # Default value for a
# Validate and Get POST data
keys = request.form.keys()
has_key = has_name = has_limit = False
for key in keys:
if key == 'key':
has_key = True
if key == 'name':
has_name = True
if key == 'limit':
has_limit = True
if (not has_key) or (not has_name):
return json.dump({'error': "NO, Input Error!"})
mobile_key = request.form['key']
mobile_name = request.form['name']
if has_limit:
LIMIT = request.form['limit']
if not db.isMobileValid(con, mobile_name, mobile_key):
con.close()
return json.dump({'error': "NO! your name and/or key is not here!"})
# RETURN THE MESSAGES
get_query = "SELECT * FROM transactions WHERE delivered_to_phone_at IS NULL LIMIT %d" % LIMIT
con.query(get_query)
r = con.store_result()
for i in xrange(0, r.num_rows()):
dic = {}
row = r.fetch_row()
(m_id, m_to, m_text, c_CA, c_DTPA, d_SA, s_DA) = row[0]
# Add to array
dic['id'] = m_id
dic['to'] = m_to
dic['text'] = m_text
arr.append(dic)
# Update Database
update_query = "UPDATE transactions SET delivered_to_phone_at = now() WHERE id = %d" % m_id
con.query(update_query)
con.commit()
dic = {}
dic['messages'] = arr
j = json.dumps(dic)
con.close()
print j
return j
def get():
arr = []
con = db.createCon()
LIMIT = 3 # Default value for a
# Validate and Get POST data
keys = request.form.keys()
has_key = has_name = has_limit = False
for key in keys:
if key == 'key':
has_key = True
if key == 'name':
has_name = True
if key == 'limit':
has_limit = True
if (not has_key) or (not has_name):
return json.dump({'error': "NO, Input Error!"})
mobile_key = request.form['key']
mobile_name = request.form['name']
if has_limit:
LIMIT = request.form['limit']
if not db.isMobileValid(con, mobile_name, mobile_key):
con.close()
return json.dump({'error': "NO! your name and/or key is not here!"})
# RETURN THE MESSAGES
get_query = "SELECT * FROM transactions WHERE delivered_to_phone_at IS NULL LIMIT %d" % LIMIT
con.query(get_query)
r = con.store_result()
for i in xrange(0,r.num_rows()):
dic = {}
row = r.fetch_row()
(m_id, m_to, m_text, c_CA, c_DTPA, d_SA, s_DA) = row[0]
# Add to array
dic['id'] = m_id
dic['to'] = m_to
dic['text'] = m_text
arr.append(dic)
# Update Database
update_query = "UPDATE transactions SET delivered_to_phone_at = now() WHERE id = %d" % m_id
con.query(update_query)
con.commit()
dic = {}
dic['messages'] = arr
j = json.dumps(dic)
con.close()
print j
return j
