Tasker SQLite Plugin

The easier way to query databases with Tasker, now with the ability to create your own databases! No need to hunt for a SQLite binary that is compatible with your phone. Simply add the Tasker SQLite Plugin step to a Tasker task, input the path to the database and your sql statement, and execute.

========== Return Variables ==========

For INSERT statements with columns specified i.e. INSERT INTO tTableName(colX, colY) VALUES (valX, valY):

%dbrowid = the row id of the newly inserted row

For SELECT statments:

%dbreturn = the output of the sql statement in the same way as the sqlite binary (columns separated by pipes and rows separated by new lines) so it can be dropped in without any other changes to existing SQLite tasks.

%dbreturncount = the number of rows returned

%dbrows() = an array of rows so you don't have to split %dbreturn by the new line character

%db[column_name_lower_case]() = an array of values for each column (replace [column_name_lower_case] with the actual name of the column)

This app is currently in beta. Please report any issues via email.

Root is required to access other app's databases.

</div> <div jsname="WJz9Hc" style="display:none">更简单的方法来查询数据库与塔斯克，现在来创建自己的数据库的能力！无需去寻找一个SQLite二进制与您的手机兼容。只需将塔斯克SQLite的插件一步添加到塔斯克任务，输入数据库路径和你的SQL语句，并执行。

==========返回变量==========

对于列INSERT语句中指定即INSERT INTO tTableName（COLX，科利）VALUES（valX，VALY）：

％dbrowid =新插入的行的行ID

对于SELECT statments：

％dbreturn =的SQL语句以同样的方式输出为SQLite的二进制文件（通过管道和以换行分隔行分隔的列），所以它可以在没有任何其他改变现有的SQLite任务被丢弃。

％dbreturncount =返回的行数

％dbrows（）=行的一组，所以你不必通过新行字符分割％dbreturn

％分贝[column_name_lower_case]（）=值的每一列数组（与柱的实际名称替换[column_name_lower_case]）

这个程序目前处于测试阶段。请通过电子邮件报告任何问题。

根需要访问其他应用程序的数据库。</div> <div class="show-more-end">