Python之SqlAlchemy

標籤：format   mysql   實體   test   creat   span   實體類   IV   sel   

1.sqlalchemy是一個orm架構，並且大量使用元編程

import sqlalchemyfrom sqlalchemy import create_enginefrom sqlalchemy.ext.declarative import declarative_basefrom sqlalchemy import Column,Integer,Date,Stringconnect_string = "{}://{}:{}@{}:{}/{}".format(    ‘mysql+pymysql‘,    ‘test‘,    ‘1qazxsw2‘,    ‘127.0.0.1‘,    ‘3306‘,    ‘blog‘)engine = create_engine(connect_string,echo=True) Base = declarative_base()   #建立基類便於實體類繼承class Student(Base):    #指定表名    __tablename__ = ‘student‘    #定義屬性對應欄位    id = Column(Integer,primary_key=True,autoincrement=True)    name = Column(String(64),nullable=False)    age = Column(Integer)    def __repr__(self):        return ‘<{} id={},name={},age={}> ‘.format(self.__class__.__name__,self.id,self.name,self.age)#建立繼承自base的所有表Base.metadata.create_all(engine)

 

Python之SqlAlchemy