activerecord is not saving the relationship

Question

I have a relationship like that in Rails

class ReducaoZ < ActiveRecord::Base
  self.table_name = 'reducaoz'   
  has_many :aliquotas, foreign_key: 'reducaoz_id', class_name: 'Aliquota', dependent: :delete_all
end


class Aliquota < ActiveRecord::Base
  self.table_name = 'aliquota'

  belongs_to :reducaoz, class_name: 'ReducaoZ'
end

and at a given time, I urge several aliquots within the reduction

aliquota = reucao.aliquotas.build
aliquota.basecalculo = aliquota.valor
# outros valores
red.aliquotas << aliquota

and when I try to save z reduction, the field reducaoz_id is not there. as there is a constraint to not save aliquot without reducaoz_id, activerecord throws an error.
Apparently it’s all right, I can’t see the error. Does anyone have any idea what I missed?

Edit The sql that Rails tries to execute (along with the error) is this

  SQL (23.4ms)  INSERT INTO "aliquota" ("aliquota", "basecalculo", "valor") VALUES ($1, $2, $3) RETURNING "id"  [["aliquota", "0300"], ["basecalculo", "0.0"], ["valor", "0.0"]]
PG::NotNullViolation: ERROR:  null value in column "reducaoz_id" violates not-null constraint
: INSERT INTO "aliquota" ("aliquota", "basecalculo", "valor") VALUES ($1, $2, $3) RETURNING "id"
   (1.0ms)  ROLLBACK
ActiveRecord::StatementInvalid Exception: PG::NotNullViolation: ERROR:  null value in column "reducaoz_id" violates not-null constraint

Answer 1

PG::Notnullviolation: ERROR: null value in column "reducaoz_id" violates not-null Constraint

The PG in front of the exception tells us that this exception was raised by Postgres (because of the Constraint NOT NULL) and not directly by Activerecord. That means you forgot to add

validates :reducaoz_id, presence: true

---

But this doesn’t solve your problem.

Try once to change

aliquota = reucao.aliquotas.build

for

@reducao = ReducaoZ.find(params[:reducaoz_id]) # esta linha pode mudar (não sei como tu fez)
@aliquota = @reducao.aliquotas.new

although theoretically it’s the same thing.