def getTaskStatuses():
result = get_session().query(TaskStatus).all()
response = []
if len(result) > 0:
for s in result:
response.append(s.to_dict())
return Response(json.dumps(response), mimetype='application/json')
def userNotes():
user = User.get(request.json)
result = get_session().query(Note).filter_by(UserId=user.UserId).all()
response = []
if len(result) > 0:
for n in result:
response.append(n.to_dict())
return Response(json.dumps(response), mimetype='application/json')
def users():
result = get_session().query(User).all()
response = []
if len(result) > 0:
for u in result:
response.append(u.to_dict())
return Response(json.dumps(response), mimetype='application/json')
return Response(json.dumps(User().to_dict()), mimetype='application/json')
def deleteNotes():
session = get_session()
for n in request.json:
note = Note.get(n)
found = session.query(Note).filter_by(NoteId=note.NoteId).first()
if found != None:
session.delete(found)
session.flush()
return Response(json.dumps(True), mimetype='application/json')
def getUser():
user = User.get(request.json)
found = get_session().query(User).filter_by(Login=user.Login).first()
if found != None:
salted = generate_salted_hash(user.Password, found.Salt)
if salted == found.Password:
return Response(json.dumps(found.to_dict()),
mimetype='application/json')
return Response(json.dumps(User().to_dict()), mimetype='application/json')
def deleteTask():
session = get_session()
for t in request.json:
task = Task.get(t)
found = session.query(Task).filter_by(TaskId=task.TaskId).first()
if found != None:
session.delete(found)
session.flush()
return Response(json.dumps(True), mimetype='application/json')
def createUser():
user = User.get(request.json)
session = get_session()
lastUser = session.query(User).order_by(User.UserId.desc()).first()
user.UserId = 1 if lastUser == None else lastUser.UserId + 1
user.Salt = get_salt()
user.Password = generate_salted_hash(user.Password, user.Salt)
session.add(user)
session.flush()
return Response(json.dumps(user.to_dict()), mimetype='application/json')
def createNote():
note = Note.get(request.json)
session = get_session()
lastNote = session.query(Note).order_by(Note.NoteId.desc()).first()
note.NoteId = 1 if lastNote == None else lastNote.NoteId + 1
try:
session.add(note)
session.flush()
except:
note = Note()
return Response(json.dumps(note.to_dict()), mimetype='application/json')
def createTask():
task = Task.get(request.json)
session = get_session()
lastTask = session.query(Task).order_by(Task.TaskId.desc()).first()
task.TaskId = 1 if lastTask == None else lastTask.TaskId + 1
try:
session.add(task)
session.flush()
except:
task = Task()
return Response(json.dumps(task.to_dict()), mimetype='application/json')
def saveNote():
note = Note.get(request.json)
session = get_session()
found = session.query(Note).filter_by(NoteId=note.NoteId).first()
if found != None:
found.MasterNoteId = note.MasterNoteId
found.TaskId = note.TaskId
found.Title = note.Title
found.NoteText = note.NoteText
found.CreationDate = note.CreationDate
found.EditionDate = note.EditionDate
session.flush()
return Response(json.dumps(True), mimetype='application/json')
return Response(json.dumps(False), mimetype='application/json')
def updateTask():
task = Task.get(request.json)
session = get_session()
found = session.query(Task).filter_by(TaskId=task.TaskId).first()
if found != None:
found.MasterTaskId = task.MasterTaskId
found.Title = task.Title
found.TaskText = task.TaskText
found.CreationDate = task.CreationDate
found.EditionDate = task.EditionDate
found.TaskStatus = task.TaskStatus
session.flush()
return Response(json.dumps(True), mimetype='application/json')
return Response(json.dumps(False), mimetype='application/json')