Skip to main content

python3 base API client for shopware6

Project description

lib_shopware6_api_base

Version v2.1.9 as of 2024-09-30 see Changelog

build_badge codeql license pypi PyPI - Downloads black codecov Maintainability Maintainability Code Coverage snyk

this is a basic API client for shopware6 which can be used on windows, Linux, MacOs. It supports all available authorisation types to the Admin and Storefront API. Paginated requests are supported.

This is only the basic abstraction layer, to enjoy higher level functions, check out “lib_shopware6_api”

On github it can be only tested on linux, because we can not run a docker shopware container service on MacOS or Windows.


automated tests, Github Actions, Documentation, Badges, etc. are managed with PizzaCutter (cookiecutter on steroids)

Python version required: 3.8.0 or newer

tested on recent linux with python 3.8, 3.9, 3.10, 3.11, 3.12, pypy-3.9, pypy-3.10, graalpy-24.1 - architectures: amd64

100% code coverage, flake8 style checking ,mypy static type checking ,tested under Linux, automatic daily builds and monitoring



Usage

configuration

the configuration is passed to the client as a configuration object of the type “ConfShopware6ApiBase” simply copy the Class definition of “ConfShopware6ApiBase” and create Your own configuration file, for instance “my_shop_config.py”

import attrs


@attrs.define
class ConfShopware6ApiBase(object):
    # the api url, like : 'https://shop.yourdomain.com/api'
    shopware_admin_api_url: str = ""
    # the storefront api url, like : 'https://shop.yourdomain.com/store-api'
    shopware_storefront_api_url: str = ""

    """
    Admin API:
    for User Credentials Grant Type:
    ==================================
    - with refresh token
    - we recommend to only use this grant flow for client applications that should
      perform administrative actions and require a user-based authentication

    """
    username: str = ""
    password: str = ""

    """
    Admin API:
    for Resource Owner Password Grant Type:
    =======================================
    - no refresh token
    - should be used for machine-to-machine communications, such as CLI jobs or automated services
    see https://shopware.stoplight.io/docs/admin-api/ZG9jOjEwODA3NjQx-authentication-and-authorisation
    setup via Web Administration Interface > settings > system > integration: "access_id" and "access_secret"
    or directly via URL : https://shop.yourdomain.com/admin#/sw/integration/index
    """
    # the client ID, setup at Web Administration Interface > settings > system > integration > access_id
    client_id: str = ""
    # the client secret, setup at Web Administration Interface > settings > system > integration > access_secret
    client_secret: str = ""

    """
    Admin API:
    Grant Type to use:
    ==================
    which grant type to use - can be either 'user_credentials'- or 'resource_owner'
    """
    grant_type: str = ""

    """
    Store API:
    sw-access-key set in Administration/Sales Channels/API
    """
    store_api_sw_access_key: str = ""

now You can use this configuration:

from lib_shopware6_api_base import Shopware6AdminAPIClientBase
from my_shop_config import ConfShopware6ApiBase

my_conf = ConfShopware6ApiBase()
my_api_client = Shopware6AdminAPIClientBase(config=my_conf)
...
  • test configuration

for testing we use the dockware docker container, see : dockware

on gitHub actions the dockware docker test container is installed as a service and is available for communication on localhost

You can start the dockware container locally with the command : sudo docker run -d –rm -p 80:80 –name dockware dockware/dev:latest

now You can test against that container with :

my_api_client = Shopware6AdminAPIClientBase(use_docker_test_container=True)
...

methods

please note, that on github actions the test configuration is used automatically, therefore on all examples no configuration is passed on purpose.

methods which take the parameter ‘payload’, the payload is of following type :

PayLoad = Union[None, Dict[str, Any], Criteria]

for the definition of “Criteria” see Query Syntax

headers

Endpoints like /api/_action/sync require request specific custom headers to manipulate the api behavior

see : Bulk Payloads Performance and Bulk edit entities in the Admin API Documentation

You may pass such custom header fields like that :

# only for python version >= 3.8:
update_header_fields = HEADER_write_in_single_transactions | HEADER_index_asynchronously

#   or the same for python 3.7:
update_header_fields: dict = dict()
update_header_fields.update(HEADER_index_asynchronously)
update_header_fields.update(HEADER_write_in_single_transactions)

#   or the same written explicitly for python 3.7:
update_heater_fields = {'single-operation' : 'true', 'indexing-behavior' : 'use-queue-indexing'}

# and pass those "update_heater_fields" to the request method parameter
# (mostly "request_post", with endpoint "/api/_action/sync")

following header fields are pre-defined :

HEADER_write_in_separate_transactions: Dict[str, str] = {"single-operation": "false"}  # default
HEADER_write_in_single_transactions: Dict[str, str] = {"single-operation": "true"}
HEADER_index_synchronously: Dict[str, str] = {"indexing-behavior": "null"}  # default
HEADER_index_asynchronously: Dict[str, str] = {"indexing-behavior": "use-queue-indexing"}
HEADER_index_disabled: Dict[str, str] = {"indexing-behavior": "disable-indexing"}
HEADER_fail_on_error: Dict[str, str] = {"fail-on-error": "true"}  # default
HEADER_do_not_fail_on_error: Dict[str, str] = {"fail-on-error": "false"}

Store API

class Shopware6StoreFrontClientBase(object):
    def __init__(self, config: Optional[ConfShopware6ApiBase] = None, use_docker_test_container: bool = False) -> None:
        """
        the Shopware6 Storefront Base API

        :param config:  You can pass a configuration object here.
                        If not given and gitHub actions is detected, or use_docker_test_container == True:
                            conf_shopware6_api_docker_testcontainer.py will be loaded automatically
                        If not given and no gitHub actions is detected:
                            conf_shopware6_api_base_rotek.py will be loaded automatically

        :param use_docker_test_container:   if True, and no config is given, the dockware config will be loaded

        >>> # Test to load automatic configuration
        >>> my_storefront_client = Shopware6StoreFrontClientBase()

        >>> # Test pass configuration
        >>> if _is_github_actions():
        ...     my_config = _load_config_for_docker_test_container()
        ...     my_storefront_client = Shopware6StoreFrontClientBase(config=my_config)

        """
  • Store API Get

def request_get(self, request_url: str, payload: PayLoad = None, update_header_fields: Optional[Dict[str, str]] = None) -> Dict[str, Any]:
    """
    make a get request

    parameters:
        request_url: API Url, without the common api prefix
        payload : a dictionary
        update_header_fields: allows to modify or add header fields

    returns
        response_dict: dictionary with the response as dict

    >>> # Setup
    >>> my_storefront_client = Shopware6StoreFrontClientBase()

    >>> # test GET a dictionary
    >>> my_response = my_storefront_client.request_get(request_url='context')

    >>> # test GET a List
    >>> my_response = my_storefront_client.request_get(request_url='sitemap')
    Traceback (most recent call last):
        ...
    conf_shopware6_api_base_classes.ShopwareAPIError: received a list instead of a dict - You need to use the method request_get_list

    """
  • Store API Get List

def request_get_list(self, request_url: str, payload: PayLoad = None, update_header_fields: Optional[Dict[str, str]] = None) -> List[Dict[str, Any]]:
    """
    make a get request, expecting a list of dictionaries as result

    parameters:
        request_url: API Url, without the common api prefix
        payload : a dictionary
        update_header_fields: allows to modify or add header fields

    returns
        List[response_dict]: a list of dictionaries

    >>> # Setup
    >>> my_storefront_client = Shopware6StoreFrontClientBase()

    >>> # test GET a List
    >>> my_response = my_storefront_client.request_get_list(request_url='sitemap')

    >>> # test GET a dictionary
    >>> my_response = my_storefront_client.request_get_list(request_url='context')
    Traceback (most recent call last):
        ...
    conf_shopware6_api_base_classes.ShopwareAPIError: received a dict instead of a list - You need to use the method request_get


    """
  • Store API Patch

def request_patch(self, request_url: str, payload: PayLoad = None, update_header_fields: Optional[Dict[str, str]] = None) -> Dict[str, Any]:
    """
    makes a patch request

    parameters:
        request_url: API Url, without the common api prefix
        payload : a dictionary
        update_header_fields: allows to modify or add header fields

    returns
        response_dict: dictionary with the response as dict

    """
  • Store API Post

def request_post(self, request_url: str, payload: PayLoad = None, update_header_fields: Optional[Dict[str, str]] = None) -> Dict[str, Any]:
    """
    make a post request

    parameters:
        request_url: API Url, without the common api prefix
        payload : a dictionary
        update_header_fields: allows to modify or add header fields

    returns
        response_dict: dictionary with the response as dict

    >>> # Setup
    >>> my_storefront_client = Shopware6StoreFrontClientBase()

    >>> # test POST without payload
    >>> my_response = my_storefront_client.request_post(request_url='product')
    >>> assert 'elements' in my_response

    >>> # test POST with payload
    >>> # see : https://shopware.stoplight.io/docs/store-api/b3A6ODI2NTY4MQ-fetch-a-list-of-products
    >>> my_payload = Criteria()
    >>> my_payload.filter.append(EqualsFilter(field='active', value='true'))
    >>> my_response = my_storefront_client.request_post(request_url='product', payload=my_payload)
    >>> assert 'elements' in my_response

    """
  • Store API Put

def request_put(self, request_url: str, payload: PayLoad = None, update_header_fields: Optional[Dict[str, str]] = None) -> Dict[str, Any]:
    """
    make a put request

    parameters:
        http_method: get, post, put, delete
        request_url: API Url, without the common api prefix
        payload : a dictionary
        update_header_fields: allows to modify or add header fields

    returns
        response_dict: dictionary with the response as dict

    """
  • Store API Delete

def request_delete(self, request_url: str, payload: PayLoad = None, update_header_fields: Optional[Dict[str, str]] = None) -> Dict[str, Any]:
    """
    make a delete request

    parameters:
        http_method: get, post, put, delete
        request_url: API Url, without the common api prefix
        payload : a dictionary
        update_header_fields: allows to modify or add header fields

    returns
        response_dict: dictionary with the response as dict

    """

Admin API

class Shopware6AdminAPIClientBase(object):
    def __init__(self, config: Optional[ConfShopware6ApiBase] = None, use_docker_test_container: bool = False) -> None:
        """
        the Shopware6 Admin Base API

        :param config:  You can pass a configuration object here.
                If not given and gitHub actions is detected, or use_docker_test_container == True:
                    conf_shopware6_api_docker_testcontainer.py will be loaded automatically
                If not given and no gitHub actions is detected:
                    conf_shopware6_api_base_rotek.py will be loaded automatically

        :param use_docker_test_container:   if True, and no config is given, the dockware config will be loaded

        >>> # Setup
        >>> my_api_client = Shopware6AdminAPIClientBase()

        """
  • Admin API GET

def request_get(self, request_url: str, payload: PayLoad = None, update_header_fields: Optional[Dict[str, str]] = None) -> Dict[str, Any]:
    """
    makes a get request

    parameters:
        request_url: API Url, without the common api prefix
        payload : a dictionary
        update_header_fields: allows to modify or add header fields

    returns
        response_dict: dictionary with the response as dict

    >>> # Setup
    >>> my_api_client = Shopware6AdminAPIClientBase()

    >>> # test resource owner token
    >>> ignore = my_api_client._get_access_token_by_user_credentials()
    >>> my_api_client._get_session()
    >>> ignore = my_api_client.request_get('customer-group')  # noqa

    >>> # test resource owner token refresh
    >>> my_access_token = my_api_client.token['access_token']
    >>> my_api_client.token['expires_in']=-1
    >>> my_api_client.token['expires_at']=time.time()-1
    >>> ignore = my_api_client.request_get('customer-group')
    >>> assert my_api_client.token['access_token'] != my_access_token

    >>> # Test client credentials token
    >>> ignore = my_api_client._get_access_token_by_resource_owner()
    >>> my_api_client._get_session()
    >>> ignore = my_api_client.request_get('customer-group')  # noqa

    >>> # test client credentials token refresh
    >>> my_access_token = my_api_client.token['access_token']
    >>> my_api_client.token['expires_in']=-1
    >>> my_api_client.token['expires_at']=time.time()-1
    >>> ignore = my_api_client.request_get('customer-group')
    >>> assert my_api_client.token['access_token'] != my_access_token

    """
  • Admin API GET Paginated

def request_get_paginated(
    self, request_url: str, payload: PayLoad = None, junk_size: int = 100, update_header_fields: Optional[Dict[str, str]] = None
) -> Dict[str, Any]:
    """
    get the data paginated - metadata 'total' and 'totalCountMode' will be updated
    the paginated request reads those records in junks of junk_size=100 for performance reasons.

    payload "limit" will be respected (meaning we deliver only 'limit' results back)
    payload "page" will be ignored

    parameters:
        request_url: API Url, without the common api prefix
        payload : a dictionary
        limit : the junk size
        update_header_fields: allows to modify or add header fields

    returns
        response_dict: dictionary with the response as dict

    >>> # Setup
    >>> my_api_client = Shopware6AdminAPIClientBase()

    >>> # test read product junk_size=3, limit = 4
    >>> my_payload={'limit': 4}
    >>> my_response_dict = my_api_client.request_get_paginated(request_url='product', payload=my_payload, junk_size=3)
    >>> assert 4 == len(my_response_dict['data'])

    >>> # test read product junk_size=3, no limit
    >>> my_response_dict = my_api_client.request_get_paginated(request_url='product', junk_size=3)
    >>> assert 3 < len(my_response_dict['data'])

    >>> # test read product junk_size=3, limit = 2
    >>> my_payload={'limit': 2}
    >>> my_response_dict = my_api_client.request_get_paginated(request_url='product', payload=my_payload, junk_size=3)
    >>> assert 2 == len(my_response_dict['data'])

    >>> # test read product junk_size=3, limit = 4
    >>> my_payload={'limit': 4}
    >>> my_response_dict = my_api_client.request_get_paginated(request_url='product', payload=my_payload, junk_size=3)
    >>> assert 4 == len(my_response_dict['data'])

    >>> # test read product junk_size=10, limit = None
    >>> my_payload=Criteria()
    >>> my_response_dict = my_api_client.request_get_paginated(request_url='product', payload=my_payload, junk_size=10)
    >>> assert 5 < len(my_response_dict['data'])
    """
  • Admin API PATCH

def request_patch(
    self,
    request_url: str,
    payload: PayLoad = None,
    content_type: str = "json",
    additional_query_params: Optional[Dict[str, Any]] = None,
    update_header_fields: Optional[Dict[str, str]] = None,
) -> Dict[str, Any]:
    """
    makes a patch request

    parameters:
        request_url: API Url, without the common api prefix
        payload : a dictionary or bytes
        content_type: any valid content type like json, octet-stream, ...
        additional_query_params: additional query parameters for patch, post, put, delete
        update_header_fields: allows to modify or add header fields

    returns
        response_dict: dictionary with the response as dict

    """
  • Admin API POST

def request_post(
    self,
    request_url: str,
    payload: PayLoad = None,
    content_type: str = "json",
    additional_query_params: Optional[Dict[str, Any]] = None,
    update_header_fields: Optional[Dict[str, str]] = None,
) -> Dict[str, Any]:
    """
    makes a post request

    parameters:
        request_url: API Url, without the common api prefix
        payload : a dictionary or bytes
        content_type: any valid content type like json, octet-stream, ...
        additional_query_params: additional query parameters for patch, post, put, delete
        update_header_fields: allows to modify or add header fields

    returns
        response_dict: dictionary with the response as dict

    """
  • Admin API POST PAGINATED

def request_post_paginated(
    self, request_url: str, payload: PayLoad = None, junk_size: int = 100, update_header_fields: Optional[Dict[str, str]] = None
) -> Dict[str, Any]:
    """
    post the data paginated - metadata 'total' and 'totalCountMode' will be updated
    if You expect a big number of records, the paginated request reads those records in junks of junk_size=100 for performance reasons.

    payload "limit" will be respected (meaning we deliver only 'limit' results back)
    payload "page" will be ignored

    parameters:
        request_url: API Url, without the common api prefix
        payload : a dictionary
        junk_size : the junk size
        update_header_fields: allows to modify or add header fields

    returns
        response_dict: dictionary with the response as dict

    >>> # Setup
    >>> my_api_client = Shopware6AdminAPIClientBase()
    >>> my_url = 'search/product'

    >>> # test read product junk_size=10, limit = None
    >>> my_payload=Criteria()
    >>> my_response_dict = my_api_client.request_post_paginated(request_url=my_url, payload=my_payload, junk_size=10)
    >>> assert 5 < len(my_response_dict['data'])

    >>> # test read product junk_size=10, no limit
    >>> my_payload=None
    >>> my_response_dict = my_api_client.request_post_paginated(request_url=my_url, payload=my_payload, junk_size=10)
    >>> assert 10 < len(my_response_dict['data'])

    >>> # test read product junk_size=3, limit = 2
    >>> my_payload={'limit': 2}
    >>> my_response_dict = my_api_client.request_post_paginated(request_url=my_url, payload=my_payload, junk_size=3)
    >>> assert 2 == len(my_response_dict['data'])

    >>> # test read product junk_size=3, limit = 4
    >>> my_payload={'limit': 4}
    >>> my_response_dict = my_api_client.request_post_paginated(request_url=my_url, payload=my_payload, junk_size=3)
    >>> assert 4 == len(my_response_dict['data'])

    >>> # search for orders
    >>> # test https://github.com/bitranox/lib_shopware6_api_base/issues/11
    >>> import pprint
    >>> date_from = '2024-09-29T00:00:00.000Z'
    >>> date_to = '2024-09-29T23:59:59.999Z'
    >>> my_criteria = Criteria()
    >>> my_criteria.filter.append(RangeFilter(field="orderDate", parameters = {'gte': date_from, 'lte': date_to}))
    >>> my_criteria.filter.append(MultiFilter('or', [
    ...     EqualsFilter(field='documents.documentType.technicalName', value='invoice'),
    ...     EqualsFilter(field='documents.documentType.technicalName', value='storno')]))
    >>> pprint_attrs(my_criteria)
    {'limit': None,
     'page': None,
     'filter': [{'type': 'range',
                 'field': 'orderDate',
                 'parameters': {'gte': '2024-09-29T00:00:00.000Z',
                                'lte': '2024-09-29T23:59:59.999Z'}},
                {'type': 'multi',
                 'operator': 'or',
                 'queries': [{'type': 'equals',
                              'field': 'documents.documentType.technicalName',
                              'value': 'invoice'},
                             {'type': 'equals',
                              'field': 'documents.documentType.technicalName',
                              'value': 'storno'}]}],
     'term': None,
     'total_count_mode': None}
    >>> my_response_dict = my_api_client.request_post_paginated(request_url='search/order', payload=my_criteria)
    >>> pprint.pprint(my_response_dict)
    {'data': []}
    """
  • Admin API PUT

def request_put(
    self,
    request_url: str,
    payload: PayLoad = None,
    content_type: str = "json",
    additional_query_params: Optional[Dict[str, Any]] = None,
    update_header_fields: Optional[Dict[str, str]] = None,
) -> Dict[str, Any]:
    """
    makes a put request

    parameters:
        http_method: get, post, put, delete
        request_url: API Url, without the common api prefix
        payload : a dictionary or bytes
        content_type: any valid content type like json, octet-stream, ...
        additional_query_params: additional query parameters for patch, post, put, delete
        update_header_fields: allows to modify or add header fields

    returns
        response_dict: dictionary with the response as dict

    """
  • Admin API DELETE

def request_delete(
    self,
    request_url: str,
    payload: PayLoad = None,
    additional_query_params: Optional[Dict[str, Any]] = None,
    update_header_fields: Optional[Dict[str, str]] = None,
) -> Dict[str, Any]:
    """
    makes a delete request

    parameters:
        http_method: get, post, put, delete
        request_url: API Url, without the common api prefix
        payload : a dictionary
        additional_query_params: additional query parameters for patch, post, put, delete
        update_header_fields: allows to modify or add header fields

    returns
        response_dict: dictionary with the response as dict

    """

Query Syntax

The querying syntax closely resembling the one from the internal DAL. If you’re familiar with Shopware 6 DAL syntax and how to retrieve it, you might see the examples are predictable and straightforward

a search criteria follows the following schema:

@attrs.define
class Criteria:
    """
    see: https://shopware.stoplight.io/docs/store-api/ZG9jOjEwODExNzU2-search-queries

    structure of Criteria:

    parameter:

    aggregations  List[Aggregation]                    Specify aggregations to be computed on-the-fly
    associations  Dict['<name>', 'Criteria']           Allows to load additional data to the standard data of an entity
    filter        List[Filter]                         Allows you to filter the result and aggregations
    grouping      List['<fieldname>']                  allows you to group the result over fields
    ids           List['<id>']                         Limits the search to a list of Ids
    includes      Dict['apiAlias', List[<fieldname>]]  Restricts the output to the defined fields
    limit         Optional[int]                        Defines the number of entries to be determined
    page          Optional[int]                        Defines at which page the search result should start
    post-filter                           not implemented at the moment
    query         List[Query]                          Enables you to determine a ranking for the search result
    sort          List[Sort]                           Defines the sorting of the search result
    term          Optional[str]                        text search on all records based on their data model and weighting
                                                       Don't use term parameters together with query parameters.
    total-count-mode    Optional[int]                  Defines whether a total must be determined


    >>> # Test empty
    >>> my_criteria = Criteria()
    >>> pprint_attrs(my_criteria)
    {'limit': None, 'page': None, 'term': None, 'total_count_mode': None}

    >>> # Test Average aggregation
    >>> my_criteria = Criteria()
    >>> my_criteria.limit=1
    >>> my_criteria.includes['product'] = ['id', 'name']
    >>> my_criteria.aggregations = [AvgAggregation('average-price', 'price')]
    >>> pprint_attrs(my_criteria)
    {'limit': 1,
     'page': None,
     'aggregations': [{'name': 'average-price', 'type': 'avg', 'field': 'price'}],
     'includes': {'product': ['id', 'name']},
     'term': None,
     'total_count_mode': None}

    >>> # Test Filter aggregation
    >>> my_criteria = Criteria(limit=1, includes={'product':['id', 'name']},
    ...     aggregations=[FilterAggregation(name='active-price-avg',
    ...                                    filter=[EqualsFilter(field='active', value=True)],
    ...                                    aggregation=AvgAggregation(name='avg-price',field='price'))])
    >>> pprint_attrs(my_criteria)
    {'limit': 1,
     'page': None,
     'aggregations': [{'name': 'active-price-avg',
                       'type': 'filter',
                       'filter': [{'type': 'equals',
                                   'field': 'active',
                                   'value': True}],
                       'aggregation': {'name': 'avg-price',
                                       'type': 'avg',
                                       'field': 'price'}}],
     'includes': {'product': ['id', 'name']},
     'term': None,
     'total_count_mode': None}

    >>> # Association{{{
    >>> # Test Association
    >>> my_criteria = Criteria()
    >>> my_criteria.associations['products'] = Criteria(limit=5, filter=[EqualsFilter('active', 'true')])
    >>> pprint_attrs(my_criteria)
    {'limit': None,
     'page': None,
     'associations': {'products': {'limit': 5,
                                   'page': None,
                                   'filter': [{'type': 'equals',
                                               'field': 'active',
                                               'value': 'true'}],
                                   'term': None,
                                   'total_count_mode': None}},
     'term': None,
     'total_count_mode': None}
    >>> # Association}}}

    >>> # Test append filters
    >>> my_criteria = Criteria()
    >>> my_criteria.page = 0
    >>> my_criteria.limit=1
    >>> my_criteria.filter.append(EqualsFilter('a', 'a'))
    >>> my_criteria.filter.append(EqualsFilter('b', 'b'))
    >>> my_criteria.filter.append(EqualsFilter('d', 'd'))
    >>> pprint_attrs(my_criteria)
    {'limit': 1,
     'page': 0,
     'filter': [{'type': 'equals', 'field': 'a', 'value': 'a'},
                {'type': 'equals', 'field': 'b', 'value': 'b'},
                {'type': 'equals', 'field': 'd', 'value': 'd'}],
     'term': None,
     'total_count_mode': None}

    >>> # Test set filters
    >>> my_criteria = Criteria()
    >>> my_criteria.filter = [EqualsFilter('a', 'a'), EqualsFilter('b', 'b'), EqualsFilter('d', 'd')]
    >>> pprint_attrs(my_criteria)
    {'limit': None,
     'page': None,
     'filter': [{'type': 'equals', 'field': 'a', 'value': 'a'},
                {'type': 'equals', 'field': 'b', 'value': 'b'},
                {'type': 'equals', 'field': 'd', 'value': 'd'}],
     'term': None,
     'total_count_mode': None}

    >>> # Grouping{{{
    >>> # Test Grouping
    >>> my_criteria = Criteria()
    >>> my_criteria.limit=5
    >>> my_criteria.grouping=['active']
    >>> pprint_attrs(my_criteria)
    {'limit': 5,
     'page': None,
     'grouping': ['active'],
     'term': None,
     'total_count_mode': None}
    >>> # Grouping}}}

    >>> # ids{{{
    >>> # Test ids
    >>> # note that the limit is automatically set to 3, and page to 1, which is for our paginated request
    >>> my_criteria = Criteria()
    >>> my_criteria.ids=["012cd563cf8e4f0384eed93b5201cc98", "075fb241b769444bb72431f797fd5776", "090fcc2099794771935acf814e3fdb24"]
    >>> pprint_attrs(my_criteria)
    {'limit': None,
     'page': None,
     'ids': ['012cd563cf8e4f0384eed93b5201cc98',
             '075fb241b769444bb72431f797fd5776',
             '090fcc2099794771935acf814e3fdb24'],
     'term': None,
     'total_count_mode': None}

    >>> # Test ids with a limit already set, which should fail
    >>> # You can use either "limit" or "ids", but not both, see : https://github.com/bitranox/lib_shopware6_api_base#ids
    >>> my_criteria = Criteria()
    >>> my_criteria.limit = 5
    >>> my_criteria.ids=["012cd563cf8e4f0384eed93b5201cc98", "075fb241b769444bb72431f797fd5776", "090fcc2099794771935acf814e3fdb24"]
    Traceback (most recent call last):
        ...
    ValueError: You can use either "limit" or "ids", but not both, ...

    >>> # Test to set limit after ids are passed, which should fail
    >>> # You can use either "limit" or "ids", but not both, see : https://github.com/bitranox/lib_shopware6_api_base#ids
    >>> my_criteria = Criteria()
    >>> my_criteria.ids=["012cd563cf8e4f0384eed93b5201cc98", "075fb241b769444bb72431f797fd5776", "090fcc2099794771935acf814e3fdb24"]
    >>> my_criteria.limit = 2
    Traceback (most recent call last):
        ...
    ValueError: You can use either "limit" or "ids", but not both, ...

    >>> # ids}}}

    >>> # includes{{{
    >>> # Test includes
    >>> my_criteria = Criteria()
    >>> my_criteria.includes['product'] = ['id', 'name']
    >>> pprint_attrs(my_criteria)
    {'limit': None,
     'page': None,
     'includes': {'product': ['id', 'name']},
     'term': None,
     'total_count_mode': None}

    >>> # includes}}}

    >>> # page&limit{{{
    >>> my_criteria = Criteria(page=1, limit=5)
    >>> pprint_attrs(my_criteria)
    {'limit': 5, 'page': 1, 'term': None, 'total_count_mode': None}

    >>> # page&limit}}}

    >>> # Test Query
    >>> my_criteria = Criteria(
    ...    query=[Query(score=500, query=ContainsFilter(field='name', value='Bronze')),
    ...           Query(score=500, query=EqualsFilter(field='active', value='true')),
    ...           Query(score=100, query=EqualsFilter(field='manufacturerId', value='db3c17b1e572432eb4a4c881b6f9d68f'))])
    >>> pprint_attrs(my_criteria)
    {'limit': None,
     'page': None,
     'query': [{'score': 500,
                'query': {'type': 'contains', 'field': 'name', 'value': 'Bronze'}},
               {'score': 500,
                'query': {'type': 'equals', 'field': 'active', 'value': 'true'}},
               {'score': 100,
                'query': {'type': 'equals',
                          'field': 'manufacturerId',
                          'value': 'db3c17b1e572432eb4a4c881b6f9d68f'}}],
     'term': None,
     'total_count_mode': None}

    >>> # Test Sorting
    >>> my_criteria = Criteria(limit=5,
    ...                        sort=[FieldSorting('name', 'ASC', True),
    ...                              DescFieldSorting('active')])
    >>> pprint_attrs(my_criteria)
    {'limit': 5,
     'page': None,
     'sort': [{'field': 'name', 'order': 'ASC', 'naturalSorting': True},
              {'field': 'active', 'order': 'DESC', 'naturalSorting': None}],
     'term': None,
     'total_count_mode': None}

    """

Aggregations

back to Query Syntax

AvgAggregation

back to Aggregations

@attrs.define
class AvgAggregation:
    """
    see aggregations reference : https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/aggregations-reference
    The Avg aggregation makes it possible to calculate the average value for a field.
    The following SQL statement is executed in the background: AVG(price).

    :parameter:
        name: str
        field: str

    >>> # Test
    >>> my_aggregation = AvgAggregation('avg-price', 'price')
    >>> pprint_attrs(my_aggregation)
    {'name': 'avg-price', 'type': 'avg', 'field': 'price'}

    """

CountAggregation

back to Aggregations

@attrs.define
class CountAggregation:
    """
    see aggregations reference : https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/aggregations-reference
    The count aggregation makes it possible to determine the number of entries for a field that are filled with a value.
    The following SQL statement is executed in the background: COUNT(DISTINCT(manufacturerId)).

    :parameter:
        name: str
        field: str

    >>> # Test
    >>> my_aggregation = CountAggregation('count-manufacturers', 'manufacturerId')
    >>> pprint_attrs(my_aggregation)
    {'name': 'count-manufacturers', 'type': 'count', 'field': 'manufacturerId'}

    """

MaxAggregation

back to Aggregations

@attrs.define
class MaxAggregation:
    """
    see aggregations reference : https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/aggregations-reference
    The max aggregation allows you to determine the maximum value of a field.
    The following SQL statement is executed in the background: MAX(price).

    :parameter:
        name: str
        field: str

    >>> # Test
    >>> my_aggregation = MaxAggregation('max-price', 'price')
    >>> pprint_attrs(my_aggregation)
    {'name': 'max-price', 'type': 'max', 'field': 'price'}

    """

MinAggregation

back to Aggregations

@attrs.define
class MinAggregation:
    """
    see aggregations reference : https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/aggregations-reference
    The min aggregation makes it possible to determine the minimum value of a field.
    The following SQL statement is executed in the background: MIN(price)

    :parameter:
        name: str
        field: str

    >>> # Test
    >>> my_aggregation = MinAggregation('min-price', 'price')
    >>> pprint_attrs(my_aggregation)
    {'name': 'min-price', 'type': 'min', 'field': 'price'}

    """

SumAggregation

back to Aggregations

@attrs.define
class SumAggregation:
    """
    see aggregations reference : https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/aggregations-reference
    The sum aggregation makes it possible to determine the total of a field.
    The following SQL statement is executed in the background: SUM(price)

    :parameter:
        name: str
        field: str

    >>> # Test
    >>> my_aggregation = SumAggregation('sum-price', 'price')
    >>> pprint_attrs(my_aggregation)
    {'name': 'sum-price', 'type': 'sum', 'field': 'price'}

    """

StatsAggregation

back to Aggregations

@attrs.define
class StatsAggregation:
    """
    see aggregations reference : https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/aggregations-reference
    The stats aggregation makes it possible to calculate several values at once for a field.
    This includes the previous max, min, avg and sum aggregation.
    The following SQL statement is executed in the background: SELECT MAX(price), MIN(price), AVG(price), SUM(price)

    :parameter:
        name: str
        field: str

    >>> # Test
    >>> my_aggregation = StatsAggregation('stats-price', 'price')
    >>> pprint_attrs(my_aggregation)
    {'name': 'stats-price', 'type': 'stats', 'field': 'price'}

    """

TermsAggregation

back to Aggregations

@attrs.define
class TermsAggregation:
    """
    see aggregations reference : https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/aggregations-reference

    The terms aggregation belongs to the bucket aggregations.
    This allows you to determine the values of a field.
    The result contains each value once and how often this value occurs in the result.
    The terms aggregation also supports the following parameters:
        limit - Defines a maximum number of entries to be returned (default: zero)
        sort - Defines the order of the entries. By default the following is not sorted
        aggregation - Enables you to calculate further aggregations for each key
    The following SQL statement is executed in the background: SELECT DISTINCT(manufacturerId) as key, COUNT(manufacturerId) as count


    :parameter:
        name: str
        field: str
        sort: Optional[SortType]
        limit: Optional[int]
        aggregation: Optional[]

    >>> # Test
    >>> my_aggregation = TermsAggregation(name='manufacturer-ids', limit=3, sort=DescFieldSorting('manufacturer.name'), field='manufacturerId')
    >>> pprint_attrs(my_aggregation)
    {'name': 'manufacturer-ids',
     'type': 'terms',
     'field': 'manufacturerId',
     'sort': {'field': 'manufacturer.name',
              'order': 'DESC',
              'naturalSorting': None},
     'limit': 3,
     'aggregation': None}

    """

FilterAggregation

back to Aggregations

@attrs.define
class FilterAggregation:
    """
    see aggregations reference : https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/aggregations-reference

    The filter aggregation belongs to the bucket aggregations.
    Unlike all other aggregations, this aggregation does not determine any result, it cannot be used alone.
    It is only used to further restrict the result of an aggregation in a criterion.
    Filters which defined inside the filter property of this aggregation type,
    are only used when calculating this aggregation.
    The filters have no effect on other aggregations or on the result of the search.

    parameter:
        name: str
        sort: SortType
        filter: List of FilterType
        aggregation : AggregationType

    >>> # Test
    >>> my_aggregation = FilterAggregation(
    ...     name='active-price-avg',
    ...     filter=[EqualsFilter(field='active', value=True)],
    ...     aggregation=AvgAggregation(name='avg-price',field='price'))
    >>> pprint_attrs(my_aggregation)
    {'name': 'active-price-avg',
     'type': 'filter',
     'filter': [{'type': 'equals', 'field': 'active', 'value': True}],
     'aggregation': {'name': 'avg-price', 'type': 'avg', 'field': 'price'}}

    """

EntityAggregation

back to Aggregations

@attrs.define
class EntityAggregation:
    """
    see aggregations reference : https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/aggregations-reference

    The entity aggregation is similar to the terms aggregation, it belongs to the bucket aggregations.
    As with terms aggregation, all unique values are determined for a field.
    The aggregation then uses the determined keys to load the defined entity. The keys are used here as ids.

    :parameter:
        name: str
        definition: str
        field: str

    >>> # Test
    >>> my_aggregation = EntityAggregation(name='manufacturers', definition='product_manufacturer', field='manufacturerId')
    >>> pprint_attrs(my_aggregation)
    {'name': 'manufacturers',
     'type': 'entity',
     'definition': 'product_manufacturer',
     'field': 'manufacturerId'}
    """

DateHistogramAggregation

back to Aggregations

@attrs.define
class DateHistogramAggregation:
    """
    see aggregations reference : https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/aggregations-reference

    The histogram aggregation is used as soon as the data to be determined refers to a date field.
    With the histogram aggregation,
    one of the following date intervals can be given: minute, hour, day, week, month, quarter, year, day.
    This interval groups the result and calculates the corresponding count of hits.

    :parameter:
        name: str
        field: str
        interval: str ,  possible values: 'minute', 'hour', 'day', 'week', 'month', 'quarter', 'year', 'day'

    >>> # Test
    >>> my_aggregation = DateHistogramAggregation(name='release-dates', field='releaseDate', interval='month')
    >>> pprint_attrs(my_aggregation)
    {'name': 'release-dates',
     'type': 'histogram',
     'field': 'releaseDate',
     'interval': 'month'}

    """

NestingAggregations

back to Aggregations

"""
see: https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/aggregations-reference#nesting-aggregations
"""

Associations

back to Query Syntax

The associations parameter allows you to load additional data to the minimal data set of an entity without sending an extra request - similar to a SQL Join. The key of the parameter is the property name of the association in the entity. You can pass a nested criteria just for that association - e.g. to perform a sort to or apply filters within the association.

>>> # Test Association
>>> my_criteria = Criteria()
>>> my_criteria.associations['products'] = Criteria(limit=5, filter=[EqualsFilter('active', 'true')])
>>> pprint_attrs(my_criteria)
{'limit': None,
 'page': None,
 'associations': {'products': {'limit': 5,
                               'page': None,
                               'filter': [{'type': 'equals',
                                           'field': 'active',
                                           'value': 'true'}],
                               'term': None,
                               'total_count_mode': None}},
 'term': None,
 'total_count_mode': None}
>>>

Filters

back to Query Syntax

EqualsFilter

back to Filters

@attrs.define
class EqualsFilter:
    """
    see filter reference : https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/filters-reference
    The Equals filter allows you to check fields for an exact value.
    The following SQL statement is executed in the background: WHERE stock = 10.

    :parameter:
        field: str
        value: Union[str, int]      # probably also bool

    >>> # Test
    >>> my_filter = EqualsFilter('stock', 10)
    >>> pprint_attrs(my_filter)
    {'type': 'equals', 'field': 'stock', 'value': 10}

    >>> my_filter = EqualsFilter('stock', None)
    >>> pprint_attrs(my_filter)
    {'type': 'equals', 'field': 'stock', 'value': None}

    """

EqualsAnyFilter

back to Filters

@attrs.define
class EqualsAnyFilter:
    """
    see filter reference : https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/filters-reference
    The EqualsAny filter allows you to filter a field where at least one of the defined values matches exactly.
    The following SQL statement is executed in the background:
    WHERE productNumber IN ('3fed029475fa4d4585f3a119886e0eb1', '77d26d011d914c3aa2c197c81241a45b').

    :parameter:
        field: str
        value: List[str]

    >>> # Test Keyword param
    >>> my_filter = EqualsAnyFilter(field = 'productNumber', value = ["3fed029475fa4d4585f3a119886e0eb1", "77d26d011d914c3aa2c197c81241a45b"])
    >>> pprint_attrs(my_filter)
    {'type': 'equalsAny',
     'field': 'productNumber',
     'value': ['3fed029475fa4d4585f3a119886e0eb1',
               '77d26d011d914c3aa2c197c81241a45b']}

    >>> # Test positional param
    >>> my_filter = EqualsAnyFilter('productNumber', ["3fed029475fa4d4585f3a119886e0eb1", "77d26d011d914c3aa2c197c81241a45b"])
    >>> pprint_attrs(my_filter)
    {'type': 'equalsAny',
     'field': 'productNumber',
     'value': ['3fed029475fa4d4585f3a119886e0eb1',
               '77d26d011d914c3aa2c197c81241a45b']}

    """

ContainsFilter

back to Filters

@attrs.define
class ContainsFilter:
    """
    see filter reference : https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/filters-reference
    The Contains Filter allows you to filter a field to an approximate value, where the passed value must be contained as a full value.
    The following SQL statement is executed in the background: WHERE name LIKE '%Lightweight%'.

    :parameter:
        field: str
        value: List[str]

    >>> # Test
    >>> my_filter = ContainsFilter(field = 'productNumber', value = 'Lightweight')
    >>> pprint_attrs(my_filter)
    {'type': 'contains', 'field': 'productNumber', 'value': 'Lightweight'}

    """

RangeFilter

back to Filters

@attrs.define
class RangeFilter:
    """
    see filter reference : https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/filters-reference
    The Range filter allows you to filter a field to a value space. This can work with date or numerical values.
    Within the parameter property the following values are possible:
        gte => Greater than equals  (You might pass 'gte' or range_filter.gte)
        lte => Less than equals     (You might pass 'lte' or range_filter.lte)
        gt => Greater than          (You might pass 'gt' or range_filter.gt)
        lt => Less than             (You might pass 'lt' or range_filter.lt)

    :parameter:
        field: str
        parameters: Dict[str, Union[int, datetime]]

    >>> # Test (pass range type as string)
    >>> my_filter = RangeFilter(field = 'stock', parameters = {'gte': 20, 'lte': 30})
    >>> pprint_attrs(my_filter)
    {'type': 'range', 'field': 'stock', 'parameters': {'gte': 20, 'lte': 30}}

    >>> # Test (pass range type from 'range_filter' object)
    >>> my_filter = RangeFilter(field = 'stock', parameters = {range_filter.gte: 20, range_filter.lte: 30})
    >>> pprint_attrs(my_filter)
    {'type': 'range', 'field': 'stock', 'parameters': {'gte': 20, 'lte': 30}}

    >>> # Test (wrong range)
    >>> my_filter = RangeFilter(field = 'stock', parameters = {'gte': 20, 'less': 30})
    Traceback (most recent call last):
        ...
    ValueError: "less" is not a valid range

    """

NotFilter

back to Filters

@attrs.define
class NotFilter:
    """
    see filter reference : https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/filters-reference
    The Not Filter is a container which allows to negate any kind of filter.
    The operator allows you to define the combination of queries within the NOT filter ("OR" and "AND").
    The following SQL statement is executed in the background: WHERE !(stock = 1 OR availableStock = 1):

    :parameter:
        operator: 'or' | 'and'
        queries: List[Filter]

    >>> # Test (pass operator as string)
    >>> my_filter = NotFilter('or', [EqualsFilter('stock', 1), EqualsFilter('availableStock', 10)])
    >>> pprint_attrs(my_filter)
    {'type': 'not',
     'operator': 'or',
     'queries': [{'type': 'equals', 'field': 'stock', 'value': 1},
                 {'type': 'equals', 'field': 'availableStock', 'value': 10}]}

    >>> # Test (pass operator from 'not_filter_operator' object)
    >>> my_filter = NotFilter(not_filter_operator.or_, [EqualsFilter('stock', 1), EqualsFilter('availableStock', 10)])
    >>> pprint_attrs(my_filter)
    {'type': 'not',
     'operator': 'or',
     'queries': [{'type': 'equals', 'field': 'stock', 'value': 1},
                 {'type': 'equals', 'field': 'availableStock', 'value': 10}]}

    >>> # Test unknown operator
    >>> my_filter = NotFilter('duck', [EqualsFilter('stock', 1), EqualsFilter('availableStock', 10)])
    Traceback (most recent call last):
        ...
    ValueError: ("'operator' must be in ['and', 'or'] (got 'duck')", ...)

    """

MultiFilter

back to Filters

@attrs.define
class MultiFilter:
    """
    see filter reference : https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/filters-reference
    The Multi Filter is a container, which allows to set logical links between filters.
    The operator allows you to define the links between the queries within the Multi filter ("OR" and "AND").
    The following SQL statement is executed in the background: WHERE (stock = 1 OR availableStock = 1)

    :parameter:
        operator: 'or' | 'and'
        queries: List[Filter]

    >>> # Test (pass operator as string)
    >>> my_filter = MultiFilter('or', [EqualsFilter('stock', 1), EqualsFilter('availableStock', 10)])
    >>> pprint_attrs(my_filter)
    {'type': 'multi',
     'operator': 'or',
     'queries': [{'type': 'equals', 'field': 'stock', 'value': 1},
                 {'type': 'equals', 'field': 'availableStock', 'value': 10}]}

    >>> # Test (pass operator from 'not_filter_operator' object)
    >>> my_filter = MultiFilter(multi_filter_operator.or_, [EqualsFilter('stock', 1), EqualsFilter('availableStock', 10)])
    >>> pprint_attrs(my_filter)
    {'type': 'multi',
     'operator': 'or',
     'queries': [{'type': 'equals', 'field': 'stock', 'value': 1},
                 {'type': 'equals', 'field': 'availableStock', 'value': 10}]}

    >>> # Test unknown operator
    >>> my_filter = MultiFilter('duck', [EqualsFilter('stock', 1), EqualsFilter('availableStock', 10)])
    Traceback (most recent call last):
        ...
    ValueError: ("'operator' must be in ['and', 'or'] (got 'duck')", ...)

    """

PrefixFilter

back to Filters

@attrs.define
class PrefixFilter:
    """
    see filter reference : https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/filters-reference
    The Prefix Filter allows you to filter a field to an approximate value, where the passed value must be the start of a full value.
    The following SQL statement is executed in the background: WHERE name LIKE 'Lightweight%'.

    :parameter:
        field: str
        value: str

    >>> # Test
    >>> my_filter = PrefixFilter('name', 'Lightweight')
    >>> pprint_attrs(my_filter)
    {'type': 'prefix', 'field': 'name', 'value': 'Lightweight'}

    """

SuffixFilter

back to Filters

@attrs.define
class SuffixFilter:
    """
    see filter reference : https://developer.shopware.com/docs/resources/references/core-reference/dal-reference/filters-reference
    The Suffix Filter allows you to filter a field to an approximate value, where the passed value must be the end of a full value.
    The following SQL statement is executed in the background: WHERE name LIKE '%Lightweight'.

    :parameter:
        field: str
        value: str

    >>> # Test
    >>> my_filter = SuffixFilter('name', 'Lightweight')
    >>> pprint_attrs(my_filter)
    {'type': 'suffix', 'field': 'name', 'value': 'Lightweight'}

    """

Grouping

back to Query Syntax

The grouping parameter allows you to group the result over fields. It can be used to realise queries such as:

  • Fetch one product for each manufacturer

  • Fetch one order per day and customer

>>> # Test Grouping
>>> my_criteria = Criteria()
>>> my_criteria.limit=5
>>> my_criteria.grouping=['active']
>>> pprint_attrs(my_criteria)
{'limit': 5,
 'page': None,
 'grouping': ['active'],
 'term': None,
 'total_count_mode': None}
>>>

ids

back to Query Syntax

If you want to perform a simple lookup using just the ids of records, you can pass a list of those using the ids field. Please note that as soon as You use ids, limit and page does not apply anymore !

>>> # Test ids
>>> # note that the limit is automatically set to 3, and page to 1, which is for our paginated request
>>> my_criteria = Criteria()
>>> my_criteria.ids=["012cd563cf8e4f0384eed93b5201cc98", "075fb241b769444bb72431f797fd5776", "090fcc2099794771935acf814e3fdb24"]
>>> pprint_attrs(my_criteria)
{'limit': None,
 'page': None,
 'ids': ['012cd563cf8e4f0384eed93b5201cc98',
         '075fb241b769444bb72431f797fd5776',
         '090fcc2099794771935acf814e3fdb24'],
 'term': None,
 'total_count_mode': None}

>>> # Test ids with a limit already set, which should fail
>>> # You can use either "limit" or "ids", but not both, see : https://github.com/bitranox/lib_shopware6_api_base#ids
>>> my_criteria = Criteria()
>>> my_criteria.limit = 5
>>> my_criteria.ids=["012cd563cf8e4f0384eed93b5201cc98", "075fb241b769444bb72431f797fd5776", "090fcc2099794771935acf814e3fdb24"]
Traceback (most recent call last):
    ...
ValueError: You can use either "limit" or "ids", but not both, ...

>>> # Test to set limit after ids are passed, which should fail
>>> # You can use either "limit" or "ids", but not both, see : https://github.com/bitranox/lib_shopware6_api_base#ids
>>> my_criteria = Criteria()
>>> my_criteria.ids=["012cd563cf8e4f0384eed93b5201cc98", "075fb241b769444bb72431f797fd5776", "090fcc2099794771935acf814e3fdb24"]
>>> my_criteria.limit = 2
Traceback (most recent call last):
    ...
ValueError: You can use either "limit" or "ids", but not both, ...

>>>

includes

back to Query Syntax

The includes parameter allows you to restrict the returned fields.

Transfer only what you need - reduces response payload Easier to consume for client applications When debugging, the response is smaller and you can concentrate on the essential fields

>>> # Test includes
>>> my_criteria = Criteria()
>>> my_criteria.includes['product'] = ['id', 'name']
>>> pprint_attrs(my_criteria)
{'limit': None,
 'page': None,
 'includes': {'product': ['id', 'name']},
 'term': None,
 'total_count_mode': None}

>>>

All response types come with a apiAlias field which you can use to identify the type in your includes field.

If you only want a categories id, add: “category”: [“id”].

For entities, this is the entity name: product, product_manufacturer, order_line_item, …

For other non-entity-types like a listing result or a line item, check the full response. This pattern applies not only to simple fields but also to associations.

page & limit

back to Query Syntax

The page and limit parameters can be used to control pagination. The page parameter is 1-indexed. Please note that as soon as You use ids, limit and page does not apply anymore !

>>> my_criteria = Criteria(page=1, limit=5)
>>> pprint_attrs(my_criteria)
{'limit': 5, 'page': 1, 'term': None, 'total_count_mode': None}

>>>

Query

back to Query Syntax

Use this parameter to create a weighted search query that returns a _score for each found entity. Any filter type can be used for the query. A score has to be defined for each query. The sum of the matching queries then results in the total _score value.

@attrs.define
class Query:
    """
    see: https://shopware.stoplight.io/docs/store-api/ZG9jOjEwODExNzU2-search-queries#query
    Enables you to determine a ranking for the search result
    Use this parameter to create a weighted search query that returns a _score for each found entity.
    Any filter type can be used for the query. A score has to be defined for each query.
    The sum of the matching queries then results in the total _score value.

    parameter
        score   int
        query   FilterType

    >>> # Test
    >>> my_criteria = Criteria(
    ...    query=[Query(score=500, query=ContainsFilter(field='name', value='Bronze')),
    ...           Query(score=500, query=EqualsFilter(field='active', value='true')),
    ...           Query(score=100, query=EqualsFilter(field='manufacturerId', value='db3c17b1e572432eb4a4c881b6f9d68f'))])

    >>> pprint_attrs(my_criteria)
    {'limit': None,
     'page': None,
     'query': [{'score': 500,
                'query': {'type': 'contains', 'field': 'name', 'value': 'Bronze'}},
               {'score': 500,
                'query': {'type': 'equals', 'field': 'active', 'value': 'true'}},
               {'score': 100,
                'query': {'type': 'equals',
                          'field': 'manufacturerId',
                          'value': 'db3c17b1e572432eb4a4c881b6f9d68f'}}],
     'term': None,
     'total_count_mode': None}

    """

Sort

back to Query Syntax

The sort parameter allows to control the sorting of the result. Several sorts can be transferred at the same time.

The field parameter defines which field is to be used for sorting. The order parameter defines the sort direction. The parameter naturalSorting allows to use a Natural Sorting Algorithm

FieldSorting

@attrs.define
class FieldSorting:
    """
    see: https://shopware.stoplight.io/docs/store-api/ZG9jOjEwODExNzU2-search-queries#sort
    The sort parameter allows to control the sorting of the result. Several sorts can be transferred at the same time.
    The field parameter defines which field is to be used for sorting.
    The order parameter defines the sort direction.
    The parameter naturalSorting allows to use a Natural Sorting Algorithm

    parameter:
        field : str
        order : str "ASC" or "DESC"
        naturalSorting : Optional[bool]

    >>> # Test
    >>> my_sorting = FieldSorting('name', 'ASC', True)
    >>> pprint_attrs(my_sorting)
    {'field': 'name', 'order': 'ASC', 'naturalSorting': True}

    """

AscFieldSorting

@attrs.define
class AscFieldSorting:
    """
    see: https://shopware.stoplight.io/docs/store-api/ZG9jOjEwODExNzU2-search-queries#sort
    The sort parameter allows to control the sorting of the result. Several sorts can be transferred at the same time.
    The field parameter defines which field is to be used for sorting.
    The order parameter defines the sort direction.
    The parameter naturalSorting allows to use a Natural Sorting Algorithm

    parameter:
        field : str
        naturalSorting : Optional[bool]

    >>> # Test
    >>> my_sorting = AscFieldSorting('name', True)
    >>> pprint_attrs(my_sorting)
    {'field': 'name', 'order': 'ASC', 'naturalSorting': True}

    """

DescFieldSorting

@attrs.define
class DescFieldSorting:
    """
    see: https://shopware.stoplight.io/docs/store-api/ZG9jOjEwODExNzU2-search-queries#sort
    The sort parameter allows to control the sorting of the result. Several sorts can be transferred at the same time.
    The field parameter defines which field is to be used for sorting.
    The order parameter defines the sort direction.
    The parameter naturalSorting allows to use a Natural Sorting Algorithm

    parameter:
        field : str
        naturalSorting : Optional[bool]

    >>> # Test
    >>> my_sorting = DescFieldSorting('name', True)
    >>> pprint_attrs(my_sorting)
    {'field': 'name', 'order': 'DESC', 'naturalSorting': True}

    """

Usage from Commandline

Usage: lib_shopware6_api_base [OPTIONS] COMMAND [ARGS]...

  python3 base API client for shopware6

Options:
  --version                     Show the version and exit.
  --traceback / --no-traceback  return traceback information on cli
  -h, --help                    Show this message and exit.

Commands:
  info  get program information

Installation and Upgrade

  • Before You start, its highly recommended to update pip:

python -m pip --upgrade pip
  • to install the latest release from PyPi via pip (recommended):

python -m pip install --upgrade lib_shopware6_api_base
  • to install the latest release from PyPi via pip, including test dependencies:

python -m pip install --upgrade lib_shopware6_api_base[test]
  • to install the latest version from github via pip:

python -m pip install --upgrade git+https://github.com/bitranox/lib_shopware6_api_base.git
  • include it into Your requirements.txt:

# Insert following line in Your requirements.txt:
# for the latest Release on pypi:
lib_shopware6_api_base

# for the latest development version :
lib_shopware6_api_base @ git+https://github.com/bitranox/lib_shopware6_api_base.git

# to install and upgrade all modules mentioned in requirements.txt:
python -m pip install --upgrade -r /<path>/requirements.txt
  • to install the latest development version, including test dependencies from source code:

# cd ~
$ git clone https://github.com/bitranox/lib_shopware6_api_base.git
$ cd lib_shopware6_api_base
python -m pip install -e .[test]
  • via makefile: makefiles are a very convenient way to install. Here we can do much more, like installing virtual environments, clean caches and so on.

# from Your shell's homedirectory:
$ git clone https://github.com/bitranox/lib_shopware6_api_base.git
$ cd lib_shopware6_api_base

# to run the tests:
$ make test

# to install the package
$ make install

# to clean the package
$ make clean

# uninstall the package
$ make uninstall

Requirements

following modules will be automatically installed :

## Project Requirements
attrs>=21.3.0
click
cli_exit_tools
lib_detect_testenv
oauthlib
requests
requests-oauthlib

Acknowledgements

  • special thanks to “uncle bob” Robert C. Martin, especially for his books on “clean code” and “clean architecture”

Contribute

I would love for you to fork and send me pull request for this project. - please Contribute

License

This software is licensed under the MIT license

Changelog

  • new MAJOR version for incompatible API changes,

  • new MINOR version for added functionality in a backwards compatible manner

  • new PATCH version for backwards compatible bug fixes

v2.1.9

2024-09-29:
  • add graalpy tests

v2.1.8

2024-09-29:
  • add example for /search/order via post request

v2.1.7

2023-10-18:
  • validator for “Criteria.ids” and “Criteria.limit”

  • if “Criteria.ids” are passed, set “limits” to the number of ids

  • prevent that “Criteria.limits” and “Criteria.ids” are set simultaneous

  • bump up coverage

v2.1.6

2023-10-18:
  • correcting “Filter Aggregation”, some typos correction

v2.1.5

2023-10-18:
  • get rid of special pretty printer version “pprint3x” for python 3.7 and below

  • correcting type hint for filter “ContainsFilter”

v2.1.4

2023-10-18:
  • correct EqualsAnyFilter, thanks to Patrik Hofmann for finding that bug.

v2.1.3

2023-07-14:
  • add codeql badge

  • move 3rd_party_stubs outside the src directory to ./.3rd_party_stubs

  • add pypy 3.10 tests

  • add python 3.12-dev tests

v2.1.2

2023-07-13:
  • require minimum python 3.8

  • remove python 3.7 tests

v2.1.1

2023-07-13:
  • introduce PEP517 packaging standard

  • introduce pyproject.toml build-system

  • remove setup.cfg

  • remove setup.py

  • update black config

  • clean ./tests/test_cli.py

v2.1.0

2023-06-28:
  • introduce additional header fields

  • update black config

  • remove travis config

  • remove bettercodehub config

  • do not upload .egg files to pypi.org

  • update github actions : checkout@v3 and setup-python@v4

  • remove “better code” badges

  • remove python 3.6 tests

  • adding python 3.11 tests

  • update pypy tests to 3.9

v2.0.9

2022-07-04: support additional query parameters for patch, post ,put and delete requests

v2.0.8

2022-07-04: allow different content-types in order to be able to upload documents as octet-stream

v2.0.7.3

2022-06-30: specify correct “attr” version in requirements

v2.0.7.2

2022-06-02: update to github actions checkout@v3 and setup-python@v3

v2.0.7.1

2022-06-01: update github actions test matrix

v2.0.7

2022-04-12: retry the request (experimental, but not harmful at all) if failed.
  • issue https://github.com/bitranox/lib_shopware6_api/issues/1

  • sometimes (seldom, after about 10 minutes connected) we got: “error code: 9, status: 401 The resource owner or authorization server denied the request, detail: Access token could not be verified.”

  • it seems to work when retry the request

v2.0.6

2022-03-29: remedy mypy Untyped decorator makes function “cli_info” untyped

v2.0.5

2022-02-15: documentation update

v2.0.4

2022-02-15: documentation update

v2.0.3

2022-01-18: mypy type adjustments

v2.0.2

2022-01-09:
  • handle dal.Criteria ‘ids’ correctly

  • remove empty lists and dicts from dal.Criteria

v2.0.1

2022-01-06: correct import for dal.Criteria

v2.0.0

2022-01-04:
  • make it possible to pass None Values to Filters (Bug)

  • paginated request now respect limits

v1.3.2

2022-01-04: improve detection of the dal.Criteria Class

v1.3.1

2021-12-31: implement testing for python 3.6, 3.7

v1.3.0

2021-12-29: add Sort, Group, Aggregations, Associations, etc ..

v1.2.0

2021-12-28: add Criteria, Filters

v1.1.0

2021-12-27: add Store Api DELETE/GET/GET LIST/PATCH/PUT methods

v1.0.0

2021-12-26: initial release

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

lib_shopware6_api_base-2.1.9.tar.gz (83.8 kB view details)

Uploaded Source

Built Distribution

lib_shopware6_api_base-2.1.9-py3-none-any.whl (40.5 kB view details)

Uploaded Python 3

File details

Details for the file lib_shopware6_api_base-2.1.9.tar.gz.

File metadata

File hashes

Hashes for lib_shopware6_api_base-2.1.9.tar.gz
Algorithm Hash digest
SHA256 8cb84d064b0ae7c945f819e8efb7b3bf618324ac3a6dadba8b0a2cccbfb2d3ca
MD5 89f49d67a3a6177d79c48fd8bb29022f
BLAKE2b-256 d263f7845a263379835b268dec541f87dfb3eab0aaf9fb674f46202912f56920

See more details on using hashes here.

File details

Details for the file lib_shopware6_api_base-2.1.9-py3-none-any.whl.

File metadata

File hashes

Hashes for lib_shopware6_api_base-2.1.9-py3-none-any.whl
Algorithm Hash digest
SHA256 4a770d9ef2e71397e71b01c56aa395aca3efb35fb262d6f8818d208f119891ee
MD5 0c362cb7166599255511925331e23b9d
BLAKE2b-256 c32875ca9567c7da8626045c420b3b21be863786ad39776656f5d1aef8bc54a6

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page