title: python sqlite3 .executemany() with named placeholders?
body: <p>This works:</p>
  
  <pre><code>ss = 'insert into images (file_path) values(?);'
  dddd = (('dd1',), ('dd2',))
  conn.executemany(ss, dddd)
  </code></pre>
  
  <p>However this does not:</p>
  
  <pre><code>s = 'insert into images (file_path) values (:v)'
  ddddd = ({':v': 'dd11'}, {':v': 'dd22'})
  conn.executemany(s, ddddd)
  Traceback (most recent call last):
    File "/Users/Wes/.virtualenvs/ppyy/lib/python2.7/site-packages/IPython/core/interactiveshell.py", line 3035, in run_code
      exec(code_obj, self.user_global_ns, self.user_ns)
    File "&lt;ipython-input-31-a999de59f73b&gt;", line 1, in &lt;module&gt;
      conn.executemany(s, ddddd)
  ProgrammingError: You did not supply a value for binding 1.
  </code></pre>
  
  <p>I am wondering if it is possible to use named parameters with executemany and, if so, how. </p>
  
  <p>The <a href="https://docs.python.org/2/library/sqlite3.html#cursor-objects" rel="nofollow noreferrer">documentation</a> at section 11.13.3 talks generally about parameters but doesn't discuss the two styles of parameters that are described for other flavors of  .executexxx().</p>
  
  <p>I have checked out <a href="https://stackoverflow.com/questions/10246542/python-sqlite3-execute-with-both-named-and-qmark-parameters">Python sqlite3 execute with both named and qmark parameters</a> which does not pertain to executemany.</p>