Thanks Niphold, its working as intended :)
On Mon, Jul 16, 2012 at 3:55 PM, Niphlod <[email protected]> wrote:
> Why write such a query when DAL allows you to use a more (portable,
> concise) pythonic way ?
>
> import datetime
> yesterday = request.now - datetime.timedelta(days=1)
> db(db.employee.created_on < yesterday).delete()
>
>
>
> On Monday, July 16, 2012 12:12:56 PM UTC+2, Amit wrote:
>>
>> Hi,
>> I have created table Employe with following fields:
>> db.define_table(
>> 'Employee',
>> Field('created_on','datetime', default=request.now),
>> Field('emp_id'),
>> Field('emp_age'),
>> Field('emp_address),
>> )
>> inserting data into the table is working fine but when i am trying to
>> delete data one day older using below command:
>>
>> db.executesql('DELETE FROM db.Employee WHERE created_on < date_sub(now(),
>> INTERVAL 1 DAY);')
>>
>> It's not working and i am not getting any error also, so can anybody help
>> me resolve this issue.
>> NOTE: I am using Sqlite database.
>>
>>
>>
--
