Money-rails gem:如何在ActiveRecord查询中使用Money对象？

Question

在安装money-rails gem之前，我在控制器中有了以下查询：

@forecasts.where('max >= ?', @budget).limit(1)[0]

其中:budget是表forecasts中的整数列。

安装money-rails后，我将该列重命名为:budget_subunits，在:budget_subunits模型中输入monetize: :budget_subunits as: :budget，使:budget现在成为Money对象。现在，此查询将导致以下错误：

PG::InvalidTextRepresentation: ERROR: invalid input syntax for integer: "--- !ruby/object:Money fractional: 4000000000.0 currency: !ruby/object:Money::Currency id: :usd priority: 1 iso_code: USD name: United States Dollar symbol: $ alternate_symbols: - US$ subunit: Cent subunit_to_unit: 100 symbol_first: true html_entity: $ decimal_mark: . thousands_separator: ',' iso_numeric: '840' bank: !ruby/object:Money::Bank::VariableExchange rounding_method: rates: {} mutex: !ruby/object:Mutex {} " LINE 1: ...get_segments"."budget_source_id" = $1 AND (max >= '--- !ruby... ^ : SELECT "budget_segments".* FROM "budget_segments" WHERE "budget_segments"."budget_source_id" = $1 AND (max >= '--- !ruby/object:Money fractional: 4000000000.0 currency: !ruby/object:Money::Currency id: :usd priority: 1 iso_code: USD name: United States Dollar symbol: $ alternate_symbols: - US$ subunit: Cent subunit_to_unit: 100 symbol_first: true html_entity: $ decimal_mark: . thousands_separator: '','' iso_numeric: ''840'' bank: !ruby/object:Money::Bank::VariableExchange rounding_method: rates: {} mutex: !ruby/object:Mutex {} ') ORDER BY "budget_segments".max ASC LIMIT 1

我知道我只需要使用:budget_subunits列，并将其与:max_subunits列进行比较，但这难道不就会辜负使用money-rails创业板的全部目的吗？

简单地说，如何在activerecord查询中使用Money对象？

Answer 1

调用cents将其转换为它的美分值，并对其进行查询。