tree 693b82f1fd698af63e38e932c8df5a23ec2eb1b0
parent 0ae655fdae5359098723da013be68ac65dc58941
author Jeff Sharkey <jsharkey@android.com> 1531773261 -0600
committer Jeff Sharkey <jsharkey@google.com> 1543710184 -0700

Add support for appending standalone phrases.

When users are building queries, they often need to append several
standalone SQL clauses, and it's tedious to track their first clause
so they can manually append " AND " to each subsequent clause.

So add new appendWherePhrase() API which appends a standalone phrase
which is AND'ed together with any existing WHERE query.

Also fix bug in update() which would turn null values into the
string literal "null" instead of passing them through as SQL NULL.

Test: atest cts/tests/tests/database/src/android/database/sqlite/cts/SQLiteQueryBuilderTest.java
Bug: 111085900
Merged-In: Ia280dd864895654239503e080eaef925f5620d37
Change-Id: Ia280dd864895654239503e080eaef925f5620d37