Is there a concept of having a model attribute loaded only when necessary. For example, I have a model called product with an attribute called file which is stored in the database as a blob. I would like to be able to retrieve a bunch of products as an array without having to load the file BLOB. Only loading it when necessary. Your help is much appreciated. Mario --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
You could wrap the file into its own object, and have the "product" model refer to the file object using has_one or has_many. This way, when you use the product model, the file model will not be loaded due to the default lazy-loading, and when you need the file, you can just go to product.file, which will load the necessary blob. Hope that helps, ~Ian On Apr 30, 7:16 pm, Mario <mari...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Is there a concept of having a model attribute loaded only when > necessary. For example, I have a model called product with an > attribute called file which is stored in the database as a blob. I > would like to be able to retrieve a bunch of products as an array > without having to load the file BLOB. Only loading it when necessary. > > Your help is much appreciated. > > Mario--~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Hi,> Is there a concept of having a model attribute loaded only when > necessary. For example, I have a model called product with an > attribute called file which is stored in the database as a blob. I > would like to be able to retrieve a bunch of products as an array > without having to load the file BLOB. Only loading it when necessary.Not sure if my suggestion is the best since it''s not 100% automatic, but almost ;) You could use the :select clause of find, so you select only those attributes you want to retrieve always. Then for the rest of the attributes if you try to read them from the object you would have an error, since they weren''t loaded from db. So here comes the trick... In your :select clause don''t forget to include the id as one of the selected fields. That way you could use it to get the rest of the data from db when you need it. Easiest way of doing this would be a find with a select clause for your blob/clob field. obj=MyHeavyModel.find(:first,:select=>''id,name,any_other_simple_fields'') puts obj.id puts obj.name puts obj.blob_field #this would cause an exception since it''s not loaded puts MyHeavyModel.find(obj.id,:select=>''blob_field'').blob_field #but this would work In case you have several blob/clob fields in your table, maybe you want to reload them all directly. In that case you don''t even have to write a new find, but just invoke reload over your object.The good thing is reload will not take into account the original select clause, but directly use the id to retrieve the complete row/object from database. obj=MyHeavyModel.find(:first,:select=>''id,name,any_other_simple_fields'') puts obj.id puts obj.name puts obj.blob_field #this would cause an exception since it''s not loaded obj.reload #everything gets retrived from db, even not previously selected fields puts obj.blob_field #now you have here your field Any of those solutions, should work fine, but you can still make it a bit more transparent if the find/reload looks artificial in your code; you could play with method_missing of your model so if it''s being called for an attribute which is in your "column_names" list, it can automatically reload/find the object and return the value of the attribute back. If you go with this approach, just take into account method_missing is already overwritten in AR classes, so alias the old method and don''t forget to call it before executing your part. Regards, Javier Ramirez - -------- Estamos de estreno... si necesitas llevar el control de tus gastos visita http://www.gastosgem.com !!Es gratis!! --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On 4/30/07, Ian Bailey <ian-jzMcY+p28M8mroCTmvX//g@public.gmane.org> wrote:> > You could wrap the file into its own object, and have the "product" > model refer to the file object using has_one or has_many. This way, > when you use the product model, the file model will not be loaded due > to the default lazy-loading, and when you need the file, you can just > go to product.file, which will load the necessary blob. > > Hope that helps, > ~IanThis is how my attachment_fu/acts_as_attachment plugin was originally written. Does a Product have a blob for an attached file, or does it have a relation to a ProductFile model with its own metadata? -- Rick Olson http://lighthouseapp.com http://weblog.techno-weenie.net http://mephistoblog.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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
I have another question. If I do product.save (where product is an
instance of my Product model), here is what the mysql adapter for Ruby
will do:
SQL: INSERT INTO `PRODUCT` COLUMNS(NAME, PRICE, FILE)
VALUES(''PROD1'',
4.56, X''00DEF033423023220'')
All is hunky dory for as long as my BLOB is not too big. If the blob
is say 8MB (not that big actually),there is a problem:
The buffer used by the mysql server(max_allowed_packet) to hold the
commands must be at least 16MB (two bytes for hexadecimal
representation). This is an unecessarily huge number for holding SQL
commands.
Is there a way to tell ruby to use a host variable in the SQL
statement (i.e. VALUES(''PROD1'', 4.56, :blobvar) instead of the
literal
format in the example above. I cannot believe this problem has never
been seen before? Imagine if the BLOB data I need to store is 100MB?
Your help is much appreciated.
On Apr 30, 7:16 pm, Mario
<mari...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> Is there a concept of having a model attribute loaded only when
> necessary. For example, I have a model called product with an
> attribute called file which is stored in the database as a blob. I
> would like to be able to retrieve a bunch of products as an array
> without having to load the file BLOB. Only loading it when necessary.
>
> Your help is much appreciated.
>
> Mario
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---