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())