def CreateEngine(self, **kwargs): self.Echo = kwargs.get('Echo', False) try: assert isinstance(self.Echo, bool) except ValueError: print("Echo must be a boolean") try: if self._use_conf is None: database_conn = database_connection(self._database_type, self._database_name) self._hostname = database_conn["hostname"] self._port = database_conn["port"] self._database = database_conn["database"] else: self._hostname = self._use_conf["hostname"] self._port = self._use_conf["port"] self._database = self._use_conf["database"] if self._use_credentials is None: cred = credentials_extractor().get_database_credentials( self._database_type, self._database_name) self._user = cred["user"] self._pwd = cred["pwd"] else: self._user = self._use_credentials["user"] self._pwd = self._use_credentials["pwd"] _connector = construct_connection_to_database(self._database_type) con = str( _connector ) + self._user + ":" + self._pwd + "@" + self._hostname + ":" + self._port + "/" + self._database _engine = create_engine(con, echo=self.Echo) except Exception as e: print("An error occurred : {}".format(e)) return _engine.connect()
def extract_SFTP_connection(_protocole_type, _protocole_name, _use_conf, _use_credentials): if _use_conf is None: _SFTP_connection = SFTP_connection(_protocole_type, _protocole_name) _hostname = _SFTP_connection["hostname"] _port = _SFTP_connection["port"] _private_key = parse_private_key(_SFTP_connection["private_key"]) else: _hostname = _use_conf["hostname"] _port = _use_conf["port"] _private_key = parse_private_key(_use_conf["private_key"]) if _use_credentials is None: cred = credentials_extractor().get_sftp_credentials(_protocole_type, _protocole_name) _user = cred["user"] _pwd = cred["pwd"] else: _user = _use_credentials["user"] _pwd = _use_credentials["pwd"] return _user, _pwd, _hostname, _port, _private_key
def extract_FTP_connection(_protocole_type, _protocole_name, _use_conf, _use_credentials): if _use_conf is None: _FTP_connection = FTP_connection(_protocole_type, _protocole_name) _hostname = _FTP_connection["hostname"] _port = _FTP_connection["port"] if _port == "None": _port = None else: _hostname = _use_conf["hostname"] _port = _use_conf["port"] if _use_credentials is None: cred = credentials_extractor().get_ftp_credentials( _protocole_type, _protocole_name) _user = cred["user"] _pwd = cred["pwd"] else: _user = _use_credentials["user"] _pwd = _use_credentials["pwd"] return _user, _pwd, _hostname, _port
import dash import dash_core_components as dcc import dash_html_components as html from dash.dependencies import * import pandas as pd import plotly.graph_objs as go from creacard_connectors.creacard_connectors.database_connector import ConnectToPostgres from Creacard_Utils.import_credentials import credentials_extractor from six.moves.urllib.parse import quote external_stylesheets = ['https://codepen.io/chriddyp/pen/bWLwgP.css'] app = dash.Dash(__name__, external_stylesheets=external_stylesheets) credentials = credentials_extractor().get_database_credentials( "Postgres", "Creacard") engine = ConnectToPostgres(credentials).CreateEngine() query_list = """ SELECT table_name FROM information_schema.tables WHERE table_schema='PROFILING' """ list_table = pd.read_sql(query_list, con=engine) query_cluster_id = """ select distinct "ClusterID" as "ClusterID" from "PROFILING"."{}" """.format(list_table["table_name"][0]) clusters_list = pd.read_sql(query_cluster_id, con=engine)