[Tutor] sqlite3 lists to database conversion/ using python variables in sqlite3

[शंतनू (Shantanoo)]

On Wed, Nov 19, 2008 at 4:48 PM, amit sethi <amit.pureenergy at gmail.com>
wrote:
> Hi , i am trying to learn python and this is my first time with any
> databases . I am using sqlite3 to create a database of my music files and
> its
> metadata tags so here is what i wanted to do . Two list one of the
> attributes and one of their values ,how do i put it in the database.Here
is
> a simple code i think should work but isn't?
>>>> import sqlite3
>>>> conn=sqlite3.connect('/tmp/example2')
>>>> c = conn.cursor()
>
>>>> list1=['hello','hi']
>>>> list2=['a','b']
>>>>c.execute('''create table ABC(hello text,hi text)''')
>>>> list1_value= ",".join(list1)
>>>> list2_value= ",".join(list2)
>>>> c.execute('''insert into ABC (%s) values
>>>> (%s)''')%(list1_value,list2_value)

You may try:
c.execute("insert into ABC(%s) values('%s')" % (list1_value, list2_value))

regards,
shantanoo
-- 

Fred Allen  - "An associate producer is the only guy in Hollywood who will
associate with a producer."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20081119/6b8f18cf/attachment.htm>