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.
