I am trying to make and connect to a local database. I am using Anaconda version 1.6.14 together with python 3.6.5 - I already have 5.7.23 installed in my path, together with mysqlclient==1.3.13.
import os
cwd = os.getcwd()
config_path = cwd + '/config.ini_sample'
print(config_path)
import configparser
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
config_fields = ['host', 'port', 'user', 'passwd', 'database', 'sql_type',
'charset']
def read_config():
config = configparser.ConfigParser()
with open(str(config_path)) as fp:
config.read_file(fp)
actual_config_fields = config['Global'].keys()
missing = set(config_fields) - actual_config_fields
if missing:
print('The configuration file (%s) ' % str(config_path) +
'is invalid. ' +
'Missing fields %s' % (', '.join(map(repr, missing))))
raise Exception
return config
def setup_database_connection():
global _engine, _session
config = read_config()
connection_url = ("{sql_type}://{user}:{passwd}@{host}:{port}/"
"{database}?charset={charset}")
connection_url = connection_url.format(**config['Global'])
_engine = create_engine(connection_url, encoding='utf-8')
_session = sessionmaker(bind=engine)
setup_database_connection()
config.ini.sample is
[Global]
host = localhost
user = your_user
port = 3306
passwd = your_pass
charset = utf8
database = erhvervsdata
sql_type = mysql
and the error
---------------------------------------------------------------------------
ImportError Traceback (most recent call last)
<ipython-input-4-6dff59dfc481> in <module>
35 _session = sessionmaker(bind=engine)
36
---> 37 setup_database_connection()
38
<ipython-input-4-6dff59dfc481> in setup_database_connection()
32 "{database}?charset={charset}")
33 connection_url = connection_url.format(**config['Global'])
---> 34 _engine = create_engine(connection_url, encoding='utf-8')
35 _session = sessionmaker(bind=engine)
36
/anaconda3/envs/Virk/lib/python3.6/site-packages/sqlalchemy/engine/__init__.py in create_engine(*args, **kwargs)
423 strategy = kwargs.pop('strategy', default_strategy)
424 strategy = strategies.strategies[strategy]
--> 425 return strategy.create(*args, **kwargs)
426
427
/anaconda3/envs/Virk/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py in create(self, name_or_url, **kwargs)
79 if k in kwargs:
80 dbapi_args[k] = pop_kwarg(k)
---> 81 dbapi = dialect_cls.dbapi(**dbapi_args)
82
83 dialect_args['dbapi'] = dbapi
/anaconda3/envs/Virk/lib/python3.6/site-packages/sqlalchemy/dialects/mysql/mysqldb.py in dbapi(cls)
100 @classmethod
101 def dbapi(cls):
--> 102 return __import__('MySQLdb')
103
104 def do_executemany(self, cursor, statement, parameters, context=None):
/anaconda3/envs/Virk/lib/python3.6/site-packages/MySQLdb/__init__.py in <module>
16 from MySQLdb.release import __version__, version_info, __author__
17
---> 18 import _mysql
19
20 if version_info != _mysql.version_info:
ImportError: dlopen(/anaconda3/envs/Virk/lib/python3.6/site-packages/_mysql.cpython-36m-darwin.so, 2): Library not loaded: @rpath/libssl.1.0.0.dylib
Referenced from: /anaconda3/envs/Virk/lib/python3.6/site-packages/_mysql.cpython-36m-darwin.so
Reason: image not found
