def api_user_create():
try:
auth_token = request.form["auth_token"]
user_first_name = request.form["user_first_name"]
user_last_name = request.form["user_last_name"]
user_other_names = request.form["user_other_names"] or None
user_email = request.form["user_email"] or None
user_username = request.form["user_first_name"]
user_password = request.form["user_password"] or gen_password(8)
user_rank = request.form["rank"]
if "" in (user_first_name, user_last_name, user_username,
user_password, user_rank):
raise KeyError
except KeyError as e:
raise APIMissingField(e.args[0])
caller = get_user_from_token(auth_token)
if caller.rank != "admin":
return make_response(
jsonify({
"status":
"failed",
"message":
"You do not have a high enough rank to create users."
}))
conn = engine.connect()
query = sql.insert(
User, {
User.first_name: user_first_name,
User.last_name: user_last_name,
User.other_names: user_other_names,
User.email: user_email,
User.username: user_username,
User.pass_hash: crypt_hash(user_password),
User.rank: user_rank
})
res = conn.execute(query)
if res.inserted_primary_key:
return make_response(
jsonify({
"status": "success",
"message": "User created",
"user_id": res.inserted_primary_key
}))
else:
return make_response(
jsonify({
"status": "failed",
"message": "Unknown error"
}))
def api_user_create():
try:
auth_token = request.form["auth_token"]
user_first_name = request.form["user_first_name"]
user_last_name = request.form["user_last_name"]
user_other_names = request.form["user_other_names"] or None
user_email = request.form["user_email"] or None
user_username = request.form["user_first_name"]
user_password = request.form["user_password"] or gen_password(8)
user_rank = request.form["rank"]
if "" in (user_first_name, user_last_name, user_username, user_password, user_rank):
raise KeyError
except KeyError as e:
raise APIMissingField(e.args[0])
caller = get_user_from_token(auth_token)
if caller.rank != "admin":
return make_response(jsonify({
"status": "failed",
"message": "You do not have a high enough rank to create users."
}))
conn = engine.connect()
query = sql.insert(User, {
User.first_name: user_first_name,
User.last_name: user_last_name,
User.other_names: user_other_names,
User.email: user_email,
User.username: user_username,
User.pass_hash: crypt_hash(user_password),
User.rank: user_rank
})
res = conn.execute(query)
if res.inserted_primary_key:
return make_response(jsonify({
"status": "success",
"message": "User created",
"user_id": res.inserted_primary_key
}))
else:
return make_response(jsonify({
"status": "failed",
"message": "Unknown error"
}))
def api_user_login():
print(request.form.to_dict())
try:
estab_id = request.form["estab_id"]
username = request.form["username"]
password = request.form["password"]
if estab_id == "":
raise APIMissingField("estab_id")
elif username == "":
raise APIMissingField("username")
elif password == "":
raise APIMissingField("password")
except KeyError as e:
raise APIMissingField(e.args[0])
try:
estab_id = int(estab_id)
except ValueError:
raise APIInvalidField("estab_id")
username = username.lower()
pass_hash = crypt_hash(password)
conn = engine.connect()
query = sql.select([User]).where((User.establishment == estab_id)
& (User.username == username)
& (User.pass_hash == pass_hash))
res = conn.execute(query)
if res.rowcount == 1:
# successful login, make a token
return make_response(
jsonify({
"status": "success",
"message": "You have successfully logged in.",
"auth_token": gen_login_token(res.fetchall()[0])
}), 200)
else:
return make_response(
jsonify({
"status":
"failed",
"message":
"Username, password and establishment combination was incorrect."
}), 200)
def api_user_login():
print(request.form.to_dict())
try:
estab_id = request.form["estab_id"]
username = request.form["username"]
password = request.form["password"]
if estab_id == "":
raise APIMissingField("estab_id")
elif username == "":
raise APIMissingField("username")
elif password == "":
raise APIMissingField("password")
except KeyError as e:
raise APIMissingField(e.args[0])
try:
estab_id = int(estab_id)
except ValueError:
raise APIInvalidField("estab_id")
username = username.lower()
pass_hash = crypt_hash(password)
conn = engine.connect()
query = sql.select([User]).where(
(User.establishment == estab_id) &
(User.username == username) &
(User.pass_hash == pass_hash)
)
res = conn.execute(query)
if res.rowcount == 1:
# successful login, make a token
return make_response(jsonify({
"status": "success",
"message": "You have successfully logged in.",
"auth_token": gen_login_token(res.fetchall()[0])
}), 200)
else:
return make_response(jsonify({
"status": "failed",
"message": "Username, password and establishment combination was incorrect."
}), 200)
def api_estab_create():
try:
full_name = request.form["full_name"]
code_name = request.form["code_name"]
except KeyError as e:
# do something more useful here
raise APIMissingField(e.args[0])
try:
user = request.form["user"] or ""
password = request.form["password"] or ""
if "" in (user, password):
raise KeyError
default_user = False
except KeyError as e:
user = "******"
password = gen_password(8)
default_user = True
if full_name == "":
raise APIMissingField("name")
conn = engine.connect()
query = sql.Insert(Establishment, {
Establishment.full_name: full_name,
Establishment.code_name: code_name
})
try:
res = conn.execute(query)
except sqlalchemy.exc.IntegrityError as e:
print(e)
return make_response(
jsonify({
"status": "failed",
"message": "Name is in use."
}), 400)
estab_id = res.inserted_primary_key[0]
query = sql.insert(
User, {
User.first_name: "Admin",
User.last_name: "User",
User.rank: "admin",
User.username: user,
User.pass_hash: crypt_hash(password),
User.establishment: estab_id
})
res = conn.execute(query)
if default_user:
return make_response(
jsonify({
"status": "success",
"message":
"Establishment was created! (User does not work yet...)",
"id": estab_id,
"username": user,
"password": password
}))
else:
return make_response(
jsonify({
"status": "success",
"message":
"Establishment was created! (User does not work yet...)",
"id": estab_id,
"username": user,
"password": "******"
}))
def api_estab_create():
try:
full_name = request.form["full_name"]
code_name = request.form["code_name"]
except KeyError as e:
# do something more useful here
raise APIMissingField(e.args[0])
try:
user = request.form["user"] or ""
password = request.form["password"] or ""
if "" in (user, password):
raise KeyError
default_user = False
except KeyError as e:
user = "******"
password = gen_password(8)
default_user = True
if full_name == "":
raise APIMissingField("name")
conn = engine.connect()
query = sql.Insert(Establishment, {
Establishment.full_name: full_name,
Establishment.code_name: code_name
})
try:
res = conn.execute(query)
except sqlalchemy.exc.IntegrityError as e:
print(e)
return make_response(jsonify({
"status": "failed",
"message": "Name is in use."
}), 400)
estab_id = res.inserted_primary_key[0]
query = sql.insert(User, {
User.first_name: "Admin",
User.last_name: "User",
User.rank: "admin",
User.username: user,
User.pass_hash: crypt_hash(password),
User.establishment: estab_id
})
res = conn.execute(query)
if default_user:
return make_response(jsonify({
"status": "success",
"message": "Establishment was created! (User does not work yet...)",
"id": estab_id,
"username": user,
"password": password
}))
else:
return make_response(jsonify({
"status": "success",
"message": "Establishment was created! (User does not work yet...)",
"id": estab_id,
"username": user,
"password": "******"
}))
