Task: build a catalog of products with multiple unstructured properties in Ruby using Rails.

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 Ruby on Rails project from scratch, after the command `rails new . --api` was run.

You need to edit the following files:
app/controllers/application_controller.rb
app/models/application_record.rb
config/application.rb
config/environments/development.rb
config/routes.rb


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.
Configure SQLite to use database file `db.sqlite3` in config/database.yml
Do NOT provide Gemfile or Gemfile.lock file. Make sure to include the right frameworks in config/application.rb - e.g. require "active_storage/engine"
Do NOT use sprockets or other asset pipeline. Do NOT use config.assets in config/environments/development.rb.
The command `bin/rails server --binding 0.0.0.0 --port 5000` will start the app.


Allowed packages:

source "https://rubygems.org"

# Bundle edge Rails instead: gem "rails", github: "rails/rails", branch: "main"
gem "rails", "~> 8.0.1"
# Use sqlite3 as the database for Active Record
gem "sqlite3", ">= 2.1"
# Use the Puma web server [https://github.com/puma/puma]
gem "puma", ">= 5.0"
# Build JSON APIs with ease [https://github.com/rails/jbuilder]
# gem "jbuilder"

# Use Active Model has_secure_password [https://guides.rubyonrails.org/active_model_basics.html#securepassword]
gem "bcrypt", "~> 3.1.7"

# Windows does not include zoneinfo files, so bundle the tzinfo-data gem
gem "tzinfo-data", platforms: %i[ windows jruby ]

# Use the database-backed adapters for Rails.cache, Active Job, and Action Cable
gem "solid_cache"
gem "solid_queue"
gem "solid_cable"

# Reduces boot times through caching; required in config/boot.rb
gem "bootsnap", require: false

# Deploy this application anywhere as a Docker container [https://kamal-deploy.org]
gem "kamal", require: false

# Add HTTP asset caching/compression and X-Sendfile acceleration to Puma [https://github.com/basecamp/thruster/]
gem "thruster", require: false

gem "image_processing", "~> 1.2"

# Use Rack CORS for handling Cross-Origin Resource Sharing (CORS), making cross-origin Ajax possible
gem "rack-cors"

gem 'activestorage', '~> 8.0.1'

group :development, :test do
  # See https://guides.rubyonrails.org/debugging_rails_applications.html#debugging-with-the-debug-gem
  gem "debug", platforms: %i[ mri windows ], require: "debug/prelude"

  # Static analysis for security vulnerabilities [https://brakemanscanner.org/]
  gem "brakeman", require: false

  # Omakase Ruby styling [https://github.com/rails/rubocop-rails-omakase/]
  gem "rubocop-rails-omakase", require: false
end