format part of python string

Question

I'm using python 2.7 I'm writing some query in python

q = '''
select * from users where user_name = %(user_name)s and  user_email = %(user_email)s
'''

I want to format the string in two step something like :

q2 = q % {'user_name':'david'}
q3 = q2 % {'user_email':'[email protected]'}

The example i wrote is not working. python throws KeyError is there any other option to perform those tasks?

That's not how you do databases in Python.

Ignacio Vazquez-Abrams
– Ignacio Vazquez-Abrams

2012-02-26 17:55:49 +00:00
Commented Feb 26, 2012 at 17:55 — Ignacio Vazquez-Abrams
– Ignacio Vazquez-Abrams, Commented Feb 26, 2012 at 17:55

Katriel · Accepted Answer · 2012-02-26 17:57:53Z

7

Use a proper database API.

That said, if you know which keys will be omitted in the first pass, you can do:

>>> "%(a)s and %%(b)s" % {'a': 1}
'1 and %(b)s'
>>> _ % {'b': 2}
'1 and 2'

answered Feb 26, 2012 at 17:57

Katriel

124k19 gold badges141 silver badges172 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Idok Over a year ago

This trick is cool. I'm using the Database API for most of the variables. i'm using it with sense, but thanks for the advice

Wojtek · Accepted Answer · 2012-03-20 10:19:16Z

4

Thanks for your answer @katrielalex. I've been trying to do something similar using the string .format() method (python2.6+). Your answer guided me to come up with the following.

>>> s="{a} and {{b}}"
'{a} and {{b}}'
>>> s.format( a = 1 )
'1 and {b}'
>>> _.format( b = 2 )
'1 and 2'

I hope it helps all of those who want to use the new functionality.

answered Mar 20, 2012 at 10:19

Wojtek

4654 silver badges16 bronze badges

Collectives™ on Stack Overflow

format part of python string

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related