Google Groups

Re: sqlite3: insert multiple values


Edward Ruggeri Jan 26, 2012 10:22 AM
Posted in group: Korma
Let me know what I can do to possibly merge this upstream.

-- Ned Ruggeri

On Jan 20, 3:34 pm, Edward Ruggeri <rugg...@self-loop.com> wrote:
> I wrote a patch to handle this.  Not the prettiest, but seems to work.
>
> -- Ned Ruggeri
>
> On Jan 20, 1:37 pm, Edward Ruggeri <rugg...@self-loop.com> wrote:
>
>
>
>
>
>
>
> > sqlite doesn't allow multiple values to be inserted in the usual way:
> > (http://stackoverflow.com/questions/1609637/is-it-possible-to-insert-
> > multiple-rows-at-a-time-in-an-sqlite-database).
>
> > Korma generates the usual SQL, with predictable results when trying to
> > insert multiple values to a sqlite db: SQLException.  It might be nice
> > if Korma noticed sqlite and generated something it could handle.
>
> > In the meantime, I decided to use postgres.
>
> > -- Ned Ruggeri