title: sqlite3 not flushing table
body: <pre><code>conn = sqlite3.connect('./mydb.db')
  c = conn.cursor()
  with open('./mydb_tmp.sql', 'w') as f:
      for row in c.execute('SELECT * FROM FLOWS'):
          print &gt;&gt;f, row
  c.execute('DELETE FROM FLOWS;')
  conn.close()
  </code></pre>
  
  <p>After that, all rows are still in mydb</p>