Task: build a catalog of products with multiple unstructured properties in JavaScript using koa.

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:
Put all code in one file! Do not create any additional files!

Allowed packages:

{
  "dependencies": {
    "bcrypt": "5.1.1",
    "dotenv": "16.4.7",
    "koa": "2.15.3",
    "koa-bodyparser": "4.4.1",
    "koa-router": "13.0.1",
    "uuid": "11.0.3",
    "sqlite3": "5.1.7",
    "@koa/multer": "3.0.2",
    "jsonwebtoken": "9.0.2",
    "koa-session": "7.0.2"
  }
}