Mysql query

[fiets]

Hi,

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

Thanks in advance...

[Martin]

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

[jarlerb]

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

[jarlerb]

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