search

snapperben / gulp-mysql-command-file-processor

This a gulp npm module that allows DDL sql files to be run into a MySql server as part of a controlled release
8 stars 4 forks source link

Change Stored Procedure handling and added new options #16

Open snapperben opened 7 years ago

snapperben commented 7 years ago

When submitting a stored procedure the delimiter statement potentially needs to be handled diffrently

snapperben commented 6 years ago

Thanks for having a look. I can't think of any unit tests other than testing the connection (that wouldn't really do anything more than running in an actual command file would) or providing sample SQL code (which wouldn't do anything other than show that the test SQL runs)

snapperben commented 6 years ago

The charParser was to get the stored procedure delimiter commands to work. What might be useful is to provide some sample SQL to test the range of different comments that it should now cope with. I'll have a go at that in the next few weeks. The latest version can be installed as gulp-mysql-command-file-processor@beta

wilwang commented 6 years ago

Yup, I think sample SQL to test the range of different comments is perfect for "unit test" cases.