SQLite for Automagic

Share and discuss your flows and ideas with other users.

Moderator: Martin

VitPMir
Posts: 12
Joined: 18 Oct 2018 17:09

Re: SQLite for Automagic

Post by VitPMir » 31 Jan 2020 18:54

fagci wrote:
31 Jan 2020 18:40
Sorry, but in every Android phone sqlite3 console utility exists. So, no need to write more code instead of SQL
Not all phones have sqlite3. I do not have (Mi Max 2). And to install this utility you need root.

anuraag
Posts: 371
Joined: 24 Jan 2015 02:06

Re: SQLite for Automagic

Post by anuraag » 31 Jan 2020 23:33

VitPMir's method is better. I have been playing with the code and it's going well. I am using query instead of rawQuery in my flow.

This code can be used to close database.

Code: Select all

callJavaMethod(objDb, "android.database.sqlite.SQLiteDatabase", "close()");

VitPMir
Posts: 12
Joined: 18 Oct 2018 17:09

Re: SQLite for Automagic

Post by VitPMir » 01 Feb 2020 04:57

anuraag wrote:
31 Jan 2020 23:33

This code can be used to close database.
Thanks.

User avatar
fagci
Posts: 80
Joined: 03 Feb 2017 13:06
Location: Novosibirsk, RU
Contact:

Re: SQLite for Automagic

Post by fagci » 01 Feb 2020 21:41

VitPMir wrote:
31 Jan 2020 18:54
Not all phones have sqlite3.
Maybe that is without custom ROM. I always flash new smartphone, coz stock is bad for me. ㄟ(ツ)ㄏ
All systems nominal.

User avatar
Desmanto
Posts: 2709
Joined: 21 Jul 2017 17:50

Re: SQLite for Automagic

Post by Desmanto » 05 Feb 2020 18:31

Mine is RN5 with AEX 6.7 Pie 9.0 ROM, and I have sqlite3 binary here. I just found out that adb shell also have the sqlite3 binary baked in. But of course it is useless as we need PC to work with.
Index of Automagic useful thread List of my other useful posts (and others')
Xiaomi Redmi Note 5 (whyred), AOSP Extended v6.7 build 20200310 Official, Android Pie 9.0, Rooted.

Post Reply