blib/lib/JSprite.pm

filter: Statementstmt 57.6% 1099 / 1905 Branchbran 37.9% 342 / 902 Conditioncond 23.8% 82 / 344 MC/DCmcdc 6.0% 12 / 199 Subroutinesub 67.2% 37 / 55 Podpod 30.4% 14 / 46 totaltotal 45.9% 1586 / 3451 CC 598 SCAR 66.3
CC
598
Cov
48%
alter
3306.0
parse_columns
2171.2
load_database
524.3
CRAP 758.9
↑ Summary blib/lib/DBD/Sprite.pm »
1 ##++
2 ## JSprite
3 ## Sprite v.3.2
4 ##
5 ## Copyright (c) 1998-2019, Jim Turner, from
6 ## Sprite.pm (c) 1995-1998, Shishir Gundavaram
7 ## All Rights Reserved
8 ##
9 ## E-Mail: shishir att ora dot com
10 ## E-Mail: turnerjw784 att yahoo dot com
11 ##
12 ## Permission to use, copy, and distribute is hereby granted,
13 ## providing that the above copyright notice and this permission
14 ## appear in all copies and in supporting documentation.
15 ##
16 ## If you use Sprite for any cool (Web) applications, I would be
17 ## interested in hearing about them. So, drop me a line. Thanks!
18 ##--
19  
20 #############################################################################
21  
22 =head1 NAME
23  
24 JSprite - Modified version of Sprite to manipulate text delimited flat-files
25 as databases using SQL emulating Oracle. The remaining documentation
26 is based on Sprite.
27  
28 =head1 SYNOPSIS
29  
30 use JSprite;
31  
32 $rdb = new JSprite;
33  
34 $rdb->set_delimiter (-read => '::') ## OR: ('read', '::');
35 $rdb->set_delimiter (-write => '::') ## OR: ('write', '::');
36 $rdb->set_delimiter (-record => '\n') ## OR: ('record', '::');
37  
38 $rdb->set_os ('Win95');
39  
40 ## Valid arguments (case insensitive) include:
41 ##
42 ## Unix, Win95, Windows95, MSDOS, NT, WinNT, OS2, VMS,
43 ## MacOS or Macintosh. Default determined by $^O.
44  
45 #$rdb->set_lock_file ('c:\win95\tmp\Sprite.lck', 10);
46 $rdb->set_lock_file ('Sprite.lck', 10);
47  
48 $rdb->set_db_dir ('Mac OS:Perl 5:Data') || die "Can't access dir!\n";
49  
50 $data = $rdb->sql (<<Query); ## OR: @data = $rdb->sql (<<Query);
51 .
52 . (SQL)
53 .
54 Query
55  
56 foreach $row (@$data) { ## OR: foreach $row (@data) {
57 @columns = @$row; ## NO null delimited string -- v3.2
58 }
59  
60 $rdb->xclose;
61 $rdb->close ($database); ## To save updated database
62  
63 =head1 DESCRIPTION
64  
65 Here is a simple database where the fields are delimited by double-colons:
66  
67 PLAYER=VARCHAR2(16)::YEARS=NUMBER::POINTS=NUMBER::REBOUNDS=NUMBER::ASSISTS=NUMBER::Championships=NUMBER
68 ...
69 Larry Bird::13::25::11::7::3
70 Michael Jordan::14::29::6::5::5
71 Magic Johnson::13::22::7::11::5
72 ...
73  
74 I<Note:> The first line must contain the field names (case insensitive),
75 and the Oracle datatype and length. Currently, the only meaningful
76 datatypes are NUMBER and VARCHAR. All other types are treated
77 the same as VARCHAR (Perl Strings, for comparisens).
78  
79 =head1 Supported SQL Commands
80  
81 Here are a list of the SQL commands that are supported by JSprite:
82  
83 =over 5
84  
85 =item I<select> - retrieves records that match specified criteria:
86  
87 select col1 [,col2] from table_name
88 where (cond1 OPERATOR value1)
89 [and|or (cond2 OPERATOR value2) ...]
90 order by col1 [,col2]
91  
92 The '*' operator can be used to select all columns.
93  
94 The I<database> is simply the file that contains the data. If the file
95 is not in the current directory, the path must be specified. By
96 default, the actual file-name will end with the extension ".sdb".
97  
98 Valid column names can be used where [cond1..n] and [value1..n] are expected,
99 such as:
100  
101 I<Example 1>:
102  
103 select Player, Points from my_db
104 where (Rebounds > Assists)
105  
106 I<Note:> Column names must not be Perl string or boolean operators, ie. (lt,
107 gt, eq, and, or, etc. and are case-insensitive.
108
109 The following SQL operators can be used: =, <, >, <=, >=, <>,
110 is, as well as Perl's special operators: =~ and !~.
111 The =~ and !~ operators are used to
112 specify regular expressions, such as:
113  
114 I<Example 2>:
115  
116 select * from my_db
117 where (Name =~ /Bird$/i)
118  
119 Selects records where the Name column ends with "Bird" (case insensitive).
120 For more information, look at a manual on regexps.
121  
122 I<Note:> A path to a database can contain only the following characters:
123  
124 \w, \x80-\xFF, -, /, \, ., :
125  
126 If you have directories with spaces or other 'invalid' characters, you
127 need to use the I<set_db_dir> method.
128  
129 =item I<update> - updates records that match specified criteria.
130  
131 update table_name
132 set cond1 = (value1)[,cond2 = (value2) ...]
133 where (cond1 OPERATOR value1)
134 [and|or (cond2 OPERATOR value2) ...]
135  
136 I<Example>:
137  
138 update my_db
139 set Championships = (Championships + 1)
140 where (Player = 'Larry Bird')
141  
142 update my_db
143 set Championships = (Championships + 1),
144 Years = (12)
145 where (Player = 'Larry Bird')
146  
147 =item I<delete> - removes records that match specified criteria:
148  
149 delete from table_name
150 where (cond1 OPERATOR value1)
151 [and|or (cond2 OPERATOR value2) ...]
152  
153 I<Example>:
154  
155 delete from my_db
156 where (Player =~ /Johnson$/i) or
157 (Years > 12)
158  
159 =item I<create> - simplified version of SQL-92 counterpart
160  
161 Creates a new table or sequence.
162  
163 create table table_name (
164 column-name datatype [, column-name2 datatype...]
165 [, primary key (column-name [, column-name..])
166  
167 create sequence sequence_name [increment by #] start with #
168  
169 A sequence is an Oracle-ish way of doing autonumbering. The sequence is stored
170 in a tiny ascii file (sequence-name.seq). You can also do autonumbering the
171 MySQL way with a field using the "AUTONUMBER" datatype and giving it a default
172 value of the starting sequence number.
173  
174 =item I<alter> - simplified version of SQL-92 counterpart
175  
176 Removes the specified column from the database. The other standard SQL
177 functions for alter table are also supported:
178  
179 alter table table_name drop (column-name [, column-name2...])
180  
181 alter table table_name add ([position] column-name datatype
182 [, [position2] column-name2 datatype2...]
183 [primary key (column-name [, column-name2...]) ])
184  
185 I<Examples>:
186  
187 alter table my_db drop (Years)
188  
189 alter table my_db add (Legend VARCHAR(40) default "value", Mapname CHAR(5))
190  
191 alter table my_db add (1 Maptype VARCHAR(40))
192  
193 This example adds a new column as the 2nd column (0 for 1st column) of the
194 table. By default, new fields are added as the right-most (last) column of
195 the table. This is a JSprite Extension and is not supported by standard SQL.
196  
197 alter table my_db modify (Legend VARCHAR(40))
198  
199 alter table my_db modify (0 Legend default 1)
200  
201 The last example moves the "Legend" column to the 1st column in the table and
202 shifts the others over, and causes all subsequent records added to use a
203 default value of "1" for the "Legend" field, if no value is inserted for it.
204 This "Position" field (zero in the example) is a JSprite extension and is not
205 part of standard SQL.
206  
207 =item I<insert> - inserts a record into the database:
208  
209 insert into table_name
210 [(col1, col2, ... coln) ]
211 values
212 (val1, val2, ... valn)
213  
214 I<Example>:
215  
216 insert into my_db
217 (Player, Years, Points, Championships)
218 values
219 ('Kareem Abdul-Jabbar', 21, 26, 6)
220  
221 You don't have to specify all of the fields in the database! Sprite also
222 does not require you to specify the fields in the same order as that of
223 the database.
224  
225 I<Note:> You should make it a habit to quote strings.
226  
227 =back
228  
229 =head1 METHODS
230  
231 Here are the available methods:
232  
233 =over 5
234  
235 =item I<set_delimiter>
236  
237 The set_delimiter function sets the read and write delimiter for the
238 database. The delimiter is not limited to one character; you can have
239 a string, and even a regexp (for reading only). In JSprite,
240 you can also set the record seperator (default is newline).
241  
242 I<Return Value>
243  
244 None
245  
246 =item I<set_os>
247  
248 The set_os function can be used to notify Sprite as to the operating
249 system that you're using. Default is determined by $^O.
250  
251 I<Note:> If you're using Sprite on Windows 95/NT or on OS2, make sure
252 to use backslashes -- and NOT forward slashes -- when specifying a path
253 for a database or to the I<set_db_dir> or I<set_lock_file> methods!
254  
255 I<Return Value>
256  
257 None
258  
259 =item I<set_lock_file>
260  
261 For any O/S that doesn't support flock (i.e Mac, Windows 95 and VMS), this
262 method allows you to set a lock file to use and the number of tries that
263 Sprite should try to obtain a 'fake' lock. However, this method is NOT
264 fully reliable, but is better than no lock at all.
265  
266 'Sprite.lck' (either in the directory specified by I<set_db_dir> or in
267 the current directory) is used as the default lock file if one
268 is not specified.
269  
270 I<Return Value>
271  
272 None
273  
274 =item I<set_db_dir>
275  
276 A path to a database can contain only the following characters:
277  
278 \w, \x80-\xFF, -, /, \, ., :
279  
280 If your path contains other characters besides the ones listed above,
281 you can use this method to set a default directory. Here's an example:
282  
283 $rdb->set_db_dir ("Mac OS:Perl 5:Data");
284  
285 $data = $rdb->sql ("select * from phone.db");
286  
287 Sprite will look for the file "Mac OS:Perl 5:Data:phone.db". Just to
288 note, the database filename cannot have any characters besides the one
289 listed above!
290  
291 I<Return Value>
292  
293 0 - Failure
294 1 - Success
295  
296 =item I<set_db_ext>
297  
298 JSprite permits the user to specify an extension that is part
299 of the actual file name, but not part of the corresponding
300 table name. The default is '.sdb'.
301  
302 $rdb->set_db_ext ('.sdb');
303  
304  
305 I<Return Value>
306  
307 None
308  
309 =item I<sql>
310  
311 The sql function is used to pass a SQL command to this module. All of the
312 SQL commands described above are supported. The I<select> SQL command
313 returns an array containing the data, where the first element is the status.
314 All of the other other SQL commands simply return a status.
315  
316 I<Return Value>
317 1 - Success
318 0 - Error
319  
320 =item I<commit>
321  
322 The sql function is used to commit changes to the database.
323 Arguments: file-name (usually the table-name) - the file
324 name to write the table to. NOTE: The path and file
325 extension will be appended to it, ie:
326  
327 &rdb->commit('filename');
328  
329 I<Return Value>
330 1 - Success
331 0 - Error
332  
333 =item I<close>
334  
335 The close function closes the file, and destroys the database object. You
336 can pass a filename to the function, in which case Sprite will save the
337 database to that file; the directory set by I<set_db_dir> is used as
338 the default.
339  
340 I<Return Value>
341  
342 None
343  
344 =back
345  
346 =head1 NOTES
347  
348 Sprite is not the solution to all your data manipulation needs. It's fine
349 for small databases (less than 1000 records), but anything over that, and
350 you'll have to sit there and twiddle your fingers while Sprite goes
351 chugging away ... and returns a few *seconds* or so later.
352  
353 The main advantage of Sprite is the ability to develop and test
354 prototype applications on personal machines (or other machines which do not
355 have an Oracle licence or some other "mainstream" database) before releasing
356 them on "production" machines which do have a "real" database. This can all
357 be done with minimal or no changes to your Perl code.
358  
359 Another advantage of Sprite is that you can use Perl's regular expressions
360 to search through your data. Yippee!
361  
362 JSprite provides the ability to emulate basic database tables
363 and SQL calls via flat-files. The primary use envisioned
364 for this is to permit website developers who can not afford
365 to purchase an Oracle licence to prototype and develop Perl
366 applications on their own equipment for later hosting at
367 larger customer sites where Oracle is used. :-)
368  
369 JSprite attempts to do things in as database-independent manner as possible,
370 but where differences occurr, JSprite most closely emmulates Oracle, for
371 example "sequences/autonumbering". JSprite uses tiny one-line text files
372 called "sequence files" (.seq). and Oracle's "seq_file_name.NEXTVAL"
373 function to insert into autonumbered fields.
374  
375 =head1 ADDITIONAL JSPRITE-SPECIFIC FEATURES
376  
377 JSprite supports Oracle sequences and functions. The
378 currently-supported Oracle functions are "SYSTIME", NEXTVAL, and "NULL".
379 Users can also "register" their own functions via the
380 "fn_register" method.
381  
382 =item I<fn_register>
383  
384 Method takes 2 arguments: Function name and optionally, a
385 package name (default is "main").
386  
387 $rdb->fn_register ('myfn','mypackage');
388
389 -or-
390  
391 JSprite::fn_register ('myfn',__PACKAGE__);
392  
393 Then, you could say:
394  
395 insert into mytable values (myfn(?))
396
397 and bind some value to "?", which is passed to "myfn", and the return-value
398 is inserted into the database. You could also say (without binding):
399  
400 insert into mytable values (myfn('mystring'))
401
402 -or (if the function takes a number)-
403  
404 select field1, field2 from mytable where field3 = myfn(123)
405
406 I<Return Value>
407  
408 None
409  
410 JSprite has added the SQL "create" function to
411 create new tables and sequences.
412  
413 I<Examples:>
414  
415 create table table1 (
416 field1 number,
417 field2 varchar(20),
418 field3 number(5,3) default 3.143)
419  
420 create sequence sequence-name [increment by 1] start with 0
421  
422 =head1 SEE ALSO
423  
424 DBD::Sprite, Sprite, Text::CSV, RDB
425  
426 =head1 ACKNOWLEDGEMENTS
427  
428 I would like to thank the following, especially Rod Whitby and Jim Esten,
429 for finding bugs and offering suggestions:
430  
431 Shishir Gundavaram (shishir@ora.com) (Original Sprite Author)
432 Rod Whitby (rwhitby@geocities.com)
433 Jim Esten (jesten@wdynamic.com)
434 Dave Moore (dmoore@videoactv.com)
435 Shane Hutchins (hutchins@ctron.com)
436 Josh Hochman (josh@bcdinc.com)
437 Barry Harrison (barryh@topnet.net)
438 Lisa Farley (lfarley@segue.com)
439 Loyd Gore (lgore@ascd.org)
440 Tanju Cataltepe (tanju@netlabs.net)
441 Haakon Norheim (hanorhei@online.no)
442  
443 =head1 COPYRIGHT INFORMATION
444
445 JSprite Copyright (c) 1998-2001, Jim Turner
446 Sprite Copyright (c) 1995-1998, Shishir Gundavaram
447 All Rights Reserved
448  
449 Permission to use, copy, and distribute is hereby granted,
450 providing that the above copyright notice and this permission
451 appear in all copies and in supporting documentation.
452  
453 =cut
454  
455 ###############################################################################
456  
457 package JSprite;
458  
459 1 ▶no warnings 'uninitialized';
Subroutine BEGIN: called CC=1 SCAR=0.0
460  
461 1 require 5.002;
462  
463 1 ▶use vars qw($VERSION);
Subroutine BEGIN: called CC=1 SCAR=0.0
464  
465 1 ▶use Cwd;
Subroutine BEGIN: called CC=1 SCAR=0.0
466 1 ▶use Fcntl;
Subroutine BEGIN: called CC=1 SCAR=0.0
467 1 ▶use File::DosGlob 'glob';
Subroutine BEGIN: called CC=1 SCAR=0.0
468 1 our ($XMLavailable, $results);
469 0 ▶eval 'use XML::Simple; $XMLavailable = 1; 1';
Subroutine BEGIN: called CC=1 SCAR=1.2
470 1 eval {require 'OraSpriteFns.pl';};
471  
472 ##++
473 ## Global Variables. Declare lock constants manually, instead of
474 ## importing them from Fcntl.
475 ##
476 1 ▶use vars qw ($VERSION $LOCK_SH $LOCK_EX);
Subroutine BEGIN: called CC=1 SCAR=0.0
477 ##--
478  
479 1 $JSprite::VERSION = '6.12';
480 1 $JSprite::LOCK_SH = 1;
481 1 $JSprite::LOCK_EX = 2;
482  
483 1 my $NUMERICTYPES = '^(NUMBER|FLOAT|DOUBLE|INT|INTEGER|NUM|AUTONUMBER|AUTO|AUTO_INCREMENT|DECIMAL|TINYINT|BIGINT|DOUBLE)$'; #20000224
484 1 my $STRINGTYPES = '^(VARCHAR2|CHAR|VARCHAR|DATE|LONG|BLOB|MEMO|RAW|TEXT)$';
485 #my $BLOBTYPES = '^(LONG|BLOB|MEMO)$';
486 1 my $BLOBTYPES = '^(LONG.*|.*?LOB|MEMO|.FILE)$';
487 1 my $REFTYPES = '^(LONG.*|.FILE)$'; #SUPPORT FILE-REFERENCING FOR THESE BLOB-TYPES. (OTHERS ARE STORED INLINE). 20010125
488 1 my @perlconds = ();
489 1 my @perlmatches = ();
490 1 my $sprite_user = ''; #ADDED 20011026.
491 1 our ($errdetails);
492  
493 ##++
494 ## Public Methods and Constructor
495 ##--
496  
497 sub new
498 3 ▶{
Subroutine new: called CC=2 SCAR=6.9
Pod undocumented
499 3 my $class = shift;
500 3 my $self;
501  
502 3 $self = {
503 commands => 'select|update|delete|alter|insert|create|drop|truncate|primary_key_info',
504 # column => '[A-Za-z0-9\~\x80-\xFF][\w\x80-\xFF]+', #CHGD. TO NEXT 20020214 TO ALLOW 1-LETTER FIELD NAMES!!!! (HOW DID THIS GO ON FOR SO LONG?)
505 column => '[A-Za-z0-9][\w\x80-\xFF]*',
506 _select => '[\w\x80-\xFF\*,\s\~]+',
507 path => '[\w\x80-\xFF\-\/\.\:\~\\\\]+',
508 table => '',
509 file => '',
510 table => '', #JWT: ADDED 20020515
511 ext => '', #JWT:ADD FILE EXTENSIONS.
512 directory => '',
513 timestamp => 0,
514 _read => ',',
515 _write => ',',
516 _record => "\n", #JWT:SUPPORT ANY RECORD-SEPARATOR!
517 fields => {},
518 fieldregex => '', #ADDED 20001218
519 use_fields => '',
520 key_fields => '',
521 order => [],
522 types => {},
523 lengths => {},
524 scales => {},
525 defaults => {},
526 records => [],
527 platform => 'Unix',
528 fake_lock => 0,
529 default_lock => 'Sprite.lck',
530 sprite_lock_file => '',
531 lock_handle => '',
532 default_try => 10,
533 sprite_lock_try => '',
534 lock_sleep => 1,
535 errors => {},
536 lasterror => 0, #JWT: ADDED FOR ERROR-CONTROL
537 lastmsg => '',
538 CaseTableNames => 0, #JWT: 19990991 TABLE-NAME CASE-SENSITIVITY?
539 LongTruncOk => 0, #JWT: 19991104: ERROR OR NOT IF TRUNCATION.
540 LongReadLen => 0, #JWT: 19991104: ERROR OR NOT IF TRUNCATION.
541 RaiseError => 0, #JWT: 20000114: ADDED DBI RAISEERROR HANDLING.
542 silent => 0,
543 dirty => 0, #JWT: 20000229: PREVENT NEEDLESS RECOMMITS.
544 StrictCharComp => 0, #JWT: 20010313: FORCES USER TO PAD STRING LITERALS W/SPACES IF COMPARING WITH "CHAR" TYPES.
545 sprite_forcereplace => 0, #JWT: 20010912: FORCE DELETE/REPLACE OF DATAFILE (FOR INTERNAL WEBFARM USE)!
546 sprite_Crypt => 0, #JWT: 20020109: Encrypt Sprite table files! FORMAT: [[encrypt=|decrypt=][Crypt]::CBC;][[IDEA[_PP]|DES]_PP];]keystr
547 sprite_reclimit => 0, #JWT: 20010123: PERMIT LIMITING # OF RECORDS FETCHED.
548 sprite_sizelimit => 0, #JWT: 20010123: SAME AS RECLIMIT, NEEDED BOR BACKWARD COMPAT.
549 sprite_actlimit => 0, #JWT: 20010123: SAME AS RECLIMIT, NEEDED BOR BACKWARD COMPAT.
550 dbuser => '', #JWT: 20011026: SAVE USER'S NAME.
551 dbname => '', #JWT: 20020515: SAVE DATABASE NAME.
552 CBC => 0, #JWT: 20020529: SAVE Crypt::CBC object, if encrypting!
553 sprite_xsl => '', #JWT: 20020611: OPTIONAL XSL TEMPLATE FILE.
554 sprite_CaseFieldNames => 0, #JWT: 20020618: FIELD-NAME CASE-SENSITIVITY?
555 sprite_lastsequence => '', #JWT: ADDED 20020905 TO SUPPORT DBIx::GeneratedKey!
556 sprite_nocase => 0, #JWT: ADDED 20040323 TO SUPPORT CASE-INSENSITIVE WHERE-CLAUSES LIKE LDAP.
557 #NOTE - ONLY CURRENTLY FOR "LIKE/NOT LIKE" (VALUE=1|'L)!
558 #MAY ADD OTHER VALUES LATER!
559 ASNAMES => {}, #ADDED 20040913 TO SUPPORT "AS" IN SELECTS.
560 };
561  
562 3 $self->{separator} = { Unix => '/', Mac => ':', #JWT: BUGFIX.
563 PC => '\\\\', VMS => '/' };
564 $self->{maxsizes} = {
565 3 'LONG RAW' => 2147483647,
566 'RAW' => 255,
567 'LONG' => 2147483647,
568 'CHAR' => 255,
569 'NUMBER' => 38,
570 'AUTONUMBER' => 38,
571 'DOUBLE' => 15,
572 'DATE' => 19,
573 'VARCHAR' => 2000,
574 'VARCHAR2' => 2000,
575 'BOOLEAN' => 1,
576 'BLOB' => 2147483647,
577 'MEMO' => 2147483647,
578 };
579  
580 3 bless $self, $class;
581  
582 3 ▶ for (my $i=0;$i<scalar(@_);$i+=2) #ADDED: 20020109 TO ALLOW SETTING ATTRIBUTES IN INITIALIZATION!
Branch: 1 branch
BranchTrueFalseTotal
if ($i < scalar @_) 9 3 12
583 {
584 9 $self->{$_[$i]} = $_[$i+1];
585 }
586  
587 3 $self->initialize;
588 3 return $self;
589 }
590  
591 sub initialize
592 3 ▶{
Subroutine initialize: called CC=10 SCAR=41.1
Pod undocumented
593 3 my $self = shift;
594  
595 3 $sprite_user = $self->{'dbuser'}; #ADDED 20011026.
596 3 $self->define_errors;
597 3 ▶ $self->set_os ($^O) if (defined $^O);
Branch: 1 branch
BranchTrueFalseTotal
if defined $^O 3 0 3
598 3 ▶ if ($self->{sprite_Crypt}) #ADDED: 20020109
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{"sprite_Crypt"}) 0 3 3
599 {
600 0 my (@cryptinfo) = split(/\;/, $self->{sprite_Crypt});
601 0 ▶ unshift (@cryptinfo, 'IDEA') if ($#cryptinfo < 1);
Branch: 1 branch
BranchTrueFalseTotal
if $#cryptinfo < 1 0 0 0
602 0 ▶ unshift (@cryptinfo, 'Crypt::CBC') if ($#cryptinfo < 2);
Branch: 1 branch
BranchTrueFalseTotal
if $#cryptinfo < 2 0 0 0
603 0 $self->{sprite_Crypt} = 1;
604 0 ▶ $self->{sprite_Crypt} = 2 if ($cryptinfo[0] =~ s/^encrypt\=//i);
Branch: 1 branch
BranchTrueFalseTotal
if $cryptinfo[0] =~ s/^encrypt\=//i 0 0 0
605 0 ▶ $self->{sprite_Crypt} = 3 if ($cryptinfo[0] =~ s/^decrypt\=//i);
Branch: 1 branch
BranchTrueFalseTotal
if $cryptinfo[0] =~ s/^decrypt\=//i 0 0 0
606 0 ▶ $cryptinfo[0] = 'Crypt::' . $cryptinfo[0]
Branch: 1 branch
BranchTrueFalseTotal
unless $cryptinfo[0] =~ /\:\:/ 0 0 0
607 unless ($cryptinfo[0] =~ /\:\:/);
608 0 eval "require $cryptinfo[0]";
609 0 ▶ if ($@)
Branch: 1 branch
BranchTrueFalseTotal
if ($@) { } 0 0 0
610 {
611 0 $errdetails = $@;
612 0 $self->display_error (-526);
613 }
614 else
615 {
616 0 eval {$self->{CBC} = Crypt::CBC->new($cryptinfo[2], $cryptinfo[1]); };
617 0 ▶ if ($@)
Branch: 1 branch
BranchTrueFalseTotal
if ($@) 0 0 0
618 {
619 0 $errdetails = "Can't find/use module \"$cryptinfo[1].pm\"? ($@)!";
620 0 $self->display_error (-526);
621 }
622 }
623 }
624 3 return $self;
625 }
626  
627 sub set_delimiter
628 9 ▶{
Subroutine set_delimiter: called CC=7 SCAR=21.5
Pod documented
629 9 my ($self, $type, $delimiter) = @_;
630 9 ▶ $type ||= 'other';
Condition50%1/2
$type ||= "other"
l!l
90
MC/DC0%0/1
$type ||= "other"
$type
Truth table50%1/2
A
A= $type
Aresult
11
00
631 9 ▶ $delimiter ||= $self->{_read} || $self->{_write};
Condition16%1/6
$delimiter ||= $self->{"_read"} || $self->{"_write"}
l!l&&r!l&&!r
900
$self->{'_read'} || $self->{'_write'}
l!l&&r!l&&!r
000
MC/DC0%0/3
$delimiter ||= $self->{"_read"} || $self->{"_write"}
$delimiter $self->{'_read'} $self->{'_write'}
Truth table0%0/4
A ||= B || C
A= $delimiterB= $self->{'_read'}C= $self->{'_write'}
ABCresult
1XX1
01X1
0011
0000
632  
633 9 $type =~ s/^-//;
634 9 $type =~ tr/A-Z/a-z/;
635  
636 9 ▶ if ($type eq 'read') {
Branch: 3 branches
BranchTrueFalseTotal
if ($type eq 'read') { } 3 6 9
elsif ($type eq 'write') { } 3 3 6
elsif ($type eq 'record') { } 3 0 3
637 3 $self->{_read} = $delimiter;
638 } elsif ($type eq 'write') {
639 3 $self->{_write} = $delimiter;
640 } elsif ($type eq 'record') { #JWT:SUPPORT ANY RECORD-SEPARATOR!
641 ###$delimiter =~ s/^\r// if ($self->{platform} eq 'PC'); #20000403 (BINMODE HANDLES THIS!!!)
642 3 $self->{_record} = $delimiter;
643 } else {
644 0 $self->{_read} = $self->{_write} = $delimiter;
645 }
646  
647 9 return (1);
648 }
649  
650 sub set_os
651 3 ▶{
Subroutine set_os: called CC=6 SCAR=22.3
Pod documented
652 3 my ($self, $platform) = @_;
653 #$platform = 'Unix', return unless ($platform); #20000403.
654 3 ▶ return $self->{platform} unless ($platform); #20000403
Branch: 1 branch
BranchTrueFalseTotal
unless $platform 0 3 3
655  
656 3 $platform =~ s/\s//g;
657  
658 # if ($platform =~ /^(?:OS2|(?:Win)?NT|Win(?:dows)?95|(?:MS)?DOS)$/i) {
659 # $self->{platform} = ''; #20000403
660  
661 3 ▶ if ($platform =~ /(?:darwin|bsdos)/i) #20020218: ADDED FOR NEW MAC OS "OS X" WHICH USES "/"
Branch: 4 branches
BranchTrueFalseTotal
if ($platform =~ /(?:darwin|bsdos)/i) { } 0 3 3
elsif ($platform =~ /(OS2|Win|DOS)/i) { } 0 3 3
elsif ($platform =~ /^Mac(?:OS|intosh)?$/i) { } 0 3 3
elsif ($platform =~ /^VMS$/i) { } 0 3 3
662 {
663 0 $self->{platform} = 'Unix';
664 }
665 elsif ($platform =~ /(OS2|Win|DOS)/i)
666 { #20000403
667 0 $self->{platform} = 'PC';
668 }
669 elsif ($platform =~ /^Mac(?:OS|intosh)?$/i)
670 {
671 0 $self->{platform} = 'Mac';
672 }
673 elsif ($platform =~ /^VMS$/i)
674 {
675 0 $self->{platform} = 'VMS';
676 }
677 else
678 {
679 3 $self->{platform} = 'Unix';
680 }
681 3 return (1);
682 }
683  
684 sub set_db_dir
685 3 ▶{
Subroutine set_db_dir: called CC=5 SCAR=19.1
Pod documented
686 3 my ($self, $directory) = @_;
687 3 ▶ return (0) unless ($directory);
Branch: 1 branch
BranchTrueFalseTotal
unless $directory 0 3 3
688  
689 3 stat ($directory);
690  
691 #if ( (-d _) && (-e _) && (-r _) && (-w _) ) { #20000103: REMD WRITABLE REQUIREMENT!
692 3 ▶ if ( (-d _) && (-e _) && (-r _) ) {
Branch: 1 branch
BranchTrueFalseTotal
if (-d _ and -e _ and -r _) { } 3 0 3
Condition33%2/6
-d _ and -e _ and -r _
!ll&&!rl&&r
003
-d _ and -e _
!ll&&!rl&&r
003
MC/DC0%0/3
-d _ and -e _ and -r _
-d _ -e _ -r _
Truth table25%1/4
A and B and C
A= -d _B= -e _C= -r _
ABCresult
0XX0
10X0
1100
1111
693 3 $self->{directory} = $directory;
694 3 return (1);
695 } else {
696 0 return (0);
697 }
698 }
699  
700 sub set_db_ext #JWT:ADD FILE EXTENSIONS.
701 3 ▶{
Subroutine set_db_ext: called CC=2 SCAR=7.0
Pod documented
702 3 my ($self, $ext) = @_;
703  
704 3 ▶ return (0) unless ($ext);
Branch: 1 branch
BranchTrueFalseTotal
unless $ext 0 3 3
705  
706 3 stat ($ext);
707  
708 3 $self->{ext} = $ext;
709 3 return (1);
710 }
711  
712 sub get_path_info
713 18 ▶{
Subroutine get_path_info: called CC=4 SCAR=14.1
Pod undocumented
714 18 my ($self, $file) = @_;
715 18 my ($separator, $path, $name, $full);
716 18 $separator = $self->{separator}->{ $self->{platform} };
717  
718 18 ($path, $name) = $file =~ m|(.*?)([^$separator]+)$|o;
719  
720 18 ▶ $name =~ tr/A-Z/a-z/ unless ($self->{CaseTableNames}); #JWT:TABLE-NAMES ARE NOW CASE-INSENSITIVE!
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"CaseTableNames"} 18 0 18
721 18 ▶ if ($path) {
Branch: 1 branch
BranchTrueFalseTotal
if ($path) { } 0 18 18
722 0 $full = $file;
723 } else {
724 #$path = $self->{directory} || fastcwd;
725 18 $path = $self->{directory};
726 18 $path .= $separator;
727 18 $full = $path . $name;
728 }
729 18 ▶ return wantarray ? ($path, $name) : $full;
Branch: 1 branch
BranchTrueFalseTotal
wantarray ? : 10 8 18
730 }
731  
732 sub set_lock_file
733 0 ▶{
Subroutine set_lock_file: not called CC=3 SCAR=24.8
Pod documented
734 0 my ($self, $file, $lock_try) = @_;
735  
736 0 ▶ if (!$file || !$lock_try) {
Branch: 1 branch
BranchTrueFalseTotal
if (not $file && $lock_try) { } 0 0 0
Condition0%0/3
$file && $lock_try
!ll&&!rl&&r
000
MC/DC0%0/2
$file && $lock_try
$file $lock_try
Truth table0%0/3
A && B
A= $fileB= $lock_try
ABresult
0X0
100
111
737 0 return (0);
738 } else {
739 0 $self->{sprite_lock_file} = $file;
740 0 $self->{sprite_lock_try} = $lock_try;
741
742 0 return (1);
743 }
744 }
745  
746 sub lock
747 0 ▶{
Subroutine lock: not called CC=5 SCAR=34.0
Pod undocumented
748 0 my $self = shift;
749 0 my $count;
750  
751 0 ▶ $self->{sprite_lock_file} ||= $self->{default_lock};
Condition0%0/3
$self->{"sprite_lock_file"} ||= $self->{"default_lock"}
l!l&&r!l&&!r
000
MC/DC0%0/2
$self->{"sprite_lock_file"} ||= $self->{"default_lock"}
$self->{"sprite_lock_file"} $self->{"default_lock"}
Truth table0%0/3
A ||= B
A= $self->{"sprite_lock_file"}B= $self->{"default_lock"}
ABresult
1X1
011
000
752 0 $self->{sprite_lock_file} = $self->get_path_info ($self->{sprite_lock_file});
753 0 ▶ $self->{sprite_lock_try} ||= $self->{default_try};
Condition0%0/3
$self->{"sprite_lock_try"} ||= $self->{"default_try"}
l!l&&r!l&&!r
000
MC/DC0%0/2
$self->{"sprite_lock_try"} ||= $self->{"default_try"}
$self->{"sprite_lock_try"} $self->{"default_try"}
Truth table0%0/3
A ||= B
A= $self->{"sprite_lock_try"}B= $self->{"default_try"}
ABresult
1X1
011
000
754  
755 0 local *FILE;
756  
757 0 $count = 0;
758  
759 0 ▶ while (++$count <= $self->{sprite_lock_try}) {
Branch: 1 branch
BranchTrueFalseTotal
if (++$count <= $self->{"sprite_lock_try"}) 0 0 0
760 0 ▶ if (sysopen (FILE, $self->{sprite_lock_file},
Branch: 1 branch
BranchTrueFalseTotal
if (sysopen FILE, $self->{'sprite_lock_file'}, 193, 420) { } 0 0 0
761 O_WRONLY|O_EXCL|O_CREAT, 0644)) {
762  
763 0 $self->{fake_lock} = 1;
764 0 $self->{lock_handle} = *FILE;
765  
766 0 last;
767 } else {
768 0 select (undef, undef, undef, $self->{lock_sleep});
769 }
770 }
771  
772 0 return $self->{fake_lock};
773 }
774  
775 sub unlock
776 4 ▶{
Subroutine unlock: called CC=4 SCAR=22.3
Pod undocumented
777 4 my $self = shift;
778  
779 4 ▶ if ($self->{fake_lock}) {
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{"fake_lock"}) 0 4 4
780  
781 0 ▶ close ($self->{lock_handle}) || return (0);
Branch: 1 branch
BranchTrueFalseTotal
close $self->{"lock_handle"} or return 0 0 0 0
782 0 ▶ unlink ($self->{sprite_lock_file}) || return (0);
Branch: 1 branch
BranchTrueFalseTotal
unlink $self->{"sprite_lock_file"} or return 0 0 0 0
783
784 0 $self->{fake_lock} = 0;
785 0 $self->{lock_handle} = '';
786  
787 }
788  
789 4 return (1);
790 }
791  
792 sub sql
793 13 ▶{
Subroutine sql: called CC=10 SCAR=24.8
Pod documented
794 13 my ($self, $query) = @_;
795 13 my ($command, $status);
796  
797 13 ▶ return wantarray ? () : -514 unless ($query);
Branch: 2 branches
BranchTrueFalseTotal
unless $query 0 13 13
wantarray ? : 0 0 0
798  
799 13 $sprite_user = $self->{'dbuser'}; #ADDED 20011026.
800 13 $self->{lasterror} = 0;
801 13 $self->{lastmsg} = '';
802 #$query =~ s/\n/ /gs; #REMOVED 20011107
803 13 $query =~ s/^\s*(.*?)\s*$/$1/s;
804 13 $command = '';
805  
806 13 ▶ if ($query =~ /^($self->{commands})/io)
Branch: 1 branch
BranchTrueFalseTotal
if ($query =~ /^($self->{'commands'})/io) { } 13 0 13
807 {
808 13 $command = $1;
809 13 $command =~ tr/A-Z/a-z/; #ADDED 19991202!
810 13 $status = $self->$command ($query);
811 13 ▶ if (ref ($status) eq 'ARRAY')
Branch: 1 branch
BranchTrueFalseTotal
if (ref $status eq 'ARRAY') { } 6 7 13
812 { #SELECT RETURNED OK (LIST OF RECORDS).
813 #unshift (@$status, 1);
814  
815 6 ▶ return wantarray ? @$status : $status;
Branch: 1 branch
BranchTrueFalseTotal
wantarray ? : 6 0 6
816 }
817 else
818 {
819 7 ▶ if ($status < 0)
Branch: 1 branch
BranchTrueFalseTotal
if ($status < 0) { } 1 6 7
820 { #SQL RETURNED AN ERROR!
821 1 $self->display_error ($status);
822 #return ($status);
823 1 ▶ return wantarray ? () : $status;
Branch: 1 branch
BranchTrueFalseTotal
wantarray ? : 1 0 1
824 }
825 else
826 { #SQL RETURNED OK.
827 6 ▶ return wantarray ? ($status) : $status;
Branch: 1 branch
BranchTrueFalseTotal
wantarray ? : 6 0 6
828 }
829 }
830 }
831 else
832 {
833 0 ▶ return wantarray ? () : -514;
Branch: 1 branch
BranchTrueFalseTotal
wantarray ? : 0 0 0
834 }
835 }
836  
837 sub display_error
838 1 ▶{
Subroutine display_error: called CC=6 SCAR=19.4
Pod undocumented
839 1 my ($self, $error) = @_;
840  
841 1 ▶ my $other = $@ || $! || 'None';
Condition40%2/5
$@ || $! || 'None'
l!l
10
$@ or $!
l!l&&r!l&&!r
010
MC/DC0%0/2
$@ || $! || 'None'
$@ $!
Truth table33%1/3
A or B
A= $@B= $!
ABresult
1X1
011
000
842  
843 1 ▶ print STDERR <<Error_Message unless ($self->{silent});
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"silent"} 0 1 1
844  
845 Oops! Sprite encountered the following error when processing your request:
846  
847 ($error) $self->{errors}->{$error} ($errdetails)
848  
849 Here's some more information to help you:
850  
851 file: $self->{file}
852 $other
853  
854 Error_Message
855  
856 #JWT: ADDED FOR ERROR-CONTROL.
857  
858 1 $self->{lasterror} = $error;
859 1 $self->{lastmsg} = "$error:" . $self->{errors}->{$error};
860 1 ▶ $self->{lastmsg} .= '('.$errdetails.')' if ($errdetails); #20000114
Branch: 1 branch
BranchTrueFalseTotal
if $errdetails 1 0 1
861  
862 1 $errdetails = ''; #20000114
863 1 ▶ die $self->{lastmsg} if ($self->{RaiseError}); #20000114.
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"RaiseError"} 0 1 1
864  
865 1 return (1);
866 }
867  
868 sub commit
869 4 ▶{
Subroutine commit: called CC=15 SCAR=37.9
Pod documented
870 4 my ($self, $file) = @_;
871 4 my ($status, $full_path);
872  
873 4 $status = 1;
874 4 ▶ return $status unless ($self->{dirty});
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"dirty"} 1 3 4
875  
876 3 ▶ if ($file)
Branch: 1 branch
BranchTrueFalseTotal
if ($file) { } 3 0 3
877 {
878 3 $full_path = $self->get_path_info ($file);
879 3 ▶ $full_path .= $self->{ext} if ($self->{ext}); #JWT:ADD FILE EXTENSIONS.
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"ext"} 3 0 3
880 }
881 else #ADDED 20010911 TO ASSIST IN HANDLING AUTOCOMMIT!
882 {
883 0 $full_path = $self->{file};
884 }
885 3 $status = $self->write_file ($full_path);
886 3 ▶ $self->display_error ($status) if ($status <= 0);
Branch: 1 branch
BranchTrueFalseTotal
if $status <= 0 0 3 3
887  
888 3 ▶ return undef if ($status <= 0); #ADDED 20000103
Branch: 1 branch
BranchTrueFalseTotal
if $status <= 0 0 3 3
889  
890 3 my $blobglob = $full_path;
891 3 $blobglob =~ s/$self->{ext}$/\_\*\_$$\.tmp/;
892 3 my @tempblobs;
893 3 eval qq|\@tempblobs = <$blobglob>|;
894 3 my ($blobfile, $tempfile);
895 3 my $bloberror = 0;
896 3 ▶ while (@tempblobs)
Branch: 1 branch
BranchTrueFalseTotal
if (@tempblobs) 0 3 3
897 {
898 0 $tempfile = shift(@tempblobs);
899 0 $blobfile = $tempfile;
900 0 $blobfile =~ s/\_$$\.tmp/\.ldt/;
901 0 ▶ unlink $blobfile if ($self->{sprite_forcereplace} && -w $blobfile && -e $tempfile);
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"sprite_forcereplace"} and -w $blobfile and -e $tempfile 0 0 0
Condition0%0/6
$self->{"sprite_forcereplace"} and -w $blobfile and -e $tempfile
!ll&&!rl&&r
000
$self->{"sprite_forcereplace"} and -w $blobfile
!ll&&!rl&&r
000
MC/DC0%0/3
$self->{"sprite_forcereplace"} and -w $blobfile and -e $tempfile
$self->{"sprite_forcereplace"} -w $blobfile -e $tempfile
Truth table0%0/4
A and B and C
A= $self->{"sprite_forcereplace"}B= -w $blobfileC= -e $tempfile
ABCresult
0XX0
10X0
1100
1111
902 0 ▶ $bloberror = $?.':'.$@ if ($?);
Branch: 1 branch
BranchTrueFalseTotal
if $? 0 0 0
903 0 ▶ rename ($tempfile, $blobfile) or ($bloberror = "Could not rename $tempfile to $blobfile (".$!.')');
Branch: 1 branch
BranchTrueFalseTotal
rename $tempfile, $blobfile or $bloberror = "Could not rename $tempfile to $blobfile (" . $! . ')' 0 0 0
904 0 ▶ last if ($bloberror);
Branch: 1 branch
BranchTrueFalseTotal
if $bloberror 0 0 0
905 }
906 3 ▶ if ($bloberror)
Branch: 1 branch
BranchTrueFalseTotal
if ($bloberror) { } 0 3 3
907 {
908 0 $errdetails = $bloberror;
909 0 $self->display_error (-528);
910 0 return undef;
911 }
912 else
913 {
914 $blobglob = $self->{directory}.$self->{separator}->{ $self->{platform} }
915 3 .$self->{table}."_*_$$.del";
916 3 @tempblobs = ();
917 3 eval qq|\@tempblobs = <$blobglob>|;
918 3 ▶ while (@tempblobs)
Branch: 1 branch
BranchTrueFalseTotal
if (@tempblobs) 0 3 3
919 {
920 0 $tempfile = shift(@tempblobs);
921 0 unlink $tempfile;
922 }
923 3 $self->{dirty} = 0;
924 }
925 3 return $status;
926 }
927  
928 sub xclose
929 0 ▶{
Subroutine xclose: not called CC=1 SCAR=6.9
Pod undocumented
930 0 my ($self, $file) = @_;
931
932 0 my $status = $self->commit($file);
933 0 undef $self;
934  
935 0 return $status;
936 }
937  
938 ##++
939 ## Private Methods
940 ##--
941  
942 sub define_errors
943 3 ▶{
Subroutine define_errors: called CC=1 SCAR=0.0
Pod undocumented
944 3 my $self = shift;
945 3 my $errors;
946  
947 3 $errors = {};
948  
949 3 $errors->{'-501'} = 'Could not open specified database.';
950 3 $errors->{'-502'} = 'Specified column(s) not found.';
951 3 $errors->{'-503'} = 'Incorrect format in [select] statement.';
952 3 $errors->{'-504'} = 'Incorrect format in [update] statement.';
953 3 $errors->{'-505'} = 'Incorrect format in [delete] statement.';
954 3 $errors->{'-506'} = 'Incorrect format in [add/drop column] statement.';
955 3 $errors->{'-507'} = 'Incorrect format in [alter table] statement.';
956 3 $errors->{'-508'} = 'Incorrect format in [insert] command.';
957 3 $errors->{'-509'} = 'The no. of columns does not match no. of values.';
958 3 $errors->{'-510'} = 'A severe error! Check your query carefully.';
959 3 $errors->{'-511'} = 'Cannot write the database to output file.';
960 3 $errors->{'-512'} = 'Unmatched quote in expression.';
961 3 $errors->{'-513'} = 'Need to open the database first!';
962 3 $errors->{'-514'} = 'Please specify a valid query.';
963 3 $errors->{'-515'} = 'Cannot get lock on database file.';
964 3 $errors->{'-516'} = 'Cannot delete temp. lock file.';
965 3 $errors->{'-517'} = "Built-in function failed ($@).";
966 3 $errors->{'-518'} = "Unique Key Constraint violated."; #JWT.
967 3 $errors->{'-519'} = "Field would have to be truncated."; #JWT.
968 3 $errors->{'-520'} = "Can not create existing table (drop first!)."; #20000225 JWT.
969 3 $errors->{'-521'} = "Can not change datatype on non-empty table."; #20000323 JWT.
970 3 $errors->{'-522'} = "Can not decrease field-size on non-empty table."; #20000323 JWT.
971 3 $errors->{'-523'} = "Special table \"DUAL\" is READONLY!"; #20000323 JWT.
972 3 $errors->{'-524'} = "Can't store non-NULL value into AUTOSEQUENCE!"; #20011029 JWT.
973 3 $errors->{'-525'} = "Can't update AUTOSEQUENCE field!"; #20011029 JWT.
974 3 $errors->{'-526'} = "Can't find encryption modules"; #20011029 JWT.
975 3 $errors->{'-527'} = "Database illedgable - wrong encryption key/method?"; #20011029 JWT.
976 3 $errors->{'-528'} = "Could not read/write BLOB file!"; #20011029 JWT.
977 3 $errors->{'-529'} = "Conversion between BLOB and nonBLOB types not (yet) supported!"; #20011029 JWT.
978 3 $errors->{'-530'} = 'Incorrect format in [create] command.'; #ADDED 20020222
979 3 $errors->{'-531'} = 'Encryption of XML databases not supported.'; #ADDED 20020516.
980 3 $errors->{'-532'} = 'XML requested, but XML::Simple module not available!'; #ADDED 20020516.
981 3 $errors->{'-533'} = 'Incorrect format in [truncate] statement.';
982 3 $self->{errors} = $errors;
983  
984 3 return (1);
985 }
986  
987 sub parse_expression
988 4 ▶{
Subroutine parse_expression: called CC=45 SCAR=44.9
Pod undocumented
989 4 my ($self, $query, $colmlist) = @_;
990 4 ▶ return unless ($query);
Branch: 1 branch
BranchTrueFalseTotal
unless $query 0 4 4
991 4 my ($column, @strings, %numopmap, %stropmap, $numops, $strops, $special);
992 4 ▶ $colmlist ||= join('|',@{$self->{order}});
Condition33%1/3
$colmlist ||= join("|", @{$self->{"order"};})
l!l&&r!l&&!r
040
MC/DC0%0/2
$colmlist ||= join("|", @{$self->{"order"};})
$colmlist join("|", @{$self->{"order"};})
Truth table33%1/3
A ||= B
A= $colmlistB= join("|", @{$self->{"order"};})
ABresult
1X1
011
000
993 4 my ($psuedocols) = "CURRVAL|NEXTVAL";
994  
995 4 ▶ unless ($colmlist =~ /\S/o)
Branch: 1 branch
BranchTrueFalseTotal
unless ($colmlist =~ /\S/o) 0 4 4
996 {
997 0 ▶ $self->{file} =~ tr/A-Z/a-z/ unless ($self->{CaseTableNames}); #JWT:TABLE-NAMES ARE NOW CASE-INSENSITIVE!
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"CaseTableNames"} 0 0 0
998 #$thefid = $self->{file};
999 0 $colmlist = &load_columninfo($self, '|');
1000 0 ▶ return $colmlist if ($colmlist =~ /^\-?\d+$/o);
Branch: 1 branch
BranchTrueFalseTotal
if $colmlist =~ /^\-?\d+$/o 0 0 0
1001 }
1002 4 $column = $self->{column};
1003 4 @strings = ();
1004  
1005 4 %numopmap = ( '=' => 'eq', '==' => 'eq', '>=' => 'ge', '<=' => 'le',
1006 '>' => 'gt', '<' => 'lt', '!=' => 'ne', '<>' => 'ne');
1007 4 %stropmap = ( 'eq' => '==', 'ge' => '>=', 'le' => '<=', 'gt' => '>',
1008 'lt' => '<', 'ne' => '!=' , '=' => '==');
1009  
1010 4 $numops = join '|', keys %numopmap;
1011 4 $strops = join '|', keys %stropmap;
1012  
1013 4 $special = "$strops|and|or";
1014 #NOTE!: NEVER USE ANY VALUE OF $special AS A COLUMN NAME IN YOUR TABLES!!
1015  
1016 ##++
1017 ## The expression: "([^"\\]*(\\.[^"\\]*)*)" was provided by
1018 ## Jeffrey Friedl. Thanks Jeffrey!
1019 ##--
1020  
1021 4 $query =~ s/\\\\/\x02\^2jSpR1tE\x02/gso; #PROTECT "\\" #XCHGD. TO 2 LINES DOWN 20020111
1022 #$query =~ s/\\\'|\'\'/\x02\^3jSpR1tE\x02/gs; #CHGD. TO NEXT 20040305 2 FIX PERL BUG? UNPROTECT WON'T WORK IF STR="m'str\x02..\x02more'"?!?!?!
1023 4 $query =~ s/\\\'|\'\'/\^3jSpR1tE/gso; #20000201 #PROTECT "", \", '', AND \'.
1024  
1025 4 my ($i, $j, $j2, $k);
1026 4 ▶my $caseopt = ($self->{sprite_nocase} ? 'i' : ''); #ADDED 20040325.
Branch: 1 branch
BranchTrueFalseTotal
$self->{'sprite_nocase'} ? : 0 4 4
1027  
1028 4 while (1)
1029 {
1030 6 $i = 0;
1031 6 $i = ($query =~ s|\b($colmlist)\s+not\s+like\s+|$1 !^ |is);
1032 6 ▶ $i = ($query =~ s|\b($colmlist)\s+like\s+|$1 =^ |is) unless ($i);
Branch: 1 branch
BranchTrueFalseTotal
unless $i 6 0 6
1033 6 ▶ if ($i)
Branch: 1 branch
BranchTrueFalseTotal
if ($i) { } 2 4 6
1034 {
1035 #if ($query =~ /([\=\!]\^\s*)(["'])(.*?)\2/s) #CHGD. TO NEXT 20040325.
1036 2 ▶ if ($query =~ s/([\=\!]\^\s*)(["'])(.*?)\2/$1$2$3$2$caseopt/s) #20001010
Branch: 1 branch
BranchTrueFalseTotal
if ($query =~ s/([\=\!]\^\s*)(["'])(.*?)\2/$1$2$3$2$caseopt/s) 1 1 2
1037 {
1038 1 $j = "$1$2"; #EVERYTHING BEFORE THE QUOTE (DELIMITER), INCLUSIVE
1039 1 $i = $3; #THE STUFF BETWEEN THE QUOTES.
1040 1 my $iquoted = $i; #ADDED 20000816 TO FIX "LIKE 'X.%'" (X\.%)!
1041 1 $iquoted =~ s/([\\\|\(\)\[\{\^\$\*\+\?\.])/\\$1/gs;
1042 1 my ($k) = "\^$iquoted\$";
1043 1 $k =~ s/^\^%//so;
1044 1 $k =~ s/%\$$//s;
1045 1 $j2 = $j;
1046 #$j2 =~ s/^\^/~/; #CHANGE SPECIAL OPERATORS (=^ AND !^) BACK TO (=~ AND !~).
1047 1 $j2 =~ s/^(.)\^/$1~/s; #20001010 CHANGE SPECIAL OPERATORS (=^ AND !^) BACK TO (=~ AND !~).
1048 1 $k =~ s/_/./gso;
1049 1 $query =~ s/\Q$j$i\E/$j2$k/s;
1050 }
1051 }
1052 else
1053 {
1054 4 last;
1055 }
1056 }
1057
1058 #$query =~ s/([!=][~\^])\s*(m)?([^\w;\s])([^\3\\]*(?:\\.[^\3\\]*)*)\3(i)?/
1059 #THIS REGEX LOOKS FOR USER-DEFINED FUNCTIONS FOLLOWING "=~ OR !~ (LIKE),
1060 #FINDS THE MATCHING CLOSE PARIN(IF ANY), AND SURROUNDS THE FUNCTION AND
1061 #IT'S ARGS WITH AN "&", A DELIMITER LATER USED TO EVAL IT.
1062
1063 4 ▶ 1 while ($query =~ s|([!=][~\^])\s*([a-zA-Z_]+)(.*)$|
Branch: 1 branch
BranchTrueFalseTotal
$query =~ s[([!=][~\^])\s*([a-zA-Z_]+)(.*)$][() = ($1, $2, $3); my($parincnt) = 0; my @lx = split(//, $three, 0); my $i; for ($i = 0; $i <= length $three; ++$i) { ++$parincnt if $lx[$i] eq "("; last unless $parincnt; --$parincnt if $lx[$i] eq ")"; } ; "$one " . '&' . "$two" . substr($three, 0, $i) . '&' . substr($three, $i);]es and do { '???' } 1 4 5
1064 1 my ($one, $two, $three) = ($1, $2, $3);
1065 1 my ($parincnt) = 0;
1066 1 my (@lx) = split('', $three);
1067 1 my ($i);
1068
1069 1 ▶ for ($i=0;$i<=length($three);$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= length $three) 12 0 12
1070 {
1071 12 ▶ ++$parincnt if ($lx[$i] eq '(');
Branch: 1 branch
BranchTrueFalseTotal
if $lx[$i] eq "(" 1 11 12
1072 12 ▶ last unless ($parincnt);
Branch: 1 branch
BranchTrueFalseTotal
unless $parincnt 1 11 12
1073 11 ▶ --$parincnt if ($lx[$i] eq ')');
Branch: 1 branch
BranchTrueFalseTotal
if $lx[$i] eq ")" 1 10 11
1074 }
1075 1 "$one ".'&'."$two".substr($three,0,$i).'&'.
1076 substr($three,$i);
1077 |es);
1078  
1079 #THIS REGEX HANDLES ALL OTHER LIKE AND PERL "=~" AND "!~" OPERATORS.
1080  
1081 4 @perlconds = ();
1082 4 $query =~ s%\b($colmlist)\s*([!=][~\^])\s*(m)?(.)([^\4]*?)\4(i)?% #20011017: CHGD TO NEXT.
1083 3 my ($m, $i, $delim, $four, $one, $fldname) = ($3, $6, $4, $5, $2, $1);
1084 3 my ($catchmatch) = 0;
1085 3 ▶ $m ||= ''; $i ||= '';
Condition50%2/4
$m ||= ""
l!l
03
$i ||= ""
l!l
03
MC/DC0%0/1
$m ||= ""
$m
MC/DC0%0/1
$i ||= ""
$i
Truth table50%1/2
A
A= $m
Aresult
11
00
Truth table50%1/2
A
A= $i
Aresult
11
00
1086 3 ▶ $m = 'm' unless ($delim eq '/');
Branch: 1 branch
BranchTrueFalseTotal
unless $delim eq "/" 3 0 3
1087 3 my ($three) = $delim;
1088 3 $four =~ s/\\\(/\x02\^5jSpR1tE\x02/gso;
1089 3 $four =~ s/\\\)/\x02\^6jSpR1tE\x02/gso;
1090 3 ▶ if ($four =~ /\(.*\)/)
Branch: 1 branch
BranchTrueFalseTotal
if ($four =~ /\(.*\)/) 2 1 3
1091 {
1092 #$four =~ s/\(//g;
1093 #$four =~ s/\)//g;
1094 2 $catchmatch = 1;
1095 }
1096 3 $four =~ s/\x02\^5jSpR1tE\x02/\(/gso;
1097 3 $four =~ s/\x02\^6jSpR1tE\x02/\)/gso;
1098 3 push (@strings, "$m$delim$four$three$i");
1099 3 ▶ push (@perlconds, "\$_->{$fldname} $one *$#strings; push (\@perlmatches, \$1) if (defined \$1); push (\@perlmatches, \$2) if (defined \$2);") if ($catchmatch);
Branch: 1 branch
BranchTrueFalseTotal
if $catchmatch 2 1 3
1100 3 "$fldname $one *$#strings";
1101 %geis;
1102 #$query =~ s|(['"])([^\1\\]*(?:\\.[^\1\\]*)*)\1|
1103 4 $query =~ s|(["'])(.*?)\1|
1104 2 push (@strings, "$1$2$1"); "*$#strings";
1105 |ges;
1106  
1107 4 $query =~ s/\x02\^3jSpR1tE\x02/\'/gso; #RESTORE PROTECTED SINGLE QUOTES HERE.
1108 4 $query =~ s/\^3jSpR1tE/\'/gso; #ADDED 20040913 RESTORE PROTECTED SINGLE QUOTES HERE.
1109 #$query =~ s/\x02\^2jSpR1tE\x02/\\/gs; #RESTORE PROTECTED SLATS HERE. #CHGD. TO NEXT 20020111
1110 4 $query =~ s/\x02\^2jSpR1tE\x02/\\\\/gso; #RESTORE PROTECTED SLATS HERE.
1111 4 for $i (0..$#strings)
1112 {
1113 #$strings[$i] =~ s/\x02\^3jSpR1tE\x02/\\\'/gs; #CHGD. TO NEXT IF-STMT. 20040503.
1114 #### NOTE: STRING MUST *NOT* CONTAIN BOTH SINGLE-QUOTES AND GRAVS AND "^"S!!!!!
1115 5 ▶ if ($strings[$i] =~ /^m\'/o) #TEST MODIFIED 20050429 TO FIX BUG - IF STRING IS LIKE, THEN CHANGE m'str' to m`str` and restore ' UNESCAPED!
Branch: 1 branch
BranchTrueFalseTotal
if ($strings[$i] =~ /^m\'/o) { } 2 3 5
1116 { #ALSO HAD 2 REMOVE "\X02" BRACKETS ON RESERVED STR. (PERL BUG?)
1117 2 $strings[$i] =~ s/\^3jSpR1tE/\'/gso; #RESTORE PROTECTED SINGLE QUOTES HERE.
1118 2 ▶ if ($string !~ /\`/o) #NO GRAVS IN STRING, SAVE TO BRACKET W/GRAVS.
Branch: 1 branch
BranchTrueFalseTotal
if (not $string =~ /\`/o) { } 2 0 2
1119 {
1120 2 $strings[$i] =~ s/^m\'/m\`/o;
1121 2 $strings[$i] =~ s/\'${caseopt}$/\`$caseopt/; #JWT:MODIFIED 20150123 TO INCLUDE $caseopt TO FIX BUG W/sprite_nocase
1122 }
1123 else #GRAVS TAKEN TOO, TRY "^" FOR BRACKET CHAR. IF BOTH GRAVS & "^" TAKEN, THEN PUNT!
1124 {
1125 0 $strings[$i] =~ s/^m\'/m\^/o;
1126 0 $strings[$i] =~ s/\'${caseopt}$/\^$caseopt/; #JWT:MODIFIED 20150123 TO INCLUDE $caseopt TO FIX BUG W/sprite_nocase
1127 }
1128 }
1129 else
1130 {
1131 3 $strings[$i] =~ s/\^3jSpR1tE/\\\'/gso; #RESTORE PROTECTED SINGLE QUOTES HERE.
1132 }
1133 5 $strings[$i] =~ s/\x02\^2jSpR1tE\x02/\\\\/gso; #RESTORE PROTECTED SLATS HERE.
1134 }
1135  
1136 4 ▶ if ($query =~ /^($column)$/)
Branch: 1 branch
BranchTrueFalseTotal
if ($query =~ /^($column)$/) 0 4 4
1137 {
1138 0 $i = $1;
1139 #$query = '&' . $i unless ($i =~ $colmlist); #CHGD. TO NEXT (20011019)
1140 0 ▶ $query = '&' . $i unless ($i =~ m/($colmlist)/i);
Branch: 1 branch
BranchTrueFalseTotal
unless $i =~ /($colmlist)/i 0 0 0
1141 }
1142  
1143 4 $query =~ s#\b($colmlist)\s*($numops)\s*\*#$1 $numopmap{$2} \*#gis;
1144 4 $query =~ s#\b($colmlist)\s*($numops)\s*\'#$1 $numopmap{$2} \'\'#gis;
1145 4 $query =~ s#\b($colmlist)\s*($numops)\s*($colmlist)#$1 $numopmap{$2} $3#gis;
1146 #$query =~ s#\b($colmlist)\s*($numops)\s*($column(?:\(.*?\))?)#$1 $numopmap{$2} $3#gi;
1147 4 $query =~ s%\b($column\s*(?:\(.*?\))?)\s+is\s+null%$1 eq ''%igs;
1148 4 $query =~ s%\b($column\s*(?:\(.*?\))?)\s+is\s+not\s+null%$1 ne ''%igs;
1149 #$query =~ s%\b($colmlist)\s*(?:\(.*?\))?)\s*($numops)\s*CURRVAL%$1 $2 &pscolfn($self,$3)%gi;
1150 0 $query =~ s%($column)\s*($numops)\s*($column\.(?:$psuedocols))%"$1 $2 ".&pscolfn($self,$3)%egs;
1151 #$query =~ s%\b($column\s*(?:\(.*?\))?)\s*($numops)\s*($column\s*(?:\(.*?\))?)% #CHGD. TO NEXT 20020108 TO FIX BUG WHEN WHERE-CLAUSE TESTED EQUALITY WITH NEGATIVE CONSTANTS.
1152 4 $query =~ s%\b($column\s*(?:\(.*?\))?)\s*($numops)\s*((?:[\+\-]?[0..9+-\.Ee]+|$column)\s*(?:\(.*?\))?)%
1153 0 my ($one,$two,$three) = ($1,$2,$3);
1154 0 $one =~ s/\s+$//;
1155 0 my $ONE = $one;
1156 0 ▶ $ONE =~ tr/a-z/A-Z/ unless ($self->{sprite_CaseFieldNames});
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"sprite_CaseFieldNames"} 0 0 0
1157 0 ▶ if ($one =~ /NUM\s*\(/ || ${$self->{types}}{$ONE} =~ /$NUMERICTYPES/io)
Branch: 1 branch
BranchTrueFalseTotal
if ($one =~ /NUM\s*\(/ or do { $$self{'types'} }->{$ONE} =~ /$NUMERICTYPES/io) { } 0 0 0
Condition0%0/3
$one =~ /NUM\s*\(/ or do { $$self{"types"} }->{$ONE} =~ /$NUMERICTYPES/io
l!l&&r!l&&!r
000
MC/DC0%0/2
$one =~ /NUM\s*\(/ or do { $$self{"types"} }->{$ONE} =~ /$NUMERICTYPES/io
$one =~ /NUM\s*\(/ do { $$self{"types"} }->{$ONE} =~ /$NUMERICTYPES/io
Truth table0%0/3
A or B
A= $one =~ /NUM\s*\(/B= do { $$self{"types"} }->{$ONE} =~ /$NUMERICTYPES/io
ABresult
1X1
011
000
1158 {
1159 0 $two =~ s/^($strops)$/$stropmap{$two}/s;
1160 0 "$one $two $three";
1161 }
1162 else
1163 {
1164 0 "$one $numopmap{$two} $three";
1165 }
1166 %egs;
1167  
1168 # (JWT 8/8/1998) $query =~ s|\b($colmlist)\s+($strops)\s+(\d+)|$1 $stropmap{$2} $3|gi;
1169 4 $query =~ s|\b($colmlist)\s*($strops)\s*(\d+)|$1 $stropmap{$2} $3|gis;
1170  
1171 4 my $ineqop = '!=';
1172 4 $query =~ s!\b($colmlist)\s*($strops)\s*(\*\d+)!
1173 2 my ($one,$two,$three) = ($1,$2,$3);
1174 2 $one =~ s/\s+$//;
1175 2 my $ONE = $one;
1176 2 ▶ $ONE =~ tr/a-z/A-Z/ unless ($self->{sprite_CaseFieldNames});
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"sprite_CaseFieldNames"} 2 0 2
1177 2 my $res;
1178 2 ▶ if ($one =~ /NUM\s*\(/ || ${$self->{types}}{$ONE} =~ /$NUMERICTYPES/ios)
Branch: 2 branches
BranchTrueFalseTotal
if ($one =~ /NUM\s*\(/ or do { $$self{'types'} }->{$ONE} =~ /$NUMERICTYPES/iso) { } 1 1 2
elsif ($self->{'StrictCharComp'} == 0 and do { $$self{'types'} }->{$ONE} eq 'CHAR') { } 0 1 1
Condition66%2/3
$one =~ /NUM\s*\(/ or do { $$self{"types"} }->{$ONE} =~ /$NUMERICTYPES/iso
l!l&&r!l&&!r
011
MC/DC50%1/2
$one =~ /NUM\s*\(/ or do { $$self{"types"} }->{$ONE} =~ /$NUMERICTYPES/iso
$one =~ /NUM\s*\(/ do { $$self{"types"} }->{$ONE} =~ /$NUMERICTYPES/iso
Truth table66%2/3
A or B
A= $one =~ /NUM\s*\(/B= do { $$self{"types"} }->{$ONE} =~ /$NUMERICTYPES/iso
ABresult
1X1
011
000
1179 {
1180 1 my ($opno) = undef; #NEXT 18 LINES ADDED 20010313 TO CAUSE STRING COMPARISENS W/NUMERIC FIELDS TO RETURN ZERO, SINCE PERL NON-NUMERIC STRINGS RETURN ZERO.
1181 1 ▶ if ($three =~ /^\*\d+/s)
Branch: 1 branch
BranchTrueFalseTotal
if ($three =~ /^\*\d+/s) { } 1 0 1
1182 {
1183 1 $opno = substr($three,1);
1184 1 $opno = $strings[$opno];
1185 1 $opno =~ s/^\'//s;
1186 1 $opno =~ s/\'$//s;
1187 }
1188 else
1189 {
1190 0 $opno = $three;
1191 }
1192 1 ▶ unless ($opno =~ /^[\+\-\d\.][\d\.Ex\+\-\_]*$/s) #ARGUMENT IS A VALID NUMBER.
Branch: 1 branch
BranchTrueFalseTotal
if ($opno =~ /^[\+\-\d\.][\d\.Ex\+\-\_]*$/s) { } 1 0 1
1193 {
1194 # $res = '0';
1195 # $res = '1' if ($two eq $ineqop);
1196 0 $res = "$one $two '0'";
1197 }
1198 else
1199 {
1200 1 ▶ $two =~ s/^($strops)$/$stropmap{$two}/s unless ($opno eq "0");
Branch: 1 branch
BranchTrueFalseTotal
unless $opno eq 0 1 0 1
1201 1 $res = "$one $two $three";
1202 }
1203 }
1204 1 ▶ elsif ($self->{StrictCharComp} == 0 && ${$self->{types}}{$ONE} eq 'CHAR')
Condition33%1/3
$self->{"StrictCharComp"} == 0 and do { $$self{"types"} }->{$ONE} eq "CHAR"
!ll&&!rl&&r
010
MC/DC0%0/2
$self->{"StrictCharComp"} == 0 and do { $$self{"types"} }->{$ONE} eq "CHAR"
$self->{"StrictCharComp"} == 0 do { $$self{"types"} }->{$ONE} eq "CHAR"
Truth table33%1/3
A and B
A= $self->{"StrictCharComp"} == 0B= do { $$self{"types"} }->{$ONE} eq "CHAR"
ABresult
0X0
100
111
1205 {
1206 0 my ($opno) = undef; #NEXT 18 LINES ADDED 20010313 TO CAUSE STRING COMPARISENS W/NUMERIC FIELDS TO RETURN ZERO, SINCE PERL NON-NUMERIC STRINGS RETURN ZERO.
1207 0 ▶ if ($three =~ /^\*\d+/)
Branch: 1 branch
BranchTrueFalseTotal
if ($three =~ /^\*\d+/) 0 0 0
1208 {
1209 0 $opno = substr($three,1);
1210 0 my $opstr = $strings[$opno];
1211 0 $opstr =~ s/^\'//s;
1212 0 $opstr =~ s/\'$//s;
1213 $strings[$opno] = "'" . sprintf(
1214 0 '%-'.${$self->{lengths}}{$ONE}.'s',
1215 $opstr) . "'";
1216 }
1217 0 $res = "$one $two $three";
1218 }
1219 else
1220 {
1221 1 $res = "$one $two $three";
1222 }
1223 2 $res;
1224 !egis;
1225  
1226 #NOTE!: NEVER USE ANY VALUE OF $special AS A COLUMN NAME IN YOUR TABLES!!
1227 #20000224 ADDED "\b" AFTER "$special)" 5 LINES BELOW!
1228 4 $query =~ s!\b(($colmlist))\b!
1229 5 my $match = $1;
1230 5 ▶ $match =~ tr/a-z/A-Z/ unless ($self->{sprite_CaseFieldNames});
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"sprite_CaseFieldNames"} 5 0 5
1231 5 ▶ ($match =~ /\b(?:$special)\b/ios) ? "\L$match\E" :
Branch: 1 branch
BranchTrueFalseTotal
$match =~ /\b(?:$special)\b/iso ? : 0 5 5
1232 "\$_->{$match}"
1233 !geis;
1234 4 $query =~ s/ (and|or|not) / \L$1\E /igs; #ADDED 20001011 TO FIX BUG THAT DIDN'T ALLOW UPPER-CASE BOOLOPS! 20001215: SPACES ADDED TO PREVENT "$_->{MandY}" MANGLE!
1235 4 $query =~ s|[;`]||gso;
1236 4 $query =~ s#\|\|#or#gso;
1237 4 $query =~ s#&&#and#gso;
1238  
1239 4 $query =~ s|(\d+)\s*($strops)\s*(\d+)|$1 $stropmap{$2} $3|gios; #ADDED 20010313 TO MAKE "1=0" CONDITION EVAL WO/ERROR.
1240 4 $query =~ s|\*(\d+)|$strings[$1]|gs;
1241 4 ▶ for (my $i=0;$i<=$#perlconds;$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#perlconds) 2 4 6
1242 {
1243 2 $perlconds[$i] =~ s|\*(\d+)|$strings[$1]|gs;
1244 }
1245  
1246 #THIS REGEX EVALS USER-FUNCTION CALLS FOLLOWING "=~" OR "!~".
1247 4 $query =~ s@([!=][~\^])\s*m\&([a-zA-Z_]+[^&]*)\&@
1248 1 my ($one, $two) = ($1, $2);
1249
1250 #$one =~ s/\^/\~/s; #MOVED INSIDE "UNLESS" BELOW 20040323.
1251 1 my ($res) = eval($two);
1252 1 $res =~ s/^\%//so;
1253 1 $res =~ s/\%$//so;
1254 1 my ($rtn, $isalike);
1255 1 foreach my $i ('/',"'",'"','|')
1256 {
1257 1 ▶ unless ($res =~ m%$i%)
Branch: 1 branch
BranchTrueFalseTotal
unless ($res =~ /$i/) 1 0 1
1258 {
1259 1 ▶ $isalike = 1 if ($one =~ s/\^/\~/so);
Branch: 1 branch
BranchTrueFalseTotal
if $one =~ s/\^/~/os 1 0 1
1260 1 $rtn = "$one m".$i.$res.$i;
1261 1 ▶ $rtn .= 'i' if ($self->{sprite_nocase} && $isalike);
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"sprite_nocase"} and $isalike 0 1 1
Condition33%1/3
$self->{"sprite_nocase"} and $isalike
!ll&&!rl&&r
100
MC/DC0%0/2
$self->{"sprite_nocase"} and $isalike
$self->{"sprite_nocase"} $isalike
Truth table33%1/3
A and B
A= $self->{"sprite_nocase"}B= $isalike
ABresult
0X0
100
111
1262 1 last;
1263 }
1264 }
1265 1 $rtn;
1266 @egs;
1267 4 return $query;
1268 }
1269  
1270 sub check_columns
1271 8 ▶{
Subroutine check_columns: called CC=5 SCAR=17.0
Pod undocumented
1272 8 my ($self, $column_string) = @_;
1273 8 my ($status, @columns, $column);
1274  
1275 8 $status = 1;
1276 8 ▶ unless ($self->{sprite_CaseFieldNames})
Branch: 1 branch
BranchTrueFalseTotal
unless ($self->{"sprite_CaseFieldNames"}) 8 0 8
1277 {
1278 8 ▶ $column =~ tr/a-z/A-Z/ if (defined $column); #JWT
Branch: 1 branch
BranchTrueFalseTotal
if defined $column 0 8 8
1279 8 $column_string =~ tr/a-z/A-Z/; #JWT
1280 }
1281 8 $self->{use_fields} = $column_string; #JWT
1282 8 @columns = split (/\,/o, $column_string);
1283  
1284 8 foreach $column (@columns) {
1285 #$status = 0 unless ($self->{fields}->{$column}); #20000114
1286 15 ▶ unless ($self->{fields}->{$column})
Branch: 1 branch
BranchTrueFalseTotal
unless ($self->{"fields"}{$column}) 0 15 15
1287 {
1288 0 $errdetails = $column;
1289 0 $status = 0;
1290 }
1291 }
1292  
1293 8 return $status;
1294 }
1295  
1296 sub parse_columns
1297 5 ▶{
Subroutine parse_columns: called CC=104 SCAR=76.8
Pod undocumented
1298 5 my ($self, $command, $column_string, $condition, $values,
1299 $ordercols, $descorder, $fields, $distinct) = @_;
1300 5 my ($i, $j, $k, $rowcnt, $status, @columns, $single, $loop, $code, $column);
1301 5 my (%colorder, $rawvalue);
1302 5 my (@result_index); #ADDED 20020709 TO SUPPORT SORTING ON COLUMNS NOT IN RESULT-SET.
1303  
1304 5 my ($psuedocols) = "CURRVAL|NEXTVAL"; #ADDED 20011019.
1305 5 local $results = undef;
1306 5 my (@keyfields) = split(',', $self->{key_fields}); #JWT: PREVENT DUP. KEYS.
1307 5 my (%valuenames); #ADDED 20001218 TO ALLOW FIELD-NAMES AS RIGHT-VALUES.
1308 5 foreach $i (keys %$values)
1309 {
1310 # $valuenames{$i} = $values->{$i}; #MOVED TO BOTTOM OF LOOP 20020522 TO FIX SINGLE-QUOTE-IN-VALUE (-517) BUG!
1311 0 $values->{$i} =~ s/^\'(.*)\'$/my ($stuff) = $1;
1312 0 $stuff =~ s|\'|\\\'|gso;
1313 0 $stuff =~ s|\\\'\\\'|\\\'|gso;
1314 0 "'" . $stuff . "'"/es;
1315 1 $values->{$i} =~ s/^\'$//so; #HANDLE NULL VALUES.
1316 #$values->{$i} =~ s/\n//gs; #REMOVE LFS ADDED BY NETSCAPE TEXTAREAS! #REMOVED 20011107 - ALLOW \n IN DATA!
1317 #$values->{$i} =~ s/\r /\r/gs; #20000108: FIX LFS PREV. CONVERTED TO SPACES! #REMOVED 20011107 (SHOULDN'T NEED ANYMORE).
1318 1 ▶ $values->{$i} = "''" unless ($values->{$i} =~ /\S/o);
Branch: 1 branch
BranchTrueFalseTotal
unless $values->{$i} =~ /\S/o 0 1 1
1319 1 $valuenames{$i} = $values->{$i};
1320 }
1321 0 ▶ local $SIG{'__WARN__'} = sub { $status = -510; $errdetails = "$_[0] at ".__LINE__ };
Subroutine __ANON__: not called CC=1 SCAR=2.6
1322 5 local $^W = 0;
1323 5 local ($_);
1324 5 $status = 1;
1325 5 $results = [];
1326 5 @columns = split (/,/o, $column_string);
1327  
1328 5 ▶ if ($command eq 'update') #ADDED NEXT 11 LINES 20011029 TO PROTECT AUTOSEQUENCE FIELDS FROM UPDATES.
Branch: 1 branch
BranchTrueFalseTotal
if ($command eq "update") 1 4 5
1329 {
1330 1 foreach my $i (@columns)
1331 {
1332 1 ▶ if (${$self->{types}}{$i} =~ /AUTO/o)
Branch: 1 branch
BranchTrueFalseTotal
if (do { $$self{"types"} }->{$i} =~ /AUTO/o) 0 1 1
1333 {
1334 0 $errdetails = $i;
1335 0 return (-525);
1336 }
1337 }
1338 }
1339 #$single = ($#columns) ? $columns[$[] : $column_string;
1340 5 ▶ $single = ($#columns) ? $columns[$#columns] : $column_string;
Branch: 1 branch
BranchTrueFalseTotal
$#columns ? : 3 2 5
1341 5 $rowcnt = 0;
1342  
1343 5 my (@these_results);
1344 5 my ($skipreformat) = 0;
1345 5 my ($colskipreformat) = 0;
1346 5 my (@types);
1347 my (@coltypes);
1348 5 @coltypes = ();
1349 5 ▶ for (my $i=0;$i<=$#columns;$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#columns) 6 5 11
1350 {
1351 6 push (@coltypes, (${$self->{types}}{$columns[$i]} =~ /$REFTYPES/o));
1352 }
1353 5 ▶ if ($fields)
Branch: 1 branch
BranchTrueFalseTotal
if ($fields) { } 4 1 5
1354 {
1355 4 @types = ();
1356 4 ▶ for (my $i=0;$i<=$#{$fields};$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#{$fields;}) 7 4 11
1357 {
1358 #$_ = (${$self->{types}}{$columns[$i]} =~ /$REFTYPES/o);
1359 7 ▶ push (@types, ((${$self->{types}}{$columns[$i]} =~ /$REFTYPES/o)||0));
Condition50%1/2
${$$self{'types'};}{$columns[$i]} =~ /$REFTYPES/o || 0
l!l
07
MC/DC0%0/1
${$$self{'types'};}{$columns[$i]} =~ /$REFTYPES/o || 0
${$$self{'types'};}{$columns[$i]} =~ /$REFTYPES/o
Truth table50%1/2
A
A= ${$$self{'types'};}{$columns[$i]} =~ /$REFTYPES/o
Aresult
11
00
1360 }
1361 }
1362 else
1363 {
1364 1 push (@$results, [ @$_{@columns} ]);
1365 1 ▶ for (my $i=0;$i<=@{$_{@columns}};$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= @{$_{@columns};}) 1 1 2
1366 {
1367 #$_ = (${$self->{types}}{$i} =~ /$REFTYPES/o);
1368 1 ▶ push (@types, ((${$self->{types}}{$i} =~ /$REFTYPES/o)||0));
Condition50%1/2
do { $$self{'types'} }->{$i} =~ /$REFTYPES/o || 0
l!l
01
MC/DC0%0/1
do { $$self{'types'} }->{$i} =~ /$REFTYPES/o || 0
do { $$self{'types'} }->{$i} =~ /$REFTYPES/o
Truth table50%1/2
A
A= do { $$self{'types'} }->{$i} =~ /$REFTYPES/o
Aresult
11
00
1369 }
1370 }
1371 5 my $blobfid;
1372 my $jj;
1373 5 ▶ $self->{sprite_reclimit} ||= $self->{sprite_sizelimit}; #ADDED 20020530 FOR SQL-PERL PLUS!
Condition33%1/3
$self->{"sprite_reclimit"} ||= $self->{"sprite_sizelimit"}
l!l&&r!l&&!r
005
MC/DC0%0/2
$self->{"sprite_reclimit"} ||= $self->{"sprite_sizelimit"}
$self->{"sprite_reclimit"} $self->{"sprite_sizelimit"}
Truth table33%1/3
A ||= B
A= $self->{"sprite_reclimit"}B= $self->{"sprite_sizelimit"}
ABresult
1X1
011
000
1374 5 ▶ for ($loop=0; $loop < scalar @{ $self->{records} }; $loop++)
Branch: 1 branch
BranchTrueFalseTotal
if ($loop < scalar @{$self->{"records"};}) 13 5 18
1375 {
1376 13 ▶ next unless (defined $self->{records}->[$loop]); #JWT: DON'T RETURN BLANK DELETED RECORDS.
Branch: 1 branch
BranchTrueFalseTotal
unless defined $self->{"records"}[$loop] 0 13 13
1377 13 $_ = $self->{records}->[$loop];
1378 13 $@ = '';
1379 #####print "<<<<<<< JSPRITE EVAL CONDITION=$condition=\n";
1380 13 ▶ if ( !$condition || (eval $condition) )
Branch: 2 branches
BranchTrueFalseTotal
if (not $condition or eval $condition) { } 7 6 13
elsif ($@) { } 0 6 6
Condition100%3/3
not $condition or eval $condition
l!l&&r!l&&!r
166
MC/DC100%2/2
not $condition or eval $condition
not $condition eval $condition
Truth table100%3/3
not(A) or B
A= not $conditionB= eval $condition
ABresult
1X1
011
000
1381 {
1382 7 ▶ if ($command eq 'select')
Branch: 4 branches
BranchTrueFalseTotal
if ($command eq 'select') { } 4 3 7
elsif ($command eq 'update') { } 3 0 3
elsif ($command eq 'add') { } 0 0 0
elsif ($command eq 'drop') { } 0 0 0
1383 {
1384 4 ▶ last if ($self->{sprite_reclimit} && $loop >= $self->{sprite_reclimit}); #ADDED 20020123 TO SPEED UP INFO-ONLY. FETCHES.
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"sprite_reclimit"} and $loop >= $self->{"sprite_reclimit"} 0 4 4
Condition33%1/3
$self->{"sprite_reclimit"} and $loop >= $self->{"sprite_reclimit"}
!ll&&!rl&&r
400
MC/DC0%0/2
$self->{"sprite_reclimit"} and $loop >= $self->{"sprite_reclimit"}
$self->{"sprite_reclimit"} $loop >= $self->{"sprite_reclimit"}
Truth table33%1/3
A and B
A= $self->{"sprite_reclimit"}B= $loop >= $self->{"sprite_reclimit"}
ABresult
0X0
100
111
1385 4 ▶ if ($fields)
Branch: 1 branch
BranchTrueFalseTotal
if ($fields) { } 4 0 4
1386 {
1387 4 @these_results = ();
1388 4 ▶ for (my $i=0;$i<=$#{$fields};$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#{$fields;}) 7 4 11
1389 {
1390 7 $fields->[$i] =~ s/($self->{column}\.(?:$psuedocols))\b/&pscolfn($self,$1)/eg; #ADDED 20011019
1391 7 $rawvalue = eval $fields->[$i];
1392 7 ▶ if ($types[$i] && $rawvalue =~ /^\d+$/o) #A LONG (REFERENCED) TYPE
Branch: 1 branch
BranchTrueFalseTotal
if ($types[$i] and $rawvalue =~ /^\d+$/o) 0 7 7
Condition33%1/3
$types[$i] and $rawvalue =~ /^\d+$/o
!ll&&!rl&&r
700
MC/DC0%0/2
$types[$i] and $rawvalue =~ /^\d+$/o
$types[$i] $rawvalue =~ /^\d+$/o
Truth table33%1/3
A and B
A= $types[$i]B= $rawvalue =~ /^\d+$/o
ABresult
0X0
100
111
1393 {
1394 $blobfid = $self->{directory}
1395 .$self->{separator}->{ $self->{platform} }
1396 0 .$self->{table}."_${rawvalue}_$$.tmp";
1397 0 ▶ if (open(FILE, "<$blobfid"))
Branch: 1 branch
BranchTrueFalseTotal
if (open FILE, "<$blobfid") { } 0 0 0
1398 {
1399 0 binmode FILE;
1400 0 $rawvalue = '';
1401 0 my $rawline;
1402 0 ▶ while ($rawline = <FILE>)
Branch: 1 branch
BranchTrueFalseTotal
if (defined($rawline = readline FILE)) 0 0 0
1403 {
1404 0 $rawvalue .= $rawline;
1405 }
1406 0 close FILE;
1407 }
1408 else
1409 {
1410 $blobfid = $self->{directory}
1411 .$self->{separator}->{ $self->{platform} }
1412 0 .$self->{table}."_${rawvalue}.ldt";
1413 0 ▶ if (open(FILE, "<$blobfid"))
Branch: 1 branch
BranchTrueFalseTotal
if (open FILE, "<$blobfid") { } 0 0 0
1414 {
1415 0 binmode FILE;
1416 0 $rawvalue = '';
1417 0 my $rawline;
1418 0 ▶ while ($rawline = <FILE>)
Branch: 1 branch
BranchTrueFalseTotal
if (defined($rawline = readline FILE)) 0 0 0
1419 {
1420 0 $rawvalue .= $rawline;
1421 }
1422 0 close FILE;
1423 }
1424 else
1425 {
1426 0 $errdetails = "$blobfid ($?)";
1427 0 return (-528);
1428 }
1429 }
1430 }
1431 7 push (@these_results, $rawvalue);
1432 }
1433 4 push (@$results, [ @these_results ]);
1434 4 push (@result_index, $loop); #ADDED 20020709 TO SUPPORT SORTING ON COLUMNS NOT IN RESULT-SET.
1435 }
1436 else #I THINK THIS IS DEAD CODE!!!
1437 {
1438 #print "<BR>-pc: SHOULD BE DEAD-CODE, PLEASE EMAIL JIM TURNER THE QUERY WHICH GOT HERE!<BR>\n";
1439 #foreach my $i (@columns) {print "<BR> $i: =$_{$i}=\n";};
1440 0 push (@$results, [ @$_{@columns} ]);
1441 }
1442 }
1443 elsif ($command eq 'update')
1444 {
1445 3 @perlmatches = ();
1446 3 ▶ for (my $i=0;$i<=$#perlconds;$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#perlconds) 3 3 6
1447 {
1448 3 eval $perlconds[$i];
1449 }
1450 3 $code = '';
1451 3 my ($matchcnt) = 0;
1452 3 my (@valuelist) = keys(%$values);
1453 #my ($dontchkcols) = '('.join('|',@valuelist).')';
1454 3 my ($dontchkcols) = '('.join('|',@valuelist);
1455 3 ▶ for (my $i=0;$i<=$#columns;$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#columns) 3 3 6
1456 {
1457 3 ▶ $dontchkcols .= '|'.$columns[$i] if ($coltypes[$i]);
Branch: 1 branch
BranchTrueFalseTotal
if $coltypes[$i] 0 3 3
1458 }
1459 3 $dontchkcols .= ')';
1460 3 foreach $i (@valuelist)
1461 {
1462 3 ▶ for ($j=0;$j<=$#keyfields;$j++)
Branch: 1 branch
BranchTrueFalseTotal
if ($j <= $#keyfields) 3 3 6
1463 {
1464 3 ▶ if ($i eq $keyfields[$j])
Branch: 1 branch
BranchTrueFalseTotal
if ($i eq $keyfields[$j]) 0 3 3
1465 {
1466 0 ▶K: for ($k=0;$k < scalar @{ $self->{records} }; $k++)
Branch: 1 branch
BranchTrueFalseTotal
if ($k < scalar @{$self->{"records"};}) 0 0 0
1467 {
1468 0 $rawvalue = $values->{$i};
1469 0 $rawvalue =~ s/^\'(.*)\'\s*$/$1/s;
1470 0 ▶ if ($self->{records}->[$k]->{$i} eq $rawvalue)
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{"records"}[$k]{$i} eq $rawvalue) 0 0 0
1471 {
1472 0 foreach $jj (@keyfields)
1473 {
1474 0 ▶ unless ($jj =~ /$dontchkcols/)
Branch: 1 branch
BranchTrueFalseTotal
unless ($jj =~ /$dontchkcols/) 0 0 0
1475 {
1476 next K
1477 unless ($self->{records}->[$k]->{$jj}
1478 0 ▶ eq $_->{$jj});
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"records"}[$k]{$jj} eq $_->{$jj} 0 0 0
1479 }
1480 }
1481 0 goto MATCHED1;
1482 }
1483 }
1484 0 goto NOMATCHED1;
1485 0 MATCHED1: ++$matchcnt;
1486 }
1487 }
1488 }
1489 3 ▶ return (-518) if ($matchcnt && $matchcnt > $#valuelist); #ALL KEY FIELDS WERE DUPLICATES!
Branch: 1 branch
BranchTrueFalseTotal
if $matchcnt and $matchcnt > $#valuelist 0 3 3
Condition33%1/3
$matchcnt and $matchcnt > $#valuelist
!ll&&!rl&&r
300
MC/DC0%0/2
$matchcnt and $matchcnt > $#valuelist
$matchcnt $matchcnt > $#valuelist
Truth table33%1/3
A and B
A= $matchcntB= $matchcnt > $#valuelist
ABresult
0X0
100
111
1490 NOMATCHED1:
1491 3 $self->{dirty} = 1;
1492 3 foreach $jj (@columns) #JWT 19991104: FORCE TRUNCATION TO FIT!
1493 {
1494 3 $colskipreformat = $skipreformat;
1495 #$rawvalue = $values->{$jj}; #CHGD TO NEXT 20011018.
1496 3 $rawvalue = $valuenames{$jj};
1497 #NEXT LINE ADDED 20011018 TO HANDLE PERL REGEX SUBSTITUTIONS.
1498 3 ▶ $colskipreformat = 0 if ($rawvalue =~ s/\$(\d)/$perlmatches[$1-1]/g);
Branch: 1 branch
BranchTrueFalseTotal
if $rawvalue =~ s/\$(\d)/$perlmatches[$1 - 1]/g 3 0 3
1499 3 ▶ if ($valuenames{$jj} =~ /^[_a-zA-Z]/o) #NEXT 5 LINES ADDED 20000516 SO FUNCTIONS WILL WORK IN UPDATES!
Branch: 1 branch
BranchTrueFalseTotal
if ($valuenames{$jj} =~ /^[_a-zA-Z]/o) { } 3 0 3
1500 {
1501 3 ▶ if ($self->{sprite_CaseFieldNames})
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'sprite_CaseFieldNames'}) { } 0 3 3
1502 {
1503 0 ▶ unless ($self->{fields}->{"$valuenames{$jj}"}) #ADDED TEST 20001218 TO ALLOW FIELD-NAMES AS RIGHT-VALUES.
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'fields'}{"$valuenames{$jj}"}) { } 0 0 0
1504 {
1505 #$rawvalue = &chkcolumnparms($self, $valuenames{$jj}); #CHGD. TO NEXT 20011018.
1506 0 $rawvalue = &chkcolumnparms($self, $rawvalue);
1507 0 $rawvalue = eval $rawvalue; #FUNCTION EVAL 3
1508 0 ▶ return (-517) if ($@);
Branch: 1 branch
BranchTrueFalseTotal
if $@ 0 0 0
1509 }
1510 else
1511 {
1512 0 $rawvalue = $_->{$valuenames{$jj}};
1513 }
1514 }
1515 else
1516 {
1517 3 ▶ unless ($self->{fields}->{"\U$valuenames{$jj}\E"}) #ADDED TEST 20001218 TO ALLOW FIELD-NAMES AS RIGHT-VALUES.
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'fields'}{uc $valuenames{$jj}}) { } 0 3 3
1518 {
1519 #$rawvalue = &chkcolumnparms($self, $valuenames{$jj}); #CHGD. TO NEXT 20011018.
1520 3 $rawvalue = &chkcolumnparms($self, $rawvalue);
1521 3 $rawvalue = eval $rawvalue; #FUNCTION EVAL 3
1522 3 ▶ return (-517) if ($@);
Branch: 1 branch
BranchTrueFalseTotal
if $@ 0 3 3
1523 }
1524 else
1525 {
1526 0 $rawvalue = $_->{$valuenames{$jj}};
1527 }
1528 }
1529 3 $colskipreformat = 0;
1530 }
1531 else
1532 {
1533 0 ▶ $rawvalue =~ s/^\'(.*)\'\s*$/$1/s if ($valuenames{$jj} =~ /^\'/o);
Branch: 1 branch
BranchTrueFalseTotal
if $valuenames{$jj} =~ /^\'/o 0 0 0
1534 }
1535 #if (${$self->{types}}{$jj} =~ /$NUMERICTYPES/) #CHGD TO NEXT LINE 20010313.
1536  
1537 3 ▶ unless ($colskipreformat) #ADDED 20011018 TO OPTIMIZE.
Branch: 1 branch
BranchTrueFalseTotal
unless ($colskipreformat) 3 0 3
1538 {
1539 3 ▶ if (length($rawvalue) > 0 && ${$self->{types}}{$jj} =~ /$NUMERICTYPES/)
Branch: 1 branch
BranchTrueFalseTotal
if (length $rawvalue > 0 and do { $$self{'types'} }->{$jj} =~ /$NUMERICTYPES/) { } 0 3 3
Condition33%1/3
length $rawvalue > 0 and do { $$self{"types"} }->{$jj} =~ /$NUMERICTYPES/
!ll&&!rl&&r
030
MC/DC0%0/2
length $rawvalue > 0 and do { $$self{"types"} }->{$jj} =~ /$NUMERICTYPES/
length $rawvalue > 0 do { $$self{"types"} }->{$jj} =~ /$NUMERICTYPES/
Truth table33%1/3
A and B
A= length $rawvalue > 0B= do { $$self{"types"} }->{$jj} =~ /$NUMERICTYPES/
ABresult
0X0
100
111
1540 {
1541 0 $k = sprintf(('%.'.${$self->{scales}}{$jj}.'f'),
1542 $rawvalue);
1543 }
1544 else
1545 {
1546 3 $k = $rawvalue;
1547 }
1548 #$rawvalue = substr($k,0,${$self->{lengths}}{$jj});
1549 3 ▶ $rawvalue = (${$self->{types}}{$jj} =~ /$BLOBTYPES/) ? $k : substr($k,0,${$self->{lengths}}{$jj});
Branch: 1 branch
BranchTrueFalseTotal
do { $$self{'types'} }->{$jj} =~ /$BLOBTYPES/ ? : 0 3 3
1550 3 ▶ unless ($self->{LongTruncOk} || $rawvalue eq $k ||
Branch: 1 branch
BranchTrueFalseTotal
unless ($self->{"LongTruncOk"} or $rawvalue eq $k or do { $$self{"types"} }->{$jj} eq "FLOAT") 0 3 3
Condition33%2/6
$self->{"LongTruncOk"} or $rawvalue eq $k or do { $$self{"types"} }->{$jj} eq "FLOAT"
l!l&&r!l&&!r
300
$self->{"LongTruncOk"} or $rawvalue eq $k
l!l&&r!l&&!r
030
MC/DC0%0/3
$self->{"LongTruncOk"} or $rawvalue eq $k or do { $$self{"types"} }->{$jj} eq "FLOAT"
$self->{"LongTruncOk"} $rawvalue eq $k do { $$self{"types"} }->{$jj} eq "FLOAT"
Truth table25%1/4
A or B or C
A= $self->{"LongTruncOk"}B= $rawvalue eq $kC= do { $$self{"types"} }->{$jj} eq "FLOAT"
ABCresult
1XX1
01X1
0011
0000
1551 0 (${$self->{types}}{$jj} eq 'FLOAT'))
1552 {
1553 0 $errdetails = "$jj to ${$self->{lengths}}{$jj} chars";
1554 0 return (-519); #20000921: ADDED (MANY PLACES) LENGTH TO ERRDETAILS "(fieldname to ## chars)"
1555 }
1556 3 ▶ if ((${$self->{types}}{$jj} eq 'FLOAT')
Branch: 1 branch
BranchTrueFalseTotal
if (do { $$self{"types"} }->{$jj} eq "FLOAT" and int $rawvalue != int $k) 0 3 3
Condition33%1/3
do { $$self{"types"} }->{$jj} eq "FLOAT" and int $rawvalue != int $k
!ll&&!rl&&r
300
MC/DC0%0/2
do { $$self{"types"} }->{$jj} eq "FLOAT" and int $rawvalue != int $k
do { $$self{"types"} }->{$jj} eq "FLOAT" int $rawvalue != int $k
Truth table33%1/3
A and B
A= do { $$self{"types"} }->{$jj} eq "FLOAT"B= int $rawvalue != int $k
ABresult
0X0
100
111
1557 && (int($rawvalue) != int($k)))
1558 {
1559 0 $errdetails = "$jj to ${$self->{lengths}}{$jj} chars";
1560 0 return (-519);
1561 }
1562 #if (${$self->{types}}{$jj} eq 'CHAR') #CHGD. TO NEXT 20030812.
1563 3 ▶ if (${$self->{types}}{$jj} eq 'CHAR' && length($rawvalue) > 0)
Branch: 1 branch
BranchTrueFalseTotal
if (do { $$self{'types'} }->{$jj} eq 'CHAR' and length $rawvalue > 0) { } 0 3 3
Condition33%1/3
do { $$self{"types"} }->{$jj} eq "CHAR" and length $rawvalue > 0
!ll&&!rl&&r
300
MC/DC0%0/2
do { $$self{"types"} }->{$jj} eq "CHAR" and length $rawvalue > 0
do { $$self{"types"} }->{$jj} eq "CHAR" length $rawvalue > 0
Truth table33%1/3
A and B
A= do { $$self{"types"} }->{$jj} eq "CHAR"B= length $rawvalue > 0
ABresult
0X0
100
111
1564 {
1565 $values->{$jj} = "'" . sprintf(
1566 0 '%-'.${$self->{lengths}}{$jj}.'s',
1567 $rawvalue) . "'";
1568 }
1569 #elsif (${$self->{types}}{$jj} !~ /$NUMERICTYPES/) #CHGD. TO NEXT 20010313.
1570 #CHGD. TO NEXT 20160111: elsif (!length($rawvalue) || ${$self->{types}}{$jj} !~ /$NUMERICTYPES/)
1571 #REASON: STOP TRAILING ZEROES IN DECIMALS FROM BEING TRUNCATED (WE ALREADY FORMATTED AT LINE 1541 ABOVE!)
1572 else
1573 {
1574 3 $values->{$jj} = "'" . $rawvalue . "'";
1575 }
1576 #xNEXT 4 REMOVED 20160111: else
1577 #x {
1578 #x $values->{$jj} = $rawvalue;
1579 #x }
1580 }
1581 }
1582 #map { $code .= qq|\$_->{'$_'} = $values->{$_};| } @columns; #NEXT 2 CHGD TO NEXT 34 20020125 TO SUPPORT BLOB REFERENCING.
1583 #eval $code;
1584 3 ▶ for (my $i=0;$i<=$#columns;$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#columns) 3 3 6
1585 {
1586 3 ▶ if ($coltypes[$i]) #BLOB REF.
Branch: 1 branch
BranchTrueFalseTotal
if ($coltypes[$i]) { } 0 3 3
1587 {
1588 0 $code = qq|\$rawvalue = $values->{$columns[$i]};|;
1589 0 eval $code;
1590 $blobfid = $self->{directory}.$self->{separator}->{ $self->{platform} }
1591 0 .$self->{table}.'_'.$_->{$columns[$i]}."_$$.tmp";
1592 0 ▶ if (open(FILE, ">$blobfid"))
Branch: 1 branch
BranchTrueFalseTotal
if (open FILE, ">$blobfid") { } 0 0 0
1593 {
1594 0 binmode FILE;
1595 0 ▶ if ($self->{CBC} && $self->{sprite_Crypt} <= 2) #ADDED: 20020109
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'CBC'} and $self->{'sprite_Crypt'} <= 2) { } 0 0 0
Condition0%0/3
$self->{"CBC"} and $self->{"sprite_Crypt"} <= 2
!ll&&!rl&&r
000
MC/DC0%0/2
$self->{"CBC"} and $self->{"sprite_Crypt"} <= 2
$self->{"CBC"} $self->{"sprite_Crypt"} <= 2
Truth table0%0/3
A and B
A= $self->{"CBC"}B= $self->{"sprite_Crypt"} <= 2
ABresult
0X0
100
111
1596 {
1597 0 print FILE $self->{CBC}->encrypt($rawvalue);
1598 }
1599 else
1600 {
1601 0 print FILE $rawvalue;
1602 }
1603 0 close FILE;
1604 }
1605 else
1606 {
1607 0 $errdetails = "$blobfid: ($?)";
1608 0 return (-528);
1609 }
1610 }
1611 else
1612 {
1613 3 $code = qq|\$_->{'$columns[$i]'} = $values->{$columns[$i]};|;
1614 3 eval $code;
1615 }
1616 }
1617  
1618 3 ▶ return (-517) if ($@);
Branch: 1 branch
BranchTrueFalseTotal
if $@ 0 3 3
1619 }
1620 elsif ($command eq 'add')
1621 {
1622 0 $_->{$single} = ''; #ORACLE DOES NOT SET EXISTING RECORDS TO DEFAULT VALUE!
1623 }
1624 elsif ($command eq 'drop')
1625 {
1626 0 delete $_->{$single};
1627 }
1628 7 ++$rowcnt;
1629 7 $skipreformat = 1;
1630 }
1631 elsif ($@) #ADDED 20010313 TO CATCH SYNTAX ERRORS.
1632 {
1633 0 $errdetails = "Condition failed ($@) in condition=$condition!";
1634 0 ▶ return -503 if ($command eq 'select');
Branch: 1 branch
BranchTrueFalseTotal
if $command eq "select" 0 0 0
1635 0 ▶ return -505 if ($command eq 'delete');
Branch: 1 branch
BranchTrueFalseTotal
if $command eq "delete" 0 0 0
1636 0 return -504;
1637 }
1638 }
1639 5 ▶ if ($status <= 0)
Branch: 2 branches
BranchTrueFalseTotal
if ($status <= 0) { } 0 5 5
elsif ($command ne 'select') { } 1 4 5
1640 {
1641 0 return $status;
1642 }
1643 elsif ( $command ne 'select' )
1644 {
1645 1 return $rowcnt;
1646 }
1647 else
1648 {
1649 4 my $theresanull = 0; #ADDED 20030930 TO HANDLE SINGLE NULL ELEMENT TO FIX _set_fbav ERROR!
1650 4 my $rowcntdigits = length(scalar(@$results)); #ADDED 20050514 TO ENSURE SORTING WORKS CORRECTLY.
1651 4 my ($ii, $t);
1652 4 ▶ if ($distinct) #THIS IF ADDED 20010521 TO MAKE "DISTINCT" WORK.
Branch: 1 branch
BranchTrueFalseTotal
if ($distinct) 0 4 4
1653 {
1654 0 my (%disthash);
1655 0 ▶ for (my $i=0;$i<=$#$results;$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $results->$#*) 0 0 0
1656 {
1657 0 ++$disthash{join("\x02\^2jSpR1tE\x02",@{$results->[$i]})};
1658 }
1659 0 @$results = ();
1660 #foreach my $i (sort keys(%disthash)) #CHGD. TO NEXT 20050514 - UNNECESSARY TO SORT.
1661 0 foreach my $i (keys(%disthash))
1662 {
1663 0 ▶ if ($i eq '') #(20030930) SINGLE NULL ELEMENT MUST GO ON *END* OF ARRAY!
Branch: 1 branch
BranchTrueFalseTotal
if ($i eq "") 0 0 0
1664 {
1665 0 $theresanull = 1;
1666 0 next;
1667 }
1668 # push (@$results, [split(/\x02\^2jSpR1tE\x02/, $i)]); #CHGD. TO NEXT 20031001 TO FIX _set_fbav ERROR!
1669 0 push (@$results, [split(/\x02\^2jSpR1tE\x02/o, $i, -1)]);
1670 }
1671 }
1672 4 ▶ if (@$ordercols) #COMPLETELY OVERHAULED 20020708 TO SUPPORT MULTIPLE ASCENDING/DESCENDING DECISIONS & SORTING ON COLUMNS NOT IN RESULT-SET!
Branch: 1 branch
BranchTrueFalseTotal
if (@$ordercols) 0 4 4
1673 {
1674 0 @$ordercols = reverse(@$ordercols);
1675 0 @$descorder = reverse(@$descorder);
1676 0 $rowcnt = 0;
1677 #my ($mysep) = "\x02\^2jSpR1tE\x02";
1678 #$mysep = "\xFF" if ($descorder);
1679 #my @mysep = ("^", "V");
1680 0 my @mysep = ("\x00", "\xff");
1681 0 my @SA = ();
1682 0 my @SSA = ();
1683 0 my @SI = ();
1684 0 my @l;
1685 0 for (0..$#columns)
1686 {
1687 0 $colorder{$columns[$_]} = $_;
1688 }
1689 0 ▶ for (my $i=0;$i<=$#$results;$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $results->$#*) 0 0 0
1690 {
1691 0 $t = sprintf('%'.$rowcntdigits.'.'.$rowcntdigits.'d', $i); #ADDED 20050514 TO ENSURE SORTING WORKS CORRECTLY.
1692 0 push (@SI, $t);
1693 0 push (@SSA, $t);
1694 }
1695 0 my $jcnt = 0;
1696 0 ▶ my $do = ($descorder->[0] =~ /de/io) ? 1 : 0;
Branch: 1 branch
BranchTrueFalseTotal
$descorder->[0] =~ /de/io ? : 0 0 0
1697 0 my $fieldval;
1698 0 foreach my $j (@$ordercols)
1699 {
1700 0 ▶ $j =~ tr/a-z/A-Z/ unless ($self->{sprite_CaseFieldNames});
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"sprite_CaseFieldNames"} 0 0 0
1701 #$k = $colorder{$j} || -1; #CHGD. TO NEXT 20050514 TO FIX BUG THAT PREVENTED SORTING FROM WORKING W/SELECT DISTINCT.
1702 0 ▶ $k = defined($colorder{$j}) ? $colorder{$j} : -1;
Branch: 1 branch
BranchTrueFalseTotal
defined $colorder{$j} ? : 0 0 0
1703 0 ▶ for (my $i=0;$i<=$#$results;$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $results->$#*) 0 0 0
1704 {
1705 $fieldval = ($k >= 0) ?
1706 0 ${$results}[$SI[$i]]->[$k]
1707 0 ▶ : $self->{records}->[$result_index[$SI[$i]]]->{$j};
Branch: 1 branch
BranchTrueFalseTotal
$k >= 0 ? : 0 0 0
1708 0 ▶ if (${$self->{types}}{$j} eq 'FLOAT' || ${$self->{types}}{$j} eq 'DOUBLE')
Branch: 2 branches
BranchTrueFalseTotal
if (do { $$self{'types'} }->{$j} eq 'FLOAT' or do { $$self{'types'} }->{$j} eq 'DOUBLE') { } 0 0 0
elsif (length $fieldval > 0 and do { $$self{'types'} }->{$j} =~ /$NUMERICTYPES/) { } 0 0 0
Condition0%0/3
do { $$self{"types"} }->{$j} eq "FLOAT" or do { $$self{"types"} }->{$j} eq "DOUBLE"
l!l&&r!l&&!r
000
MC/DC0%0/2
do { $$self{"types"} }->{$j} eq "FLOAT" or do { $$self{"types"} }->{$j} eq "DOUBLE"
do { $$self{"types"} }->{$j} eq "FLOAT" do { $$self{"types"} }->{$j} eq "DOUBLE"
Truth table0%0/3
A or B
A= do { $$self{"types"} }->{$j} eq "FLOAT"B= do { $$self{"types"} }->{$j} eq "DOUBLE"
ABresult
1X1
011
000
1709 {
1710 0 push (@SA, (sprintf('%'.${$self->{lengths}}{$j}.${$self->{scales}}{$j}.'e',$fieldval) . $mysep[$do] . $SSA[$i]));
1711 }
1712 0 ▶ elsif (length ($fieldval) > 0 && ${$self->{types}}{$j} =~ /$NUMERICTYPES/)
Condition0%0/3
length $fieldval > 0 and do { $$self{"types"} }->{$j} =~ /$NUMERICTYPES/
!ll&&!rl&&r
000
MC/DC0%0/2
length $fieldval > 0 and do { $$self{"types"} }->{$j} =~ /$NUMERICTYPES/
length $fieldval > 0 do { $$self{"types"} }->{$j} =~ /$NUMERICTYPES/
Truth table0%0/3
A and B
A= length $fieldval > 0B= do { $$self{"types"} }->{$j} =~ /$NUMERICTYPES/
ABresult
0X0
100
111
1713 {
1714 0 push (@SA, (sprintf('%'.${$self->{lengths}}{$j}.${$self->{scales}}{$j}.'f',$fieldval) . $mysep[$do] . $SSA[$i]));
1715 }
1716 else
1717 {
1718 0 push (@SA, ($fieldval . $mysep[$do] . $SSA[$i]));
1719 }
1720 }
1721 0 @SI = ();
1722 0 @SSA = ();
1723 0 @SI = sort {$a cmp $b} @SA;
1724 0 ▶ @SI = reverse(@SI) if ($do);
Branch: 1 branch
BranchTrueFalseTotal
if $do 0 0 0
1725 0 @SA = ();
1726 0 my $ii = $#SI;
1727 0 $l = length($ii);
1728 0 ▶ if ($jcnt < $#$ordercols)
Branch: 1 branch
BranchTrueFalseTotal
if ($jcnt < $ordercols->$#*) 0 0 0
1729 {
1730 0 ▶ $do = ($descorder->[++$jcnt] =~ /de/io) ? 1 : 0;
Branch: 1 branch
BranchTrueFalseTotal
$$descorder[++$jcnt] =~ /de/io ? : 0 0 0
1731 0 ▶ for (my $i=0;$i<=$#SI;$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#SI) 0 0 0
1732 {
1733 0 ▶ $SI[$i] = $1 if ($SI[$i] =~ /(\d+)$/o);
Branch: 1 branch
BranchTrueFalseTotal
if $SI[$i] =~ /(\d+)$/o 0 0 0
1734 #push (@SSA, sprintf("%${l}d",$ii--) . $mysep[$do] . $SI[$i]); #CHGD. TO NEXT 20050514 TO ENSURE SORTING WORKS CORRECTLY.
1735 0 ▶ push (@SSA, sprintf("%${l}d",($do ? $ii-- : $i)) . $mysep[$do] . sprintf('%'.$rowcntdigits.'.'.$rowcntdigits.'d',$SI[$i]));
Branch: 1 branch
BranchTrueFalseTotal
$do ? : 0 0 0
1736 }
1737 }
1738 }
1739 0 @SA = @$results;
1740 0 @$results = ();
1741 0 ▶ for (my $i=0;$i<=$#SI;$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#SI) 0 0 0
1742 {
1743 0 ▶ $SI[$i] = $1 if ($SI[$i] =~ /(\d+)$/o);
Branch: 1 branch
BranchTrueFalseTotal
if $SI[$i] =~ /(\d+)$/o 0 0 0
1744 0 push (@$results, $SA[$SI[$i]]);
1745 }
1746 }
1747 4 ▶ if ($theresanull) #ADDED 20030930 TO HANDLE SINGLE NULL ELEMENT TO FIX _set_fbav ERROR!
Branch: 1 branch
BranchTrueFalseTotal
if ($theresanull) 0 4 4
1748 {
1749 0 unshift (@$results, ['']);
1750 }
1751 #$rowcnt = $#$results + 1;
1752 #NEXT 2 ADDED 20160111 TO SUPPORT "limit #" ON QUERIES:
1753 0 $#{$results} = $self->{sprite_actlimit} - 1
1754 0 ▶ if ($self->{sprite_actlimit} > 0 && $#{$results} >= $self->{sprite_actlimit});
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"sprite_actlimit"} > 0 and $#{$results;} >= $self->{"sprite_actlimit"} 0 4 4
Condition33%1/3
$self->{"sprite_actlimit"} > 0 and $#{$results;} >= $self->{"sprite_actlimit"}
!ll&&!rl&&r
400
MC/DC0%0/2
$self->{"sprite_actlimit"} > 0 and $#{$results;} >= $self->{"sprite_actlimit"}
$self->{"sprite_actlimit"} > 0 $#{$results;} >= $self->{"sprite_actlimit"}
Truth table33%1/3
A and B
A= $self->{"sprite_actlimit"} > 0B= $#{$results;} >= $self->{"sprite_actlimit"}
ABresult
0X0
100
111
1755 4 $rowcnt = scalar(@{$results});
1756 }
1757 4 unshift (@$results, $rowcnt);
1758 4 return $results;
1759 }
1760  
1761 sub check_for_reload
1762 11 ▶{
Subroutine check_for_reload: called CC=11 SCAR=24.1
Pod undocumented
1763 11 my ($self, $file) = @_;
1764 11 my ($table, $path, $status);
1765  
1766 11 ▶ return unless ($file);
Branch: 1 branch
BranchTrueFalseTotal
unless $file 0 11 11
1767  
1768 11 ▶ if ($file =~ /^DUAL$/io) #ADDED 20000306 TO HANDLE ORACLE'S "DUAL" TABLE!
Branch: 1 branch
BranchTrueFalseTotal
if ($file =~ /^DUAL$/io) 1 10 11
1769 {
1770 1 undef %{ $self->{types} };
1771 1 undef %{ $self->{lengths} };
1772 1 $self->{use_fields} = 'DUMMY';
1773 1 $self->{key_fields} = 'DUMMY'; #20000223 - FIX LOSS OF KEY ASTERISK ON ROLLBACK!
1774 1 ${$self->{types}}{DUMMY} = 'VARCHAR2';
1775 1 ${$self->{lengths}}{DUMMY} = 1;
1776 1 ${$self->{scales}}{DUMMY} = 1;
1777 1 $self->{order} = [ 'DUMMY' ];
1778 1 $self->{fields}->{DUMMY} = 1;
1779 1 undef @{ $self->{records} };
1780 1 $self->{records}->[0] = {'DUMMY' => 'X'};
1781 1 $self->{table} = 'DUAL';
1782 1 return (1);
1783 }
1784  
1785 10 ($path, $table) = $self->get_path_info ($file);
1786 10 $file = $path . $table; # if ($table eq $file);
1787 10 ▶ $file .= $self->{ext} if ($self->{ext}); #JWT:ADD FILE EXTENSIONS.
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"ext"} 10 0 10
1788 10 $self->{table} = $table;
1789 10 $status = 1;
1790  
1791 10 my (@stats) = stat ($file);
1792 10 ▶ if ( ($self->{table} ne $table) || ($self->{file} ne $file
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{"table"} ne $table or ($self->{"file"} ne $file or $self->{"timestamp"} != $stats[9])) 2 8 10
Condition66%4/6
$self->{"table"} ne $table or ($self->{"file"} ne $file or $self->{"timestamp"} != $stats[9])
l!l&&r!l&&!r
028
$self->{"file"} ne $file or $self->{"timestamp"} != $stats[9]
l!l&&r!l&&!r
208
MC/DC33%1/3
$self->{"table"} ne $table or ($self->{"file"} ne $file or $self->{"timestamp"} != $stats[9])
$self->{"table"} ne $table $self->{"file"} ne $file $self->{"timestamp"} != $stats[9]
Truth table50%2/4
A or B or C
A= $self->{"table"} ne $tableB= $self->{"file"} ne $fileC= $self->{"timestamp"} != $stats[9]
ABCresult
1XX1
01X1
0011
0000
1793 || $self->{timestamp} != $stats[9]) )
1794 {
1795 2 ▶ if ( (-e _) && (-s _) && (-r _) )
Branch: 1 branch
BranchTrueFalseTotal
if (-e _ and -s _ and -r _) { } 1 1 2
Condition66%4/6
-e _ and -s _ and -r _
!ll&&!rl&&r
101
-e _ and -s _
!ll&&!rl&&r
101
MC/DC33%1/3
-e _ and -s _ and -r _
-e _ -s _ -r _
Truth table50%2/4
A and B and C
A= -e _B= -s _C= -r _
ABCresult
0XX0
10X0
1100
1111
1796 {
1797  
1798 1 $self->{table} = $table;
1799 1 $self->{file} = $file;
1800 1 $status = $self->load_database ($file);
1801 1 $self->{timestamp} = $stats[9];
1802 }
1803 else
1804 {
1805 1 $errdetails = $file; #20000114
1806 1 $status = 0;
1807 }
1808 }
1809  
1810 10 ▶ $errdetails = $file if ($status == 0); #20000114
Branch: 1 branch
BranchTrueFalseTotal
if $status == 0 1 9 10
1811 10 return $status;
1812 }
1813  
1814 sub rollback
1815 0 ▶{
Subroutine rollback: not called CC=9 SCAR=45.0
Pod undocumented
1816 0 my ($self) = @_;
1817 0 my ($table, $path, $status);
1818  
1819 0 my (@stats) = stat ($self->{file});
1820
1821 0 ▶ if ( (-e _) && (-T _) && (-s _) && (-r _) )
Branch: 1 branch
BranchTrueFalseTotal
if (-e _ and -T _ and -s _ and -r _) { } 0 0 0
Condition0%0/9
-e _ and -T _ and -s _ and -r _
!ll&&!rl&&r
000
-e _ and -T _ and -s _
!ll&&!rl&&r
000
-e _ and -T _
!ll&&!rl&&r
000
MC/DC0%0/4
-e _ and -T _ and -s _ and -r _
-e _ -T _ -s _ -r _
Truth table0%0/5
A and B and C and D
A= -e _B= -T _C= -s _D= -r _
ABCDresult
0XXX0
10XX0
110X0
11100
11111
1822 {
1823 0 $status = $self->load_database ($self->{file});
1824 0 $self->{timestamp} = $stats[9];
1825 }
1826 else
1827 {
1828 0 $status = 0;
1829 }
1830 0 my $blobglob = $self->{file};
1831 0 $blobglob =~ s/$self->{ext}$/\_\*\_$$\.tmp/;
1832 0 my $bloberror = 0;
1833 0 unlink $blobglob;
1834 0 ▶ $bloberror = $?.':'.$@ if ($?);
Branch: 1 branch
BranchTrueFalseTotal
if $? 0 0 0
1835 #if ($bloberror) #CHGD. TO NEXT 20020222 TO PREVENT EXTRA FALSE ERROR MSG.
1836 0 ▶ if ($blobglob && $bloberror)
Branch: 1 branch
BranchTrueFalseTotal
if ($blobglob and $bloberror) { } 0 0 0
Condition0%0/3
$blobglob and $bloberror
!ll&&!rl&&r
000
MC/DC0%0/2
$blobglob and $bloberror
$blobglob $bloberror
Truth table0%0/3
A and B
A= $blobglobB= $bloberror
ABresult
0X0
100
111
1837 {
1838 0 $errdetails = $bloberror;
1839 0 $self->display_error (-528);
1840 0 return undef;
1841 }
1842 else
1843 {
1844 $blobglob = $self->{directory}.$self->{separator}->{ $self->{platform} }
1845 0 .$self->{table}."_*_$$.del";
1846 0 my @tempblobs = ();
1847 0 eval qq|\@tempblobs = <$blobglob>|;
1848 0 my ($blobfile, $tempfile);
1849 0 ▶ while (@tempblobs)
Branch: 1 branch
BranchTrueFalseTotal
if (@tempblobs) 0 0 0
1850 {
1851 0 $tempfile = shift(@tempblobs);
1852 0 $blobfile = $tempfile;
1853 0 $blobfile =~ s/\_$$\.del/\.ldt/;
1854 0 rename ($tempfile, $blobfile);
1855 }
1856 0 $self->{dirty} = 0;
1857 }
1858 0 return $status;
1859 }
1860  
1861 sub select
1862 5 ▶{
Subroutine select: called CC=38 SCAR=43.4
Pod documented
1863 5 my ($self, $query) = @_;
1864 5 my ($i, @l, $regex, $path, $columns, $table, $extra, $condition,
1865 $values_or_error, $descorder, @descorder);
1866 5 my (@ordercols) = ();
1867 5 $regex = $self->{_select};
1868 5 $path = $self->{path};
1869 #$fieldregex = $self->{fieldregex};
1870 5 my ($psuedocols) = "CURRVAL|NEXTVAL";
1871  
1872 5 my $distinct; #NEXT 2 ADDED 20010521 TO ADD "DISTINCT" CAPABILITY!
1873 5 ▶ $distinct = 1 if ($query =~ /^select\s+distinct/o);
Branch: 1 branch
BranchTrueFalseTotal
if $query =~ /^select\s+distinct/o 0 5 5
1874 5 $query =~ s/^select\s+distinct(\s+\w|\s*\(|\s+\*)/select $1/is;
1875  
1876  
1877 5 ▶ if ($query =~ /^select\s+
Branch: 1 branch
BranchTrueFalseTotal
if ($query =~ /^select\s+ (.+)\s+ from\s+ (\w+)(.*)$/iosx) { } 5 0 5
1878 (.+)\s+
1879 from\s+
1880 (\w+)(.*)$/ioxs)
1881 {
1882 5 my ($column_stuff, $table, $extra) = ($1, $2, $3);
1883 5 my (@fields) = ();
1884 5 my ($fnname, $found_parin, $parincnt, $t);
1885 5 my @column_stuff;
1886  
1887 #ORACLE COMPATABILITY!
1888  
1889 5 ▶ if ($column_stuff =~ /^table_name\s*$/io && $table =~ /^(user|all)_tables$/io) #JWT: FETCH TABLE NAMES!
Branch: 1 branch
BranchTrueFalseTotal
if ($column_stuff =~ /^table_name\s*$/io and $table =~ /^(user|all)_tables$/io) 1 4 5
Condition66%2/3
$column_stuff =~ /^table_name\s*$/io and $table =~ /^(user|all)_tables$/io
!ll&&!rl&&r
401
MC/DC50%1/2
$column_stuff =~ /^table_name\s*$/io and $table =~ /^(user|all)_tables$/io
$column_stuff =~ /^table_name\s*$/io $table =~ /^(user|all)_tables$/io
Truth table66%2/3
A and B
A= $column_stuff =~ /^table_name\s*$/ioB= $table =~ /^(user|all)_tables$/io
ABresult
0X0
100
111
1890 {
1891 1 my $full_path = $self->{directory};
1892 $full_path .= $self->{separator}->{ $self->{platform} }
1893 1 ▶ unless ($full_path !~ /\S/o
Branch: 1 branch
BranchTrueFalseTotal
unless not $full_path =~ /\S/o or $full_path =~ /$self->{"separator"}{$self->{"platform"}}$/ 1 0 1
Condition33%1/3
not $full_path =~ /\S/o or $full_path =~ /$self->{"separator"}{$self->{"platform"}}$/
l!l&&r!l&&!r
001
MC/DC0%0/2
not $full_path =~ /\S/o or $full_path =~ /$self->{"separator"}{$self->{"platform"}}$/
not $full_path =~ /\S/o $full_path =~ /$self->{"separator"}{$self->{"platform"}}$/
Truth table33%1/3
not(A) or B
A= not $full_path =~ /\S/oB= $full_path =~ /$self->{"separator"}{$self->{"platform"}}$/
ABresult
1X1
011
000
1894 || $full_path =~ m#$self->{separator}->{ $self->{platform} }$#);
1895 1 my ($cmd);
1896 1 $cmd = $full_path . '*' . $self->{ext};
1897 1 my ($code);
1898 1 ▶ if ($^O =~ /Win/i) #NEEDED TO MAKE PERL2EXE'S "-GUI" VERSION WORK!
Branch: 1 branch
BranchTrueFalseTotal
if ($^O =~ /Win/i) { } 0 1 1
1899 {
1900 0 @l = glob $cmd;
1901 }
1902 else
1903 {
1904 1 @l = ();
1905 1 $code = "while (my \$i = <$cmd>)\n";
1906 1 $code .= <<'END_CODE';
1907 {
1908 chomp ($i);
1909 push (@l, $i);
1910 }
1911 END_CODE
1912 1 eval $code;
1913 }
1914 1 $self->{use_fields} = 'TABLE_NAME'; #ADDED 20000224 FOR DBI!
1915 1 $values_or_error = [];
1916 1 ▶ for ($i=0;$i<=$#l;$i++) {
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#l) 1 1 2
1917 #chomp($l[$i]); #NO LONGER NEEDED 20000228
1918 1 ▶ if ($^O =~ /Win/i) #COND. ADDED 20010321 TO HANDLE WINDOZE FILENAMES (CAN BE UPPER & OR LOWER)!
Branch: 1 branch
BranchTrueFalseTotal
if ($^O =~ /Win/i) { } 0 1 1
1919 {
1920 0 $l[$i] =~ s/${full_path}(.*?)$self->{ext}/$1/i;
1921 0 $l[$i] =~ s/$self->{ext}$//i; #ADDED 20000418 - FORCE THIS!
1922 }
1923 else
1924 {
1925 1 $l[$i] =~ s/${full_path}(.*?)$self->{ext}/$1/;
1926 1 $l[$i] =~ s/$self->{ext}$//; #ADDED 20000418 - FORCE THIS!
1927 }
1928 1 push (@$values_or_error,[$l[$i]]);
1929 }
1930 1 unshift (@$values_or_error, ($#l+1));
1931 1 return $values_or_error;
1932 }
1933  
1934 #SPLIT UP THE FIELDS BEING REQUESTED.
1935  
1936 4 $self->{ASNAMES} = {}; #ADDED NEXT 4 LINES 20040913 TO SUPPORT "AS".
1937 4 ▶ while ($column_stuff =~ s/($self->{column})\s+(?:AS|as)\s+($self->{column})/$1/)
Branch: 1 branch
BranchTrueFalseTotal
if ($column_stuff =~ s/($self->{"column"})\s+(?:AS|as)\s+($self->{"column"})/$1/) 0 4 4
1938 {
1939 0 $self->{ASNAMES}->{$1} = $2;
1940 };
1941 4 $column_stuff =~ s/\s+$//o;
1942 4 while (1)
1943 {
1944 10 $found_parin = 0;
1945 10 $column_stuff =~ s/^\s+//o;
1946 10 $fnname = '';
1947 # $fnname = $1 if ($column_stuff =~ s/^(\w+)//); #CHGD TO NEXT 20020211!
1948 10 ▶ $fnname = $1 if ($column_stuff =~ s/^($self->{column}(?:\.(?:$psuedocols))?)//);
Branch: 1 branch
BranchTrueFalseTotal
if $column_stuff =~ s/^($self->{"column"}(?:\.(?:$psuedocols))?)// 7 3 10
1949 10 $column_stuff =~ s/^ +//o;
1950 10 ▶ last unless ($fnname);
Branch: 1 branch
BranchTrueFalseTotal
unless $fnname 3 7 10
1951 7 @column_stuff = split(//o,$column_stuff);
1952 7 ▶ if ($#column_stuff <= 0 || $column_stuff[0] eq ',')
Branch: 1 branch
BranchTrueFalseTotal
if ($#column_stuff <= 0 or $column_stuff[0] eq ",") 6 1 7
Condition100%3/3
$#column_stuff <= 0 or $column_stuff[0] eq ","
l!l&&r!l&&!r
331
MC/DC100%2/2
$#column_stuff <= 0 or $column_stuff[0] eq ","
$#column_stuff <= 0 $column_stuff[0] eq ","
Truth table100%3/3
A or B
A= $#column_stuff <= 0B= $column_stuff[0] eq ","
ABresult
1X1
011
000
1953 {
1954 6 push (@fields, $fnname);
1955 6 $column_stuff =~ s/^\,//o;
1956 6 next;
1957 }
1958  
1959 #FOR FUNCTIONS W/ARGS, WE MUST FIND THE CLOSING ")"!
1960  
1961 1 ▶ for ($i=0;$i<=length($column_stuff);$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= length $column_stuff) 58 0 58
1962 {
1963 58 ▶ if ($column_stuff[$i] eq '(')
Branch: 1 branch
BranchTrueFalseTotal
if ($column_stuff[$i] eq "(") 2 56 58
1964 {
1965 2 ++$parincnt;
1966 2 $found_parin = 1;
1967 }
1968 58 ▶ last if (!$parincnt && $found_parin);
Branch: 1 branch
BranchTrueFalseTotal
if not $parincnt and $found_parin 1 57 58
Condition66%2/3
not $parincnt and $found_parin
!ll&&!rl&&r
5701
MC/DC50%1/2
not $parincnt and $found_parin
not $parincnt $found_parin
Truth table66%2/3
not(A) and B
A= not $parincntB= $found_parin
ABresult
0X0
100
111
1969 57 ▶ --$parincnt if ($column_stuff[$i] eq ')');
Branch: 1 branch
BranchTrueFalseTotal
if $column_stuff[$i] eq ")" 2 55 57
1970 }
1971 1 push (@fields, ($fnname . substr($column_stuff,0,$i)));
1972 1 $t = substr($column_stuff,$i);
1973 1 $t =~ s/^\s*\,//o;
1974 1 ▶ last unless ($t);
Branch: 1 branch
BranchTrueFalseTotal
unless $t 1 0 1
1975 0 $column_stuff = $t;
1976 }
1977  
1978 #$thefid = $table;
1979 #$self->check_for_reload ($table) || return (-501); #CHGD. TO NEXT 20020110 TO BETTER CATCH ERRORS.
1980 4 ▶ my $cfr = $self->check_for_reload($table) || -501;
Condition50%1/2
$self->check_for_reload($table) || -501
l!l
40
MC/DC0%0/1
$self->check_for_reload($table) || -501
$self->check_for_reload($table)
Truth table50%1/2
A
A= $self->check_for_reload($table)
Aresult
11
00
1981 4 ▶ return $cfr if ($cfr < 0);
Branch: 1 branch
BranchTrueFalseTotal
if $cfr < 0 0 4 4
1982 4 $columns = '';
1983 4 my (@strings);
1984 4 my ($column_list) = '('.join ('|', @{ $self->{order} }).')';
1985  
1986 #DETERMINE WHICH WORDS ARE VALID COLUMN NAMES AND CONVERT THEM INTO
1987 #THE VARIABLE FOR LATER EVAL IN PARSE_EXPRESSION! OTHER WORDS ARE
1988 #TREATED AS FUNCTION NAMES AND ARE EVALLED AS THEY ARE.
1989  
1990 4 ▶ for (my $i=0;$i<=$#fields;$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#fields) 7 4 11
1991 {
1992 7 @strings = ();
1993  
1994 #FIRST, WE MUST PROTECT COLUMN NAMES APPEARING IN LITERAL STRINGS!
1995  
1996 7 $fields[$i] =~ s|(\'[^\']+\')|
1997 2 push (@strings, $1);
1998 2 "\x02\^2jSpR1tE\x02$#strings\x02\^2jSpR1tE\x02"
1999 |eg;
2000  
2001 #NOW CONVERT THE REMAINING COLUMN NAMES TO "$$_{COLUMN_NAME}"!
2002  
2003 #$fields[$i] =~ s/($column_list)/ #ADDED WORD-BOUNDARIES 20011129 TO FIX BUG WHERE ONE COLUMN NAME CONTAINED ANOTHER ONE, IE. "EMPL" AND "EMPLID".
2004 7 ▶ if ($self->{sprite_CaseFieldNames})
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'sprite_CaseFieldNames'}) { } 0 7 7
2005 {
2006 0 $fields[$i] =~ s/\b($column_list)\b/
2007 0 my ($column_name) = $1;
2008 0 $columns .= $column_name . ',';
2009 0 "\$\$\_\{$column_name\}"/ieg;
2010 }
2011 else
2012 {
2013 7 $fields[$i] =~ s/\b($column_list)\b/
2014 5 my ($column_name) = $1;
2015 5 $columns .= $column_name . ',';
2016 5 "\$\$\_\{\U$column_name\E\}"/ieg;
2017 }
2018 7 $fields[$i] =~ s/\x02\^2jSpR1tE\x02(\d+)\x02\^2jSpR1tE\x02/$strings[$1]/g; #UNPROTECT LITERALS!
2019 }
2020 4 chop ($columns);
2021  
2022 #PROCESS ANY WHERE AND ORDER-BY CLAUSES.
2023  
2024 #if ($extra =~ s/([\s|\)]+)order\s+by\s*(.*)/$1/i) #20011129
2025 4 ▶ if ($extra =~ s/([\s|\)]+)order\s+by\s*(.*)/$1/is)
Branch: 1 branch
BranchTrueFalseTotal
if ($extra =~ s/([\s|\)]+)order\s+by\s*(.*)/$1/is) 0 4 4
2026 {
2027 0 my $orderclause = $2;
2028 0 @ordercols = split(/,/o, $orderclause);
2029 #$descorder = ($ordercols[$#ordercols] =~ s/(\w+\W+)desc$/$1/i);
2030 #$descorder = ($ordercols[$#ordercols] =~ s/(\w+\W+)desc$/$1/is); #20011129
2031 0 ▶ for (my $i=0;$i<=$#ordercols;$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#ordercols) 0 0 0
2032 {
2033 0 $descorder = 'asc';
2034 0 ▶ $descorder = $2 if ($ordercols[$i] =~ s/(\w+)\W+(asc|desc|ascending|descending)$/$1/is); #20020708
Branch: 1 branch
BranchTrueFalseTotal
if $ordercols[$i] =~ s/(\w+)\W+(asc|desc|ascending|descending)$/$1/is 0 0 0
2035 0 push (@descorder, $descorder); #20020708
2036 }
2037 #$orderclause =~ s/,\s+/,/g;
2038 0 for $i (0..$#ordercols)
2039 {
2040 0 $ordercols[$i] =~ s/\s//go;
2041 0 $ordercols[$i] =~ s/[\(\)]+//go;
2042 }
2043 }
2044 #if ($extra =~ /^\s+where\s*(.+)$/i) #20011129
2045 4 ▶ if ($extra =~ /^\s+where\s*(.+)$/iso)
Branch: 1 branch
BranchTrueFalseTotal
if ($extra =~ /^\s+where\s*(.+)$/iso) 3 1 4
2046 {
2047 3 $condition = $self->parse_expression ($1);
2048 }
2049 4 ▶ if ($column_stuff =~ /\*/o)
Branch: 1 branch
BranchTrueFalseTotal
if ($column_stuff =~ /\*/o) 0 4 4
2050 {
2051 0 @fields = @{ $self->{order} };
2052 0 $columns = join (',', @fields);
2053 0 ▶ if ($self->{sprite_CaseFieldNames})
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'sprite_CaseFieldNames'}) { } 0 0 0
2054 {
2055 0 ▶ for (my $i=0;$i<=$#fields;$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#fields) 0 0 0
2056 {
2057 0 $fields[$i] =~ s/([^\,]+)/\$\$\_\{$1\}/g;
2058 }
2059 }
2060 else
2061 {
2062 0 ▶ for (my $i=0;$i<=$#fields;$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#fields) 0 0 0
2063 {
2064 #$fields[$i] =~ s/([^\,]+)/\$\$\_\{\U$1\E\}/g; #CHGD. TO NEXT 20030208 TO FIX WIERD BUG THAT $#?%ED UP NAMES SOMETIMES!
2065 0 $fields[$i] =~ s/([^\,]+)/\$\$\_\{$1\}/g;
2066 0 $fields[$i] =~ tr/a-z/A-Z/;
2067 }
2068 }
2069 }
2070 4 ▶ $columns =~ tr/a-z/A-Z/ unless ($self->{sprite_CaseFieldNames});
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"sprite_CaseFieldNames"} 4 0 4
2071 4 ▶ $self->check_columns ($columns) || return (-502);
Branch: 1 branch
BranchTrueFalseTotal
$self->check_columns($columns) or return -502 4 0 4
2072 #$self->{use_fields} = join (',', @{ $self->{order} }[0..$#fields] )
2073 4 ▶ if ($#fields >= 0)
Branch: 1 branch
BranchTrueFalseTotal
if ($#fields >= 0) 4 0 4
2074 {
2075 4 my (@fieldnames) = @fields;
2076 4 ▶ for (my $i=0;$i<=$#fields;$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#fields) 7 4 11
2077 {
2078 7 $fieldnames[$i] =~ s/\(.*$//o;
2079 7 $fieldnames[$i] =~ s/\$\_//o;
2080 7 $fieldnames[$i] =~ s/[^\w\,]//go;
2081 }
2082 4 $self->{use_fields} = join(',', @fieldnames);
2083 }
2084 4 $values_or_error = $self->parse_columns ('select', $columns,
2085 $condition, '', \@ordercols, \@descorder, \@fields, $distinct); #JWT
2086 4 return $values_or_error;
2087 }
2088 else #INVALID SELECT STATEMENT!
2089 {
2090 0 $errdetails = $query;
2091 0 return (-503);
2092 }
2093 }
2094  
2095 sub update
2096 1 ▶{
Subroutine update: called CC=13 SCAR=26.8
Pod documented
2097 1 my ($self, $query) = @_;
2098 1 my ($i, $path, $regex, $table, $extra, $condition, $all_columns,
2099 $columns, $status);
2100 1 my ($psuedocols) = "CURRVAL|NEXTVAL";
2101  
2102 ##++
2103 ## Hack to allow parenthesis to be escaped!
2104 ##--
2105  
2106 0 $query =~ s/\\([()])/sprintf ("%%\0%d: ", ord ($1))/ges;
2107 1 $path = $self->{path};
2108 1 $regex = $self->{column};
2109  
2110 1 ▶ if ($query =~ /^update\s+($path)\s+set\s+(.+)$/ios) {
Branch: 1 branch
BranchTrueFalseTotal
if ($query =~ /^update\s+($path)\s+set\s+(.+)$/iso) { } 1 0 1
2111 1 ($table, $extra) = ($1, $2);
2112 1 ▶ return (-523) if ($table =~ /^DUAL$/io);
Branch: 1 branch
BranchTrueFalseTotal
if $table =~ /^DUAL$/io 0 1 1
2113  
2114 #ADDED IF-STMT 20010418 TO CATCH
2115 #PARENTHESIZED SET-CLAUSES (ILLEGAL IN ORACLE & CAUSE WIERD PARSING ERRORS!)
2116 1 ▶ if ($extra =~ /^\(.+\)\s*where/so)
Branch: 1 branch
BranchTrueFalseTotal
if ($extra =~ /^\(.+\)\s*where/so) 0 1 1
2117 {
2118 0 $errdetails = 'parenthesis around SET clause?';
2119 0 return (-504);
2120 }
2121 #$thefid = $table;
2122 #$self->check_for_reload ($table) || return (-501); #CHGD. TO NEXT 20020110 TO BETTER CATCH ERRORS.
2123 1 ▶ my $cfr = $self->check_for_reload($table) || -501;
Condition50%1/2
$self->check_for_reload($table) || -501
l!l
10
MC/DC0%0/1
$self->check_for_reload($table) || -501
$self->check_for_reload($table)
Truth table50%1/2
A
A= $self->check_for_reload($table)
Aresult
11
00
2124 1 ▶ return $cfr if ($cfr < 0);
Branch: 1 branch
BranchTrueFalseTotal
if $cfr < 0 0 1 1
2125  
2126 1 ▶ return (-511) unless (-w $self->{file}); #ADDED 19991207!
Branch: 1 branch
BranchTrueFalseTotal
unless -w $self->{"file"} 0 1 1
2127  
2128 1 $all_columns = {};
2129 1 $columns = '';
2130  
2131 1 $extra =~ s/\\\\/\x02\^2jSpR1tE\x02/gso; #PROTECT "\\"
2132 #$extra =~ s/\\\'|\'\'/\x02\^3jSpR1tE\x02/gs; #PROTECT '', AND \'. #CHANGED 20000303 TO NEXT 2.
2133 #$extra =~ s/\'\'/\x02\^3jSpR1tE\x02\x02\^3jSpR1tE\x02/gs; #CHGD. TO NEXT 20040121
2134 #$extra =~ s/\'\'/\x02\^3jSpR1tE\x02\x02\^8jSpR1tE\x02/gs; #PROTECT '', AND \'.
2135 1 $extra =~ s/\'\'/\x02\^8jSpR1tE\x02/gso; #PROTECT ''.
2136 1 $extra =~ s/\\\'/\x02\^3jSpR1tE\x02/gso; #PROTECT \'.
2137 #$extra =~ s/\\\"|\"\"/\x02\^4jSpR1tE\x02/gs; #REMOVED 20000303.
2138  
2139 #$extra =~ s/^[\s\(]+(.*)$/$1/; #STRIP OFF SURROUNDING SPACES AND PARINS.
2140 #$extra =~ s/[\s\)]+$/$1/;
2141 #$extra =~ s/^[\s\(]+//; #STRIP OFF SURROUNDING SPACES AND PARINS.
2142 #$extra =~ s/[\s\)]+$//;
2143 1 $extra =~ s/^\s+//so; #STRIP OFF SURROUNDING SPACES.
2144 1 $extra =~ s/\s+$//so;
2145 #NOW TEMPORARILY PROTECT COMMAS WITHIN (), IE. FN(ARG1,ARG2).
2146 1 my $column = $self->{column};
2147 1 $extra =~ s/($column\s*\=\s*)\'(.*?)\'(,|$)/
2148 0 my ($one,$two,$three) = ($1,$2,$3);
2149 0 $two =~ s|\,|\x02\^5jSpR1tE\x02|go;
2150 0 $two =~ s|\(|\x02\^6jSpR1tE\x02|go;
2151 0 $two =~ s|\)|\x02\^7jSpR1tE\x02|go;
2152 0 $one."'".$two."'".$three;
2153 /egs;
2154  
2155 1 ▶ 1 while ($extra =~ s/\(([^\(\)]*)\)/
Branch: 1 branch
BranchTrueFalseTotal
$extra =~ s[\(([^\(\)]*)\)][my($args) = $1; $args =~ s/\,/\cB^5jSpR1tE\cB/go; "\cB^6jSpR1tE\cB$args\cB^7jSpR1tE\cB";]seg and do { '???' } 2 1 3
2156 3 my ($args) = $1;
2157 3 $args =~ s|\,|\x02\^5jSpR1tE\x02|go;
2158 3 "\x02\^6jSpR1tE\x02$args\x02\^7jSpR1tE\x02";
2159 /egs);
2160 ###$extra =~ s/\'(.*?)\'/my ($j)=$1; #PROTECT COMMAS IN QUOTES.
2161 ### $j=~s|,|\x02\^5jSpR1tE\x02|g;
2162 ### "'$j'"/eg;
2163 1 my @expns = split(',',$extra);
2164 1 ▶ for ($i=0;$i<=$#expns;$i++) #PROTECT "WHERE" IN QUOTED VALUES.
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#expns) 1 1 2
2165 {
2166 1 $expns[$i] =~ s/\x02\^5jSpR1tE\x02/,/gso;
2167 1 $expns[$i] =~ s/\x02\^6jSpR1tE\x02/\(/gso;
2168 1 $expns[$i] =~ s/\x02\^7jSpR1tE\x02/\)/gso;
2169 1 $expns[$i] =~ s/\=\s*'([^']*?)where([^']*?)'/\='$1\x02\^5jSpR1tE\x02$2'/gis;
2170 1 $expns[$i] =~ s/\'(.*?)\'/my ($j)=$1;
2171 1 $j=~s|where|\x02\^5jSpR1tE\x02|go;
2172 1 "'$j'"/egs;
2173 }
2174 1 $extra = $expns[$#expns]; #EXTRACT WHERE-CLAUSE, IF ANY.
2175 1 $extra =~ s/\x02\^8jSpR1tE\x02/\'\'/gso; #ADDED 20040121.
2176 1 ▶ $condition = ($extra =~ s/(.*)where(.+)$/where$1/is) ? $2 : '';
Branch: 1 branch
BranchTrueFalseTotal
$extra =~ s/(.*)where(.+)$/where$1/is ? : 1 0 1
2177 1 $condition =~ s/\s+//so;
2178 ####$condition =~ s/^\((.*)\)$/$1/g; #REMOVED 20010313 SO "WHERE ((COND) OP (COND) OP (COND)) WOULD WORK FOR DBIX-RECORDSET. (SELECT APPEARS TO WORK WITHOUT THIS).
2179 #$expns[$#expns] =~ s/where(.+)$//i;
2180 1 $expns[$#expns] =~ s/\s*where(.+)$//iso; #20000108 REP. PREV. LINE 2FIX BUG IF LAST COLUMN CONTAINS SINGLE QUOTES.
2181 ##########$expns[$#expns] =~ s/\s*\)\s*$//i; #20010416: ADDED TO FIX BUG WHERE LAST ")" BEFORE "WHERE" NOT STRIPPED!
2182 ##########ABOVE NOT A BUG -- MUST NOT USE PARINS AROUND UPDATE CLAUSE, IE.
2183 ##########"update table set (a = b, c = d) where e = f" is INVALID (IN ORACLE ALSO!!!!!!!!
2184 1 $column = $self->{column};
2185 1 $condition = $self->parse_expression ($condition);
2186 1 $columns = ''; #ADDED 20010228. (THESE CHGS FIXED INCORRECT ORDER BUG FOR "TYPE", "NAME", ETC. LISTS IN UPDATES).
2187 1 ▶ for ($i=0;$i<=$#expns;$i++) #EXTRACT FIELD NAMES AND
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#expns) 1 1 2
2188 #VALUES FROM EACH EXPRESSION.
2189 {
2190 1 $expns[$i] =~ s!\s*($column)\s*=\s*(.+)$!
2191 1 my ($var) = $1;
2192 1 my ($val) = $2;
2193  
2194 1 ▶ $var =~ tr/a-z/A-Z/ unless ($self->{sprite_CaseFieldNames});
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"sprite_CaseFieldNames"} 1 0 1
2195 1 $columns .= $var . ','; #ADDED 20010228.
2196 0 $val =~ s|%\0(\d+): |pack("C",$1)|ge;
2197 1 $all_columns->{$var} = $val;
2198 1 $all_columns->{$var} =~ s/\x02\^2jSpR1tE\x02/\\\\/g;
2199 1 $all_columns->{$var} =~ s/\x02\^8jSpR1tE\x02/\'\'/g; #ADDED 20040121.
2200 1 $all_columns->{$var} =~ s/\x02\^3jSpR1tE\x02/\'/g; #20000108 REPL. PREV. LINE - NO NEED TO DOUBLE QUOTES (WE ESCAPE THEM) - THIS AIN'T ORACLE.
2201 #$all_columns->{$var} =~ s/\x02\^4jSpR1tE\x02/\"\"/g; #REMOVED 20000303.
2202 !es;
2203 }
2204 #$columns = join (',', keys %$all_columns); #NEXT 2 CHGD TO 3RD LINE 20010228.
2205 #$columns =~ tr/a-z/A-Z/ unless ($self->{sprite_CaseFieldNames}); #JWT
2206 1 chop($columns); #ADDED 20010228.
2207 #$condition = ($extra =~ /^\s*where\s+(.+)$/is) ? $1 : '';
2208  
2209 #$self->check_for_reload ($table) || return (-501);
2210 1 ▶ $self->check_columns ($columns) || return (-502);
Branch: 1 branch
BranchTrueFalseTotal
$self->check_columns($columns) or return -502 1 0 1
2211 #### MOVED UP ABOVE FOR-LOOP SO "NEXTVAL" GETS EVALUATED IN RIGHT ORDER!
2212 ####$condition = $self->parse_expression ($condition);
2213 1 $status = $self->parse_columns ('update', $columns,
2214 $condition,
2215 $all_columns);
2216 1 return ($status);
2217 } else {
2218 0 $errdetails = $query;
2219 0 return (-504);
2220 }
2221 }
2222  
2223 sub delete
2224 0 ▶{
Subroutine delete: not called CC=6 SCAR=37.4
Pod documented
2225 0 my ($self, $query) = @_;
2226 0 my ($path, $table, $condition, $status, $wherepart);
2227  
2228 0 $path = $self->{path};
2229  
2230 0 ▶ if ($query =~ /^delete\s+from\s+($path)(?:\s+where\s+(.+))?$/ios) {
Branch: 1 branch
BranchTrueFalseTotal
if ($query =~ /^delete\s+from\s+($path)(?:\s+where\s+(.+))?$/iso) { } 0 0 0
2231 0 $table = $1;
2232 0 $wherepart = $2;
2233 #$thefid = $table;
2234 #$self->check_for_reload ($table) || return (-501); #CHGD. TO NEXT 20020110 TO BETTER CATCH ERRORS.
2235 0 ▶ my $cfr = $self->check_for_reload($table) || -501;
Condition0%0/2
$self->check_for_reload($table) || -501
l!l
00
MC/DC0%0/1
$self->check_for_reload($table) || -501
$self->check_for_reload($table)
Truth table0%0/2
A
A= $self->check_for_reload($table)
Aresult
11
00
2236 0 ▶ return $cfr if ($cfr < 0);
Branch: 1 branch
BranchTrueFalseTotal
if $cfr < 0 0 0 0
2237  
2238 0 ▶ return (-511) unless (-w $self->{file}); #ADDED 19991207!
Branch: 1 branch
BranchTrueFalseTotal
unless -w $self->{"file"} 0 0 0
2239 0 ▶ if ($wherepart =~ /\S/o)
Branch: 1 branch
BranchTrueFalseTotal
if ($wherepart =~ /\S/o) { } 0 0 0
2240 {
2241 0 $condition = $self->parse_expression ($wherepart);
2242 }
2243 else
2244 {
2245 0 $condition = 1;
2246 }
2247 #$self->check_for_reload ($table) || return (-501);
2248  
2249 0 $status = $self->delete_rows ($condition);
2250  
2251 0 return $status;
2252 } else {
2253 0 $errdetails = $query;
2254 0 return (-505);
2255 }
2256 }
2257  
2258 sub drop
2259 1 ▶{
Subroutine drop: called CC=5 SCAR=24.9
Pod undocumented
2260 1 my ($self, $query) = @_;
2261 1 my ($path, $table, $condition, $status, $wherepart);
2262  
2263 1 $path = $self->{path};
2264  
2265 1 $_ = undef;
2266 1 ▶ if ($query =~ /^drop\s+table\s+($path)\s*$/ios)
Branch: 1 branch
BranchTrueFalseTotal
if ($query =~ /^drop\s+table\s+($path)\s*$/iso) 1 0 1
2267 {
2268 1 $table = $1;
2269 #$self->check_for_reload ($table) || return (-501); #CHGD. TO NEXT 20020110 TO BETTER CATCH ERRORS.
2270 1 ▶ my $cfr = $self->check_for_reload($table) || -501;
Condition50%1/2
$self->check_for_reload($table) || -501
l!l
01
MC/DC0%0/1
$self->check_for_reload($table) || -501
$self->check_for_reload($table)
Truth table50%1/2
A
A= $self->check_for_reload($table)
Aresult
11
00
2271 1 ▶ return $cfr if ($cfr < 0);
Branch: 1 branch
BranchTrueFalseTotal
if $cfr < 0 1 0 1
2272  
2273 0 @{$self->{records}} = (); #ADDED 20021025 TO REMOVE DANGLING DATA (CAUSED TESTS TO FAIL AT 9)!
2274 0 @{$self->{order}} = ();
2275 0 %{$self->{types}} = ();
2276 0 %{$self->{lengths}} = ();
2277 0 %{$self->{scales}} = ();
2278 0 %{$self->{defaults}} = ();
2279 0 $self->{key_fields} = '';
2280  
2281 #SOME DAY, I SHOULD ADD CODE TO DELETE DANGLING BLOB FILES!!!!!!!
2282  
2283 # return (unlink $self->{file} || -501); #NEXT 2 CHGD. TO FOLLOWING 20020606.
2284 # return
2285 0 ▶ return (unlink $self->{file}) ? '0E0' : -501;
Branch: 1 branch
BranchTrueFalseTotal
unlink($self->{'file'}) ? : 0 0 0
2286 }
2287 0 $errdetails = $query;
2288 0 return (-501);
2289 }
2290  
2291 sub truncate
2292 0 ▶{
Subroutine truncate: not called CC=2 SCAR=17.9
Pod undocumented
2293 0 my ($self, $query) = @_;
2294 0 ▶ return $self->delete($query)
Branch: 1 branch
BranchTrueFalseTotal
if $query =~ s/^\s*truncate\s+table\s+/delete from /iso 0 0 0
2295 if ($query =~ s/^\s*truncate\s+table\s+/delete from /ios);
2296 0 $errdetails = $query;
2297 0 return (-533);
2298 }
2299  
2300 sub primary_key_info
2301 1 ▶{
Subroutine primary_key_info: called CC=4 SCAR=13.9
Pod undocumented
2302 1 my ($self, $query) = @_;
2303 1 my $table = $query;
2304 1 $table =~ s/^.*\s+(\w+)$/$1/;
2305 1 ▶ my $cfr = $self->check_for_reload($table) || -501;
Condition50%1/2
$self->check_for_reload($table) || -501
l!l
10
MC/DC0%0/1
$self->check_for_reload($table) || -501
$self->check_for_reload($table)
Truth table50%1/2
A
A= $self->check_for_reload($table)
Aresult
11
00
2306 1 ▶ return $cfr if ($cfr < 0);
Branch: 1 branch
BranchTrueFalseTotal
if $cfr < 0 0 1 1
2307 1 undef %{ $self->{types} };
2308 1 undef %{ $self->{lengths} };
2309 1 $self->{use_fields} = 'CAT,SCHEMA,TABLE_NAME,PRIMARY_KEY';
2310 1 $self->{order} = [ 'CAT', 'SCHEMA', 'TABLE_NAME', 'PRIMARY_KEY' ];
2311 1 $self->{fields}->{CAT} = 1;
2312 1 $self->{fields}->{SCHEMA} = 1;
2313 1 $self->{fields}->{TABLE_NAME} = 1;
2314 1 $self->{fields}->{PRIMARY_KEY} = 1;
2315 1 undef @{ $self->{records} };
2316 1 my (@keyfields) = split(',', $self->{key_fields}); #JWT: PREVENT DUP. KEYS.
2317 1 ${$self->{types}}{CAT} = 'VARCHAR2';
2318 1 ${$self->{types}}{SCHEMA} = 'VARCHAR2';
2319 1 ${$self->{types}}{TABLE_NAME} = 'VARCHAR2';
2320 1 ${$self->{types}}{PRIMARY_KEY} = 'VARCHAR2';
2321 1 ${$self->{lengths}}{CAT} = 50;
2322 1 ${$self->{lengths}}{SCHEMA} = 50;
2323 1 ${$self->{lengths}}{TABLE_NAME} = 50;
2324 1 ${$self->{lengths}}{PRIMARY_KEY} = 50;
2325 1 ${$self->{defaults}}{CAT} = undef;
2326 1 ${$self->{defaults}}{SCHEMA} = undef;
2327 1 ${$self->{defaults}}{TABLE_NAME} = undef;
2328 1 ${$self->{defaults}}{PRIMARY_KEY} = undef;
2329 1 ${$self->{scales}}{PRIMARY_KEY} = 50;
2330 1 ${$self->{scales}}{PRIMARY_KEY} = 50;
2331 1 ${$self->{scales}}{PRIMARY_KEY} = 50;
2332 1 ${$self->{scales}}{PRIMARY_KEY} = 50;
2333 1 my $results;
2334 1 my $keycnt = scalar(@keyfields);
2335 1 ▶ while (@keyfields)
Branch: 1 branch
BranchTrueFalseTotal
if (@keyfields) 1 1 2
2336 {
2337 1 push (@{$results}, [0, 0, $table, shift(@keyfields)]);
2338 }
2339 1 unshift (@$results, $keycnt);
2340 1 return $results;
2341 }
2342  
2343 sub delete_rows
2344 0 ▶{
Subroutine delete_rows: not called CC=8 SCAR=42.8
Pod undocumented
2345 0 my ($self, $condition) = @_;
2346 0 my ($status, $loop);
2347 0 ▶ local $SIG{'__WARN__'} = sub { $status = -510; $errdetails = "$_[0] at ".__LINE__ };
Subroutine __ANON__: not called CC=1 SCAR=6.9
2348 0 local $^W = 0;
2349  
2350 #$status = 1;
2351 0 $status = 0;
2352  
2353 0 my @blobcols;
2354 0 foreach my $i (keys %{$self->{types}})
2355 {
2356 0 ▶ push (@blobcols, $i) if (${$self->{types}}{$i} =~ /$REFTYPES/o)
Branch: 1 branch
BranchTrueFalseTotal
if do { $$self{"types"} }->{$i} =~ /$REFTYPES/o 0 0 0
2357 }
2358 0 my ($blobfid, $delfid, $rawvalue);
2359
2360 0 $loop = 0;
2361 0 while (1)
2362 {
2363 #last if ($loop > scalar @{ $self->{records} });
2364 #last if (!scalar(@{$self->{records}}) || $loop > scalar @{ $self->{records} }); #JWT: 19991222
2365 0 ▶ last if (!scalar(@{$self->{records}}) || $loop >= scalar @{ $self->{records} }); #JWT: 20000609 FIX INFINITE LOOP!
Branch: 1 branch
BranchTrueFalseTotal
if not scalar @{$self->{"records"};} or $loop >= scalar @{$self->{"records"};} 0 0 0
Condition0%0/3
not scalar @{$self->{"records"};} or $loop >= scalar @{$self->{"records"};}
l!l&&r!l&&!r
000
MC/DC0%0/2
not scalar @{$self->{"records"};} or $loop >= scalar @{$self->{"records"};}
not scalar @{$self->{"records"};} $loop >= scalar @{$self->{"records"};}
Truth table0%0/3
not(A) or B
A= not scalar @{$self->{"records"};}B= $loop >= scalar @{$self->{"records"};}
ABresult
1X1
011
000
2366  
2367 0 $_ = $self->{records}->[$loop];
2368
2369 0 ▶ if (eval $condition)
Branch: 1 branch
BranchTrueFalseTotal
if (eval $condition) { } 0 0 0
2370 {
2371 0 foreach my $i (@blobcols)
2372 {
2373 0 $rawvalue = $self->{records}->[$loop]->{$i};
2374 $blobfid = $self->{directory}
2375 .$self->{separator}->{ $self->{platform} }
2376 0 .$self->{table}."_${rawvalue}.ldt";
2377 $delfid = $self->{directory}
2378 .$self->{separator}->{ $self->{platform} }
2379 0 .$self->{table}."_${rawvalue}_$$.del";
2380 0 rename ($blobfid, $delfid);
2381 }
2382 #$self->{records}->[$loop] = undef;
2383 0 splice(@{ $self->{records} }, $loop, 1);
2384 0 ++$status; #LET'S COUNT THE # RECORDS DELETED!
2385 }
2386 else
2387 {
2388 0 ++$loop;
2389 }
2390 }
2391  
2392 0 ▶ $self->{dirty} = 1 if ($status > 0);
Branch: 1 branch
BranchTrueFalseTotal
if $status > 0 0 0 0
2393 0 return $status;
2394 }
2395  
2396 sub create
2397 2 ▶{
Subroutine create: called CC=41 SCAR=53.0
Pod documented
2398 2 my ($self, $query) = @_;
2399  
2400 2 my ($i, @keyfields, @values);
2401 ### create table table1 (field1 number, field2 varchar(20), field3 number(5,3))
2402 2 local (*FILE, $^W);
2403 2 local ($/) = $self->{_record}; #JWT:SUPPORT ANY RECORD-SEPARATOR!
2404  
2405 2 $^W = 0;
2406 2 ▶ if ($query =~ /^create\s+table\s+($self->{path})\s*\((.+)\)\s*$/is)
Branch: 2 branches
BranchTrueFalseTotal
if ($query =~ /^create\s+table\s+($self->{'path'})\s*\((.+)\)\s*$/is) { } 1 1 2
elsif ($query =~ /^create\s+sequence\s+($self->{'path'})(?:\s+inc(?:rement)?\s+by\s+(\d+))?(?:\s+start\s+with\s+(\d+))?/is) { } 1 0 1
2407 {
2408 1 my ($table, $extra) = ($1, $2);
2409  
2410 1 ▶ $query =~ tr/a-z/A-Z/s unless ($self->{sprite_CaseFieldNames}); #ADDED 20000225;
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"sprite_CaseFieldNames"} 1 0 1
2411 #$extra =~ tr/a-z/A-Z/; #ADDED 20000225;
2412 1 $extra =~ s/^\s*//so;
2413 1 $extra =~ s/\s*$//so;
2414 1 $extra =~ s/\((.*?)\)/
2415 4 my ($precision) = $1;
2416 4 $precision =~ s|\,|\x02\^2jSpR1tE\x02|g; #PROTECT COMMAS IN ().
2417 4 "($precision)"/egs;
2418 1 $extra =~ s/([\'\"])([^\1]*?)\1/
2419 0 my ($quote) = $1;
2420 0 my ($str) = $2;
2421 0 $str =~ s|\,|\x02\^2jSpR1tE\x02|g; #PROTECT COMMAS IN QUOTES.
2422 0 "$quote$str$quote"/egs;
2423  
2424 1 my (@fieldlist) = split(/,/o ,$extra);
2425 1 my $fieldname;
2426 1 ▶ for ($i=0;$i<=$#fieldlist;$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#fieldlist) 4 1 5
2427 {
2428 4 $fieldlist[$i] =~ s/^\s+//gso;
2429 4 $fieldlist[$i] =~ s/\s+$//gso;
2430 4 ▶ if ($fieldlist[$i] =~ s/^PRIMARY\s+KEY\s*\(([^\)]+)\)$//i)
Branch: 1 branch
BranchTrueFalseTotal
if ($fieldlist[$i] =~ s/^PRIMARY\s+KEY\s*\(([^\)]+)\)$//i) 1 3 4
2431 {
2432 1 my $keyfields = $1;
2433 1 $keyfields =~ s/\s+//go;
2434 1 ▶ $keyfields =~ tr/a-z/A-Z/ unless ($self->{sprite_CaseFieldNames});
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"sprite_CaseFieldNames"} 1 0 1
2435 1 @keyfields = split(/\x02\^2jSpR1tE\x02/o ,$keyfields);
2436 }
2437 }
2438  
2439 #ALTERED THIS ROUTINE 20021024 TO DO CREATES VIA WRITE_FILE (AS IT SHOULD!)
2440 #SO THAT NEW XML TABLES GET CREATED IN XML!!!!
2441  
2442 1 @{$self->{order}} = ();
2443 1 %{$self->{types}} = ();
2444 1 %{$self->{lengths}} = ();
2445 1 %{$self->{scales}} = ();
2446 1 %{$self->{defaults}} = ();
2447 1 ▶ while (@fieldlist)
Branch: 1 branch
BranchTrueFalseTotal
if (@fieldlist) 4 0 4
2448 {
2449 4 $i = shift(@fieldlist);
2450 #$i =~ s/^\s*\(\s*//;
2451 4 ▶ last unless ($i =~ /\S/o);
Branch: 1 branch
BranchTrueFalseTotal
unless $i =~ /\S/o 1 3 4
2452 3 $i =~ s/\s+DEFAULT\s+(?:([\'\"])([^\1]*?)\1|([\+\-]?[\d\.]+)|(NULL))$/
2453 0 ▶ my ($value) = $4 || $3 || $2 || $1;
Condition0%0/9
$4 || $3 || $2 || $1
l!l&&r!l&&!r
000
$4 or $3 or $2
l!l&&r!l&&!r
000
$4 or $3
l!l&&r!l&&!r
000
MC/DC0%0/4
$4 || $3 || $2 || $1
$4 $3 $2 $1
Truth table0%0/5
A or B or C || D
A= $4B= $3C= $2D= $1
ABCDresult
1XXX1
01XX1
001X1
00011
00000
2454 0 ▶ $value = '' if ($4);
Branch: 1 branch
BranchTrueFalseTotal
if $4 0 0 0
2455 0 push (@values, $value);
2456 0 "=<3>"/ieg;
2457 3 $i =~ s/\s+/=/o;
2458 3 ▶ $i =~ tr/a-z/A-Z/ unless ($self->{sprite_CaseFieldNames});
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"sprite_CaseFieldNames"} 3 0 3
2459 3 $fieldname = $i;
2460 3 $fieldname =~ s/=.*//o;
2461 #NEXT LINE ADDED 20030901 TO ALLOW PRIMARY-KEY ATTRIBUTE ON SAME LINE AS FIELD.
2462 3 ▶ push (@keyfields, $fieldname) if ($i =~ s/\s*PRIMARY\s+KEY\s*//i);
Branch: 1 branch
BranchTrueFalseTotal
if $i =~ s/\s*PRIMARY\s+KEY\s*//i 0 3 3
2463 3 my ($tp,$len,$scale);
2464 3 $i =~ s/\w+\=//o;
2465 3 $i =~ s/\s+//go;
2466 3 ▶ if ($i =~ /(\w+)(?:\((\d+))?(?:\x02\^2jSpR1tE\x02(\d+))?/o)
Branch: 1 branch
BranchTrueFalseTotal
if ($i =~ /(\w+)(?:\((\d+))?(?:\x02\^2jSpR1tE\x02(\d+))?/o) { } 3 0 3
2467 {
2468 3 $tp = $1;
2469 3 $len = $2;
2470 3 $scale = $3;
2471 }
2472 else
2473 {
2474 0 $tp = 'VARCHAR2';
2475 }
2476 3 ▶ unless ($len)
Branch: 1 branch
BranchTrueFalseTotal
unless ($len) 0 3 3
2477 {
2478 0 $len = 40;
2479 0 ▶ $len = 10 if ($tp =~ /NUM|INT|FLOAT|DOUBLE/o);
Branch: 1 branch
BranchTrueFalseTotal
if $tp =~ /NUM|INT|FLOAT|DOUBLE/o 0 0 0
2480 #$len = 5000 if ($tp =~ /LONG|BLOB|MEMO/); #CHGD TO NEXT 20020110.
2481 0 ▶ $len = $self->{LongReadLen} || 0 if ($tp =~ /$BLOBTYPES/);
Branch: 1 branch
BranchTrueFalseTotal
if $tp =~ /$BLOBTYPES/ 0 0 0
Condition0%0/2
$self->{'LongReadLen'} || 0
l!l
00
MC/DC0%0/1
$self->{'LongReadLen'} || 0
$self->{'LongReadLen'}
Truth table0%0/2
A
A= $self->{'LongReadLen'}
Aresult
11
00
2482 }
2483 3 ▶ unless ($scale)
Branch: 1 branch
BranchTrueFalseTotal
unless ($scale) 3 0 3
2484 {
2485 3 $scale = $len;
2486 3 ▶ if ($tp eq 'FLOAT')
Branch: 2 branches
BranchTrueFalseTotal
if ($tp eq 'FLOAT') { } 0 3 3
elsif ($tp =~ /$NUMERICTYPES/) { } 1 2 3
2487 {
2488 0 $scale -= 3;
2489 }
2490 elsif ($tp =~ /$NUMERICTYPES/)
2491 {
2492 1 $scale = 0;
2493 }
2494 }
2495 3 my ($value) = '';
2496 3 ▶ if ($i =~ /\<3\>/)
Branch: 1 branch
BranchTrueFalseTotal
if ($i =~ /\<3\>/) 0 3 3
2497 {
2498 0 $value = shift(@values);
2499 0 my ($rawvalue);
2500 #if ($tp =~ /$NUMERICTYPES/) #CHGD TO NEXT LINE 20010313.
2501 0 ▶ if (length($value) > 0 && $tp =~ /$NUMERICTYPES/)
Branch: 1 branch
BranchTrueFalseTotal
if (length $value > 0 and $tp =~ /$NUMERICTYPES/) { } 0 0 0
Condition0%0/3
length $value > 0 and $tp =~ /$NUMERICTYPES/
!ll&&!rl&&r
000
MC/DC0%0/2
length $value > 0 and $tp =~ /$NUMERICTYPES/
length $value > 0 $tp =~ /$NUMERICTYPES/
Truth table0%0/3
A and B
A= length $value > 0B= $tp =~ /$NUMERICTYPES/
ABresult
0X0
100
111
2502 {
2503 0 $rawvalue = sprintf(('%.'.$scale.'f'),
2504 $value);
2505 }
2506 else
2507 {
2508 0 $rawvalue = $value;
2509 }
2510 #$value = substr($rawvalue,0,$len); #CHGD. TO NEXT 20020110.
2511 0 ▶ $value = ($tp =~ /$BLOBTYPES/) ? $rawvalue : substr($rawvalue,0,$len);
Branch: 1 branch
BranchTrueFalseTotal
$tp =~ /$BLOBTYPES/ ? : 0 0 0
2512 0 ▶ unless ($self->{LongTruncOk} || $value eq $rawvalue ||
Branch: 1 branch
BranchTrueFalseTotal
unless ($self->{"LongTruncOk"} or $value eq $rawvalue or $tp eq "FLOAT") 0 0 0
Condition0%0/6
$self->{"LongTruncOk"} or $value eq $rawvalue or $tp eq "FLOAT"
l!l&&r!l&&!r
000
$self->{"LongTruncOk"} or $value eq $rawvalue
l!l&&r!l&&!r
000
MC/DC0%0/3
$self->{"LongTruncOk"} or $value eq $rawvalue or $tp eq "FLOAT"
$self->{"LongTruncOk"} $value eq $rawvalue $tp eq "FLOAT"
Truth table0%0/4
A or B or C
A= $self->{"LongTruncOk"}B= $value eq $rawvalueC= $tp eq "FLOAT"
ABCresult
1XX1
01X1
0011
0000
2513 ($tp eq 'FLOAT'))
2514 {
2515 0 $errdetails = "$fieldname to $len chars";
2516 0 return (-519);
2517 }
2518 0 ▶ if (($tp eq 'FLOAT')
Branch: 1 branch
BranchTrueFalseTotal
if ($tp eq "FLOAT" and int $value != int $rawvalue) 0 0 0
Condition0%0/3
$tp eq "FLOAT" and int $value != int $rawvalue
!ll&&!rl&&r
000
MC/DC0%0/2
$tp eq "FLOAT" and int $value != int $rawvalue
$tp eq "FLOAT" int $value != int $rawvalue
Truth table0%0/3
A and B
A= $tp eq "FLOAT"B= int $value != int $rawvalue
ABresult
0X0
100
111
2519 && (int($value) != int($rawvalue)))
2520 {
2521 0 $errdetails = "$fieldname to $len chars";
2522 0 return (-519);
2523 }
2524 # if ($tp eq 'CHAR') #CHGD. TO NEXT 20030812.
2525 0 ▶ if ($tp eq 'CHAR' && length($rawvalue) > 0)
Branch: 1 branch
BranchTrueFalseTotal
if ($tp eq 'CHAR' and length $rawvalue > 0) { } 0 0 0
Condition0%0/3
$tp eq "CHAR" and length $rawvalue > 0
!ll&&!rl&&r
000
MC/DC0%0/2
$tp eq "CHAR" and length $rawvalue > 0
$tp eq "CHAR" length $rawvalue > 0
Truth table0%0/3
A and B
A= $tp eq "CHAR"B= length $rawvalue > 0
ABresult
0X0
100
111
2526 {
2527 0 $rawvalue = sprintf('%-'.$len.'s',$value);
2528 }
2529 else
2530 {
2531 0 $rawvalue = $value;
2532 }
2533 # if ($tp eq 'CHAR') #REDUNDANT CODE REMOVED 20030812
2534 # {
2535 # $value = sprintf('%-'.$len.'s',$rawvalue);
2536 # }
2537 # else
2538 # {
2539 # $value = $rawvalue;
2540 # }
2541 }
2542 3 push (@{$self->{order}}, $fieldname);
2543 3 ${$self->{types}}{$fieldname} = $tp;
2544 3 ${$self->{lengths}}{$fieldname} = $len;
2545 3 ${$self->{scales}}{$fieldname} = $scale;
2546 3 ${$self->{defaults}}{$fieldname} = $value;
2547 }
2548 1 $self->{key_fields} = join(',',@keyfields);
2549 1 $self->{dirty} = 1;
2550 1 @{$self->{records}} = (); #ADDED 20021025 TO REMOVE DANGLING DATA (CAUSED TESTS TO FAIL AT 9)!
2551  
2552 1 $self->commit($table); #ALWAYS AUTOCOMMIT NEW TABLES (ORACLE DOES)!
2553 1 ▶ my $cfr = $self->check_for_reload($table) || -501;
Condition50%1/2
$self->check_for_reload($table) || -501
l!l
10
MC/DC0%0/1
$self->check_for_reload($table) || -501
$self->check_for_reload($table)
Truth table50%1/2
A
A= $self->check_for_reload($table)
Aresult
11
00
2554 1 ▶ return $cfr if ($cfr < 0);
Branch: 1 branch
BranchTrueFalseTotal
if $cfr < 0 0 1 1
2555 }
2556 elsif ($query =~ /^create\s+sequence\s+($self->{path})(?:\s+inc(?:rement)?\s+by\s+(\d+))?(?:\s+start\s+with\s+(\d+))?/is)
2557 {
2558 1 my ($seqfid, $incval, $startval) = ($1, $2, $3);
2559  
2560 1 ▶ $incval = 1 unless ($incval);
Branch: 1 branch
BranchTrueFalseTotal
unless $incval 1 0 1
2561 1 ▶ $startval = 0 unless ($startval);
Branch: 1 branch
BranchTrueFalseTotal
unless $startval 1 0 1
2562  
2563 1 my ($new_file) = $self->get_path_info($seqfid) . '.seq';
2564 #### $new_file =~ tr/A-Z/a-z/ unless ($self->{CaseTableNames}); #JWT:TABLE-NAMES ARE NOW CASE-INSENSITIVE!
2565 1 ▶ unlink ($new_file) if ($self->{sprite_forcereplace} && -e $new_file); #ADDED 20010912.
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"sprite_forcereplace"} and -e $new_file 0 1 1
Condition33%1/3
$self->{"sprite_forcereplace"} and -e $new_file
!ll&&!rl&&r
100
MC/DC0%0/2
$self->{"sprite_forcereplace"} and -e $new_file
$self->{"sprite_forcereplace"} -e $new_file
Truth table33%1/3
A and B
A= $self->{"sprite_forcereplace"}B= -e $new_file
ABresult
0X0
100
111
2566 1 ▶ if (open (FILE, ">$new_file"))
Branch: 1 branch
BranchTrueFalseTotal
if (open FILE, ">$new_file") { } 1 0 1
2567 {
2568 1 print FILE "$startval,$incval\n";
2569 1 close (FILE);
2570 }
2571 else
2572 {
2573 0 $errdetails = "$@/$? (file:$new_file)";
2574 0 return -511;
2575 }
2576 }
2577 else #ADDED 20020222 TO CHECK WHETHER TABLE CREATED!
2578 {
2579 0 $errdetails = $query;
2580 0 return -530;
2581 }
2582 }
2583  
2584 sub alter
2585 0 ▶{
Subroutine alter: not called CC=57 SCAR=81.0
Pod documented
2586 0 my ($self, $query) = @_;
2587 0 my ($i, $path, $regex, $table, $extra, $type, $column, $count, $status, $fd);
2588 0 my ($posn);
2589 0 my (@keyfields) = split(',', $self->{key_fields}); #JWT: PREVENT DUP. KEYS.
2590  
2591 0 $path = $self->{path};
2592 0 $regex = $self->{column};
2593  
2594 0 ▶ if ($query =~ /^alter\s+table\s+($path)\s+(.+)$/ios)
Branch: 1 branch
BranchTrueFalseTotal
if ($query =~ /^alter\s+table\s+($path)\s+(.+)$/iso) { } 0 0 0
2595 {
2596 0 ($table, $extra) = ($1, $2);
2597 0 ▶ if ($extra =~ /^(add|modify|drop)\s*(.+)$/ios)
Branch: 1 branch
BranchTrueFalseTotal
if ($extra =~ /^(add|modify|drop)\s*(.+)$/iso) { } 0 0 0
2598 {
2599 0 my ($type, $columnstuff) = ($1, $2);
2600 0 $columnstuff =~ s/^\s*\(//s;
2601 0 $columnstuff =~ s/\)\s*$//s;
2602 ###alter table table2 add (newcol1 varchar(5), newcol2 varchar(10))
2603 0 $columnstuff =~ s/\((.*?)\)/
2604 0 my ($precision) = $1;
2605 0 $precision =~ s|\,|\x02\^2jSpR1tE\x02|g; #PROTECT COMMAS IN ().
2606 0 "($precision)"/egs;
2607 0 $columnstuff =~ s/([\'\"])([^\1]*?)\1/
2608 0 my ($quote) = $1;
2609 0 my ($str) = $2;
2610 0 $str =~ s|\,|\x02\^2jSpR1tE\x02|gs; #PROTECT COMMAS IN QUOTES.
2611 0 "$quote$str$quote"/egs;
2612  
2613 #$thefid = $table;
2614 #$self->check_for_reload ($table) || return (-501); #CHGD. TO NEXT 20020110 TO BETTER CATCH ERRORS.
2615 0 ▶ my $cfr = $self->check_for_reload($table) || -501;
Condition0%0/2
$self->check_for_reload($table) || -501
l!l
00
MC/DC0%0/1
$self->check_for_reload($table) || -501
$self->check_for_reload($table)
Truth table0%0/2
A
A= $self->check_for_reload($table)
Aresult
11
00
2616 0 ▶ return $cfr if ($cfr < 0);
Branch: 1 branch
BranchTrueFalseTotal
if $cfr < 0 0 0 0
2617  
2618 0 my (@values) = ();
2619 0 my (@fieldlist) = split(/,/,$columnstuff);
2620 0 my ($olddf, $oldln, $tp, $x);
2621 0 ▶ while (@fieldlist)
Branch: 1 branch
BranchTrueFalseTotal
if (@fieldlist) 0 0 0
2622 {
2623 0 $i = shift(@fieldlist);
2624 0 $i =~ s/^\s+//go;
2625 0 $i =~ s/\s+$//go;
2626 0 ▶ last unless ($i =~ /\S/o);
Branch: 1 branch
BranchTrueFalseTotal
unless $i =~ /\S/o 0 0 0
2627 0 $i =~ s/\x02\^2jSpR1tE\x02/\,/go;
2628 0 $i =~ s/\s+DEFAULT\s+(?:([\'\"])([^\1]*?)\1|([\+\-]?[\d\.]+)|(NULL))$/
2629 0 ▶ my ($value) = $4 || $3 || $2 || $1;
Condition0%0/9
$4 || $3 || $2 || $1
l!l&&r!l&&!r
000
$4 or $3 or $2
l!l&&r!l&&!r
000
$4 or $3
l!l&&r!l&&!r
000
MC/DC0%0/4
$4 || $3 || $2 || $1
$4 $3 $2 $1
Truth table0%0/5
A or B or C || D
A= $4B= $3C= $2D= $1
ABCDresult
1XXX1
01XX1
001X1
00011
00000
2630 0 ▶ $value = "\x02\^4jSpR1tE\x02" if ($4);
Branch: 1 branch
BranchTrueFalseTotal
if $4 0 0 0
2631 0 push (@values, $value);
2632 0 "=\x02\^3jSpR1tE\x02"/ieg;
2633 0 $posn = undef;
2634 0 ▶ $posn = $1 if ($i =~ s/^(\d+)\s*//o);
Branch: 1 branch
BranchTrueFalseTotal
if $i =~ s/^(\d+)\s*//o 0 0 0
2635 0 $i =~ s/\s+/=/o;
2636 0 $fd = $i;
2637 0 $fd =~ s/=.*//o;
2638 0 ▶ $fd =~ tr/a-z/A-Z/ unless ($self->{sprite_CaseFieldNames});
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"sprite_CaseFieldNames"} 0 0 0
2639 0 ▶ for (my $j=0;$j<=$#keyfields;$j++)
Branch: 1 branch
BranchTrueFalseTotal
if ($j <= $#keyfields) 0 0 0
2640 {
2641 0 ▶ $i =~ s/=/=*/o if ($fd eq $keyfields[$j]);
Branch: 1 branch
BranchTrueFalseTotal
if $fd eq $keyfields[$j] 0 0 0
2642 }
2643 0 $x = undef;
2644 0 $tp = undef;
2645 0 $i =~ /\w+\=[\*]?(\w*)\s*(.*)/o;
2646 0 ($tp, $x) = ($1, $2);
2647 0 $oldln = 0;
2648 0 $tp =~ tr/a-z/A-Z/;
2649 0 ▶ if ($type =~ /modify/io)
Branch: 1 branch
BranchTrueFalseTotal
if ($type =~ /modify/io) 0 0 0
2650 {
2651 0 ▶ unless ($tp =~ /[a-zA-Z]/)
Branch: 1 branch
BranchTrueFalseTotal
unless ($tp =~ /[a-zA-Z]/) 0 0 0
2652 {
2653 0 $tp = $self->{types}->{$fd};
2654 }
2655 0 ▶ unless ($tp eq $self->{types}->{$fd})
Branch: 1 branch
BranchTrueFalseTotal
unless ($tp eq $self->{"types"}{$fd}) 0 0 0
2656 {
2657 0 ▶ if ($#{$self->{records}} >= 0)
Branch: 1 branch
BranchTrueFalseTotal
if ($#{$$self{"records"};} >= 0) 0 0 0
2658 {
2659 0 $errdetails = ($#{$self->{records}}+1) . ' records!';
2660 0 return -521;
2661 }
2662 }
2663 0 $olddf = undef;
2664 0 ▶ $olddf = $self->{defaults}->{$fd} if (defined $self->{defaults}->{$fd});
Branch: 1 branch
BranchTrueFalseTotal
if defined $self->{"defaults"}{$fd} 0 0 0
2665 0 ▶ unless ($tp eq $self->{types}->{$fd})
Branch: 1 branch
BranchTrueFalseTotal
unless ($tp eq $self->{"types"}{$fd}) 0 0 0
2666 {
2667 0 $self->{lengths}->{$fd} = 0;
2668 0 $self->{scales}->{$fd} = 0;
2669 }
2670 0 $oldln = $self->{lengths}->{$fd};
2671 }
2672 0 $self->{defaults}->{$fd} = undef;
2673 0 ▶ $self->{lengths}->{$fd} = $1 if ($x =~ s/(\d+)//o);
Branch: 1 branch
BranchTrueFalseTotal
if $x =~ s/(\d+)//o 0 0 0
2674 0 ▶ unless ($self->{lengths}->{$fd})
Branch: 1 branch
BranchTrueFalseTotal
unless ($self->{"lengths"}{$fd}) 0 0 0
2675 {
2676 0 $self->{lengths}->{$fd} = 40;
2677 0 ▶ $self->{lengths}->{$fd} = 10 if ($tp =~ /NUM|INT|FLOAT|DOUBLE/o);
Branch: 1 branch
BranchTrueFalseTotal
if $tp =~ /NUM|INT|FLOAT|DOUBLE/o 0 0 0
2678 #$self->{lengths}->{$fd} = 5000 if ($tp =~ /$BLOBTYPES/); #CHGD. 20020110
2679 0 ▶ $self->{lengths}->{$fd} = $self->{LongReadLen} || 0 if ($tp =~ /$BLOBTYPES/);
Branch: 1 branch
BranchTrueFalseTotal
if $tp =~ /$BLOBTYPES/ 0 0 0
Condition0%0/2
$self->{'LongReadLen'} || 0
l!l
00
MC/DC0%0/1
$self->{'LongReadLen'} || 0
$self->{'LongReadLen'}
Truth table0%0/2
A
A= $self->{'LongReadLen'}
Aresult
11
00
2680 }
2681 0 ▶ if ($self->{lengths}->{$fd} < $oldln && $tp !~ /$BLOBTYPES/)
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{"lengths"}{$fd} < $oldln and not $tp =~ /$BLOBTYPES/) 0 0 0
Condition0%0/3
$self->{"lengths"}{$fd} < $oldln and not $tp =~ /$BLOBTYPES/
!ll&&!rl&&r
000
MC/DC0%0/2
$self->{"lengths"}{$fd} < $oldln and not $tp =~ /$BLOBTYPES/
$self->{"lengths"}{$fd} < $oldln not $tp =~ /$BLOBTYPES/
Truth table0%0/3
A and not(B)
A= $self->{"lengths"}{$fd} < $oldlnB= not $tp =~ /$BLOBTYPES/
ABresult
0X0
100
111
2682 {
2683 0 $errdetails = $fd;
2684 0 return -522;
2685 }
2686 0 $x =~ s/\x02\^3jSpR1tE\x02/
2687 0 $self->{defaults}->{$fd} = shift(@values);
2688 #$self->{defaults}->{$fd} =~ s|\x02\^2jSpR1tE\x02|\,|g;
2689 0 $self->{defaults}->{$fd}/eg;
2690 0 $self->{fields}->{$fd} = 1;
2691 0 ▶ if ($self->{types}->{$fd} =~ /$REFTYPES/o || $tp =~ /$REFTYPES/o)
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{"types"}{$fd} =~ /$REFTYPES/o or $tp =~ /$REFTYPES/o) 0 0 0
Condition0%0/3
$self->{"types"}{$fd} =~ /$REFTYPES/o or $tp =~ /$REFTYPES/o
l!l&&r!l&&!r
000
MC/DC0%0/2
$self->{"types"}{$fd} =~ /$REFTYPES/o or $tp =~ /$REFTYPES/o
$self->{"types"}{$fd} =~ /$REFTYPES/o $tp =~ /$REFTYPES/o
Truth table0%0/3
A or B
A= $self->{"types"}{$fd} =~ /$REFTYPES/oB= $tp =~ /$REFTYPES/o
ABresult
1X1
011
000
2692 {
2693 0 $errdetails = "$fd: ".$self->{types}->{$fd}." <=> $tp";
2694 0 return -529;
2695 }
2696 0 $self->{types}->{$fd} = $tp;
2697 $self->{defaults}->{$fd} = $olddf
2698 0 ▶ if ((defined $olddf) && !(defined $self->{defaults}->{$fd}));
Branch: 1 branch
BranchTrueFalseTotal
if defined $olddf and not defined $self->{"defaults"}{$fd} 0 0 0
Condition0%0/3
defined $olddf and not defined $self->{"defaults"}{$fd}
!ll&&!rl&&r
000
MC/DC0%0/2
defined $olddf and not defined $self->{"defaults"}{$fd}
defined $olddf not defined $self->{"defaults"}{$fd}
Truth table0%0/3
A and not(B)
A= defined $olddfB= not defined $self->{"defaults"}{$fd}
ABresult
0X0
100
111
2699 0 ▶ $self->{defaults}->{$fd} = undef if ($self->{defaults}->{$fd} eq "\x02\^4jSpR1tE\x02");
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"defaults"}{$fd} eq "\2^4jSpR1tE\2" 0 0 0
2700 0 ▶ if ($x =~ s/\,\s*(\d+)//o)
Branch: 2 branches
BranchTrueFalseTotal
if ($x =~ s/\,\s*(\d+)//o) { } 0 0 0
elsif ($self->{'types'}{$fd} eq 'FLOAT') { } 0 0 0
2701 {
2702 0 $self->{scales}->{$fd} = $1;
2703 }
2704 elsif ($self->{types}->{$fd} eq 'FLOAT')
2705 {
2706 0 $self->{scales}->{$fd} = $self->{lengths}->{$fd} - 3;
2707 }
2708 0 ▶ if (defined $self->{defaults}->{$fd})
Branch: 1 branch
BranchTrueFalseTotal
if (defined $self->{"defaults"}{$fd}) 0 0 0
2709 {
2710 0 my ($val);
2711 #if (${$self->{types}}{$fd} =~ /$NUMERICTYPES/) #CHGD TO NEXT LINE 20010313.
2712 0 ▶ if (length($self->{defaults}->{$fd}) > 0 && ${$self->{types}}{$fd} =~ /$NUMERICTYPES/)
Branch: 1 branch
BranchTrueFalseTotal
if (length $self->{'defaults'}{$fd} > 0 and do { $$self{'types'} }->{$fd} =~ /$NUMERICTYPES/) { } 0 0 0
Condition0%0/3
length $self->{"defaults"}{$fd} > 0 and do { $$self{"types"} }->{$fd} =~ /$NUMERICTYPES/
!ll&&!rl&&r
000
MC/DC0%0/2
length $self->{"defaults"}{$fd} > 0 and do { $$self{"types"} }->{$fd} =~ /$NUMERICTYPES/
length $self->{"defaults"}{$fd} > 0 do { $$self{"types"} }->{$fd} =~ /$NUMERICTYPES/
Truth table0%0/3
A and B
A= length $self->{"defaults"}{$fd} > 0B= do { $$self{"types"} }->{$fd} =~ /$NUMERICTYPES/
ABresult
0X0
100
111
2713 {
2714 0 $val = sprintf(('%.'.${$self->{scales}}{$fd}.'f'),
2715 0 $self->{defaults}->{$fd});
2716 }
2717 else
2718 {
2719 0 $val = $self->{defaults}->{$fd};
2720 }
2721 #$self->{defaults}->{$fd} = substr($val,0, #CHGD. TO NEXT 2 20020110
2722 # ${$self->{lengths}}{$fd});
2723 0 ▶ $self->{defaults}->{$fd} = (${$self->{types}}{$fd} =~ /$BLOBTYPES/) ? $val : substr($val,0,${$self->{lengths}}{$fd});
Branch: 1 branch
BranchTrueFalseTotal
do { $$self{'types'} }->{$fd} =~ /$BLOBTYPES/ ? : 0 0 0
2724 0 ▶ unless ($self->{LongTruncOk} || ${$self->{types}}{$fd} =~ /$BLOBTYPES/
Branch: 1 branch
BranchTrueFalseTotal
unless ($self->{"LongTruncOk"} or do { $$self{"types"} }->{$fd} =~ /$BLOBTYPES/ or $self->{"defaults"}{$fd} eq $val or do { $$self{"types"} }->{$fd} eq "FLOAT") 0 0 0
Condition0%0/9
$self->{"LongTruncOk"} or do { $$self{"types"} }->{$fd} =~ /$BLOBTYPES/ or $self->{"defaults"}{$fd} eq $val or do { $$self{"types"} }->{$fd} eq "FLOAT"
l!l&&r!l&&!r
000
$self->{"LongTruncOk"} or do { $$self{"types"} }->{$fd} =~ /$BLOBTYPES/ or $self->{"defaults"}{$fd} eq $val
l!l&&r!l&&!r
000
$self->{"LongTruncOk"} or do { $$self{"types"} }->{$fd} =~ /$BLOBTYPES/
l!l&&r!l&&!r
000
MC/DC0%0/4
$self->{"LongTruncOk"} or do { $$self{"types"} }->{$fd} =~ /$BLOBTYPES/ or $self->{"defaults"}{$fd} eq $val or do { $$self{"types"} }->{$fd} eq "FLOAT"
$self->{"LongTruncOk"} do { $$self{"types"} }->{$fd} =~ /$BLOBTYPES/ $self->{"defaults"}{$fd} eq $val do { $$self{"types"} }->{$fd} eq "FLOAT"
Truth table0%0/5
A or B or C or D
A= $self->{"LongTruncOk"}B= do { $$self{"types"} }->{$fd} =~ /$BLOBTYPES/C= $self->{"defaults"}{$fd} eq $valD= do { $$self{"types"} }->{$fd} eq "FLOAT"
ABCDresult
1XXX1
01XX1
001X1
00011
00000
2725 || $self->{defaults}->{$fd} eq $val
2726 0 || ${$self->{types}}{$fd} eq 'FLOAT')
2727 {
2728 0 $errdetails = "$fd to ${$self->{lengths}}{$fd} chars";
2729 0 return (-519);
2730 }
2731 0 ▶ if (${$self->{types}}{$fd} eq 'FLOAT' &&
Branch: 1 branch
BranchTrueFalseTotal
if (do { $$self{"types"} }->{$fd} eq "FLOAT" and int $self->{"defaults"}{$fd} != int $val) 0 0 0
Condition0%0/3
do { $$self{"types"} }->{$fd} eq "FLOAT" and int $self->{"defaults"}{$fd} != int $val
!ll&&!rl&&r
000
MC/DC0%0/2
do { $$self{"types"} }->{$fd} eq "FLOAT" and int $self->{"defaults"}{$fd} != int $val
do { $$self{"types"} }->{$fd} eq "FLOAT" int $self->{"defaults"}{$fd} != int $val
Truth table0%0/3
A and B
A= do { $$self{"types"} }->{$fd} eq "FLOAT"B= int $self->{"defaults"}{$fd} != int $val
ABresult
0X0
100
111
2732 int($self->{defaults}->{$fd}) != int($val))
2733 {
2734 0 $errdetails = "$fd to ${$self->{lengths}}{$fd} chars";
2735 0 return (-519);
2736 }
2737 #if (${$self->{types}}{$fd} eq 'CHAR') #CHGD TO NEXT 20030812.
2738 0 ▶ if (${$self->{types}}{$fd} eq 'CHAR' && length($self->{defaults}->{$fd}) > 0)
Branch: 1 branch
BranchTrueFalseTotal
if (do { $$self{"types"} }->{$fd} eq "CHAR" and length $self->{"defaults"}{$fd} > 0) 0 0 0
Condition0%0/3
do { $$self{"types"} }->{$fd} eq "CHAR" and length $self->{"defaults"}{$fd} > 0
!ll&&!rl&&r
000
MC/DC0%0/2
do { $$self{"types"} }->{$fd} eq "CHAR" and length $self->{"defaults"}{$fd} > 0
do { $$self{"types"} }->{$fd} eq "CHAR" length $self->{"defaults"}{$fd} > 0
Truth table0%0/3
A and B
A= do { $$self{"types"} }->{$fd} eq "CHAR"B= length $self->{"defaults"}{$fd} > 0
ABresult
0X0
100
111
2739 {
2740 0 $val = sprintf('%-'.${$self->{lengths}}{$fd}.'s',
2741 0 $self->{defaults}->{$fd});
2742 0 $self->{defaults}->{$fd} = $val;
2743 }
2744  
2745 #THIS CODE SETS ALL EMPTY VALUES FOR THIS FIELD TO THE
2746 #DEFAULT VALUE. ORACLE DOES NOT DO THIS!
2747 #for ($j=0;$j < scalar @{ $self->{records} }; $j++)
2748 #{
2749 # $self->{records}->[$j]->{$fd} = $self->{defaults}->{$fd}
2750 # unless (length($self->{records}->[$j]->{$fd}));
2751 #}
2752 }
2753 0 ▶ if ($type =~ /add/io)
Branch: 3 branches
BranchTrueFalseTotal
if ($type =~ /add/io) { } 0 0 0
elsif ($type =~ /modify/io) { } 0 0 0
elsif ($type =~ /drop/io) { } 0 0 0
2754 {
2755 0 ▶ if (defined $posn)
Branch: 1 branch
BranchTrueFalseTotal
if (defined $posn) { } 0 0 0
2756 {
2757 0 my (@myorder) = (@{ $self->{order} }[0..($posn-1)],
2758 $fd,
2759 0 @{ $self->{order} }[$posn..$#{ $self->{order} }]);
2760 0 @{ $self->{order} } = @myorder;
2761 }
2762 else
2763 {
2764 0 push (@{ $self->{order} }, $fd);
2765 }
2766 }
2767 elsif ($type =~ /modify/io)
2768 {
2769 0 ▶ if (defined $posn)
Branch: 1 branch
BranchTrueFalseTotal
if (defined $posn) 0 0 0
2770 {
2771 0 ▶ for (my $j=0;$j<=$#{ $self->{order} };$j++)
Branch: 1 branch
BranchTrueFalseTotal
if ($j <= $#{$$self{"order"};}) 0 0 0
2772 {
2773 0 ▶ if (${ $self->{order} }[$j] eq $fd)
Branch: 1 branch
BranchTrueFalseTotal
if (do { $$self{"order"} }->[$j] eq $fd) 0 0 0
2774 {
2775 0 splice (@{ $self->{order} }, $j, 1);
2776 0 my (@myorder) = (@{ $self->{order} }[0..($posn-1)],
2777 $fd,
2778 0 @{ $self->{order} }[$posn..$#{ $self->{order} }]);
2779 0 @{ $self->{order} } = @myorder;
2780 0 last;
2781 }
2782 }
2783 }
2784 }
2785 elsif ($type =~ /drop/io)
2786 {
2787 0 ▶ $self->check_columns ($fd) || return (-502);
Branch: 1 branch
BranchTrueFalseTotal
$self->check_columns($fd) or return -502 0 0 0
2788 0 $count = -1;
2789 0 foreach (@{ $self->{order} })
2790 {
2791 0 ++$count;
2792 0 ▶ last if ($_ eq $fd);
Branch: 1 branch
BranchTrueFalseTotal
if $_ eq $fd 0 0 0
2793 }
2794 0 splice (@{ $self->{order} }, $count, 1);
2795 0 delete $self->{fields}->{$fd};
2796 0 delete $self->{types}->{$fd};
2797 0 delete $self->{lengths}->{$fd};
2798 0 delete $self->{scales}->{$fd};
2799 }
2800 }
2801  
2802 0 $status = $self->parse_columns ("\L$type\E", $column);
2803 0 $self->{dirty} = 1;
2804 0 $self->commit($table); #ALWAYS AUTOCOMMIT TABLE ALTERATIONS!
2805 0 return $status;
2806 }
2807 else
2808 {
2809 0 $errdetails = $extra;
2810 0 return (-506);
2811 }
2812 }
2813 else
2814 {
2815 0 $errdetails = $query;
2816 0 return (-507);
2817 }
2818 }
2819  
2820 sub insert
2821 3 ▶{
Subroutine insert: called CC=23 SCAR=37.5
Pod documented
2822 3 my ($self, $query) = @_;
2823 3 my ($i, $path, $table, $columns, $values, $status);
2824 3 $path = $self->{path};
2825 3 ▶ if ($query =~ /^insert\s+into\s+ # Keyword
Branch: 1 branch
BranchTrueFalseTotal
if ($query =~ /^insert\s+into\s+ # Keyword ($path)\s* # Table (?:\((.+?)\)\s*)? # Keys values\s* # 'values' \((.+)\)$/iosx) { } 3 0 3
2826 ($path)\s* # Table
2827 (?:\((.+?)\)\s*)? # Keys
2828 values\s* # 'values'
2829 \((.+)\)$/ixos)
2830 { #JWT: MAKE COLUMN LIST OPTIONAL!
2831  
2832 3 ($table, $columns, $values) = ($1, $2, $3);
2833 3 ▶ return (-523) if ($table =~ /^DUAL$/io);
Branch: 1 branch
BranchTrueFalseTotal
if $table =~ /^DUAL$/io 0 3 3
2834 #$thefid = $table;
2835 #$self->check_for_reload ($table) || return (-501); #CHGD. TO NEXT 20020110 TO BETTER CATCH ERRORS.
2836 3 ▶ my $cfr = $self->check_for_reload($table) || -501;
Condition50%1/2
$self->check_for_reload($table) || -501
l!l
30
MC/DC0%0/1
$self->check_for_reload($table) || -501
$self->check_for_reload($table)
Truth table50%1/2
A
A= $self->check_for_reload($table)
Aresult
11
00
2837 3 ▶ return $cfr if ($cfr < 0);
Branch: 1 branch
BranchTrueFalseTotal
if $cfr < 0 0 3 3
2838  
2839 3 ▶ $columns ||= '';
Condition50%1/2
$columns ||= ""
l!l
03
MC/DC0%0/1
$columns ||= ""
$columns
Truth table50%1/2
A
A= $columns
Aresult
11
00
2840 3 $columns =~ s/\s//gso;
2841 3 ▶ $columns = join(',', @{ $self->{order} }) unless ($columns =~ /\S/o); #JWT
Branch: 1 branch
BranchTrueFalseTotal
unless $columns =~ /\S/o 3 0 3
2842 #$self->check_for_reload ($table) || return (-501);
2843 3 ▶ return (-511) unless (-w $self->{file});
Branch: 1 branch
BranchTrueFalseTotal
unless -w $self->{"file"} 0 3 3
2844 3 ▶ unless ($columns =~ /\S/o)
Branch: 1 branch
BranchTrueFalseTotal
unless ($columns =~ /\S/o) 0 3 3
2845 {
2846 #$thefid = $self->{file};
2847 0 $columns = &load_columninfo($self, ',');
2848 0 ▶ return $columns if ($columns =~ /^\-?\d+$/o);
Branch: 1 branch
BranchTrueFalseTotal
if $columns =~ /^\-?\d+$/o 0 0 0
2849 }
2850  
2851 3 $values =~ s/\\\\/\x02\^2jSpR1tE\x02/gso; #PROTECT "\\" #XCHGD. TO 4 LINES DOWN 20020111
2852 #$values =~ s/\\\'/\x02\^3jSpR1tE\x02/gs; #CHGD. TO NEXT 20060720.
2853 3 $values =~ s/\\\'/\x02\^3jSpR1tE\x02/gso; #PROTECT ESCAPED QUOTES.
2854 3 $values =~ s/\\\"/\x02\^5jSpR1tE\x02/gso;
2855  
2856 3 ▶ 1 while ($values =~ s/\(([^\)]*?)\)/
Branch: 1 branch
BranchTrueFalseTotal
$values =~ s[\(([^\)]*?)\)][my($j) = $1; $j =~ s/\,/\cB^4jSpR1tE\cB/sog; "($j\cB^6jSpR1tE\cB";]seg and do { '???' } 0 3 3
2857 0 my ($j)=$1;
2858 0 $j=~s|\,|\x02\^4jSpR1tE\x02|gso; #PROTECT "," IN PARENTHESIS (FUNCTION-CALL ARG-LISTS).
2859 0 "($j\x02\^6jSpR1tE\x02"
2860 /egs);
2861 # $values =~ s/\'([^\']*?)\'/ #CHGD. TO NEXT 20060720.
2862 3 $values =~ s/([\'\"])([^\1]*?)\1/
2863 6 my ($j)=$2;
2864 6 $j=~s|\,|\x02\^4jSpR1tE\x02|gso; #PROTECT "," IN QUOTES.
2865 6 "'$j'"
2866 /egs;
2867 3 $values =~ s/\x02\^6jSpR1tE\x02/\)/gso;
2868  
2869 3 my $x;
2870 3 my @values = split(/\,\s*/o ,$values);
2871 3 $values = '';
2872 3 for $i (0..$#values)
2873 {
2874 9 $values[$i] =~ s/^\s+//so; #STRIP LEADING & TRAILING SPACES.
2875 9 $values[$i] =~ s/\s+$//so;
2876 9 $values[$i] =~ s/\x02\^5jSpR1tE\x02/\\\"/gso; #RESTORE PROTECTED SINGLE QUOTES HERE.
2877 9 $values[$i] =~ s/\x02\^3jSpR1tE\x02/\\\'/gso; #RESTORE PROTECTED SINGLE QUOTES HERE.
2878 9 $values[$i] =~ s/\x02\^2jSpR1tE\x02/\\\\/gso; #RESTORE PROTECTED SLATS HERE.
2879 9 $values[$i] =~ s/\x02\^4jSpR1tE\x02/\,/gos; #RESTORE PROTECTED COMMAS HERE.
2880 9 ▶ if ($values[$i] =~ /^[_a-zA-Z]/so)
Branch: 1 branch
BranchTrueFalseTotal
if ($values[$i] =~ /^[_a-zA-Z]/so) 3 6 9
2881 {
2882 3 ▶ if ($values[$i] =~ /\s*(\w+).NEXTVAL\s*$/o
Branch: 1 branch
BranchTrueFalseTotal
if ($values[$i] =~ /\s*(\w+).NEXTVAL\s*$/o or $values[$i] =~ /\s*(\w+).CURRVAL\s*$/o) { } 3 0 3
Condition33%1/3
$values[$i] =~ /\s*(\w+).NEXTVAL\s*$/o or $values[$i] =~ /\s*(\w+).CURRVAL\s*$/o
l!l&&r!l&&!r
300
MC/DC0%0/2
$values[$i] =~ /\s*(\w+).NEXTVAL\s*$/o or $values[$i] =~ /\s*(\w+).CURRVAL\s*$/o
$values[$i] =~ /\s*(\w+).NEXTVAL\s*$/o $values[$i] =~ /\s*(\w+).CURRVAL\s*$/o
Truth table33%1/3
A or B
A= $values[$i] =~ /\s*(\w+).NEXTVAL\s*$/oB= $values[$i] =~ /\s*(\w+).CURRVAL\s*$/o
ABresult
1X1
011
000
2883 || $values[$i] =~ /\s*(\w+).CURRVAL\s*$/o)
2884 {
2885 3 my ($seq_file) = $self->get_path_info($1) . '.seq';
2886 #### REMOVED 20010814 - ALREAD DONE IN GET_PATH_INFO!!!! ####$seq_file =~ tr/A-Z/a-z/ unless ($self->{CaseTableNames}); #JWT:TABLE-NAMES ARE NOW CASE-INSENSITIVE!
2887 #open (FILE, "<$seq_file") || return (-511);
2888 3 ▶ unless (open (FILE, "<$seq_file"))
Branch: 1 branch
BranchTrueFalseTotal
unless (open FILE, "<$seq_file") 0 3 3
2889 {
2890 0 $errdetails = "$@/$? (file:$seq_file)";
2891 0 return (-511);
2892 }
2893 3 $x = <FILE>;
2894 #chomp($x);
2895 3 $x =~ s/\s+$//; #20000113 CHOMP WON'T WORK HERE IF RECORD DELIMITER SET TO OTHER THAN \n!
2896 3 my ($incval, $startval) = split(/,/o ,$x);
2897 3 close (FILE);
2898 3 $_ = $values[$i];
2899 3 ▶ if (/\s*(\w+).NEXTVAL\s*$/o)
Branch: 1 branch
BranchTrueFalseTotal
if (/\s*(\w+).NEXTVAL\s*$/o) 3 0 3
2900 {
2901 #open (FILE, ">$seq_file") || return (-511);
2902 3 ▶ unlink ($seq_file) if ($self->{sprite_forcereplace} && -e $seq_file); #ADDED 20010912.
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"sprite_forcereplace"} and -e $seq_file 0 3 3
Condition33%1/3
$self->{"sprite_forcereplace"} and -e $seq_file
!ll&&!rl&&r
300
MC/DC0%0/2
$self->{"sprite_forcereplace"} and -e $seq_file
$self->{"sprite_forcereplace"} -e $seq_file
Truth table33%1/3
A and B
A= $self->{"sprite_forcereplace"}B= -e $seq_file
ABresult
0X0
100
111
2903 3 ▶ unless (open (FILE, ">$seq_file"))
Branch: 1 branch
BranchTrueFalseTotal
unless (open FILE, ">$seq_file") 0 3 3
2904 {
2905 0 $errdetails = "$@/$? (file:$seq_file)";
2906 0 return (-511);
2907 }
2908 3 ▶ $incval += ($startval || 1);
Condition50%1/2
$startval || 1
l!l
30
MC/DC0%0/1
$startval || 1
$startval
Truth table50%1/2
A
A= $startval
Aresult
11
00
2909 3 print FILE "$incval,$startval\n";
2910 3 close (FILE);
2911 }
2912 3 $values[$i] = $incval;
2913 3 $self->{sprite_lastsequence} = $incval; #ADDED 20020905 TO SUPPORT DBIx::GeneratedKey!
2914 }
2915 else
2916 {
2917 #eval {$values[$i] = &{$values[$i]} };
2918 0 $values[$i] = eval &chkcolumnparms($self, $values[$i]); #FUNCTION EVAL 2
2919 0 ▶ return (-517) if ($@);
Branch: 1 branch
BranchTrueFalseTotal
if $@ 0 0 0
2920 }
2921 }
2922 };
2923 3 chop($values);
2924 3 ▶ $self->check_columns ($columns) || return (-502);
Branch: 1 branch
BranchTrueFalseTotal
$self->check_columns($columns) or return -502 3 0 3
2925  
2926 3 $status = $self->insert_data ($columns, @values);
2927
2928 3 return $status;
2929 } else {
2930 0 $errdetails = $query;
2931 0 return (-508);
2932 }
2933 }
2934  
2935 sub insert_data
2936 3 ▶{
Subroutine insert_data: called CC=41 SCAR=54.3
Pod undocumented
2937 3 my ($self, $column_string, @values) = @_;
2938 3 my (@columns, $hash, $loop, $column, $j, $k, $autoColumnIncluded);
2939 3 ▶ $column_string =~ tr/a-z/A-Z/ unless ($self->{sprite_CaseFieldNames});
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"sprite_CaseFieldNames"} 3 0 3
2940 3 @columns = split (/,/, $column_string);
2941 3 foreach my $i (@{ $self->{order} }) #NEXT LOOP ADDED 20040913 TO SUPPORT AUTONUMBERING W/O SPECIFYING COLUMN ON INSERT (LIKE MYSQL)?
2942 {
2943 9 ▶ if (${$self->{types}}{$i} =~ /AUTO/io)
Branch: 1 branch
BranchTrueFalseTotal
if (do { $$self{"types"} }->{$i} =~ /AUTO/io) 0 9 9
2944 {
2945 0 $autoColumnIncluded = 0;
2946 0 foreach my $j (@columns)
2947 {
2948 0 ▶ if ($j eq $i)
Branch: 1 branch
BranchTrueFalseTotal
if ($j eq $i) 0 0 0
2949 {
2950 0 $autoColumnIncluded = 1;
2951 0 last;
2952 }
2953 }
2954 0 ▶ unless ($autoColumnIncluded)
Branch: 1 branch
BranchTrueFalseTotal
unless ($autoColumnIncluded) 0 0 0
2955 {
2956 0 push (@columns, $i);
2957 0 push (@values, '');
2958 }
2959 }
2960 }
2961 3 $column_string = join(',', @columns);
2962 #JWT: @values = $self->quotewords (',', 0, $value_string);
2963 # if ($#columns > $#values) #ADDED 20011029 TO DO AUTOSEQUENCING!
2964 # {
2965 # $column_string .= ',' unless ($column_string =~ /\,\s*$/);
2966 # for (my $i=0;$i<=$#columns;$i++)
2967 # {
2968 # if (${$self->{types}}{$columns[$i]} =~ /AUTO/)
2969 # {
2970 # $column_string =~ s/$columns[$i]\,//;
2971 # $column_string .= $columns[$i] . ',';
2972 # push (@values, "''");
2973 # }
2974 # }
2975 # $column_string =~ s/\,\s*$//;
2976 # @columns = split (/\,/, $column_string);
2977 # }
2978 3 ▶ if ($#columns == $#values) {
Branch: 1 branch
BranchTrueFalseTotal
if ($#columns == $#values) { } 3 0 3
2979
2980 3 my (@keyfields) = split(',', $self->{key_fields}); #JWT: PREVENT DUP. KEYS.
2981 3 my ($matchcnt) = 0;
2982
2983 3 $hash = {};
2984  
2985 3 foreach $column (@{ $self->{order} })
2986 {
2987 9 ▶ $column =~ tr/a-z/A-Z/ unless ($self->{sprite_CaseFieldNames}); #JWT
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"sprite_CaseFieldNames"} 9 0 9
2988 $hash->{$column} = $self->{defaults}->{$column}
2989 9 ▶ if (defined($self->{defaults}->{$column}) && length($self->{defaults}->{$column}));
Branch: 1 branch
BranchTrueFalseTotal
if defined $self->{"defaults"}{$column} and length $self->{"defaults"}{$column} 0 9 9
Condition33%1/3
defined $self->{"defaults"}{$column} and length $self->{"defaults"}{$column}
!ll&&!rl&&r
900
MC/DC0%0/2
defined $self->{"defaults"}{$column} and length $self->{"defaults"}{$column}
defined $self->{"defaults"}{$column} length $self->{"defaults"}{$column}
Truth table33%1/3
A and B
A= defined $self->{"defaults"}{$column}B= length $self->{"defaults"}{$column}
ABresult
0X0
100
111
2990 }
2991  
2992 3 ▶ for ($loop=0; $loop <= $#columns; $loop++)
Branch: 1 branch
BranchTrueFalseTotal
if ($loop <= $#columns) 9 3 12
2993 {
2994 9 $column = $columns[$loop];
2995 9 ▶ $column =~ tr/a-z/A-Z/ unless ($self->{sprite_CaseFieldNames});
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"sprite_CaseFieldNames"} 9 0 9
2996
2997 9 my ($v);
2998 9 ▶ if ($self->{fields}->{$column})
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{"fields"}{$column}) 9 0 9
2999 {
3000 9 $values[$loop] =~ s/^\'(.*)\'$/my ($stuff) = $1;
3001 #$stuff =~ s|\'|\\\'|gs;
3002 6 $stuff =~ s|\'\'|\'|gso;
3003 6 $stuff/es;
3004 9 $values[$loop] =~ s|^\'$||so; #HANDLE NULL VALUES!!!.
3005 9 ▶ if (${$self->{types}}{$column} =~ /AUTO/o) #NEXT 12 ADDED 20011029 TO DO ODBC&MYSQL-LIKE AUTOSEQUENCING.
Branch: 2 branches
BranchTrueFalseTotal
if (do { $$self{'types'} }->{$column} =~ /AUTO/o) { } 0 9 9
elsif (length $values[$loop] or not length $self->{'defaults'}{$column}) { } 9 0 9
3006 {
3007 0 ▶ if (length($values[$loop]))
Branch: 1 branch
BranchTrueFalseTotal
if (length $values[$loop]) { } 0 0 0
3008 {
3009 0 $errdetails = "value($values[$loop]) into column($column)";
3010 0 return (-524);
3011 }
3012 else
3013 {
3014 0 $v = ++$self->{defaults}->{$column};
3015 0 $self->{sprite_lastsequence} = $v; #ADDED 20020905 TO SUPPORT DBIx::GeneratedKey!
3016 }
3017 }
3018 ▶ elsif (length($values[$loop]) || !length($self->{defaults}->{$column}))
Condition33%1/3
length $values[$loop] or not length $self->{"defaults"}{$column}
l!l&&r!l&&!r
900
MC/DC0%0/2
length $values[$loop] or not length $self->{"defaults"}{$column}
length $values[$loop] not length $self->{"defaults"}{$column}
Truth table33%1/3
A or not(B)
A= length $values[$loop]B= not length $self->{"defaults"}{$column}
ABresult
1X1
011
000
3019 {
3020 9 $v = $values[$loop];
3021 }
3022 else
3023 {
3024 0 $v = $self->{defaults}->{$column};
3025 }
3026 #if (${$self->{types}}{$column} =~ /$NUMERICTYPES/) #CHGD TO NEXT LINE 20010313.
3027 9 ▶ if (length($v) > 0 && ${$self->{types}}{$column} =~ /$NUMERICTYPES/)
Branch: 2 branches
BranchTrueFalseTotal
if (length $v > 0 and do { $$self{'types'} }->{$column} =~ /$NUMERICTYPES/) { } 3 6 9
elsif (do { $$self{'types'} }->{$column} =~ /$REFTYPES/o) { } 0 6 6
Condition66%2/3
length $v > 0 and do { $$self{"types"} }->{$column} =~ /$NUMERICTYPES/
!ll&&!rl&&r
063
MC/DC50%1/2
length $v > 0 and do { $$self{"types"} }->{$column} =~ /$NUMERICTYPES/
length $v > 0 do { $$self{"types"} }->{$column} =~ /$NUMERICTYPES/
Truth table66%2/3
A and B
A= length $v > 0B= do { $$self{"types"} }->{$column} =~ /$NUMERICTYPES/
ABresult
0X0
100
111
3028 {
3029 3 $hash->{$column} = sprintf(('%.'.${$self->{scales}}{$column}.'f'), $v);
3030 }
3031 6 elsif (${$self->{types}}{$column} =~ /$REFTYPES/o) #ADDED 20020124 TO SUPPORT REFERENCED TYPES.
3032 {
3033 0 my $randblobid = int(rand(99999));
3034 0 my $randblobfid;
3035 0 ▶ do {
Branch: 1 branch
BranchTrueFalseTotal
-e $randblobfid and do { do { $randblobid = int rand 99999; $randblobfid = $self->{"directory"} . $self->{"separator"}{$self->{"platform"}} . $self->{"table"} . "_${randblobid}_${$}.tmp" } } 0 0 0
3036 0 $randblobid = int(rand(99999));
3037 $randblobfid = $self->{directory}
3038 .$self->{separator}->{ $self->{platform} }
3039 0 .$self->{table}."_${randblobid}_$$.tmp";
3040 } while (-e $randblobfid);
3041 0 ▶ if (open(FILE, ">$randblobfid"))
Branch: 1 branch
BranchTrueFalseTotal
if (open FILE, ">$randblobfid") { } 0 0 0
3042 {
3043 0 binmode FILE;
3044 0 ▶ if ($self->{CBC} && $self->{sprite_Crypt} <= 2) #ADDED: 20020109
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'CBC'} and $self->{'sprite_Crypt'} <= 2) { } 0 0 0
Condition0%0/3
$self->{"CBC"} and $self->{"sprite_Crypt"} <= 2
!ll&&!rl&&r
000
MC/DC0%0/2
$self->{"CBC"} and $self->{"sprite_Crypt"} <= 2
$self->{"CBC"} $self->{"sprite_Crypt"} <= 2
Truth table0%0/3
A and B
A= $self->{"CBC"}B= $self->{"sprite_Crypt"} <= 2
ABresult
0X0
100
111
3045 {
3046 0 print FILE $self->{CBC}->encrypt($v);
3047 }
3048 else
3049 {
3050 0 print FILE $v;
3051 }
3052 0 close FILE;
3053 0 $hash->{$column} = $randblobid;
3054 }
3055 else
3056 {
3057 0 $errdetails = "$randblobfid: ($?)";
3058 0 return (-528);
3059 }
3060 }
3061 else
3062 {
3063 6 $hash->{$column} = $v;
3064 }
3065 #$v = substr($hash->{$column},0,${$self->{lengths}}{$column}); #CHGD TO NEXT (20020110)
3066 9 ▶ $v = (${$self->{types}}{$column} =~ /$BLOBTYPES/) ? $hash->{$column} : substr($hash->{$column},0,${$self->{lengths}}{$column});
Branch: 1 branch
BranchTrueFalseTotal
do { $$self{'types'} }->{$column} =~ /$BLOBTYPES/ ? : 0 9 9
3067 9 ▶ unless ($self->{LongTruncOk} || $v eq $hash->{$column} ||
Branch: 1 branch
BranchTrueFalseTotal
unless ($self->{"LongTruncOk"} or $v eq $hash->{$column} or do { $$self{"types"} }->{$column} eq "FLOAT") 0 9 9
Condition33%2/6
$self->{"LongTruncOk"} or $v eq $hash->{$column} or do { $$self{"types"} }->{$column} eq "FLOAT"
l!l&&r!l&&!r
900
$self->{"LongTruncOk"} or $v eq $hash->{$column}
l!l&&r!l&&!r
090
MC/DC0%0/3
$self->{"LongTruncOk"} or $v eq $hash->{$column} or do { $$self{"types"} }->{$column} eq "FLOAT"
$self->{"LongTruncOk"} $v eq $hash->{$column} do { $$self{"types"} }->{$column} eq "FLOAT"
Truth table25%1/4
A or B or C
A= $self->{"LongTruncOk"}B= $v eq $hash->{$column}C= do { $$self{"types"} }->{$column} eq "FLOAT"
ABCresult
1XX1
01X1
0011
0000
3068 0 (${$self->{types}}{$column} eq 'FLOAT'))
3069 {
3070 0 $errdetails = "$column to ${$self->{lengths}}{$column} chars";
3071 0 return (-519);
3072 }
3073 9 ▶ if ((${$self->{types}}{$column} eq 'FLOAT')
Branch: 2 branches
BranchTrueFalseTotal
if (do { $$self{'types'} }->{$column} eq 'FLOAT' and int $v != int $hash->{$column}) { } 0 9 9
elsif (do { $$self{'types'} }->{$column} eq 'CHAR' and length $v > 0) { } 3 6 9
Condition33%1/3
do { $$self{"types"} }->{$column} eq "FLOAT" and int $v != int $hash->{$column}
!ll&&!rl&&r
900
MC/DC0%0/2
do { $$self{"types"} }->{$column} eq "FLOAT" and int $v != int $hash->{$column}
do { $$self{"types"} }->{$column} eq "FLOAT" int $v != int $hash->{$column}
Truth table33%1/3
A and B
A= do { $$self{"types"} }->{$column} eq "FLOAT"B= int $v != int $hash->{$column}
ABresult
0X0
100
111
3074 && (int($v) != int($hash->{$column})))
3075 {
3076 0 $errdetails = "$column to ${$self->{lengths}}{$column} chars";
3077 0 return (-519);
3078 }
3079 #elsif (${$self->{types}}{$column} eq 'CHAR') #CHGD. TO NEXT 20030812.
3080 9 ▶ elsif (${$self->{types}}{$column} eq 'CHAR' && length($v) > 0)
Condition66%2/3
do { $$self{"types"} }->{$column} eq "CHAR" and length $v > 0
!ll&&!rl&&r
603
MC/DC50%1/2
do { $$self{"types"} }->{$column} eq "CHAR" and length $v > 0
do { $$self{"types"} }->{$column} eq "CHAR" length $v > 0
Truth table66%2/3
A and B
A= do { $$self{"types"} }->{$column} eq "CHAR"B= length $v > 0
ABresult
0X0
100
111
3081 {
3082 3 $hash->{$column} = sprintf('%-'.${$self->{lengths}}{$column}.'s',$v);
3083 }
3084 else
3085 {
3086 6 $hash->{$column} = $v;
3087 }
3088 }
3089 }
3090  
3091 #20000201 - FIX UNIQUE-KEY TEST FOR LARGE DATASETS.
3092  
3093 3 ▶recloop: for ($k=0;$k < scalar @{ $self->{records} }; $k++) #CHECK EACH RECORD.
Branch: 1 branch
BranchTrueFalseTotal
if ($k < scalar @{$self->{"records"};}) 3 3 6
3094 {
3095 3 $matchcnt = 0;
3096 3 valueloop: foreach $column (keys %$hash) #CHECK EACH NEW VALUE AGAINST IT'S RESPECTIVE COLUMN.
3097 {
3098 9 ▶keyloop: for ($j=0;$j<=$#keyfields;$j++)
Branch: 1 branch
BranchTrueFalseTotal
if ($j <= $#keyfields) 9 9 18
3099 {
3100 9 ▶ if ($column eq $keyfields[$j])
Branch: 1 branch
BranchTrueFalseTotal
if ($column eq $keyfields[$j]) 3 6 9
3101 {
3102 3 ▶ if ($self->{records}->[$k]->{$column} eq $hash->{$column})
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{"records"}[$k]{$column} eq $hash->{$column}) 0 3 3
3103 {
3104 0 ++$matchcnt;
3105 0 ▶ return (-518) if ($matchcnt && $matchcnt > $#keyfields); #ALL KEY FIELDS WERE DUPLICATES!
Branch: 1 branch
BranchTrueFalseTotal
if $matchcnt and $matchcnt > $#keyfields 0 0 0
Condition0%0/3
$matchcnt and $matchcnt > $#keyfields
!ll&&!rl&&r
000
MC/DC0%0/2
$matchcnt and $matchcnt > $#keyfields
$matchcnt $matchcnt > $#keyfields
Truth table0%0/3
A and B
A= $matchcntB= $matchcnt > $#keyfields
ABresult
0X0
100
111
3106 }
3107 }
3108 }
3109 }
3110 #return (-518) if ($matchcnt && $matchcnt > $#keyfields); #ALL KEY FIELDS WERE DUPLICATES!
3111 }
3112  
3113  
3114 3 push @{ $self->{records} }, $hash;
3115
3116 3 $self->{dirty} = 1;
3117 3 return (1);
3118 } else {
3119 0 $errdetails = "$#columns != $#values"; #20000114
3120 0 return (-509);
3121 }
3122 }
3123  
3124 sub write_file
3125 3 ▶{
Subroutine write_file: called CC=52 SCAR=59.8
Pod undocumented
3126 3 my ($self, $new_file) = @_;
3127 3 my ($i, $j, $status, $loop, $record, $column, $value, $fields, $record_string);
3128 3 my (@keyfields) = split(',', $self->{key_fields}); #JWT: PREVENT DUP. KEYS.
3129 return ($self->display_error (-531) * -531)
3130 3 ▶ if (($self->{_write} =~ /^xml/io) && $self->{CBC} && $self->{sprite_Crypt} <= 2);
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"_write"} =~ /^xml/io and $self->{"CBC"} and $self->{"sprite_Crypt"} <= 2 0 3 3
Condition33%2/6
$self->{"_write"} =~ /^xml/io and $self->{"CBC"} and $self->{"sprite_Crypt"} <= 2
!ll&&!rl&&r
300
$self->{"_write"} =~ /^xml/io and $self->{"CBC"}
!ll&&!rl&&r
300
MC/DC0%0/3
$self->{"_write"} =~ /^xml/io and $self->{"CBC"} and $self->{"sprite_Crypt"} <= 2
$self->{"_write"} =~ /^xml/io $self->{"CBC"} $self->{"sprite_Crypt"} <= 2
Truth table25%1/4
A and B and C
A= $self->{"_write"} =~ /^xml/ioB= $self->{"CBC"}C= $self->{"sprite_Crypt"} <= 2
ABCresult
0XX0
10X0
1100
1111
3131  
3132 3 local (*FILE, $^W);
3133 3 local ($/);
3134 3 ▶ if ($self->{CBC} && $self->{sprite_Crypt} <= 2) #ADDED: 20020109
Branch: 2 branches
BranchTrueFalseTotal
if ($self->{'CBC'} and $self->{'sprite_Crypt'} <= 2) { } 0 3 3
elsif (not $self->{'_write'} =~ /^xml/io) { } 3 0 3
Condition33%1/3
$self->{"CBC"} and $self->{"sprite_Crypt"} <= 2
!ll&&!rl&&r
300
MC/DC0%0/2
$self->{"CBC"} and $self->{"sprite_Crypt"} <= 2
$self->{"CBC"} $self->{"sprite_Crypt"} <= 2
Truth table33%1/3
A and B
A= $self->{"CBC"}B= $self->{"sprite_Crypt"} <= 2
ABresult
0X0
100
111
3135 {
3136 0 $/ = "\x03^0jSp".$self->{_record}; #(EOR) JWT:SUPPORT ANY RECORD-SEPARATOR!
3137 }
3138 elsif ($self->{_write} !~ /^xml/io)
3139 {
3140 3 $/ = $self->{_record}; #JWT:SUPPORT ANY RECORD-SEPARATOR!
3141 }
3142  
3143 3 $^W = 0;
3144  
3145 #$status = (scalar @{ $self->{records} }) ? 1 : -513;
3146 3 $status = 1; #JWT 19991222
3147  
3148 3 ▶ return 1 if $#{$self->{order}} < 0; #ADDED 20000225 PREVENT BLANKING OUT TABLES, IE IF USER CREATES SEQUENCE W/SAME NAME AS TABLE, THEN COMMITS!
Branch: 1 branch
BranchTrueFalseTotal
if $#{$$self{"order"};} < 0 0 3 3
3149
3150 #########$new_file =~ tr/A-Z/a-z/ unless ($self->{CaseTableNames}); #JWT:TABLE-NAMES ARE NOW CASE-INSENSITIVE!
3151 3 ▶ unlink ($new_file) if ($status >= 1 && $self->{sprite_forcereplace} && -e $new_file); #ADDED 20010912.
Branch: 1 branch
BranchTrueFalseTotal
if $status >= 1 and $self->{"sprite_forcereplace"} and -e $new_file 0 3 3
Condition33%2/6
$status >= 1 and $self->{"sprite_forcereplace"} and -e $new_file
!ll&&!rl&&r
300
$status >= 1 and $self->{"sprite_forcereplace"}
!ll&&!rl&&r
030
MC/DC0%0/3
$status >= 1 and $self->{"sprite_forcereplace"} and -e $new_file
$status >= 1 $self->{"sprite_forcereplace"} -e $new_file
Truth table25%1/4
A and B and C
A= $status >= 1B= $self->{"sprite_forcereplace"}C= -e $new_file
ABCresult
0XX0
10X0
1100
1111
3152 3 ▶ if ( ($status >= 1) && (open (FILE, ">$new_file")) ) {
Branch: 1 branch
BranchTrueFalseTotal
if ($status >= 1 and open FILE, ">$new_file") { } 3 0 3
Condition33%1/3
$status >= 1 and open FILE, ">$new_file"
!ll&&!rl&&r
003
MC/DC0%0/2
$status >= 1 and open FILE, ">$new_file"
$status >= 1 open FILE, ">$new_file"
Truth table33%1/3
A and B
A= $status >= 1B= open FILE, ">$new_file"
ABresult
0X0
100
111
3153 3 binmode FILE; #20000404
3154  
3155 #if (($^O eq 'MSWin32') or ($^O =~ /cygwin/i)) #CHGD. TO NEXT 20020221
3156 3 ▶ if ($self->{platform} eq 'PC')
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'platform'} eq 'PC') { } 0 3 3
3157 {
3158 0 ▶ $self->lock || $self->display_error (-515);
Branch: 1 branch
BranchTrueFalseTotal
$self->lock or $self->display_error(-515) 0 0 0
3159 }
3160 else #GOOD, MUST BE A NON-M$ SYSTEM :-)
3161 {
3162 3 ▶ eval { flock (FILE, $JSprite::LOCK_EX) || die };
Branch: 1 branch
BranchTrueFalseTotal
flock FILE, $LOCK_EX or die 3 0 3
3163  
3164 3 ▶ if ($@)
Branch: 1 branch
BranchTrueFalseTotal
if ($@) 0 3 3
3165 {
3166 0 ▶ $self->lock || $self->display_error (-515) if ($@);
Branch: 1 branch
BranchTrueFalseTotal
if $@ 0 0 0
Condition0%0/6
$@ && ($self->lock || $self->display_error(-515))
!ll&&!rl&&r
000
$self->lock or $self->display_error(-515)
l!l&&r!l&&!r
000
MC/DC0%0/3
$@ && ($self->lock || $self->display_error(-515))
$@ $self->lock $self->display_error(-515)
Truth table0%0/4
A && B or C
A= $@B= $self->lockC= $self->display_error(-515)
ABCresult
0XX0
1000
11X1
1011
3167 }
3168 }
3169  
3170 3 $fields = '';
3171  
3172 3 my $reccnt = scalar @{ $self->{records} };
3173 3 ▶ if ($self->{_write} =~ /^xml/io)
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'_write'} =~ /^xml/io) { } 0 3 3
3174 {
3175 0 require MIME::Base64;
3176 0 $fields = <<END_XML;
3177 <?xml version="1.0" encoding="UTF-8"?>
3178 END_XML
3179 0 ▶ $fields .= <<END_XML if ($self->{sprite_xsl});
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"sprite_xsl"} 0 0 0
3180 <?xml-stylesheet type="text/xsl" href="$self->{sprite_xsl}"?>
3181 END_XML
3182 0 $fields .= <<END_XML;
3183 <database name="$self->{dbname}" user="$self->{dbuser}">
3184 <select query="select * from $self->{table}" rows="$reccnt">
3185 END_XML
3186 0 $fields .= ' <columns order="'.join(',',@{ $self->{order} }).'">'."\n";
3187 0 my ($iskey, $haveadefault, $havemaxsize, $typeinfo);
3188 0 for $i (0..$#{$self->{order}})
3189 {
3190 0 $iskey = 'NO';
3191 0 ▶ for ($j=0;$j<=$#keyfields;$j++) #JWT: MARK KEY FIELDS.
Branch: 1 branch
BranchTrueFalseTotal
if ($j <= $#keyfields) 0 0 0
3192 {
3193 0 ▶ if (${$self->{order}}[$i] eq $keyfields[$j])
Branch: 1 branch
BranchTrueFalseTotal
if (do { $$self{"order"} }->[$i] eq $keyfields[$j]) 0 0 0
3194 {
3195 0 $iskey = 'PRIMARY';
3196 0 last;
3197 }
3198 }
3199 0 $haveadefault = ${$self->{defaults}}{${$self->{order}}[$i]};
3200 0 ▶ $havemaxsize = (${$self->{types}}{${$self->{order}}[$i]} =~ /$BLOBTYPES/)
Condition0%0/7
$self->{"LongReadLen"} or 0
l!l
00
$self->{"maxsizes"}{${$$self{"types"};}{do { $$self{"order"} }->[$i]}} or ${$$self{"lengths"};}{do { $$self{"order"} }->[$i]} or 0
l!l
00
$self->{"maxsizes"}{${$$self{"types"};}{do { $$self{"order"} }->[$i]}} or ${$$self{"lengths"};}{do { $$self{"order"} }->[$i]}
l!l&&r!l&&!r
000
MC/DC0%0/1
$self->{"LongReadLen"} or 0
$self->{"LongReadLen"}
MC/DC0%0/2
$self->{"maxsizes"}{${$$self{"types"};}{do { $$self{"order"} }->[$i]}} or ${$$self{"lengths"};}{do { $$self{"order"} }->[$i]} or 0
$self->{"maxsizes"}{${$$self{"types"};}{do { $$self{"order"} }->[$i]}} ${$$self{"lengths"};}{do { $$self{"order"} }->[$i]}
Truth table0%0/2
A
A= $self->{"LongReadLen"}
Aresult
11
00
Truth table0%0/3
A or B
A= $self->{"maxsizes"}{${$$self{"types"};}{do { $$self{"order"} }->[$i]}}B= ${$$self{"lengths"};}{do { $$self{"order"} }->[$i]}
ABresult
1X1
011
000
3201 ? ($self->{LongReadLen} || '0')
3202 0 : ($self->{maxsizes}->{${$self->{types}}{${$self->{order}}[$i]}}
3203 0 ▶ || ${$self->{lengths}}{${$self->{order}}[$i]} || '0');
Branch: 1 branch
BranchTrueFalseTotal
${$$self{'types'};}{do { $$self{'order'} }->[$i]} =~ /$BLOBTYPES/ ? : 0 0 0
3204 0 $fields .= <<END_XML
3205 <column>
3206 0 <name>${$self->{order}}[$i]</name>
3207 0 <type>${$self->{types}}{${$self->{order}}[$i]}</type>
3208 <size>$havemaxsize</size>
3209 0 <precision>${$self->{lengths}}{${$self->{order}}[$i]}</precision>
3210 0 <scale>${$self->{scales}}{${$self->{order}}[$i]}</scale>
3211 <nullable>NULL</nullable>
3212 <key>$iskey</key>
3213 <default>$haveadefault</default>
3214 </column>
3215 END_XML
3216 }
3217 0 $fields .= " </columns>\n";
3218 }
3219 else
3220 {
3221 3 for $i (0..$#{$self->{order}})
3222 {
3223 9 $fields .= ${$self->{order}}[$i] . '=';
3224 9 ▶ for ($j=0;$j<=$#keyfields;$j++) #JWT: MARK KEY FIELDS.
Branch: 1 branch
BranchTrueFalseTotal
if ($j <= $#keyfields) 9 9 18
3225 {
3226 9 ▶ $fields .= '*' if (${$self->{order}}[$i] eq $keyfields[$j])
Branch: 1 branch
BranchTrueFalseTotal
if do { $$self{"order"} }->[$i] eq $keyfields[$j] 3 6 9
3227 }
3228 #$fields .= ${$self->{types}}{${$self->{order}}[$i]} . '(' #CHGD. TO NEXT 20020110
3229 # . ${$self->{lengths}}{${$self->{order}}[$i]};
3230 9 $fields .= ${$self->{types}}{${$self->{order}}[$i]};
3231 9 ▶ unless (${$self->{types}}{${$self->{order}}[$i]} =~ /$BLOBTYPES/)
Branch: 1 branch
BranchTrueFalseTotal
unless (${$$self{"types"};}{do { $$self{"order"} }->[$i]} =~ /$BLOBTYPES/) 9 0 9
3232 {
3233 9 $fields .= '(' . ${$self->{lengths}}{${$self->{order}}[$i]};
3234 9 ▶ if (${$self->{scales}}{${$self->{order}}[$i]}
Branch: 1 branch
BranchTrueFalseTotal
if (${$$self{"scales"};}{do { $$self{"order"} }->[$i]} and ${$$self{"types"};}{do { $$self{"order"} }->[$i]} =~ /$NUMERICTYPES/) 0 9 9
Condition66%2/3
${$$self{"scales"};}{do { $$self{"order"} }->[$i]} and ${$$self{"types"};}{do { $$self{"order"} }->[$i]} =~ /$NUMERICTYPES/
!ll&&!rl&&r
720
MC/DC0%0/2
${$$self{"scales"};}{do { $$self{"order"} }->[$i]} and ${$$self{"types"};}{do { $$self{"order"} }->[$i]} =~ /$NUMERICTYPES/
${$$self{"scales"};}{do { $$self{"order"} }->[$i]} ${$$self{"types"};}{do { $$self{"order"} }->[$i]} =~ /$NUMERICTYPES/
Truth table66%2/3
A and B
A= ${$$self{"scales"};}{do { $$self{"order"} }->[$i]}B= ${$$self{"types"};}{do { $$self{"order"} }->[$i]} =~ /$NUMERICTYPES/
ABresult
0X0
100
111
3235 2 && ${$self->{types}}{${$self->{order}}[$i]} =~ /$NUMERICTYPES/)
3236 {
3237 0 $fields .= ',' . ${$self->{scales}}{${$self->{order}}[$i]}
3238 }
3239 #$fields .= ')' . $self->{_write};
3240 9 $fields .= ')';
3241 }
3242 0 $fields .= '='. ${$self->{defaults}}{${$self->{order}}[$i]}
3243 9 ▶ if (length(${$self->{defaults}}{${$self->{order}}[$i]}));
Branch: 1 branch
BranchTrueFalseTotal
if length ${$$self{"defaults"};}{do { $$self{"order"} }->[$i]} 0 9 9
3244 9 $fields .= $self->{_write};
3245 }
3246 3 $fields =~ s/$self->{_write}$//;
3247 }
3248  
3249 3 ▶ if ($self->{CBC} && $self->{sprite_Crypt} <= 2) #ADDED: 20020109
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'CBC'} and $self->{'sprite_Crypt'} <= 2) { } 0 3 3
Condition33%1/3
$self->{"CBC"} and $self->{"sprite_Crypt"} <= 2
!ll&&!rl&&r
300
MC/DC0%0/2
$self->{"CBC"} and $self->{"sprite_Crypt"} <= 2
$self->{"CBC"} $self->{"sprite_Crypt"} <= 2
Truth table33%1/3
A and B
A= $self->{"CBC"}B= $self->{"sprite_Crypt"} <= 2
ABresult
0X0
100
111
3250 {
3251 0 print FILE $self->{CBC}->encrypt($fields).$/;
3252 }
3253 else
3254 {
3255 3 print FILE "$fields$/";
3256 }
3257 3 ▶ my $rsinit = ($self->{_write} =~ /^xml/io) ? " <row>\n" : '';
Branch: 1 branch
BranchTrueFalseTotal
$self->{'_write'} =~ /^xml/io ? : 0 3 3
3258 3 ▶ my $rsend = $rsinit ? " </row>\n" : '';
Branch: 1 branch
BranchTrueFalseTotal
$rsinit ? : 0 3 3
3259  
3260 3 ▶ for ($loop=0; $loop < $reccnt; $loop++) {
Branch: 1 branch
BranchTrueFalseTotal
if ($loop < $reccnt) 6 3 9
3261 #++$loop1;
3262 6 $record = $self->{records}->[$loop];
3263  
3264 6 ▶ next unless (defined $record);
Branch: 1 branch
BranchTrueFalseTotal
unless defined $record 0 6 6
3265  
3266 6 $record_string = $rsinit;
3267 #$record_string =~ s/\?/$loop1/;
3268  
3269 6 foreach $column (@{ $self->{order} })
3270 {
3271 #if (${$self->{types}}{$column} eq 'CHAR') #CHGD. TO NEXT 20030812.
3272 18 ▶ if (${$self->{types}}{$column} eq 'CHAR' && length($record->{$column}) > 0)
Branch: 1 branch
BranchTrueFalseTotal
if (do { $$self{'types'} }->{$column} eq 'CHAR' and length $record->{$column} > 0) { } 6 12 18
Condition66%2/3
do { $$self{"types"} }->{$column} eq "CHAR" and length $record->{$column} > 0
!ll&&!rl&&r
1206
MC/DC50%1/2
do { $$self{"types"} }->{$column} eq "CHAR" and length $record->{$column} > 0
do { $$self{"types"} }->{$column} eq "CHAR" length $record->{$column} > 0
Truth table66%2/3
A and B
A= do { $$self{"types"} }->{$column} eq "CHAR"B= length $record->{$column} > 0
ABresult
0X0
100
111
3273 {
3274 $value = sprintf(
3275 6 '%-'.${$self->{lengths}}{$column}.'s',
3276 6 $record->{$column});
3277 }
3278 #elsif (${$self->{types}}{$column} =~ /$NUMERICTYPES/)
3279 #{
3280 # $value = sprintf(('%.'.${$self->{scales}}{$column}.'f'),
3281 # $record->{$column});
3282 #}
3283 else
3284 {
3285 12 $value = $record->{$column};
3286 }
3287  
3288 #NEXT 2 ADDED 20020111 TO PERMIT EMBEDDED RECORD & FIELD SEPERATORS.
3289 18 $value =~ s/$self->{_record}/\x02\^0jSpR1tE\x02/gso; #PROTECT EMBEDDED RECORD SEPARATORS.
3290 18 $value =~ s/$self->{_write}/\x02\^1jSpR1tE\x02/gso; #PROTECT EMBEDDED RECORD SEPARATORS.
3291 18 ▶ $record_string .= $rsinit ? (&xmlescape($column,$value)."\n")
Branch: 1 branch
BranchTrueFalseTotal
$rsinit ? : 0 18 18
3292 : "$self->{_write}$value";
3293 }
3294  
3295 #$record_string =~ s/^$self->{_write}//o; #CHGD TO NEXT LINE 20010917.
3296 6 $record_string =~ s/^$self->{_write}//s;
3297 6 $record_string .= $rsend;
3298  
3299 6 ▶ if ($self->{CBC} && $self->{sprite_Crypt} <= 2) #ADDED: 20020109
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'CBC'} and $self->{'sprite_Crypt'} <= 2) { } 0 6 6
Condition33%1/3
$self->{"CBC"} and $self->{"sprite_Crypt"} <= 2
!ll&&!rl&&r
600
MC/DC0%0/2
$self->{"CBC"} and $self->{"sprite_Crypt"} <= 2
$self->{"CBC"} $self->{"sprite_Crypt"} <= 2
Truth table33%1/3
A and B
A= $self->{"CBC"}B= $self->{"sprite_Crypt"} <= 2
ABresult
0X0
100
111
3300 {
3301 0 print FILE $self->{CBC}->encrypt($record_string).$/;
3302 }
3303 else
3304 {
3305 6 print FILE "$record_string$/";
3306 }
3307 }
3308 3 ▶ if ($rsend)
Branch: 1 branch
BranchTrueFalseTotal
if ($rsend) 0 3 3
3309 {
3310 0 $rsend = " </select>\n</database>\n";
3311 0 ▶ if ($self->{CBC} && $self->{sprite_Crypt} <= 2) #ADDED: 20020109
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'CBC'} and $self->{'sprite_Crypt'} <= 2) { } 0 0 0
Condition0%0/3
$self->{"CBC"} and $self->{"sprite_Crypt"} <= 2
!ll&&!rl&&r
000
MC/DC0%0/2
$self->{"CBC"} and $self->{"sprite_Crypt"} <= 2
$self->{"CBC"} $self->{"sprite_Crypt"} <= 2
Truth table0%0/3
A and B
A= $self->{"CBC"}B= $self->{"sprite_Crypt"} <= 2
ABresult
0X0
100
111
3312 {
3313 0 print FILE $self->{CBC}->encrypt($rsend).$/;
3314 }
3315 else
3316 {
3317 0 print FILE "$rsend$/";
3318 }
3319 }
3320 3 close (FILE);
3321  
3322 3 my (@stats) = stat ($new_file);
3323 3 $self->{timestamp} = $stats[9];
3324  
3325 3 ▶ $self->unlock || $self->display_error (-516);
Branch: 1 branch
BranchTrueFalseTotal
$self->unlock or $self->display_error(-516) 3 0 3
3326 } else {
3327 0 ▶ $status = ($status < 1) ? $status : -511;
Branch: 1 branch
BranchTrueFalseTotal
$status < 1 ? : 0 0 0
3328 }
3329 3 return $status;
3330 }
3331  
3332 {
3333 1 my %xmleschash = (
3334 '<' => '&lt;',
3335 '>' => '&gt;',
3336 '"' => '&quot;',
3337 '--' => '&#45;&#45;',
3338 );
3339 sub xmlescape
3340 0 ▶ {
Subroutine xmlescape: not called CC=2 SCAR=17.9
Pod undocumented
3341 0 my $res;
3342  
3343 0 $_[1] =~ s/\&/\&amp;/gs;
3344 0 eval "\$_[1] =~ s/(".join('|', keys(%xmleschash)).")/\$xmleschash{\$1}/gs;";
3345 #$_[1] =~ s/([\x01-\x1b\x7f-\xff])/"\&\#".ord($1).';'/egs;
3346 0 ▶ if ($_[1] =~ /[\x00-\x08\x0A-\x0C\x0E-\x19\x7f-\xff]/o)
Branch: 1 branch
BranchTrueFalseTotal
if ($_[1] =~ /[\x00-\x08\x0A-\x0C\x0E-\x19\x7f-\xff]/o) { } 0 0 0
3347 {
3348 0 return " <$_[0] xml:encoding=\"base64\">"
3349 . MIME::Base64::encode_base64($_[1]) . "</$_[0]>";
3350 }
3351 else
3352 {
3353 0 return " <$_[0]>$_[1]</$_[0]>";
3354 }
3355 }
3356 }
3357  
3358 sub load_database
3359 1 ▶{
Subroutine load_database: called CC=51 SCAR=62.6
Pod undocumented
3360 1 my ($self, $file) = @_;
3361  
3362 return -531
3363 1 ▶ if (($self->{_read} =~ /^xml/io) && $self->{CBC} && $self->{sprite_Crypt} <= 2);
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"_read"} =~ /^xml/io and $self->{"CBC"} and $self->{"sprite_Crypt"} <= 2 0 1 1
Condition33%2/6
$self->{"_read"} =~ /^xml/io and $self->{"CBC"} and $self->{"sprite_Crypt"} <= 2
!ll&&!rl&&r
100
$self->{"_read"} =~ /^xml/io and $self->{"CBC"}
!ll&&!rl&&r
100
MC/DC0%0/3
$self->{"_read"} =~ /^xml/io and $self->{"CBC"} and $self->{"sprite_Crypt"} <= 2
$self->{"_read"} =~ /^xml/io $self->{"CBC"} $self->{"sprite_Crypt"} <= 2
Truth table25%1/4
A and B and C
A= $self->{"_read"} =~ /^xml/ioB= $self->{"CBC"}C= $self->{"sprite_Crypt"} <= 2
ABCresult
0XX0
10X0
1100
1111
3364  
3365 1 my ($i, $header, @fields, $no_fields, @record, $hash, $loop, $tp, $dflt);
3366 1 local (*FILE);
3367 1 local ($/);
3368 1 ▶ if ($self->{CBC} && $self->{sprite_Crypt} != 2) #ADDED: 20020109
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'CBC'} and $self->{'sprite_Crypt'} != 2) { } 0 1 1
Condition33%1/3
$self->{"CBC"} and $self->{"sprite_Crypt"} != 2
!ll&&!rl&&r
100
MC/DC0%0/2
$self->{"CBC"} and $self->{"sprite_Crypt"} != 2
$self->{"CBC"} $self->{"sprite_Crypt"} != 2
Truth table33%1/3
A and B
A= $self->{"CBC"}B= $self->{"sprite_Crypt"} != 2
ABresult
0X0
100
111
3369 {
3370 0 $/ = "\x03^0jSp".$self->{_record}; #JWT:SUPPORT ANY RECORD-SEPARATOR!
3371 }
3372 else
3373 {
3374 1 $/ = $self->{_record}; #JWT:SUPPORT ANY RECORD-SEPARATOR!
3375 }
3376  
3377 ########$file =~ tr/A-Z/a-z/ unless ($self->{CaseTableNames}); #JWT:TABLE-NAMES ARE NOW CASE-INSENSITIVE!
3378 #$thefid = $file;
3379 # open (FILE, $file) || return (-501);
3380 # binmode FILE; #20000404
3381  
3382 0 ▶ undef @{ $self->{records} } if (scalar @{ $self->{records} });
Branch: 1 branch
BranchTrueFalseTotal
if scalar @{$self->{"records"};} 0 1 1
3383 1 $self->{use_fields} = '';
3384 1 $self->{key_fields} = ''; #20000223 - FIX LOSS OF KEY ASTERISK ON ROLLBACK!
3385 1 ▶ if ($self->{_read} =~ /^xml/io)
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'_read'} =~ /^xml/io) { } 0 1 1
3386 {
3387 0 ▶ return -532 unless ($XMLavailable);
Branch: 1 branch
BranchTrueFalseTotal
unless $XMLavailable 0 0 0
3388 0 my $xs1 = XML::Simple->new();
3389 0 my $xmldoc;
3390 0 eval {$xmldoc = $xs1->XMLin($file, suppressempty => undef); };
3391 0 $errdetails = $@;
3392 0 ▶ return -501 unless ($xmldoc);
Branch: 1 branch
BranchTrueFalseTotal
unless $xmldoc 0 0 0
3393 @fields = ($xmldoc->{select}->{columns}->{order})
3394 ? split(/\,/, $xmldoc->{select}->{columns}->{order})
3395 0 ▶ : keys(%{$xmldoc->{select}->{columns}->{column}});
Branch: 1 branch
BranchTrueFalseTotal
$xmldoc->{'select'}{'columns'}{'order'} ? : 0 0 0
3396 0 foreach my $i (0..$#fields)
3397 {
3398 #$fields[$i] =~ tr/a-z/A-Z/ unless ($self->{sprite_CaseFieldNames}); #DON'T *SEEM* TO NEED, BUT ADD IF NEEDED!
3399 $self->{key_fields} .= ($fields[$i] . ',')
3400 if ($xmldoc->{select}->{columns}->{column}->{$fields[$i]}->{key}
3401 0 ▶ eq 'PRIMARY');
Branch: 1 branch
BranchTrueFalseTotal
if $xmldoc->{"select"}{"columns"}{"column"}{$fields[$i]}{"key"} eq "PRIMARY" 0 0 0
3402 0 ${$self->{types}}{$fields[$i]} =
3403 0 $xmldoc->{select}->{columns}->{column}->{$fields[$i]}->{type};
3404 0 ${$self->{lengths}}{$fields[$i]} =
3405 0 $xmldoc->{select}->{columns}->{column}->{$fields[$i]}->{precision};
3406 0 ${$self->{scales}}{$fields[$i]} =
3407 0 $xmldoc->{select}->{columns}->{column}->{$fields[$i]}->{scale};
3408 0 ${$self->{defaults}}{$fields[$i]} = undef;
3409 0 ▶ if (length($xmldoc->{select}->{columns}->{column}->{$fields[$i]}->{default}) > 0)
Branch: 1 branch
BranchTrueFalseTotal
if (length $xmldoc->{"select"}{"columns"}{"column"}{$fields[$i]}{"default"} > 0) 0 0 0
3410 {
3411 0 ${$self->{defaults}}{$fields[$i]} =
3412 0 $xmldoc->{select}->{columns}->{column}->{$fields[$i]}->{default};
3413 }
3414 0 $self->{use_fields} .= $fields[$i] . ',';
3415 }
3416 0 ▶ if (ref($xmldoc->{select}->{row}) eq 'ARRAY') #ADDED IF-STMT 20020611 TO HANDLE TABLES W/0 OR 1 RECORD!
Branch: 2 branches
BranchTrueFalseTotal
if (ref $xmldoc->{'select'}{'row'} eq 'ARRAY') { } 0 0 0
elsif (ref $xmldoc->{'select'}{'row'} eq 'HASH') { } 0 0 0
3417 {
3418 0 $self->{records} = $xmldoc->{select}->{row}; #TABLE HAS >1 RECORD.
3419 }
3420 elsif (ref($xmldoc->{select}->{row}) eq 'HASH')
3421 {
3422 0 $self->{records}->[0] = $xmldoc->{select}->{row}; #TABLE HAS 1 RECORD.
3423 }
3424 else
3425 {
3426 0 $self->{records} = undef; #TABLE HAS NO RECORDS!
3427 }
3428 0 $xmldoc = undef;
3429  
3430 #UNESCAPE ALL VALUES.
3431  
3432 0 ▶ if (ref($self->{records}) eq 'ARRAY') #ADDED IF-STMT 20020611 TO SKIP TABLES W/NO RECORDS!
Branch: 1 branch
BranchTrueFalseTotal
if (ref $self->{"records"} eq "ARRAY") 0 0 0
3433 {
3434 0 require MIME::Base64; #ADDED 20020816!
3435  
3436 0 ▶ for (my $i=0;$i<=$#{$self->{records}};$i++)
Branch: 1 branch
BranchTrueFalseTotal
if ($i <= $#{$$self{"records"};}) 0 0 0
3437 {
3438 0 foreach my $j (@fields)
3439 {
3440 0 ▶ if ($self->{records}->[$i]->{$j}->{'xml:encoding'})
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{"records"}[$i]{$j}{"xml:encoding"}) 0 0 0
3441 {
3442 0 $self->{records}->[$i]->{$j} = MIME::Base64::decode_base64($self->{records}->[$i]->{$j}->{content});
3443 }
3444 0 ▶ $self->{records}->[$i]->{$j} = '' if (ref($self->{records}->[$i]->{$j}));
Branch: 1 branch
BranchTrueFalseTotal
if ref $self->{"records"}[$i]{$j} 0 0 0
3445 0 $self->{records}->[$i]->{$j} =~ s/\&lt;/\</gso;
3446 0 $self->{records}->[$i]->{$j} =~ s/\&gt;/\>/gso;
3447 0 $self->{records}->[$i]->{$j} =~ s/\&quot;/\"/gso;
3448 0 $self->{records}->[$i]->{$j} =~ s/\&\#45;/\-/gso;
3449 #$self->{records}->[$i]->{$j} =~ s/\&\#0;/\0/gs;
3450 #$self->{records}->[$i]->{$j} =~ s/\&\#(\d+);/pack('C', $1)/egs;
3451 0 $self->{records}->[$i]->{$j} =~ s/\&amp;/\&/gso;
3452 }
3453 }
3454 }
3455 }
3456 else
3457 {
3458 1 ▶ open (FILE, $file) || return (-501);
Branch: 1 branch
BranchTrueFalseTotal
open FILE, $file or return -501 1 0 1
3459 1 binmode FILE; #20000404
3460  
3461 # if (($^O eq 'MSWin32') or ($^O =~ /cygwin/i)) #CHGD. TO NEXT 20020221
3462 1 ▶ if ($self->{platform} eq 'PC')
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'platform'} eq 'PC') { } 0 1 1
3463 {
3464 0 ▶ $self->lock || $self->display_error (-515);
Branch: 1 branch
BranchTrueFalseTotal
$self->lock or $self->display_error(-515) 0 0 0
3465 }
3466 else #GOOD, MUST BE A NON-M$ SYSTEM :-)
3467 {
3468 1 ▶ eval { flock (FILE, $JSprite::LOCK_EX) || die };
Branch: 1 branch
BranchTrueFalseTotal
flock FILE, $LOCK_EX or die 1 0 1
3469
3470 1 ▶ if ($@)
Branch: 1 branch
BranchTrueFalseTotal
if ($@) 0 1 1
3471 {
3472 0 ▶ $self->lock || $self->display_error (-515) if ($@);
Branch: 1 branch
BranchTrueFalseTotal
if $@ 0 0 0
Condition0%0/6
$@ && ($self->lock || $self->display_error(-515))
!ll&&!rl&&r
000
$self->lock or $self->display_error(-515)
l!l&&r!l&&!r
000
MC/DC0%0/3
$@ && ($self->lock || $self->display_error(-515))
$@ $self->lock $self->display_error(-515)
Truth table0%0/4
A && B or C
A= $@B= $self->lockC= $self->display_error(-515)
ABCresult
0XX0
1000
11X1
1011
3473 }
3474 }
3475 1 $_ = <FILE>;
3476 1 chomp; #JWT:SUPPORT ANY RECORD-SEPARATOR!
3477 1 my $t = $_;
3478 1 ▶ $_ = $self->{CBC}->decrypt($t) if ($self->{CBC} && $self->{sprite_Crypt} != 2); #ADDED: 20020109
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"CBC"} and $self->{"sprite_Crypt"} != 2 0 1 1
Condition33%1/3
$self->{"CBC"} and $self->{"sprite_Crypt"} != 2
!ll&&!rl&&r
100
MC/DC0%0/2
$self->{"CBC"} and $self->{"sprite_Crypt"} != 2
$self->{"CBC"} $self->{"sprite_Crypt"} != 2
Truth table33%1/3
A and B
A= $self->{"CBC"}B= $self->{"sprite_Crypt"} != 2
ABresult
0X0
100
111
3479 1 ▶ return -527 unless (/^\w+\=/o); #ADDED 20020110
Branch: 1 branch
BranchTrueFalseTotal
unless /^\w+\=/o 0 1 1
3480  
3481 1 ($header) = /^ *(.*?) *$/o;
3482 #####################$header =~ tr/a-z/A-Z/; #JWT 20000316
3483 #@fields = split (/$self->{_read}/o, $header); #CHGD TO NEXT LINE 20021216.
3484 1 @fields = split (/\Q$self->{_read}\E/, $header);
3485 1 $no_fields = $#fields;
3486  
3487 1 undef %{ $self->{types} };
3488 1 undef %{ $self->{lengths} };
3489 1 undef %{ $self->{scales} }; #ADDED 20000306.
3490  
3491 1 my $ln;
3492 1 foreach $i (0..$#fields)
3493 {
3494 3 $dflt = undef;
3495 3 ($fields[$i],$tp,$dflt) = split(/\=/o ,$fields[$i]);
3496 3 ▶ $fields[$i] =~ tr/a-z/A-Z/ unless ($self->{sprite_CaseFieldNames});
Branch: 1 branch
BranchTrueFalseTotal
unless $self->{"sprite_CaseFieldNames"} 3 0 3
3497 3 ▶ $tp = 'VARCHAR(40)' unless($tp);
Branch: 1 branch
BranchTrueFalseTotal
unless $tp 0 3 3
3498 3 $tp =~ tr/a-z/A-Z/;
3499 3 ▶ $self->{key_fields} .= $fields[$i] . ','
Branch: 1 branch
BranchTrueFalseTotal
if $tp =~ s/^\*//o 1 2 3
3500 if ($tp =~ s/^\*//o); #JWT: *TYPE means KEY FIELD!
3501 3 $ln = 40;
3502 3 ▶ $ln = 10 if ($tp =~ /NUM|INT|FLOAT|DOUBLE/);
Branch: 1 branch
BranchTrueFalseTotal
if $tp =~ /NUM|INT|FLOAT|DOUBLE/ 1 2 3
3503 #$ln = 5000 if ($tp =~ /$BLOBTYPES/); #CHGD. 20020110.
3504 3 ▶ $ln = $self->{LongReadLen} || 0 if ($tp =~ /$BLOBTYPES/);
Branch: 1 branch
BranchTrueFalseTotal
if $tp =~ /$BLOBTYPES/ 0 3 3
Condition0%0/2
$self->{'LongReadLen'} || 0
l!l
00
MC/DC0%0/1
$self->{'LongReadLen'} || 0
$self->{'LongReadLen'}
Truth table0%0/2
A
A= $self->{'LongReadLen'}
Aresult
11
00
3505 3 ▶ $ln = $2 if ($tp =~ s/(.*)\((.*)\)/$1/);
Branch: 1 branch
BranchTrueFalseTotal
if $tp =~ s/(.*)\((.*)\)/$1/ 3 0 3
3506 3 ${$self->{types}}{$fields[$i]} = $tp;
3507 3 ${$self->{lengths}}{$fields[$i]} = $ln;
3508 3 ${$self->{defaults}}{$fields[$i]} = undef;
3509 0 ▶ ${$self->{defaults}}{$fields[$i]} = $dflt if (defined $dflt);
Branch: 1 branch
BranchTrueFalseTotal
if defined $dflt 0 3 3
3510 3 ▶ if (${$self->{lengths}}{$fields[$i]} =~ s/\,(\d+)//)
Branch: 2 branches
BranchTrueFalseTotal
if (${$$self{'lengths'};}{$fields[$i]} =~ s/\,(\d+)//) { } 0 3 3
elsif (${$$self{'types'};}{$fields[$i]} eq 'FLOAT') { } 0 3 3
3511 {
3512 #NOTE: ORACLE NEGATIVE SCALES NOT CURRENTLY SUPPORTED!
3513  
3514 0 ${$self->{scales}}{$fields[$i]} = $1;
3515 }
3516 3 elsif (${$self->{types}}{$fields[$i]} eq 'FLOAT')
3517 {
3518 0 ${$self->{scales}}{$fields[$i]} = ${$self->{lengths}}{$fields[$i]} - 3;
3519 }
3520 3 ▶ ${$self->{scales}}{$fields[$i]} = '0' unless (${$self->{scales}}{$fields[$i]});
Branch: 1 branch
BranchTrueFalseTotal
unless ${$$self{"scales"};}{$fields[$i]} 3 0 3
3521  
3522 # (JWT 8/8/1998) $self->{use_fields} .= $column_string . ','; #JWT
3523 3 $self->{use_fields} .= $fields[$i] . ','; #JWT
3524 }
3525  
3526 1 ▶ while (<FILE>)
Branch: 1 branch
BranchTrueFalseTotal
if (defined($_ = readline FILE)) 0 1 1
3527 {
3528 0 chomp;
3529 0 $t = $_;
3530 0 ▶ $_ = $self->{CBC}->decrypt($t) if ($self->{CBC} && $self->{sprite_Crypt} != 2); #ADDED: 20020109
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"CBC"} and $self->{"sprite_Crypt"} != 2 0 0 0
Condition0%0/3
$self->{"CBC"} and $self->{"sprite_Crypt"} != 2
!ll&&!rl&&r
000
MC/DC0%0/2
$self->{"CBC"} and $self->{"sprite_Crypt"} != 2
$self->{"CBC"} $self->{"sprite_Crypt"} != 2
Truth table0%0/3
A and B
A= $self->{"CBC"}B= $self->{"sprite_Crypt"} != 2
ABresult
0X0
100
111
3531  
3532 0 ▶ next unless ($_);
Branch: 1 branch
BranchTrueFalseTotal
unless $_ 0 0 0
3533  
3534 #@record = split (/$self->{_read}/s, $_); #CHGD. TO NEXT LINE 20021216
3535 0 @record = split (/\Q$self->{_read}\E/s, $_);
3536  
3537 0 $hash = {};
3538  
3539 0 ▶ for ($loop=0; $loop <= $no_fields; $loop++)
Branch: 1 branch
BranchTrueFalseTotal
if ($loop <= $no_fields) 0 0 0
3540 {
3541 #NEXT 2 ADDED 20020111 TO PERMIT EMBEDDED RECORD & FIELD SEPERATORS.
3542 0 $record[$loop] =~ s/\x02\^0jSpR1tE\x02/$self->{_record}/gs; #RESTORE EMBEDDED RECORD SEPARATORS.
3543 0 $record[$loop] =~ s/\x02\^1jSpR1tE\x02/$self->{_read}/gs; #RESTORE EMBEDDED RECORD SEPARATORS.
3544 0 $hash->{ $fields[$loop] } = $record[$loop];
3545 }
3546  
3547 0 push @{ $self->{records} }, $hash;
3548 }
3549  
3550 1 close (FILE);
3551  
3552 1 ▶ $self->unlock || $self->display_error (-516);
Branch: 1 branch
BranchTrueFalseTotal
$self->unlock or $self->display_error(-516) 1 0 1
3553 }
3554  
3555 1 ▶ chop ($self->{use_fields}) if ($self->{use_fields}); #REMOVE TRAILING ','.
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"use_fields"} 1 0 1
3556 1 ▶ chop ($self->{key_fields}) if ($self->{key_fields});
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"key_fields"} 1 0 1
3557  
3558 1 undef %{ $self->{fields} };
3559 1 undef @{ $self->{order} };
3560  
3561 1 $self->{order} = [ @fields ];
3562 1 $self->{fieldregex} = $self->{use_fields};
3563 1 $self->{fieldregex} =~ s/,/\|/go;
3564  
3565 1 map { $self->{fields}->{$_} = 1 } @fields;
3566  
3567 1 return (1);
3568 }
3569  
3570 sub load_columninfo
3571 0 ▶{
Subroutine load_columninfo: not called CC=11 SCAR=48.8
Pod undocumented
3572 0 my ($self) = shift;
3573 0 my ($sep) = shift;
3574  
3575 0 my $colmlist;
3576  
3577 0 ▶ if ($#{$self->{order}} >= 0)
Branch: 1 branch
BranchTrueFalseTotal
if ($#{$$self{'order'};} >= 0) { } 0 0 0
3578 {
3579 0 $colmlist = join($sep, @{$self->{order}});
3580 }
3581 else
3582 {
3583 0 local (*FILE);
3584 0 local ($_);
3585 0 local ($/) = $self->{_record}; #JWT:SUPPORT ANY RECORD-SEPARATOR!
3586
3587 0 ▶ open(FILE, $self->{file}) || return -501;
Branch: 1 branch
BranchTrueFalseTotal
open FILE, $self->{"file"} or return -501 0 0 0
3588 0 binmode FILE; #20000404
3589 0 ▶ if ($self->{_read} =~ /^xml/io)
Branch: 1 branch
BranchTrueFalseTotal
if ($self->{'_read'} =~ /^xml/io) { } 0 0 0
3590 {
3591 0 ▶ return -531 if ($self->{CBC} && $self->{sprite_Crypt} <= 2);
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"CBC"} and $self->{"sprite_Crypt"} <= 2 0 0 0
Condition0%0/3
$self->{"CBC"} and $self->{"sprite_Crypt"} <= 2
!ll&&!rl&&r
000
MC/DC0%0/2
$self->{"CBC"} and $self->{"sprite_Crypt"} <= 2
$self->{"CBC"} $self->{"sprite_Crypt"} <= 2
Truth table0%0/3
A and B
A= $self->{"CBC"}B= $self->{"sprite_Crypt"} <= 2
ABresult
0X0
100
111
3592 0 ▶ return -532 unless ($XMLavailable);
Branch: 1 branch
BranchTrueFalseTotal
unless $XMLavailable 0 0 0
3593
3594 0 my $xs1 = XML::Simple->new();
3595 0 my $xmltext = '';
3596 0 my $xmldoc;
3597 # eval {$xmldoc = $xs1->XMLin($self->{file}, suppressempty => undef); };
3598 0 ▶ while (<FILE>)
Branch: 1 branch
BranchTrueFalseTotal
if (defined($_ = readline FILE)) 0 0 0
3599 {
3600 0 ▶ last if (/^\s*\<row.*\>\s*$/o);
Branch: 1 branch
BranchTrueFalseTotal
if /^\s*\<row.*\>\s*$/o 0 0 0
3601 0 $xmltext .= $_;
3602 }
3603 0 $xmltext .= <<END_XML; #MAKE IT WELL-FORMED!
3604 </row>
3605 </select>
3606 </database>
3607 END_XML
3608 0 eval {$xmldoc = $xs1->XMLin($xmltext, suppressempty => undef); };
3609 0 $errdetails = $@;
3610 0 ▶ return -501 unless ($xmldoc);
Branch: 1 branch
BranchTrueFalseTotal
unless $xmldoc 0 0 0
3611 0 $colmlist = $xmldoc->{select}->{columns}->{order};
3612 0 ▶ if ($colmlist)
Branch: 1 branch
BranchTrueFalseTotal
if ($colmlist) { } 0 0 0
3613 {
3614 0 @{$self->{order}} = split(/$sep/, $colmlist);
3615 }
3616 else
3617 {
3618 0 @{$self->{order}} = keys(%{$xmldoc->{select}->{columns}->{column}});
3619 0 $colmlist = join($sep, @{$self->{order}});
3620 }
3621 }
3622 else
3623 {
3624 0 my $colmlist = <FILE>;
3625 0 chomp ($colmlist);
3626 #$colmlist =~ s/$self->{_read}/$sep/g; #CHGD. TO NEXT LINE 20021216
3627 0 $colmlist =~ s/\Q$self->{_read}\E/$sep/g;
3628 0 @{$self->{order}} = split(/$sep/, $colmlist);
3629 }
3630 0 close FILE;
3631 }
3632 0 return $colmlist;
3633 }
3634  
3635 sub pscolfn
3636 1 ▶{
Subroutine pscolfn: called CC=8 SCAR=23.0
Pod undocumented
3637 1 my ($self,$id) = @_;
3638 1 ▶ return $id unless ($id =~ /CURRVAL|NEXTVAL/);
Branch: 1 branch
BranchTrueFalseTotal
unless $id =~ /CURRVAL|NEXTVAL/ 0 1 1
3639 1 my ($value) = '';
3640 1 my ($seq_file,$col) = split(/\./,$id);
3641 1 $seq_file = $self->get_path_info($seq_file) . '.seq';
3642 # $seq_file =~ tr/A-Z/a-z/ unless ($self->{CaseTableNames}); #JWT:TABLE-NAMES ARE NOW CASE-INSENSITIVE! - REMOVED 20011218 (get_path_info HANDLES THIS RIGHT!)
3643 #open (FILE, "<$seq_file") || return (-511);
3644 1 ▶ unless (open (FILE, "<$seq_file"))
Branch: 1 branch
BranchTrueFalseTotal
unless (open FILE, "<$seq_file") 0 1 1
3645 {
3646 0 $errdetails = "$@/$? (file:$seq_file)";
3647 0 return (-511);
3648 }
3649 1 my $x = <FILE>;
3650 #chomp($x);
3651 1 $x =~ s/\s+$//o; #20000113
3652 1 my ($incval, $startval) = split(/\,/o ,$x);
3653 1 close (FILE);
3654 1 ▶ if ($id =~ /NEXTVAL/o)
Branch: 1 branch
BranchTrueFalseTotal
if ($id =~ /NEXTVAL/o) 1 0 1
3655 {
3656 #open (FILE, ">$seq_file") || return (-511);
3657 1 ▶ unlink ($seq_file) if ($self->{sprite_forcereplace} && -e $seq_file); #ADDED 20010912.
Branch: 1 branch
BranchTrueFalseTotal
if $self->{"sprite_forcereplace"} and -e $seq_file 0 1 1
Condition33%1/3
$self->{"sprite_forcereplace"} and -e $seq_file
!ll&&!rl&&r
100
MC/DC0%0/2
$self->{"sprite_forcereplace"} and -e $seq_file
$self->{"sprite_forcereplace"} -e $seq_file
Truth table33%1/3
A and B
A= $self->{"sprite_forcereplace"}B= -e $seq_file
ABresult
0X0
100
111
3658 1 ▶ unless (open (FILE, ">$seq_file"))
Branch: 1 branch
BranchTrueFalseTotal
unless (open FILE, ">$seq_file") 0 1 1
3659 {
3660 0 $errdetails = "$@/$? (file:$seq_file)";
3661 0 return (-511);
3662 }
3663 1 ▶ $incval += ($startval || 1);
Condition50%1/2
$startval || 1
l!l
10
MC/DC0%0/1
$startval || 1
$startval
Truth table50%1/2
A
A= $startval
Aresult
11
00
3664 1 print FILE "$incval,$startval\n";
3665 1 close (FILE);
3666 }
3667 1 $value = $incval;
3668 1 $self->{sprite_lastsequence} = $incval; #ADDED 20020905 TO SUPPORT DBIx::GeneratedKey!
3669 1 return $value;
3670 }
3671  
3672 ##++
3673 ## NOTE: Derived from lib/Text/ParseWords.pm. Thanks Hal!
3674 ##--
3675  
3676 0 ▶sub quotewords { #SPLIT UP USER'S SEARCH-EXPRESSION INTO "WORDS" (TOKENISE)!
Subroutine quotewords: not called CC=13 SCAR=52.0
Pod undocumented
3677  
3678 # THIS CODE WAS COPIED FROM THE PERL "TEXT" MODULE, (ParseWords.pm),
3679 # written by: Hal Pomeranz (pomeranz@netcom.com), 23 March 1994
3680 # (Thanks, Hal!)
3681 # MODIFIED BY JIM TURNER (6/97) TO ALLOW ESCAPED (REGULAR-EXPRESSION)
3682 # CHARACTERS TO BE INCLUDED IN WORDS AND TO COMPRESS MULTIPLE OCCURRANCES
3683 # OF THE DELIMITER CHARACTER TO BE COMPRESSED INTO A SINGLE DELIMITER
3684 # (NO EMPTY WORDS).
3685 #
3686 # The inner "for" loop builds up each word (or $field) one $snippet
3687 # at a time. A $snippet is a quoted string, a backslashed character,
3688 # or an unquoted string. We fall out of the "for" loop when we reach
3689 # the end of $_ or when we hit a delimiter. Falling out of the "for"
3690 # loop, we push the $field we've been building up onto the list of
3691 # @words we'll be returning, and then loop back and pull another word
3692 # off of $_.
3693 #
3694 # The first two cases inside the "for" loop deal with quoted strings.
3695 # The first case matches a double quoted string, removes it from $_,
3696 # and assigns the double quoted string to $snippet in the body of the
3697 # conditional. The second case handles single quoted strings. In
3698 # the third case we've found a quote at the current beginning of $_,
3699 # but it didn't match the quoted string regexps in the first two cases,
3700 # so it must be an unbalanced quote and we croak with an error (which can
3701 # be caught by eval()).
3702 #
3703 # The next case handles backslashed characters, and the next case is the
3704 # exit case on reaching the end of the string or finding a delimiter.
3705 #
3706 # Otherwise, we've found an unquoted thing and we pull of characters one
3707 # at a time until we reach something that could start another $snippet--
3708 # a quote of some sort, a backslash, or the delimiter. This one character
3709 # at a time behavior was necessary if the delimiter was going to be a
3710 # regexp (love to hear it if you can figure out a better way).
3711  
3712 0 my ($self, $delim, $keep, @lines) = @_;
3713 0 my (@words,$snippet,$field,$q,@quotes);
3714  
3715 0 $_ = join('', @lines);
3716 0 ▶ while ($_) {
Branch: 1 branch
BranchTrueFalseTotal
if ($_) 0 0 0
3717 0 $field = '';
3718 0 for (;;) {
3719 0 $snippet = '';
3720 0 @quotes = ('\'','"');
3721 0 ▶ if (s/^(["'`])(.+?)\1//) {
Branch: 4 branches
BranchTrueFalseTotal
if (s/^(["'`])(.+?)\1//) { } 0 0 0
elsif (/^["']/o) { } 0 0 0
elsif (s/^\\(.)//o) { } 0 0 0
elsif (not $_ or s/^$delim//) { } 0 0 0
3722 0 $snippet = $2;
3723 0 ▶ $snippet = "$1$snippet$1" if ($keep);
Branch: 1 branch
BranchTrueFalseTotal
if $keep 0 0 0
3724 0 $field .= $snippet;
3725 0 last;
3726 }
3727 elsif (/^["']/o) {
3728 0 $self->display_error(-512);
3729 0 return ();
3730 }
3731 elsif (s/^\\(.)//o) {
3732 0 $snippet = $1;
3733 0 ▶ $snippet = "\\$snippet" if ($keep);
Branch: 1 branch
BranchTrueFalseTotal
if $keep 0 0 0
3734 }
3735 ▶ elsif (!$_ || s/^$delim//) { #REMOVE "+" TO REMOVE DELIMITER-COMPRESSION.
Condition0%0/3
not $_ or s/^$delim//
l!l&&r!l&&!r
000
MC/DC0%0/2
not $_ or s/^$delim//
not $_ s/^$delim//
Truth table0%0/3
not(A) or B
A= not $_B= s/^$delim//
ABresult
1X1
011
000
3736 0 last;
3737 }
3738 else {
3739 0 ▶ while ($_ && !(/^$delim/)) { #ATTEMPT TO HANDLE TWO QUOTES IN A ROW.
Branch: 1 branch
BranchTrueFalseTotal
if ($_ and not /^$delim/) 0 0 0
Condition0%0/3
$_ and not /^$delim/
!ll&&!rl&&r
000
MC/DC0%0/2
$_ and not /^$delim/
$_ not /^$delim/
Truth table0%0/3
A and not(B)
A= $_B= not /^$delim/
ABresult
0X0
100
111
3740 0 ▶ last if (/^['"]/ && ($snippet !~ /\\$/o));
Branch: 1 branch
BranchTrueFalseTotal
if /^['"]/ and not $snippet =~ /\\$/o 0 0 0
Condition0%0/3
/^['"]/ and not $snippet =~ /\\$/o
!ll&&!rl&&r
000
MC/DC0%0/2
/^['"]/ and not $snippet =~ /\\$/o
/^['"]/ not $snippet =~ /\\$/o
Truth table0%0/3
A and not(B)
A= /^['"]/B= not $snippet =~ /\\$/o
ABresult
0X0
100
111
3741 0 $snippet .= substr($_, 0, 1);
3742 0 substr($_, 0, 1) = '';
3743 }
3744 }
3745 0 $field .= $snippet;
3746 }
3747 0 push(@words, $field);
3748 }
3749 0 @words;
3750 }
3751  
3752 sub chkcolumnparms #ADDED 20001218 TO CHECK FUNCTION PARAMETERS FOR FIELD-NAMES.
3753 3 ▶{
Subroutine chkcolumnparms: called CC=3 SCAR=11.0
Pod undocumented
3754 3 my ($self) = shift;
3755 3 my ($evalstr) = shift;
3756  
3757 # $evalstr =~ s/\\\'|\'\'/\x02\^2jSpR1tE\x02/g; #PROTECT QUOTES W/N QUOTES.
3758 # $evalstr =~ s/\\\"|\"\"/\x02\^3jSpR1tE\x02/g; #PROTECT QUOTES W/N QUOTES.
3759 3 $evalstr =~ s/\\\'/\x02\^2jSpR1tE\x02/gso; #PROTECT ESCAPED QUOTES.
3760 3 $evalstr =~ s/\\\"/\x02\^3jSpR1tE\x02/gso; #PROTECT ESCAPED QUOTES.
3761
3762 3 my $i = -1;
3763 3 my (@strings); #PROTECT ANYTHING BETWEEN QUOTES (FIELD NAMES IN LITERALS).
3764 3 $evalstr =~ s/([\'\"])([^\1]*?)\1/
3765 3 my ($one, $two) = ($1, $2);
3766 3 ++$i;
3767 3 $two =~ s|([\'\"])|$1$1|g;
3768 3 $strings[$i] = "$one$two$one";
3769 3 "\x02\^4jSpR1tE\x02$i";
3770 /egs;
3771  
3772 #FIND EACH FIELD NAME PARAMETER & REPLACE IT WITH IT'S VALUE || NAME || EMPTY-STRING.
3773 #$evalstr =~ s/($fieldregex)/ #CHGD. TO NEXT 20020530 + REMVD THIS VBLE.
3774 3 $evalstr =~ s/($self->{fieldregex})/
3775 3 my ($one) = $1;
3776 3 $one =~ tr!a-z!A-Z!;
3777 3 ▶ my $res = (defined $_->{$one}) ? $_->{$one} : $one;
Branch: 1 branch
BranchTrueFalseTotal
defined $_->{$one} ? : 3 0 3
3778  
3779 #$res ||= '""'; #CHGD. TO NEXT (20020225)!
3780 3 ▶ $res = '"'.$res.'"' unless (${$self->{types}}{$one} =~ m#$NUMERICTYPES#i);
Branch: 1 branch
BranchTrueFalseTotal
unless do { $$self{"types"} }->{$one} =~ /$NUMERICTYPES/i 3 0 3
3781 3 $res;
3782 /eigs;
3783  
3784 3 $evalstr =~ s/\x02\^4jSpR1tE\x02(\d+)/$strings[$1]/g; #UNPROTECT LITERALS
3785 3 $evalstr =~ s/\x02\^3jSpR1tE\x02/\\\'/go; #UNPROTECT QUOTES.
3786 3 $evalstr =~ s/\x02\^2jSpR1tE\x02/\\\"/go;
3787 3 return $evalstr;
3788 }
3789  
3790 sub SYSTIME
3791 0 ▶{
Subroutine SYSTIME: not called CC=1 SCAR=6.9
Pod undocumented
3792 0 return time;
3793 }
3794  
3795 sub SYSDATE
3796 1 ▶{
Subroutine SYSDATE: called CC=1 SCAR=0.0
Pod undocumented
3797 1 return time;
3798 }
3799  
3800 sub NUM
3801 0 ▶{
Subroutine NUM: not called CC=1 SCAR=6.9
Pod undocumented
3802 0 return shift;
3803 }
3804  
3805 sub NULL
3806 0 ▶{
Subroutine NULL: not called CC=1 SCAR=6.9
Pod undocumented
3807 0 return '';
3808 }
3809  
3810 sub ROWNUM
3811 0 ▶{
Subroutine ROWNUM: not called CC=1 SCAR=6.9
Pod undocumented
3812 0 return (scalar (@$results) + 1);
3813 }
3814  
3815 sub USER
3816 0 ▶{
Subroutine USER: not called CC=1 SCAR=6.9
Pod undocumented
3817 0 return $sprite_user;
3818 }
3819  
3820 sub fn_register #REGISTER SQL-CALLABLE FUNCTIONS.
3821 1 ▶{
Subroutine fn_register: called CC=3 SCAR=11.3
Pod documented
3822 1 ▶ shift if (ref($_[0]) eq 'HASH'); #20000224
Branch: 1 branch
BranchTrueFalseTotal
if ref $_[0] eq "HASH" 0 1 1
3823 1 my ($fnname, $packagename) = @_;
3824 1 ▶ $packagename = 'main' unless ($packagename);
Branch: 1 branch
BranchTrueFalseTotal
unless $packagename 0 1 1
3825  
3826 1 ▶ eval <<END_EVAL;
Subroutine reverseUP: called CC=1 SCAR=0.0
Pod undocumented
3827 sub $fnname
3828 {
3829 return &${packagename}::$fnname;
3830 }
3831 END_EVAL
3832 }
3833  
3834 1 1;
↑ Summary blib/lib/DBD/Sprite.pm »