def save(self): prune() log.info("saving...") log.info(str(self.value.keys())[:300]) session.add(self) session.commit() prune()
def patch(): c1_json = request.get_json() one_customer = session.query(Customer).filter( Customer.email == c1_json["email"]).first() if one_customer == None: return (jsonify({"message": "Mail not found."}), 404) else: session.add(one_customer) session.commit() return (jsonify({}), 200)
def post(): c1_json = request.get_json() if session.query(Customer).filter( Customer.email == c1_json["email"]).first() == None: c1 = Customer(name=c1_json["name"], address=c1_json["address"], email=c1_json["email"]) session.add(c1) session.commit() return (jsonify({"message": "Successfully loaded."}), 200) else: return (jsonify({"message": "This email already exists."}), 404)
def delete(): c1_json = request.get_json() try: if Customer.check_user_existance_and_apply(c1_json, session): session.delete( session.query(Customer).filter( Customer.email == c1_json["email"]).first()) session.commit() return (jsonify({"Message": "User deleted."}), 200) else: return (jsonify({"Message": "User could not be found."}), 404) except: return (jsonify({"Message": "The database could not be accesed."}), 500)
def prune(): """ Prune the cached extractions database to keep below 10,000 records, the free limit on Heroku. """ num = session.query(KvStore.id).count() if num > 9990: limit = num - 9900 log.info("Pruning {} records".format(limit)) for resolution in session.query(KvStore).order_by(KvStore.id.asc()).limit(limit): session.delete(resolution) session.commit() return num
def prune(): """ Prune the cached extractions database to keep below 10,000 records, the free limit on Heroku. """ num = session.query(KvStore.id).count() if(num > 9990): limit = num - 9900 log.info("Pruning {} records".format(limit)) for resolution in session.query( KvStore).order_by( KvStore.id.asc()).limit(limit): session.delete(resolution) session.commit() return num
def post(self): json_user_data = request.data print(json_user_data.decode('utf-8')) user_data = json.loads(json_user_data.decode('utf-8')) try: username = user_data['username'] password = user_data['password'] except: return {"status": 1, "message": "invalid format"} try: new_customer = Customer(username, password) session.add(new_customer) session.flush() session.commit() except Exception as e: print(e) return {"status": 2, "message": "error adding data to database"} return {"status": 0, "message": "sign up success"}
def save(self): print "saving..." print self.value.keys() session.add(self) session.commit()