def iot_api():
try:
if 'apiKey' in request.args:
api_key = request.args.get('apiKey')
if api_key is None:
return jsonify({"response": "Invalid Credentials"})
else:
try:
api_auth = models.mydb.Os_ver.find_one(
{"api_key": api_key}, {"_id": 0})
if api_auth:
if request.json == None:
return jsonify({"response": "Invalid Data"})
else:
try:
if 'phone_number' in request.json:
phone_no = request.json.get('phone_number')
json_data = request.get_json()
timer = str(datetime.datetime.now())
json_data['Received_at'] = timer
return models.add_data(phone_no=phone_no,
data=json_data)
else:
raise ValueError("Phone Number not found")
except Exception as e:
return "Error Occured: {}".format(str(e))
else:
return jsonify({"response": "Invalid Credentials"})
except Exception as e:
return "Error Occured: {}".format(str(e))
else:
raise ValueError('Invalid Argument List')
except Exception as e:
return "Error Occured: {}".format(str(e))
def hello_world():
if request.method == 'POST':
sname = request.form['sname']
tname = request.form['tname']
new_task = Studentdata(name=sname, teacher=tname)
try:
add_data(new_task)
commit_changes()
return jsonify(name=sname,
teacher=tname,
result="DATA SAVED SUCCESSFULLY")
#redirect('/sdata')
except:
return jsonify(name=sname, teacher=tname, result="DB ERROR")
else:
return jsonify(result="request method get")
def save_cotizacion(banco):
with (yield from sem):
body = yield from get(banco.url)
cotizacion = parse_cotizacion(banco, body)
if cotizacion and cotizacion.check_unique():
logger.info("Intentando guardar cotización para Banco %s",
banco.name)
try:
add_data(cotizacion, db_session)
logger.info("Guardada cotización %s", cotizacion)
except Exception as e:
logger.exception(e)
raise e
else:
msj = ("No se pudo obtener cotización para Banco %s"
if not cotizacion else
"Ya existe cotización actualizada para Banco %s")
logger.info(msj, banco.name)
def hello_world():
if g.user:
if request.method == 'POST':
sname = request.form['sname']
tname = request.form['tname']
new_task = Studentdata(name=sname, teacher=tname)
try:
add_data(new_task)
commit_changes()
return redirect('/sdata')
except:
return "THERE WAS A PROBLEM IN ENTERING DATA TO DATABASE"
else:
tasks = Studentdata.query.order_by(Studentdata.id).all()
return render_template('sdata.html', tasks=tasks)
else:
return "ERROR PLEASE LOGIN FIRST ", 401
def login():
if request.method == 'POST':
name = request.form['name']
email = request.form['email']
password = request.form['password']
token = True
task = authusers(name=name,
email=email,
password=password,
token=token,
new_dt=datetime.now() + timedelta(minutes=1))
try:
add_data(task)
commit_changes()
#redirect('/mainlogin')
return jsonify(result="Thanks for signup", name=name, email=email)
except:
return "sorry cannot save your data", 401
else:
return render_template('login.html')
def create_info():
datadir = '/home/li/company'
files = os.listdir(datadir)
for fname in files:
print fname
for line in open(os.path.join(datadir, fname), 'r'):
data = line.strip().split(',')
# print data[1], data[2]
info = db.Info()
info.code = str(data[1]).zfill(6)
info.date = str(data[0])
try:
info.pe = float(data[11])
info.pe_ttm = float(data[12])
info.pb = float(data[13])
except ValueError:
continue
try:
info.dyr = float(data[14])
except ValueError:
info.dyr = 0
info.roe = 100 * info.pb / info.pe_ttm
db.add_data([info])
def create_company():
datadir = '/home/li/company'
files = os.listdir(datadir)
for fname in files:
with open(os.path.join(datadir, fname), 'r') as f:
# read file end
f.seek(2)
data = f.readline().strip('\n')
data = data.strip().split(',')
print data[1], data[2]
company = db.Company()
company.code = str(data[1]).zfill(6)
company.name = str(data[2]).decode('utf-8')
company.zz1code = str(data[3]).zfill(2)
company.zz1name = str(data[4]).decode('utf-8')
company.zz2code = str(data[5]).zfill(4)
company.zz2name = str(data[6]).decode('utf-8')
company.zz3code = str(data[7]).zfill(6)
company.zz3name = str(data[8]).decode('utf-8')
company.zz4code = str(data[9]).zfill(8)
company.zz4name = str(data[10]).decode('utf-8')
if not db.get_company(company.code):
db.add_data([company])
def load_data(session):
add_data(bancos, session)
