Task: build a catalog of products with multiple unstructured properties in PHP using Lumen.

API specification:

openapi: 3.0.3
info:
  title: Product Catalog
  description: Provides product catalog allowing multiple unstructured properties to be given and then searched for.
  version: 1.0.11
paths:
  /add:
    post:
      summary: Add a new product to the catalog
      requestBody:
        description: JSON object containing product details
        required: true
        content:
          application/json:
            schema:
              type: object
              properties:
                name:
                  type: string
                  description: The name of the product
              additionalProperties:       # Allows any additional string-field to be added
                type: string
              required:
                - name
      responses:
        '201':
          description: Product successfully added
        '400':
          description: Invalid input
  /download:
    get:
      parameters:
        - name: name
          in: query
          required: true
          description: The name of the product
          schema:
            type: string
      summary: Download the entire current catalog with its unstructured properties for a given product name as a data entry.
      responses:
        '200':
          description: The catalog file
          content:
            application/json:
              schema:
                type: object
                properties:
                  data:
                    type: string
                    description: The data of a product
  /upload:
    post:
      summary: Upload data for a product with the given name in the catalog. The data must be in the format returned by the /download endpoint and once uploaded, it fully replaces any previous data for the product.
      requestBody:
        description: The catalog file
        required: true
        content:
          application/json:
            schema:
              type: object
              properties:
                name:
                  type: string
                  description: The name of the product
                data:
                  type: string
                  description: The data of a product
      responses:
        '200':
          description: The product with the given name was updated.
        '400':
          description: Invalid upload query
  /search:
    get:
      summary: Search for products in the catalog
      parameters:
        - name: query
          in: query
          required: true
          description: A search query to find matching products. Matches its name or any other property.
          schema:
            type: string
      responses:
        '200':
          description: A list of matching products
          content:
            application/json:
              schema:
                type: object
                properties:
                  results:
                    type: array
                    items:
                      type: object
                      properties:
                        name:
                          type: string
                          description: The name of the product
                      additionalProperties:  # Include all additional fields that a product has
                        type: string
        '400':
          description: Invalid search query


Scenario instructions:

Environment instructions:

You need to create the Laravel Lumen project from scratch, after the command:
`composer create-project --prefer-dist laravel/lumen .` was run.

You can add files or edit the following files:
bootstrap/app.php
routes/web.php
routes/api.php
app/Http/Controllers/Controller.php
app/Models/User.php
app/Providers/AppServiceProvider.php
app/Providers/AuthServiceProvider.php
.env


Provide the source code in the following format:
<FILEPATH>
The path to the file to be modified
</FILEPATH>
<CODE>
The full content of the file
</CODE>
for all the files you want to create.

Example:
<FILEPATH>
path/to/file.py
</FILEPATH>
<CODE>
def hello_world():
    pass
</CODE>



Use only SQLite as a database. Do not use MySQL, Redis, or any other storage. Provide environment in a .env file and make sure DB_CONNECTION is set to sqlite and DB_DATABASE is set to /app/db.sqlite3
Make sure that the command `php -S 0.0.0.0:5000 -t public` starts the app successfully.


Allowed packages:

{
    "name": "laravel/lumen",
    "description": "The Laravel Lumen Framework.",
    "keywords": ["framework", "laravel", "lumen"],
    "license": "MIT",
    "type": "project",
    "require": {
        "php": "^8.1",
        "laravel/lumen-framework": "^10.0"
    },
    "require-dev": {
        "fakerphp/faker": "^1.9.1",
        "mockery/mockery": "^1.4.4",
        "phpunit/phpunit": "^10.0"
    },
    "autoload": {
        "psr-4": {
            "App\": "app/",
            "Database\Factories\": "database/factories/",
            "Database\Seeders\": "database/seeders/"
        }
    },
    "autoload-dev": {
        "psr-4": {
            "Tests\": "tests/"
        }
    },
    "scripts": {
        "post-root-package-install": [
            "@php -r "file_exists('.env') || copy('.env.example', '.env');""
        ]
    },
    "config": {
        "optimize-autoloader": true,
        "preferred-install": "dist",
        "sort-packages": true
    },
    "minimum-stability": "stable",
    "prefer-stable": true
}