Advertisement
Guest User

Untitled

a guest
Nov 26th, 2016
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.10 KB | None | 0 0
  1. python --version
  2. Python 3.5.2
  3.  
  4. pip --version
  5. pip 9.0.1 from /usr/local/lib/python3.5/site-packages
  6. (python 3.5)
  7.  
  8. pip install SQLAlchemy
  9. Requirement already satisfied: SQLAlchemy in
  10. /usr/local/lib/python3.5/site-packages
  11.  
  12. pip install mysql-connector-python
  13. Requirement already satisfied:
  14. mysql-connector-python in /usr/local/lib/python3.5/site-packages
  15.  
  16. >>> import sqlalchemy as s
  17. >>> s.__version__
  18. '1.1.4'
  19. >>>
  20.  
  21. >>> import mysql.connector as msc
  22. >>> msc.__version__
  23. '2.2.1b1'
  24.  
  25. from sqlalchemy import create_engine
  26.  
  27. mysqlHost = '127.0.0.1'
  28. mysqlPort = 3306
  29. mysqlUser = 'root'
  30. mysqlPassword = 'password'
  31. mysqlDatabase = 'database';
  32.  
  33. mysqlEngine = create_engine('mysql+mysqlconnector://{0}:{1}@{2}:{3}/{4}'.format(mysqlUser, mysqlPassword, mysqlHost, mysqlPort, mysqlDatabase), isolation_level = 'READ UNCOMMITTED', echo = False)
  34.  
  35. mysqlConnection = mysqlEngine.connect()
  36.  
  37. Traceback (most recent call last):
  38. File "mysql.py", line 12, in <module>
  39. mysqlEngine = create_engine('mysql+mysqlconnector://root:password@127.0.0.1/database', echo = False)
  40. File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/__init__.py", line 387, in create_engine
  41. return strategy.create(*args, **kwargs)
  42. File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/strategies.py", line 80, in create
  43. dbapi = dialect_cls.dbapi(**dbapi_args)
  44. File "/usr/local/lib/python3.5/site-packages/sqlalchemy/dialects/mysql/mysqlconnector.py", line 107, in dbapi
  45. from mysql import connector
  46. File "/var/www/accent/mysql.py", line 12, in <module>
  47. mysqlEngine = create_engine('mysql+mysqlconnector://root:password@127.0.0.1/database', echo = False)
  48. File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/__init__.py", line 387, in create_engine
  49. return strategy.create(*args, **kwargs)
  50. File "/usr/local/lib/python3.5/site-packages/sqlalchemy/engine/strategies.py", line 80, in create
  51. dbapi = dialect_cls.dbapi(**dbapi_args)
  52. File "/usr/local/lib/python3.5/site-packages/sqlalchemy/dialects/mysql/mysqlconnector.py", line 107, in dbapi
  53. from mysql import connector
  54. ImportError: cannot import name 'connector'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement