diff options
83 files changed, 94 insertions, 2103 deletions
diff --git a/projects/3/Makefile b/projects/3/Makefile index a1b102d..a9964fb 100644 --- a/projects/3/Makefile +++ b/projects/3/Makefile @@ -4,4 +4,6 @@ clean: rm -f project.db project.db: - sqlite3 project.db < structure.sql + sqlite3 project.db < ddl.sql + sqlite3 project.db < seed.sql + sqlite3 project.db < queries.sql diff --git a/projects/3/ddl.sql b/projects/3/ddl.sql new file mode 100644 index 0000000..4a264cf --- /dev/null +++ b/projects/3/ddl.sql @@ -0,0 +1,43 @@ +create table categories( + id integer primary key asc, + title varchar(16) unique not null, + description varchar(255) not null, + created_at datetime default current_timestamp, + updated_at datetime default current_timestamp +); + +create table customers( + id integer primary key asc, + first_name varchar(255) not null, + last_name varchar(255) not null, + address text, + created_at datetime default current_timestamp, + updated_at datetime default current_timestamp +); + +create table media( + id integer primary key asc, + title varchar(255) unique not null, + m_type varchar(255) check(m_type in ('blu-ray', 'dvd', 'game')) not null default('dvd'), + category_id integer not null, + created_at datetime default current_timestamp, + updated_at datetime default current_timestamp, + foreign key(category_id) references categories(id) +); + +create table rentals( + id integer primary key asc, + rented_at datetime not null, + due_at datetime not null, + customer_id integer not null, + media_id integer not null, + created_at datetime default current_timestamp, + updated_at datetime default current_timestamp, + foreign key(media_id) references media(id), + foreign key(customer_id) references customers(id) +); + +create index index_media_on_category_id on media(category_id); +create index index_rentals_on_customer_id_and_media_id on rentals(customer_id, media_id); + +.schema diff --git a/projects/3/example/.dockerignore b/projects/3/example/.dockerignore deleted file mode 100644 index 325bfc0..0000000 --- a/projects/3/example/.dockerignore +++ /dev/null @@ -1,51 +0,0 @@ -# See https://docs.docker.com/engine/reference/builder/#dockerignore-file for more about ignoring files. - -# Ignore git directory. -/.git/ -/.gitignore - -# Ignore bundler config. -/.bundle - -# Ignore all environment files. -/.env* - -# Ignore all default key files. -/config/master.key -/config/credentials/*.key - -# Ignore all logfiles and tempfiles. -/log/* -/tmp/* -!/log/.keep -!/tmp/.keep - -# Ignore pidfiles, but keep the directory. -/tmp/pids/* -!/tmp/pids/.keep - -# Ignore storage (uploaded files in development and any SQLite databases). -/storage/* -!/storage/.keep -/tmp/storage/* -!/tmp/storage/.keep - -# Ignore assets. -/node_modules/ -/app/assets/builds/* -!/app/assets/builds/.keep -/public/assets - -# Ignore CI service files. -/.github - -# Ignore Kamal files. -/config/deploy*.yml -/.kamal - -# Ignore development files -/.devcontainer - -# Ignore Docker-related files -/.dockerignore -/Dockerfile* diff --git a/projects/3/example/.gitattributes b/projects/3/example/.gitattributes deleted file mode 100644 index 8dc4323..0000000 --- a/projects/3/example/.gitattributes +++ /dev/null @@ -1,9 +0,0 @@ -# See https://git-scm.com/docs/gitattributes for more about git attribute files. - -# Mark the database schema as having been generated. -db/schema.rb linguist-generated - -# Mark any vendored files as having been vendored. -vendor/* linguist-vendored -config/credentials/*.yml.enc diff=rails_credentials -config/credentials.yml.enc diff=rails_credentials diff --git a/projects/3/example/.github/dependabot.yml b/projects/3/example/.github/dependabot.yml deleted file mode 100644 index f0527e6..0000000 --- a/projects/3/example/.github/dependabot.yml +++ /dev/null @@ -1,12 +0,0 @@ -version: 2 -updates: -- package-ecosystem: bundler - directory: "/" - schedule: - interval: daily - open-pull-requests-limit: 10 -- package-ecosystem: github-actions - directory: "/" - schedule: - interval: daily - open-pull-requests-limit: 10 diff --git a/projects/3/example/.github/workflows/ci.yml b/projects/3/example/.github/workflows/ci.yml deleted file mode 100644 index abb548b..0000000 --- a/projects/3/example/.github/workflows/ci.yml +++ /dev/null @@ -1,90 +0,0 @@ -name: CI - -on: - pull_request: - push: - branches: [ main ] - -jobs: - scan_ruby: - runs-on: ubuntu-latest - - steps: - - name: Checkout code - uses: actions/checkout@v4 - - - name: Set up Ruby - uses: ruby/setup-ruby@v1 - with: - ruby-version: .ruby-version - bundler-cache: true - - - name: Scan for common Rails security vulnerabilities using static analysis - run: bin/brakeman --no-pager - - scan_js: - runs-on: ubuntu-latest - - steps: - - name: Checkout code - uses: actions/checkout@v4 - - - name: Set up Ruby - uses: ruby/setup-ruby@v1 - with: - ruby-version: .ruby-version - bundler-cache: true - - - name: Scan for security vulnerabilities in JavaScript dependencies - run: bin/importmap audit - - lint: - runs-on: ubuntu-latest - steps: - - name: Checkout code - uses: actions/checkout@v4 - - - name: Set up Ruby - uses: ruby/setup-ruby@v1 - with: - ruby-version: .ruby-version - bundler-cache: true - - - name: Lint code for consistent style - run: bin/rubocop -f github - - test: - runs-on: ubuntu-latest - - # services: - # redis: - # image: redis - # ports: - # - 6379:6379 - # options: --health-cmd "redis-cli ping" --health-interval 10s --health-timeout 5s --health-retries 5 - steps: - - name: Install packages - run: sudo apt-get update && sudo apt-get install --no-install-recommends -y build-essential git pkg-config google-chrome-stable - - - name: Checkout code - uses: actions/checkout@v4 - - - name: Set up Ruby - uses: ruby/setup-ruby@v1 - with: - ruby-version: .ruby-version - bundler-cache: true - - - name: Run tests - env: - RAILS_ENV: test - # REDIS_URL: redis://localhost:6379/0 - run: bin/rails db:test:prepare test test:system - - - name: Keep screenshots from failed system tests - uses: actions/upload-artifact@v4 - if: failure() - with: - name: screenshots - path: ${{ github.workspace }}/tmp/screenshots - if-no-files-found: ignore diff --git a/projects/3/example/.gitignore b/projects/3/example/.gitignore deleted file mode 100644 index f92525c..0000000 --- a/projects/3/example/.gitignore +++ /dev/null @@ -1,34 +0,0 @@ -# See https://help.github.com/articles/ignoring-files for more about ignoring files. -# -# Temporary files generated by your text editor or operating system -# belong in git's global ignore instead: -# `$XDG_CONFIG_HOME/git/ignore` or `~/.config/git/ignore` - -# Ignore bundler config. -/.bundle - -# Ignore all environment files. -/.env* - -# Ignore all logfiles and tempfiles. -/log/* -/tmp/* -!/log/.keep -!/tmp/.keep - -# Ignore pidfiles, but keep the directory. -/tmp/pids/* -!/tmp/pids/ -!/tmp/pids/.keep - -# Ignore storage (uploaded files in development and any SQLite databases). -/storage/* -!/storage/.keep -/tmp/storage/* -!/tmp/storage/ -!/tmp/storage/.keep - -/public/assets - -# Ignore master key for decrypting credentials and more. -/config/master.key diff --git a/projects/3/example/.rubocop.yml b/projects/3/example/.rubocop.yml deleted file mode 100644 index f9d86d4..0000000 --- a/projects/3/example/.rubocop.yml +++ /dev/null @@ -1,8 +0,0 @@ -# Omakase Ruby styling for Rails -inherit_gem: { rubocop-rails-omakase: rubocop.yml } - -# Overwrite or add rules to create your own house style -# -# # Use `[a, [b, c]]` not `[ a, [ b, c ] ]` -# Layout/SpaceInsideArrayLiteralBrackets: -# Enabled: false diff --git a/projects/3/example/.ruby-version b/projects/3/example/.ruby-version deleted file mode 100644 index 408069a..0000000 --- a/projects/3/example/.ruby-version +++ /dev/null @@ -1 +0,0 @@ -ruby-3.4.1 diff --git a/projects/3/example/Dockerfile b/projects/3/example/Dockerfile deleted file mode 100644 index ab06edb..0000000 --- a/projects/3/example/Dockerfile +++ /dev/null @@ -1,72 +0,0 @@ -# syntax=docker/dockerfile:1 -# check=error=true - -# This Dockerfile is designed for production, not development. Use with Kamal or build'n'run by hand: -# docker build -t example . -# docker run -d -p 80:80 -e RAILS_MASTER_KEY=<value from config/master.key> --name example example - -# For a containerized dev environment, see Dev Containers: https://guides.rubyonrails.org/getting_started_with_devcontainer.html - -# Make sure RUBY_VERSION matches the Ruby version in .ruby-version -ARG RUBY_VERSION=3.4.1 -FROM docker.io/library/ruby:$RUBY_VERSION-slim AS base - -# Rails app lives here -WORKDIR /rails - -# Install base packages -RUN apt-get update -qq && \ - apt-get install --no-install-recommends -y curl libjemalloc2 libvips sqlite3 && \ - rm -rf /var/lib/apt/lists /var/cache/apt/archives - -# Set production environment -ENV RAILS_ENV="production" \ - BUNDLE_DEPLOYMENT="1" \ - BUNDLE_PATH="/usr/local/bundle" \ - BUNDLE_WITHOUT="development" - -# Throw-away build stage to reduce size of final image -FROM base AS build - -# Install packages needed to build gems -RUN apt-get update -qq && \ - apt-get install --no-install-recommends -y build-essential git pkg-config && \ - rm -rf /var/lib/apt/lists /var/cache/apt/archives - -# Install application gems -COPY Gemfile Gemfile.lock ./ -RUN bundle install && \ - rm -rf ~/.bundle/ "${BUNDLE_PATH}"/ruby/*/cache "${BUNDLE_PATH}"/ruby/*/bundler/gems/*/.git && \ - bundle exec bootsnap precompile --gemfile - -# Copy application code -COPY . . - -# Precompile bootsnap code for faster boot times -RUN bundle exec bootsnap precompile app/ lib/ - -# Precompiling assets for production without requiring secret RAILS_MASTER_KEY -RUN SECRET_KEY_BASE_DUMMY=1 ./bin/rails assets:precompile - - - - -# Final stage for app image -FROM base - -# Copy built artifacts: gems, application -COPY --from=build "${BUNDLE_PATH}" "${BUNDLE_PATH}" -COPY --from=build /rails /rails - -# Run and own only the runtime files as a non-root user for security -RUN groupadd --system --gid 1000 rails && \ - useradd rails --uid 1000 --gid 1000 --create-home --shell /bin/bash && \ - chown -R rails:rails db log storage tmp -USER 1000:1000 - -# Entrypoint prepares the database. -ENTRYPOINT ["/rails/bin/docker-entrypoint"] - -# Start server via Thruster by default, this can be overwritten at runtime -EXPOSE 80 -CMD ["./bin/thrust", "./bin/rails", "server"] diff --git a/projects/3/example/Gemfile b/projects/3/example/Gemfile deleted file mode 100644 index 25c0933..0000000 --- a/projects/3/example/Gemfile +++ /dev/null @@ -1,63 +0,0 @@ -source "https://rubygems.org" - -# Bundle edge Rails instead: gem "rails", github: "rails/rails", branch: "main" -gem "rails", "~> 8.0.1" -# The modern asset pipeline for Rails [https://github.com/rails/propshaft] -gem "propshaft" -# 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" -# Use JavaScript with ESM import maps [https://github.com/rails/importmap-rails] -gem "importmap-rails" -# Hotwire's SPA-like page accelerator [https://turbo.hotwired.dev] -gem "turbo-rails" -# Hotwire's modest JavaScript framework [https://stimulus.hotwired.dev] -gem "stimulus-rails" -# 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 - -# Use Active Storage variants [https://guides.rubyonrails.org/active_storage_overview.html#transforming-images] -# gem "image_processing", "~> 1.2" - -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 - -group :development do - # Use console on exceptions pages [https://github.com/rails/web-console] - gem "web-console" -end - -group :test do - # Use system testing [https://guides.rubyonrails.org/testing.html#system-testing] - gem "capybara" - gem "selenium-webdriver" -end diff --git a/projects/3/example/Gemfile.lock b/projects/3/example/Gemfile.lock deleted file mode 100644 index e2856cb..0000000 --- a/projects/3/example/Gemfile.lock +++ /dev/null @@ -1,380 +0,0 @@ -GEM - remote: https://rubygems.org/ - specs: - actioncable (8.0.1) - actionpack (= 8.0.1) - activesupport (= 8.0.1) - nio4r (~> 2.0) - websocket-driver (>= 0.6.1) - zeitwerk (~> 2.6) - actionmailbox (8.0.1) - actionpack (= 8.0.1) - activejob (= 8.0.1) - activerecord (= 8.0.1) - activestorage (= 8.0.1) - activesupport (= 8.0.1) - mail (>= 2.8.0) - actionmailer (8.0.1) - actionpack (= 8.0.1) - actionview (= 8.0.1) - activejob (= 8.0.1) - activesupport (= 8.0.1) - mail (>= 2.8.0) - rails-dom-testing (~> 2.2) - actionpack (8.0.1) - actionview (= 8.0.1) - activesupport (= 8.0.1) - nokogiri (>= 1.8.5) - rack (>= 2.2.4) - rack-session (>= 1.0.1) - rack-test (>= 0.6.3) - rails-dom-testing (~> 2.2) - rails-html-sanitizer (~> 1.6) - useragent (~> 0.16) - actiontext (8.0.1) - actionpack (= 8.0.1) - activerecord (= 8.0.1) - activestorage (= 8.0.1) - activesupport (= 8.0.1) - globalid (>= 0.6.0) - nokogiri (>= 1.8.5) - actionview (8.0.1) - activesupport (= 8.0.1) - builder (~> 3.1) - erubi (~> 1.11) - rails-dom-testing (~> 2.2) - rails-html-sanitizer (~> 1.6) - activejob (8.0.1) - activesupport (= 8.0.1) - globalid (>= 0.3.6) - activemodel (8.0.1) - activesupport (= 8.0.1) - activerecord (8.0.1) - activemodel (= 8.0.1) - activesupport (= 8.0.1) - timeout (>= 0.4.0) - activestorage (8.0.1) - actionpack (= 8.0.1) - activejob (= 8.0.1) - activerecord (= 8.0.1) - activesupport (= 8.0.1) - marcel (~> 1.0) - activesupport (8.0.1) - base64 - benchmark (>= 0.3) - bigdecimal - concurrent-ruby (~> 1.0, >= 1.3.1) - connection_pool (>= 2.2.5) - drb - i18n (>= 1.6, < 2) - logger (>= 1.4.2) - minitest (>= 5.1) - securerandom (>= 0.3) - tzinfo (~> 2.0, >= 2.0.5) - uri (>= 0.13.1) - addressable (2.8.7) - public_suffix (>= 2.0.2, < 7.0) - ast (2.4.2) - base64 (0.2.0) - bcrypt_pbkdf (1.1.1) - benchmark (0.4.0) - bigdecimal (3.1.9) - bindex (0.8.1) - bootsnap (1.18.4) - msgpack (~> 1.2) - brakeman (7.0.0) - racc - builder (3.3.0) - capybara (3.40.0) - addressable - matrix - mini_mime (>= 0.1.3) - nokogiri (~> 1.11) - rack (>= 1.6.0) - rack-test (>= 0.6.3) - regexp_parser (>= 1.5, < 3.0) - xpath (~> 3.2) - concurrent-ruby (1.3.4) - connection_pool (2.5.0) - crass (1.0.6) - date (3.4.1) - debug (1.10.0) - irb (~> 1.10) - reline (>= 0.3.8) - dotenv (3.1.7) - drb (2.2.1) - ed25519 (1.3.0) - erubi (1.13.1) - et-orbi (1.2.11) - tzinfo - fugit (1.11.1) - et-orbi (~> 1, >= 1.2.11) - raabro (~> 1.4) - globalid (1.2.1) - activesupport (>= 6.1) - i18n (1.14.6) - concurrent-ruby (~> 1.0) - importmap-rails (2.1.0) - actionpack (>= 6.0.0) - activesupport (>= 6.0.0) - railties (>= 6.0.0) - io-console (0.8.0) - irb (1.14.3) - rdoc (>= 4.0.0) - reline (>= 0.4.2) - jbuilder (2.13.0) - actionview (>= 5.0.0) - activesupport (>= 5.0.0) - json (2.9.1) - kamal (2.4.0) - activesupport (>= 7.0) - base64 (~> 0.2) - bcrypt_pbkdf (~> 1.0) - concurrent-ruby (~> 1.2) - dotenv (~> 3.1) - ed25519 (~> 1.2) - net-ssh (~> 7.3) - sshkit (>= 1.23.0, < 2.0) - thor (~> 1.3) - zeitwerk (>= 2.6.18, < 3.0) - language_server-protocol (3.17.0.3) - logger (1.6.5) - loofah (2.24.0) - crass (~> 1.0.2) - nokogiri (>= 1.12.0) - mail (2.8.1) - mini_mime (>= 0.1.1) - net-imap - net-pop - net-smtp - marcel (1.0.4) - matrix (0.4.2) - mini_mime (1.1.5) - minitest (5.25.4) - msgpack (1.7.5) - net-imap (0.5.5) - date - net-protocol - net-pop (0.1.2) - net-protocol - net-protocol (0.2.2) - timeout - net-scp (4.0.0) - net-ssh (>= 2.6.5, < 8.0.0) - net-sftp (4.0.0) - net-ssh (>= 5.0.0, < 8.0.0) - net-smtp (0.5.0) - net-ssh (7.3.0) - nio4r (2.7.4) - nokogiri (1.18.1-aarch64-linux-gnu) - racc (~> 1.4) - nokogiri (1.18.1-aarch64-linux-musl) - racc (~> 1.4) - nokogiri (1.18.1-arm-linux-gnu) - racc (~> 1.4) - nokogiri (1.18.1-arm-linux-musl) - racc (~> 1.4) - nokogiri (1.18.1-x86_64-darwin) - racc (~> 1.4) - nokogiri (1.18.1-x86_64-linux-gnu) - racc (~> 1.4) - nokogiri (1.18.1-x86_64-linux-musl) - racc (~> 1.4) - ostruct (0.6.1) - parallel (1.26.3) - parser (3.3.6.0) - ast (~> 2.4.1) - racc - propshaft (1.1.0) - actionpack (>= 7.0.0) - activesupport (>= 7.0.0) - rack - railties (>= 7.0.0) - psych (5.2.2) - date - stringio - public_suffix (6.0.1) - puma (6.5.0) - nio4r (~> 2.0) - raabro (1.4.0) - racc (1.8.1) - rack (3.1.8) - rack-session (2.1.0) - base64 (>= 0.1.0) - rack (>= 3.0.0) - rack-test (2.2.0) - rack (>= 1.3) - rackup (2.2.1) - rack (>= 3) - rails (8.0.1) - actioncable (= 8.0.1) - actionmailbox (= 8.0.1) - actionmailer (= 8.0.1) - actionpack (= 8.0.1) - actiontext (= 8.0.1) - actionview (= 8.0.1) - activejob (= 8.0.1) - activemodel (= 8.0.1) - activerecord (= 8.0.1) - activestorage (= 8.0.1) - activesupport (= 8.0.1) - bundler (>= 1.15.0) - railties (= 8.0.1) - rails-dom-testing (2.2.0) - activesupport (>= 5.0.0) - minitest - nokogiri (>= 1.6) - rails-html-sanitizer (1.6.2) - loofah (~> 2.21) - nokogiri (>= 1.15.7, != 1.16.7, != 1.16.6, != 1.16.5, != 1.16.4, != 1.16.3, != 1.16.2, != 1.16.1, != 1.16.0.rc1, != 1.16.0) - railties (8.0.1) - actionpack (= 8.0.1) - activesupport (= 8.0.1) - irb (~> 1.13) - rackup (>= 1.0.0) - rake (>= 12.2) - thor (~> 1.0, >= 1.2.2) - zeitwerk (~> 2.6) - rainbow (3.1.1) - rake (13.2.1) - rdoc (6.10.0) - psych (>= 4.0.0) - regexp_parser (2.10.0) - reline (0.6.0) - io-console (~> 0.5) - rexml (3.4.0) - rubocop (1.70.0) - json (~> 2.3) - language_server-protocol (>= 3.17.0) - parallel (~> 1.10) - parser (>= 3.3.0.2) - rainbow (>= 2.2.2, < 4.0) - regexp_parser (>= 2.9.3, < 3.0) - rubocop-ast (>= 1.36.2, < 2.0) - ruby-progressbar (~> 1.7) - unicode-display_width (>= 2.4.0, < 4.0) - rubocop-ast (1.37.0) - parser (>= 3.3.1.0) - rubocop-minitest (0.36.0) - rubocop (>= 1.61, < 2.0) - rubocop-ast (>= 1.31.1, < 2.0) - rubocop-performance (1.23.1) - rubocop (>= 1.48.1, < 2.0) - rubocop-ast (>= 1.31.1, < 2.0) - rubocop-rails (2.28.0) - activesupport (>= 4.2.0) - rack (>= 1.1) - rubocop (>= 1.52.0, < 2.0) - rubocop-ast (>= 1.31.1, < 2.0) - rubocop-rails-omakase (1.0.0) - rubocop - rubocop-minitest - rubocop-performance - rubocop-rails - ruby-progressbar (1.13.0) - rubyzip (2.4.1) - securerandom (0.4.1) - selenium-webdriver (4.27.0) - base64 (~> 0.2) - logger (~> 1.4) - rexml (~> 3.2, >= 3.2.5) - rubyzip (>= 1.2.2, < 3.0) - websocket (~> 1.0) - solid_cable (3.0.5) - actioncable (>= 7.2) - activejob (>= 7.2) - activerecord (>= 7.2) - railties (>= 7.2) - solid_cache (1.0.6) - activejob (>= 7.2) - activerecord (>= 7.2) - railties (>= 7.2) - solid_queue (1.1.2) - activejob (>= 7.1) - activerecord (>= 7.1) - concurrent-ruby (>= 1.3.1) - fugit (~> 1.11.0) - railties (>= 7.1) - thor (~> 1.3.1) - sqlite3 (2.5.0-aarch64-linux-gnu) - sqlite3 (2.5.0-aarch64-linux-musl) - sqlite3 (2.5.0-arm-linux-gnu) - sqlite3 (2.5.0-arm-linux-musl) - sqlite3 (2.5.0-x86_64-darwin) - sqlite3 (2.5.0-x86_64-linux-gnu) - sqlite3 (2.5.0-x86_64-linux-musl) - sshkit (1.23.2) - base64 - net-scp (>= 1.1.2) - net-sftp (>= 2.1.2) - net-ssh (>= 2.8.0) - ostruct - stimulus-rails (1.3.4) - railties (>= 6.0.0) - stringio (3.1.2) - thor (1.3.2) - thruster (0.1.10) - thruster (0.1.10-aarch64-linux) - thruster (0.1.10-x86_64-darwin) - thruster (0.1.10-x86_64-linux) - timeout (0.4.3) - turbo-rails (2.0.11) - actionpack (>= 6.0.0) - railties (>= 6.0.0) - tzinfo (2.0.6) - concurrent-ruby (~> 1.0) - unicode-display_width (3.1.3) - unicode-emoji (~> 4.0, >= 4.0.4) - unicode-emoji (4.0.4) - uri (1.0.2) - useragent (0.16.11) - web-console (4.2.1) - actionview (>= 6.0.0) - activemodel (>= 6.0.0) - bindex (>= 0.4.0) - railties (>= 6.0.0) - websocket (1.2.11) - websocket-driver (0.7.7) - base64 - websocket-extensions (>= 0.1.0) - websocket-extensions (0.1.5) - xpath (3.2.0) - nokogiri (~> 1.8) - zeitwerk (2.7.1) - -PLATFORMS - aarch64-linux - aarch64-linux-gnu - aarch64-linux-musl - arm-linux-gnu - arm-linux-musl - x86_64-darwin-24 - x86_64-linux - x86_64-linux-gnu - x86_64-linux-musl - -DEPENDENCIES - bootsnap - brakeman - capybara - debug - importmap-rails - jbuilder - kamal - propshaft - puma (>= 5.0) - rails (~> 8.0.1) - rubocop-rails-omakase - selenium-webdriver - solid_cable - solid_cache - solid_queue - sqlite3 (>= 2.1) - stimulus-rails - thruster - turbo-rails - tzinfo-data - web-console - -BUNDLED WITH - 2.6.2 diff --git a/projects/3/example/README.md b/projects/3/example/README.md deleted file mode 100644 index 7db80e4..0000000 --- a/projects/3/example/README.md +++ /dev/null @@ -1,24 +0,0 @@ -# README - -This README would normally document whatever steps are necessary to get the -application up and running. - -Things you may want to cover: - -* Ruby version - -* System dependencies - -* Configuration - -* Database creation - -* Database initialization - -* How to run the test suite - -* Services (job queues, cache servers, search engines, etc.) - -* Deployment instructions - -* ... diff --git a/projects/3/example/Rakefile b/projects/3/example/Rakefile deleted file mode 100644 index 9a5ea73..0000000 --- a/projects/3/example/Rakefile +++ /dev/null @@ -1,6 +0,0 @@ -# Add your own tasks in files placed in lib/tasks ending in .rake, -# for example lib/tasks/capistrano.rake, and they will automatically be available to Rake. - -require_relative "config/application" - -Rails.application.load_tasks diff --git a/projects/3/example/app/assets/images/.keep b/projects/3/example/app/assets/images/.keep deleted file mode 100644 index e69de29..0000000 --- a/projects/3/example/app/assets/images/.keep +++ /dev/null diff --git a/projects/3/example/app/assets/stylesheets/application.css b/projects/3/example/app/assets/stylesheets/application.css deleted file mode 100644 index fe93333..0000000 --- a/projects/3/example/app/assets/stylesheets/application.css +++ /dev/null @@ -1,10 +0,0 @@ -/* - * This is a manifest file that'll be compiled into application.css. - * - * With Propshaft, assets are served efficiently without preprocessing steps. You can still include - * application-wide styles in this file, but keep in mind that CSS precedence will follow the standard - * cascading order, meaning styles declared later in the document or manifest will override earlier ones, - * depending on specificity. - * - * Consider organizing styles into separate files for maintainability. - */ diff --git a/projects/3/example/app/controllers/application_controller.rb b/projects/3/example/app/controllers/application_controller.rb deleted file mode 100644 index 0d95db2..0000000 --- a/projects/3/example/app/controllers/application_controller.rb +++ /dev/null @@ -1,4 +0,0 @@ -class ApplicationController < ActionController::Base - # Only allow modern browsers supporting webp images, web push, badges, import maps, CSS nesting, and CSS :has. - allow_browser versions: :modern -end diff --git a/projects/3/example/app/controllers/concerns/.keep b/projects/3/example/app/controllers/concerns/.keep deleted file mode 100644 index e69de29..0000000 --- a/projects/3/example/app/controllers/concerns/.keep +++ /dev/null diff --git a/projects/3/example/app/helpers/application_helper.rb b/projects/3/example/app/helpers/application_helper.rb deleted file mode 100644 index de6be79..0000000 --- a/projects/3/example/app/helpers/application_helper.rb +++ /dev/null @@ -1,2 +0,0 @@ -module ApplicationHelper -end diff --git a/projects/3/example/app/jobs/application_job.rb b/projects/3/example/app/jobs/application_job.rb deleted file mode 100644 index d394c3d..0000000 --- a/projects/3/example/app/jobs/application_job.rb +++ /dev/null @@ -1,7 +0,0 @@ -class ApplicationJob < ActiveJob::Base - # Automatically retry jobs that encountered a deadlock - # retry_on ActiveRecord::Deadlocked - - # Most jobs are safe to ignore if the underlying records are no longer available - # discard_on ActiveJob::DeserializationError -end diff --git a/projects/3/example/app/mailers/application_mailer.rb b/projects/3/example/app/mailers/application_mailer.rb deleted file mode 100644 index 3c34c81..0000000 --- a/projects/3/example/app/mailers/application_mailer.rb +++ /dev/null @@ -1,4 +0,0 @@ -class ApplicationMailer < ActionMailer::Base - default from: "from@example.com" - layout "mailer" -end diff --git a/projects/3/example/app/models/application_record.rb b/projects/3/example/app/models/application_record.rb deleted file mode 100644 index b63caeb..0000000 --- a/projects/3/example/app/models/application_record.rb +++ /dev/null @@ -1,3 +0,0 @@ -class ApplicationRecord < ActiveRecord::Base - primary_abstract_class -end diff --git a/projects/3/example/app/models/concerns/.keep b/projects/3/example/app/models/concerns/.keep deleted file mode 100644 index e69de29..0000000 --- a/projects/3/example/app/models/concerns/.keep +++ /dev/null diff --git a/projects/3/example/app/views/layouts/application.html.erb b/projects/3/example/app/views/layouts/application.html.erb deleted file mode 100644 index 56d9cf8..0000000 --- a/projects/3/example/app/views/layouts/application.html.erb +++ /dev/null @@ -1,27 +0,0 @@ -<!DOCTYPE html> -<html> - <head> - <title><%= content_for(:title) || "Example" %></title> - <meta name="viewport" content="width=device-width,initial-scale=1"> - <meta name="apple-mobile-web-app-capable" content="yes"> - <meta name="mobile-web-app-capable" content="yes"> - <%= csrf_meta_tags %> - <%= csp_meta_tag %> - - <%= yield :head %> - - <%# Enable PWA manifest for installable apps (make sure to enable in config/routes.rb too!) %> - <%#= tag.link rel: "manifest", href: pwa_manifest_path(format: :json) %> - - <link rel="icon" href="/icon.png" type="image/png"> - <link rel="icon" href="/icon.svg" type="image/svg+xml"> - <link rel="apple-touch-icon" href="/icon.png"> - - <%# Includes all stylesheet files in app/assets/stylesheets %> - <%= stylesheet_link_tag :app, "data-turbo-track": "reload" %> - </head> - - <body> - <%= yield %> - </body> -</html> diff --git a/projects/3/example/app/views/layouts/mailer.html.erb b/projects/3/example/app/views/layouts/mailer.html.erb deleted file mode 100644 index 3aac900..0000000 --- a/projects/3/example/app/views/layouts/mailer.html.erb +++ /dev/null @@ -1,13 +0,0 @@ -<!DOCTYPE html> -<html> - <head> - <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> - <style> - /* Email styles need to be inline */ - </style> - </head> - - <body> - <%= yield %> - </body> -</html> diff --git a/projects/3/example/app/views/layouts/mailer.text.erb b/projects/3/example/app/views/layouts/mailer.text.erb deleted file mode 100644 index 37f0bdd..0000000 --- a/projects/3/example/app/views/layouts/mailer.text.erb +++ /dev/null @@ -1 +0,0 @@ -<%= yield %> diff --git a/projects/3/example/app/views/pwa/manifest.json.erb b/projects/3/example/app/views/pwa/manifest.json.erb deleted file mode 100644 index 25405df..0000000 --- a/projects/3/example/app/views/pwa/manifest.json.erb +++ /dev/null @@ -1,22 +0,0 @@ -{ - "name": "Example", - "icons": [ - { - "src": "/icon.png", - "type": "image/png", - "sizes": "512x512" - }, - { - "src": "/icon.png", - "type": "image/png", - "sizes": "512x512", - "purpose": "maskable" - } - ], - "start_url": "/", - "display": "standalone", - "scope": "/", - "description": "Example.", - "theme_color": "red", - "background_color": "red" -} diff --git a/projects/3/example/app/views/pwa/service-worker.js b/projects/3/example/app/views/pwa/service-worker.js deleted file mode 100644 index b3a13fb..0000000 --- a/projects/3/example/app/views/pwa/service-worker.js +++ /dev/null @@ -1,26 +0,0 @@ -// Add a service worker for processing Web Push notifications: -// -// self.addEventListener("push", async (event) => { -// const { title, options } = await event.data.json() -// event.waitUntil(self.registration.showNotification(title, options)) -// }) -// -// self.addEventListener("notificationclick", function(event) { -// event.notification.close() -// event.waitUntil( -// clients.matchAll({ type: "window" }).then((clientList) => { -// for (let i = 0; i < clientList.length; i++) { -// let client = clientList[i] -// let clientPath = (new URL(client.url)).pathname -// -// if (clientPath == event.notification.data.path && "focus" in client) { -// return client.focus() -// } -// } -// -// if (clients.openWindow) { -// return clients.openWindow(event.notification.data.path) -// } -// }) -// ) -// }) diff --git a/projects/3/example/bin/brakeman b/projects/3/example/bin/brakeman deleted file mode 100755 index ace1c9b..0000000 --- a/projects/3/example/bin/brakeman +++ /dev/null @@ -1,7 +0,0 @@ -#!/usr/bin/env ruby -require "rubygems" -require "bundler/setup" - -ARGV.unshift("--ensure-latest") - -load Gem.bin_path("brakeman", "brakeman") diff --git a/projects/3/example/bin/dev b/projects/3/example/bin/dev deleted file mode 100755 index 5f91c20..0000000 --- a/projects/3/example/bin/dev +++ /dev/null @@ -1,2 +0,0 @@ -#!/usr/bin/env ruby -exec "./bin/rails", "server", *ARGV diff --git a/projects/3/example/bin/docker-entrypoint b/projects/3/example/bin/docker-entrypoint deleted file mode 100755 index 57567d6..0000000 --- a/projects/3/example/bin/docker-entrypoint +++ /dev/null @@ -1,14 +0,0 @@ -#!/bin/bash -e - -# Enable jemalloc for reduced memory usage and latency. -if [ -z "${LD_PRELOAD+x}" ]; then - LD_PRELOAD=$(find /usr/lib -name libjemalloc.so.2 -print -quit) - export LD_PRELOAD -fi - -# If running the rails server then create or migrate existing database -if [ "${@: -2:1}" == "./bin/rails" ] && [ "${@: -1:1}" == "server" ]; then - ./bin/rails db:prepare -fi - -exec "${@}" diff --git a/projects/3/example/bin/rails b/projects/3/example/bin/rails deleted file mode 100755 index efc0377..0000000 --- a/projects/3/example/bin/rails +++ /dev/null @@ -1,4 +0,0 @@ -#!/usr/bin/env ruby -APP_PATH = File.expand_path("../config/application", __dir__) -require_relative "../config/boot" -require "rails/commands" diff --git a/projects/3/example/bin/rake b/projects/3/example/bin/rake deleted file mode 100755 index 4fbf10b..0000000 --- a/projects/3/example/bin/rake +++ /dev/null @@ -1,4 +0,0 @@ -#!/usr/bin/env ruby -require_relative "../config/boot" -require "rake" -Rake.application.run diff --git a/projects/3/example/bin/rubocop b/projects/3/example/bin/rubocop deleted file mode 100755 index 40330c0..0000000 --- a/projects/3/example/bin/rubocop +++ /dev/null @@ -1,8 +0,0 @@ -#!/usr/bin/env ruby -require "rubygems" -require "bundler/setup" - -# explicit rubocop config increases performance slightly while avoiding config confusion. -ARGV.unshift("--config", File.expand_path("../.rubocop.yml", __dir__)) - -load Gem.bin_path("rubocop", "rubocop") diff --git a/projects/3/example/bin/setup b/projects/3/example/bin/setup deleted file mode 100755 index be3db3c..0000000 --- a/projects/3/example/bin/setup +++ /dev/null @@ -1,34 +0,0 @@ -#!/usr/bin/env ruby -require "fileutils" - -APP_ROOT = File.expand_path("..", __dir__) - -def system!(*args) - system(*args, exception: true) -end - -FileUtils.chdir APP_ROOT do - # This script is a way to set up or update your development environment automatically. - # This script is idempotent, so that you can run it at any time and get an expectable outcome. - # Add necessary setup steps to this file. - - puts "== Installing dependencies ==" - system("bundle check") || system!("bundle install") - - # puts "\n== Copying sample files ==" - # unless File.exist?("config/database.yml") - # FileUtils.cp "config/database.yml.sample", "config/database.yml" - # end - - puts "\n== Preparing database ==" - system! "bin/rails db:prepare" - - puts "\n== Removing old logs and tempfiles ==" - system! "bin/rails log:clear tmp:clear" - - unless ARGV.include?("--skip-server") - puts "\n== Starting development server ==" - STDOUT.flush # flush the output before exec(2) so that it displays - exec "bin/dev" - end -end diff --git a/projects/3/example/bin/thrust b/projects/3/example/bin/thrust deleted file mode 100755 index 36bde2d..0000000 --- a/projects/3/example/bin/thrust +++ /dev/null @@ -1,5 +0,0 @@ -#!/usr/bin/env ruby -require "rubygems" -require "bundler/setup" - -load Gem.bin_path("thruster", "thrust") diff --git a/projects/3/example/config.ru b/projects/3/example/config.ru deleted file mode 100644 index 4a3c09a..0000000 --- a/projects/3/example/config.ru +++ /dev/null @@ -1,6 +0,0 @@ -# This file is used by Rack-based servers to start the application. - -require_relative "config/environment" - -run Rails.application -Rails.application.load_server diff --git a/projects/3/example/config/application.rb b/projects/3/example/config/application.rb deleted file mode 100644 index 215ee5a..0000000 --- a/projects/3/example/config/application.rb +++ /dev/null @@ -1,28 +0,0 @@ -require_relative "boot" - -require "rails/all" - -# Require the gems listed in Gemfile, including any gems -# you've limited to :test, :development, or :production. -Bundler.require(*Rails.groups) - -module Example - class Application < Rails::Application - # Initialize configuration defaults for originally generated Rails version. - config.load_defaults 8.0 - - # Please, add to the `ignore` list any other `lib` subdirectories that do - # not contain `.rb` files, or that should not be reloaded or eager loaded. - # Common ones are `templates`, `generators`, or `middleware`, for example. - config.autoload_lib(ignore: %w[assets tasks]) - - # Configuration for the application, engines, and railties goes here. - # - # These settings can be overridden in specific environments using the files - # in config/environments, which are processed later. - # - # config.time_zone = "Central Time (US & Canada)" - # config.eager_load_paths << Rails.root.join("extras") - config.active_record.schema_format = :sql - end -end diff --git a/projects/3/example/config/boot.rb b/projects/3/example/config/boot.rb deleted file mode 100644 index 988a5dd..0000000 --- a/projects/3/example/config/boot.rb +++ /dev/null @@ -1,4 +0,0 @@ -ENV["BUNDLE_GEMFILE"] ||= File.expand_path("../Gemfile", __dir__) - -require "bundler/setup" # Set up gems listed in the Gemfile. -require "bootsnap/setup" # Speed up boot time by caching expensive operations. diff --git a/projects/3/example/config/cable.yml b/projects/3/example/config/cable.yml deleted file mode 100644 index 515b711..0000000 --- a/projects/3/example/config/cable.yml +++ /dev/null @@ -1,10 +0,0 @@ -development: - adapter: async - -test: - adapter: test - -production: - adapter: redis - url: <%= ENV.fetch("REDIS_URL") { "redis://localhost:6379/1" } %> - channel_prefix: example_production diff --git a/projects/3/example/config/credentials.yml.enc b/projects/3/example/config/credentials.yml.enc deleted file mode 100644 index bd0fae3..0000000 --- a/projects/3/example/config/credentials.yml.enc +++ /dev/null @@ -1 +0,0 @@ -7BMSZsPUM7qT78BslvcdsunRZoH1xx5126VpoA/8f9PqJpIZEWCDlFV0OWqbW5AwGmu1H+6MSIstu2JExiRBFSa7ImNX+7243/2YrRK935KCCG//nKD+YOnnmeqvQca5Xn5rcTTBUogf9S9QtT1AiCGqVkhhPa+L7oWCJt+O9b1dbmtPAi4L6YP6pPWel4P6SiHR6wPpebnBj6qcHEMTWGF1xDTETyXNzk92TDmKJReesn8xQoQU4Wdj2cSJEUKVMQcjZ/IpetIxZKATLR9SmUe2Vk/oYV3aZeUM6K4btzqeS/lYl4lrkX0JodiXyspY74mRPzBD6Sa9BCDnOWBnPJTOMIkkT/EnLRWV57bUtfmQhsFABzp7qxKjznpb9vDTydTwpqB2SiM1iguKVrr+kFctGXDJicOu2/xMyWXPuQagxtI3rJKiPgwJb1GZkd7kFNKM8eEib10/kilwgs6KHueffAcUYBfljyq0lmsx2vgN7oxZxrt65cr6--2LpKPOypkuiK45am--6YZ/7PmUoaYpNImYOIJ58A==
\ No newline at end of file diff --git a/projects/3/example/config/database.yml b/projects/3/example/config/database.yml deleted file mode 100644 index 2640cb5..0000000 --- a/projects/3/example/config/database.yml +++ /dev/null @@ -1,41 +0,0 @@ -# SQLite. Versions 3.8.0 and up are supported. -# gem install sqlite3 -# -# Ensure the SQLite 3 gem is defined in your Gemfile -# gem "sqlite3" -# -default: &default - adapter: sqlite3 - pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %> - timeout: 5000 - -development: - <<: *default - database: storage/development.sqlite3 - -# Warning: The database defined as "test" will be erased and -# re-generated from your development database when you run "rake". -# Do not set this db to the same as development or production. -test: - <<: *default - database: storage/test.sqlite3 - - -# Store production database in the storage/ directory, which by default -# is mounted as a persistent Docker volume in config/deploy.yml. -production: - primary: - <<: *default - database: storage/production.sqlite3 - cache: - <<: *default - database: storage/production_cache.sqlite3 - migrations_paths: db/cache_migrate - queue: - <<: *default - database: storage/production_queue.sqlite3 - migrations_paths: db/queue_migrate - cable: - <<: *default - database: storage/production_cable.sqlite3 - migrations_paths: db/cable_migrate diff --git a/projects/3/example/config/environment.rb b/projects/3/example/config/environment.rb deleted file mode 100644 index cac5315..0000000 --- a/projects/3/example/config/environment.rb +++ /dev/null @@ -1,5 +0,0 @@ -# Load the Rails application. -require_relative "application" - -# Initialize the Rails application. -Rails.application.initialize! diff --git a/projects/3/example/config/environments/development.rb b/projects/3/example/config/environments/development.rb deleted file mode 100644 index 4cc21c4..0000000 --- a/projects/3/example/config/environments/development.rb +++ /dev/null @@ -1,72 +0,0 @@ -require "active_support/core_ext/integer/time" - -Rails.application.configure do - # Settings specified here will take precedence over those in config/application.rb. - - # Make code changes take effect immediately without server restart. - config.enable_reloading = true - - # Do not eager load code on boot. - config.eager_load = false - - # Show full error reports. - config.consider_all_requests_local = true - - # Enable server timing. - config.server_timing = true - - # Enable/disable Action Controller caching. By default Action Controller caching is disabled. - # Run rails dev:cache to toggle Action Controller caching. - if Rails.root.join("tmp/caching-dev.txt").exist? - config.action_controller.perform_caching = true - config.action_controller.enable_fragment_cache_logging = true - config.public_file_server.headers = { "cache-control" => "public, max-age=#{2.days.to_i}" } - else - config.action_controller.perform_caching = false - end - - # Change to :null_store to avoid any caching. - config.cache_store = :memory_store - - # Store uploaded files on the local file system (see config/storage.yml for options). - config.active_storage.service = :local - - # Don't care if the mailer can't send. - config.action_mailer.raise_delivery_errors = false - - # Make template changes take effect immediately. - config.action_mailer.perform_caching = false - - # Set localhost to be used by links generated in mailer templates. - config.action_mailer.default_url_options = { host: "localhost", port: 3000 } - - # Print deprecation notices to the Rails logger. - config.active_support.deprecation = :log - - # Raise an error on page load if there are pending migrations. - config.active_record.migration_error = :page_load - - # Highlight code that triggered database queries in logs. - config.active_record.verbose_query_logs = true - - # Append comments with runtime information tags to SQL queries in logs. - config.active_record.query_log_tags_enabled = true - - # Highlight code that enqueued background job in logs. - config.active_job.verbose_enqueue_logs = true - - # Raises error for missing translations. - # config.i18n.raise_on_missing_translations = true - - # Annotate rendered view with file names. - config.action_view.annotate_rendered_view_with_filenames = true - - # Uncomment if you wish to allow Action Cable access from any origin. - # config.action_cable.disable_request_forgery_protection = true - - # Raise error when a before_action's only/except options reference missing actions. - config.action_controller.raise_on_missing_callback_actions = true - - # Apply autocorrection by RuboCop to files generated by `bin/rails generate`. - # config.generators.apply_rubocop_autocorrect_after_generate! -end diff --git a/projects/3/example/config/environments/production.rb b/projects/3/example/config/environments/production.rb deleted file mode 100644 index 1749607..0000000 --- a/projects/3/example/config/environments/production.rb +++ /dev/null @@ -1,89 +0,0 @@ -require "active_support/core_ext/integer/time" - -Rails.application.configure do - # Settings specified here will take precedence over those in config/application.rb. - - # Code is not reloaded between requests. - config.enable_reloading = false - - # Eager load code on boot for better performance and memory savings (ignored by Rake tasks). - config.eager_load = true - - # Full error reports are disabled. - config.consider_all_requests_local = false - - # Turn on fragment caching in view templates. - config.action_controller.perform_caching = true - - # Cache assets for far-future expiry since they are all digest stamped. - config.public_file_server.headers = { "cache-control" => "public, max-age=#{1.year.to_i}" } - - # Enable serving of images, stylesheets, and JavaScripts from an asset server. - # config.asset_host = "http://assets.example.com" - - # Store uploaded files on the local file system (see config/storage.yml for options). - config.active_storage.service = :local - - # Assume all access to the app is happening through a SSL-terminating reverse proxy. - config.assume_ssl = true - - # Force all access to the app over SSL, use Strict-Transport-Security, and use secure cookies. - config.force_ssl = true - - # Skip http-to-https redirect for the default health check endpoint. - # config.ssl_options = { redirect: { exclude: ->(request) { request.path == "/up" } } } - - # Log to STDOUT with the current request id as a default log tag. - config.log_tags = [ :request_id ] - config.logger = ActiveSupport::TaggedLogging.logger(STDOUT) - - # Change to "debug" to log everything (including potentially personally-identifiable information!) - config.log_level = ENV.fetch("RAILS_LOG_LEVEL", "info") - - # Prevent health checks from clogging up the logs. - config.silence_healthcheck_path = "/up" - - # Don't log any deprecations. - config.active_support.report_deprecations = false - - # Replace the default in-process memory cache store with a durable alternative. - # config.cache_store = :mem_cache_store - - # Replace the default in-process and non-durable queuing backend for Active Job. - # config.active_job.queue_adapter = :resque - - # Ignore bad email addresses and do not raise email delivery errors. - # Set this to true and configure the email server for immediate delivery to raise delivery errors. - # config.action_mailer.raise_delivery_errors = false - - # Set host to be used by links generated in mailer templates. - config.action_mailer.default_url_options = { host: "example.com" } - - # Specify outgoing SMTP server. Remember to add smtp/* credentials via rails credentials:edit. - # config.action_mailer.smtp_settings = { - # user_name: Rails.application.credentials.dig(:smtp, :user_name), - # password: Rails.application.credentials.dig(:smtp, :password), - # address: "smtp.example.com", - # port: 587, - # authentication: :plain - # } - - # Enable locale fallbacks for I18n (makes lookups for any locale fall back to - # the I18n.default_locale when a translation cannot be found). - config.i18n.fallbacks = true - - # Do not dump schema after migrations. - config.active_record.dump_schema_after_migration = false - - # Only use :id for inspections in production. - config.active_record.attributes_for_inspect = [ :id ] - - # Enable DNS rebinding protection and other `Host` header attacks. - # config.hosts = [ - # "example.com", # Allow requests from example.com - # /.*\.example\.com/ # Allow requests from subdomains like `www.example.com` - # ] - # - # Skip DNS rebinding protection for the default health check endpoint. - # config.host_authorization = { exclude: ->(request) { request.path == "/up" } } -end diff --git a/projects/3/example/config/environments/test.rb b/projects/3/example/config/environments/test.rb deleted file mode 100644 index c2095b1..0000000 --- a/projects/3/example/config/environments/test.rb +++ /dev/null @@ -1,53 +0,0 @@ -# The test environment is used exclusively to run your application's -# test suite. You never need to work with it otherwise. Remember that -# your test database is "scratch space" for the test suite and is wiped -# and recreated between test runs. Don't rely on the data there! - -Rails.application.configure do - # Settings specified here will take precedence over those in config/application.rb. - - # While tests run files are not watched, reloading is not necessary. - config.enable_reloading = false - - # Eager loading loads your entire application. When running a single test locally, - # this is usually not necessary, and can slow down your test suite. However, it's - # recommended that you enable it in continuous integration systems to ensure eager - # loading is working properly before deploying your code. - config.eager_load = ENV["CI"].present? - - # Configure public file server for tests with cache-control for performance. - config.public_file_server.headers = { "cache-control" => "public, max-age=3600" } - - # Show full error reports. - config.consider_all_requests_local = true - config.cache_store = :null_store - - # Render exception templates for rescuable exceptions and raise for other exceptions. - config.action_dispatch.show_exceptions = :rescuable - - # Disable request forgery protection in test environment. - config.action_controller.allow_forgery_protection = false - - # Store uploaded files on the local file system in a temporary directory. - config.active_storage.service = :test - - # Tell Action Mailer not to deliver emails to the real world. - # The :test delivery method accumulates sent emails in the - # ActionMailer::Base.deliveries array. - config.action_mailer.delivery_method = :test - - # Set host to be used by links generated in mailer templates. - config.action_mailer.default_url_options = { host: "example.com" } - - # Print deprecation notices to the stderr. - config.active_support.deprecation = :stderr - - # Raises error for missing translations. - # config.i18n.raise_on_missing_translations = true - - # Annotate rendered view with file names. - # config.action_view.annotate_rendered_view_with_filenames = true - - # Raise error when a before_action's only/except options reference missing actions. - config.action_controller.raise_on_missing_callback_actions = true -end diff --git a/projects/3/example/config/initializers/assets.rb b/projects/3/example/config/initializers/assets.rb deleted file mode 100644 index 4873244..0000000 --- a/projects/3/example/config/initializers/assets.rb +++ /dev/null @@ -1,7 +0,0 @@ -# Be sure to restart your server when you modify this file. - -# Version of your assets, change this if you want to expire all your assets. -Rails.application.config.assets.version = "1.0" - -# Add additional assets to the asset load path. -# Rails.application.config.assets.paths << Emoji.images_path diff --git a/projects/3/example/config/initializers/content_security_policy.rb b/projects/3/example/config/initializers/content_security_policy.rb deleted file mode 100644 index b3076b3..0000000 --- a/projects/3/example/config/initializers/content_security_policy.rb +++ /dev/null @@ -1,25 +0,0 @@ -# Be sure to restart your server when you modify this file. - -# Define an application-wide content security policy. -# See the Securing Rails Applications Guide for more information: -# https://guides.rubyonrails.org/security.html#content-security-policy-header - -# Rails.application.configure do -# config.content_security_policy do |policy| -# policy.default_src :self, :https -# policy.font_src :self, :https, :data -# policy.img_src :self, :https, :data -# policy.object_src :none -# policy.script_src :self, :https -# policy.style_src :self, :https -# # Specify URI for violation reports -# # policy.report_uri "/csp-violation-report-endpoint" -# end -# -# # Generate session nonces for permitted importmap, inline scripts, and inline styles. -# config.content_security_policy_nonce_generator = ->(request) { request.session.id.to_s } -# config.content_security_policy_nonce_directives = %w(script-src style-src) -# -# # Report violations without enforcing the policy. -# # config.content_security_policy_report_only = true -# end diff --git a/projects/3/example/config/initializers/filter_parameter_logging.rb b/projects/3/example/config/initializers/filter_parameter_logging.rb deleted file mode 100644 index c0b717f..0000000 --- a/projects/3/example/config/initializers/filter_parameter_logging.rb +++ /dev/null @@ -1,8 +0,0 @@ -# Be sure to restart your server when you modify this file. - -# Configure parameters to be partially matched (e.g. passw matches password) and filtered from the log file. -# Use this to limit dissemination of sensitive information. -# See the ActiveSupport::ParameterFilter documentation for supported notations and behaviors. -Rails.application.config.filter_parameters += [ - :passw, :email, :secret, :token, :_key, :crypt, :salt, :certificate, :otp, :ssn, :cvv, :cvc -] diff --git a/projects/3/example/config/initializers/inflections.rb b/projects/3/example/config/initializers/inflections.rb deleted file mode 100644 index 3860f65..0000000 --- a/projects/3/example/config/initializers/inflections.rb +++ /dev/null @@ -1,16 +0,0 @@ -# Be sure to restart your server when you modify this file. - -# Add new inflection rules using the following format. Inflections -# are locale specific, and you may define rules for as many different -# locales as you wish. All of these examples are active by default: -# ActiveSupport::Inflector.inflections(:en) do |inflect| -# inflect.plural /^(ox)$/i, "\\1en" -# inflect.singular /^(ox)en/i, "\\1" -# inflect.irregular "person", "people" -# inflect.uncountable %w( fish sheep ) -# end - -# These inflection rules are supported but not enabled by default: -# ActiveSupport::Inflector.inflections(:en) do |inflect| -# inflect.acronym "RESTful" -# end diff --git a/projects/3/example/config/locales/en.yml b/projects/3/example/config/locales/en.yml deleted file mode 100644 index 6c349ae..0000000 --- a/projects/3/example/config/locales/en.yml +++ /dev/null @@ -1,31 +0,0 @@ -# Files in the config/locales directory are used for internationalization and -# are automatically loaded by Rails. If you want to use locales other than -# English, add the necessary files in this directory. -# -# To use the locales, use `I18n.t`: -# -# I18n.t "hello" -# -# In views, this is aliased to just `t`: -# -# <%= t("hello") %> -# -# To use a different locale, set it with `I18n.locale`: -# -# I18n.locale = :es -# -# This would use the information in config/locales/es.yml. -# -# To learn more about the API, please read the Rails Internationalization guide -# at https://guides.rubyonrails.org/i18n.html. -# -# Be aware that YAML interprets the following case-insensitive strings as -# booleans: `true`, `false`, `on`, `off`, `yes`, `no`. Therefore, these strings -# must be quoted to be interpreted as strings. For example: -# -# en: -# "yes": yup -# enabled: "ON" - -en: - hello: "Hello world" diff --git a/projects/3/example/config/puma.rb b/projects/3/example/config/puma.rb deleted file mode 100644 index a248513..0000000 --- a/projects/3/example/config/puma.rb +++ /dev/null @@ -1,41 +0,0 @@ -# This configuration file will be evaluated by Puma. The top-level methods that -# are invoked here are part of Puma's configuration DSL. For more information -# about methods provided by the DSL, see https://puma.io/puma/Puma/DSL.html. -# -# Puma starts a configurable number of processes (workers) and each process -# serves each request in a thread from an internal thread pool. -# -# You can control the number of workers using ENV["WEB_CONCURRENCY"]. You -# should only set this value when you want to run 2 or more workers. The -# default is already 1. -# -# The ideal number of threads per worker depends both on how much time the -# application spends waiting for IO operations and on how much you wish to -# prioritize throughput over latency. -# -# As a rule of thumb, increasing the number of threads will increase how much -# traffic a given process can handle (throughput), but due to CRuby's -# Global VM Lock (GVL) it has diminishing returns and will degrade the -# response time (latency) of the application. -# -# The default is set to 3 threads as it's deemed a decent compromise between -# throughput and latency for the average Rails application. -# -# Any libraries that use a connection pool or another resource pool should -# be configured to provide at least as many connections as the number of -# threads. This includes Active Record's `pool` parameter in `database.yml`. -threads_count = ENV.fetch("RAILS_MAX_THREADS", 3) -threads threads_count, threads_count - -# Specifies the `port` that Puma will listen on to receive requests; default is 3000. -port ENV.fetch("PORT", 3000) - -# Allow puma to be restarted by `bin/rails restart` command. -plugin :tmp_restart - -# Run the Solid Queue supervisor inside of Puma for single-server deployments -plugin :solid_queue if ENV["SOLID_QUEUE_IN_PUMA"] - -# Specify the PID file. Defaults to tmp/pids/server.pid in development. -# In other environments, only set the PID file if requested. -pidfile ENV["PIDFILE"] if ENV["PIDFILE"] diff --git a/projects/3/example/config/routes.rb b/projects/3/example/config/routes.rb deleted file mode 100644 index 48254e8..0000000 --- a/projects/3/example/config/routes.rb +++ /dev/null @@ -1,14 +0,0 @@ -Rails.application.routes.draw do - # Define your application routes per the DSL in https://guides.rubyonrails.org/routing.html - - # Reveal health status on /up that returns 200 if the app boots with no exceptions, otherwise 500. - # Can be used by load balancers and uptime monitors to verify that the app is live. - get "up" => "rails/health#show", as: :rails_health_check - - # Render dynamic PWA files from app/views/pwa/* (remember to link manifest in application.html.erb) - # get "manifest" => "rails/pwa#manifest", as: :pwa_manifest - # get "service-worker" => "rails/pwa#service_worker", as: :pwa_service_worker - - # Defines the root path route ("/") - # root "posts#index" -end diff --git a/projects/3/example/config/storage.yml b/projects/3/example/config/storage.yml deleted file mode 100644 index 4942ab6..0000000 --- a/projects/3/example/config/storage.yml +++ /dev/null @@ -1,34 +0,0 @@ -test: - service: Disk - root: <%= Rails.root.join("tmp/storage") %> - -local: - service: Disk - root: <%= Rails.root.join("storage") %> - -# Use bin/rails credentials:edit to set the AWS secrets (as aws:access_key_id|secret_access_key) -# amazon: -# service: S3 -# access_key_id: <%= Rails.application.credentials.dig(:aws, :access_key_id) %> -# secret_access_key: <%= Rails.application.credentials.dig(:aws, :secret_access_key) %> -# region: us-east-1 -# bucket: your_own_bucket-<%= Rails.env %> - -# Remember not to checkin your GCS keyfile to a repository -# google: -# service: GCS -# project: your_project -# credentials: <%= Rails.root.join("path/to/gcs.keyfile") %> -# bucket: your_own_bucket-<%= Rails.env %> - -# Use bin/rails credentials:edit to set the Azure Storage secret (as azure_storage:storage_access_key) -# microsoft: -# service: AzureStorage -# storage_account_name: your_account_name -# storage_access_key: <%= Rails.application.credentials.dig(:azure_storage, :storage_access_key) %> -# container: your_container_name-<%= Rails.env %> - -# mirror: -# service: Mirror -# primary: local -# mirrors: [ amazon, google, microsoft ] diff --git a/projects/3/example/db/seeds.rb b/projects/3/example/db/seeds.rb deleted file mode 100644 index 4fbd6ed..0000000 --- a/projects/3/example/db/seeds.rb +++ /dev/null @@ -1,9 +0,0 @@ -# This file should ensure the existence of records required to run the application in every environment (production, -# development, test). The code here should be idempotent so that it can be executed at any point in every environment. -# The data can then be loaded with the bin/rails db:seed command (or created alongside the database with db:setup). -# -# Example: -# -# ["Action", "Comedy", "Drama", "Horror"].each do |genre_name| -# MovieGenre.find_or_create_by!(name: genre_name) -# end diff --git a/projects/3/example/db/structure.sql b/projects/3/example/db/structure.sql deleted file mode 100644 index 7d96d16..0000000 --- a/projects/3/example/db/structure.sql +++ /dev/null @@ -1,4 +0,0 @@ -CREATE TABLE IF NOT EXISTS "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY); -CREATE TABLE IF NOT EXISTS "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL); - - diff --git a/projects/3/example/lib/tasks/.keep b/projects/3/example/lib/tasks/.keep deleted file mode 100644 index e69de29..0000000 --- a/projects/3/example/lib/tasks/.keep +++ /dev/null diff --git a/projects/3/example/log/.keep b/projects/3/example/log/.keep deleted file mode 100644 index e69de29..0000000 --- a/projects/3/example/log/.keep +++ /dev/null diff --git a/projects/3/example/public/400.html b/projects/3/example/public/400.html deleted file mode 100644 index 282dbc8..0000000 --- a/projects/3/example/public/400.html +++ /dev/null @@ -1,114 +0,0 @@ -<!doctype html> - -<html lang="en"> - - <head> - - <title>The server cannot process the request due to a client error (400 Bad Request)</title> - - <meta charset="utf-8"> - <meta name="viewport" content="initial-scale=1, width=device-width"> - <meta name="robots" content="noindex, nofollow"> - - <style> - - *, *::before, *::after { - box-sizing: border-box; - } - - * { - margin: 0; - } - - html { - font-size: 16px; - } - - body { - background: #FFF; - color: #261B23; - display: grid; - font-family: ui-sans-serif, system-ui, -apple-system, BlinkMacSystemFont, Aptos, Roboto, "Segoe UI", "Helvetica Neue", Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; - font-size: clamp(1rem, 2.5vw, 2rem); - -webkit-font-smoothing: antialiased; - font-style: normal; - font-weight: 400; - letter-spacing: -0.0025em; - line-height: 1.4; - min-height: 100vh; - place-items: center; - text-rendering: optimizeLegibility; - -webkit-text-size-adjust: 100%; - } - - a { - color: inherit; - font-weight: 700; - text-decoration: underline; - text-underline-offset: 0.0925em; - } - - b, strong { - font-weight: 700; - } - - i, em { - font-style: italic; - } - - main { - display: grid; - gap: 1em; - padding: 2em; - place-items: center; - text-align: center; - } - - main header { - width: min(100%, 12em); - } - - main header svg { - height: auto; - max-width: 100%; - width: 100%; - } - - main article { - width: min(100%, 30em); - } - - main article p { - font-size: 75%; - } - - main article br { - - display: none; - - @media(min-width: 48em) { - display: inline; - } - - } - - </style> - - </head> - - <body> - - <!-- This file lives in public/400.html --> - - <main> - <header> - <svg height="172" viewBox="0 0 480 172" width="480" xmlns="http://www.w3.org/2000/svg"><path d="m124.48 3.00509-45.6889 100.02991h26.2239v-28.1168h38.119v28.1168h21.628v35.145h-21.628v30.82h-37.308v-30.82h-72.1833v-31.901l50.2851-103.27391zm115.583 168.69891c-40.822 0-64.884-35.146-64.884-85.7015 0-50.5554 24.062-85.700907 64.884-85.700907 40.823 0 64.884 35.145507 64.884 85.700907 0 50.5555-24.061 85.7015-64.884 85.7015zm0-133.2831c-17.572 0-22.709 21.8984-22.709 47.5816 0 25.6835 5.137 47.5815 22.709 47.5815 17.303 0 22.71-21.898 22.71-47.5815 0-25.6832-5.407-47.5816-22.71-47.5816zm140.456 133.2831c-40.823 0-64.884-35.146-64.884-85.7015 0-50.5554 24.061-85.700907 64.884-85.700907 40.822 0 64.884 35.145507 64.884 85.700907 0 50.5555-24.062 85.7015-64.884 85.7015zm0-133.2831c-17.573 0-22.71 21.8984-22.71 47.5816 0 25.6835 5.137 47.5815 22.71 47.5815 17.302 0 22.709-21.898 22.709-47.5815 0-25.6832-5.407-47.5816-22.709-47.5816z" fill="#f0eff0"/><path d="m123.606 85.4445c3.212 1.0523 5.538 4.2089 5.538 8.0301 0 6.1472-4.209 9.5254-11.298 9.5254h-15.617v-34.0033h14.565c7.089 0 11.353 3.1566 11.353 9.2484 0 3.6551-2.049 6.3134-4.541 7.1994zm-12.904-2.9905h5.095c2.603 0 3.988-.9968 3.988-3.1013 0-2.1044-1.385-3.0459-3.988-3.0459h-5.095zm0 6.6456v6.5902h5.981c2.492 0 3.877-1.3291 3.877-3.2674 0-2.049-1.385-3.3228-3.877-3.3228zm43.786 13.9004h-8.362v-1.274c-.831.831-3.323 1.717-5.981 1.717-4.929 0-9.083-2.769-9.083-8.0301 0-4.818 4.154-7.9193 9.581-7.9193 2.049 0 4.486.6646 5.483 1.3845v-1.606c0-1.606-.942-2.9905-3.046-2.9905-1.606 0-2.548.7199-2.935 1.8275h-8.197c.72-4.8181 4.985-8.6393 11.409-8.6393 7.088 0 11.131 3.7659 11.131 10.2453zm-8.362-6.9779v-1.4399c-.554-1.0522-2.049-1.7167-3.655-1.7167-1.717 0-3.434.7199-3.434 2.3813 0 1.7168 1.717 2.4367 3.434 2.4367 1.606 0 3.101-.6645 3.655-1.6614zm27.996 6.9779v-1.994c-1.163 1.329-3.599 2.548-6.147 2.548-7.199 0-11.131-5.8151-11.131-13.0145s3.932-13.0143 11.131-13.0143c2.548 0 4.984 1.2184 6.147 2.5475v-13.0697h8.695v35.997zm0-9.1931v-6.5902c-.664-1.3291-2.159-2.326-3.821-2.326-2.99 0-4.763 2.4368-4.763 5.6488s1.773 5.5934 4.763 5.5934c1.717 0 3.157-.9415 3.821-2.326zm35.471-2.049h-3.101v11.2421h-8.806v-34.0033h15.285c7.31 0 12.35 4.1535 12.35 11.5744 0 5.1503-2.603 8.6947-6.757 10.2453l7.975 12.1836h-9.858zm-3.101-15.2849v8.1962h5.538c3.156 0 4.596-1.606 4.596-4.0981s-1.44-4.0981-4.596-4.0981zm36.957 17.8323h8.03c-.886 5.7597-5.206 9.2487-11.685 9.2487-7.643 0-12.682-5.2613-12.682-13.0145 0-7.6978 5.316-13.0143 12.515-13.0143 7.643 0 11.962 5.095 11.962 12.5159v2.1598h-16.115c.277 2.9905 1.827 4.5965 4.32 4.5965 1.772 0 3.156-.7753 3.655-2.4921zm-3.822-10.0237c-2.049 0-3.433 1.2737-3.987 3.5997h7.532c-.111-2.0491-1.385-3.5997-3.545-3.5997zm30.98 27.5234v-10.799c-1.163 1.329-3.6 2.548-6.147 2.548-7.2 0-11.132-5.9259-11.132-13.0145 0-7.144 3.932-13.0143 11.132-13.0143 2.547 0 4.984 1.2184 6.147 2.5475v-1.9937h8.695v33.726zm0-17.9981v-6.5902c-.665-1.3291-2.105-2.326-3.821-2.326-2.991 0-4.763 2.4368-4.763 5.6488s1.772 5.5934 4.763 5.5934c1.661 0 3.156-.9415 3.821-2.326zm36.789-15.7279v24.921h-8.695v-2.16c-1.329 1.551-3.821 2.714-6.646 2.714-5.482 0-8.75-3.5999-8.75-9.1379v-16.3371h8.64v14.288c0 2.1045.996 3.5997 3.212 3.5997 1.606 0 3.101-1.0522 3.544-2.769v-15.1187zm19.084 16.2263h8.03c-.886 5.7597-5.206 9.2487-11.685 9.2487-7.643 0-12.682-5.2613-12.682-13.0145 0-7.6978 5.316-13.0143 12.515-13.0143 7.643 0 11.963 5.095 11.963 12.5159v2.1598h-16.116c.277 2.9905 1.828 4.5965 4.32 4.5965 1.772 0 3.156-.7753 3.655-2.4921zm-3.822-10.0237c-2.049 0-3.433 1.2737-3.987 3.5997h7.532c-.111-2.0491-1.385-3.5997-3.545-3.5997zm13.428 11.0206h8.474c.387 1.3845 1.606 2.1598 3.156 2.1598 1.44 0 2.548-.5538 2.548-1.7168 0-.9414-.72-1.2737-1.939-1.5506l-4.873-.9969c-4.154-.886-6.867-2.8797-6.867-7.2547 0-5.3165 4.762-8.4178 10.633-8.4178 6.812 0 10.522 3.1567 11.297 8.0855h-8.03c-.277-1.0522-1.052-1.9937-3.046-1.9937-1.273 0-2.326.5538-2.326 1.6614 0 .7753.554 1.163 1.717 1.3845l4.929 1.163c4.541 1.0522 6.978 3.4335 6.978 7.4763 0 5.3168-4.818 8.2518-10.91 8.2518-6.369 0-10.965-2.88-11.741-8.2518zm27.538-.8861v-9.5807h-3.655v-6.7564h3.655v-6.8671h8.584v6.8671h5.205v6.7564h-5.205v8.307c0 1.9383.941 2.769 2.658 2.769.941 0 1.993-.2216 2.769-.5538v7.3654c-.997.443-2.88.775-4.818.775-5.871 0-9.193-2.769-9.193-9.0819z" fill="#d30001"/></svg> - </header> - <article> - <p><strong>The server cannot process the request due to a client error.</strong> Please check the request and try again. If you’re the application owner check the logs for more information.</p> - </article> - </main> - - </body> - -</html> diff --git a/projects/3/example/public/404.html b/projects/3/example/public/404.html deleted file mode 100644 index c0670bc..0000000 --- a/projects/3/example/public/404.html +++ /dev/null @@ -1,114 +0,0 @@ -<!doctype html> - -<html lang="en"> - - <head> - - <title>The page you were looking for doesn’t exist (404 Not found)</title> - - <meta charset="utf-8"> - <meta name="viewport" content="initial-scale=1, width=device-width"> - <meta name="robots" content="noindex, nofollow"> - - <style> - - *, *::before, *::after { - box-sizing: border-box; - } - - * { - margin: 0; - } - - html { - font-size: 16px; - } - - body { - background: #FFF; - color: #261B23; - display: grid; - font-family: ui-sans-serif, system-ui, -apple-system, BlinkMacSystemFont, Aptos, Roboto, "Segoe UI", "Helvetica Neue", Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; - font-size: clamp(1rem, 2.5vw, 2rem); - -webkit-font-smoothing: antialiased; - font-style: normal; - font-weight: 400; - letter-spacing: -0.0025em; - line-height: 1.4; - min-height: 100vh; - place-items: center; - text-rendering: optimizeLegibility; - -webkit-text-size-adjust: 100%; - } - - a { - color: inherit; - font-weight: 700; - text-decoration: underline; - text-underline-offset: 0.0925em; - } - - b, strong { - font-weight: 700; - } - - i, em { - font-style: italic; - } - - main { - display: grid; - gap: 1em; - padding: 2em; - place-items: center; - text-align: center; - } - - main header { - width: min(100%, 12em); - } - - main header svg { - height: auto; - max-width: 100%; - width: 100%; - } - - main article { - width: min(100%, 30em); - } - - main article p { - font-size: 75%; - } - - main article br { - - display: none; - - @media(min-width: 48em) { - display: inline; - } - - } - - </style> - - </head> - - <body> - - <!-- This file lives in public/404.html --> - - <main> - <header> - <svg height="172" viewBox="0 0 480 172" width="480" xmlns="http://www.w3.org/2000/svg"><path d="m124.48 3.00509-45.6889 100.02991h26.2239v-28.1168h38.119v28.1168h21.628v35.145h-21.628v30.82h-37.308v-30.82h-72.1833v-31.901l50.2851-103.27391zm115.583 168.69891c-40.822 0-64.884-35.146-64.884-85.7015 0-50.5554 24.062-85.700907 64.884-85.700907 40.823 0 64.884 35.145507 64.884 85.700907 0 50.5555-24.061 85.7015-64.884 85.7015zm0-133.2831c-17.572 0-22.709 21.8984-22.709 47.5816 0 25.6835 5.137 47.5815 22.709 47.5815 17.303 0 22.71-21.898 22.71-47.5815 0-25.6832-5.407-47.5816-22.71-47.5816zm165.328-35.41581-45.689 100.02991h26.224v-28.1168h38.119v28.1168h21.628v35.145h-21.628v30.82h-37.308v-30.82h-72.184v-31.901l50.285-103.27391z" fill="#f0eff0"/><path d="m157.758 68.9967v34.0033h-7.199l-14.233-19.8814v19.8814h-8.584v-34.0033h8.307l13.125 18.7184v-18.7184zm28.454 21.5428c0 7.6978-5.15 13.0145-12.737 13.0145-7.532 0-12.738-5.3167-12.738-13.0145s5.206-13.0143 12.738-13.0143c7.587 0 12.737 5.3165 12.737 13.0143zm-8.528 0c0-3.4336-1.496-5.8703-4.209-5.8703-2.659 0-4.154 2.4367-4.154 5.8703s1.495 5.8149 4.154 5.8149c2.713 0 4.209-2.3813 4.209-5.8149zm13.184 3.8766v-9.5807h-3.655v-6.7564h3.655v-6.8671h8.584v6.8671h5.205v6.7564h-5.205v8.307c0 1.9383.941 2.769 2.658 2.769.941 0 1.994-.2216 2.769-.5538v7.3654c-.997.443-2.88.775-4.818.775-5.87 0-9.193-2.769-9.193-9.0819zm37.027 8.5839h-8.806v-34.0033h23.924v7.6978h-15.118v6.7564h13.9v7.5316h-13.9zm41.876-12.4605c0 7.6978-5.15 13.0145-12.737 13.0145-7.532 0-12.738-5.3167-12.738-13.0145s5.206-13.0143 12.738-13.0143c7.587 0 12.737 5.3165 12.737 13.0143zm-8.529 0c0-3.4336-1.495-5.8703-4.208-5.8703-2.659 0-4.154 2.4367-4.154 5.8703s1.495 5.8149 4.154 5.8149c2.713 0 4.208-2.3813 4.208-5.8149zm35.337-12.4605v24.921h-8.695v-2.16c-1.329 1.551-3.821 2.714-6.646 2.714-5.482 0-8.75-3.5999-8.75-9.1379v-16.3371h8.64v14.288c0 2.1045.997 3.5997 3.212 3.5997 1.606 0 3.101-1.0522 3.544-2.769v-15.1187zm4.076 24.921v-24.921h8.694v2.1598c1.385-1.5506 3.822-2.7136 6.701-2.7136 5.538 0 8.806 3.5997 8.806 9.1377v16.3371h-8.639v-14.2327c0-2.049-1.053-3.5443-3.268-3.5443-1.717 0-3.156.9969-3.6 2.7136v15.0634zm44.113 0v-1.994c-1.163 1.329-3.6 2.548-6.147 2.548-7.2 0-11.132-5.8151-11.132-13.0145s3.932-13.0143 11.132-13.0143c2.547 0 4.984 1.2184 6.147 2.5475v-13.0697h8.695v35.997zm0-9.1931v-6.5902c-.665-1.3291-2.16-2.326-3.821-2.326-2.991 0-4.763 2.4368-4.763 5.6488s1.772 5.5934 4.763 5.5934c1.717 0 3.156-.9415 3.821-2.326z" fill="#d30001"/></svg> - </header> - <article> - <p><strong>The page you were looking for doesn’t exist.</strong> You may have mistyped the address or the page may have moved. If you’re the application owner check the logs for more information.</p> - </article> - </main> - - </body> - -</html> diff --git a/projects/3/example/public/406-unsupported-browser.html b/projects/3/example/public/406-unsupported-browser.html deleted file mode 100644 index 9532a9c..0000000 --- a/projects/3/example/public/406-unsupported-browser.html +++ /dev/null @@ -1,114 +0,0 @@ -<!doctype html> - -<html lang="en"> - - <head> - - <title>Your browser is not supported (406 Not Acceptable)</title> - - <meta charset="utf-8"> - <meta name="viewport" content="initial-scale=1, width=device-width"> - <meta name="robots" content="noindex, nofollow"> - - <style> - - *, *::before, *::after { - box-sizing: border-box; - } - - * { - margin: 0; - } - - html { - font-size: 16px; - } - - body { - background: #FFF; - color: #261B23; - display: grid; - font-family: ui-sans-serif, system-ui, -apple-system, BlinkMacSystemFont, Aptos, Roboto, "Segoe UI", "Helvetica Neue", Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; - font-size: clamp(1rem, 2.5vw, 2rem); - -webkit-font-smoothing: antialiased; - font-style: normal; - font-weight: 400; - letter-spacing: -0.0025em; - line-height: 1.4; - min-height: 100vh; - place-items: center; - text-rendering: optimizeLegibility; - -webkit-text-size-adjust: 100%; - } - - a { - color: inherit; - font-weight: 700; - text-decoration: underline; - text-underline-offset: 0.0925em; - } - - b, strong { - font-weight: 700; - } - - i, em { - font-style: italic; - } - - main { - display: grid; - gap: 1em; - padding: 2em; - place-items: center; - text-align: center; - } - - main header { - width: min(100%, 12em); - } - - main header svg { - height: auto; - max-width: 100%; - width: 100%; - } - - main article { - width: min(100%, 30em); - } - - main article p { - font-size: 75%; - } - - main article br { - - display: none; - - @media(min-width: 48em) { - display: inline; - } - - } - - </style> - - </head> - - <body> - - <!-- This file lives in public/406-unsupported-browser.html --> - - <main> - <header> - <svg height="172" viewBox="0 0 480 172" width="480" xmlns="http://www.w3.org/2000/svg"><path d="m124.48 3.00509-45.6889 100.02991h26.2239v-28.1168h38.119v28.1168h21.628v35.145h-21.628v30.82h-37.308v-30.82h-72.1833v-31.901l50.2851-103.27391zm115.583 168.69891c-40.822 0-64.884-35.146-64.884-85.7015 0-50.5554 24.062-85.700907 64.884-85.700907 40.823 0 64.884 35.145507 64.884 85.700907 0 50.5555-24.061 85.7015-64.884 85.7015zm0-133.2831c-17.572 0-22.709 21.8984-22.709 47.5816 0 25.6835 5.137 47.5815 22.709 47.5815 17.303 0 22.71-21.898 22.71-47.5815 0-25.6832-5.407-47.5816-22.71-47.5816zm202.906 9.7326h-41.093c-2.433-7.2994-7.84-12.4361-17.302-12.4361-16.221 0-25.413 17.5728-25.954 34.8752v1.3517c5.137-7.0291 16.221-12.4361 30.82-12.4361 33.524 0 54.881 24.0612 54.881 53.7998 0 33.253-23.791 58.396-61.64 58.396-21.628 0-39.741-10.003-50.825-27.576-9.733-14.599-13.788-32.442-13.788-54.3406 0-51.9072 24.331-89.485807 66.236-89.485807 32.712 0 53.258 18.654107 58.665 47.851907zm-82.727 66.2355c0 13.247 9.463 22.439 22.71 22.439 12.977 0 22.439-9.192 22.439-22.439 0-13.517-9.462-22.7091-22.439-22.7091-13.247 0-22.71 9.1921-22.71 22.7091z" fill="#f0eff0"/><path d="m100.761 68.9967v34.0033h-7.1991l-14.2326-19.8814v19.8814h-8.5839v-34.0033h8.307l13.125 18.7184v-18.7184zm28.454 21.5428c0 7.6978-5.15 13.0145-12.737 13.0145-7.532 0-12.738-5.3167-12.738-13.0145s5.206-13.0143 12.738-13.0143c7.587 0 12.737 5.3165 12.737 13.0143zm-8.529 0c0-3.4336-1.495-5.8703-4.208-5.8703-2.659 0-4.154 2.4367-4.154 5.8703s1.495 5.8149 4.154 5.8149c2.713 0 4.208-2.3813 4.208-5.8149zm13.185 3.8766v-9.5807h-3.655v-6.7564h3.655v-6.8671h8.584v6.8671h5.205v6.7564h-5.205v8.307c0 1.9383.941 2.769 2.658 2.769.941 0 1.994-.2216 2.769-.5538v7.3654c-.997.443-2.88.775-4.818.775-5.87 0-9.193-2.769-9.193-9.0819zm39.02-25.4194h9.083l12.958 34.0033h-9.027l-2.436-6.5902h-12.35l-2.381 6.5902h-8.806zm4.431 10.5222-3.489 9.5807h6.978zm17.44 11.0206c0-7.6978 5.095-13.0143 12.572-13.0143 6.701 0 10.854 3.9874 11.574 9.8023h-8.418c-.221-1.4953-1.384-2.6029-3.156-2.6029-2.437 0-3.988 2.2706-3.988 5.8149s1.551 5.7595 3.988 5.7595c1.772 0 2.935-1.0522 3.156-2.5475h8.418c-.72 5.7596-4.873 9.8025-11.574 9.8025-7.477 0-12.572-5.3167-12.572-13.0145zm25.676 0c0-7.6978 5.095-13.0143 12.572-13.0143 6.701 0 10.854 3.9874 11.574 9.8023h-8.418c-.221-1.4953-1.384-2.6029-3.156-2.6029-2.437 0-3.988 2.2706-3.988 5.8149s1.551 5.7595 3.988 5.7595c1.772 0 2.935-1.0522 3.156-2.5475h8.418c-.72 5.7596-4.873 9.8025-11.574 9.8025-7.477 0-12.572-5.3167-12.572-13.0145zm42.013 3.7658h8.031c-.887 5.7597-5.206 9.2487-11.686 9.2487-7.642 0-12.682-5.2613-12.682-13.0145 0-7.6978 5.317-13.0143 12.516-13.0143 7.643 0 11.962 5.095 11.962 12.5159v2.1598h-16.115c.277 2.9905 1.827 4.5965 4.319 4.5965 1.773 0 3.157-.7753 3.655-2.4921zm-3.821-10.0237c-2.049 0-3.433 1.2737-3.987 3.5997h7.532c-.111-2.0491-1.385-3.5997-3.545-3.5997zm23.4 16.7244v10.799h-8.694v-33.726h8.694v1.9937c1.163-1.3291 3.6-2.5475 6.148-2.5475 7.199 0 11.131 5.8703 11.131 13.0143 0 7.0886-3.932 13.0145-11.131 13.0145-2.548 0-4.985-1.219-6.148-2.548zm0-13.7893v6.5902c.665 1.3845 2.16 2.326 3.822 2.326 2.99 0 4.762-2.3814 4.762-5.5934s-1.772-5.6488-4.762-5.6488c-1.717 0-3.157.9969-3.822 2.326zm21.892 7.1994v-9.5807h-3.655v-6.7564h3.655v-6.8671h8.584v6.8671h5.206v6.7564h-5.206v8.307c0 1.9383.941 2.769 2.658 2.769.942 0 1.994-.2216 2.769-.5538v7.3654c-.997.443-2.88.775-4.818.775-5.87 0-9.193-2.769-9.193-9.0819zm39.458 8.5839h-8.363v-1.274c-.83.831-3.322 1.717-5.981 1.717-4.928 0-9.082-2.769-9.082-8.0301 0-4.818 4.154-7.9193 9.581-7.9193 2.049 0 4.486.6646 5.482 1.3845v-1.606c0-1.606-.941-2.9905-3.045-2.9905-1.606 0-2.548.7199-2.936 1.8275h-8.196c.72-4.8181 4.984-8.6393 11.408-8.6393 7.089 0 11.132 3.7659 11.132 10.2453zm-8.363-6.9779v-1.4399c-.553-1.0522-2.049-1.7167-3.655-1.7167-1.716 0-3.433.7199-3.433 2.3813 0 1.7168 1.717 2.4367 3.433 2.4367 1.606 0 3.102-.6645 3.655-1.6614zm20.742 4.9839v1.994h-8.694v-35.997h8.694v13.0697c1.163-1.3291 3.6-2.5475 6.148-2.5475 7.199 0 11.131 5.8149 11.131 13.0143s-3.932 13.0145-11.131 13.0145c-2.548 0-4.985-1.219-6.148-2.548zm0-13.7893v6.5902c.665 1.3845 2.105 2.326 3.822 2.326 2.99 0 4.762-2.3814 4.762-5.5934s-1.772-5.6488-4.762-5.6488c-1.662 0-3.157.9969-3.822 2.326zm28.759-20.2137v35.997h-8.695v-35.997zm19.172 27.3023h8.03c-.886 5.7597-5.206 9.2487-11.685 9.2487-7.643 0-12.682-5.2613-12.682-13.0145 0-7.6978 5.316-13.0143 12.516-13.0143 7.642 0 11.962 5.095 11.962 12.5159v2.1598h-16.116c.277 2.9905 1.828 4.5965 4.32 4.5965 1.772 0 3.157-.7753 3.655-2.4921zm-3.821-10.0237c-2.049 0-3.434 1.2737-3.988 3.5997h7.532c-.111-2.0491-1.384-3.5997-3.544-3.5997z" fill="#d30001"/></svg> - </header> - <article> - <p><strong>Your browser is not supported.</strong><br> Please upgrade your browser to continue.</p> - </article> - </main> - - </body> - -</html> diff --git a/projects/3/example/public/422.html b/projects/3/example/public/422.html deleted file mode 100644 index 8bcf060..0000000 --- a/projects/3/example/public/422.html +++ /dev/null @@ -1,114 +0,0 @@ -<!doctype html> - -<html lang="en"> - - <head> - - <title>The change you wanted was rejected (422 Unprocessable Entity)</title> - - <meta charset="utf-8"> - <meta name="viewport" content="initial-scale=1, width=device-width"> - <meta name="robots" content="noindex, nofollow"> - - <style> - - *, *::before, *::after { - box-sizing: border-box; - } - - * { - margin: 0; - } - - html { - font-size: 16px; - } - - body { - background: #FFF; - color: #261B23; - display: grid; - font-family: ui-sans-serif, system-ui, -apple-system, BlinkMacSystemFont, Aptos, Roboto, "Segoe UI", "Helvetica Neue", Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; - font-size: clamp(1rem, 2.5vw, 2rem); - -webkit-font-smoothing: antialiased; - font-style: normal; - font-weight: 400; - letter-spacing: -0.0025em; - line-height: 1.4; - min-height: 100vh; - place-items: center; - text-rendering: optimizeLegibility; - -webkit-text-size-adjust: 100%; - } - - a { - color: inherit; - font-weight: 700; - text-decoration: underline; - text-underline-offset: 0.0925em; - } - - b, strong { - font-weight: 700; - } - - i, em { - font-style: italic; - } - - main { - display: grid; - gap: 1em; - padding: 2em; - place-items: center; - text-align: center; - } - - main header { - width: min(100%, 12em); - } - - main header svg { - height: auto; - max-width: 100%; - width: 100%; - } - - main article { - width: min(100%, 30em); - } - - main article p { - font-size: 75%; - } - - main article br { - - display: none; - - @media(min-width: 48em) { - display: inline; - } - - } - - </style> - - </head> - - <body> - - <!-- This file lives in public/422.html --> - - <main> - <header> - <svg height="172" viewBox="0 0 480 172" width="480" xmlns="http://www.w3.org/2000/svg"><path d="m124.48 3.00509-45.6889 100.02991h26.2239v-28.1168h38.119v28.1168h21.628v35.145h-21.628v30.82h-37.308v-30.82h-72.1833v-31.901l50.2851-103.27391zm130.453 51.63681c0-8.9215-6.218-15.4099-15.681-15.4099-10.273 0-15.95 7.5698-16.491 16.4913h-44.608c3.244-30.8199 25.683-55.421707 61.099-55.421707 36.498 0 59.477 20.816907 59.477 51.636807 0 21.3577-14.869 36.7676-31.901 52.7186l-27.305 27.035h59.747v37.308h-120.306v-27.846l57.044-56.7736c11.084-11.8954 18.925-20.0059 18.925-29.7385zm140.455 0c0-8.9215-6.218-15.4099-15.68-15.4099-10.274 0-15.951 7.5698-16.492 16.4913h-44.608c3.245-30.8199 25.684-55.421707 61.1-55.421707 36.497 0 59.477 20.816907 59.477 51.636807 0 21.3577-14.87 36.7676-31.902 52.7186l-27.305 27.035h59.747v37.308h-120.305v-27.846l57.043-56.7736c11.085-11.8954 18.925-20.0059 18.925-29.7385z" fill="#f0eff0"/><path d="m19.3936 103.554c-8.9715 0-14.84183-5.0952-14.84183-14.4544v-20.1029h8.86083v19.3276c0 4.8181 2.2706 7.3102 5.981 7.3102 3.6551 0 5.9257-2.4921 5.9257-7.3102v-19.3276h8.8608v20.1583c0 9.3038-5.8149 14.399-14.7865 14.399zm18.734-.554v-24.921h8.6947v2.1598c1.3845-1.5506 3.8212-2.7136 6.701-2.7136 5.538 0 8.8054 3.5997 8.8054 9.1377v16.3371h-8.6393v-14.2327c0-2.049-1.0522-3.5443-3.2674-3.5443-1.7168 0-3.1567.9969-3.5997 2.7136v15.0634zm36.8584-1.994v10.799h-8.6946v-33.726h8.6946v1.9937c1.163-1.3291 3.5997-2.5475 6.1472-2.5475 7.1994 0 11.1314 5.8703 11.1314 13.0143 0 7.0886-3.932 13.0145-11.1314 13.0145-2.5475 0-4.9842-1.219-6.1472-2.548zm0-13.7893v6.5902c.6646 1.3845 2.1599 2.326 3.8213 2.326 2.9905 0 4.7626-2.3814 4.7626-5.5934s-1.7721-5.6488-4.7626-5.6488c-1.7168 0-3.1567.9969-3.8213 2.326zm36.789-9.2485v8.3624c-1.052-.5538-2.215-.7753-3.6-.7753-2.381 0-3.987 1.0522-4.43 2.8244v14.6203h-8.6949v-24.921h8.6949v2.2152c1.218-1.6614 3.156-2.769 5.648-2.769 1.108 0 1.994.2215 2.382.443zm26.769 12.5713c0 7.6978-5.15 13.0145-12.737 13.0145-7.532 0-12.738-5.3167-12.738-13.0145s5.206-13.0143 12.738-13.0143c7.587 0 12.737 5.3165 12.737 13.0143zm-8.528 0c0-3.4336-1.496-5.8703-4.209-5.8703-2.659 0-4.154 2.4367-4.154 5.8703s1.495 5.8149 4.154 5.8149c2.713 0 4.209-2.3813 4.209-5.8149zm10.352 0c0-7.6978 5.095-13.0143 12.571-13.0143 6.701 0 10.855 3.9874 11.574 9.8023h-8.417c-.222-1.4953-1.385-2.6029-3.157-2.6029-2.437 0-3.987 2.2706-3.987 5.8149s1.55 5.7595 3.987 5.7595c1.772 0 2.935-1.0522 3.157-2.5475h8.417c-.719 5.7596-4.873 9.8025-11.574 9.8025-7.476 0-12.571-5.3167-12.571-13.0145zm42.013 3.7658h8.03c-.886 5.7597-5.206 9.2487-11.685 9.2487-7.643 0-12.682-5.2613-12.682-13.0145 0-7.6978 5.316-13.0143 12.516-13.0143 7.642 0 11.962 5.095 11.962 12.5159v2.1598h-16.116c.277 2.9905 1.828 4.5965 4.32 4.5965 1.772 0 3.156-.7753 3.655-2.4921zm-3.821-10.0237c-2.049 0-3.434 1.2737-3.988 3.5997h7.532c-.111-2.0491-1.385-3.5997-3.544-3.5997zm13.428 11.0206h8.473c.387 1.3845 1.606 2.1598 3.156 2.1598 1.44 0 2.548-.5538 2.548-1.7168 0-.9414-.72-1.2737-1.938-1.5506l-4.874-.9969c-4.153-.886-6.867-2.8797-6.867-7.2547 0-5.3165 4.763-8.4178 10.633-8.4178 6.812 0 10.522 3.1567 11.297 8.0855h-8.03c-.277-1.0522-1.052-1.9937-3.046-1.9937-1.273 0-2.326.5538-2.326 1.6614 0 .7753.554 1.163 1.717 1.3845l4.929 1.163c4.541 1.0522 6.978 3.4335 6.978 7.4763 0 5.3168-4.818 8.2518-10.91 8.2518-6.369 0-10.965-2.88-11.74-8.2518zm24.269 0h8.474c.387 1.3845 1.606 2.1598 3.156 2.1598 1.44 0 2.548-.5538 2.548-1.7168 0-.9414-.72-1.2737-1.939-1.5506l-4.873-.9969c-4.154-.886-6.867-2.8797-6.867-7.2547 0-5.3165 4.763-8.4178 10.633-8.4178 6.812 0 10.522 3.1567 11.297 8.0855h-8.03c-.277-1.0522-1.052-1.9937-3.046-1.9937-1.273 0-2.326.5538-2.326 1.6614 0 .7753.554 1.163 1.717 1.3845l4.929 1.163c4.541 1.0522 6.978 3.4335 6.978 7.4763 0 5.3168-4.818 8.2518-10.91 8.2518-6.369 0-10.965-2.88-11.741-8.2518zm47.918 7.6978h-8.363v-1.274c-.831.831-3.323 1.717-5.981 1.717-4.929 0-9.082-2.769-9.082-8.0301 0-4.818 4.153-7.9193 9.581-7.9193 2.049 0 4.485.6646 5.482 1.3845v-1.606c0-1.606-.941-2.9905-3.046-2.9905-1.606 0-2.547.7199-2.935 1.8275h-8.196c.72-4.8181 4.984-8.6393 11.408-8.6393 7.089 0 11.132 3.7659 11.132 10.2453zm-8.363-6.9779v-1.4399c-.554-1.0522-2.049-1.7167-3.655-1.7167-1.717 0-3.434.7199-3.434 2.3813 0 1.7168 1.717 2.4367 3.434 2.4367 1.606 0 3.101-.6645 3.655-1.6614zm20.742 4.9839v1.994h-8.695v-35.997h8.695v13.0697c1.163-1.3291 3.6-2.5475 6.147-2.5475 7.2 0 11.132 5.8149 11.132 13.0143s-3.932 13.0145-11.132 13.0145c-2.547 0-4.984-1.219-6.147-2.548zm0-13.7893v6.5902c.665 1.3845 2.105 2.326 3.821 2.326 2.991 0 4.763-2.3814 4.763-5.5934s-1.772-5.6488-4.763-5.6488c-1.661 0-3.156.9969-3.821 2.326zm28.759-20.2137v35.997h-8.695v-35.997zm19.172 27.3023h8.03c-.886 5.7597-5.206 9.2487-11.685 9.2487-7.643 0-12.682-5.2613-12.682-13.0145 0-7.6978 5.316-13.0143 12.515-13.0143 7.643 0 11.962 5.095 11.962 12.5159v2.1598h-16.115c.277 2.9905 1.827 4.5965 4.32 4.5965 1.772 0 3.156-.7753 3.655-2.4921zm-3.822-10.0237c-2.049 0-3.433 1.2737-3.987 3.5997h7.532c-.111-2.0491-1.385-3.5997-3.545-3.5997zm25.461-15.2849h24.311v7.6424h-15.561v5.3165h14.232v7.4763h-14.232v5.8703h15.561v7.6978h-24.311zm27.942 34.0033v-24.921h8.694v2.1598c1.385-1.5506 3.822-2.7136 6.701-2.7136 5.538 0 8.806 3.5997 8.806 9.1377v16.3371h-8.639v-14.2327c0-2.049-1.053-3.5443-3.268-3.5443-1.717 0-3.157.9969-3.6 2.7136v15.0634zm29.991-8.5839v-9.5807h-3.655v-6.7564h3.655v-6.8671h8.584v6.8671h5.206v6.7564h-5.206v8.307c0 1.9383.941 2.769 2.658 2.769.942 0 1.994-.2216 2.769-.5538v7.3654c-.997.443-2.88.775-4.818.775-5.87 0-9.193-2.769-9.193-9.0819zm26.161-16.3371v24.921h-8.694v-24.921zm.61-6.7564c0 2.8244-2.271 4.652-4.929 4.652s-4.929-1.8276-4.929-4.652c0-2.8797 2.271-4.7073 4.929-4.7073s4.929 1.8276 4.929 4.7073zm5.382 23.0935v-9.5807h-3.655v-6.7564h3.655v-6.8671h8.584v6.8671h5.206v6.7564h-5.206v8.307c0 1.9383.941 2.769 2.658 2.769.941 0 1.994-.2216 2.769-.5538v7.3654c-.997.443-2.88.775-4.818.775-5.87 0-9.193-2.769-9.193-9.0819zm29.22 17.3889h-8.584l3.655-9.414-9.303-24.312h9.026l4.763 14.1773 4.652-14.1773h8.639z" fill="#d30001"/></svg> - </header> - <article> - <p><strong>The change you wanted was rejected.</strong> Maybe you tried to change something you didn’t have access to. If you’re the application owner check the logs for more information.</p> - </article> - </main> - - </body> - -</html> diff --git a/projects/3/example/public/500.html b/projects/3/example/public/500.html deleted file mode 100644 index d77718c..0000000 --- a/projects/3/example/public/500.html +++ /dev/null @@ -1,114 +0,0 @@ -<!doctype html> - -<html lang="en"> - - <head> - - <title>We’re sorry, but something went wrong (500 Internal Server Error)</title> - - <meta charset="utf-8"> - <meta name="viewport" content="initial-scale=1, width=device-width"> - <meta name="robots" content="noindex, nofollow"> - - <style> - - *, *::before, *::after { - box-sizing: border-box; - } - - * { - margin: 0; - } - - html { - font-size: 16px; - } - - body { - background: #FFF; - color: #261B23; - display: grid; - font-family: ui-sans-serif, system-ui, -apple-system, BlinkMacSystemFont, Aptos, Roboto, "Segoe UI", "Helvetica Neue", Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; - font-size: clamp(1rem, 2.5vw, 2rem); - -webkit-font-smoothing: antialiased; - font-style: normal; - font-weight: 400; - letter-spacing: -0.0025em; - line-height: 1.4; - min-height: 100vh; - place-items: center; - text-rendering: optimizeLegibility; - -webkit-text-size-adjust: 100%; - } - - a { - color: inherit; - font-weight: 700; - text-decoration: underline; - text-underline-offset: 0.0925em; - } - - b, strong { - font-weight: 700; - } - - i, em { - font-style: italic; - } - - main { - display: grid; - gap: 1em; - padding: 2em; - place-items: center; - text-align: center; - } - - main header { - width: min(100%, 12em); - } - - main header svg { - height: auto; - max-width: 100%; - width: 100%; - } - - main article { - width: min(100%, 30em); - } - - main article p { - font-size: 75%; - } - - main article br { - - display: none; - - @media(min-width: 48em) { - display: inline; - } - - } - - </style> - - </head> - - <body> - - <!-- This file lives in public/500.html --> - - <main> - <header> - <svg height="172" viewBox="0 0 480 172" width="480" xmlns="http://www.w3.org/2000/svg"><path d="m101.23 93.8427c-8.1103 0-15.4098 3.7849-19.7354 8.3813h-36.2269v-99.21891h103.8143v37.03791h-68.3984v24.8722c5.1366-2.7035 15.1396-5.9477 24.6014-5.9477 35.146 0 56.233 22.7094 56.233 55.4215 0 34.605-23.791 57.315-60.558 57.315-37.8492 0-61.64-22.169-63.8028-55.963h42.9857c1.0814 10.814 9.1919 19.195 21.6281 19.195 11.355 0 19.465-8.381 19.465-20.547 0-11.625-7.299-20.5463-20.006-20.5463zm138.833 77.8613c-40.822 0-64.884-35.146-64.884-85.7015 0-50.5554 24.062-85.700907 64.884-85.700907 40.823 0 64.884 35.145507 64.884 85.700907 0 50.5555-24.061 85.7015-64.884 85.7015zm0-133.2831c-17.572 0-22.709 21.8984-22.709 47.5816 0 25.6835 5.137 47.5815 22.709 47.5815 17.303 0 22.71-21.898 22.71-47.5815 0-25.6832-5.407-47.5816-22.71-47.5816zm140.456 133.2831c-40.823 0-64.884-35.146-64.884-85.7015 0-50.5554 24.061-85.700907 64.884-85.700907 40.822 0 64.884 35.145507 64.884 85.700907 0 50.5555-24.062 85.7015-64.884 85.7015zm0-133.2831c-17.573 0-22.71 21.8984-22.71 47.5816 0 25.6835 5.137 47.5815 22.71 47.5815 17.302 0 22.709-21.898 22.709-47.5815 0-25.6832-5.407-47.5816-22.709-47.5816z" fill="#f0eff0"/><path d="m23.1377 68.9967v34.0033h-8.9162v-34.0033zm4.3157 34.0033v-24.921h8.6947v2.1598c1.3845-1.5506 3.8212-2.7136 6.701-2.7136 5.538 0 8.8054 3.5997 8.8054 9.1377v16.3371h-8.6393v-14.2327c0-2.049-1.0522-3.5443-3.2674-3.5443-1.7168 0-3.1567.9969-3.5997 2.7136v15.0634zm29.9913-8.5839v-9.5807h-3.655v-6.7564h3.655v-6.8671h8.5839v6.8671h5.2058v6.7564h-5.2058v8.307c0 1.9383.9415 2.769 2.6583 2.769.9414 0 1.9937-.2216 2.769-.5538v7.3654c-.9969.443-2.8798.775-4.8181.775-5.8703 0-9.1931-2.769-9.1931-9.0819zm32.3666-.1108h8.0301c-.8861 5.7597-5.2057 9.2487-11.6852 9.2487-7.6424 0-12.682-5.2613-12.682-13.0145 0-7.6978 5.3165-13.0143 12.5159-13.0143 7.6424 0 11.9621 5.095 11.9621 12.5159v2.1598h-16.1156c.2769 2.9905 1.8275 4.5965 4.3196 4.5965 1.7722 0 3.1567-.7753 3.6551-2.4921zm-3.8212-10.0237c-2.0491 0-3.4336 1.2737-3.9874 3.5997h7.5317c-.1107-2.0491-1.3845-3.5997-3.5443-3.5997zm31.4299-6.3134v8.3624c-1.052-.5538-2.215-.7753-3.599-.7753-2.382 0-3.988 1.0522-4.431 2.8244v14.6203h-8.694v-24.921h8.694v2.2152c1.219-1.6614 3.157-2.769 5.649-2.769 1.108 0 1.994.2215 2.381.443zm2.949 25.0318v-24.921h8.694v2.1598c1.385-1.5506 3.821-2.7136 6.701-2.7136 5.538 0 8.806 3.5997 8.806 9.1377v16.3371h-8.64v-14.2327c0-2.049-1.052-3.5443-3.267-3.5443-1.717 0-3.157.9969-3.6 2.7136v15.0634zm50.371 0h-8.363v-1.274c-.83.831-3.323 1.717-5.981 1.717-4.929 0-9.082-2.769-9.082-8.0301 0-4.818 4.153-7.9193 9.581-7.9193 2.049 0 4.485.6646 5.482 1.3845v-1.606c0-1.606-.941-2.9905-3.046-2.9905-1.606 0-2.547.7199-2.935 1.8275h-8.196c.72-4.8181 4.984-8.6393 11.408-8.6393 7.089 0 11.132 3.7659 11.132 10.2453zm-8.363-6.9779v-1.4399c-.554-1.0522-2.049-1.7167-3.655-1.7167-1.717 0-3.433.7199-3.433 2.3813 0 1.7168 1.716 2.4367 3.433 2.4367 1.606 0 3.101-.6645 3.655-1.6614zm20.742-29.0191v35.997h-8.694v-35.997zm13.036 25.9178h9.248c.72 2.326 2.714 3.489 5.483 3.489 2.713 0 4.596-1.163 4.596-3.2674 0-1.6061-1.052-2.326-3.212-2.8244l-6.534-1.3845c-4.985-1.1076-8.751-3.7105-8.751-9.47 0-6.6456 5.538-11.0206 13.07-11.0206 8.307 0 13.014 4.5411 13.956 10.4114h-8.695c-.72-1.8829-2.27-3.3228-5.205-3.3228-2.548 0-4.265 1.1076-4.265 2.9905 0 1.4953 1.052 2.326 2.825 2.7137l6.645 1.5506c5.815 1.3845 9.027 4.5412 9.027 9.8023 0 6.9778-5.87 10.9654-13.291 10.9654-8.141 0-13.679-3.9322-14.897-10.6332zm46.509 1.3845h8.031c-.887 5.7597-5.206 9.2487-11.686 9.2487-7.642 0-12.682-5.2613-12.682-13.0145 0-7.6978 5.317-13.0143 12.516-13.0143 7.643 0 11.962 5.095 11.962 12.5159v2.1598h-16.115c.277 2.9905 1.827 4.5965 4.319 4.5965 1.773 0 3.157-.7753 3.655-2.4921zm-3.821-10.0237c-2.049 0-3.433 1.2737-3.987 3.5997h7.532c-.111-2.0491-1.385-3.5997-3.545-3.5997zm31.431-6.3134v8.3624c-1.053-.5538-2.216-.7753-3.6-.7753-2.381 0-3.988 1.0522-4.431 2.8244v14.6203h-8.694v-24.921h8.694v2.2152c1.219-1.6614 3.157-2.769 5.649-2.769 1.108 0 1.994.2215 2.382.443zm18.288 25.0318h-7.809l-9.47-24.921h8.861l4.763 14.288 4.652-14.288h8.528zm25.614-8.6947h8.03c-.886 5.7597-5.206 9.2487-11.685 9.2487-7.642 0-12.682-5.2613-12.682-13.0145 0-7.6978 5.316-13.0143 12.516-13.0143 7.642 0 11.962 5.095 11.962 12.5159v2.1598h-16.116c.277 2.9905 1.828 4.5965 4.32 4.5965 1.772 0 3.157-.7753 3.655-2.4921zm-3.821-10.0237c-2.049 0-3.434 1.2737-3.988 3.5997h7.532c-.111-2.0491-1.384-3.5997-3.544-3.5997zm31.43-6.3134v8.3624c-1.052-.5538-2.215-.7753-3.6-.7753-2.381 0-3.987 1.0522-4.43 2.8244v14.6203h-8.695v-24.921h8.695v2.2152c1.218-1.6614 3.157-2.769 5.649-2.769 1.107 0 1.993.2215 2.381.443zm13.703-8.9715h24.312v7.6424h-15.562v5.3165h14.232v7.4763h-14.232v5.8703h15.562v7.6978h-24.312zm44.667 8.9715v8.3624c-1.052-.5538-2.215-.7753-3.6-.7753-2.381 0-3.987 1.0522-4.43 2.8244v14.6203h-8.695v-24.921h8.695v2.2152c1.218-1.6614 3.156-2.769 5.648-2.769 1.108 0 1.994.2215 2.382.443zm19.673 0v8.3624c-1.053-.5538-2.216-.7753-3.6-.7753-2.381 0-3.987 1.0522-4.43 2.8244v14.6203h-8.695v-24.921h8.695v2.2152c1.218-1.6614 3.156-2.769 5.648-2.769 1.108 0 1.994.2215 2.382.443zm26.769 12.5713c0 7.6978-5.15 13.0145-12.737 13.0145-7.532 0-12.738-5.3167-12.738-13.0145s5.206-13.0143 12.738-13.0143c7.587 0 12.737 5.3165 12.737 13.0143zm-8.529 0c0-3.4336-1.495-5.8703-4.208-5.8703-2.659 0-4.154 2.4367-4.154 5.8703s1.495 5.8149 4.154 5.8149c2.713 0 4.208-2.3813 4.208-5.8149zm28.082-12.5713v8.3624c-1.052-.5538-2.215-.7753-3.6-.7753-2.381 0-3.987 1.0522-4.43 2.8244v14.6203h-8.695v-24.921h8.695v2.2152c1.218-1.6614 3.157-2.769 5.649-2.769 1.107 0 1.993.2215 2.381.443z" fill="#d30001"/></svg> - </header> - <article> - <p><strong>We’re sorry, but something went wrong.</strong><br> If you’re the application owner check the logs for more information.</p> - </article> - </main> - - </body> - -</html> diff --git a/projects/3/example/public/icon.png b/projects/3/example/public/icon.png Binary files differdeleted file mode 100644 index c4c9dbf..0000000 --- a/projects/3/example/public/icon.png +++ /dev/null diff --git a/projects/3/example/public/icon.svg b/projects/3/example/public/icon.svg deleted file mode 100644 index 04b34bf..0000000 --- a/projects/3/example/public/icon.svg +++ /dev/null @@ -1,3 +0,0 @@ -<svg width="512" height="512" xmlns="http://www.w3.org/2000/svg"> - <circle cx="256" cy="256" r="256" fill="red"/> -</svg> diff --git a/projects/3/example/public/robots.txt b/projects/3/example/public/robots.txt deleted file mode 100644 index c19f78a..0000000 --- a/projects/3/example/public/robots.txt +++ /dev/null @@ -1 +0,0 @@ -# See https://www.robotstxt.org/robotstxt.html for documentation on how to use the robots.txt file diff --git a/projects/3/example/script/.keep b/projects/3/example/script/.keep deleted file mode 100644 index e69de29..0000000 --- a/projects/3/example/script/.keep +++ /dev/null diff --git a/projects/3/example/storage/.keep b/projects/3/example/storage/.keep deleted file mode 100644 index e69de29..0000000 --- a/projects/3/example/storage/.keep +++ /dev/null diff --git a/projects/3/example/test/application_system_test_case.rb b/projects/3/example/test/application_system_test_case.rb deleted file mode 100644 index cee29fd..0000000 --- a/projects/3/example/test/application_system_test_case.rb +++ /dev/null @@ -1,5 +0,0 @@ -require "test_helper" - -class ApplicationSystemTestCase < ActionDispatch::SystemTestCase - driven_by :selenium, using: :headless_chrome, screen_size: [ 1400, 1400 ] -end diff --git a/projects/3/example/test/controllers/.keep b/projects/3/example/test/controllers/.keep deleted file mode 100644 index e69de29..0000000 --- a/projects/3/example/test/controllers/.keep +++ /dev/null diff --git a/projects/3/example/test/fixtures/files/.keep b/projects/3/example/test/fixtures/files/.keep deleted file mode 100644 index e69de29..0000000 --- a/projects/3/example/test/fixtures/files/.keep +++ /dev/null diff --git a/projects/3/example/test/helpers/.keep b/projects/3/example/test/helpers/.keep deleted file mode 100644 index e69de29..0000000 --- a/projects/3/example/test/helpers/.keep +++ /dev/null diff --git a/projects/3/example/test/integration/.keep b/projects/3/example/test/integration/.keep deleted file mode 100644 index e69de29..0000000 --- a/projects/3/example/test/integration/.keep +++ /dev/null diff --git a/projects/3/example/test/mailers/.keep b/projects/3/example/test/mailers/.keep deleted file mode 100644 index e69de29..0000000 --- a/projects/3/example/test/mailers/.keep +++ /dev/null diff --git a/projects/3/example/test/models/.keep b/projects/3/example/test/models/.keep deleted file mode 100644 index e69de29..0000000 --- a/projects/3/example/test/models/.keep +++ /dev/null diff --git a/projects/3/example/test/system/.keep b/projects/3/example/test/system/.keep deleted file mode 100644 index e69de29..0000000 --- a/projects/3/example/test/system/.keep +++ /dev/null diff --git a/projects/3/example/test/test_helper.rb b/projects/3/example/test/test_helper.rb deleted file mode 100644 index 0c22470..0000000 --- a/projects/3/example/test/test_helper.rb +++ /dev/null @@ -1,15 +0,0 @@ -ENV["RAILS_ENV"] ||= "test" -require_relative "../config/environment" -require "rails/test_help" - -module ActiveSupport - class TestCase - # Run tests in parallel with specified workers - parallelize(workers: :number_of_processors) - - # Setup all fixtures in test/fixtures/*.yml for all tests in alphabetical order. - fixtures :all - - # Add more helper methods to be used by all tests here... - end -end diff --git a/projects/3/example/tmp/.keep b/projects/3/example/tmp/.keep deleted file mode 100644 index e69de29..0000000 --- a/projects/3/example/tmp/.keep +++ /dev/null diff --git a/projects/3/example/tmp/pids/.keep b/projects/3/example/tmp/pids/.keep deleted file mode 100644 index e69de29..0000000 --- a/projects/3/example/tmp/pids/.keep +++ /dev/null diff --git a/projects/3/example/tmp/storage/.keep b/projects/3/example/tmp/storage/.keep deleted file mode 100644 index e69de29..0000000 --- a/projects/3/example/tmp/storage/.keep +++ /dev/null diff --git a/projects/3/example/vendor/.keep b/projects/3/example/vendor/.keep deleted file mode 100644 index e69de29..0000000 --- a/projects/3/example/vendor/.keep +++ /dev/null diff --git a/projects/3/queries.sql b/projects/3/queries.sql new file mode 100644 index 0000000..eed58d0 --- /dev/null +++ b/projects/3/queries.sql @@ -0,0 +1,22 @@ +-- Find all rentals in January 2024 +select media.title, rentals.due_at, customers.first_name, customers.last_name +from rentals +inner join media on media.id = rentals.media_id +inner join customers on customers.id = rentals.customer_id +inner join categories on categories.id = media.category_id +where rentals.rented_at > '2024-01-01 00:00:00' +and rentals.due_at < '2024-02-01 00:00:00'; + +-- Find all rentals for Documentaries +select media.title, rentals.due_at, customers.first_name, customers.last_name +from rentals +inner join media on media.id = rentals.media_id +inner join customers on customers.id = rentals.customer_id +inner join categories on categories.id = media.category_id +and categories.title = 'Documentary'; + +-- Find all media in the Action category +select media.* +from media +inner join categories on categories.id = media.category_id +and categories.title = 'Action'; diff --git a/projects/3/structure.sql b/projects/3/seed.sql index b029517..a3a194c 100644 --- a/projects/3/structure.sql +++ b/projects/3/seed.sql @@ -1,38 +1,9 @@ -create table customers( - id integer primary key asc, - first_name varchar(255) not null, - last_name varchar(255) not null, - address text, - created_at datetime default current_timestamp, - updated_at datetime default current_timestamp -); - -create table categories( - id integer primary key asc, - title varchar(16) unique not null, - description varchar(255) not null, - created_at datetime default current_timestamp, - updated_at datetime default current_timestamp -); - -create table media( - id integer primary key asc, - title varchar(255) unique not null, - category_id integer not null, - created_at datetime default current_timestamp, - updated_at datetime default current_timestamp, - foreign key(category_id) references categories(id) -); - -create table rentals( - id integer primary key asc, - rented_at datetime not null, - due_at datetime not null, - media_id integer not null, - created_at datetime default current_timestamp, - updated_at datetime default current_timestamp, - foreign key(media_id) references media(id) -); +begin transaction; + insert into categories(id, title, description) values(1, 'Action', 'A film genre that predominantly features chase sequences, fights, shootouts, explosions, and stunt work'); + insert into categories(id, title, description) values(2, 'Comedy', 'A film genre that emphasizes humor'); + insert into categories(id, title, description) values(3, 'Documentary', 'A film genre that is a non-fictional motion picture intended to document reality, primarily for instruction, education or maintaining a historical record'); + insert into categories(id, title, description) values(4, 'Horror', 'A film genre that seeks to elicit fear or disgust in its audience for entertainment purposes'); +commit; begin transaction; insert into customers(first_name, last_name) values('Achilleas', 'Pipinellis'); @@ -47,12 +18,6 @@ begin transaction; insert into customers(first_name, last_name) values('Vijay', 'Hawoldar'); commit; -begin transaction; - insert into categories(id, title, description) values(1, 'Action', 'A film genre that predominantly features chase sequences, fights, shootouts, explosions, and stunt work'); - insert into categories(id, title, description) values(2, 'Comedy', 'A film genre that emphasizes humor'); - insert into categories(id, title, description) values(3, 'Documentary', 'A film genre that is a non-fictional motion picture intended to document reality, primarily for instruction, education or maintaining a historical record'); - insert into categories(id, title, description) values(4, 'Horror', 'A film genre that seeks to elicit fear or disgust in its audience for entertainment purposes'); -commit; begin transaction; insert into media(title, category_id) values('10 000 BC', (select id from categories order by random() limit 1)); @@ -8663,29 +8628,27 @@ begin transaction; insert into media(title, category_id) values('Zulu', (select id from categories order by random() limit 1)); commit; --- insert 20 rentals - begin transaction; - insert into rentals(rented_at, due_at, media_id) values('2024-01-01 09:00:00', '2024-02-01 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-02-01 09:00:00', '2024-03-01 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-03-01 09:00:00', '2024-04-01 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-04-01 09:00:00', '2024-05-01 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-05-01 09:00:00', '2024-06-01 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-06-01 09:00:00', '2024-07-01 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-07-01 09:00:00', '2024-08-01 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-08-01 09:00:00', '2024-09-01 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-09-01 09:00:00', '2024-10-01 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-01-02 09:00:00', '2024-02-01 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-02-03 09:00:00', '2024-03-01 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-03-04 09:00:00', '2024-04-01 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-04-05 09:00:00', '2024-05-01 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-05-06 09:00:00', '2024-06-01 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-06-07 09:00:00', '2024-07-01 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-07-08 09:00:00', '2024-08-01 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-08-09 09:00:00', '2024-09-01 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-09-10 09:00:00', '2024-10-01 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-01-15 09:00:00', '2024-01-30 09:00:00', (select id from media order by random() limit 1)); - insert into rentals(rented_at, due_at, media_id) values('2024-02-17 09:00:00', '2024-02-28 09:00:00', (select id from media order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-01-01 09:00:00', '2024-02-01 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-02-01 09:00:00', '2024-03-01 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-03-01 09:00:00', '2024-04-01 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-04-01 09:00:00', '2024-05-01 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-05-01 09:00:00', '2024-06-01 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-06-01 09:00:00', '2024-07-01 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-07-01 09:00:00', '2024-08-01 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-08-01 09:00:00', '2024-09-01 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-09-01 09:00:00', '2024-10-01 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-01-02 09:00:00', '2024-02-01 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-02-03 09:00:00', '2024-03-01 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-03-04 09:00:00', '2024-04-01 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-04-05 09:00:00', '2024-05-01 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-05-06 09:00:00', '2024-06-01 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-06-07 09:00:00', '2024-07-01 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-07-08 09:00:00', '2024-08-01 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-08-09 09:00:00', '2024-09-01 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-09-10 09:00:00', '2024-10-01 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-01-15 09:00:00', '2024-01-30 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); + insert into rentals(rented_at, due_at, media_id, customer_id) values('2024-02-17 09:00:00', '2024-02-28 09:00:00', (select id from media order by random() limit 1), (select id from customers order by random() limit 1)); commit; select * from categories; |
