sorry, I may have my object types wrong.
To summarize:
I'm trying to pass data directly to t2.itemize() without having to
write to a database.
If I understood right, Bill was hinting that writing to an in-memory
database was the easiest way, so I was wondering what was the harder
alternative way.
I was hoping there was a way to directly instantiate the required
input for t2.itemize() directly without going through a database.
Writing to a temporary in-memory database 'smells' bad for me.
For now I've created my own itemize.
Baron
On Nov 21, 8:11 am, mdipierro <[EMAIL PROTECTED]> wrote:
> What for? SQLTable or SQLTABLE? I am confused.
>
> Massimo
>
> On Nov 20, 3:06 pm, Baron <[EMAIL PROTECTED]> wrote:
>
> > > The easiest way to construct an SQLTable is to use define_table (as in a
> > > model like db.py).
>
> > You say 'easiest' - is there an alternative way to instantiate an
> > SQLTable object?
>
> > On Nov 19, 9:20 pm, billf <[EMAIL PROTECTED]> wrote:
>
> > > OK, I see. The objects passed to itemize are an SQLTable and,
> > > optionally, an SQLQuery, that basically filters the rows returned.
> > > The easiest way to construct an SQLTable is to use define_table (as in
> > > a model like db.py). That's why I was suggesting an in-memory
> > > database which Massimo has now implemented in trunk.
>
> > > So you should be able to say (I haven't tested this and the while is
> > > pseudo-code):
>
> > > dbm=SQLDB('sqlite:memory:')
>
> > > dbm.define_table('temp_data',SQLField('temp_field1),SQLField
> > > ('temp_field2'), etc)
>
> > > while creating_temp_data:
> > > dbm.temp_data.insert(temp_field1='X',temp_field2='Y')
>
> > > t2.itemize(dbm.temp_data)
>
> > > And all the temp data is just held in memory. Does that help?
>
> > > On Nov 19, 8:49 am, Baron <[EMAIL PROTECTED]> wrote:
>
> > > > > When you say "these tables are Python objects", I assume you are
>
> > > > refererring to your temporary data(?)
>
> > > > No, to the table input to itemize. This input is a python object. So
> > > > can this object be instantiated directly without going through a
> > > > database?
>
> > > > On Nov 19, 5:36 pm, billf <[EMAIL PROTECTED]> wrote:
>
> > > > > When you say "these tables are Python objects", I assume you are
> > > > > refererring to your temporary data(?)
>
> > > > > The "detour" above about in-memory tables was just to provide an
> > > > > alternative to making your own itemize, i.e.:
> > > > > - define your temp tables as in-memory tables
> > > > > - insert your "rows" instead of appending to your Python objects
> > > > > - pass the in-memory tables to the existing itemize
>
> > > > > (Apologies if that was stating the obvious)
>
> > > > > On Nov 18, 10:48 pm, Baron <[EMAIL PROTECTED]> wrote:
>
> > > > > > These tables are Python objects, so is there a way to instantiate
> > > > > > them
> > > > > > without a database?
>
> > > > > > Otherwise I'll do as you suggest, Bill, and make my own itemize.
> > > > > > Baron
>
> > > > > > On Nov 19, 12:33 am, billf <[EMAIL PROTECTED]> wrote:
>
> > > > > > > I don't think you can - as you say itemize takes tables and an
> > > > > > > optional query. I think you will have to create your own
> > > > > > > "itemize"
> > > > > > > that works off your results. Looking at T2.itemize, it should not
> > > > > > > be
> > > > > > > difficult.
>
> > > > > > > Would it be nice if one could create a database and table in ram
> > > > > > > cache
> > > > > > > (disk cache wouldn't be much better than a conventional temp
> > > > > > > table?)
> > > > > > > and access it like a normal database. Maybe that is possible
> > > > > > > already
> > > > > > > but I don't think so.
>
> > > > > > > On Nov 18, 11:47 am, Baron <[EMAIL PROTECTED]> wrote:
>
> > > > > > > > hello,
>
> > > > > > > > My app calculates temporary data that I want to display to the
> > > > > > > > user.
> > > > > > > > There is a lot of it so paginating it with t2.itemize sounds
> > > > > > > > like a
> > > > > > > > good idea. But itemize takes a database table as input.
>
> > > > > > > > So, I could write the data to a table and then query it to get
> > > > > > > > the
> > > > > > > > right form, but that would be wasteful. How can I instead wrap
> > > > > > > > the
> > > > > > > > data directly for itemize?
>
> > > > > > > > thanks,
> > > > > > > > Baron- Hide quoted text -
>
> > > > > > - Show quoted text -
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
