please correct me if i am wrong, but ID's on GAE are really UUID's and
are not sequential and not guaranteed to be strictly increasing.
timestamps are the closest you can get to strictly increasing on GAE,
but it is possible for 2 inserts to happen at the same time, so don't
count on that 100% either.
cfh
On Sep 10, 4:42 am, b vivek <bvivek1...@gmail.com> wrote:
> Oh Thanks I got it ... the solution suggested by Martin works perfectly
> instead of ordering by record id ,it should be ordered by datetime field and
> the tilde works fine!
>
> On Fri, Sep 10, 2010 at 4:23 PM, b vivek <bvivek1...@gmail.com> wrote:
> > It would be great if somebody could please let me know how to find the id
> > of the last inserted row in a table using DAL
>
> > On Fri, Sep 10, 2010 at 4:09 PM, b vivek <bvivek1...@gmail.com> wrote:
>
> >> Sorry for the late reply Martin, but even if I add the datetime field in
> >> here,and order by the datetime field , wont I get the data
> >> in ascending order . However I did what you had suggested , But i still am
> >> able to retrive the data in ascending order rather than descending.
> >> Could there be any other method ..
> >> (A quick recap--> I am trying to get the data ordered in descending order
> >> from the dbase. It can be done by using a tilde , but the GAE seems to
> >> ignore the tilde all together.. Please help)
>
> >> On Thu, Sep 9, 2010 at 3:46 PM, Martin.Mulone
> >> <mulone.mar...@gmail.com>wrote:
>
> >>> Yes but i think this is gae thing. You try? with max(id) or add some
> >>> datetime field and order by this field like Field('created_on',
> >>> 'datetime',
> >>> default=datetime.datetime.today(),writable=False,readable=False)
>
> >>> On 9 sep, 03:06, b vivek <bvivek1...@gmail.com> wrote:
> >>> > Ok so if i have a table in my db named homepage as below:-
> >>> > ----------------------
> >>> > id | data |
> >>> > -----------------------
> >>> > 1 | vivek|
> >>> > ----------------------
> >>> > 2 | andrew|
> >>> > -----------------------
>
> >>> > Now if I want to retrieve only the last row .. i can do this
> >>> > homepage=db().select(db.homepage.ALL,orderby=~db.homepage.id
> >>> ,limitby=(0,1))
>
> >>> > Now let me point out that this works prefectly on localhost using the
> >>> normal
> >>> > rdbms like mysql or sqlite. However when I use the local development
> >>> GAE
> >>> > environ or even when I upload it to GAE,it just returns the first row.
> >>> Seems
> >>> > like it totally ignores the tilde.
>
> >>> > The same command when used on GAE gives me the first row,rather than
> >>> the
> >>> > last one.
>
> >>> > Thanks
> >>> > Vivek
>
> >>> > On Thu, Sep 9, 2010 at 11:27 AM, Andrew Thompson <andre...@aktzero.com
> >>> >wrote:
>
> >>> > > On 9/9/2010 12:24 AM, b vivek wrote:
>
> >>> > > Hi I wanted to retrieve the latest data entered in a table and thus
> >>> used
> >>> > > the below syntax for data look up
>
> >>> > > homepage=db().select(db.homepage.ALL,orderby=~db.homepage.id
> >>> > > ,limitby=(0,1))
>
> >>> > > This is expected to retrieve the last row entered in the table
> >>> homepage .
> >>> > > While this works perfectly, it does not work on GAE. It would be
> >>> really
> >>> > > helpful, if someone could please help me with this..
>
> >>> > > While I'm not familiar with GAE, I can say for sure that you've not
> >>> > > provided enough information.
>
> >>> > > How does it "not work"?
>
> >>> > > For example, can you make any .select() work? If you remove the
> >>> orderby or
> >>> > > the limitby does it change how it doesn't work?
>
> >>> > > --
> >>> > > Andrew Thompsonhttp://aktzero.com/
>
>
