def edituser(userid=None):
user = mongo.db.users.find_one({'_id': ObjectId(userid)})
return render_template('edituser.html', title="Please modify the user", user=user)
def findById(self, id):
return self.user.find_one({'_id': ObjectId(id), 'is_active': True})
def viewBlog(id):
blog = mongo.db.blogs.find_one_or_404({'_id': ObjectId(id)})
blog.setdefault('user', getMe())
if not (current_user and current_user.is_authenticated):
mongo.db.blogs.update({'_id': ObjectId(id)}, {'$inc': {'viewCount': 1}})
return render_template('blog.html', blog=blog)
def load_user(user_id):
user = mongo.db.users.find_one({"_id": ObjectId(user_id)})
return User(username=user['username'],
password=user['password'],
id=user['_id'])
def deleteCite(id):
db.delete_one({'_id': ObjectId(id)})
return jsonify({'message': 'Cite Deleted'})
def deleteUser(id):
#Eliminamos al usuario atravez de ese ID unico
db.delete_one({'_id': ObjectId(id)})
#Retornamos al cliente un mensaje
return jsonify({'msg': 'Usuario eliminado correctamente'})
def deleteUser(id):
db.delete_one({'_id': ObjectId(id)})
return jsonify({'msg': 'User delete'})
def deleteUser(id):
db.delete_one({'_id': ObjectId(id)})
return jsonify({'msg': f'user {id} deleted'})
def deleteUser(id):
db.delete_one({"_id": ObjectId(id)})
return jsonify({"msg": "User deleted"})
def audits():
if request.method == 'POST':
auditData = request.json
auditMetaData = auditData["auditMetadata"]
filledAuditForms = auditData["auditForms"]
allFormsAreValid = validateFilledAuditForms(filledAuditForms)
allMetadataAreValid = validateAuditMetadata(auditMetaData)
if not allMetadataAreValid[0]:
errorDescription = allMetadataAreValid[1]
return serverResponse(None, 400, errorDescription)
if not allFormsAreValid[0]:
errorDescription = allFormsAreValid[1]
return serverResponse(
None, 400,
f"Item no. {errorDescription[1]} in '{errorDescription[0]}':\n{errorDescription[2]}"
)
auditMetaData_ID, filledAuditForms_ID = generateIDs(
auditMetaData, filledAuditForms)
filledAuditForms_ID_processed = post_process_filledAuditForms(
filledAuditForms_ID)
auditMetaData_ID_processed = post_process_AuditMetadata(
auditMetaData_ID)
auditScore = calculateAuditScore(filledAuditForms_ID_processed)
auditMetaData_ID_processed["score"] = auditScore
if auditScore < 1:
allAnswers = []
for filledAuditForm in filledAuditForms_ID_processed.values():
for answerList in filledAuditForm["answers"].values():
allAnswers.extend(answerList)
percentRect = percentageRectification(allAnswers)
if percentRect < 1:
auditMetaData_ID_processed['rectificationProgress'] = 0
try:
result1 = mongo.db.audits.insert_one(
auditMetaData_ID_processed)
if not result1.acknowledged:
return serverResponse(
None, 503,
"Problem uploading audit details to Database")
for filledForm in filledAuditForms_ID_processed.values():
result2 = mongo.db.filledAuditForms.insert_one(filledForm)
if not result2.acknowledged:
return serverResponse(
None, 503, "Problem uploading forms to Database")
except DuplicateKeyError:
return serverResponse(None, 400,
"Form has already been uploaded")
tenant = mongo.db.tenant.find_one(
{"_id": auditMetaData["tenantID"]})
if tenant:
if (expoTokens := tenant.get("expoToken")) != None:
for token in expoTokens:
try:
send_push_message(
token, "SingHealth Audits",
"Recent audit results ready for viewing")
except:
continue
date = auditMetaData_ID_processed['date']
send_email_notif(
app, tenant["email"], "Audit Results",
f"""Dear {tenant["name"]},
Your recent audit results dated {utc2sgt(date).strftime('%d %B %Y, %I:%M %p')} are ready for reviewing. Please check your app for details.
This email is auto generated. No signature is required.
You do not have to reply to this email.""")
notif = {
"_id": str(ObjectId()),
"userID": tenant["_id"],
"auditID": auditMetaData_ID_processed["_id"],
"stallName": tenant["stallName"],
"type": "post",
"message":
f"New audit on {utc2sgt(date).strftime('%d/%m/%Y')} ready for viewing.",
"readReceipt": False,
"notiDate": datetime.now(),
"auditDate": date
}
result = mongo.db.notifications.insert_one(notif)
if not result.acknowledged:
print("Failed to add POST nofitication to DB")
return serverResponse(None, 200,
"Forms have been submitted successfully!")
def find_lesson(mongo, _id):
condition = {'_id': ObjectId(_id)}
data = mongo.db.lessons.find_one(condition)
return data
def deletar(self, id):
return self.tabela.delete_one({'_id': ObjectId(id)})
def busca_por_id(self, id):
return self.tabela.find_one({'_id': ObjectId(id)})
def removeuser():
mongo.db.users.delete_one({'_id': ObjectId(request.form['radio-delete'])})
return index()
def getPerfilPhoto(id):
data = str(id)
gen = db.find_one({'_id': ObjectId(data)}, {"_id": 0, "foto": 1})
return jsonify(gen)
def find_block_type(mongo, _id):
condition = {'using': True, '_id': ObjectId(_id)}
data = mongo.db.block_type.find_one(condition)
return data
def recuperar(codigo):
livro = mongo.db.livros.find_one({'_id': ObjectId(codigo)})
livro['id'] = str(livro['_id'])
del livro['_id']
return jsonify(livro)
def leave_lfg(lfg_id):
lfg = LFG(**mongo.db.lfgs.find_one({"_id": ObjectId(lfg_id)}))
lfg.remove_member(str(current_user.id))
lfg.update_collection(mongo.db.lfgs)
return redirect(url_for("lfgs.index"))
def user_home(logged_user):
if 'mail' in session and session['USER'] == True:
searchmovieform = SearchMovieForm()
buyticketform = BuyTicketForm()
if request.form.get(
"submit", ""
) == 'Search_movie' and searchmovieform.validate_on_submit and request.method == 'POST':
if movies.find_one({"title": searchmovieform.s_movie.data}):
movie = movies.find({"title": searchmovieform.s_movie.data})
flash(movie, "movie_info")
else:
flash("No movie with this title.", "not_found")
elif request.form.get(
"submit", ""
) == 'choose_movie' and buyticketform.validate_on_submit and request.method == 'POST':
ticket_num = buyticketform.t_ticket_num.data
title = buyticketform.t_title.data
screening_date = buyticketform.t_screening_date.data
movie_id = buyticketform.t_movie_id.data
sits_left = buyticketform.t_sits_left.data
if int(sits_left) < int(ticket_num):
flash("Invalid amount of tickets.", "invalid")
else:
session['movie_id'] = movie_id
session['ticket_num'] = ticket_num
session['title'] = title
session['screening_date'] = screening_date
flash(title, 'title')
flash(screening_date, 'screening_date')
flash(ticket_num, 'ticket_num')
elif request.form.get(
"submit", "") == 'submit_order' and request.method == 'POST':
movie = movies.find_one({"_id": ObjectId(session['movie_id'])})
dates = movie['screening_dates']
for date in dates:
if date['screening_date'] == session['screening_date']:
sits_left = int(date['sits_left']) - int(
session['ticket_num'])
db.movies.update_one(
{
"title":
session['title'],
"screening_dates.screening_date":
session['screening_date']
},
{'$set': {
'screening_dates.$.sits_left': sits_left
}})
db.users.update_one({"mail": session['mail']}, {
'$push': {
'movies_seen':
[session['movie_id'], session['ticket_num']]
}
})
flash("Book successful.", 'book')
elif request.form.get("submit",
"") == 'history' and request.method == 'POST':
return redirect(url_for("user_history", logged_user=logged_user))
elif request.form.get("submit",
"") == 'log_out' and request.method == 'POST':
session.clear()
return redirect(url_for("sign_up_page"))
return render_template("user_home.html",
logged_user=logged_user,
searchmovieform=searchmovieform,
buyticketform=buyticketform)
else:
return render_template("error.html")
def find_form_meta(mongo, _id):
condition = {'using': True, '_id': ObjectId(_id)}
data = mongo.db.form_meta.find_one(condition)
return data
def deleteUser(id):
db.find_one_and_delete({'_id': ObjectId(id)})
return jsonify({'msg': 'User deleted'})
def delete(id):
db.delete_one({'_id': ObjectId(id)})
respose = jsonify({"message": "user" + id + "borrado"})
return respose
def deleteUser(id):
db.delete_one({'_id': ObjectId(id)})
return jsonify({'message': 'Usuario eliminado'})
def create(pid):
exp_form = CreateExperiment_form()
db = get_db()
#
col_gans = (db["gantypes"].find({},{"_id":0}))
col_exp = db["experiments"] # experiments table
col_exp.create_index([("name", pymongo.ASCENDING), ("pid", pymongo.ASCENDING)], unique=True) # name unique index
all_exps = col_exp.find({"pid":pid})
gan_types = []
for g in col_gans:
print("gggg=", g)
gan_types.append((g["name"], g["name"]))
print(gan_types)
exp_form.ganType.choices = gan_types
error = None
#all_projects = col.find({})
# load default hyper params
all_hyperparams = list(get_default_hyperparams(db, pid))
default_para_list = list(get_default_hyperparams(db, pid))
#print(all_projects)
#all_projects = list(all_projects)
# test_project = {"p1":"test1", "p2":"test2"}
# if this for loop print outputs -
# web page will not print outputs
#for p in all_projects:
# print(p)
if exp_form.validate_on_submit():
try:
if error is None:
exp_name = exp_form.expName.data
exp_gan = exp_form.ganType.data
exp_pro_path = db.projects.find_one({"_id":ObjectId(pid)})["path"]
print(exp_pro_path)
print("exp gan=", exp_gan)
#paths
exp_path = os.path.join(exp_pro_path, exp_name)
exp_models_path = os.path.join(exp_pro_path, exp_name + "/models")
exp_output_path = os.path.join(exp_pro_path, exp_name + "/output")
os.mkdir(exp_path)
os.mkdir(exp_models_path)
os.mkdir(exp_output_path)
# initialize exp inforamtion
exp_dict = {"name":exp_name, "type":exp_gan, "pid": pid, "status": "TRAIN",
"path":exp_path, "models_path":exp_models_path, "output_path": exp_output_path , "iters": 0,
"current_epoch": 0, "dataloader_size": 0}
# modify exp_dict with default parameters
exp_para_list = get_default_exp_para(db, pid)
print("exp para list=", exp_para_list)
for exp_para in exp_para_list:
print("exp para000=====", exp_para)
exp_dict.update({exp_para["para_key"]: exp_para["para_value"]})
# insert exp dict
x = col_exp.insert_one(exp_dict)
# add additional data to experiments collection
#addInfoToExp
# initialize train settings
dict_settings = {"num_epochs": 0, "checkpoint_interval": 0, "checkpoint_type":"EPOCH"}
set_train_settings(db, str(x.inserted_id), dict_settings)
print(x.inserted_id) #out.inserted_id
# flash(x.inserted_id) # remove this one, if redirect the page
#return redirect(url_for('experiments.create'))
except Exception as e:
flash(e)
return render_template('experiments/create.html', form=exp_form, pid=pid, exps=all_exps)
def find_user(mongo, _id):
condition = {'using': True, '_id': ObjectId(_id)}
datas = mongo.db.user.find_one(condition)
return datas
def move_food(id, receive_id):
if request.method == "GET":
donate = mongo.db.donate
identity = ObjectId(str(id))
# print(identity)
donateview = list(donate.find({"_id": identity}))
# print(donateview)
quantity = donateview[0]["quantity"]
food = donateview[0]["description"]
kind = donateview[0]["type"]
name = donateview[0]["name"]
email = donateview[0]["email"]
# print(quantity)
return render_template('message.html',
time=datetime.now(),
quantity=quantity,
food=food,
kind=kind,
name=name,
email=email,
id=identity,
receive_id=receive_id)
else:
# get the user quantity from form
user_quantity = request.form['quantity']
# connect with database and query the database and store variables "89-98"
donate = mongo.db.donate
identity = ObjectId(str(id))
receive_identity = ObjectId(str(receive_id))
donateview = list(donate.find({"_id": identity}))
quantity = donateview[0]["quantity"]
kind = donateview[0]["type"]
# subtraction = subtract user_quantity from quantity
remaining = int(quantity) - int(user_quantity)
# print(remaining)
# compare it with the quantity that's already in the database
if remaining > 0:
# insert new data
receive = mongo.db.receive
# receive.insert({'quantity': quantity})
receive.update({'_id': receive_identity},
{"$set": {
'quantity': user_quantity
}})
searchreceive = list(receive.find({"_id": receive_identity}))
receive_name = searchreceive[0]["name"]
receive_city = searchreceive[0]["city"]
receive_type = searchreceive[0]["type"]
receive_email = searchreceive[0]["email"]
receive_quantity = searchreceive[0]["quantity"]
for item in searchreceive:
print(item)
donate.update({'_id': identity},
{"$set": {
'quantity': str(remaining)
}})
# donate = mongo.db.donate
donateview = list(donate.find({"_id": identity}))
quantity = donateview[0]["quantity"]
food = donateview[0]["description"]
kind = donateview[0]["type"]
name = donateview[0]["name"]
email = donateview[0]["email"]
message = "Here's a summary of your receive request: "
return render_template('receive-confirmation.html',
time=datetime.now(),
quantity=quantity,
food=food,
kind=kind,
name=name,
email=email,
identity=identity,
receive_name=receive_name,
receive_city=receive_city,
receive_type=receive_type,
receive_email=receive_email,
receive_quantity=receive_quantity,
message=message)
elif remaining == 0:
# insert new data
receive = mongo.db.receive
receive.update({'_id': receive_identity},
{"$set": {
'quantity': user_quantity
}})
searchreceive = list(receive.find({"_id": receive_identity}))
receive_name = searchreceive[0]["name"]
receive_city = searchreceive[0]["city"]
receive_type = searchreceive[0]["type"]
receive_email = searchreceive[0]["email"]
receive_quantity = searchreceive[0]["quantity"]
donate = mongo.db.donate
donateview = list(donate.find({"_id": identity}))
food = donateview[0]["description"]
donate.remove({"_id": identity})
message = "Here's a summary of your receive request: "
return render_template('receive-confirmation.html',
time=datetime.now(),
food=food,
receive_name=receive_name,
receive_city=receive_city,
receive_type=receive_type,
receive_email=receive_email,
receive_quantity=receive_quantity,
message=message)
else:
# Show donate quantity
donate = mongo.db.donate
donateview = list(donate.find({"_id": identity}))
donate_quantity = donateview[0]["quantity"]
return render_template('receive-fail.html',
time=datetime.now(),
donate_quantity=donate_quantity)
def bloglist():
user = getMe()
condition = {'userId': ObjectId(user.get_id())}
db_blogs = mongo.db.blogs.find(condition).sort("postTime", DESCENDING)
blogs = list(db_blogs)
return render_template('bloglist.html', blogs=blogs)
def findone_company(c):
querykey = client.get(c)
if querykey == None:
querykey = ct.find_one({'_id': ObjectId(c)})
client.set(c, querykey)
return querykey
def deleteBlog(id):
mongo.db.blogs.remove({'_id': ObjectId(id)})
flash(u'删除成功')
return redirect(request.args.get('next') or url_for('index'))
def updateUser(id):
db.update_one({"_id": ObjectId(id)}, {"$set": request.json})
return {"message": "User updated."}
