/
main.py
156 lines (141 loc) · 5.43 KB
/
main.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
from flask import Flask, request, Response
import json
from User import User
from Task import Task
from Note import Note
from TaskStatus import TaskStatus
from DBContext import get_session, create_all
from common import generate_salted_hash, get_salt
create_all()
app = Flask(__name__)
@app.route('/users/', methods=['GET'])
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')
@app.route('/getUser/', methods=['POST'])
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')
@app.route('/createUser/', methods=['POST'])
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')
@app.route('/userNotes/', methods=['POST'])
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')
@app.route('/createNote/', methods=['POST'])
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')
@app.route('/saveNote/', methods=['POST'])
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')
@app.route('/deleteNotes/', methods=['POST'])
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')
@app.route('/userTasks/', methods=['POST'])
def usertasks():
user = User.get(request.json)
result = get_session().query(Task).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')
@app.route('/createTask/', methods=['POST'])
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')
@app.route('/deleteTask/', methods=['POST'])
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')
@app.route('/updateTask/', methods=['POST'])
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')
@app.route('/getTaskStatuses/', methods=['POST'])
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')
if __name__ == '__main__':
app.run(debug=True)