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)