Support view and triggers displaying

[mariotaku]

It would be nice if we can see views (content and creation statement), and triggers.

[reisub]

We'll see what we can do.
If you have an idea how to do it and the time to do it, feel free to open a pull request :)

[mariotaku]

no problem, I'll try :)

[reisub]

@mariotaku any luck with this?
@zplesac do you have an idea how to do this?

[zplesac]

@reisub @mariotaku Views and triggers are stored in sql_master database file. You can get them like this:

SELECT name, tbl_name FROM sqlite_master WHERE type='trigger';

SELECT sql FROM sqlite_master WHERE type = 'view';

I'll check if we can obtain them using raw SQL statements in Android code.