本文整理汇总了Python中zookeepr.model.meta.Session.query方法的典型用法代码示例。如果您正苦于以下问题:Python Session.query方法的具体用法?Python Session.query怎么用?Python Session.query使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类zookeepr.model.meta.Session
的用法示例。
在下文中一共展示了Session.query方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: find_by_id
# 需要导入模块: from zookeepr.model.meta import Session [as 别名]
# 或者: from zookeepr.model.meta.Session import query [as 别名]
def find_by_id(cls, id, abort_404 = True, published = True):
if published:
result = Session.query(Schedule).filter_by(id=id).filter_by(published=published).first()
else:
result = Session.query(Schedule).filter_by(id=id).first()
if result is None and abort_404:
abort(404, "No such Schedule")
return result
示例2: find_by_id
# 需要导入模块: from zookeepr.model.meta import Session [as 别名]
# 或者: from zookeepr.model.meta.Session import query [as 别名]
def find_by_id(cls, id, abort_404 = True, published = True):
if published:
#I can't see why this exists as events as published, not schedules
#Original: result = Session.query(Schedule).filter_by(id=id).filter_by(published=published).first()
result = Session.query(Schedule).filter_by(id=id).first()
else:
result = Session.query(Schedule).filter_by(id=id).first()
if result is None and abort_404:
abort(404, "No such Schedule")
return result
示例3: find_next_proposal
# 需要导入模块: from zookeepr.model.meta import Session [as 别名]
# 或者: from zookeepr.model.meta.Session import query [as 别名]
def find_next_proposal(cls, id, type_id, signed_in_person_id):
withdrawn = FundingStatus.find_by_name('Withdrawn')
next = Session.query(Funding).from_statement("""
SELECT
f.id
FROM
(SELECT id
FROM funding
WHERE id <> %d
AND status_id <> %d
AND funding_type_id = %d
EXCEPT
SELECT funding_id AS id
FROM funding_review
WHERE funding_review.reviewer_id = %d) AS f
LEFT JOIN
funding_review AS r
ON(f.id=r.funding_id)
GROUP BY
f.id
ORDER BY COUNT(r.reviewer_id), RANDOM()
LIMIT 1
""" % (id, withdrawn.id, type_id, signed_in_person_id))
next = next.first()
if next is not None:
return next.id
else:
# looks like you've reviewed everything!
return None
示例4: find_accepted_by_id
# 需要导入模块: from zookeepr.model.meta import Session [as 别名]
# 或者: from zookeepr.model.meta.Session import query [as 别名]
def find_accepted_by_id(cls, id):
#status = ProposalStatus.find_by_name('Accepted')
#result = Session.query(Proposal).filter_by(id=id,status_id=status.id)
# Optimisation: assume that ProposalStatus of ID=1 is Accepted
result = Session.query(Proposal).filter_by(id=id,status_id=1).one()
return result
示例5: select_values
# 需要导入模块: from zookeepr.model.meta import Session [as 别名]
# 或者: from zookeepr.model.meta.Session import query [as 别名]
def select_values(self):
streams = Session.query(Stream).order_by(Stream.name).all()
values = [ (None, '(none)') ]
for stream in streams:
v = (stream.id, stream.name)
values.append(v)
return values
示例6: find_scheduled_by_date_and_type
# 需要导入模块: from zookeepr.model.meta import Session [as 别名]
# 或者: from zookeepr.model.meta.Session import query [as 别名]
def find_scheduled_by_date_and_type(cls, date, event_type):
from zookeepr.model.schedule import Schedule
from zookeepr.model.event import Event
from zookeepr.model.time_slot import TimeSlot
start = datetime.combine(date,time(0,0,0))
end = datetime.combine(date,time(23,59,59))
return Session.query(Location).join(Schedule).join(Event).join(TimeSlot).filter(Event.type==event_type).filter(TimeSlot.start_time.between(start, end)).order_by(Location.display_order).all()
示例7: find_by_date
# 需要导入模块: from zookeepr.model.meta import Session [as 别名]
# 或者: from zookeepr.model.meta.Session import query [as 别名]
def find_by_date(cls, date, primary=False):
start = datetime.combine(date, time(0, 0, 0))
end = datetime.combine(date, time(23, 59, 59))
if primary == True:
return (
Session.query(TimeSlot)
.filter(TimeSlot.start_time.between(start, end))
.filter(TimeSlot.primary == primary)
.order_by(TimeSlot.start_time)
.all()
)
else:
return (
Session.query(TimeSlot)
.filter(TimeSlot.start_time.between(start, end))
.order_by(TimeSlot.start_time)
.all()
)
示例8: find_all_by_funding_type_id
# 需要导入模块: from zookeepr.model.meta import Session [as 别名]
# 或者: from zookeepr.model.meta.Session import query [as 别名]
def find_all_by_funding_type_id(cls, id, abort_404 = True, include_withdrawn=True):
result = Session.query(Funding).filter_by(funding_type_id=id)
if not include_withdrawn:
withdrawn = FundingStatus.find_by_name('Withdrawn')
result = result.filter(Funding.status_id != withdrawn.id)
result = result.all()
if result is None and abort_404:
abort(404, "No such funding object")
return result
示例9: find_all_by_proposal_type_id
# 需要导入模块: from zookeepr.model.meta import Session [as 别名]
# 或者: from zookeepr.model.meta.Session import query [as 别名]
def find_all_by_proposal_type_id(cls, id, abort_404 = True, include_withdrawn=True):
result = Session.query(Proposal).filter_by(proposal_type_id=id)
if not include_withdrawn:
withdrawn = ProposalStatus.find_by_name('Withdrawn')
result = result.filter(Proposal.status_id != withdrawn.id)
result = result.all()
if result is None and abort_404:
abort(404, "No such proposal object")
return result
示例10: find_by_id
# 需要导入模块: from zookeepr.model.meta import Session [as 别名]
# 或者: from zookeepr.model.meta.Session import query [as 别名]
def find_by_id(cls, id, abort_404 = True):
result = Session.query(RegoRoom).filter_by(id=id).first()
if result is None and abort_404:
abort(404, "No such rego room object")
return result
示例11: find_by_code
# 需要导入模块: from zookeepr.model.meta import Session [as 别名]
# 或者: from zookeepr.model.meta.Session import query [as 别名]
def find_by_code(cls, code):
return Session.query(Voucher).filter_by(code=code).first()
示例12: find_all
# 需要导入模块: from zookeepr.model.meta import Session [as 别名]
# 或者: from zookeepr.model.meta.Session import query [as 别名]
def find_all(cls):
return Session.query(Voucher).order_by(Voucher.id).all()
示例13: find_by_id
# 需要导入模块: from zookeepr.model.meta import Session [as 别名]
# 或者: from zookeepr.model.meta.Session import query [as 别名]
def find_by_id(cls, id):
return Session.query(Ceiling).filter_by(id=id).first()
示例14: find_by_category
# 需要导入模块: from zookeepr.model.meta import Session [as 别名]
# 或者: from zookeepr.model.meta.Session import query [as 别名]
def find_by_category(cls, id):
return Session.query(Product).filter_by(category_id=id)
示例15: find_all
# 需要导入模块: from zookeepr.model.meta import Session [as 别名]
# 或者: from zookeepr.model.meta.Session import query [as 别名]
def find_all(self):
return Session.query(Product).order_by(Product.cost).all()