def _connect(**conn_override) -> Connection:
conn_args = dict(host=settings.DB_HOST,
user=settings.DB_USER,
password=settings.DB_PASS,
port=settings.DB_PORT)
if not empty(settings.DB_NAME):
conn_args['database'] = settings.DB_NAME
conn_args = {**conn_args, **conn_override}
return Connection(**conn_args)
def Connect(*args, **kwargs):
# import pymysql.cursors
# # Connect to the database
# connection = pymysql.connect(host='localhost',
# user='******',
# password='',
# db='ATEC_DB_MYSQL',
# charset='utf8mb4',
# cursorclass=pymysql.cursors.DictCursor)
"""Factory function for connections.Connection."""
from MySQLdb.connections import Connection
return Connection(*args, **kwargs)
def Connect(*args, **kwargs):
"""Factory function for connections.Connection."""
from MySQLdb.connections import Connection
return Connection(*args, **kwargs)
from dataset import InputDataSet
from selected_result import SelectResult
import configparser
conf_dir = dirname(dirname(abspath(__file__)))
config = configparser.ConfigParser()
config.read(join(conf_dir, 'app.conf'), encoding='utf-8')
SYS_USER = os.getenv("USER") # get system user
CONFIG = {
'user': config['DB']['user'] if SYS_USER == 'dimasty' else 'root',
'password': config['DB']['user'] if SYS_USER == 'dimasty' else '',
'host': config['DB']['host'],
'database': config['DB']['database']
}
db = Connection(**CONFIG)
dbc = db.cursor()
db.set_character_set('utf8')
dbc.execute('SET NAMES utf8;')
dbc.execute('SET CHARACTER SET utf8;')
dbc.execute('SET character_set_connection=utf8;')
def usage():
print("\nThis is the usage function\n")
print("Usage: " + sys.argv[0] + " -f <file> or --data-file=<file>]")
def get_duplicate_name():
try:
dbc.execute(queries.FIND_PERSON_DUPLICATES)
def db(self):
return self.__db if isinstance(self.__db,Connection)\
else Connection(host=dbhost, user=dbuser, passwd=dbpass, db=dbname)
