displaying the id field

Thufir · December 8, 2007, 12:41pm

When the browser is pointed to <http://localhost:3000/feeds> there's a CRUD interface. However, the interface doesn't display all of the fields defined at <http://strawr.googlecode.com/svn/trunk/db/ migrate/001_feeds.rb>.

I've done "rake db:migrate VERSION=0 ; rake db:migrate" and, also:

thufir@arrakis ~/Desktop/strawr/db $ thufir@arrakis ~/Desktop/strawr/db $ ll total 20 -rw-r--r-- 1 thufir users 9216 Dec 8 04:29 development.sqlite3 drwxr-xr-x 3 thufir users 4096 Dec 8 04:29 migrate -rw-r--r-- 1 thufir users 1430 Dec 8 04:29 schema.rb thufir@arrakis ~/Desktop/strawr/db $ thufir@arrakis ~/Desktop/strawr/db $ sqlite3 development.sqlite3 SQLite version 3.4.1 Enter ".help" for instructions

.schema

CREATE TABLE categories ("id" INTEGER PRIMARY KEY NOT NULL, "parent_num" integer DEFAULT NULL, "title" varchar(255) DEFAULT NULL, "feed_id" integer DEFAULT NULL); CREATE TABLE feeds ("id" INTEGER PRIMARY KEY NOT NULL, "title" varchar (255) DEFAULT NULL, "location" varchar(255) DEFAULT NULL, "category_id" integer DEFAULT NULL, "item_id" integer DEFAULT NULL); CREATE TABLE items ("id" INTEGER PRIMARY KEY NOT NULL, "title" varchar (255) DEFAULT NULL, "is_read" integer DEFAULT NULL, "link" varchar(255) DEFAULT NULL, "pub_date" varchar(255) DEFAULT NULL, "description" varchar (255) DEFAULT NULL, "feed_id" integer DEFAULT NULL); CREATE TABLE nodes ("id" INTEGER PRIMARY KEY NOT NULL, "obj_num" integer DEFAULT NULL, "norder" varchar(255) DEFAULT NULL, "type" varchar(255) DEFAULT NULL); CREATE TABLE posts ("id" INTEGER PRIMARY KEY NOT NULL, "post" varchar (255) DEFAULT NULL); CREATE TABLE schema_info (version integer);

.quit

thufir@arrakis ~/Desktop/strawr/db $ thufir@arrakis ~/Desktop/strawr/db $

Clearly the "feeds" table has "item_id" as a field; so why doesn't it show in the CRUD? Perhaps I need to undo and then redo the scaffolding?

based on <http://strawr.googlecode.com/svn/trunk/app/views/feeds/ show.rhtml>, I don't see why all the fields for "feeds" aren't being displayed

thanks,

Thufir

Frederick_Cheung · December 8, 2007, 1:09pm

When the browser is pointed to <http://localhost:3000/feeds> there's a CRUD interface. However, the interface doesn't display all of the fields defined at <http://strawr.googlecode.com/svn/trunk/db/ migrate/001_feeds.rb>.

Scaffolding just iterates over content_columns. If you look a the doc for content_columns you'll see that it doesn't include columns ending in _id

Fred

Thufir · December 8, 2007, 7:33pm

Yes, you're absolutely correct (I even looked at the API after posting this last night). I tried a few variations, and did some light googling, but didn't find a way to get it iterate over all fields.

Can I just change that one line so that it shows all of the fields when doing any of the CRUD actions?

thanks,

Thufir

Frederick_Cheung · December 8, 2007, 7:57pm

Scaffolding just iterates over content_columns. If you look a the doc for content_columns you'll see that it doesn't include columns
ending in _id

Yes, you're absolutely correct (I even looked at the API after posting this last night). I tried a few variations, and did some light
googling, but didn't find a way to get it iterate over all fields.

Can I just change that one line so that it shows all of the fields
when doing any of the CRUD actions?

does using Model.columns do what you want?

Fred

Thufir · December 9, 2007, 7:02am

does using Model.columns do what you want?

I still get the same result after using Feed.columns

http://strawr.googlecode.com/svn/trunk/app/views/feeds/list.rhtml

The database appears fine:

thufir@arrakis ~/Desktop/strawr/db $ thufir@arrakis ~/Desktop/strawr/db $ thufir@arrakis ~/Desktop/strawr/db $ thufir@arrakis ~/Desktop/strawr/db $ sqlite3 development.sqlite3 SQLite version 3.4.1 Enter ".help" for instructions

.schema

CREATE TABLE categories ("id" INTEGER PRIMARY KEY NOT NULL, "parent_num" integer DEFAULT NULL, "title" varchar(255) DEFAULT NULL, "feed_id" integer DEFAULT NULL); CREATE TABLE feeds ("id" INTEGER PRIMARY KEY NOT NULL, "title" varchar (255) DEFAULT NULL, "location" varchar(255) DEFAULT NULL, "category_id" integer DEFAULT NULL, "item_id" integer DEFAULT NULL); CREATE TABLE items ("id" INTEGER PRIMARY KEY NOT NULL, "title" varchar (255) DEFAULT NULL, "is_read" integer DEFAULT NULL, "link" varchar(255) DEFAULT NULL, "pub_date" varchar(255) DEFAULT NULL, "description" varchar (255) DEFAULT NULL, "feed_id" integer DEFAULT NULL); CREATE TABLE nodes ("id" INTEGER PRIMARY KEY NOT NULL, "obj_num" integer DEFAULT NULL, "norder" varchar(255) DEFAULT NULL, "type" varchar(255) DEFAULT NULL); CREATE TABLE posts ("id" INTEGER PRIMARY KEY NOT NULL, "post" varchar (255) DEFAULT NULL); CREATE TABLE schema_info (version integer);

.quit

thufir@arrakis ~/Desktop/strawr/db $

-Thufir

Frederick_Cheung · December 9, 2007, 11:04am

does using Model.columns do what you want?

I still get the same result after using Feed.columns

http://strawr.googlecode.com/svn/trunk/app/views/feeds/list.rhtml

Well you've still got a content_columns at the top of your page. Other
than that I don't see why it wouldn't work (although you wouldn't see
anything if the _id columns were null)

Fred

Thufir · December 10, 2007, 9:36am

Doh, fixed that; thanks. The item_id field for a row in the feeds table will be null until I can edit that field; for instance, by displaying the field.

Won't it show: "item_id: NULL" as it does for other fields?

thanks,

Thufir

Frederick_Cheung · December 10, 2007, 9:50am

Well you've still got a content_columns at the top of your page.
Other than that I don't see why it wouldn't work (although you wouldn't see anything if the _id columns were null)

Doh, fixed that; thanks. The item_id field for a row in the feeds
table will be null until I can edit that field; for instance, by
displaying the field.

Won't it show: "item_id: NULL" as it does for other fields?

no. It would show nil.to_s (ie blank), although you should of course
get the column headings.

Fred