def test_error(exc, request):
"""
Test (temp endpoint)
"""
query = request.dbsession.query(Client).first()
query = Utils.set_model_record(query, request.params)
return Utils.serialize_one(query)
def client_by_id_view(request):
"""
Return client by id
"""
# Check connected
if not Utils.check_connected(request):
raise exc.HTTPForbidden()
id = request.matchdict['id']
query = request.dbsession.query(Client).filter(Client.id == id).first()
return Utils.serialize_one(query)
def operateur_by_id_view(request):
"""
Return operateur by id
"""
# Check connected
if not Utils.check_connected(request):
raise exc.HTTPForbidden()
id = request.matchdict['id']
query = request.dbsession.query(Operateur).filter(
Operateur.id == id).first()
return Utils.serialize_one(query)
def numeros_by_id_view(request):
"""
Return numeros by id
"""
# Check connected
if not Utils.check_connected(request):
raise exc.HTTPForbidden()
# Get controle mutation id
id = request.id = request.matchdict['id']
query = request.dbsession.query(VNumeros).filter(VNumeros.id == id).first()
return Utils.serialize_one(query)
def affaire_by_id_view(request):
"""
Return affaires by id
"""
# Check connected
if not Utils.check_connected(request):
raise exc.HTTPForbidden()
id = request.matchdict['id']
query = request.dbsession.query(VAffaire)
one = query.filter(VAffaire.id == id).first()
return Utils.serialize_one(one)
def service_by_id_view(request):
"""
GET service by id
"""
# Check connected
if not Utils.check_connected(request):
raise exc.HTTPForbidden()
service_id = request.matchdict['id']
record = request.dbsession.query(Service).filter(
Service.id == service_id).first()
return Utils.serialize_one(record)
def login_view(request):
"""
Login
"""
response = None
login = None
password = None
if 'login' in request.params:
login = request.params['login']
if 'password' in request.params:
password = request.params['password']
# Check if user exists in DB
query = request.dbsession.query(Operateur)
log.info('Attempt to log with: {}'.format(login))
operateur = query.filter(
func.lower(Operateur.login) == func.lower(login)).first()
if not operateur:
return exc.HTTPNotFound('Username {} was not found'.format(login))
try:
resp_json = LDAPQuery.do_login(request, login, password)
except Exception as error:
log.error(str(error))
return {'error': 'true', 'code': 403, 'message': str(error)}
if resp_json and 'dn' in resp_json:
headers = remember(request, resp_json['dn'])
if operateur:
operateur_json = Utils.serialize_one(operateur)
"""
operateur_json['role_id'] = Utils.get_role_id_by_name(request, resp_json['role_name'])
operateur_json['role_name'] = resp_json['role_name']
operateur_json['fonctions'] = Utils.get_fonctions_roles_by_id(request, operateur_json['role_id'])
operateur_json['fonctions'] = [x["nom"] for x in operateur_json['fonctions']]"""
operateur_json = json.dumps(operateur_json) if operateur else ''
response = Response(operateur_json,
content_type='application/json; charset=UTF-8',
headers=headers)
return response
def controles_mutations_by_affaire_id_view(request):
"""
Return controle_mutation by affaire_id
"""
# Check connected
if not Utils.check_connected(request):
raise exc.HTTPForbidden()
# Get controle mutation id
affaire_id = request.id = request.matchdict['id']
query = request.dbsession.query(ControleMutation).filter(
ControleMutation.affaire_id == affaire_id).first()
if query is None:
return None
return Utils.serialize_one(query)
def affaire_suivi_mandats_by_affaire_id_view(request):
"""
Return suivi_mandats by affaire_id
"""
# Check connected
if not Utils.check_connected(request):
raise exc.HTTPForbidden()
# Get controle mutation id
affaire_id = request.id = request.matchdict['id']
query = request.dbsession.query(SuiviMandat).filter(
SuiviMandat.affaire_id == affaire_id).first()
if query is None:
return None
return Utils.serialize_one(query)