Insert Rails without sending null values

Question

I have a table in SQL Server set up with a default value for a uniqueidentifier not null.

I do not want ActiveRecord to send the null value to the database, but it is, causing a 'Cannot insert null value into not null column' error.

How do I save an ActiveRecord without sending columns that have defaults? I don't really want to:

Making the columns nullable.
Using Rails to generate the GUID and sending it to the database
Writing the query manually.

I could do either 2 or 3 this seems like something that has to be doable in plain ActiveRecord/RoR.

Jeff Steil · Accepted Answer · 2013-01-17 18:46:11Z

0

Unfortunately I think this is an issue with Rails with Sql Server as using Rails with MySql handles defaults (and this situation) correctly. There may be other options, but probably the quickest is to add a before_create callback to your ActiveRecord class and set the guid there.

answered Jan 17, 2013 at 18:46

Jeff Steil

1,77017 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert Rails without sending null values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related