SQLite for Automagic

Share and discuss your flows and ideas with other users.

Moderator: Martin

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

SQLite for Automagic

Post by VitPMir » 20 Dec 2019 10:50

Sorry for my English. Used Google-translator
flow_group_SQLite_for_Automagic_20191220_143938.xml
(35.27 KiB) Downloaded 265 times
Fixed version here:
http://automagic4android.com/forum/view ... 776#p26751
Last edited by VitPMir on 26 Dec 2019 06:17, edited 2 times in total.

User avatar
jassing
Posts: 94
Joined: 16 Jul 2017 01:42
Location: SF Bay Area

Re: SQLite for Automagic

Post by jassing » 20 Dec 2019 12:59

Awesome work!

But... The insert routine does not work for me...

Great work, much appreciated!!

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

Re: SQLite for Automagic

Post by VitPMir » 20 Dec 2019 13:42

Corrected something
flow_group_SQLite_for_Automagic_20191220_173803.xml
(35.31 KiB) Downloaded 326 times

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

Re: SQLite for Automagic

Post by anuraag » 20 Dec 2019 15:02

Good effort.

I have already tested same java functions but problem here is database takes some minutes to close.

User avatar
jassing
Posts: 94
Joined: 16 Jul 2017 01:42
Location: SF Bay Area

Re: SQLite for Automagic

Post by jassing » 20 Dec 2019 19:24

VitPMir wrote:
20 Dec 2019 13:42
Corrected something
flow_group_SQLite_for_Automagic_20191220_173803.xml
Works perfectly here! Thank you for sharing your work!

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

Re: SQLite for Automagic

Post by VitPMir » 21 Dec 2019 06:59

anuraag wrote:
20 Dec 2019 15:02
Good effort.

I have already tested same java functions but problem here is database takes some minutes to close.
Renamed 'objDb' to 'global_objDb', opened the database.
After 12 hours, I performed INSERT. Everything worked.

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

Re: SQLite for Automagic

Post by anuraag » 21 Dec 2019 09:22

@VitPMir
Working perfectly. Can you give some reference where i can learn more about sQ or sWHERE Variables you used?

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

Re: SQLite for Automagic

Post by VitPMir » 21 Dec 2019 10:06

anuraag wrote:
21 Dec 2019 09:22
Can you give some reference where i can learn more about sQ or sWHERE Variables you used?
https://www.guru99.com/sqlite-query.html

https://www.sqlitetutorial.net

https://www.sqlite.org/lang_select.html

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

Re: SQLite for Automagic

Post by Desmanto » 21 Dec 2019 17:18

@VitPMir : That's Amazing. I should reverse engineer your flow to study it. Thanks.
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.

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

Re: SQLite for Automagic

Post by fagci » 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

Example: http://automagic4android.com/flow.php?i ... e616f2e3b5
All systems nominal.

Post Reply