Re: [Rails] Column with dynamic db type

On 2 May 2012, at 21:25, Greg Ma <lists@ruby-forum.com> wrote:

> Hi,
>
> I have a Question model where the answer to the question can have
> multiple db type (integer, string, boolean, ...).

I've had a similar situation. I'd use STI to have different models for different answer types. My repository at http://github.com/ihid/super_sti might help. Email me personally if you want some help with that repository.

Jeremy Walker
http://www.ihid.co.uk

>
> I would like to know if you have a better solution than this one:
>
> Question:
> question:string
> answer_type:string
>
> AnsweredQuestion:
> question_id:integer
> answer:text
> answer_type:string
>
> Ex: AnsweredQuestion.create(:question => 1, :answer => '5', :answer_type
> => 'Integer')
>
> My problem with this solution is that I can't question is that I can't
> question the answered questions where the answer is > 2.
>
> Any better idea?
>
> --
> Posted via http://www.ruby-forum.com/.
>
> --
> You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
> To post to this group, send email to rubyonrails-talk@googlegroups.com.
> To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
>

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.