This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm that you accept these cookies being set.

Delete object logs from script
#12
(01.09.2021, 09:13)admin Wrote: Like this, you need to specify the min/max log time as UNIX timestamp:
Code:
id = buslib.encodega('1/1/1')
mintime = os.time() - 3600 * 2
maxtime = os.time() - 3600
db:query('DELETE FROM objectlog WHERE address=? AND logtime BETWEEN ? AND ?', id, mintime, maxtime)

thank you, admin
great 
where to learn about these query command?
like if I want it to be depend on value


db:query('DELETE FROM objectlog WHERE value<=0')

doese this work?
Best Regards,
Reply


Messages In This Thread
Delete object logs from script - by Mirco - 17.05.2017, 15:01
RE: Delete object logs from script - by Mirco - 18.05.2017, 06:11
RE: Delete object logs from script - by admin - 18.05.2017, 05:58
RE: Delete object logs from script - by admin - 18.05.2017, 07:38
RE: Delete object logs from script - by Mirco - 18.05.2017, 08:47
RE: Delete object logs from script - by admin - 26.07.2021, 10:16
RE: Delete object logs from script - by admin - 01.09.2021, 09:13
RE: Delete object logs from script - by khalil - 01.09.2021, 09:22
RE: Delete object logs from script - by admin - 01.09.2021, 12:08
RE: Delete object logs from script - by admin - 01.09.2021, 12:37

Forum Jump: