Automagic Forum

Hi,

Is it possible to do a sql query and do somthing with the result of it?

Thanks in advance...

Hi,

You can use action Query Content Provider to execute some basic queries against the content providers that are available to Automagic. The action includes a few examples for calendar and contacts.
You could also use sqlite to directly query the database with Execute Root Command with a command like sqlite3 /data/data/com.android.providers.calendar/databases/calendar.db "SELECT xyz FROM Calendars WHERE ...". sqlite has to be available on the device.

Regards,
Martin

Hi.
root commands doesn't work anymore on samsung upgraded to lollipop. Example:sqlite3 /data/databases/com.galaxytone.tarot.illuminati/databases/tarot.db "SELECT reverse FROM card_of_day WHERE day= {getDate(),dateformat,D} AND year = {getDate(),dateformat,yyyy}" return an error:error: only position independent executables (PIE) are supported.
Is there a way to make this work?
Regards, Jarle

Found a solution.
Copied the sqlite3 file from the Titanium backup app into xbin.
Jarle