def get(self):
user_id = self.request.matchdict.get('user_id')
with create_transaction() as transaction:
state = transaction.query(UserSql).filter(
UserSql.id == user_id).first()
return HTTPOk(state.val()) if state is not None \
else HTTPNotFound(FailResultSimple("UserNotFound", "Пользователь не найдена"))
def _get_permission(sub: Urn, obj: Urn):
with create_transaction() as transaction:
permission = transaction.query(PermissionSql) \
.filter((PermissionSql.subject == str(sub)) & (PermissionSql.object == str(obj)))\
.first()
return HTTPOk(permission.val()) if permission is not None \
else HTTPNotFound(Permission(sub, obj, Permissions.Null))
def session(self):
with create_transaction() as transaction:
auth_sid = self.request.matchdict.get('auth_sid')
state = transaction.query(SessionStateSql).filter(
SessionStateSql.id == auth_sid).first()
return HTTPOk(state.val()) if state is not None \
else HTTPNotFound(FailResultSimple("SessionNotFound", "Сессия не найдена"))
def add_binding(self):
form_id = self.request.matchdict.get('form_id')
place_id = self.request.matchdict.get('place_id')
with create_transaction() as transaction:
binding = BindingSql(form_id, place_id)
transaction.add(binding)
return HTTPOk()
def get_form(self):
id = self.request.matchdict.get('id')
with create_transaction() as transaction:
form = transaction.query(FormSql) \
.filter(FormSql.id == id) \
.first()
return HTTPOk(form.val()) if form \
else HTTPNotFound(FailResultSimple('FormNotFound', 'Форма не найдена'))
def delete_answer(self):
id = self.request.matchdict.get('id')
with create_transaction() as transaction:
deleted = transaction.query(AnswerSql) \
.filter(AnswerSql.id == id) \
.delete()
return HTTPOk() if deleted \
else HTTPNotFound(FailResultSimple('AnswerNotFound', 'Ответ не найдена'))
def get_answer(self):
id = self.request.matchdict.get('id')
with create_transaction() as transaction:
answer = transaction.query(AnswerSql) \
.filter(AnswerSql.id == id) \
.first()
return HTTPOk(answer.val()) if answer \
else HTTPNotFound(FailResultSimple('AnswerNotFound', 'Ответ не найдена'))
def delete_binding(self):
form_id = self.request.matchdict.get('form_id')
place_id = self.request.matchdict.get('place_id')
with create_transaction() as transaction:
deleted = transaction.query(BindingSql) \
.filter(BindingSql.form_id == form_id and BindingSql.place_id == place_id) \
.delete()
return HTTPOk() if deleted \
else HTTPNotFound(FailResultSimple('BindingNotFound', 'Привязка не найдена'))
def set_answer(self):
id = self.request.matchdict.get('id')
answer = self.request.body.decode()
with create_transaction() as transaction:
patched = transaction.query(AnswerSql) \
.filter(AnswerSql.id == id) \
.update({AnswerSql.answer: answer})
return HTTPOk() if patched \
else HTTPNotFound(FailResultSimple('AnswerNotFound', 'Ответ не найдена'))
def set_form(self):
id = self.request.matchdict.get('id')
data = self.request.body.decode()
data = json.loads(data)
with create_transaction() as transaction:
patched = transaction.query(FormSql) \
.filter(FormSql.id == id) \
.update(data)
return HTTPOk() if patched \
else HTTPNotFound(FailResultSimple('FormNotFound', 'Форма не найдена'))
def put_form(self):
id = self.request.matchdict.get('id')
data = self.request.body.decode()
data = json.loads(data)
data["id"] = id
form = FormSql(**data)
try:
with create_transaction() as transaction:
transaction.add(form)
return HTTPOk()
except IntegrityError:
return HTTPNotFound(FailResultSimple('FormNotCreated', 'Форма не создана'))
def put_answer(self):
id = self.request.matchdict.get('id')
data = self.request.body.decode()
data = json.loads(data)
data["id"] = id
answer = AnswerSql(**data)
try:
with create_transaction() as transaction:
transaction.add(answer)
return HTTPOk()
except IntegrityError:
return HTTPNotFound(FailResultSimple('AnswerNotCreated', 'Ответ не создана'))
def put(self):
login = self.request.params.get('login')
email = self.request.params.get('email')
password = self.request.body.decode()
try:
with create_transaction() as transaction:
user = UserSql(login, password, email)
transaction.add(user)
return HTTPOk(user.id)
except IntegrityError:
return HTTPBadResponse(
FailResultSimple("FailRegister",
"Не удалось зарегистрировать"))
def _get_permissions(sub: Urn, skip: int, take: int):
with create_transaction() as transaction:
count = transaction.query(PermissionSql) \
.filter(PermissionSql.subject == str(sub)) \
.count()
if count == 0 or skip >= count:
return HTTPNotFound(ItemsResult([], skip, take, count))
permissions = transaction.query(PermissionSql)\
.filter(PermissionSql.subject == sub)\
[skip:take]
items = list(map(lambda p: p.val().__dict__, permissions))
return HTTPOk(ItemsResult(items, skip, take, count))
def get_forms_by_place(self):
place_id = self.request.matchdict.get('place_id')
skip = int(self.request.matchdict.get('skip', 0))
take = int(self.request.matchdict.get('take', 50000))
with create_transaction() as transaction:
count = transaction.query(FormSql) \
.join(BindingSql, BindingSql.form_id == FormSql.id) \
.filter(BindingSql.place_id == place_id) \
.count()
if count == 0 or skip >= count:
return HTTPNotFound(ItemsResult([], skip, take, count))
answers = transaction.query(FormSql) \
.join(BindingSql, BindingSql.form_id == FormSql.id) \
.filter(BindingSql.place_id == place_id) \
[skip:take]
items = list(map(lambda p: p.val().__dict__, answers))
return HTTPOk(ItemsResult(items, skip, take, count))
def authenticate_by_pass(self):
login = self.request.params.get('login')
client_addr = self.request.params.get('client_addr')
password = self.request.body.decode()
with create_transaction() as transaction:
user = transaction.query(UserSql)\
.filter((UserSql.login == login) & (UserSql.password == password))\
.first()
if user is None:
return HTTPForbidden(
FailResultSimple("UserNotFound", "Пользователь не найден"))
state = SessionStateSql(user_id=user.id,
auth_mode="ByPass",
ip_address=client_addr)
transaction.add(state)
return HTTPOk(sid=state.id)
def _add_or_update(self, osm_id: int, osm_type: str, address: str,
title: str):
with create_transaction() as transaction:
place = transaction.query(PlaceSql) \
.filter(PlaceSql.osm_id == osm_id and PlaceSql.osm_type == osm_type) \
.first()
if place:
transaction.query(PlaceSql)\
.filter(PlaceSql.id == place.id)\
.update({PlaceSql.address: address, PlaceSql.title: title})
place = place.val()
place.title = title
place.address = address
else:
place = PlaceSql(osm_type, osm_id, title, address)
transaction.add(place)
place = place.val()
return place
def get_forms(self):
user_id = self.request.matchdict.get('user_id')
skip = int(self.request.matchdict.get('skip', 0))
take = int(self.request.matchdict.get('take', 50000))
with create_transaction() as transaction:
count = transaction.query(FormSql)\
.filter(FormSql.creator == user_id)\
.count()
if count == 0 or skip >= count:
return HTTPNotFound(ItemsResult([], skip, take, count))
answers = transaction.query(FormSql)\
.filter(FormSql.creator == user_id)\
[skip:take]
items = list(map(lambda p: p.val().__dict__, answers))
return HTTPOk(ItemsResult(items, skip, take, count))