Export entire trend log database once

[spyder]

Dear experts,

I would like to export the entire trend log in a csv file once.

However, I wonder what would be the easiest solution?
1) using the visual interface - I can only seem to select 1 day or 1 week and then export every single day manually?
2) using a script with trend log function - how can I run a script once? e.g. https://forum.logicmachine.net/showthread.php?tid=313
3) using a call to /scada-main/trends/fetch to get json
4) using a script with direct db export db:getall('SELECT * FROM trends ORDER BY name DESC') - is this possible?

What would be the easiest to get all the data with the highest resolution?

Thanks,

Kristof

[admin]

You can get a list of all trends via a db request, then you can call fetch:

Code:

require('trends')
names = db:getlist('SELECT name FROM trends')

dates = {}
dates['start'] = os.date('*t')
dates['start'].year = dates['start'].year - 1
dates['end'] = os.date('*t')

for _, name in ipairs(names) do
  data = trends.fetch(name, dates)
end