Mysql query

Post your questions and help other users.

Moderator: Martin

Post Reply
fiets
Posts: 19
Joined: 23 May 2013 11:06

Mysql query

Post by fiets » 30 Sep 2014 09:29

Hi,

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

Thanks in advance...

User avatar
Martin
Posts: 4468
Joined: 09 Nov 2012 14:23

Re: Mysql query

Post by Martin » 01 Oct 2014 09:40

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
Posts: 10
Joined: 19 Jun 2013 17:48

Re: Mysql query

Post by jarlerb » 09 Jul 2015 17:27

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
Posts: 10
Joined: 19 Jun 2013 17:48

Re: Mysql query

Post by jarlerb » 11 Jul 2015 23:46

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

Post Reply