本文整理汇总了Python中c3smembership.data.model.base.c3smember.C3sMember.is_member_filter方法的典型用法代码示例。如果您正苦于以下问题：Python C3sMember.is_member_filter方法的具体用法？Python C3sMember.is_member_filter怎么用？Python C3sMember.is_member_filter使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类c3smembership.data.model.base.c3smember.C3sMember的用法示例。
在下文中一共展示了C3sMember.is_member_filter方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: get_invitees
# 需要导入模块: from c3smembership.data.model.base.c3smember import C3sMember [as 别名]
# 或者: from c3smembership.data.model.base.c3smember.C3sMember import is_member_filter [as 别名]
def get_invitees(cls, general_assembly_number, invitees_count):
"""
Gets a number of members which have not yet been invited to the general
assembly.
Queries the database for members, where:
- members are members
- members have not received their invitation email yet
Args:
general_assembly_number: Integer. The number of the general
assembly for which the invitees are returned.
invitees_count: Integer. Number of invitees returned at maximum.
Returns:
A list member objects.
"""
# pylint: disable=no-member
# In SqlAlchemy the True comparison must be done as "a == True" and not
# in the python default way "a is True". Therefore:
# pylint: disable=singleton-comparison
return (
# Get members
DBSession.query(C3sMember)
# combine with the general assembly requested as a cross join with
# the one general assembly row
.join(
GeneralAssembly,
GeneralAssembly.number == general_assembly_number)
# combine them with invitations for this member to this general
# assembly if any
.outerjoin(
GeneralAssemblyInvitation,
and_(
C3sMember.id == GeneralAssemblyInvitation.member_id,
GeneralAssemblyInvitation.general_assembly_id ==
GeneralAssembly.id
)
)
# but only
.filter(
and_(
# if no invitation has been sent
GeneralAssemblyInvitation.id == None,
# and the member has membership at the assmebly date
C3sMember.is_member_filter(GeneralAssembly.date),
)
)
# get as many as requested
.slice(0, invitees_count)
# and get all of the actual records
.all()
)