Sqlalchemy简单应用
from sqlalchemy import create_engine
engine = create_engine('mysql://root:123456@127.0.0.1:3306/sqlalchemy',echo=True)
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
from sqlalchemy import Column,Integer,String
class User(Base):
__tablename__ = 'users'
id = Column(Integer,primary_key=True)
name = Column(String(10))
User.metadata.create_all(engine)
from sqlalchemy.orm import sessionmaker
session = sessionmaker(bind=engine)
password = Column(String(10))
def __repr__(self):
return "<User(name='%s', name='%s', password='%s')>" % (self.id, self.name, self.password)
session = Session()
ed_user = User(id=2, name='ed', assword='edpassword')
session.add(ed_user)
session.commit()