import re, json, csv

#generic = importlib.import_module('generic')
from   generic.gn_api       import   gn_api # 
from   generic.gn_request   import   Request #
from   generic.gn_mysql     import   gn_mysql # 

class db_integracao(gn_api):
    
    def __init__(self, argv:list):
            
            self.db = False
            self.externaldb = False
            self.setup(argv)
            
            #self.get_external_db()
            
            super(db_integracao, self, ).__init__()
            
            
            
    def get_external_db(self, **kwargs) :
        if (not self.externaldb) :
            self.externaldb = gn_mysql(
                "{0}{1}{2}".format(
                        self.nmlkgrupo
                    ,   "\\" if self.debug else "/"
                    ,   self.apiName 
                ),
                '',self.debug
                )
            #self.externaldb.pydb_connection(**kwargs)
            
            
        return self.externaldb
        
    
    def handle_querys(self, query_result):
        if self.hasAttr('args',query_result):
            erro = " - ".join(map(str,query_result.args))
            self.createLog("999","Erro: " + erro)
            raise erro
            
        return query_result