Any other way to import data files(like .csv) in python sqlite3 module ? [not insert one by one]
Question: In sqlite3's client CLI, there is " .import file TABLE_name " to do it.

But, I do not want to install sqlite3 to my server at present.

In python sqlite3 module, we can creat and edit a DB.

But, I have not found a way to import data-file to a TABLE, except inserting
rows one by one.

Any other way?


Answer: You could insert at one shot using
[executemany](http://docs.python.org/library/sqlite3.html#using-shortcut-
methods) command instead of inserting one by one

Lets say I have users.csv with following contents

    
    
    "Hugo","Boss"
    "Calvin","Klein"
    

and basically open with csv module and pass it to .executemany function

    
    
    import csv,sqlite3
    
    persons= csv.reader(open("users.csv"))
    con = sqlite3.connect(":memory:")
    
    con.execute("create table person(firstname, lastname)")
    con.executemany("insert into person(firstname, lastname) values (?, ?)", persons)
    
    for row in con.execute("select firstname, lastname from person"):
        print row
    
    #(u'Hugo', u'Boss')
    #(u'Calvin', u'Klein')
    

