Conflict resolution in Android's SQLiteDatabase

Question

How does Android's SQLite library resolve conflicts if I insert duplicate rows? I am building my app for API level 7, which unfortunately does not have the SQLiteDatabase.insertOnConflict() method that was included starting in API level 8.

Answer 1

You can specify a UNIQUE index in the table definition which will allow rows to be REPLACED:

CREATE TABLE mytable (
  id  INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT NOT NULL,
  UNIQUE (id) ON CONFLICT REPLACE
)

If a row an INSERT or UPDATE statement tries to add a row with an id which already exists, the existing row is replaced with the new one.

Answer 2

There's a ON CONFLICT clause in SQLite that you can say INSERT INTO ... ON CONFLICT....

Read the documentation please. http://www.sqlite.org/lang_conflict.html