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 <darks...@gmail.com> wrote:
> It works!!! Thanks!
>
> On Mar 18, 6:37 pm, mdipierro <mdipie...@cs.depaul.edu> 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 <darks...@gmail.com> 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 <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.
