title: insert into sqlite table with unique column
body: <p>I'm inserting values into my table (from python code) as follows:</p>
  
  <pre><code>cur.execute("insert into t(a, b, c) values (?, ?, ?)", (a, b, c))
  </code></pre>
  
  <p>There is a <code>unique constraint</code> on column c. What is a common way of <code>insert</code> if I want to cover the case when we're inserting duplicate value for c column?<br>
  I have some ideas</p>
  
  <ol>
  <li>select everything from t to list and test before inserting if the value is already present</li>
  <li>try-catch block</li>
  <li>some more sophisticated sqlite statement</li>
  </ol>
  
  <p>How would you test it?</p>
  
  <p>thank you</p>