Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

invalid multi queries error raised in .execute(), improper checking for ; #121

Open
gijzelaerr opened this issue Jan 22, 2021 · 0 comments
Assignees
Milestone

Comments

@gijzelaerr
Copy link
Collaborator

gijzelaerr commented Jan 22, 2021

calling .execute() with

INSERT INTO “voc.voyages” VALUES (125, ‘’, 2, ‘’, ‘HOLLANDIA’, ‘Simon Jansz. Hoen’, 800, NULL, NULL, NULL, NULL, ‘A’, ‘A’, ‘1607-12-22’, ‘Texel’, NULL, NULL, true, ‘1608-09-18’, ‘Goa’, 5097, ‘illemsz. Verhoeff aboard the GEUNIEERDE PROVINCIEN and vice-adm. Frans Hendriksz. Wittert aboard the MIDDELBURG. The 3 Zeeland ships and the mainfleet met at Maio I. February 1608; from 15-05 till 02-06 at St. Helena; 28-06 somewhere in the regions off the Cape; from 28-06 till 23-08 the fleet started operations against the Portuguese at Mozambique; from 18-09 till 02-10 off Goa.’);

gives a a Multiple queries in one execute() call error.

The string constants should be parsed for embedded non-espaced quotes.

@gijzelaerr gijzelaerr self-assigned this Jan 22, 2021
@gijzelaerr gijzelaerr modified the milestones: 0.10, 0.11 Apr 9, 2021
@gijzelaerr gijzelaerr modified the milestones: 0.11, 0.12 Apr 30, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant