| line |
stmt |
bran |
cond |
sub |
pod |
time |
code |
|
1
|
|
|
|
|
|
|
# |
|
2
|
|
|
|
|
|
|
# this is a generic module, used by note database |
|
3
|
|
|
|
|
|
|
# backend modules. |
|
4
|
|
|
|
|
|
|
# |
|
5
|
|
|
|
|
|
|
# Copyright (c) 2000-2017 T.v.Dein |
|
6
|
|
|
|
|
|
|
|
|
7
|
|
|
|
|
|
|
|
|
8
|
|
|
|
|
|
|
package NOTEDB; |
|
9
|
|
|
|
|
|
|
|
|
10
|
1
|
|
|
1
|
|
88972
|
use Exporter (); |
|
|
1
|
|
|
|
|
2
|
|
|
|
1
|
|
|
|
|
153
|
|
|
11
|
1
|
|
|
1
|
|
8
|
use vars qw(@ISA @EXPORT $crypt_supported); |
|
|
1
|
|
|
|
|
2
|
|
|
|
1
|
|
|
|
|
141
|
|
|
12
|
|
|
|
|
|
|
|
|
13
|
|
|
|
|
|
|
$NOTEDB::VERSION = "1.45"; |
|
14
|
|
|
|
|
|
|
|
|
15
|
|
|
|
|
|
|
BEGIN { |
|
16
|
|
|
|
|
|
|
# make sure, it works, otherwise encryption |
|
17
|
|
|
|
|
|
|
# is not supported on this system! |
|
18
|
1
|
|
|
1
|
|
4
|
eval { require Crypt::CBC; }; |
|
|
1
|
|
|
|
|
68
|
|
|
19
|
1
|
50
|
|
|
|
5
|
if($@) { |
|
20
|
1
|
|
|
|
|
1463
|
$NOTEDB::crypt_supported = 0; |
|
21
|
|
|
|
|
|
|
} |
|
22
|
|
|
|
|
|
|
else { |
|
23
|
0
|
|
|
|
|
|
$NOTEDB::crypt_supported = 1; |
|
24
|
|
|
|
|
|
|
} |
|
25
|
|
|
|
|
|
|
} |
|
26
|
|
|
|
|
|
|
|
|
27
|
|
|
|
|
|
|
|
|
28
|
|
|
|
|
|
|
sub no_crypt { |
|
29
|
0
|
|
|
0
|
0
|
|
$NOTEDB::crypt_supported = 0; |
|
30
|
|
|
|
|
|
|
} |
|
31
|
|
|
|
|
|
|
|
|
32
|
|
|
|
|
|
|
|
|
33
|
|
|
|
|
|
|
sub use_crypt { |
|
34
|
0
|
|
|
0
|
0
|
|
my($this,$key,$method) = @_; |
|
35
|
0
|
|
|
|
|
|
my($cipher); |
|
36
|
0
|
0
|
|
|
|
|
if($NOTEDB::crypt_supported == 1) { |
|
37
|
0
|
|
|
|
|
|
eval { |
|
38
|
0
|
|
|
|
|
|
$cipher = new Crypt::CBC($key, $method); |
|
39
|
|
|
|
|
|
|
}; |
|
40
|
0
|
0
|
|
|
|
|
if($@) { |
|
41
|
0
|
|
|
|
|
|
print "warning: Crypt::$method not supported by system!\n"; |
|
42
|
0
|
|
|
|
|
|
$NOTEDB::crypt_supported = 0; |
|
43
|
|
|
|
|
|
|
} |
|
44
|
|
|
|
|
|
|
else { |
|
45
|
0
|
|
|
|
|
|
$this->{cipher} = $cipher; |
|
46
|
|
|
|
|
|
|
} |
|
47
|
|
|
|
|
|
|
} |
|
48
|
|
|
|
|
|
|
else{ |
|
49
|
0
|
|
|
|
|
|
print "warning: Crypt::CBC not supported by system!\n"; |
|
50
|
|
|
|
|
|
|
} |
|
51
|
|
|
|
|
|
|
} |
|
52
|
|
|
|
|
|
|
|
|
53
|
|
|
|
|
|
|
|
|
54
|
|
|
|
|
|
|
sub use_cache { |
|
55
|
|
|
|
|
|
|
# |
|
56
|
|
|
|
|
|
|
# this sub turns on cache support |
|
57
|
|
|
|
|
|
|
# |
|
58
|
0
|
|
|
0
|
0
|
|
my $this = shift; |
|
59
|
0
|
|
|
|
|
|
$this->{use_cache} = 1; |
|
60
|
0
|
|
|
|
|
|
$this->{changed} = 1; |
|
61
|
|
|
|
|
|
|
} |
|
62
|
|
|
|
|
|
|
|
|
63
|
|
|
|
|
|
|
sub cache { |
|
64
|
|
|
|
|
|
|
# |
|
65
|
|
|
|
|
|
|
# store the whole db as hash |
|
66
|
|
|
|
|
|
|
# if use_cache is turned on |
|
67
|
|
|
|
|
|
|
# |
|
68
|
0
|
|
|
0
|
0
|
|
my $this = shift; |
|
69
|
0
|
0
|
|
|
|
|
if ($this->{use_cache}) { |
|
70
|
0
|
|
|
|
|
|
my %res = @_; |
|
71
|
0
|
|
|
|
|
|
%{$this->{cache}} = %res; |
|
|
0
|
|
|
|
|
|
|
|
72
|
|
|
|
|
|
|
} |
|
73
|
|
|
|
|
|
|
} |
|
74
|
|
|
|
|
|
|
|
|
75
|
|
|
|
|
|
|
sub unchanged { |
|
76
|
|
|
|
|
|
|
# |
|
77
|
|
|
|
|
|
|
# return true if $this->{changed} is true, this will |
|
78
|
|
|
|
|
|
|
# be set to true by writing subs using $this->changed(). |
|
79
|
|
|
|
|
|
|
# |
|
80
|
0
|
|
|
0
|
0
|
|
my $this = shift; |
|
81
|
0
|
0
|
|
|
|
|
return 0 if(!$this->{use_cache}); |
|
82
|
0
|
0
|
|
|
|
|
if ($this->{changed}) { |
|
83
|
0
|
|
|
|
|
|
$this->{changed} = 0; |
|
84
|
0
|
|
|
|
|
|
return 0; |
|
85
|
|
|
|
|
|
|
} |
|
86
|
|
|
|
|
|
|
else { |
|
87
|
0
|
|
|
|
|
|
print "%\n"; |
|
88
|
0
|
|
|
|
|
|
return 1; |
|
89
|
|
|
|
|
|
|
} |
|
90
|
|
|
|
|
|
|
} |
|
91
|
|
|
|
|
|
|
|
|
92
|
|
|
|
|
|
|
sub changed { |
|
93
|
|
|
|
|
|
|
# |
|
94
|
|
|
|
|
|
|
# turn on $this->{changed} |
|
95
|
|
|
|
|
|
|
# this will be used by update or create subs. |
|
96
|
|
|
|
|
|
|
# |
|
97
|
0
|
|
|
0
|
0
|
|
my $this = shift; |
|
98
|
0
|
|
|
|
|
|
$this->{changed} = 1; |
|
99
|
0
|
|
|
|
|
|
return 1; |
|
100
|
|
|
|
|
|
|
} |
|
101
|
|
|
|
|
|
|
|
|
102
|
|
|
|
|
|
|
|
|
103
|
|
|
|
|
|
|
sub generate_search { |
|
104
|
|
|
|
|
|
|
# |
|
105
|
|
|
|
|
|
|
# get user input and create perlcode ready for eval |
|
106
|
|
|
|
|
|
|
# sample input: |
|
107
|
|
|
|
|
|
|
# "ann.a OR eg???on AND u*do$" |
|
108
|
|
|
|
|
|
|
# resulting output: |
|
109
|
|
|
|
|
|
|
# "$match = 1 if(/ann\.a/i or /eg...on/i and /u.*do\$/i ); |
|
110
|
|
|
|
|
|
|
# |
|
111
|
0
|
|
|
0
|
0
|
|
my($this, $string) = @_; |
|
112
|
|
|
|
|
|
|
|
|
113
|
0
|
|
|
|
|
|
my $case = "i"; |
|
114
|
|
|
|
|
|
|
|
|
115
|
0
|
0
|
|
|
|
|
if ($string =~ /^\/.+?\/$/) { |
|
|
|
0
|
|
|
|
|
|
|
116
|
0
|
|
|
|
|
|
return $string; |
|
117
|
|
|
|
|
|
|
} |
|
118
|
|
|
|
|
|
|
elsif (!$string) { |
|
119
|
0
|
|
|
|
|
|
return "/^/"; |
|
120
|
|
|
|
|
|
|
} |
|
121
|
|
|
|
|
|
|
|
|
122
|
|
|
|
|
|
|
# we will get a / in front of the first word too! |
|
123
|
0
|
|
|
|
|
|
$string = " " . $string . " "; |
|
124
|
|
|
|
|
|
|
|
|
125
|
|
|
|
|
|
|
# check for apostrophs |
|
126
|
0
|
|
|
|
|
|
$string =~ s/(?<=\s)(\(??)("[^"]+"|\S+)(\)??)(?=\s)/$1 . $this->check_exact($2) . $3/ge; |
|
|
0
|
|
|
|
|
|
|
|
127
|
|
|
|
|
|
|
|
|
128
|
|
|
|
|
|
|
# remove odd spaces infront of and after »and« and »or« |
|
129
|
0
|
|
|
|
|
|
$string =~ s/\s\s*(AND|OR)\s\s*/ $1 /g; |
|
130
|
|
|
|
|
|
|
|
|
131
|
|
|
|
|
|
|
# remove odd spaces infront of »(« and after »)« |
|
132
|
0
|
|
|
|
|
|
$string =~ s/(\s*\()/\(/g; |
|
133
|
0
|
|
|
|
|
|
$string =~ s/(\)\s*)/\)/g; |
|
134
|
|
|
|
|
|
|
|
|
135
|
|
|
|
|
|
|
# remove first and last space so it will not masked! |
|
136
|
0
|
|
|
|
|
|
$string =~ s/^\s//; |
|
137
|
0
|
|
|
|
|
|
$string =~ s/\s$//; |
|
138
|
|
|
|
|
|
|
|
|
139
|
|
|
|
|
|
|
# mask spaces if not infront of or after »and« and »or« |
|
140
|
0
|
|
|
|
|
|
$string =~ s/(?
|
|
|
0
|
|
|
|
|
|
|
|
141
|
|
|
|
|
|
|
|
|
142
|
|
|
|
|
|
|
# add first space again |
|
143
|
0
|
|
|
|
|
|
$string = " " . $string; |
|
144
|
|
|
|
|
|
|
|
|
145
|
|
|
|
|
|
|
# lowercase AND and OR |
|
146
|
0
|
|
|
|
|
|
$string =~ s/(\s??OR\s??|\s??AND\s??)/\L$1\E/g; |
|
147
|
|
|
|
|
|
|
|
|
148
|
|
|
|
|
|
|
# surround brackets with at least one space |
|
149
|
0
|
|
|
|
|
|
$string =~ s/(?
|
|
150
|
|
|
|
|
|
|
|
|
151
|
|
|
|
|
|
|
# surround strings with slashes |
|
152
|
0
|
|
|
|
|
|
$string =~ s/(?<=\s)(\S+)/ $this->check_or($1, $case) /ge; |
|
|
0
|
|
|
|
|
|
|
|
153
|
|
|
|
|
|
|
|
|
154
|
|
|
|
|
|
|
# remove slashes on »and« and »or« |
|
155
|
0
|
|
|
|
|
|
$string =~ s/\/(and|or)\/$case/$1/g; |
|
156
|
|
|
|
|
|
|
|
|
157
|
|
|
|
|
|
|
# remove spaces inside /string/ constructs |
|
158
|
0
|
|
|
|
|
|
$string =~ s/(?
|
|
159
|
|
|
|
|
|
|
|
|
160
|
0
|
|
|
|
|
|
$string =~ s/\/\s*(?!and|or)/\//g; |
|
161
|
|
|
|
|
|
|
|
|
162
|
|
|
|
|
|
|
#my $res = qq(\$match = 1 if($string);); |
|
163
|
0
|
|
|
|
|
|
return qq(\$match = 1 if($string);); |
|
164
|
|
|
|
|
|
|
#print $res . "\n"; |
|
165
|
|
|
|
|
|
|
#return $res; |
|
166
|
|
|
|
|
|
|
} |
|
167
|
|
|
|
|
|
|
|
|
168
|
|
|
|
|
|
|
sub check_or { |
|
169
|
|
|
|
|
|
|
# |
|
170
|
|
|
|
|
|
|
# surrounds string with slashes if it is not |
|
171
|
|
|
|
|
|
|
# »and« or »or« |
|
172
|
|
|
|
|
|
|
# |
|
173
|
0
|
|
|
0
|
0
|
|
my($this, $str, $case) = @_; |
|
174
|
0
|
0
|
|
|
|
|
if ($str =~ /^\s*(or|and)\s*$/) { |
|
|
|
0
|
|
|
|
|
|
|
175
|
0
|
|
|
|
|
|
return " $str "; |
|
176
|
|
|
|
|
|
|
} |
|
177
|
|
|
|
|
|
|
elsif ($str =~ /(?
|
|
178
|
0
|
|
|
|
|
|
return $str; |
|
179
|
|
|
|
|
|
|
} |
|
180
|
|
|
|
|
|
|
else { |
|
181
|
0
|
|
|
|
|
|
return " \/$str\/$case "; |
|
182
|
|
|
|
|
|
|
} |
|
183
|
|
|
|
|
|
|
} |
|
184
|
|
|
|
|
|
|
|
|
185
|
|
|
|
|
|
|
|
|
186
|
|
|
|
|
|
|
sub check_exact { |
|
187
|
|
|
|
|
|
|
# |
|
188
|
|
|
|
|
|
|
# helper for generate_search() |
|
189
|
|
|
|
|
|
|
# masks special chars if string |
|
190
|
|
|
|
|
|
|
# not inside "" |
|
191
|
|
|
|
|
|
|
# |
|
192
|
0
|
|
|
0
|
0
|
|
my($this, $str) = @_; |
|
193
|
|
|
|
|
|
|
|
|
194
|
0
|
|
|
|
|
|
my %wildcards = ( |
|
195
|
|
|
|
|
|
|
'*' => '.*', |
|
196
|
|
|
|
|
|
|
'?' => '.', |
|
197
|
|
|
|
|
|
|
'[' => '[', |
|
198
|
|
|
|
|
|
|
']' => ']', |
|
199
|
|
|
|
|
|
|
'+' => '\+', |
|
200
|
|
|
|
|
|
|
'.' => '\.', |
|
201
|
|
|
|
|
|
|
'$' => '\$', |
|
202
|
|
|
|
|
|
|
'@' => '\@', |
|
203
|
|
|
|
|
|
|
'/' => '\/', |
|
204
|
|
|
|
|
|
|
'|' => '\|', |
|
205
|
|
|
|
|
|
|
'}' => '\}', |
|
206
|
|
|
|
|
|
|
'{' => '\{', |
|
207
|
|
|
|
|
|
|
); |
|
208
|
|
|
|
|
|
|
|
|
209
|
0
|
|
|
|
|
|
my %escapes = ( |
|
210
|
|
|
|
|
|
|
'*' => '\*', |
|
211
|
|
|
|
|
|
|
'?' => '\?', |
|
212
|
|
|
|
|
|
|
'[' => '[', |
|
213
|
|
|
|
|
|
|
']' => ']', |
|
214
|
|
|
|
|
|
|
'+' => '\+', |
|
215
|
|
|
|
|
|
|
'.' => '\.', |
|
216
|
|
|
|
|
|
|
'$' => '\$', |
|
217
|
|
|
|
|
|
|
'@' => '\@', |
|
218
|
|
|
|
|
|
|
'(' => '\(', |
|
219
|
|
|
|
|
|
|
')' => '\)', |
|
220
|
|
|
|
|
|
|
'/' => '\/', |
|
221
|
|
|
|
|
|
|
'|' => '\|', |
|
222
|
|
|
|
|
|
|
'}' => '\}', |
|
223
|
|
|
|
|
|
|
'{' => '\{', |
|
224
|
|
|
|
|
|
|
); |
|
225
|
|
|
|
|
|
|
|
|
226
|
|
|
|
|
|
|
# mask backslash |
|
227
|
0
|
|
|
|
|
|
$str =~ s/\\/\\\\/g; |
|
228
|
|
|
|
|
|
|
|
|
229
|
|
|
|
|
|
|
|
|
230
|
0
|
0
|
0
|
|
|
|
if ($str =~ /^"/ && $str =~ /"$/) { |
|
231
|
|
|
|
|
|
|
# mask bracket-constructs |
|
232
|
0
|
0
|
|
|
|
|
$str =~ s/(.)/$escapes{$1} || "$1"/ge; |
|
|
0
|
|
|
|
|
|
|
|
233
|
|
|
|
|
|
|
} |
|
234
|
|
|
|
|
|
|
else { |
|
235
|
0
|
0
|
|
|
|
|
$str =~ s/(.)/$wildcards{$1} || "$1"/ge; |
|
|
0
|
|
|
|
|
|
|
|
236
|
|
|
|
|
|
|
} |
|
237
|
|
|
|
|
|
|
|
|
238
|
0
|
|
|
|
|
|
$str =~ s/^"//; |
|
239
|
0
|
|
|
|
|
|
$str =~ s/"$//; |
|
240
|
|
|
|
|
|
|
|
|
241
|
|
|
|
|
|
|
# mask spaces |
|
242
|
0
|
|
|
|
|
|
$str =~ s/\s/\\s/g; |
|
243
|
0
|
|
|
|
|
|
return $str; |
|
244
|
|
|
|
|
|
|
} |
|
245
|
|
|
|
|
|
|
|
|
246
|
|
|
|
|
|
|
|
|
247
|
|
|
|
|
|
|
|
|
248
|
|
|
|
|
|
|
|
|
249
|
|
|
|
|
|
|
sub lock { |
|
250
|
0
|
|
|
0
|
0
|
|
my ($this) = @_; |
|
251
|
|
|
|
|
|
|
|
|
252
|
0
|
0
|
|
|
|
|
if (-e $this->{LOCKFILE}) { |
|
253
|
0
|
0
|
|
|
|
|
open LOCK, "<$this->{LOCKFILE}" or die "could not open $this->{LOCKFILE}: $!\n"; |
|
254
|
0
|
|
|
|
|
|
my $data = ; |
|
255
|
0
|
|
|
|
|
|
close LOCK; |
|
256
|
0
|
|
|
|
|
|
chomp $data; |
|
257
|
0
|
|
|
|
|
|
print "-- waiting for lock by $data --\n"; |
|
258
|
0
|
|
|
|
|
|
print "-- remove the lockfile if you are sure: \"$this->{LOCKFILE}\" --\n"; |
|
259
|
|
|
|
|
|
|
} |
|
260
|
|
|
|
|
|
|
|
|
261
|
0
|
|
|
|
|
|
my $timeout = 60; |
|
262
|
|
|
|
|
|
|
|
|
263
|
0
|
|
|
|
|
|
eval { |
|
264
|
0
|
|
|
0
|
|
|
local $SIG{ALRM} = sub { die "timeout" }; |
|
|
0
|
|
|
|
|
|
|
|
265
|
0
|
|
|
0
|
|
|
local $SIG{INT} = sub { die "interrupted" }; |
|
|
0
|
|
|
|
|
|
|
|
266
|
0
|
|
|
|
|
|
alarm $timeout - 2; |
|
267
|
0
|
|
|
|
|
|
while (1) { |
|
268
|
0
|
0
|
|
|
|
|
if (! -e $this->{LOCKFILE}) { |
|
269
|
0
|
|
|
|
|
|
umask 022; |
|
270
|
0
|
0
|
|
|
|
|
open LOCK, ">$this->{LOCKFILE}" or die "could not open $this->{LOCKFILE}: $!\n"; |
|
271
|
0
|
|
|
|
|
|
flock LOCK, LOCK_EX; |
|
272
|
|
|
|
|
|
|
|
|
273
|
0
|
|
|
|
|
|
my $now = scalar localtime(); |
|
274
|
0
|
|
|
|
|
|
print LOCK "$ENV{USER} since $now (PID: $$)\n"; |
|
275
|
|
|
|
|
|
|
|
|
276
|
0
|
|
|
|
|
|
flock LOCK, LOCK_UN; |
|
277
|
0
|
|
|
|
|
|
close LOCK; |
|
278
|
0
|
|
|
|
|
|
alarm 0; |
|
279
|
0
|
|
|
|
|
|
return 0; |
|
280
|
|
|
|
|
|
|
} |
|
281
|
0
|
|
|
|
|
|
printf " %0d\r", $timeout; |
|
282
|
0
|
|
|
|
|
|
$timeout--; |
|
283
|
0
|
|
|
|
|
|
sleep 1; |
|
284
|
|
|
|
|
|
|
} |
|
285
|
|
|
|
|
|
|
}; |
|
286
|
0
|
0
|
|
|
|
|
if($@) { |
|
287
|
0
|
0
|
|
|
|
|
if ($@ =~ /^inter/) { |
|
288
|
0
|
|
|
|
|
|
print " interrupted\n"; |
|
289
|
|
|
|
|
|
|
} |
|
290
|
|
|
|
|
|
|
else { |
|
291
|
0
|
|
|
|
|
|
print $@; |
|
292
|
0
|
|
|
|
|
|
print " timeout\n"; |
|
293
|
|
|
|
|
|
|
} |
|
294
|
0
|
|
|
|
|
|
return 1; |
|
295
|
|
|
|
|
|
|
} |
|
296
|
0
|
|
|
|
|
|
return 0; |
|
297
|
|
|
|
|
|
|
} |
|
298
|
|
|
|
|
|
|
|
|
299
|
|
|
|
|
|
|
sub unlock { |
|
300
|
0
|
|
|
0
|
0
|
|
my ($this) = @_; |
|
301
|
0
|
|
|
|
|
|
unlink $this->{LOCKFILE}; |
|
302
|
|
|
|
|
|
|
} |
|
303
|
|
|
|
|
|
|
|
|
304
|
|
|
|
|
|
|
|
|
305
|
|
|
|
|
|
|
|
|
306
|
|
|
|
|
|
|
1; |