Python の sqlalchemy テーブル作成例 詳細

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

engine = create_engine('mysql+pymysql://godme:godme@localhost/godme',encoding='utf-8',echo=True) 

Base = declarative_base() 

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

__tablename__: specifies the table name
Column: row declaration, you can specify the primary key
Integer: data type
String: data type, can specify length

Base.metadata.create_all(engine)