Android-AnnotatedSQL

Android-AnnotatedSQL copied to clipboard

Consider using beginTransactionNonExclusive when available

2

I have encountered a nasty deadlock during debugging some db-related code and traced it down to [this thread](http://sqlite.1065341.n5.nabble.com/Deadlock-with-multiple-connections-td69525.html). So, basically, SQLite is advertised as a multiple-readers-single-writer db, but does not...

Alexander--

Lib has an issue with support at least one sqlite aggregation function in @RawQuery

1

Steps to reprodice: 1. Define rawquery as SELECT AI._id, GROUP_CONCAT(Name, ", ") AS GroupedName FROM ABSTRACTS_ITEM AI JOIN AUTHORS_ABSTRACT AAB ON AI.ID = AAB.ABSTRACTSITEM_ID JOIN ABSTRACT_AUTHOR AAU ON AAU._id =...

Gelassen

Foreign keys support

1

Hi, Could you please add support of foreign keys feature?

Hensin

Fixes #15. Comments welcome.

Alexander--

Allow Unique constraint on multiple columns

1

Alexander--

Let's look at schema with [simple join on views](https://gist.github.com/Alexander--/80d263643d936f88ae4f). The linked gist won't compile, because using a Schema2 requires a table to be parsed... Which can not be done until...

Alexander--

Do not rename columns in generated JOINs unless necessary

3

Right now AnnotatedSQL mangles column names during joins by appending "as _table_name___column_name_" to each column in generated SELECT statement, e.g. ``` CREATE VIEW nearest as SELECT locations._id as _id, locations.coslat...

Alexander--

Triggers don't work with bulk inserts

2

Generated code fails to compile because of variable name mismatch.

Alexander--

Hi, Could you please add an option for bulk insert operation - to throw an exception on failure and rollback a transaction?

Hensin