iiwo

# frozen_string_literal: true

# Tag ownership example using easy_tags

require "bundler/inline"

gemfile(true) do
  source "https://rubygems.org"
  gem "activerecord", "~> 7.0"
  gem "sqlite3"

iiwo

db/model	string/no enum	integer/array enum	integer/hash enum	string/hash enum	pg enum/hash enum
migration(pg)	`add_column(:scraper_re

iiwo

belongs_to:

1. Assigning an object to a belongs_to association does not automatically save the object. It does not save the associated object either.

has_one:

1. When you assign an object to a has_one association, that object is automatically saved (in order to update its foreign key).
2. In addition, any object being replaced is also automatically saved, because its foreign key will change too
3. If either of these saves fails due to validation errors, then the assignment statement returns false and the assignment itself is cancelled.
4. If the parent object (the one declaring the has_one association) is unsaved (that is, new_record? returns true) then the child objects are not saved. They will automatically when the parent object is saved.

iiwo

# frozen_string_literal: true

# This script illustrates caveats of ActiveRecord association autosave
# when using a combination of database constrains with a through association (join model)
#
#  ## USAGE
#
#   ruby through_association_autosave.rb
#
#  ## EDGE CASE

iiwo

# frozen_string_literal: true

require "bundler/inline"

gemfile(true) do
  source "https://rubygems.org"
  gem "activerecord", "6.1"
  gem "sqlite3"
end

iiwo

# frozen_string_literal: true

require "bundler/inline"

gemfile(true) do
  source "https://rubygems.org"
  gem "activerecord", "6.0.3.7"
  gem "paper_trail", "~> 12", require: false
  gem "sqlite3"
end

iiwo

# frozen_string_literal: true

require "bundler/inline"

gemfile(true) do
  source "https://rubygems.org"

  git_source(:github) { |repo| "https://github.com/#{repo}.git" }

  gem 'rails', '~> 5.1.7'

iiwo

# frozen_string_literal: true

require "bundler/inline"

gemfile(true) do
  source "https://rubygems.org"

  git_source(:github) { |repo| "https://github.com/#{repo}.git" }

  gem 'rails', '~> 5.2.3'

iiwo

# frozen_string_literal: true

require "bundler/inline"

gemfile(true) do
  source "https://rubygems.org"

  git_source(:github) { |repo| "https://github.com/#{repo}.git" }

  # Activate the gem you are reporting the issue against.

iiwo

SELECT COUNT(*)
FROM "users"
LEFT OUTER JOIN blacklisted_emails b_e ON LOWER(b_e.email) = LOWER(users.email)
LEFT OUTER JOIN
  (SELECT "campaign_emails".*
   FROM "campaign_emails"
   INNER JOIN "campaign_blasts" ON "campaign_blasts"."id" = "campaign_emails"."campaign_blast_id"
   INNER JOIN "email_campaigns" ON "email_campaigns"."id" = "campaign_blasts"."email_campaign_id"
   WHERE (email_campaigns.id = NULL)) c_e ON c_e.user_id = users.id
WHERE (b_e.email IS NULL)