summaryrefslogtreecommitdiff
path: root/support/dktools/dk-sqlsplit.ctr
blob: 81463eea945807cc5c5f3863b0f21aeea7e85fb9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
%%	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 <stdio.h>
#if DK4_HAVE_STDLIB_H
#ifndef STDLIB_H_INCLUDED
#include <stdlib.h>
#define	STDLIB_H_INCLUDED 1
#endif
#endif

#if DK4_HAVE_UNISTD_H
#ifndef UNISTD_H_INCLUDED
#include <unistd.h>
#define	UNISTD_H_INCLUDED 1
#endif
#endif

#if DK4_HAVE_PROCESS_H
#ifndef PROCESS_H_INCLUDED
#include <process.h>
#define	PROCESS_H_INCLUDED 1
#endif
#endif

#if DK4_HAVE_IO_H
#ifndef IO_H_INCLUDED
#include <io.h>
#define IO_H_INCLUDED 1
#endif
#endif

#if DK4_HAVE_FCNTL_H
#ifndef FCNTL_H_INCLUDED
#include <fcntl.h>
#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 [<file(s)>]

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;
}