def clean(self):
        # default validation
        super(MySQLConnectionForm, self).clean()

        if self.errors:
            return self.cleaned_data

        # test connection
        try:
            mysql_connect(host=self.cleaned_data['host'], port=self.cleaned_data['port'],
                          user=self.cleaned_data['user'], password=self.cleaned_data['password'],
                          database=self.cleaned_data['database'])

        except (InterfaceError, ProgrammingError), e:
            raise ValidationError(str(e))
Exemple #2
0
    def clean(self):
        # default validation
        super(MySQLConnectionForm, self).clean()

        if self.errors:
            return self.cleaned_data

        # test connection
        try:
            mysql_connect(host=self.cleaned_data['host'], port=self.cleaned_data['port'],
                          user=self.cleaned_data['user'], password=self.cleaned_data['password'],
                          database=self.cleaned_data['database'])

        except (InterfaceError, ProgrammingError), e:
            raise ValidationError(str(e))
Exemple #3
0
    def __init__(self, connection_dict):
        self.connections = []

        # create connection to all databases & save them
        for conn_info in connection_dict:
            connection = Connection(id=conn_info['id'], engine=conn_info['engine'])

            if connection.is_sqlite3():
                conn = sqlite3.connect(conn_info['name'])
            elif connection.is_mysql():
                conn = mysql_connect(host=conn_info['host'], port=conn_info['port'],
                                     user=conn_info['user'], password=conn_info['password'],
                                     database=conn_info['name'])
            elif connection.is_postgres():
                conn = psycopg2.connect("host='%s' port='%s' user='******' password='******' dbname='%s'" %
                                        (conn_info['host'], conn_info['port'], conn_info['user'],
                                         conn_info['password'], conn_info['name']))
            else:
                raise UnsupportedEngine('Unsupported engine: ' + conn_info['engine'])

            # save the connection object
            connection.conn = conn

            # add to connections array
            self.connections.append(connection)
    def start(self):
        try:
            self.sqlConnection = mysql_connect(host=self.host, user=self.dbUser, password=self.dbPass)
            #establish connection with mysql database

            self.sqlConnection.cursor().execute(f"USE {self.dbName}")
            #integrate cursor mechanincs
            print("Connected to database successfully")

        except mySqlError as err:
            print(f"Database error encountered: {err}. Exiting...") 
            sys.exit()
Exemple #5
0
    def _connect(self):
        if self._conf_defs['connection_type'] == DSN:
            raise HydroException("Mysql dsn connection is not implemented")
        else:
            if connector_type == 'MySQLdb':
                db_var = 'db'
                password_var = 'passwd'
            elif connector_type == 'mysql.connector':
                db_var = 'database'
                password_var = 'password'

            #TODO need to be implemented based on connection string
            # conn_string = 'DSN=%s' % self._conf_defs['connection_string']
            # self.logger.debug('Connect to {0}'.format(conn_string))
            db_params = {'user': self._conf_defs['db_user'],
                         password_var: self._conf_defs['db_password'],
                         'host': self._conf_defs['connection_string']}
            if self._conf_defs['db_name']:
                db_params[db_var] = self._conf_defs['db_name']
            self._conn = mysql_connect(**db_params)
Exemple #6
0
    def _connect(self):
        if self._conf_defs['connection_type'] == DSN:
            raise HydroException("Mysql dsn connection is not implemented")
        else:
            if connector_type == 'MySQLdb':
                db_var = 'db'
                password_var = 'passwd'
            elif connector_type == 'mysql.connector':
                db_var = 'database'
                password_var = 'password'

            #TODO need to be implemented based on connection string
            # conn_string = 'DSN=%s' % self._conf_defs['connection_string']
            # self.logger.debug('Connect to {0}'.format(conn_string))
            db_params = {'user': self._conf_defs['db_user'],
                         password_var: self._conf_defs['db_password'],
                         'host': self._conf_defs['connection_string']}
            if self._conf_defs['db_name']:
                db_params[db_var] = self._conf_defs['db_name']
            self._conn = mysql_connect(**db_params)
Exemple #7
0
def connect():
    return ConnectionAdapter(mysql_connect(**config('DATABASE_URL', cast=dburl)))
Exemple #8
0
def connect():
    return mysql_connect(**config('DATABASE_URL', cast=dburl))
Exemple #9
0
import mysql.connector
from mysql.connector import connect as mysql_connect

#Get connection info
host = input("Host: ")
if not host:
    host = 'localhost'
    print('Using localhost')
username = input("Username: "******"Password: "******"Database: ")

#Connect to the database and create a cursor
try:
    conn = mysql_connect(host = host,
                         user = username,
                         passwd = password,
                         database = database,
                         auth_plugin='mysql_native_password')
    cursor = conn.cursor()
except mysql.connector.errors.DatabaseError as e:
    print('Error: could not connect to the database')
    print(e)
else:
    print('Connected to database')

#Get the file

#Get table info
table_name = input("Table name: ")
    return http_request(url=url,
                        method='POST',
                        headers={'Content-Type': 'application/json'},
                        **post_vars)


if __name__ == '__main__':
    try:
        with open('latest_page.log', 'r') as file:
            latest_page = int(file.read())
    except:
        latest_page = 0  # 23

    with open('dbconfig.json', 'r') as file:
        config = json.loads(file.read())
    conn = mysql_connect(**config)

    for page, url, article in scrap(page=latest_page):
        # utama/2019/10/505232/datuk-red-enggan-cerai-adira
        match = find_matches(
            r'^https://www\.hmetro\.com\.my/(.+?)/(\d{4})/(\d{2})/(\d+?)/(.+)$',
            url)
        c, y, m, id, title = map(range(1, 6),
                                 lambda x: try_cast(match.group(x), int))
        cid = get_id_by_category(c)

        with open('article.txt', 'a', encoding='utf-8') as file:
            file.write('{}\n\n'.format(article))

        print('Got article from page {}: {}'.format(page, url))