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

[ParserFactory] Ability to handle CREATE TRIGGER multi semicolons #7

Open
DamianSuess opened this issue Aug 15, 2020 · 1 comment
Open
Labels
help wanted Extra attention is needed story Product backlog item

Comments

@DamianSuess
Copy link
Collaborator

As a user, I would like to be able to use the CREATE TRIGGER statement which can contain multiple semicolons. ParserFactory currently splits in the semicolon as a delimited to differentiate between each query. Add support for BEGIN and END; statements.

@DamianSuess DamianSuess added help wanted Extra attention is needed story Product backlog item labels Aug 15, 2020
@DamianSuess
Copy link
Collaborator Author

DamianSuess commented Aug 15, 2020

Note, avoid delimiting via GO statement. As this would not be optimal and it is not a Sqlite command.

// split script on GO command
System.Collections.Generic.IEnumerable<string> commandStrings = Regex.Split(script, @"^\s*GO\s*$",
  RegexOptions.Multiline | RegexOptions.IgnoreCase);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
help wanted Extra attention is needed story Product backlog item
Projects
None yet
Development

No branches or pull requests

1 participant