%% options copyright owner = Dirk Krause copyright year = 2015-xxxx license = bsd %% state machine [options] name = find_line_end write header = no [states] ST_START # Normal state ST_START_BS # Backslash found in normal state ST_SQ # In single quotes string ST_SQ_BS # In single quotes string after backslash ST_DQ # In double quotes string ST_DQ_BS # In double quotes string after back ST_BQ # In back-tick quoted string ST_BQ_BS # In back-tick quoted string after backslash ST_SL # Normal state after slash ST_SL_CO # In double slash comment ST_CO # In normal comment ST_CO_AST # In normal comment after asterisk ST_CLBR # In normal state after closing bracket ST_CLBRCO # In normal state after closing bracket and comma ST_ERROR # Undefined state [inputs] I_NL # Newline I_OPBR # Opening bracket I_CLBR # Closing bracket I_BS # Backslash I_SL # Slash I_AST # Asterisk I_SQ # Single quote I_DQ # Double quote I_BT # Backtick I_COMMA # Comma I_ANY # Anything else [outputs] O_NORMAL # Print character O_NL # Print newline and character [rules] * * ST_ERROR O_NORMAL ST_START I_SQ ST_SQ O_NORMAL ST_START I_DQ ST_DQ O_NORMAL ST_START I_BT ST_BQ O_NORMAL ST_START I_SL ST_SL O_NORMAL ST_START I_CLBR ST_CLBR O_NORMAL ST_START I_BS ST_START_BS O_NORMAL ST_START * ST_START O_NORMAL ST_START_BS * ST_START O_NORMAL ST_SQ I_SQ ST_START O_NORMAL ST_SQ I_BS ST_SQ_BS O_NORMAL ST_SQ * ST_SQ O_NORMAL ST_SQ_BS * ST_SQ O_NORMAL ST_DQ I_DQ ST_START O_NORMAL ST_DQ I_BS ST_DQ_BS O_NORMAL ST_DQ * ST_DQ O_NORMAL ST_DQ_BS * ST_DQ O_NORMAL ST_BQ I_BT ST_START O_NORMAL ST_BQ I_BS ST_BQ_BS O_NORMAL ST_BQ * ST_BQ O_NORMAL ST_BQ_BS * ST_BQ O_NORMAL ST_SL I_SL ST_SL_CO O_NORMAL ST_SL I_AST ST_CO O_NORMAL ST_SL * ST_START O_NORMAL ST_SL_CO I_NL ST_START O_NORMAL ST_SL_CO * ST_SL_CO O_NORMAL ST_CO I_AST ST_CO_AST O_NORMAL ST_CO * ST_CO O_NORMAL ST_CO_AST I_SL ST_START O_NORMAL ST_CO_AST I_AST ST_CO_AST O_NORMAL ST_CO_AST * ST_CO O_NORMAL ST_CLBR I_COMMA ST_CLBRCO O_NORMAL ST_CLBR I_CLBR ST_CLBR O_NORMAL ST_CLBR * ST_START O_NORMAL ST_CLBRCO I_OPBR ST_START O_NL ST_CLBRCO * ST_START O_NORMAL %% module /** @file dk-sqlsplit Program to split SQL lines. */ /* The help_text array below shows details. */ #include "dk4conf.h" #include #if DK4_HAVE_STDLIB_H #ifndef STDLIB_H_INCLUDED #include #define STDLIB_H_INCLUDED 1 #endif #endif #if DK4_HAVE_UNISTD_H #ifndef UNISTD_H_INCLUDED #include #define UNISTD_H_INCLUDED 1 #endif #endif #if DK4_HAVE_PROCESS_H #ifndef PROCESS_H_INCLUDED #include #define PROCESS_H_INCLUDED 1 #endif #endif #if DK4_HAVE_IO_H #ifndef IO_H_INCLUDED #include #define IO_H_INCLUDED 1 #endif #endif #if DK4_HAVE_FCNTL_H #ifndef FCNTL_H_INCLUDED #include #define FCNTL_H_INCLUDED 1 #endif #endif #include "dk4types.h" #include "dk4const.h" #include "dk4vers.h" #include "dk4app.h" #include "dk4fopda.h" #include "dk4isadm.h" #if DK4_ON_WINDOWS #include "dk4mem.h" #include "dk4strd.h" #include "dk4mpl.h" #include "dk4pathd.h" #endif /** Default help text, shown if help file is not found. */ static const dkChar * const help_text[] = { $!text macro=dkT,preprocessor Split overlong SQL lines dk-sqlsplit [] Options: --help Show this short help text. --manual *** SHOW FULL MANUAL. *** --version Show version information. --license Show license information. http://dktools.sourceforge.net $!end }; /** License conditions. */ static const dkChar * const license_text[] = { $!text macro=dkT,preprocessor This software uses code from the following projects, either directly or as a library: dktools Dirk Krause's tools and libraries. See http://dktools.sourceforge.net/ for more information. #if DK4_HAVE_ZLIB_H zlib Data compression library. See http://www.zlib.net/ for more information. #endif #if DK4_HAVE_BZLIB_H bzip2 Data compression program and library. See http://www.bzip.org/ for more information. #endif All the licenses below apply to the program. Licenses for used libraries are shown as found on my Scientific Linux 6.x computer in the /usr/share/doc directory on 2015-04-01. Check the project homepages of the used libraries for additional information and/or updated license terms. DK tools and libraries license ============================== Copyright (c) 2015-2016, Dirk Krause All rights reserved. Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: * Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution. * Neither the name of the Dirk Krause nor the names of contributors may be used to endorse or promote products derived from this software without specific prior written permission. THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. #if DK4_HAVE_ZLIB_H Zlib license ============ (C) 1995-2004 Jean-loup Gailly and Mark Adler This software is provided 'as-is', without any express or implied warranty. In no event will the authors be held liable for any damages arising from the use of this software. Permission is granted to anyone to use this software for any purpose, including commercial applications, and to alter it and redistribute it freely, subject to the following restrictions: 1. The origin of this software must not be misrepresented; you must not claim that you wrote the original software. If you use this software in a product, an acknowledgment in the product documentation would be appreciated but is not required. 2. Altered source versions must be plainly marked as such, and must not be misrepresented as being the original software. 3. This notice may not be removed or altered from any source distribution. Jean-loup Gailly Mark Adler jloup@gzip.org madler@alumni.caltech.edu #endif #if DK4_HAVE_BZLIB_H Bzip2 and libbzip2 library license ================================== This program, "bzip2", the associated library "libbzip2", and all documentation, are copyright (C) 1996-2007 Julian R Seward. All rights reserved. Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: 1. Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. 2. The origin of this software must not be misrepresented; you must not claim that you wrote the original software. If you use this software in a product, an acknowledgment in the product documentation would be appreciated but is not required. 3. Altered source versions must be plainly marked as such, and must not be misrepresented as being the original software. 4. The name of the author may not be used to endorse or promote products derived from this software without specific prior written permission. THIS SOFTWARE IS PROVIDED BY THE AUTHOR ``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. Julian Seward, jseward@bzip.org bzip2/libbzip2 version 1.0.5 of 10 December 2007 #endif $!end }; /** Constant texts used by the program, not localized. */ static const dkChar * const kwnl[] = { $!string-table macro=dkT # # 0 Program group name # dktools # # 1 Help file name # dk-sqlsplit.txt # # 2 File name: stdin # stdin # # 3 File name separator for Windows # \\ $!end }; /** Application structure. */ static dk4_app_t *app = NULL; /** Exit status code. */ static int exval = EXIT_FAILURE; static void process_file_with_name(FILE *fp, const dkChar *fn) { const dkChar *oldsourcefile; /* Previous source file name setting */ dk4_um_t oldsourceline; /* Previous source line setting */ dk4_um_t lineno; /* Current line number */ int inc; /* Input character from fgetc() */ int ccl; /* Character class, input to STM */ int st; /* State */ int lnl; /* Flag: Last char was newline */ char c; /* Current character to process */ /* Save current log settings */ oldsourcefile = dk4app_get_log_source_file(app); oldsourceline = dk4app_get_log_source_line(app); /* Set logging too file name */ dk4app_set_log_source_file(app, fn); dk4app_set_log_source_line(app, (dk4_um_t)1UL); lineno = (dk4_um_t)1UL; /* Process all input bytes */ lnl = 0; find_line_end_reset(&st); while (EOF != (inc = fgetc(fp))) { c = (char)inc; if ('\r' != c) { /* Classify input character */ ccl = I_ANY; switch (c) { case '\n': ccl = I_NL; break; case '(': ccl = I_OPBR; break; case ')': ccl = I_CLBR; break; case '\\': ccl = I_BS; break; case '/': ccl = I_SL; break; case '*': ccl = I_AST; break; case '\'': ccl = I_SQ; break; case '"': ccl = I_DQ; break; case '`': ccl = I_BT; break; case ',': ccl = I_COMMA; break; } /* Get state machine reaction and go to appropriate brach */ switch (find_line_end_step(&st, ccl)) { case O_NL : { if (EOF == fputc('\n', stdout)) { exval = EXIT_FAILURE; /* ERROR: Write operation failed */ dk4app_log_base1(app, DK4_LL_ERROR, 128); } if (EOF == fputc(c, stdout)) { exval = EXIT_FAILURE; /* ERROR: Write operation failed */ dk4app_log_base1(app, DK4_LL_ERROR, 128); } } break; default : { if (EOF == fputc(c, stdout)) { exval = EXIT_FAILURE; /* ERROR: Write operation failed */ dk4app_log_base1(app, DK4_LL_ERROR, 128); } } break; } if ('\n' == c) { lnl = 1; lineno++; dk4app_set_log_source_line(app, lineno); } else { lnl = 0; } } } if (0 == lnl) { if (EOF == fputc('\n', stdout)) { exval = EXIT_FAILURE; /* ERROR: Write operation failed */ dk4app_log_base1(app, DK4_LL_ERROR, 128); } } /* Restore log settings */ dk4app_set_log_source_file(app, oldsourcefile); dk4app_set_log_source_line(app, oldsourceline); } static void process_named_file(const dkChar *filename) { FILE *fipo = NULL; int tests = DK4_FOPEN_SC_USER; #if 0 /* File is opened for reading only. */ if (1 == dk4isadmin()) { tests = DK4_FOPEN_SC_PRIVILEGED; } #endif fipo = dk4fopen_app(filename, dkT("rb"), tests, app); if (NULL != fipo) { process_file_with_name(fipo, filename); fclose(fipo); } else { exval = EXIT_FAILURE; } } #if DK4_ON_WINDOWS static void expand_and_process(const dkChar *pattern) { dkChar buf[DK4_MAX_PATH]; dk4_dir_t *fne; const dkChar *shf; const dkChar *pth; int any_file_found = 0; fne = dk4app_fne_open(pattern, app); if (NULL != fne) { while (NULL != (shf = dk4dir_next_file(fne))) { any_file_found = 1; pth = dk4dir_get_path(fne); if (0 != dk4str_cpy_s(buf, DK4_SIZEOF(buf,dkChar), pth, NULL)) { if(0 != dk4str_cat_s(buf, DK4_SIZEOF(buf,dkChar), kwnl[3], NULL)) { if(0 != dk4str_cat_s(buf, DK4_SIZEOF(buf,dkChar), shf, NULL)) { process_named_file(buf); } else { dk4app_log_base3(app, DK4_LL_ERROR, 100, 105, pattern); exval = EXIT_FAILURE; } } else { dk4app_log_base3(app, DK4_LL_ERROR, 100, 105, pattern); exval = EXIT_FAILURE; } } else { dk4app_log_base3(app, DK4_LL_ERROR, 100, 105, pattern); exval = EXIT_FAILURE; } if (NULL != pth) { } else { process_named_file(shf); } } dk4dir_close(fne); if (0 == any_file_found) { dk4app_log_base3(app, DK4_LL_ERROR, 100, 107, pattern); exval = EXIT_FAILURE; } } else { exval = EXIT_FAILURE; } } #endif /** Main function. @param argc Number of command line arguments. @param argv Command line arguments array. @return 0 on success, all other values indicate errors. */ #if DK4_CHAR_SIZE > 1 int wmain(int argc, wchar_t *argv[]) #else int main(int argc, char *argv[]) #endif { const dkChar *argptr = NULL; #if DK4_ON_WINDOWS int oldmode = _O_TEXT; #endif int xargc = 0; int i; $!trace-init dk-sqlsplit.deb $? "+ main" app = dk4app_open_cmd( argc, argv, NULL, 0, kwnl[0], DKT_VERSION_DK, kwnl[1], help_text, license_text ); if (NULL != app) { if (0 != dk4app_can_run_normally(app)) { exval = EXIT_SUCCESS; if (0 < (xargc = dk4app_get_argc(app))) { for (i = 0; i < xargc; i++) { argptr = dk4app_get_argv(app, i); if (NULL != argptr) { #if DK4_ON_WINDOWS if (0 != dk4path_must_expand(argptr)) { expand_and_process(argptr); } else { #endif process_named_file(argptr); #if DK4_ON_WINDOWS } #endif } else { $? "! BUG, empty argptr" /* BUG: Should not happen */ } } } else { #if DK4_ON_WINDOWS oldmode = _setmode(_fileno(stdin), _O_BINARY); #endif process_file_with_name(stdin, kwnl[2]); #if DK4_ON_WINDOWS _setmode(_fileno(stdin), oldmode); #endif } } else { if (0 != dk4app_help_version_license(app)) { exval = EXIT_SUCCESS; } } dk4app_close(app); } else { } $? "- main %d", exval $!trace-end exit(exval); return exval; }