title: How to update row by row using python function in sqlite3?
body: <p>This question is duplicated I think, but I couldn't understand other answers...</p>
  
  <ol>
  <li>Original table looks like this.</li>
  </ol>
  
  <pre><code>NAME    AGE SMOKE
  John    25  None
  Alice   23  None
  Ken     26  None
  </code></pre>
  
  <ol start="2">
  <li><p>I will update <code>SMOKE</code> column in these rows,</p></li>
  <li><p>But <strong>I need to use output of function which was coded in python <code>check_smoke()</code>.</strong> If I input name to <code>check_smoke()</code>, then it returns <code>"Smoke"</code> or <code>"Not Smoke"</code>.</p></li>
  <li><p>So final table would look like below:</p></li>
  </ol>
  
  <pre><code>NAME    AGE SMOKE
  John    25  Smoke
  Alice   23  Not Smoke
  Ken     26  Not Smoke
  </code></pre>
  
  <p>I'm using sqlite3 and python3.
  How can I do it? Thank you for help!</p>