How to insert multiple rows in SQLite Dbase
afandimscit at gmail.com
Mon Apr 21 13:10:39 CEST 2008
On Apr 1, 12:22 am, afandi <afandims... at gmail.com> wrote:
> On Mar 30, 4:46 am, Gerhard Häring <g... at ghaering.de> wrote:
> > Gabriel Genellina wrote:
> > > [...]
> > > and execute:
> > > cur.executemany("insert into log (IP, EntryDate, Requestt, ErrorCode)
> > > values (:ip, :date, :request, :errorcode)", values)
> > It's probably worth mentioning that pysqlite's executemany() accepts
> > anything iterable for its parameter. So you don't need to build a list
> > beforehand to enjoy the performance boost of executemany().
> > The deluxe version with generators could look like this:
> > def parse_logfile():
> > logf = open(...)
> > for line in logf:
> > if ...:
> > row = (value1, value2, value3)
> > yield row
> > logf.close()
> > ...
> > cur.executemany("insert into ... values (c1, c2, c3)", parse_logfile())
> > -- Gerhard
> > PS: pysqlite internally has a statement cache since verson 2.2, so
> >multipleexecute() calls are almost as fast as executemany().
> Thanks regards to your suggestion, but I don't understand why we have
> to put the IF statement?
I have the solution.Thanks
split it using REgex to   
parse to Database
More information about the Python-list