def save(self):
prune()
log.info("saving...")
log.info(str(self.value.keys())[:300])
session.add(self)
session.commit()
prune()
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()
def save(self):
print "saving..."
print self.value.keys()
session.add(self)
session.commit()
