from sqlalchemy.ext.declarative import declarative_base
BASE = declarative_base()
class User(BASE):
__tablename__ = "users"
id = Column(INTEGER, primary_key=True)
name = Column(CHAR(127))
password = Column(CHAR(127))
from sqlalchemy.orm import sessionmaker
from sqlalchemy import create_engine
ENGINE = create_engine("mysql://root:zaq12wsx@localhost:3306/mydb?charset=utf8",
convert_unicode=True)
Session = sessionmaker(bind=ENGINE, autocommit=False, autoflush=False)
session = Session()
user = User()
user.name = "user1"
user.password = "password"
session.add(user)
session.commit()
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
from sqlalchemy import Column, Integer, String
def declarative_base(bind=None, metadata=None, mapper=None, cls=object,
name='Base', constructor=_declarative_constructor,
class_registry=None,
metaclass=DeclarativeMeta):
class _BoundDeclarativeMeta(DeclarativeMeta):
def __init__(self, name, bases, d):
bind_key = d.pop('__bind_key__', None)
DeclarativeMeta.__init__(self, name, bases, d)
if bind_key is not None:
self.__table__.info['bind_key'] = bind_key
def make_declarative_base(self, metadata=None):
"""Creates the declarative base."""
base = declarative_base(cls=Model, name='Model',
metadata=metadata,
metaclass=_BoundDeclarativeMeta)
base.query = _QueryProperty(self)
return base
AdABCModelBase = make_declarative_base()
class ABCAuth(AdABCModelBase):
'''
ABC 授权
'''
__tablename__ = 'ABC_auth'
__bind_key__ = 'ABC'
__model_version__ = '2018-06-07'
id = Column(BigInteger, primary_key=True)
# ABCProductLibrary/ABCBehaviour id
target_id = Column(BigInteger, default=0)
type = Column(SmallInteger, default=0)
av_id = Column(BigInteger, default=0)
available = Column(Boolean, default=True)
isdel = Column(Boolean, default=False)
create_time = Column(DateTime)
modify_time = Column(DateTime)
from sqlalchemy.orm import Session
session = Session(engine)
query = session.query(ABCAuth)
query = ABCVideoPackage.query.filter(ABCVideoPackage.status != ABCVideoPackageStatus.DELETED)