This may work on sqlite but I am not sure. Anyway it is not portable. It
should be possible to use .epoch()
import time
query = (db.status.updated_on.epoch() + db.status.interval_time*60) <
time.time()
On Wednesday, 14 November 2012 11:17:40 UTC-6, Paolo Caruccio wrote:
>
> Please try:
>
> query = Expression(db,"interval_time < (strftime('%M','now') -
> strftime('%M', updated_on))")
>
> On the page suggested by Niphlod we read:
>
> Compute the number of seconds between two dates:
> SELECT strftime('%s','now') - strftime('%s','2004-01-01 02:34:56');
>
> So by replacing '%s' with '%M' we obtain the difference in minutes between
> two dates.
>
>
> Il giorno mercoledì 14 novembre 2012 12:13:03 UTC+1, Amit ha scritto:
>>
>> 100% correct :) , now facing problem of replacing the query with sqlite
>> compatible query :
>>
>> MySql query were:
>>
>> *query = Expression(db,"date_sub(now(),interval interval_time minute) >
>> updated_on")*
>>
>> where interval_time field is integer field which will be considered to
>> take interval in minutes for e.g. if user wants to save the interval time
>> is 1 hour then he has to enter it in minutes means 60 minutes.
>>
>> Now problem is when i tried to replace the above query with sqlite
>> compitible query like below and pass to the db to get the required records:
>>
>> *query = Expression(db,"date('now','-interval_time minutes') >
>> updated_on")*
>>
>> it returns nothing.
>> So can you please help me out write the above query in Sqlite.
>>
>> Thanks,
>> Amit
>>
>>
>>
>> On Wed, Nov 14, 2012 at 3:36 PM, Niphlod <[email protected]> wrote:
>>
>>>
>>> Il giorno mercoledì 14 novembre 2012 09:51:43 UTC+1, Amit ha scritto:
>>>
>>>> Hi,
>>>> I am getting error
>>>> *<class 'sqlite3.OperationalError'> near "interval_time": syntax error*
>>>>
>>>
>>> syntax error points to something around "interval_time"...... my bet is
>>> on date_sub() not supported by sqlite
>>>
>>> http://www.sqlite.org/cvstrac/wiki/wiki?p=DateAndTimeFunctions
>>>
>>>
>>> --
>>>
>>>
>>>
>>>
>>
>>
--
