sqlalchemy 初始化数据库

初始化数据库
方法1

from sqlalchemy import create_engine, MetaData

engine = create_engine('sqlite:///foo.db', echo=True)

metadata = MetaData(engine)
metadata.create_all()

方法2

from sqlalchemy import create_engine 
from sqlalchemy.ext.declarative import declarative_base 

engine = create_engine('sqlite:///foo.db', echo=True)  # 创建连接

Base = declarative_base()  # 创建基类，以后在创建表的时候要继承这个类



Base.metadata.create_all(engine) 

2.创建表

from sqlalchemy import create_engine 
from sqlalchemy.ext.declarative import declarative_base 
from sqlalchemy import Column, Integer, String

engine = create_engine('sqlite:///foo.db', echo=True)

Base = declarative_base()

class User(Base):
    __tablename__ = 'user'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    password = Column(String)

Base.metadata.create_all(engine) 

参考文献：
http://www.jb51.net/article/125271.htm
https://www.pythoncentral.io/introductory-tutorial-python-sqlalchemy/