Rodauth in seed files (properly destroying and reseting accounts and dependent models))

[mdodell]

Hello!

I am trying to use Rodauth in a seed file. I currently have the following schema, where an Account has a Profile associated with it. I saw this issue which suggested using Account.create in the seed file.

My seed file is very simple right now:

Account.destroy_all

profile = Profile.create(first_name: 'User', last_name: 'Doe')

Account.create(email: '[email protected]', password: 'secret', status: 'verified', profile:)

When I try that, I get an error that the account_id is still being referenced in my Profiles table: update or delete on table "accounts" violates foreign key constraint "fk_rails_f44be28d09" on table "profiles".

That seems odd, as I have the models dependent on destroying as shown below.

When I add Profile.destroy_all before Account.destroy_all, it works, but I'd like to have anything related to Account be destroyed when it is destroyed/deleted.

Here is my schema/models:

ActiveRecord::Schema[7.0].define(version: 2023_07_03_133647) do
  enable_extension "citext"
  enable_extension "plpgsql"

  create_table "account_password_reset_keys", force: :cascade do |t|
    t.string "key", null: false
    t.datetime "deadline", null: false
    t.datetime "email_last_sent", default: -> { "CURRENT_TIMESTAMP" }, null: false
  end

  create_table "account_remember_keys", force: :cascade do |t|
    t.string "key", null: false
    t.datetime "deadline", null: false
  end

  create_table "account_verification_keys", force: :cascade do |t|
    t.string "key", null: false
    t.datetime "requested_at", default: -> { "CURRENT_TIMESTAMP" }, null: false
    t.datetime "email_last_sent", default: -> { "CURRENT_TIMESTAMP" }, null: false
  end

  create_table "accounts", force: :cascade do |t|
    t.integer "status", default: 1, null: false
    t.citext "email", null: false
    t.string "password_hash"
    t.index ["email"], name: "index_accounts_on_email", unique: true, where: "(status = ANY (ARRAY[1, 2]))"
  end

  create_table "profiles", force: :cascade do |t|
    t.bigint "account_id", null: false
    t.string "first_name"
    t.string "last_name"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.index ["account_id"], name: "index_profiles_on_account_id"
  end

  add_foreign_key "account_password_reset_keys", "accounts", column: "id"
  add_foreign_key "account_remember_keys", "accounts", column: "id"
  add_foreign_key "account_verification_keys", "accounts", column: "id"
  add_foreign_key "profiles", "accounts"
end

My Account model looks like this:

class Account < ApplicationRecord
  include Rodauth::Rails.model

  has_one :profile, dependent: :destroy
  enum :status, unverified: 1, verified: 2, closed: 3

  def to_builder
    Jbuilder.new do |account|
      account.call(self, :status, :email)
      account.profile profile.to_builder
    end
  end
end

Here is my Profile

class Profile < ApplicationRecord
  belongs_to :account, dependent: :destory

  def to_builder
    Jbuilder.new do |profile|
      profile.call(self, :first_name, :last_name)
    end
  end
end

[janko]

I couldn't reproduce this in the official demo app. I added the inverse dependent: :destroy option on Profile side, and ran the following script with rails runner, but it deletes the account with profile just fine:

account = Account.create!(email: "[email protected]", password: "secret", status: "verified")
profile = Profile.create!(account: account, name: "Foobar")

Account.destroy_all