def setUp(self):
# FIXME somehow check this port number for availability
self.port = 12454
# create database directory
self.database_dir = TemporaryDirectory()
dbdir = self.database_dir.name
for relpath, content in ldap_objects.items():
filepath, _ = path.split(relpath)
cpath = path.join(dbdir, filepath)
fpath = path.join(dbdir, relpath)
if filepath and not path.exists(cpath):
os.makedirs(cpath)
with open(fpath, 'w') as f:
f.write(content)
# create temporary config file
self.configfile = NamedTemporaryFile()
self.configfile.write(bytes(slapd_config.format(dbdir=self.database_dir.name), 'UTF-8'))
self.configfile.flush()
uri = 'ldap://127.0.0.1:{}/'.format(self.port)
self.slapd = Popen(['slapd', '-f', self.configfile.name, '-h', uri, '-d', 'none'], stdout=DEVNULL, stderr=DEVNULL)
# FIXME give the server some time to start
time.sleep(1)
# connect and bind
self.ldap = ldap.ldap(uri)
self.ldap.simple_bind('cn=root,ou=test,ou=pyldap,o=jaseg,c=de', 'alpine')
def setUp(self):
# FIXME somehow check this port number for availability
self.port = 12454
# create database directory
self.database_dir = TemporaryDirectory()
dbdir = self.database_dir.name
for relpath, content in ldap_objects.items():
filepath, _ = path.split(relpath)
cpath = path.join(dbdir, filepath)
fpath = path.join(dbdir, relpath)
if filepath and not path.exists(cpath):
os.makedirs(cpath)
with open(fpath, 'w') as f:
f.write(content)
# create temporary config file
self.configfile = NamedTemporaryFile()
self.configfile.write(
bytes(slapd_config.format(dbdir=self.database_dir.name), 'UTF-8'))
self.configfile.flush()
uri = 'ldap://127.0.0.1:{}/'.format(self.port)
self.slapd = Popen(
['slapd', '-f', self.configfile.name, '-h', uri, '-d', 'none'],
stdout=DEVNULL,
stderr=DEVNULL)
# FIXME give the server some time to start
time.sleep(1)
# connect and bind
self.ldap = ldap.ldap(uri)
self.ldap.simple_bind('cn=root,ou=test,ou=pyldap,o=jaseg,c=de',
'alpine')
def configureldap(self, env): import params env.set_params(params) ldap()
def configure(self, env): import params env.set_params(params) knox() ldap()
#!/usr/bin/env python3
#
# Autor: Danielle dos Reis
# Version: v1
from mysql import primeira_query_novos, segunda_query_novos, update_mysql_novos
from sendmail import send_email
from ldap import ldap
query_1 = primeira_query_novos()
if query_1 != 0:
query_2 = segunda_query_novos()
for i in query_2:
lista = list(i)
cod_sf = lista[0]
usuario = lista[1].replace("@dominio.com.br", "")
senha = lista[2]
usr_ad = ldap(usuario)
if usr_ad == True:
send_email(usuario, senha, 'Acesso ao Timesheet')
print(f'2. E-mail enviado para o usuário {usuario}')
print('')
update_mysql_novos(cod_sf)
else:
print(f'3. O usuário {usuario} não foi encontrado no AD')
print('')
else:
print(f'O resultado da primeira query é {query_1}, não há o que executar.')
