[New-bugs-announce] [issue14619] Enhanced variable substitution for databases

Raymond Hettinger report at bugs.python.org
Thu Apr 19 07:14:55 CEST 2012

New submission from Raymond Hettinger <raymond.hettinger at gmail.com>:

I suggest adding a ?? placeholder for variable length substitutions in SQL statements:

vars = 'Knight', ('Gwain', 'Gallahad', 'Lancelot'), 30
c.execute('''SELECT * FROM loyalsubjects
             WHERE rank = ? 
             AND name IN (??)
             AND age >= ?
          ''', vars)

components: Extension Modules
messages: 158698
nosy: rhettinger
priority: low
severity: normal
status: open
title: Enhanced variable substitution for databases
type: enhancement
versions: Python 3.4

Python tracker <report at bugs.python.org>

More information about the New-bugs-announce mailing list