def set_browser(path, plan_browser):
try:
way = join(path, plan_browser)
data = pd.read_excel(way, usecols=['Browser'])
browser = data.to_dict()
except Exception as e:
filelog('PY_F', '[SB]:/n' + str(e))
return "[ERRO_GMD]: Erro ao pegar os dados do browser. <" + str(
e) + ">"
return browser
def get_user_data(path, plan_user):
try:
way = join(path, plan_user)
data = pd.read_excel(way, usecols=['username', 'password'])
login = data.to_dict()
except Exception as e:
filelog('PY_F', '[GUD]:\n' + str(traceback.format_exc()))
return "[ERRO_GUD]: Erro ao pegar os dados do usuário. <" + str(
e) + ">"
return login
def get_keyword(kword):
try:
k = True
while k:
rtn = BuiltIn().run_keyword(kword)
if rtn == -1:
k = False
elif rtn == False:
k = True
else:
k = True
except Exception as e:
filelog('PY_F', '[RFK]:\n' + str(traceback.format_exc()))
return '-1:/n' + str(e)
def get_materia_data(path, plan_materia):
try:
way = join(path, plan_materia)
data = pd.read_excel(way,
usecols=[
'Materias', 'Hora_Inicio', 'Hora_Fim',
'Dia_Semana', 'Status', 'Inicio_Aulas',
'Fim_Aulas'
])
course = data.to_dict()
except Exception as e:
filelog('PY_F', '[GMD]:\n' + str(traceback.format_exc()))
return "[ERRO_GMD]: Erro ao pegar os dados das matérias. <" + str(
e) + ">"
return course
def number_weekday(weekday):
try:
if 'Monday' in weekday:
return 1
elif 'Tuesday' in weekday:
return 2
elif 'Wednesday' in weekday:
return 3
elif 'Thursday' in weekday:
return 4
elif 'Friday' in weekday:
return 5
else:
return str("[ALERTA]: Sem aula nesse dia")
except Exception as e:
filelog('PY_F', '[SC]:\n' + str(traceback.format_exc()))
return "[ERRO_SC]: Erro ao validar o dia. <" + str(e) + ">"
def set_weekday(args):
try:
if 'segunda' in args or 'segunda-feira' in args:
rtn = 'Monday'
elif 'terça' in args or 'terca' in args or 'terça-feira' in args or 'terca-feira' in args:
rtn = 'Tuesday'
elif 'quarta' in args or 'quarta-feira' in args:
rtn = 'Wednesday'
elif 'quinta' in args or 'quinta-feira' in args:
rtn = 'Thursday'
elif 'sexta' in args or 'sexta-feira' in args:
rtn = 'Friday'
elif 'sábado' in args or 'sabado' in args:
rtn = 'Saturday'
elif 'domingo' in args:
rtn = 'Sunday'
else:
return '[ERRO]: Data inválida.'
return rtn
except Exception as e:
filelog('PY_F', '[SW]:\n' + str(traceback.format_exc()))
return "[ERRO_SW]: Erro ao indicar o dia da semana. <" + str(e) + ">"
def get_type(args):
try:
return type(args)
except Exception as e:
filelog('PY_F', '[GT]:\n' + str(traceback.format_exc()))
return '-3:/n' + str(e)
def lower_string(args):
try:
return args.lower()
except Exception as e:
filelog('PY_F', '[LS]:\n' + str(traceback.format_exc()))
return '-2:/n' + str(e)