Robin,
I do not know how to run the gql tests. Can you explain?
Anyway, I checked it with this code
db.define_table('birth',db.Field('day','datetime'))
def index():
db.birth.insert(day=request.now)
return PRE(str(db(db.birth.day<request.now).select()))
The problem exists. It has nothing do to with obj_represent (I tried
to revert and the problem is still there).
The problem happens with datetime but not string. The problem does not
show up in SQLDB, only GQLDB.
I tried to track it down but to me this looks like a GAE bug.
If not, only Robin can fix this.
Massimo
On Feb 26, 10:48 pm, Robin B <robi...@gmail.com> wrote:
> The obj_represent/datetime code was modified after 1.56.2. I would
> check if this problem is present in 1.56.2 and if the gql.py doctests
> still pass on trunk.
>
> Robin
>
> On Feb 26, 10:21 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > I missed the part where you said this problem was on GAE.
>
> > Robin? Do you have anything to say about this?
>
> > Massimo
>
> > On Feb 26, 8:03 am, "Sebastian E. Ovide" <sebastianov...@gmail.com>
> > wrote:
>
> > > yes I'm sure... it is the 1.56.4...
>
> > > with logging.debug(db(db.message.created_on<request.now)._select())
>
> > > I get
>
> > > DEBUG 2009-02-26 13:59:05,926 default.py]
> > > (<google.appengine.ext.db.Query
> > > object at 0x9b40dac>, 'message', ['id', 'subject', 'body', 'from_user',
> > > 'from_cas_user_id', 'to_user', 'to_cas_user_id', 'read', 'created_on'])
>
> > > On Thu, Feb 26, 2009 at 5:13 AM, mdipierro <mdipie...@cs.depaul.edu>
> > > wrote:
>
> > > > btw. It works fine for me. Are you sure you did not accidentally edit
> > > > the sql.py file?
>
> > > > Massimo
>
> > > > On Feb 25, 11:29 pm, "Sebastian E. Ovide" <sebastianov...@gmail.com>
> > > > wrote:
> > > > > Hi All,
>
> > > > > I have a model like this:
>
> > > > > db.define_table('message_sent',
> > > > > ...
> > > > > ...),
> > > > > SQLField('created_on','datetime',
> > > > > readable=False,
> > > > > writable=False,
> > > > > default=request.now),
> > > > > )
>
> > > > > so any query like db(db.message_sent.created_on<request.now).select()
> > > > should
> > > > > return everyting... as request,now is less than created_on ...
>
> > > > > instead it returns nothing... if I use the inequality filter >
> > > > > (greater
> > > > > than) it returns the whole table.
>
> > > > > any ideas ? is this a web2py bug?
>
> > > > > (for example with request.now equal to 2009-02-26 05:26:53.356458 I
> > > > > get
> > > > > records with 2009-02-26 02:25:38.951329.... it is less than... not
> > > > > bigger!!!!)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@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
-~----------~----~----~----~------~----~------~--~---
