search

db-migrate / db-migrate-base

Base driver for db-migrate
Other
7 stars 16 forks source link

Insert generates invalid SQL when multiple rows and values passed #26

Open balint-balku-scraperapi opened 3 years ago

balint-balku-scraperapi commented 3 years ago

insert generates invalid SQL statement when used to fill multiple columns:

db.insert('table',
  [ 'column1', 'column2' ],
  [ [ 'data11', 'data21' ], [ 'data12', 'data22' ] ]
);

delimiters are not added properly so in the final statement parts of the real data get sliced, ending up in statements like this:

INSERT INTO "table" ("column1","column2") VALUES ('data11''data21),('data12''data22);