def products_count_json(): is_available = param('available', bool) if is_available is not None and is_available: return jsonify_success( Product.query(Product.is_available == True).count()) if is_available is not None and not is_available: return jsonify_success( Product.query(Product.is_available != True).count()) return jsonify_success(Product.query().count())
def get_to_sync(): id_1c = param('id_1c') if id_1c is not None: products = Product.query(Product.to_sync == True).fetch( projection=[Product.id_1c]) return jsonify_success([key.id_1c for key in products]) products = Product.query(Product.to_sync == True).fetch(keys_only=True) return jsonify_success([key.id() for key in products])
def products_json(): is_available = param('available', bool) if is_available is not None: if is_available: products_q = Product.query(Product.is_available == True) else: products_q = Product.query(Product.is_available != True) else: products_q = Product.query() is_1c = param('id_1c') if is_1c is not None: return jsonify_success([ key.id_1c for key in products_q.fetch(projection=[Product.id_1c]) ]) return jsonify_success( [key.id() for key in products_q.fetch(keys_only=True)])
def products_dates_json(): date1 = param("from_date") date2 = param('to_date') if date1 is None: ApiException('Invalid request: parameter "from_date" not found.') date1 = datetime.strptime(date1, '%Y-%m-%d') if date2 is None: date2 = datetime.now() else: date2 = datetime.strptime(date2, '%Y-%m-%d') ApiException(date2) is_new = param('only_new') if is_new is None: products_q = Product.query( Product.modified >= date1, Product.modified <= date2).fetch(keys_only=True) else: products_q = Product.query( Product.created >= date1, Product.created <= date2).fetch(keys_only=True) return jsonify_success([key.id() for key in products_q])
def categories_json(): categories = [key.id() for key in Category.query().fetch(keys_only=True)] return jsonify_success(categories)
def categories_count_json(): return jsonify_success(Category.query().count())