ruby script/generate scaffold < types
script/generate scaffold ModelName [field:type, field:type]
Rails 2.x changed the scaffolding script to one that doesn’t make a view that iterates over all the columns, letting you create an admin interface in five minutes, but rather one that wants you to fill in the types of all the columns of the table there, on the spot. (Can you tell I don’t like the change?). Neither the in-command help, nor the docs on scaffold, nor google tell you what the valid types for the columns are; turns out it’s the same types you use in migrations. (Maybe that’s obvious, but being the foolish man I am, I never learned migrations properly until very recently). Thusly, I’ll copy-paste this wonderful cheat-sheet with the types, for future reference for myself and you:
| Rails | db2 | mysql | openbase | Oracle |
|---|---|---|---|---|
:binary | blob(32678) | blob | object | blob |
:boolean | decimal(1) | tinyint(1) | boolean | number(10) |
:date | date | date | date | date |
:datetime | timestamp | datetime | datetime | date |
:decimal | decimal | decimal | decimal | decimal |
:float | float | float | float | number |
:integer | int | int(11) | integer | number(38) |
:string | varchar(255) | varchar(255) | char(4096) | varchar2(255) |
:text | clob(32768) | text | text | clob |
:time | time | time | time | date |
:timestamp | timestamp | datetime | timestamp | date |
| Â | ||||
| Rails | postgresql | sqlite | sqlserver | Sybase |
:binary | bytea | blob | image | image |
:boolean | boolean | boolean | bit | bit |
:date | date | date | datetime | datetime |
:datetime | timestamp | datetime | datetime | datetime |
:decimal | decimal | decimal | decimal | decimal |
:float | float | float | float(8) | float(8) |
:integer | integer | integer | int | int |
:string | * | varchar(255) | varchar(255) | varchar(255) |
:text | text | text | text | text |
:time | time | datetime | datetime | time |
:timestamp | timestamp | datetime | datetime | timestamp |