Is the data there or not? Seriously, just pick one

[adric]

Having stumped one nice fellow on #rubyonrails, I inflict this on you all:

I can make a new object, which is then empty. Sure. I run a method to populate the fields which runs fine and debug out some correctfield data. Inspecting or printing the method shows it is still empty, but if I ask politely the data is there (accessors and to_string). But. When I ask it to save the data, it writes out all NULLS, which is wrong and also causes the DB to throw back an error (since some of those fields are Not Null in the schema). Elipsises mine to cut down on the number of times you need to read nil and NULL.

>> @moo.to_s
=> "first last-name was Zen order 27,\n      so we'll call it number 27."
>> @moo.moocash_orders_id
=> 27
>> @moo.inspect
=> "#< MoocashOrder moocash_id: nil, moocash_orders_id: nil, student_fname: nil, ...
 nil, is_paid_up: false, created_at: \"2008-11-06 17:40:30\", updated_at: \"2008-11-06 17:40:30\">"
>> @moo.save
ActiveRecord::StatementInvalid: SQLite3::SQLException: SQL logic error or missing database: 
INSERT INTO "moocash_orders" ("moocash_orders_id", ... "created_at") 
VALUES(NULL, ... NULL, '2008-11-06 17:40:30', '2008-11-06 17:40:30')

ETA: Trying out the scaffold views shows that they really don't work right either... tried and fix some of that (self.id="id") to see if it helps. This also may indicate further misalignment of gnats and crumbs in the sqlite3 RAILS_ENV=test. Also my joins may not be right, although I'm not using them anywhere that I know of. sqlite returns data when I "select * from yen_orders" but rails scaffold just shows buttons or polite nothing...

Comments

Re: Thanks for looking at this !

[adric]

Wow, thanks so much for actually looking at this.

It's commented out because it didn't work and I wanted to make sure that my override of the constructor wasn't causing the problem .. yesterday?

You can chat at me on any network of your choice if that's easier on you ?