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")