Problem with SQLite executemany
        Posted  
        
            by Strider1066
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Strider1066
        
        
        
        Published on 2009-06-23T06:37:09Z
        Indexed on 
            2010/04/22
            0:03 UTC
        
        
        Read the original article
        Hit count: 283
        
I can't find my error in the following code. When it is run a type error is given for line: cur.executemany(sql % itr.next()) => 'function takes exactly 2 arguments (1 given),
import sqlite3
con = sqlite3.connect('test.sqlite')
cur = con.cursor()
cur.execute("create table IF NOT EXISTS fred (dat)")
def newSave(className, fields, objData):
    sets = []
    itr = iter(objData)
    if len(fields) == 1:
        sets.append( ':' + fields[0])
    else:
        for name in fields:
            sets.append( ':' +  name)
    if len(sets)== 1:
        colNames = sets[0]
    else:
        colNames = ', '.join(sets)
    sql = " '''insert into %s (%s) values(%%s)'''," % (className, colNames)
    print itr.next()
    cur.executemany(sql  % itr.next())
    con.commit()
if __name__=='__main__':
    newSave('fred', ['dat'], [{'dat':1}, {'dat':2}, { 'dat':3}, {'dat':4}])
I would appreciate your thoughts.
© Stack Overflow or respective owner