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))
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()
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)
def connect(): return ConnectionAdapter(mysql_connect(**config('DATABASE_URL', cast=dburl)))
def connect(): return mysql_connect(**config('DATABASE_URL', cast=dburl))
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))