一、创建数据库表格
建立Python文件alchemy5.py,代码如下:
#!/usr/bin/ python
#encoding:utf8
from sqlalchemy import *
from sqlalchemy.orm import *
#from sqlalchemy.ext.declarative import declarative_base
#功能:创建数据库表格,初始化数据库
#定义引擎
engine = create_engine('mysql+mysqlconnector://root:111111@localhost:3306/testalchemy')
#绑定元信息
metadata = MetaData(engine)
#创建表格,初始化数据库
user = Table('user', metadata,
Column('id', Integer, primary_key = True),
Column('name', String(20)),
Column('fullname', String(40)))
address = Table('address', metadata,
Column('id', Integer, primary_key = True),
Column('user_id', None, ForeignKey('user.id')),
Column('email', Strin