Shouldn't the bulk insert on Appengine (and on MySQL), return the ids of the inserted row? Now, it just returns True, where it should have been something like (taken from insert in gql.py):
tmp.put() rid = Reference(tmp.key().id()) (rid._table, rid._record) = (self, None) On Mar 18, 6:42 pm, Jon Romero <[email protected]> wrote: > It works!!! Thanks! > > On Mar 18, 6:37 pm, mdipierro <[email protected]> wrote: > > > > > It is a bug. Thanks for checking it. > > Please help me test the fix. > > > In gluon/contrib/gae.py replace line 277 > > > parsed_items.append(fields) > > with: > > parsed_items.append(self._tableobj(**fields)) > > > Does it work now? > > > Massimo > > > On Mar 18, 11:04 am, Jon Romero <[email protected]> wrote: > > > > 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> wrote: > > > > > > > I am going to stress test it this week :) > > > > > > > On Jan 31, 4:44 pm, mdipierro <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 [email protected]. 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.
