sqlite python insert

Question

I have asked similar question before , here is detailed explanation of what i'm trying to achieve

I have two sqlite tables
table1 - is standard table - has fields like server,id,status table2 - has fields like server,id,status,number,logfile

Table2 is empty and Table1 has values. I'm trying to fill table2 with entries from table1. I can retrieve records from table1 ,but while trying to insert into table2 it fails.(but inserting a single field works)

self.cursor.execute("select * from server_table1 limit (?)",t)
#insert into server_process

for record in self.server_pool_list:
    print "--->",record # geting output like ---> (u'cloud_sys1', u'free', u'192.168.1.111')
    self.cursor.execute("insert into server_table2(server,status,id) values (?,?,?)",(record[0],)(record[1],),(record[2],));

And also let me know how to produce more useful error messages when insert fails

Yes..thanks I solved it . I should have used this (?,?,?"),(record[0],record[1],record[2],) instead of above ... Now it's working :) — webminal.org
– webminal.org, Commented Jan 25, 2010 at 6:48

Omnifarious · Accepted Answer · 2010-01-25 07:01:49Z

3

This statement is broken:

self.cursor.execute("insert into server_table2(server,status,id) values (?,?,?)",(record[0],)(record[1],),(record[2],));

it should read:

self.cursor.execute("insert into server_table2(server,status,id) values (?,?,?)",record[0:2])

And you might want to look into executemany as I think it could save you a ton of time.

answered Jan 25, 2010 at 7:01

Omnifarious

56.4k20 gold badges142 silver badges203 bronze badges

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

Collectives™ on Stack Overflow

sqlite python insert

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related