def emailAlunoNcc(): db = get_db() x = ncc.Ldap() res = x.listaUsuarios() for e in res: if e.uidNumber != 3432: try: db.execute('UPDATE aluno SET email = ?' 'WHERE usuario = ?', (e.mail.value, e.uid.value)) db.commit() except LDAPCursorError: pass x.fecha() print("Emails atualizados. \n")
def grupoBaseAlunoNcc(): db = get_db() x = ncc.Ldap() res = x.listaGrupos() for e in res: try: db.execute('UPDATE aluno SET grupoBase = ?' 'WHERE grupoBase = ?', (e.cn.value, e.gidNumber.value)) db.commit() except LDAPCursorError: pass db.close() x.fecha() print("Grupos Base atualizados. \n")
def matriculaAlunoNcc(): db = get_db() x = ncc.Ldap() res = x.listaUsuarios() for e in res: if e.uidNumber != 3432: try: db.execute( 'UPDATE aluno SET matricula = ?' 'WHERE usuario = ?', (e.employeeNumber.value, e.uid.value)) db.commit() except LDAPCursorError: pass x.fecha() print("Matriculas atualizadas. \n")
def dadosBasicoAlunoNcc(): db = get_db() x = ncc.Ldap() res = x.listaUsuarios() if res is None: print('\nERRO: nao foi possivel listar usuarios!\n') sys.exit() for e in res: if e.uidNumber != 3432: db.execute( 'INSERT INTO aluno (usuario, uidNumber, nome, home, grupoBase)' 'VALUES (?,?,?,?,?)', (e.uid.value, e.uidNumber.value, e.gecos.value, e.homeDirectory.value, e.gidNumber.value)) db.commit() x.fecha() print("Usuários, UID, nomes e homes atualizados. \n")
def senhaAlunoNcc(): db = get_db() x = ncc.Ldap() res = x.listaUsuarios() for e in res: if e.uidNumber != 3432: try: aux = str(e.userPassword.value) aux = aux.replace("b'{ssha}", "") aux = aux.replace("=='", "") db.execute('UPDATE aluno SET senha = ?' 'WHERE usuario = ?', (aux, e.uid.value)) db.commit() except LDAPCursorError: pass x.fecha() print("Senhas atualizadas. \n")
def grupoSecundarioAlunoNcc(): db = get_db() x = ncc.Ldap() res = x.listaGrupos() for e in res: try: aux = str(e.memberUid.value) aux = aux.replace("[", "") aux = aux.replace("]", "") aux = aux.replace("'", "") db.execute( 'UPDATE aluno SET grupoSecundario = ?' 'WHERE grupoBase = ?', (aux, e.gidNumber.value)) db.commit() except LDAPCursorError: pass x.fecha() print("Grupos Secudários atualizados. \n")