todoroo/astrid — pull request #202 by StingerAJ (2012-10-02 21:17:26+00:00)
Title: Aj taskswidget manual order and SQLMaid

This version supports showing subtasks with maual ordering in free TasksWidget.
I found a bug with starting the initially selected fragment and not the currently needed when pressing the widget (e.g. TagViewFragment for alphabetically ordered tasks when the widget was created for a SubTasksViewFragment for manually ordered). This will be tackled in another commit.

The 2nd commit is to use SQLBride to connect a JDBC-capable DB-tool to run SQL-queries against a live database on-device (as described here: http://www.peculiarcat.com/?p=151).
I needed this to actually figure out why the SQL-query for subtasks wasn't restricting access to the current list.

To get this working, you have to install SQLBride on your development-device prior to the deployment of this Astrid-version.

The SQLBride-App is supported from Android 2.3 upwards and can be installed from here: https://play.google.com/store/apps/details?id=com.peculiarcat.sqlbride

A rooted device is not necessary due to use of SQLMaid-integration (rooted access to arbitrary databases is disabled in current playstore despite the description, hence this commit).

You might need to start SQLBride once and then Astrid once. If you have connection-problems try the USB-cable method (it is supposed to be faster) and restart adb-server (fixed it for me).

As for DB-tools, I use SQuirreL and it is working fine.