Neil Blakey-Milner wrote:
> The downside of storing in the database attached to your main class is
> that SQLObject will fetch that from the database every time you get any
> information from a particular object. That's fairly heavy - when I
> tried it, it made the whole application unusable.
>
With SQLAlchemy, you can ask that a column is retrieved only upon reference.
>From the example:
book_excerpts = Table('books', db,
Column('book_id', Integer, primary_key=True),
Column('title', String(200), nullable=False),
Column('summary', String(2000)),
Column('excerpt', String),
Column('photo', Binary)
)
class Book(object):
pass
# define a mapper that will load each of 'excerpt' and 'photo' in
# separate, individual-row SELECT statements when each attribute
# is first referenced on the individual object instance
mapper(Book, book_excerpts, properties = {
'excerpt' : deferred(book_excerpts.c.excerpt),
'photo' : deferred(book_excerpts.c.photo)
})
Deferred columns can also be grouped and loaded together.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/turbogears
-~----------~----~----~----~------~----~------~--~---
