Yeap it works now for MySQL but not for GAE.
Expected one of (<class 'google.appengine.ext.db.Model'>,); Got a
dict()
On Mar 18, 4:51 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> Should be
>
> db.table_name.bulk_insert(
> *[{
> 'name': data['name'],
> 'surname': data['surname'],
> 'registered': False} for data in some_data])
>
> The star was missing.
>
> On Mar 18, 9:19 am, Jon Romero <darks...@gmail.com> wrote:
>
>
>
> > It doesn't seem to work.
> > This is my code
> > db.table_name.bulk_insert(
> > [{
> > 'name': data['name'],
> > 'surname': data['surname'],
> > 'registered': False} for data in some_data])
>
> > Problems:
> > On not GAE, I have this problem:
> > Expected one of (<class 'google.appengine.ext.db.Model'>,); Got a
> > dict()
>
> > On MySQL, was getting an error that it was expecting a map not a list.
> > I tried this and it doesn't work:
> > db.table_name.insert(dict(field='smth'))
>
> > Any hints?
>
> > On Jan 31, 5:01 pm, Jon Romero <darks...@gmail.com> wrote:
>
> > > I am going to stress test it this week :)
>
> > > On Jan 31, 4:44 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > needs testing but please check in trunk
>
> > > > db.table.bulk_insert([dict(field='value'),dict(field1='value')])
>
> > > > Massimo
>
> > > > On Jan 31, 3:11 am, Jon Romero <darks...@gmail.com> wrote:
>
> > > > > Yeap the speadup is HUGE (one query toinsert100 rows). Inserting in
> > > > > gae is slow and if you try toinsert100 one by one you get timeout
> > > > > errors. I am using the gae_retry butinsertqueries are bad for
> > > > > quotas.
>
> > > > > I am already using put after importing gae but it accepts gae models
> > > > > in an array. So I have to declare AGAIN my table with gae.models and
> > > > > that creates a lot of confusion.
>
> > > > > On Jan 31, 2:31 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > > > We will think about this for the new DAL. It is not difficult to
> > > > > > add.
> > > > > > Other than syntactical sugar, is there a speed up? If so for now you
> > > > > > can do
>
> > > > > > from gluon.contrib.gql import gae
>
> > > > > > gae.put(...)
>
> > > > > > and access the low lever gae api.
>
> > > > > > On Jan 30, 6:21 pm, Jon Romero <darks...@gmail.com> wrote:
>
> > > > > > > It doesn't seem that's easy to dobulkinserts for AppEngine using
> > > > > > > web2py (please correct me if I am wrong).
> > > > > > > Theinsertfunction for gae does a Table.put(data) (Model.put(data)
> > > > > > > in
> > > > > > > terms of AppEngine) where forbulkwe need:
> > > > > > > db.put([array_of_Models]).
>
> > > > > > > Is this going to be corrected on the new DAL? Is there a way to
> > > > > > > have
> > > > > > > access to db (gae) so I can do a put?
>
> > > > > > > On Jan 16, 5:08 am, Jon Romero <darks...@gmail.com> wrote:
>
> > > > > > > > Is there any way to dobulkinserts in GAE?
>
> > > > > > > > Check here number 5
> > > > > > > > (http://googleappengine.blogspot.com/2009/06/10-
> > > > > > > > things-you-probably-didnt-know-about.html)
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
