Insert only if timestamp is unoccupied

Question

I am using Android / Java and SQLite3 / SQLiteOpenHelper, with the Cursors and ContentValues.

I have a timestamp field in my table. I want to ensure that if someone is adding a new row, the row is not added if the timestamp is already occupied (so I do not want more than one value per timestamp).

Can this be enforced efficiently? Or do I have to perform a select statement every single time I perform an insertion to check first?

score 1 · Accepted Answer · answered May 09 '16 at 19:32

1

Add a UNIQUE qualifier on the timestamp field. You can then choose the behavior you want by calling inserWithOnConflict() and passing CONFLICT_FAIL as the conflict algorithm argument.

answered May 09 '16 at 19:32

Jeffrey Blattman

22,176
9
79
134

Does this mean any inserts that have the same timestamps are simply ignored or do they throw an error, etc? – The 29th Saltshaker May 09 '16 at 19:35
Take a look at the javadocs I linked. You can choose the behavior you want. `CONFLICT_FAIL` will cause an exception to be thrown, – Jeffrey Blattman May 09 '16 at 19:37
Oh sorry the post had been edited. I see it now. Thanks! Can accept in 5. – The 29th Saltshaker May 09 '16 at 19:38

Insert only if timestamp is unoccupied

1 Answers1