[SQLite] Support for UNIQUE conflict clauses

[monxalo]

Support for table UNIQUE conflict clauses would be nice, e.g.:

CREATE TABLE table_name
(
  _id INTEGER PRIMARY KEY AUTOINCREMENT,
  record_id INTEGER NOT NULL,
  ...
  , UNIQUE ( record_id ) ON CONFLICT REPLACE
)

ON CONFLICT clause:

• ROLLBACK
• ABORT
• FAIL
• IGNORE
• REPLACE

[jlandrum]

Isn't this already available?

https://github.com/Kotlin/anko/blob/master/anko/library/static/sqlite/src/sqlTypes.kt

[monxalo]

Yes, UNIQUE is already available. This is to support conflict clauses.

[monxalo]

A simpler version of the example can also be written like so:

CREATE TABLE table_name
(
  _id INTEGER PRIMARY KEY AUTOINCREMENT,
  record_id INTEGER NOT NULL UNIQUE ON CONFLICT REPLACE,
  ...
)