| line |
stmt |
bran |
cond |
sub |
pod |
time |
code |
|
1
|
|
|
|
|
|
|
package Dwimmer; |
|
2
|
1
|
|
|
1
|
|
856
|
use Dancer ':syntax'; |
|
|
0
|
|
|
|
|
|
|
|
|
0
|
|
|
|
|
|
|
|
3
|
|
|
|
|
|
|
|
|
4
|
|
|
|
|
|
|
use 5.008005; |
|
5
|
|
|
|
|
|
|
|
|
6
|
|
|
|
|
|
|
our $VERSION = '0.32'; |
|
7
|
|
|
|
|
|
|
|
|
8
|
|
|
|
|
|
|
use Data::Dumper qw(Dumper); |
|
9
|
|
|
|
|
|
|
use Dwimmer::DB; |
|
10
|
|
|
|
|
|
|
use Dwimmer::Tools qw(_get_db _get_site _get_redirect read_file $SCHEMA_VERSION); |
|
11
|
|
|
|
|
|
|
|
|
12
|
|
|
|
|
|
|
use Encode qw(decode); |
|
13
|
|
|
|
|
|
|
use Fcntl qw(:flock); |
|
14
|
|
|
|
|
|
|
use List::Util qw(min); |
|
15
|
|
|
|
|
|
|
use Template; |
|
16
|
|
|
|
|
|
|
use XML::RSS; |
|
17
|
|
|
|
|
|
|
|
|
18
|
|
|
|
|
|
|
load_app 'Dwimmer::Admin', prefix => "/_dwimmer"; |
|
19
|
|
|
|
|
|
|
|
|
20
|
|
|
|
|
|
|
# list of pages that can be accessed withot any login |
|
21
|
|
|
|
|
|
|
my %open = map { $_ => 1 } qw( |
|
22
|
|
|
|
|
|
|
/poll |
|
23
|
|
|
|
|
|
|
/_dwimmer/login.json |
|
24
|
|
|
|
|
|
|
/_dwimmer/session.json |
|
25
|
|
|
|
|
|
|
/_dwimmer/register_email.json /_dwimmer/register_email |
|
26
|
|
|
|
|
|
|
/_dwimmer/validate_email.json /_dwimmer/validate_email |
|
27
|
|
|
|
|
|
|
); |
|
28
|
|
|
|
|
|
|
|
|
29
|
|
|
|
|
|
|
hook before => sub { |
|
30
|
|
|
|
|
|
|
my $path = request->path_info; |
|
31
|
|
|
|
|
|
|
|
|
32
|
|
|
|
|
|
|
# debug(request->uri); |
|
33
|
|
|
|
|
|
|
|
|
34
|
|
|
|
|
|
|
my $db = _get_db(); |
|
35
|
|
|
|
|
|
|
my ($version) = $db->storage->dbh->selectrow_array('PRAGMA user_version'); |
|
36
|
|
|
|
|
|
|
|
|
37
|
|
|
|
|
|
|
#see also do_dbh https://metacpan.org/module/DBIx::Class::Storage::DBI#dbh_do |
|
38
|
|
|
|
|
|
|
if ( $version != $SCHEMA_VERSION ) { |
|
39
|
|
|
|
|
|
|
return halt("Database is currently at version $version while we need version $SCHEMA_VERSION"); |
|
40
|
|
|
|
|
|
|
} |
|
41
|
|
|
|
|
|
|
my ( $host, $url ) = _get_redirect(); |
|
42
|
|
|
|
|
|
|
if ($host) { |
|
43
|
|
|
|
|
|
|
debug("Redirection to $url"); |
|
44
|
|
|
|
|
|
|
return redirect $url; |
|
45
|
|
|
|
|
|
|
} |
|
46
|
|
|
|
|
|
|
|
|
47
|
|
|
|
|
|
|
my ( $site_name, $site ) = _get_site(); |
|
48
|
|
|
|
|
|
|
return halt("Could not find site called '$site_name' in the database") if not $site; |
|
49
|
|
|
|
|
|
|
|
|
50
|
|
|
|
|
|
|
# TODO send text or json whatever is appropriate |
|
51
|
|
|
|
|
|
|
# return to_json { error => 'no_site_found' } if not $site; |
|
52
|
|
|
|
|
|
|
|
|
53
|
|
|
|
|
|
|
return if $open{$path}; |
|
54
|
|
|
|
|
|
|
return if $path !~ m{/_}; # only the pages starting with /_ are management pages that need restriction |
|
55
|
|
|
|
|
|
|
|
|
56
|
|
|
|
|
|
|
if ( not session->{logged_in} ) { |
|
57
|
|
|
|
|
|
|
if ( $path =~ /json$/ ) { |
|
58
|
|
|
|
|
|
|
request->path_info('/_dwimmer/needs_login.json'); |
|
59
|
|
|
|
|
|
|
} else { |
|
60
|
|
|
|
|
|
|
request->path_info('/_dwimmer/needs_login'); |
|
61
|
|
|
|
|
|
|
} |
|
62
|
|
|
|
|
|
|
} |
|
63
|
|
|
|
|
|
|
return; |
|
64
|
|
|
|
|
|
|
}; |
|
65
|
|
|
|
|
|
|
|
|
66
|
|
|
|
|
|
|
get '/search' => sub { |
|
67
|
|
|
|
|
|
|
my $text = param('text'); |
|
68
|
|
|
|
|
|
|
return 'No search term provided' |
|
69
|
|
|
|
|
|
|
if not defined $text or $text =~ /^\s*$/; |
|
70
|
|
|
|
|
|
|
|
|
71
|
|
|
|
|
|
|
my $results = Dwimmer::Admin::search(text => $text); |
|
72
|
|
|
|
|
|
|
template 'search_results', { results => $results }; |
|
73
|
|
|
|
|
|
|
}; |
|
74
|
|
|
|
|
|
|
|
|
75
|
|
|
|
|
|
|
|
|
76
|
|
|
|
|
|
|
sub route_index { |
|
77
|
|
|
|
|
|
|
my ( $site_name, $site ) = _get_site(); |
|
78
|
|
|
|
|
|
|
|
|
79
|
|
|
|
|
|
|
my $path = request->path_info; |
|
80
|
|
|
|
|
|
|
my $data = Dwimmer::Admin::get_page_data( $site, $path ); |
|
81
|
|
|
|
|
|
|
|
|
82
|
|
|
|
|
|
|
if ($data) { |
|
83
|
|
|
|
|
|
|
if ( $data->{body} =~ s{\[poll://([^]]+)\]}{} ) { |
|
84
|
|
|
|
|
|
|
my $poll = $1; |
|
85
|
|
|
|
|
|
|
if ( not params->{submitted} ) { |
|
86
|
|
|
|
|
|
|
$data->{body} = _poll($poll); |
|
87
|
|
|
|
|
|
|
} |
|
88
|
|
|
|
|
|
|
} |
|
89
|
|
|
|
|
|
|
|
|
90
|
|
|
|
|
|
|
# disable special tag processing for now, will need to |
|
91
|
|
|
|
|
|
|
$data->{body} =~ s{\[\[(\w+)://([^]]+)\]\]}{_process($1, $2)}eg; |
|
92
|
|
|
|
|
|
|
$data->{body} =~ s{\[\[([\w .\$@%-]+)\]\]}{$1}g; |
|
93
|
|
|
|
|
|
|
|
|
94
|
|
|
|
|
|
|
return Dwimmer::Admin::render_response( 'index', { page => $data } ); |
|
95
|
|
|
|
|
|
|
} else { |
|
96
|
|
|
|
|
|
|
|
|
97
|
|
|
|
|
|
|
# TODO: actually this should check if the user has the right to create a new page |
|
98
|
|
|
|
|
|
|
# on this site |
|
99
|
|
|
|
|
|
|
if ( session->{logged_in} ) { |
|
100
|
|
|
|
|
|
|
return Dwimmer::Admin::render_response( 'error', { page_does_not_exist => 1, creation_offer => 1 } ); |
|
101
|
|
|
|
|
|
|
} else { |
|
102
|
|
|
|
|
|
|
return Dwimmer::Admin::render_response( 'error', { page_does_not_exist => 1 } ); |
|
103
|
|
|
|
|
|
|
} |
|
104
|
|
|
|
|
|
|
} |
|
105
|
|
|
|
|
|
|
}; |
|
106
|
|
|
|
|
|
|
|
|
107
|
|
|
|
|
|
|
get '/update.rss' => sub { |
|
108
|
|
|
|
|
|
|
my $db = _get_db(); |
|
109
|
|
|
|
|
|
|
my ( $site_name, $site ) = _get_site(); |
|
110
|
|
|
|
|
|
|
|
|
111
|
|
|
|
|
|
|
my $host = request->uri_base; |
|
112
|
|
|
|
|
|
|
my $rss = XML::RSS->new( version => '1.0' ); |
|
113
|
|
|
|
|
|
|
my $year = 1900 + (localtime)[5]; |
|
114
|
|
|
|
|
|
|
$rss->channel( |
|
115
|
|
|
|
|
|
|
title => "Dwimmer.org", |
|
116
|
|
|
|
|
|
|
link => $host, |
|
117
|
|
|
|
|
|
|
description => "A Dwimmer based site", |
|
118
|
|
|
|
|
|
|
dc => { |
|
119
|
|
|
|
|
|
|
language => 'en-us', |
|
120
|
|
|
|
|
|
|
publisher => 'szabgab@gmail.com', |
|
121
|
|
|
|
|
|
|
rights => "Copyright $year", |
|
122
|
|
|
|
|
|
|
}, |
|
123
|
|
|
|
|
|
|
syn => { |
|
124
|
|
|
|
|
|
|
updatePeriod => "hourly", |
|
125
|
|
|
|
|
|
|
updateFrequency => "1", |
|
126
|
|
|
|
|
|
|
updateBase => "1901-01-01T00:00+00:00", |
|
127
|
|
|
|
|
|
|
} |
|
128
|
|
|
|
|
|
|
); |
|
129
|
|
|
|
|
|
|
|
|
130
|
|
|
|
|
|
|
my @pages = $db->resultset('Page')->search( { siteid => $site->id } ); |
|
131
|
|
|
|
|
|
|
#my @urls = map { { loc => [ $host . $_->filename ] } } @res; |
|
132
|
|
|
|
|
|
|
|
|
133
|
|
|
|
|
|
|
my $RSS = 10; |
|
134
|
|
|
|
|
|
|
|
|
135
|
|
|
|
|
|
|
# TODO this whole thing should be a single query and not one for each item! |
|
136
|
|
|
|
|
|
|
foreach my $p (reverse @pages[-min($RSS, scalar @pages) .. -1]) { |
|
137
|
|
|
|
|
|
|
my $page = $db->resultset('PageHistory')->find( { siteid => $site->id, pageid => $p->id, revision => $p->revision } ); |
|
138
|
|
|
|
|
|
|
my $text = $page->body; |
|
139
|
|
|
|
|
|
|
# $text =~ s{"/}{"$host/}g; |
|
140
|
|
|
|
|
|
|
$rss->add_item( |
|
141
|
|
|
|
|
|
|
title => decode('utf-8', $page->title), |
|
142
|
|
|
|
|
|
|
link => $host . $page->filename, |
|
143
|
|
|
|
|
|
|
description => decode('utf-8', $text), |
|
144
|
|
|
|
|
|
|
dc => { |
|
145
|
|
|
|
|
|
|
creator => $page->author->name, |
|
146
|
|
|
|
|
|
|
date => POSIX::strftime("%Y-%m-%dT%H:%M:%S+00:00", localtime $page->timestamp), # 2008-05-14T13:43:49+00:00 |
|
147
|
|
|
|
|
|
|
subject => $page->title, |
|
148
|
|
|
|
|
|
|
} |
|
149
|
|
|
|
|
|
|
); |
|
150
|
|
|
|
|
|
|
} |
|
151
|
|
|
|
|
|
|
|
|
152
|
|
|
|
|
|
|
return $rss->as_string; |
|
153
|
|
|
|
|
|
|
}; |
|
154
|
|
|
|
|
|
|
|
|
155
|
|
|
|
|
|
|
|
|
156
|
|
|
|
|
|
|
# http://www.sitemaps.org/protocol.html |
|
157
|
|
|
|
|
|
|
get '/sitemap.xml' => sub { |
|
158
|
|
|
|
|
|
|
|
|
159
|
|
|
|
|
|
|
# see also Dwimmer::Admin get_pages.json |
|
160
|
|
|
|
|
|
|
my $db = _get_db(); |
|
161
|
|
|
|
|
|
|
my ( $site_name, $site ) = _get_site(); |
|
162
|
|
|
|
|
|
|
my @res = $db->resultset('Page')->search( { siteid => $site->id } ); |
|
163
|
|
|
|
|
|
|
|
|
164
|
|
|
|
|
|
|
# lastmode => YYYY-MM-DD |
|
165
|
|
|
|
|
|
|
# changefreq |
|
166
|
|
|
|
|
|
|
# priority |
|
167
|
|
|
|
|
|
|
my $host = request->uri_base; |
|
168
|
|
|
|
|
|
|
|
|
169
|
|
|
|
|
|
|
my $xml = qq(\n); |
|
170
|
|
|
|
|
|
|
foreach my $r (@res) { |
|
171
|
|
|
|
|
|
|
$xml .= qq( \n); |
|
172
|
|
|
|
|
|
|
$xml .= qq( $host) . $r->filename . qq(\n); |
|
173
|
|
|
|
|
|
|
$xml .= qq( \n); |
|
174
|
|
|
|
|
|
|
} |
|
175
|
|
|
|
|
|
|
$xml .= qq(); |
|
176
|
|
|
|
|
|
|
|
|
177
|
|
|
|
|
|
|
content_type "text/xml"; |
|
178
|
|
|
|
|
|
|
return $xml; |
|
179
|
|
|
|
|
|
|
}; |
|
180
|
|
|
|
|
|
|
|
|
181
|
|
|
|
|
|
|
get qr{^/([a-zA-Z0-9][\w .\$@%-]*)?$} => \&route_index; |
|
182
|
|
|
|
|
|
|
|
|
183
|
|
|
|
|
|
|
# TODO plan: |
|
184
|
|
|
|
|
|
|
# when a pages is marked as a "poll" there are going to be two parts of it |
|
185
|
|
|
|
|
|
|
# one is a json file describing the actual poll |
|
186
|
|
|
|
|
|
|
# the other is the content of the page in the database that will be shown upon posting the poll |
|
187
|
|
|
|
|
|
|
# actually this probbaly should be shown only if we get a parmater in the get request. |
|
188
|
|
|
|
|
|
|
# and the whole thing will be replaced by the result page once the poll is closed. |
|
189
|
|
|
|
|
|
|
post '/poll' => sub { |
|
190
|
|
|
|
|
|
|
my $id = params->{id}; |
|
191
|
|
|
|
|
|
|
return Dwimmer::Admin::render_response( 'error', { invalid_poll_id => $id } ) |
|
192
|
|
|
|
|
|
|
if $id !~ /^[\w-]+$/; |
|
193
|
|
|
|
|
|
|
|
|
194
|
|
|
|
|
|
|
my $json_file = path( config->{appdir}, 'polls', "$id.json" ); |
|
195
|
|
|
|
|
|
|
return Dwimmer::Admin::render_response( 'error', { poll_not_found => $id } ) |
|
196
|
|
|
|
|
|
|
if not -e $json_file; |
|
197
|
|
|
|
|
|
|
|
|
198
|
|
|
|
|
|
|
my $log_file = path( config->{appdir}, 'polls', "$id.txt" ); |
|
199
|
|
|
|
|
|
|
my %data = params(); |
|
200
|
|
|
|
|
|
|
$data{IP} = request->address; |
|
201
|
|
|
|
|
|
|
$data{TS} = time; |
|
202
|
|
|
|
|
|
|
$data{SID} = session->id; |
|
203
|
|
|
|
|
|
|
if ( open my $fh, '>>', $log_file ) { |
|
204
|
|
|
|
|
|
|
flock( $fh, LOCK_EX ); |
|
205
|
|
|
|
|
|
|
print $fh to_json( \%data ), "\n"; |
|
206
|
|
|
|
|
|
|
close $fh; |
|
207
|
|
|
|
|
|
|
} |
|
208
|
|
|
|
|
|
|
redirect request->uri_base . "/$id?submitted=1"; |
|
209
|
|
|
|
|
|
|
}; |
|
210
|
|
|
|
|
|
|
|
|
211
|
|
|
|
|
|
|
sub _poll { |
|
212
|
|
|
|
|
|
|
my ($action) = @_; |
|
213
|
|
|
|
|
|
|
if ( $action !~ m{^[\w-]+$} ) { |
|
214
|
|
|
|
|
|
|
return qq{Invalid poll name "$action"}; |
|
215
|
|
|
|
|
|
|
} |
|
216
|
|
|
|
|
|
|
my $json_file = path( config->{appdir}, 'polls', "$action.json" ); |
|
217
|
|
|
|
|
|
|
|
|
218
|
|
|
|
|
|
|
if ( not -e $json_file ) { |
|
219
|
|
|
|
|
|
|
debug("File '$json_file' not found"); |
|
220
|
|
|
|
|
|
|
return "Poll Not found"; |
|
221
|
|
|
|
|
|
|
} |
|
222
|
|
|
|
|
|
|
my $data = eval { from_json scalar read_file $json_file }; |
|
223
|
|
|
|
|
|
|
if ($@) { |
|
224
|
|
|
|
|
|
|
debug("Could not read json file '$json_file': $@"); |
|
225
|
|
|
|
|
|
|
return "Could not read poll data"; |
|
226
|
|
|
|
|
|
|
} |
|
227
|
|
|
|
|
|
|
|
|
228
|
|
|
|
|
|
|
my $html; |
|
229
|
|
|
|
|
|
|
open my $out, '>', \$html or die; |
|
230
|
|
|
|
|
|
|
my $t = Template->new( |
|
231
|
|
|
|
|
|
|
ABSOLUTE => 1, |
|
232
|
|
|
|
|
|
|
|
|
233
|
|
|
|
|
|
|
# encoding: 'utf8' |
|
234
|
|
|
|
|
|
|
START_TAG => '<%', |
|
235
|
|
|
|
|
|
|
END_TAG => '%>', |
|
236
|
|
|
|
|
|
|
); |
|
237
|
|
|
|
|
|
|
|
|
238
|
|
|
|
|
|
|
#return path(config->{appdir}, 'views', 'poll.tt') . -s path(config->{appdir}, 'views', 'poll.tt'); |
|
239
|
|
|
|
|
|
|
$t->process( path( config->{appdir}, 'views', 'poll.tt' ), { poll => $data }, $out ); |
|
240
|
|
|
|
|
|
|
|
|
241
|
|
|
|
|
|
|
#use Capture::Tiny qw(); |
|
242
|
|
|
|
|
|
|
#my ($out, $err) = Capture::Tiny::capture { $t->process(path(config->{appdir}, 'views', 'poll.tt'), {poll => $data}) }; |
|
243
|
|
|
|
|
|
|
close $out; |
|
244
|
|
|
|
|
|
|
return $html; |
|
245
|
|
|
|
|
|
|
} |
|
246
|
|
|
|
|
|
|
|
|
247
|
|
|
|
|
|
|
sub _process { |
|
248
|
|
|
|
|
|
|
my ( $scheme, $action ) = @_; |
|
249
|
|
|
|
|
|
|
if ( $scheme eq 'http' or $scheme eq 'https' ) { |
|
250
|
|
|
|
|
|
|
return qq{$action}; |
|
251
|
|
|
|
|
|
|
} |
|
252
|
|
|
|
|
|
|
|
|
253
|
|
|
|
|
|
|
|
|
254
|
|
|
|
|
|
|
return qq{Unknown scheme: "$scheme"}; |
|
255
|
|
|
|
|
|
|
} |
|
256
|
|
|
|
|
|
|
|
|
257
|
|
|
|
|
|
|
true; |
|
258
|
|
|
|
|
|
|
|
|
259
|
|
|
|
|
|
|
=head1 NAME |
|
260
|
|
|
|
|
|
|
|
|
261
|
|
|
|
|
|
|
Dwimmer - A platform to develop things |
|
262
|
|
|
|
|
|
|
|
|
263
|
|
|
|
|
|
|
=head1 COPYRIGHT |
|
264
|
|
|
|
|
|
|
|
|
265
|
|
|
|
|
|
|
(c) 2011 Gabor Szabo |
|
266
|
|
|
|
|
|
|
|
|
267
|
|
|
|
|
|
|
=head1 LICENSE |
|
268
|
|
|
|
|
|
|
|
|
269
|
|
|
|
|
|
|
This program is free software; you can redistribute it and/or |
|
270
|
|
|
|
|
|
|
modify it under the same terms as Perl 5 itself. |
|
271
|
|
|
|
|
|
|
|
|
272
|
|
|
|
|
|
|
=cut |
|
273
|
|
|
|
|
|
|
|
|
274
|
|
|
|
|
|
|
# Copyright 2011 Gabor Szabo |
|
275
|
|
|
|
|
|
|
# LICENSE |
|
276
|
|
|
|
|
|
|
# This program is free software; you can redistribute it and/or |
|
277
|
|
|
|
|
|
|
# modify it under the same terms as Perl 5 itself. |
|
278
|
|
|
|
|
|
|
|