def get_shop_loyalty_slides(app_id=None):
result = []
if app_id:
qry = ShopLoyaltySlide.gql(
"WHERE deleted=False AND has_apps=False ORDER BY timestamp DESC")
result.extend(generator(qry.run()))
qry = ShopLoyaltySlide.gql(
"WHERE deleted=False AND apps = :app_id ORDER BY timestamp DESC")
qry.bind(app_id=app_id)
result.extend(generator(qry.run()))
else:
qry = ShopLoyaltySlide.gql(
"WHERE deleted=False ORDER BY timestamp DESC")
result.extend(generator(qry.run()))
return result
def get_planned_reservations_by_user(service_user, service_identity, user,
from_):
service_identity_user = create_service_identity_user_wo_default(
service_user, service_identity)
return generator(RestaurantReservation.all().filter(
"service_user =", service_identity_user).filter('user', user).filter(
'status', RestaurantReservation.STATUS_PLANNED).filter(
'shift_start >=', from_))
def get_solution_loyalty_visits_for_lottery(service_user, service_identity,
app_user):
service_identity_user = create_service_identity_user_wo_default(
service_user, service_identity)
qry = SolutionLoyaltyVisitLottery.all().ancestor(
parent_key_unsafe(service_identity_user, SOLUTION_COMMON)).filter(
'redeemed =', False).filter('app_user =', app_user)
return generator(qry.run())
def get_broken_reservations(service_user, service_identity):
service_identity_user = create_service_identity_user_wo_default(
service_user, service_identity)
filter_ = RestaurantReservation.all().filter("service_user =",
service_identity_user)
return generator(
filter_.filter('status >=',
RestaurantReservation.STATUS_SHIFT_REMOVED))
def get_solution_loyalty_slides(service_user, service_identity):
service_identity_user = create_service_identity_user_wo_default(
service_user, service_identity)
qry = SolutionLoyaltySlide.gql(
"WHERE ANCESTOR IS :ancestor AND deleted=False ORDER BY timestamp DESC"
)
qry.bind(
ancestor=parent_key_unsafe(service_identity_user, SOLUTION_COMMON))
return generator(qry.run())
def get_reservations(service_user, service_identity, from_=None, until=None):
service_identity_user = create_service_identity_user_wo_default(
service_user, service_identity)
filter_ = RestaurantReservation.all().filter("service_user =",
service_identity_user)
if from_:
filter_ = filter_.filter('shift_start >=', from_)
if until:
filter_ = filter_.filter('shift_start <', until)
return generator(filter_)
def get_upcoming_planned_reservations_by_table(service_user, service_identity,
table_id, from_):
service_identity_user = create_service_identity_user_wo_default(
service_user, service_identity)
qry = RestaurantReservation.all().filter("service_user =",
service_identity_user)
qry.filter('tables =', table_id)
qry.filter('status', RestaurantReservation.STATUS_PLANNED)
qry.filter('shift_start >=', from_)
return generator(qry)
def get_solution_pharmacy_orders(service_user, service_identity):
service_identity_user = create_service_identity_user_wo_default(
service_user, service_identity)
qry = SolutionPharmacyOrder.gql(
"WHERE ANCESTOR IS :ancestor AND deleted = :deleted ORDER BY timestamp DESC"
)
qry.bind(ancestor=parent_key_unsafe(service_identity_user,
SOLUTION_COMMON),
deleted=False)
return generator(qry.run())
def get_solution_calendars(service_user,
solution,
filter_broadcast_disabled=False):
if filter_broadcast_disabled:
qry = SolutionCalendar.gql(
"WHERE ANCESTOR IS :ancestor AND deleted=False AND broadcast_enabled=True"
)
else:
qry = SolutionCalendar.gql(
"WHERE ANCESTOR IS :ancestor AND deleted=False")
qry.bind(ancestor=parent_key(service_user, solution))
return generator(qry.run())
def get_solution_repair_orders(service_user,
service_identity,
solution,
cursor=None):
service_identity_user = create_service_identity_user_wo_default(
service_user, service_identity)
qry = SolutionRepairOrder.gql(
"WHERE ANCESTOR IS :ancestor AND deleted=False ORDER BY timestamp DESC"
)
qry.with_cursor(cursor)
qry.bind(ancestor=parent_key_unsafe(service_identity_user, solution))
return generator(qry.run())
def get_solution_city_wide_lottery_loyalty_visits_for_user(
app_id, app_user, max_stamps=None, return_qry=False):
parent_key = SolutionCityWideLotteryVisit.create_city_parent_key(app_id)
qry = SolutionCityWideLotteryVisit.all() \
.ancestor(parent_key) \
.filter('redeemed =', False) \
.filter('app_user ='******'timestamp')
if return_qry:
return qry
return qry.fetch(max_stamps)
else:
return generator(qry.run())
def get_solution_loyalty_visits_for_revenue_discount(service_user,
service_identity,
app_user,
max_visits=None):
service_identity_user = create_service_identity_user_wo_default(
service_user, service_identity)
qry = SolutionLoyaltyVisitRevenueDiscount.all() \
.ancestor(parent_key_unsafe(service_identity_user, SOLUTION_COMMON)) \
.filter('redeemed =', False) \
.filter('app_user ='******'timestamp')
return qry.fetch(max_visits)
else:
qry.order('-timestamp')
return generator(qry.run())
def get_solution_loyalty_visits_for_stamps(service_user,
service_identity,
app_user,
max_stamps=None,
return_qry=False):
service_identity_user = create_service_identity_user_wo_default(
service_user, service_identity)
qry = SolutionLoyaltyVisitStamps.all() \
.ancestor(parent_key_unsafe(service_identity_user, SOLUTION_COMMON)) \
.filter('redeemed =', False) \
.filter('app_user ='******'timestamp')
if return_qry:
return qry
return qry.fetch(max_stamps)
else:
return generator(qry.run())
def get_service_api_callback_records(service_user):
qry = ServiceAPICallback.gql("WHERE ANCESTOR IS :ancestor")
qry.bind(ancestor=parent_key(service_user))
return generator(qry.run())
def get_service_menu_items(service_identity_user):
svc_user = get_service_user_from_service_identity_user(service_identity_user)
qry = ServiceMenuDef.gql("WHERE ANCESTOR IS :ancestor")
qry.bind(ancestor=parent_key(svc_user))
return generator(qry.run())
def get_service_identities(service_user):
qry = get_service_identities_query(service_user)
return generator(qry)
def get_limited_backlog(mobile, limit):
qry = RpcCAPICall.gql("WHERE ANCESTOR IS :ancestor ORDER BY priority DESC, timestamp ASC")
qry.bind(ancestor=get_rpc_capi_backlog_parent_by_mobile(mobile))
return generator(qry.fetch(limit))
def get_message_flow_designs_by_sub_flow_key(flow_key):
kind = MessageFlowDesign.kind()
azzert(flow_key.kind() == kind)
qry = MessageFlowDesign.gql("WHERE sub_flows = :flow AND ANCESTOR IS :ancestor AND deleted = false")
qry.bind(flow=flow_key, ancestor=flow_key.parent())
return generator(qry.run())
def get_user_friends(user):
_GET_USER_FRIENDS_QUERY.bind(ancestor=parent_key(user))
return generator(_GET_USER_FRIENDS_QUERY.run())
def get_event_list(service_user, solution):
qry = Event.gql("WHERE ANCESTOR IS :ancestor AND deleted=False")
qry.bind(ancestor=parent_key_unsafe(service_user, solution))
return generator(qry.run())
def get_shop_loyalty_slides_new_order():
return generator(ShopLoyaltySlideNewOrder.all())
def get_activation_log(min_timestamp, max_timestamp):
qry = ActivationLog.gql("WHERE timestamp > :min_timestamp AND timestamp < :max_timestamp ORDER BY timestamp DESC")
qry.bind(min_timestamp=min_timestamp, max_timestamp=max_timestamp)
return generator(qry.run())
def get_regex_callback_configurations(service_user):
return generator(ServiceCallBackConfiguration.all().ancestor(parent_key(service_user)).run())
def get_tables(service_user, service_identity):
service_identity_user = create_service_identity_user_wo_default(
service_user, service_identity)
return generator(RestaurantTable.all().ancestor(
parent_key_unsafe(service_identity_user,
SOLUTION_COMMON)).filter("deleted =", False))
def get_restaurant_reservation(service_user, service_identity, shift_start):
service_identity_user = create_service_identity_user_wo_default(
service_user, service_identity)
return generator(RestaurantReservation.all().filter(
"service_user =",
service_identity_user).filter('shift_start =', shift_start))
def get_transfer_chunks(transfer_result_key):
return generator(TransferChunk.all().ancestor(transfer_result_key).order("number").run(batch_size=10))
def get_filtered_backlog(mobile, method):
qry = RpcCAPICall.gql("WHERE ANCESTOR IS :ancestor AND method = :method ORDER BY priority DESC, timestamp ASC")
qry.bind(ancestor=get_rpc_capi_backlog_parent_by_mobile(mobile), method=method)
return generator(qry)
def get_all_statistics_by_service_user(service_user):
return generator(ServiceIdentityStatistic.all().ancestor(parent_key(service_user)).run())
def _get_list(size):
l = []
for i in range(size):
l.append(u'item %s' % i)
return generator(l)
def get_last_location_sharing_friends(user):
_GET_LAST_LOCATION_SHARING_FRIENDS.bind(ancestor=parent_key(user))
return generator(_GET_LAST_LOCATION_SHARING_FRIENDS.run())
def trans():
return generator(CurrentlyForwardingLogs.all().ancestor(CurrentlyForwardingLogs.create_parent_key()))
def get_public_event_list(service_user, solution):
qry = Event.gql(
"WHERE ANCESTOR IS :ancestor AND deleted=False AND source = :source")
qry.bind(ancestor=parent_key(service_user, solution),
source=Event.SOURCE_CMS)
return generator(qry.run())
def get_service_message_flow_designs(service_user):
qry = MessageFlowDesign.gql("WHERE ANCESTOR IS :ancestor and deleted = false ORDER BY multilanguage DESC, name ASC")
qry.bind(ancestor=parent_key(service_user))
return generator(qry.run())
def get_service_identities(service_user):
# type: (users.User) -> list[ServiceIdentity]
qry = get_service_identities_query(service_user)
return generator(qry)
def get_complete_backlog(mobile):
qry = RpcCAPICall.gql("WHERE ANCESTOR IS :ancestor")
qry.bind(ancestor=get_rpc_capi_backlog_parent_by_mobile(mobile))
return generator(qry.run())
