Example #1
0
def obtener_usuarios_por_search():
    try:
        search = request.args.get('q', None)
        with open_session() as s:
            uids = UsersModel.search_user(s, search)
            usuarios = UsersModel.get_users(s, uids)
            musers = [map_user_from_model(u) for u in usuarios]
        return jsonify({'status': 200, 'response': musers})

    except Exception as e:
        return jsonify({'status': 500, 'response': str(e)})
Example #2
0
def obtener_usuarios_por_uids(uids=[]):
    try:
        with open_session() as s:
            usuarios = UsersModel.get_users(s, uids)
            musers = [map_user_from_model(u) for u in usuarios]
        return jsonify({'status': 200, 'response': musers})

    except Exception as e:
        return jsonify({'status': 500, 'response': str(e)})
def config_dev(binder):
    """
        Configura un ambiente de desarrollo web
    """
    from login.model.LoginModel import LoginModel
    from users.model.UsersModel import UsersModel

    from .models.HydraApi import HydraApi
    from .models.google.GoogleSyncModel import GoogleSyncModel, GoogleSyncModelMock
    from .models.MailsModel import MailsModel, MailsModelMock

    binder.bind(LoginModel, LoginModel())
    binder.bind(UsersModel, UsersModel())
    binder.bind(HydraApi,
                HydraApi(HydraEnv.HYDRA_ADMIN_URL, HydraEnv.VERIFY_HTTPS))
    binder.bind(GoogleSyncModel, GoogleSyncModelMock())
    binder.bind(MailsModel, MailsModelMock())
Example #4
0
def _buscar_o_crear_usuario_uid(dni):
    with open_users_session() as session:
        uid = UsersModel.get_uid_person_number(session, dni)
        if not uid:
            uid = str(uuid.uuid4())
            user = User()
            user.id = uid
            user.name = 'Importado del sileg.'
            user.lastname = 'Importado del sileg'
            session.add(user)

            idni = IdentityNumber()
            idni.id = str(uuid.uuid4())
            idni.number = dni
            idni.user_id = uid
            session.add(idni)

            session.commit()

    return uid
Example #5
0
import os

HYDRA_ADMIN_URL = os.environ.get('HYDRA_ADMIN_URL')
VERIFY_HTTPS = bool(int(os.environ.get('VERIFY_HTTPS', 0)))

from hydra.model.HydraModel import HydraModel
from hydra.model.HydraLocalModel import HydraLocalModel
from hydra.model.QRModel import QRModel
from login.model.LoginModel import LoginModel
from users.model.UsersModel import UsersModel

hydraModel = HydraModel(HYDRA_ADMIN_URL, VERIFY_HTTPS)
hydraLocalModel = HydraLocalModel()
loginModel = LoginModel()
usersModel = UsersModel()
qrModel = QRModel()
Example #6
0
 def _obtener_usuarios(self, uids):
     with open_session() as s:
         users = UsersModel.get_users(s, uids)
         musers = [map_user_from_model(u) for u in users]
     return musers
from login.model import obtener_session
from login.model.LoginModel import LoginModel
from login.model.entities.Login import UserCredentials

f_to_read = sys.argv[1]
with open(f_to_read,'r') as f:
    with open('/var/log/supervisor/importar.log','a') as log:
        log.write(f'Ejecutando importaciĆ³n {datetime.datetime.utcnow()}\n')
        line = f.readline()
        while line:
            lastname, firstname, student_number, username, password, email = line.replace('\n','').split(';')
            dni = username
            try:            
                with open_session() as s:
                    #print(f'Buscando - {firstname} {lastname} {username} {email}')
                    uid = UsersModel.get_uid_person_number(s, dni)
                    #print(uid)
                    if uid:
                        users = UsersModel.get_users(s, [uid])
                        assert len(users) > 0
                        user = users[0]

                        if student_number and student_number != '':
                            # busco legajo y lo agrego en el caso de que no tenga
                            student_numbers = [l for l in user.identity_numbers if l.type == IdentityNumberTypes.STUDENT]
                            if len(student_numbers) < 0:
                                #print(f'Agregando legajo - {firstname} {lastname} {dni} {student_number}')
                                log.write(f'Agregando legajo - {firstname} {lastname} {dni} {student_number}\n')
                                l = IdentityNumber()
                                l.id = str(uuid.uuid4())
                                l.user_id = uid
Example #8
0
        try:
            cur.execute(
                'select pers_nrodoc from empleado e left join persona p on (p.pers_id = e.empleado_pers_id)'
            )
            dnis = [str(d[0]) for d in cur]
        finally:
            cur.close()
    finally:
        con.close()

    for dni in dnis:

        try:
            print(f'buscando usuario {dni}')
            with open_users_session() as s2:
                uid = UsersModel.get_uid_person_number(s2, dni)
                if not uid:
                    raise Exception(f'no se encuentra uid para el dni {dni}')

            silegModel = SilegModel()
            with open_session(echo=False) as session:
                try:
                    """ elimino fisicamente todas las designaciones de la persona referenciada """
                    print(f"eliminando designaciones {dni}")
                    for p in session.query(PersonalLeaveLicense.id).filter(
                            PersonalLeaveLicense.user_id == uid).all():
                        session.query(PersonalLeaveLicense).filter(
                            PersonalLeaveLicense.license_id == p.id).delete()
                    session.commit()
                    session.query(PersonalLeaveLicense).filter(
                        PersonalLeaveLicense.user_id == uid).delete()
Example #9
0
                'a': p[1],
                'd': str(p[2]),
                'f': p[3],
                'c': p[4]
            })

    finally:
        cur.close()
finally:
    con.close()

with open_session() as session:
    for p in persons:
        try:
            dni = p['d'].strip()
            user = UsersModel.get_uid_person_number(session, dni)
            if not user:
                uid = str(uuid.uuid4())
                print(f"agregando persona {p['n']} {p['a']} {p['d']}")
                u = User()
                u.id = uid
                u.firstname = p['n']
                u.lastname = p['a']
                u.birthdate = p['f']
                session.add(u)

                i = IdentityNumber()
                i.user_id = uid
                i.number = p['d'].strip()
                i.type = IdentityNumberTypes.DNI
                session.add(i)