#########################################################################################
import logging
import time
import pyautogui as gui
import pyperclip as pyc #pip install pyperclip
import unicodedata
import io
from selenium import webdriver
from selenium.webdriver.remote.webdriver import WebDriver
from utils import *
from utils_vision import *
from subir_file import *
from logging_advance import *
#######################################################################################
log = logging_advance(_index="debug-python",
service='load_doc_principalyasociados.py',
send_elk=True)
x = logging_advance(service=__file__, send_elk=False)
def load_page_load_documento_principal(filename="win_doc_principal.png",
directory="D:/DPA/img",
pos_xy=None): #D://DPA//bin//
"""
Carga pagina usando driver
"""
gui.scroll(1000)
if load_page(filename=filename,
directory=directory,
pos_xy=None,
import requests
import yaml #pyyaml
import json
import sys
import time
import datetime
import os
import pandas as pd
import unicodedata
from pandas import read_excel # pip install xlrd
from pandas.io.json import json_normalize
from utils import *
from logging_advance import *
#######################################################################################
log = logging_advance(_index="debug-python",
service='datamanager.py',
send_elk=True)
#######################################################################################
def xlsx_2_pandas(fullpath,
name_sheet,
drop_colums=[],
drop_rows=[],
delete_columns_name=False):
only_name_file = os.path.basename(fullpath)
fullpath_name, extension = os.path.splitext(fullpath)
df = None
if extension == '.xlsx':
df = read_excel(fullpath, sheet_name=name_sheet, encoding='javascript')
log.print_info("namefile: {0} | name_sheet: {1} | {2}".format(
# Date: 10/06/2020
# Description: Carga la pagina "formulario" y llena los datos respectivos
#########################################################################################
import logging
import json
import time
import unicodedata
from utils import *
import pyautogui as gui
import pyperclip as pyc #pip install pyperclip
import html
from load_doc_principal_y_asociados import *
from utils_vision import *
from logging_advance import *
#######################################################################################
log = logging_advance(_index="debug-python", service='fill_data_formulario.py', send_elk=True)
#######################################################################################
## Normalizar cadenas de caracteres
def normalize(s):
replacements = (
("á", "a"),
("é", "e"),
("í", "i"),
("ó", "o"),
("ú", "u"),
)
for a, b in replacements:
s = s.replace(a, b).replace(a.upper(), b.upper()).replace('\n', ' ').replace('\r', '')
return s
def load_page_formulario(url,driver):
# Description: Ingresa user,pass y login to url.
#########################################################################################
import logging
import sys
import time
from utils import *
from login import *
from datamanager import *
from fill_data_formulario import *
from logging_advance import *
import pyautogui as gui
gui.FAILSAFE = True
if __name__ == "__main__":
#logging.basicConfig(format='%(asctime)s - %(message)s', level=logging.mBUG)
log = logging_advance(_index="debug-python", service='', send_elk=True)
log.print_debug("INI |", data_json={}, name_function="__main__")
#sys.setdefaultencoding( "utf-8" )
idx_sheet = 0 #int( input('retomar sheet:') ) # 3 tipos = ["Consejo Directivo","Presidencia","Gerencia General"]
idx_doc = 0 #870#868#828#696#516#424#366 #69 #14#int( input('retomar docum:') )
retomar = {'idx_sheet': idx_sheet, 'idx_doc': idx_doc}
driver = login(url, user, pasw)
## loading excel
filename = "Filtrado_2.xlsx"
fullpath = "D:\\DPA\\files\\" + filename
list_sheets = ["Consejo Directivo", "Presidencia", "Gerencia General"]
columns_rename = [
"resolucion", "anio", "tema", "enlace", "materia", "submateria", "or"
import sys
from logging_advance import *
from datetime import datetime
from utils import *
from utils_elk import *
#from flatten_json import flatten
from elastic import *
#######################################################################################
dict_real_name = {
"hot": "aws.data.highio.i3",
"warm": "aws.data.highstorage.d2",
"ml": "aws.ml.m5",
"m": "aws.master.r4"
}
#######################################################################################
log = logging_advance(fullpath=__file__, send_elk=False)
#######################################################################################
def execute_readonly(index, value=True):
flagExecuted = False
elk = elasticsearch()
rpt_json = {}
try:
URL_API = "{0}/{1}/_settings".format(elk.get_url_elk(), index)
data_query = {"index.blocks.write": value}
rpt_json = elk.req_put(URL_API, data=data_query)
flagExecuted = True
except:
log.print_error("flagExecute={0}",
name_function="execute_readonly",