SQLAlchemy orm.query.Query

https://docs.sqlalchemy.org/en/13/orm/query.html#sqlalchemy.orm.query.Query

class sqlalchemy.orm.query.Query(entities, session=None)

通过Session.query()或者直接创建Query对象
例子

q = Query([User, Address], session=some_session)
q = some_session.query(User, Address)

方法	描述
sqlalchemy.orm.query.Query.init(entities, session=None)
sqlalchemy.orm.query.Query.add_column(column)
sqlalchemy.orm.query.Query.add_columns(*column)
sqlalchemy.orm.query.Query.add_entity(entity, alias=None)
sqlalchemy.orm.query.Query.all()	返回结果为list
sqlalchemy.orm.query.Query.as_scalar()
sqlalchemy.orm.query.Query.autoflush(setting)
sqlalchemy.orm.query.Query.column_descriptions
sqlalchemy.orm.query.Query.correlate(*args)
sqlalchemy.orm.query.Query.count()	返回多少行
sqlalchemy.orm.query.Query.cte(name=None, recursive=False)
sqlalchemy.orm.query.Query.delete(synchronize_session=‘evaluate’)
sqlalchemy.orm.query.Query.distinct(*expr)
sqlalchemy.orm.query.Query.enable_assertions(value)
sqlalchemy.orm.query.Query.enable_eagerloads(value)
sqlalchemy.orm.query.Query.except_(*q)
sqlalchemy.orm.query.Query.except_all(*q)
sqlalchemy.orm.query.Query.execution_options(**kwargs)
sqlalchemy.orm.query.Query.exists()
sqlalchemy.orm.query.Query.filter(*criterion)
sqlalchemy.orm.query.Query.filter_by(**kwargs)
sqlalchemy.orm.query.Query.first()
sqlalchemy.orm.query.Query.from_self(*entities)
sqlalchemy.orm.query.Query.from_statement(statement)
sqlalchemy.orm.query.Query.get(ident)
sqlalchemy.orm.query.Query.get_execution_options()
sqlalchemy.orm.query.Query.group_by(*criterion)
sqlalchemy.orm.query.Query.having(criterion)
sqlalchemy.orm.query.Query.instances(cursor, _Query__context=None)
sqlalchemy.orm.query.Query.intersect(*q)
sqlalchemy.orm.query.Query.intersect_all(*q)
sqlalchemy.orm.query.Query.is_single_entity
sqlalchemy.orm.query.Query.join(*props, **kwargs)
sqlalchemy.orm.query.Query.label(name)
sqlalchemy.orm.query.Query.lazy_loaded_from = None
sqlalchemy.orm.query.Query.limit(limit)
sqlalchemy.orm.query.Query.merge_result(iterator, load=True)
sqlalchemy.orm.query.Query.offset(offset)
sqlalchemy.orm.query.Query.one()
sqlalchemy.orm.query.Query.one_or_none()
sqlalchemy.orm.query.Query.only_return_tuples(value)
sqlalchemy.orm.query.Query.options(*args)
sqlalchemy.orm.query.Query.order_by(*criterion)
sqlalchemy.orm.query.Query.outerjoin(*props, **kwargs)
sqlalchemy.orm.query.Query.params(*args, **kwargs)
sqlalchemy.orm.query.Query.populate_existing()
sqlalchemy.orm.query.Query.prefix_with(*prefixes)
sqlalchemy.orm.query.Query.reset_joinpoint()
sqlalchemy.orm.query.Query.scalar()
sqlalchemy.orm.query.Query.select_entity_from(from_obj)
sqlalchemy.orm.query.Query.select_from(*from_obj)
sqlalchemy.orm.query.Query.selectable
sqlalchemy.orm.query.Query.slice(start, stop)
sqlalchemy.orm.query.Query.statement
sqlalchemy.orm.query.Query.subquery(name=None, with_labels=False, reduce_columns=False)
sqlalchemy.orm.query.Query.suffix_with(*suffixes)
sqlalchemy.orm.query.Query.union(*q)
sqlalchemy.orm.query.Query.union_all(*q)
sqlalchemy.orm.query.Query.update(values, synchronize_session=‘evaluate’, update_args=None)
sqlalchemy.orm.query.Query.value(column)
sqlalchemy.orm.query.Query.values(*columns)
sqlalchemy.orm.query.Query.whereclause
sqlalchemy.orm.query.Query.with_entities(*entities)
sqlalchemy.orm.query.Query.with_for_update(read=False, nowait=False, of=None, skip_locked=False, key_share=False)
sqlalchemy.orm.query.Query.with_hint(selectable, text, dialect_name=’*’)
sqlalchemy.orm.query.Query.with_labels()
sqlalchemy.orm.query.Query.with_lockmode(mode)
sqlalchemy.orm.query.Query.with_parent(instance, property=None, from_entity=None)
sqlalchemy.orm.query.Query.with_polymorphic(cls_or_mappers, selectable=None, polymorphic_on=None)¶
sqlalchemy.orm.query.Query.with_session(session)
sqlalchemy.orm.query.Query.with_statement_hint(text, dialect_name=’*’)
sqlalchemy.orm.query.Query.with_transformation(fn)
sqlalchemy.orm.query.Query.yield_per(count)