Hi Niclas,
I tried your remomendations.
data = myData.all().filter("mytype=", type)
is returning all the correct that. as soon as i add:
.filter("pubdate >", startDate)
it starts going wrong.
I also changed:
endDate = datetime.datetime.today() //so it is a datetime instead
of date
It seems that the date filter is not working very well.
I checked all the data in dataviewer, and its fine. For some reason i
get errors randomly when queriing in dataviewer,even if the syntaxis
is correct.
When I execute this query:
SELECT * FROM myData WHERE type = '1' ORDER BY pubdate DESC
I dont see the date after going trough all the pages in dataViewer.
But if I search for this:
SELECT * FROM myData WHERE type = '1'
I see the result for the missing date in the first page of dataViewer.
I went inside the entity that was missing, clicked on Save Entity, and
now its appearing under my filtered searches.
What do you suggest? My data was uploaded using the google bulkload
python script, and it run successfully with no errors.
Thanks,
ben
On Apr 7, 4:18 pm, niklas <[email protected]> wrote:
> On 6 Apr, 20:47, Benjamin Ortuzar <[email protected]> wrote:
>
>
>
> > Hi gents,
>
> > Im trying to search for some codes within a date range, but some dates
> > that exist in the database are not being returned by the query. Here
> > is an extract of the code in using.
>
> > deltaDays = timedelta(days= 10)
> > endDate = datetime.date.today()
> > startDate = endDate - deltaDays
>
> > result = db.GqlQuery(
> > "SELECT * FROM myData WHERE mytype = :1 AND pubdate>= :2
> > and pubdate <= :3", type, startDate, endDate
>
> > )
>
> > class myData(db.Model):
> > mytype = db.StringProperty(required=True)
> > value = db.FloatProperty(required=True)
> > pubdate = db.DateTimeProperty(required=True)
>
> > The script returns :
>
> > 2009-03-18 00:00:00
> > (missing date in results: 2009-03-20 data exists in database)
> > 2009-03-23 00:00:00
> > 2009-03-24 00:00:00
> > 2009-03-25 00:00:00
> > 2009-03-26 00:00:00
> > (missing date in results: 2009-03-27 data exists in database)
> > 2009-03-30 00:00:00
> > (missing date in results: 2009-03-31. data exists in database)
> > 2009-04-01 00:00:00
> > 2009-04-02 00:00:00
> > 2009-04-03 00:00:00
> > 2009-04-06 00:00:00
>
> > Any help is appreciated. thanks.
>
> Hi Benjamin
> Try fetch the range in other ways with filter or DATETIME wrapper
> data = myData.all().filter("mytype=", type).filter("pubdate >",
> startDate)
> or
> result = db.GqlQuery("SELECT * FROM myData WHERE mytype = :1 AND
> pubdate >= DATETIME(2009,03,18)", type)
> or use dataviewer directly to see differences between rows.
> Regards
> Niklas
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google App Engine" 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/google-appengine?hl=en
-~----------~----~----~----~------~----~------~--~---
