sqlalchemy连接 MySQL（转）

1from sqlalchemy import create_engine,Table,Column,Integer,String,MetaData,ForeignKey
2engine=create_engine("mysql+pymysql://root:a5230411@localhost:3306/test",echo=True)
3metadata=MetaData(engine)
4
5user=Table('user',metadata,
6    Column('id',Integer,primary_key=True),
7    Column('name',String(20)),
8    Column('fullname',String(40)),
9    )
10address_table = Table('address', metadata,
11    Column('id', Integer, primary_key=True),
12    Column('user_id', None, ForeignKey('user.id')),
13    Column('email', String(128), nullable=False)
14    )
15
16metadata.create_all()
17
18from sqlalchemy import create_engine
19from sqlalchemy.ext.declarative import declarative_base
20from sqlalchemy import Column, Integer, String
21 
22 
23connect = create_engine("mysql+pymysql://root:123456@localhost:3306/mysql",
24                        encoding="utf-8",
25                        echo=True)  # 连接数据库，echo=True =>把所有的信息都打印出来
26 
27 
28Base = declarative_base()  # 生成ORM基类
29 
30 
31class User(Base):
32    __tablename__ = "hello_word"  # 表名
33    id = Column(Integer, primary_key=True)
34    name = Column(String(32))
35    password = Column(String(64))
36 
37Base.metadata.create_all(connect)   # 创建表结构

mysql语句建表

1CREATE TABLE user (
2    id INTEGER NOT NULL AUTO_INCREMENT,
3    name VARCHAR(32),
4    password VARCHAR(64),
5    PRIMARY KEY (id)
6)