!pip install mysqlclient
Collecting mysqlclient
Using cached mysqlclient-1.4.6.tar.gz (85 kB)
Using legacy setup.py install for mysqlclient, since package 'wheel' is not installed.
Installing collected packages: mysqlclient
Running setup.py install for mysqlclient ... error
ERROR: Command errored out with exit status 1:
command: /Users/wxnacy/.pyenv/versions/3.7.6/envs/notebook/bin/python3.7 -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/private/var/folders/kz/8syfctw919zdt3shr9w5j8v00000gn/T/pip-install-gzuju0kh/mysqlclient/setup.py'"'"'; __file__='"'"'/private/var/folders/kz/8syfctw919zdt3shr9w5j8v00000gn/T/pip-install-gzuju0kh/mysqlclient/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /private/var/folders/kz/8syfctw919zdt3shr9w5j8v00000gn/T/pip-record-7d7ia_ag/install-record.txt --single-version-externally-managed --compile --install-headers /Users/wxnacy/.pyenv/versions/3.7.6/envs/notebook/include/site/python3.7/mysqlclient
cwd: /private/var/folders/kz/8syfctw919zdt3shr9w5j8v00000gn/T/pip-install-gzuju0kh/mysqlclient/
Complete output (30 lines):
running install
running build
running build_py
creating build
creating build/lib.macosx-10.14-x86_64-3.7
creating build/lib.macosx-10.14-x86_64-3.7/MySQLdb
copying MySQLdb/__init__.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
copying MySQLdb/_exceptions.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
copying MySQLdb/compat.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
copying MySQLdb/connections.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
copying MySQLdb/converters.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
copying MySQLdb/cursors.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
copying MySQLdb/release.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
copying MySQLdb/times.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
creating build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
copying MySQLdb/constants/__init__.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
copying MySQLdb/constants/CLIENT.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
copying MySQLdb/constants/CR.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
copying MySQLdb/constants/ER.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
copying MySQLdb/constants/FLAG.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
running build_ext
building 'MySQLdb._mysql' extension
creating build/temp.macosx-10.14-x86_64-3.7
creating build/temp.macosx-10.14-x86_64-3.7/MySQLdb
clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -I/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include -I/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/include -Dversion_info=(1,4,6,'final',0) -D__version__=1.4.6 -I/usr/local/Cellar/mysql/5.7.19/include/mysql -I/Users/wxnacy/.pyenv/versions/3.7.6/envs/notebook/include -I/Users/wxnacy/.pyenv/versions/3.7.6/Python.framework/Versions/3.7/include/python3.7m -c MySQLdb/_mysql.c -o build/temp.macosx-10.14-x86_64-3.7/MySQLdb/_mysql.o
clang -bundle -undefined dynamic_lookup -L/usr/local/opt/readline/lib -L/usr/local/opt/readline/lib -L/Users/wxnacy/.pyenv/versions/3.7.6/lib -L/usr/local/opt/readline/lib -L/usr/local/opt/readline/lib -L/Users/wxnacy/.pyenv/versions/3.7.6/lib build/temp.macosx-10.14-x86_64-3.7/MySQLdb/_mysql.o -L/usr/local/Cellar/mysql/5.7.19/lib -lmysqlclient -lssl -lcrypto -o build/lib.macosx-10.14-x86_64-3.7/MySQLdb/_mysql.cpython-37m-darwin.so
ld: library not found for -lssl
clang: error: linker command failed with exit code 1 (use -v to see invocation)
error: command 'clang' failed with exit status 1
----------------------------------------
ERROR: Command errored out with exit status 1: /Users/wxnacy/.pyenv/versions/3.7.6/envs/notebook/bin/python3.7 -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/private/var/folders/kz/8syfctw919zdt3shr9w5j8v00000gn/T/pip-install-gzuju0kh/mysqlclient/setup.py'"'"'; __file__='"'"'/private/var/folders/kz/8syfctw919zdt3shr9w5j8v00000gn/T/pip-install-gzuju0kh/mysqlclient/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /private/var/folders/kz/8syfctw919zdt3shr9w5j8v00000gn/T/pip-record-7d7ia_ag/install-record.txt --single-version-externally-managed --compile --install-headers /Users/wxnacy/.pyenv/versions/3.7.6/envs/notebook/include/site/python3.7/mysqlclient Check the logs for full command output.
# pip install sqlalchemy pymysql
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
import config
SQLALCHEMY_DATABASE_URL = config.DATABASE_URL
engine = create_engine(
SQLALCHEMY_DATABASE_URL, connect_args={"check_same_thread": False}
)
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
Base = declarative_base()
--------------------------------------------------------------------------- ModuleNotFoundError Traceback (most recent call last) <ipython-input-5-173d78124eaf> in <module> 8 9 engine = create_engine( ---> 10 SQLALCHEMY_DATABASE_URL, connect_args={"check_same_thread": False} 11 ) 12 SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine) ~/.pyenv/versions/3.7.6/envs/notebook/lib/python3.7/site-packages/sqlalchemy/engine/__init__.py in create_engine(*args, **kwargs) 486 strategy = kwargs.pop("strategy", default_strategy) 487 strategy = strategies.strategies[strategy] --> 488 return strategy.create(*args, **kwargs) 489 490 ~/.pyenv/versions/3.7.6/envs/notebook/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py in create(self, name_or_url, **kwargs) 85 if k in kwargs: 86 dbapi_args[k] = pop_kwarg(k) ---> 87 dbapi = dialect_cls.dbapi(**dbapi_args) 88 89 dialect_args["dbapi"] = dbapi ~/.pyenv/versions/3.7.6/envs/notebook/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.py in dbapi(cls) 116 @classmethod 117 def dbapi(cls): --> 118 return __import__("MySQLdb") 119 120 def on_connect(self): ModuleNotFoundError: No module named 'MySQLdb'
from sqlalchemy import Boolean, Column, ForeignKey, Integer, String
class User(Base):
__tablename__ = 'test_user'
id = Column(Integer, primary_key = True)
name = Column(String, default="")
score = Column(Integer, default=0)
import sqlalchemy
for module in sqlalchemy, sqlalchemy.orm:
print(module.__all__)
for key in module.__all__:
print(key)
['ARRAY', 'BIGINT', 'BINARY', 'BLANK_SCHEMA', 'BLOB', 'BOOLEAN', 'BigInteger', 'Binary', 'Boolean', 'CHAR', 'CLOB', 'CheckConstraint', 'Column', 'ColumnDefault', 'Computed', 'Constraint', 'DATE', 'DATETIME', 'DDL', 'DECIMAL', 'Date', 'DateTime', 'DefaultClause', 'Enum', 'FLOAT', 'FetchedValue', 'Float', 'ForeignKey', 'ForeignKeyConstraint', 'INT', 'INTEGER', 'Index', 'Integer', 'Interval', 'JSON', 'LargeBinary', 'MetaData', 'NCHAR', 'NUMERIC', 'NVARCHAR', 'Numeric', 'PassiveDefault', 'PickleType', 'PrimaryKeyConstraint', 'REAL', 'SMALLINT', 'Sequence', 'SmallInteger', 'String', 'TEXT', 'TIME', 'TIMESTAMP', 'Table', 'Text', 'ThreadLocalMetaData', 'Time', 'TypeDecorator', 'Unicode', 'UnicodeText', 'UniqueConstraint', 'VARBINARY', 'VARCHAR', 'alias', 'all_', 'and_', 'any_', 'asc', 'between', 'bindparam', 'case', 'cast', 'collate', 'column', 'create_engine', 'delete', 'desc', 'distinct', 'engine_from_config', 'except_', 'except_all', 'exists', 'extract', 'false', 'func', 'funcfilter', 'insert', 'inspect', 'intersect', 'intersect_all', 'join', 'lateral', 'literal', 'literal_column', 'modifier', 'not_', 'null', 'nullsfirst', 'nullslast', 'or_', 'outerjoin', 'outparam', 'over', 'select', 'subquery', 'table', 'tablesample', 'text', 'true', 'tuple_', 'type_coerce', 'union', 'union_all', 'update', 'within_group'] ARRAY BIGINT BINARY BLANK_SCHEMA BLOB BOOLEAN BigInteger Binary Boolean CHAR CLOB CheckConstraint Column ColumnDefault Computed Constraint DATE DATETIME DDL DECIMAL Date DateTime DefaultClause Enum FLOAT FetchedValue Float ForeignKey ForeignKeyConstraint INT INTEGER Index Integer Interval JSON LargeBinary MetaData NCHAR NUMERIC NVARCHAR Numeric PassiveDefault PickleType PrimaryKeyConstraint REAL SMALLINT Sequence SmallInteger String TEXT TIME TIMESTAMP Table Text ThreadLocalMetaData Time TypeDecorator Unicode UnicodeText UniqueConstraint VARBINARY VARCHAR alias all_ and_ any_ asc between bindparam case cast collate column create_engine delete desc distinct engine_from_config except_ except_all exists extract false func funcfilter insert inspect intersect intersect_all join lateral literal literal_column modifier not_ null nullsfirst nullslast or_ outerjoin outparam over select subquery table tablesample text true tuple_ type_coerce union union_all update within_group ['AliasOption', 'AttributeExtension', 'Bundle', 'ColumnProperty', 'ComparableProperty', 'CompositeProperty', 'EXT_CONTINUE', 'EXT_SKIP', 'EXT_STOP', 'Load', 'Mapper', 'MapperExtension', 'PropComparator', 'Query', 'RelationshipProperty', 'Session', 'SessionExtension', 'SynonymProperty', 'aliased', 'backref', 'class_mapper', 'clear_mappers', 'close_all_sessions', 'column_property', 'comparable_property', 'compile_mappers', 'composite', 'configure_mappers', 'contains_alias', 'contains_eager', 'create_session', 'defaultload', 'defer', 'deferred', 'dynamic_loader', 'eagerload', 'eagerload_all', 'foreign', 'immediateload', 'join', 'joinedload', 'joinedload_all', 'lazyload', 'lazyload_all', 'load_only', 'make_transient', 'make_transient_to_detached', 'mapper', 'noload', 'object_mapper', 'object_session', 'outerjoin', 'polymorphic_union', 'public_factory', 'query_expression', 'raiseload', 'reconstructor', 'relation', 'relationship', 'remote', 'scoped_session', 'selectin_polymorphic', 'selectinload', 'selectinload_all', 'sessionmaker', 'subqueryload', 'subqueryload_all', 'synonym', 'undefer', 'undefer_group', 'validates', 'was_deleted', 'with_expression', 'with_parent', 'with_polymorphic'] AliasOption AttributeExtension Bundle ColumnProperty ComparableProperty CompositeProperty EXT_CONTINUE EXT_SKIP EXT_STOP Load Mapper MapperExtension PropComparator Query RelationshipProperty Session SessionExtension SynonymProperty aliased backref class_mapper clear_mappers close_all_sessions column_property comparable_property compile_mappers composite configure_mappers contains_alias contains_eager create_session defaultload defer deferred dynamic_loader eagerload eagerload_all foreign immediateload join joinedload joinedload_all lazyload lazyload_all load_only make_transient make_transient_to_detached mapper noload object_mapper object_session outerjoin polymorphic_union public_factory query_expression raiseload reconstructor relation relationship remote scoped_session selectin_polymorphic selectinload selectinload_all sessionmaker subqueryload subqueryload_all synonym undefer undefer_group validates was_deleted with_expression with_parent with_polymorphic