Delete object logs from script

[Mirco]

Hi, is there a way to delete all object logs from a script?

Thanks!

[buuuudzik]

Something like below:

Code:

db:delete('objectlog', { id > -1 })

[admin]

Code:

db:query('DELETE FROM objectlog')

[Mirco]

The istruction returns this error:

User script:35: attempt to compare number with nil
stack traceback:
User script:35: in main chunk

[admin]

Use the second code example, the first one is incorrect, though it can be used like this:

Code:

db:delete('objectlog')

[Mirco]

Thank you! 

[khalil]

Use the second code example, the first one is incorrect, though it can be used like this:

Code:

db:delete('objectlog')

Hello Admin
how to delete a specific object address logs?

[admin]

Use this:

Code:

id = buslib.encodega('1/1/1')
db:delete('objectlog', { address = id })

[khalil]

Use this:

Code:

id = buslib.encodega('1/1/1')
db:delete('objectlog', { address = id })

Thanks admin

[khalil]

Use this:

Code:

id = buslib.encodega('1/1/1')
db:delete('objectlog', { address = id })

hello admin
How to delete a specific period for a specific address
regards,

[admin]

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)

[khalil]

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?

[admin]

It's more complicated. Value is stored raw format so it has to be decoded before comparison.

Code:

obj = grp.find('1/1/1')
rows = db:getall('SELECT * FROM objectlog WHERE address=?', obj.id)

for _, row in ipairs(rows) do
  if row.datahex then
    value = busdatatype.decode(row.datahex, obj.datatype)

    if value <= 0 then
      db:delete('objectlog', { id = row.id })
    end
  end
end

[khalil]

It's more complicated. Value is stored raw format so it has to be decoded before comparison.

Code:

obj = grp.find('1/1/1')
rows = db:getall('SELECT * FROM objectlog WHERE address=?', obj.id)

for _, row in ipairs(rows) do
  if row.datahex then
    value = busdatatype.decode(row.datahex, obj.datatype)

    if value <= 0 then
      db:delete('objectlog', { id = row.id })
    end
  end
end

thank you admin
is it easy to make it in general (delete all obj. logs <=0)

[admin]

Try this:

Code:

rows = db:getall([[
  SELECT ol.id, ol.datahex, o.datatype
  FROM objectlog ol
  JOIN objects o ON ol.address=o.id
]])

for _, row in ipairs(rows) do
  if row.datahex then
    value = busdatatype.decode(row.datahex, row.datatype)

    if type(value) == 'number' and value <= 0 then
      db:delete('objectlog', { id = row.id })
    end
  end
end

[khalil]

Try this:

Code:

rows = db:getall([[
  SELECT ol.id, ol.datahex, o.datatype
  FROM objectlog ol
  JOIN objects o ON ol.address=o.id
]])

for _, row in ipairs(rows) do
  if row.datahex then
    value = busdatatype.decode(row.datahex, row.datatype)

    if type(value) == 'number' and value <= 0 then
      db:delete('objectlog', { id = row.id })
    end
  end
end

thank you very much 
appreciate your help