title: Python SQLITE3 Insert into and On conflict do update with variables - Syntax problem?
body: <p>I am running this code in a method that is called in a for loop and passing to it 'text_body':</p>
  <pre><code>*connecting to db*
  
  cursor.execute('CREATE TABLE IF NOT EXISTS temp_data (temp_text_body text, id integer)')
  
  cursor.execute('INSERT INTO temp_data(temp_text_body, id) VALUES (?, 1) ON CONFLICT (id) DO UPDATE '
                 'SET temp_text_body = temp_text_body || (?)', (text_body, text_body))
  
  *commiting connection*
  </code></pre>
  <p>My goal is to, on first time this is called to create a table and fill it with 'text_body', then on a second call add to the first 'text_body' second 'text_body' and so on.</p>
  <p>I tried many combinations of this code, I was also trying to do it with UPDATE (and it was fine but UPDATE needs some data to actually start working).</p>
  <p>When my code comes to this places it's just stop running, no error no anything. Could some please let me know where I made a mistake?</p>