INNER CODE UNIT · Python

_ensure_credentials_db

infobyte/emploleaks · emploleaks.py:619

    def _ensure_credentials_db(self):
        """Create the credentials database and table if they don't exist."""
        if not self.leaks_conn:
            return
        try:
            self.leaks_conn.execute(f'CREATE DATABASE IF NOT EXISTS {self.ch_dbname}')
            self.leaks_conn.execute(f'''
                CREATE TABLE IF NOT EXISTS {self.ch_dbname}.credentials (
                    mail_username String,
                    mail_domain String,
                    mail_tld String,
                    password String,
                    uri_subdomain String,
                    uri_domain String,
                    uri_tld String
                ) ENGINE = ReplacingMergeTree()
                ORDER BY (mail_username, mail_domain, mail_tld, password, uri_subdomain, uri_domain, uri_tld)
                SETTINGS index_granularity = 8192

View source record →