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