sqlalchemy python数据库实战 中文版_python处理数据库工具sqlalchemy

安装sqlalchemy

pip install sqlalchemy

数据库基本操作

数据库连接

使用create_engine创建数据库连接；

例子：

from sqlalchemy import create_engine

engine = create_engine('mysql+mysqlconnector://root:password@localhost:3306/test')

connect = engine.connect()

创建表

方法一：

from sqlalchemy import Table, MetaData, create_engine

engine = create_engine("mysql+mysqlconnector://root:password@localhost:3306/test")

metadata = MetaData(bind=engine)

t1 = Table('users',

metadata,

Column('id',INT, primary_key=True),

Column('name', String(20)),

Column('fullname', String(50)),

Column('password', String(20))

)

t2 = Table('address',

metadata,

Column('id',INT, primary_key = True),

Column('email_address',String(50), nullable=False),

Column('user_id', INT, ForeignKey('users.id'))

)

t1.create()

t2.create()

方法二

from sqlalchemy import Table, MetaData, create_engine

engine = create_engine("mysql+mysqlconnector://root:password@localhost:3306/test")

metadata = MetaData()

t1 =