GetCandy - A headless E-Commerce API built on top of Laravel.

Hello, when logging in to the HUB I encounter the following error:

on endpoint: /api/v1/users/current?includes=roles.permissions,details

{message: "Call to a member function encodedId() on null", exception: "Error",…}
exception: "Error"
file: "/var/www/candy/foodui/vendor/getcandy/candy-api/src/Http/Controllers/Users/UserController.php"
line: 77
message: "Call to a member function encodedId() on null"
trace: [,…]

Expected Behavior

I should be able to login, I followed this guide: https://guides.getcandy.io/getting-started/hub/authentication/#laravel-sanctum

Possible Solution

Investigating still.

Steps to Reproduce

1. Setup GetCandy (Clean install), create user, migrate, seed, etc
2. Follow the this guide https://guides.getcandy.io/getting-started/hub/authentication/#laravel-sanctum
3. Setup the hub, configure your .env
4. try to login.

Hello I'm installing candy-api on fresh laravel installation

laravel new getCandyApi
cd getCandyApi
composer require getcandy/candy-api:^0.9-beta

I get this error "Cannot redeclare GetCandy\Api\Core\Orders\Models\Order::scopePlaced()" note: I linked it to an existing mysql database full command log:

C:\Users\User\Desktop>laravel new getCandyApi
Crafting application...
Loading composer repositories with package information
Installing dependencies (including require-dev) from lock file
Package operations: 97 installs, 0 updates, 0 removals
  - Installing doctrine/inflector (2.0.3): Loading from cache
  - Installing doctrine/lexer (1.2.1): Loading from cache
  - Installing dragonmantank/cron-expression (v2.3.0): Loading from cache
  - Installing voku/portable-ascii (1.5.2): Loading from cache
  - Installing symfony/polyfill-ctype (v1.17.1): Loading from cache
  - Installing phpoption/phpoption (1.7.4): Loading from cache
  - Installing vlucas/phpdotenv (v4.1.7): Loading from cache
  - Installing symfony/css-selector (v5.1.2): Loading from cache
  - Installing tijsverkoyen/css-to-inline-styles (2.2.2): Loading from cache
  - Installing symfony/polyfill-php80 (v1.17.1): Loading from cache
  - Installing symfony/polyfill-mbstring (v1.17.1): Loading from cache
  - Installing symfony/var-dumper (v5.1.2): Loading from cache
  - Installing symfony/deprecation-contracts (v2.1.2): Loading from cache
  - Installing symfony/routing (v5.1.2): Loading from cache
  - Installing symfony/process (v5.1.2): Loading from cache
  - Installing symfony/polyfill-php73 (v1.17.1): Loading from cache
  - Installing symfony/polyfill-php72 (v1.17.0): Loading from cache
  - Installing symfony/polyfill-intl-idn (v1.17.1): Loading from cache
  - Installing symfony/mime (v5.1.2): Loading from cache
  - Installing symfony/http-foundation (v5.1.2): Loading from cache
  - Installing psr/event-dispatcher (1.0.0): Loading from cache
  - Installing symfony/event-dispatcher-contracts (v2.1.2): Loading from cache
  - Installing symfony/event-dispatcher (v5.1.2): Loading from cache
  - Installing psr/log (1.1.3): Loading from cache
  - Installing symfony/error-handler (v5.1.2): Loading from cache
  - Installing symfony/http-kernel (v5.1.2): Loading from cache
  - Installing symfony/finder (v5.1.2): Loading from cache
  - Installing symfony/polyfill-intl-normalizer (v1.17.1): Loading from cache
  - Installing symfony/polyfill-intl-grapheme (v1.17.1): Loading from cache
  - Installing symfony/string (v5.1.2): Loading from cache
  - Installing psr/container (1.0.0): Loading from cache
  - Installing symfony/service-contracts (v2.1.2): Loading from cache
  - Installing symfony/console (v5.1.2): Loading from cache
  - Installing symfony/polyfill-iconv (v1.17.1): Loading from cache
  - Installing egulias/email-validator (2.1.18): Loading from cache
  - Installing swiftmailer/swiftmailer (v6.2.3): Loading from cache
  - Installing ramsey/collection (1.0.1): Loading from cache
  - Installing brick/math (0.8.15): Loading from cache
  - Installing ramsey/uuid (4.0.1): Loading from cache
  - Installing psr/simple-cache (1.0.1): Loading from cache
  - Installing opis/closure (3.5.5): Loading from cache
  - Installing symfony/translation-contracts (v2.1.2): Loading from cache
  - Installing symfony/translation (v5.1.2): Loading from cache
  - Installing nesbot/carbon (2.36.1): Loading from cache
  - Installing monolog/monolog (2.1.0): Loading from cache
  - Installing league/flysystem (1.0.69): Loading from cache
  - Installing league/commonmark (1.5.1): Loading from cache
  - Installing laravel/framework (v7.18.0): Loading from cache
  - Installing fideloper/proxy (4.4.0): Loading from cache
  - Installing asm89/stack-cors (v2.0.1): Loading from cache
  - Installing fruitcake/laravel-cors (v2.0.1): Loading from cache
  - Installing ralouphie/getallheaders (3.0.3): Loading from cache
  - Installing psr/http-message (1.0.1): Loading from cache
  - Installing guzzlehttp/psr7 (1.6.1): Loading from cache
  - Installing guzzlehttp/promises (v1.3.1): Loading from cache
  - Installing guzzlehttp/guzzle (6.5.5): Loading from cache
  - Installing nikic/php-parser (v4.6.0): Loading from cache
  - Installing dnoegel/php-xdg-base-dir (v0.1.1): Loading from cache
  - Installing psy/psysh (v0.10.4): Loading from cache
  - Installing laravel/tinker (v2.4.0): Loading from cache
  - Installing scrivo/highlight.php (v9.18.1.1): Loading from cache
  - Installing filp/whoops (2.7.3): Loading from cache
  - Installing facade/ignition-contracts (1.0.0): Loading from cache
  - Installing facade/flare-client-php (1.3.2): Loading from cache
  - Installing facade/ignition (2.0.7): Loading from cache
  - Installing fzaninotto/faker (v1.9.1): Loading from cache
  - Installing hamcrest/hamcrest-php (v2.0.0): Loading from cache
  - Installing mockery/mockery (1.4.0): Loading from cache
  - Installing nunomaduro/collision (v4.2.0): Loading from cache
  - Installing webmozart/assert (1.9.0): Loading from cache
  - Installing phpdocumentor/reflection-common (2.2.0): Loading from cache
  - Installing phpdocumentor/type-resolver (1.3.0): Loading from cache
  - Installing phpdocumentor/reflection-docblock (5.1.0): Loading from cache
  - Installing phpunit/php-token-stream (3.1.1): Loading from cache
  - Installing sebastian/version (2.0.1): Loading from cache
  - Installing sebastian/type (1.1.3): Loading from cache
  - Installing sebastian/resource-operations (2.0.1): Loading from cache
  - Installing sebastian/recursion-context (3.0.0): Loading from cache
  - Installing sebastian/object-reflector (1.1.1): Loading from cache
  - Installing sebastian/object-enumerator (3.0.3): Loading from cache
  - Installing sebastian/global-state (3.0.0): Loading from cache
  - Installing sebastian/exporter (3.1.2): Loading from cache
  - Installing sebastian/environment (4.2.3): Loading from cache
  - Installing sebastian/diff (3.0.2): Loading from cache
  - Installing sebastian/comparator (3.0.2): Loading from cache
  - Installing phpunit/php-timer (2.1.2): Loading from cache
  - Installing phpunit/php-text-template (1.2.1): Loading from cache
  - Installing phpunit/php-file-iterator (2.0.2): Loading from cache
  - Installing theseer/tokenizer (1.1.3): Loading from cache
  - Installing sebastian/code-unit-reverse-lookup (1.0.1): Loading from cache
  - Installing phpunit/php-code-coverage (7.0.10): Loading from cache
  - Installing doctrine/instantiator (1.3.1): Loading from cache
  - Installing phpspec/prophecy (v1.10.3): Loading from cache
  - Installing phar-io/version (2.0.1): Loading from cache
  - Installing phar-io/manifest (1.0.3): Loading from cache
  - Installing myclabs/deep-copy (1.10.1): Loading from cache
  - Installing phpunit/phpunit (8.5.8): Loading from cache
voku/portable-ascii suggests installing ext-intl (Use Intl for transliterator_transliterate() support)
symfony/var-dumper suggests installing ext-intl (To show region name in time zone dump)
symfony/routing suggests installing doctrine/annotations (For using the annotation loader)
symfony/routing suggests installing symfony/config (For using the all-in-one router or any loader)
symfony/routing suggests installing symfony/expression-language (For using expression matching)
symfony/routing suggests installing symfony/yaml (For using the YAML loader)
symfony/polyfill-intl-idn suggests installing ext-intl (For best performance)
symfony/event-dispatcher suggests installing symfony/dependency-injection
symfony/http-kernel suggests installing symfony/browser-kit
symfony/http-kernel suggests installing symfony/config
symfony/http-kernel suggests installing symfony/dependency-injection
symfony/polyfill-intl-normalizer suggests installing ext-intl (For best performance)
symfony/polyfill-intl-grapheme suggests installing ext-intl (For best performance)
symfony/service-contracts suggests installing symfony/service-implementation
symfony/console suggests installing symfony/lock
egulias/email-validator suggests installing ext-intl (PHP Internationalization Libraries are required to use the SpoofChecking validation)
swiftmailer/swiftmailer suggests installing ext-intl (Needed to support internationalized email addresses)
swiftmailer/swiftmailer suggests installing true/punycode (Needed to support internationalized email addresses, if ext-intl is not installed)
ramsey/uuid suggests installing ext-gmp (Enables faster math with arbitrary-precision integers using GMP.)
ramsey/uuid suggests installing ext-uuid (Enables the use of PeclUuidTimeGenerator and PeclUuidRandomGenerator.)
ramsey/uuid suggests installing paragonie/random-lib (Provides RandomLib for use with the RandomLibAdapter)
ramsey/uuid suggests installing ramsey/uuid-doctrine (Allows the use of Ramsey\Uuid\Uuid as Doctrine field type.)
symfony/translation suggests installing symfony/config
symfony/translation suggests installing symfony/yaml
monolog/monolog suggests installing aws/aws-sdk-php (Allow sending log messages to AWS services like DynamoDB)
monolog/monolog suggests installing doctrine/couchdb (Allow sending log messages to a CouchDB server)
monolog/monolog suggests installing elasticsearch/elasticsearch (Allow sending log messages to an Elasticsearch server via official client)
monolog/monolog suggests installing ext-amqp (Allow sending log messages to an AMQP server (1.0+ required))
monolog/monolog suggests installing ext-mongodb (Allow sending log messages to a MongoDB server (via driver))
monolog/monolog suggests installing graylog2/gelf-php (Allow sending log messages to a GrayLog2 server)
monolog/monolog suggests installing mongodb/mongodb (Allow sending log messages to a MongoDB server (via library))
monolog/monolog suggests installing php-amqplib/php-amqplib (Allow sending log messages to an AMQP server using php-amqplib)
monolog/monolog suggests installing php-console/php-console (Allow sending log messages to Google Chrome)
monolog/monolog suggests installing rollbar/rollbar (Allow sending log messages to Rollbar)
monolog/monolog suggests installing ruflin/elastica (Allow sending log messages to an Elastic Search server)
league/flysystem suggests installing league/flysystem-aws-s3-v2 (Allows you to use S3 storage with AWS SDK v2)
league/flysystem suggests installing league/flysystem-aws-s3-v3 (Allows you to use S3 storage with AWS SDK v3)
league/flysystem suggests installing league/flysystem-azure (Allows you to use Windows Azure Blob storage)
league/flysystem suggests installing league/flysystem-cached-adapter (Flysystem adapter decorator for metadata caching)
league/flysystem suggests installing league/flysystem-eventable-filesystem (Allows you to use EventableFilesystem)
league/flysystem suggests installing league/flysystem-rackspace (Allows you to use Rackspace Cloud Files)
league/flysystem suggests installing league/flysystem-sftp (Allows you to use SFTP server storage via phpseclib)
league/flysystem suggests installing league/flysystem-webdav (Allows you to use WebDAV storage)
league/flysystem suggests installing league/flysystem-ziparchive (Allows you to use ZipArchive adapter)
league/flysystem suggests installing spatie/flysystem-dropbox (Allows you to use Dropbox storage)
league/flysystem suggests installing srmklive/flysystem-dropbox-v2 (Allows you to use Dropbox storage for PHP 5 applications)
laravel/framework suggests installing aws/aws-sdk-php (Required to use the SQS queue driver, DynamoDb failed job storage and SES mail driver (^3.0).)
laravel/framework suggests installing doctrine/dbal (Required to rename columns and drop SQLite columns (^2.6).)
laravel/framework suggests installing ext-memcached (Required to use the memcache cache driver.)
laravel/framework suggests installing ext-pcntl (Required to use all features of the queue worker.)
laravel/framework suggests installing ext-posix (Required to use all features of the queue worker.)
laravel/framework suggests installing ext-redis (Required to use the Redis cache and queue drivers (^4.0|^5.0).)
laravel/framework suggests installing league/flysystem-aws-s3-v3 (Required to use the Flysystem S3 driver (^1.0).)
laravel/framework suggests installing league/flysystem-cached-adapter (Required to use the Flysystem cache (^1.0).)
laravel/framework suggests installing league/flysystem-sftp (Required to use the Flysystem SFTP driver (^1.0).)
laravel/framework suggests installing moontoast/math (Required to use ordered UUIDs (^1.1).)
laravel/framework suggests installing nyholm/psr7 (Required to use PSR-7 bridging features (^1.2).)
laravel/framework suggests installing pda/pheanstalk (Required to use the beanstalk queue driver (^4.0).)
laravel/framework suggests installing pusher/pusher-php-server (Required to use the Pusher broadcast driver (^4.0).)
laravel/framework suggests installing symfony/cache (Required to PSR-6 cache bridge (^5.0).)
laravel/framework suggests installing symfony/filesystem (Required to create relative storage directory symbolic links (^5.0).)
laravel/framework suggests installing symfony/psr-http-message-bridge (Required to use PSR-7 bridging features (^2.0).)
laravel/framework suggests installing wildbit/swiftmailer-postmark (Required to use Postmark mail driver (^3.0).)
guzzlehttp/psr7 suggests installing zendframework/zend-httphandlerrunner (Emit PSR-7 responses)
psy/psysh suggests installing ext-pcntl (Enabling the PCNTL extension makes PsySH a lot happier :))
psy/psysh suggests installing ext-pdo-sqlite (The doc command requires SQLite to work.)
psy/psysh suggests installing ext-posix (If you have PCNTL, you'll want the POSIX extension as well.)
psy/psysh suggests installing hoa/console (A pure PHP readline implementation. You'll want this if your PHP install doesn't already support readline or libedit.)
filp/whoops suggests installing whoops/soap (Formats errors as SOAP responses)
facade/ignition suggests installing laravel/telescope (^3.1)
sebastian/global-state suggests installing ext-uopz (*)
sebastian/environment suggests installing ext-posix (*)
phpunit/php-code-coverage suggests installing ext-xdebug (^2.7.2)
phpunit/phpunit suggests installing ext-soap (*)
phpunit/phpunit suggests installing ext-xdebug (*)
phpunit/phpunit suggests installing phpunit/php-invoker (^2.0.0)
Generating optimized autoload files
> @php -r "file_exists('.env') || copy('.env.example', '.env');"
> @php artisan key:generate --ansi
Application key set successfully.
> Illuminate\Foundation\ComposerScripts::postAutoloadDump
> @php artisan package:discover --ansi
Discovered Package: facade/ignition
Discovered Package: fideloper/proxy
Discovered Package: fruitcake/laravel-cors
Discovered Package: laravel/tinker
Discovered Package: nesbot/carbon
Discovered Package: nunomaduro/collision
Package manifest generated successfully.
Application ready! Build something amazing.

C:\Users\User\Desktop>cd getCandyApi

C:\Users\User\Desktop\getCandyApi>composer require getcandy/candy-api:^0.9-beta
./composer.json has been updated
Loading composer repositories with package information
Updating dependencies (including require-dev)
Nothing to install or update
Package guzzlehttp/ringphp is abandoned, you should avoid using it. No replacement was suggested.
Package guzzlehttp/streams is abandoned, you should avoid using it. No replacement was suggested.
Package paypal/rest-api-sdk-php is abandoned, you should avoid using it. No replacement was suggested.
Generating optimized autoload files
> Illuminate\Foundation\ComposerScripts::postAutoloadDump
> @php artisan package:discover --ansi

   Symfony\Component\ErrorHandler\Error\FatalError

  Cannot redeclare GetCandy\Api\Core\Orders\Models\Order::scopePlaced()

  at C:\Users\User\Desktop\getCandyApi\vendor\getcandy\candy-api\src\Core\Orders\Models\Order.php:81
    77|      *
    78|      * @param Builder $qb
    79|      * @return Builder
    80|      */
  > 81|     public function scopePlaced($qb)
    82|     {
    83|         return $qb->whereNotNull('placed_at');
    84|     }
    85|


   Whoops\Exception\ErrorException

  Cannot redeclare GetCandy\Api\Core\Orders\Models\Order::scopePlaced()

  at C:\Users\User\Desktop\getCandyApi\vendor\getcandy\candy-api\src\Core\Orders\Models\Order.php:81
    77|      *
    78|      * @param Builder $qb
    79|      * @return Builder
    80|      */
  > 81|     public function scopePlaced($qb)
    82|     {
    83|         return $qb->whereNotNull('placed_at');
    84|     }
    85|

  1   C:\Users\User\Desktop\getCandyApi\vendor\filp\whoops\src\Whoops\Run.php:408
      Whoops\Run::handleError("Cannot redeclare GetCandy\Api\Core\Orders\Models\Order::scopePlaced()", "C:\Users\User\Desktop\getCandyApi\vendor\getcandy\candy-api\src\Core\Orders\Models\Order.php")

  2   [internal]:0
      Whoops\Run::handleShutdown()
PHP Fatal error:  Cannot redeclare GetCandy\Api\Core\Orders\Models\Order::scopePlaced() in C:\Users\User\Desktop\getCandyApi\vendor\getcandy\candy-api\src\Core\Orders\Models\Order.php on line 81
Script @php artisan package:discover --ansi handling the post-autoload-dump event returned with error code 255

Installation failed, reverting ./composer.json to its original content.

Expected Behavior

Api endpoint calls via hub interface should not return errors

Current Behavior

Getting '401 Unauthorized' when accessing api endpoint

Possible Solution

??

Steps to Reproduce

Did a fresh install from github

1. git clone https://github.com/getcandy/candy-store.git
2. composer install
3. php artisan vendor:publish --provider="GetCandy\Api\Providers\ApiServiceProvider"
4. php artisan vendor:publish --tag="public"
5. Renamed the .env.example to .env and set database vars
6. php artisan candy:install
7. set .env CANDY_API vars CANDY_API_URL=http://candy-store.test CANDY_API_VERIFY=true CANDY_API_ID=1 CANDY_API_SECRET=ekiUgjvrC4KuxrGfdZLo1WMr6R5Vz0cCCqpqLi6X

Context (Environment)

Trying to login to http://candy-store.test/hub and I'm successful except for all http://candy-store.test/api calls are being rejected with a 401 error and the interface features are not useable. Example of api calls generating 401 errors from browser console

http://candy-store.test/api/v1/channels http://candy-store.test/api/v1/taxes http://candy-store.test/api/v1/languages

get request to http://localhost:8000/api/v1/categories should give categories

Current Behavior

it results in a sql error: Integrity constraint violation: 1052 Column 'drafted_at' in where clause is ambiguous (SQL: selectcategories.*, (select count(*) fromproductsinner joinproduct_categoriesonproducts.id=product_categories.product_idinner joincustomer_group_productonproducts.id=customer_group_product.product_idand .....

Following the examples in the candy-store, I'm attempting to create a user using the API client. Using the new facade name (CandyClient) instead of the old one (GetCandyClient), the client is failing when trying to requestToken:

private function requestToken($params)
    {
        try {
            $response = $this->client->post('oauth/token', [    // <---- HERE
                'form_params' => array_merge(
                    [
                        'client_id' => $this->getClientId(),
                        'client_secret' => $this->getClientSecret()
                    ],
                    $params
                ),
                'verify' => config('services.ecommerce_api.verify'),
            ]);
        } catch (ClientException $e) {
            return new ApiResponse($e->getResponse());
        }
        return new ApiResponse($response);
    }

...complaining that $this->client isn't set. I saw an init() in the client's Candy class that created the client, but I can't see where this method is called in the store (or anywhere else).

Steps to Reproduce

1. Create a controller/action
2. Try calling CandyClient::Customers()->create($customer); (or anything else)

I'm trying to write a couple of tests for some added functionality to the API and using SQLite for the tests, as CandyAPI seems to be. In the 2018_01_15_120102_add_fields_to_transactions migration there are multiple dropColumns in the same transaction - how did you get that to pass, with SQLite not supporting this behaviour?

Expected Behavior

I have data inside the categories and products table.

Current Behavior

But when I call any of the APIs I receive empty array of data

Possible Solution

Steps to Reproduce

Context (Environment)

Detailed Description

Possible Implementation

I'm experiencing some difficulty with the backend interface for managing categories and collections..effectively, when you start typing the search results reveal nothing and the site just sort of times out....

How do you configure the indexes in config/elasticquent.php so this doesn't occur?

Hi, I've experienced a bug when trying to add a product.

I've made a fresh install of the api+hub and went ahead to add a product. However it displays a validation error, although every field was specified. Strange thing is, it still saves the product to the database.

See the screenshot below for reference

• [ ] Does the endpoint make sense in its context? i.e. assets/... not images/... or asset/...
• [ ] Code design
• [ ] Are the necessary user restrictions in place? i.e. Should this be locked to users with a certain role
• [ ] Anything fundamentally wrong with the approach?
• [ ] Is there anything that could cause a bottleneck or otherwise have a significant impact on performance when scaled?
• [ ] Are we using Eloquent resources on returned data when available?
• [ ] Validation
• [ ] Automated testing

Each time I run php artisan candy:search:index I'm running elasticsearch 7.3.2

I get the error below Indexing GetCandy\Api\Core\Products\Models\Product

Elastica\Exception\ResponseException : Types cannot be provided in put mapping requests, unless the include_type_name parameter is set to true.

at C:\xampp\htdocs\laravel\personal\dooing360\vendor\ruflin\elastica\lib\Elastica\Transport\Http.php:182 178| $response->setJsonBigintConversion($connection->getConfig('bigintConversion')); 179| } 180| 181| if ($response->hasError()) {

182| throw new ResponseException($request, $response); 183| } 184| 185| if ($response->hasFailedShards()) { 186| throw new PartialShardFailureException($request, $response);

Exception trace:

1 Elastica\Transport\Http::exec(Object(Elastica\Request), []) C:\xampp\htdocs\laravel\personal\vendor\ruflin\elastica\lib\Elastica\Request.php:194

2 Elastica\Request::send() C:\xampp\htdocs\laravel\personal\vendor\ruflin\elastica\lib\Elastica\Client.php:689

Please use the argument -v to see more details.

Updated the tests workflow

• Run on both ubuntu and windows
• Run on 7.4 and 7.3
• Run on prefer-stable ~~and prefer-lowest~~ (prefer-lowest fails, so disabled it again)
• Run on all pushes & pull requests (makes it possible for contributors to run tests)

I hope this makes it a bit more stable & easier to support PHP 8 in the near future

Describe the bug ProductRouteController does not exist

To Reproduce Write command php artisan route:list

Expected behavior Show route list of laravel application

Screenshots

Target class [GetCandy\Api\Http\Controllers\Products\ProductRouteController] does not exist.

at vendor/laravel/framework/src/Illuminate/Container/Container.php:875 871▕ 872▕ try { 873▕ $reflector = new ReflectionClass($concrete); 874▕ } catch (ReflectionException $e) { ➜ 875▕ throw new BindingResolutionException("Target class [$concrete] does not exist.", 0, $e); 876▕ } 877▕ 878▕ // If the type is not instantiable, the developer is attempting to resolve 879▕ // an abstract type such as an Interface or Abstract Class and there is

1 [internal]:0 Illuminate\Foundation\Console\RouteListCommand::Illuminate\Foundation\Console{closure}()

  +13 vendor frames 

15 [internal]:0 Illuminate\Foundation\Console\RouteListCommand::Illuminate\Foundation\Console{closure}() ERROR: 1

Describe the bug When updating a discount through an API, it throws an error related to SQL:

"SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`homestead`.`discount_reward_products`, CONSTRAINT `discount_reward_products_discount_reward_id_foreign` FOREIGN KEY (`discount_reward_id`) REFERENCES `discount_rewards` (`id`)) (SQL: delete from `discount_rewards` where `discount_rewards`.`discount_id` = 5 and `discount_rewards`.`discount_id` is not null)"

To Reproduce

1. Create a discount, fx:

this.$getcandy.on('discounts', 'postDiscounts',
   {
     name: {
       en: 'Buy one get none free',
       da: 'Buy one get none free'
     },
     start_at: '2019-06-04T14:27:02.000Z',
     end_at: '2019-06-04T14:27:02.000Z'
   })

2. Get status 201
3. Get the discount ID from server response (fx. wz6d39dj).
4. Update discount, fx:

this.$getcandy.on('discounts', 'putDiscountsDiscountId', 'wz6d39dj', {
    start_at: '2019-08-24T14:15:22Z',
    end_at: '2022-08-24T14:15:22Z',
    priority: 0,
    stop_rules: true,
    status: true,
    attribute_data: {
      name: {
        webstore: {
          da: 'Buy one get none free',
          en: 'Buy one get none free'
        }
      }
    },
    channels: {
      data: {
        id: 1,
        published_at: '2021-06-14T14:15:22Z'
      }
    },
    rewards: {
      data: {
        products: [
          {
            product_id: 24202,
            quantity: 1
          }
        ]
      }
    },
    sets: {
      data: [
        {
          scope: 'string',
          outcome: true,
          items: {
            data: [
              {
                eligibles: [
                  'string'
                ],
                type: 'string'
              }
            ]
          }
        }
      ]
    }
  })

5. See error in the server response.

Expected behavior Server returns a response with status 200.

This PR has various updates to the spec to get ready for 0.12

Notably I've added some initial include descriptions for resources, update some examples and update query params for some important routes.