Beispiel #1
0
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'})
Beispiel #2
0
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
Beispiel #3
0
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'})
Beispiel #4
0
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
Beispiel #5
0
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
Beispiel #6
0
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