Re: Using Meta Data in a database field in a View

nobosh
2010-09-30T04:31:28Z

Looks like I''m storing data correctly, I don''t want DATA to be
a JSON
object as it won''t be created via JavaScript but an Observer on
certain models after_create etc...

What do you think about using YAML? I was told Marshal was the way to
go but after doing some google searches I found, there isn''t a lot of
info on Marshal and it sounds like the community is against it...

That being said, in sum:

1. What is the best way to store unsecured data in the data column
2. How to insert and extract from the database?

Thank you



On Sep 29, 8:11 pm, nobosh
<bhellm...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> Hello...
>
> Given a database with records like the following
> Table: AuditLog
> Fields: ID | USERID | TYPE | TIME | DATA
>
>     id:1, userId:1, type:PHOTO, time:2008-10-15 12:00:00, data:
> {photo_id:2089, photoname:"A trip to the beach"}
>
> Lets say the database had 50 records, with Rails How can I loop
> through the results as follows:
>
>
> id, user_id, data.photoID, data.PhotoName
>
>
> The main thing I don''t get is how to extract what''s
inside the data
> column. Example given:
> @mystuff = AuditLog.all
> How to display something like mystuff.data.photo_id
>
> Thanks

--
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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.