maemo.org - Talk - View Single Post - is there a way to read SMS's via wifi thru SSH?

	bingomion	2012-08-03 , 14:37
	Posts: 528 \| Thanked: 345 times \| Joined on Aug 2010 @ MLB.AU	#5

Originally Posted by sakya

You can read the sqlite database:
Code:
sqlite3 /home/user/.rtcom-eventlogger/el-v1.db "Select remote_uid,
 free_text, outgoing, is_read, storage_time from Events where service_id=3 and e
vent_type_id=11 order by storage_time asc"
if you want to read only incoming messages add
Code:
 and outgoing=0
to the where condition

Thanks for the info, exactly what i was looking for!

I had to clear my unread messages: sqlite3 /home/user/.rtcom-eventlogger/el-v1.db "update Events set is_read=1 where is_read=0"

I can now make it speak unread messages to me:
sqlite3 /home/user/.rtcom-eventlogger/el-v1.db "Select free_text from Events where is_read=0 order by storage_time desc" | espeak

I was looking at using the power button replacing 'swipe to unlock' screen with a script to run this but all i can find is talk about mod'ing the unlock screen

I drive listening to podcasts/mp3/etc and when i get a message i want to click an external button (vol/power/camera) and have it read to me.

I don't like reading sms/skype while driving.. this would help out heaps!

EDIT: Harder then I thought

Last edited by bingomion; 2012-08-04 at 03:08.

Quote & Reply |

The Following 2 Users Say Thank You to bingomion For This Useful Post:
reinob, rotoflex