Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- python --version
- Python 3.5.2
- pip --version
- pip 9.0.1 from /usr/local/lib/python3.5/site-packages
- (python 3.5)
- pip install SQLAlchemy
- Requirement already satisfied: SQLAlchemy in
- /usr/local/lib/python3.5/site-packages
- pip install mysql-connector-python
- Requirement already satisfied:
- mysql-connector-python in /usr/local/lib/python3.5/site-packages
- >>> import sqlalchemy as s
- >>> s.__version__
- '1.1.4'
- >>>
- >>> import mysql.connector as msc
- >>> msc.__version__
- '2.2.1b1'
- from sqlalchemy import create_engine
- mysqlHost = '127.0.0.1'
- mysqlPort = 3306
- mysqlUser = 'root'
- mysqlPassword = 'password'
- mysqlDatabase = 'database';
- mysqlEngine = create_engine('mysql+mysqlconnector://{0}:{1}@{2}:{3}/{4}'.format(mysqlUser, mysqlPassword, mysqlHost, mysqlPort, mysqlDatabase), isolation_level = 'READ UNCOMMITTED', echo = False)
- mysqlConnection = mysqlEngine.connect()
- Traceback (most recent call last):
- File "mysql.py", line 12, in <module>
- mysqlEngine = create_engine('mysql+mysqlconnector://root:password@127.0.0.1/database', echo = False)
- File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/__init__.py", line 387, in create_engine
- return strategy.create(*args, **kwargs)
- File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/strategies.py", line 80, in create
- dbapi = dialect_cls.dbapi(**dbapi_args)
- File "/usr/local/lib/python3.5/site-packages/sqlalchemy/dialects/mysql/mysqlconnector.py", line 107, in dbapi
- from mysql import connector
- File "/var/www/accent/mysql.py", line 12, in <module>
- mysqlEngine = create_engine('mysql+mysqlconnector://root:password@127.0.0.1/database', echo = False)
- File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/__init__.py", line 387, in create_engine
- return strategy.create(*args, **kwargs)
- File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/strategies.py", line 80, in create
- dbapi = dialect_cls.dbapi(**dbapi_args)
- File "/usr/local/lib/python3.5/site-packages/sqlalchemy/dialects/mysql/mysqlconnector.py", line 107, in dbapi
- from mysql import connector
- ImportError: cannot import name 'connector'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement