singular association name

[bol-stas-t]

require 'sqlite3'
require 'sequel'
Sequel::VERSION # => "5.96.0"
DB = Sequel.connect('sqlite://test.db')
DB.create_table(:users){ primary_key :id }
DB.create_table(:user_bonuses){
  primary_key :id
  Integer :user_id
}

class User < Sequel::Model
  one_to_many :user_bonuses, class: :UserBonus
end

User.instance_methods.grep(/user_bonus/)
=> [:add_user_bonuse, :remove_user_bonuse, :remove_all_user_bonuses, :user_bonuses, :user_bonuses_dataset]

Why bonuse? How can I change this to bonus?
I thied

Sequel.extension :inflector
Sequel.inflections { |i| i.irregular 'user_bonus', 'user_bonuses' }

tried singular option for association

chatGPT failed to handle this issue

help please

[jeremyevans]

Add this before defining the association:

Sequel.extension :inflector
String.inflections do |inflect|
  inflect.singular /(bonus)es/i, '\1'
end

[jeremyevans]

Also, your code with Sequel.inflections { |i| i.irregular 'user_bonus', 'user_bonuses' } will also fix it, but must be before the association definition and not after.

[bol-stas-t]

no, working only your version

$ irb
irb(main):001> require 'sqlite3'
irb(main):002> require 'sequel'
irb(main):003> Sequel::VERSION # => "5.96.0"
irb(main):004> DB = Sequel.connect('sqlite://test.db')
=> #<Sequel::SQLite::Database database=test.db>
irb(main):005> Sequel.extension :inflector
irb(main):006> Sequel.inflections { |i| i.irregular 'user_bonus', 'user_bonuses' }
=> Sequel::Inflections
irb(main):007* class User < Sequel::Model
irb(main):008*   one_to_many :user_bonuses, class: :UserBonus
irb(main):009> end
=>
{type: :one_to_many,
 name: :user_bonuses,
 cache: {},
 model: User,
 use_placeholder_loader: true,
 eager_block: nil,
 graph_join_type: :left_outer,
 order_eager_graph: true,
 graph_alias_base: :user_bonuses,
 graph_conditions: [],
 class_name: "UserBonus",
 _hash: 281261981123635470,
 key: :user_id,
 key_method: :user_id,
 keys: [:user_id],
 key_methods: [:user_id],
 primary_key: :id,
 eager_loader_key: :id,
 primary_keys: [:id],
 primary_key_column: :id,
 primary_key_columns: [:id],
 uses_composite_keys: false,
 dataset: #<Proc:0x00000001099276b0 /Users/dev-back-02/.rvm/gems/ruby-3.4.4/gems/sequel-5.96.0/lib/sequel/model/associations.rb:225>,
 eager_loader: #<Proc:0x000000010a535a60 /Users/dev-back-02/.rvm/gems/ruby-3.4.4/gems/sequel-5.96.0/lib/sequel/model/associations.rb:2383>,
 cartesian_product_number: 1,
 eager_grapher: #<Proc:0x000000010a535a38 /Users/dev-back-02/.rvm/gems/ruby-3.4.4/gems/sequel-5.96.0/lib/sequel/model/associations.rb:2416>,
 adder: #<Proc:0x000000010a5359c0 /Users/dev-back-02/.rvm/gems/ruby-3.4.4/gems/sequel-5.96.0/lib/sequel/model/associations.rb:2467>,
 remover: #<Proc:0x000000010a535998 /Users/dev-back-02/.rvm/gems/ruby-3.4.4/gems/sequel-5.96.0/lib/sequel/model/associations.rb:2474>,
 clearer: #<Proc:0x000000010a535970 /Users/dev-back-02/.rvm/gems/ruby-3.4.4/gems/sequel-5.96.0/lib/sequel/model/associations.rb:2481>,
 dataset_method: :user_bonuses_dataset,
 _add_method: :_add_user_bonuse,
 add_method: :add_user_bonuse,
 _remove_method: :_remove_user_bonuse,
 remove_method: :remove_user_bonuse,
 _remove_all_method: :_remove_all_user_bonuses,
 remove_all_method: :remove_all_user_bonuses,
 dataset_opt_arity: 1,
 dataset_opt_method: :_sequel_user_bonuses_dataset_opt_1,
 orig_class: :UserBonus,
 orig_opts: {class: nil, class_name: "UserBonus", block: nil}}
irb(main):010>

add_method: :add_user_bonuse

$ irb
irb(main):001> require 'sqlite3'
irb(main):002> require 'sequel'
irb(main):003> Sequel::VERSION # => "5.96.0"
irb(main):004> DB = Sequel.connect('sqlite://test.db')
=> #<Sequel::SQLite::Database database=test.db>
irb(main):005> Sequel.extension :inflector
irb(main):006* String.inflections do |inflect|
irb(main):007*   inflect.singular /(bonus)es/i, '\1'
irb(main):008> end
=> String::Inflections
irb(main):009* class User < Sequel::Model
irb(main):010*   one_to_many :user_bonuses, class: :UserBonus
irb(main):011> end
=>
{type: :one_to_many,
 name: :user_bonuses,
 cache: {},
 model: User,
 use_placeholder_loader: true,
 eager_block: nil,
 graph_join_type: :left_outer,
 order_eager_graph: true,
 graph_alias_base: :user_bonuses,
 graph_conditions: [],
 class_name: "UserBonus",
 _hash: 4183890282397096351,
 key: :user_id,
 key_method: :user_id,
 keys: [:user_id],
 key_methods: [:user_id],
 primary_key: :id,
 eager_loader_key: :id,
 primary_keys: [:id],
 primary_key_column: :id,
 primary_key_columns: [:id],
 uses_composite_keys: false,
 dataset: #<Proc:0x0000000103a54db8 /Users/dev-back-02/.rvm/gems/ruby-3.4.4/gems/sequel-5.96.0/lib/sequel/model/associations.rb:225>,
 eager_loader: #<Proc:0x0000000104783598 /Users/dev-back-02/.rvm/gems/ruby-3.4.4/gems/sequel-5.96.0/lib/sequel/model/associations.rb:2383>,
 cartesian_product_number: 1,
 eager_grapher: #<Proc:0x00000001047834f8 /Users/dev-back-02/.rvm/gems/ruby-3.4.4/gems/sequel-5.96.0/lib/sequel/model/associations.rb:2416>,
 adder: #<Proc:0x0000000104783458 /Users/dev-back-02/.rvm/gems/ruby-3.4.4/gems/sequel-5.96.0/lib/sequel/model/associations.rb:2467>,
 remover: #<Proc:0x0000000104783408 /Users/dev-back-02/.rvm/gems/ruby-3.4.4/gems/sequel-5.96.0/lib/sequel/model/associations.rb:2474>,
 clearer: #<Proc:0x00000001047833e0 /Users/dev-back-02/.rvm/gems/ruby-3.4.4/gems/sequel-5.96.0/lib/sequel/model/associations.rb:2481>,
 dataset_method: :user_bonuses_dataset,
 _add_method: :_add_user_bonus,
 add_method: :add_user_bonus,
 _remove_method: :_remove_user_bonus,
 remove_method: :remove_user_bonus,
 _remove_all_method: :_remove_all_user_bonuses,
 remove_all_method: :remove_all_user_bonuses,
 dataset_opt_arity: 1,
 dataset_opt_method: :_sequel_user_bonuses_dataset_opt_1,
 orig_class: :UserBonus,
 orig_opts: {class: nil, class_name: "UserBonus", block: nil}}
irb(main):012>

add_method: :add_user_bonus

may be bug

ruby 3.4.4 (2025-05-14 revision a38531fd3f) +PRISM [x86_64-darwin19]

tnx for help

[bol-stas-t]

$ irb
irb(main):001> require 'sequel'
=> true
irb(main):002> Sequel::VERSION
=> "5.96.0"

[jeremyevans]

Sorry, I missed the typo in your code. If you are using Sequel.extension :inflector, you need to use String.inflections, not Sequel.inflections. Sequel.inflections will work if you are not using the inflector extension.

Sequel will call inflection methods on String if they exist. If they do not exist, it will call internal inflection methods. Sequel.inflections manages the internal inflection methods. The inflector extension adds inflection methods to String, which are managed by String.inflections. So this isn't a bug, it's expected behavior.