maemo.org - Talk - View Single Post - SMS counter for N900?

nex	2010-01-29 , 22:22
Posts: 61 \| Thanked: 13 times \| Joined on Jan 2010	#15

I know it's probably not optimal, but what about a oneliner command for Desktop Execution Widget? Since that one already has its windowing and settings done. It could be added as a oneliner ie:

Code:

sqlite3 /home/user/.rtcom-eventlogger/el.db "select  CASE event_type_id WHEN 7 THEN 'In' WHEN 8 THEN 'Out' END, count(id) from Events where event_type_id in (7,8) AND strftime('%Y%m', storage_time, 'unixepoch') = strftime('%Y%m', 'now') group by strftime('%Y-%m', storage_time, 'unixepoch'), 1;"

This will give the in/out counts for the current month:
In|443
Out|104

Last edited by nex; 2010-01-29 at 22:26. Reason: explanation

Quote & Reply |

The Following 2 Users Say Thank You to nex For This Useful Post:
hartti, pcfe