SQLALCHEM 初始化数据库

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

WIN = sys.platform.startswith('win')
if WIN:
    prefix = 'sqlite:///'
else:
    prefix = 'sqlite:////'
    
engine = create_engine(prefix + 'data.db', echo=True)

Base = declarative_base()
    

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String(60))
    age = Column(Integer)
  
  
Base.metadata.create_all(engine)