swish-e/prog-bin/MySQL.pl

#!/usr/local/bin/perl -w
use strict;

=pod

    This is an example program to index data stored in a MySQL database.

    In this example, a table is read that contains "minutes" from some
    organization's meetings.  The text of the minutes was stored in a
    blob, compressed with zlib.

    This script reads the record from MySQL, uncompresses the text, and
    formats for swish-e.  The example below uses HTML, but you could
    also format at XML, or even plain text.

=cut    


use DBI;
use Compress::Zlib;
use Time::Local;

my %database = {
        dsn      => 'dbi:mysql:test',
        user     => 'user',
        password => 'pass',
};

my $dbh = DBI->connect( @database{qw/ dsn user password /}, { RaiseError => 1 } );

my $sth = $dbh->prepare("select id, date, minutes from meetings");

$sth->execute();

while ( my( $id, $date, $minutes) = $sth->fetchrow_array ) {

    my $uncompressed = uncompress( $minutes );

    my $unix_date = unixtime( $date );
    

    my $content = <<EOF;
<html>
<head>
<title>
    Minutes for meeting on date $date
</title>
</head>
<body>
$uncompressed
</body>
</html>
EOF

    my $length = length $content;

    
    print <<EOF;
Content-Length: $length
Last-Mtime: $unix_date
Path-Name: /minutes/index.cgi?id=$id
Document-Type: HTML

EOF
    print $content;

}

sub unixtime {
        my ( $y, $m, $d ) = split /-/, shift;
        return timelocal(0,0,0,$d,$m-1,$y-1900);
    };

1	#!/usr/local/bin/perl -w
2	use strict;
3
4	=pod
5
6	This is an example program to index data stored in a MySQL database.
7
8	In this example, a table is read that contains "minutes" from some
9	organization's meetings. The text of the minutes was stored in a
10	blob, compressed with zlib.
11
12	This script reads the record from MySQL, uncompresses the text, and
13	formats for swish-e. The example below uses HTML, but you could
14	also format at XML, or even plain text.
15
16	=cut
17
18
19	use DBI;
20	use Compress::Zlib;
21	use Time::Local;
22
23	my %database = {
24	dsn => 'dbi:mysql:test',
25	user => 'user',
26	password => 'pass',
27	};
28
29	my $dbh = DBI->connect( @database{qw/ dsn user password /}, { RaiseError => 1 } );
30
31	my $sth = $dbh->prepare("select id, date, minutes from meetings");
32
33	$sth->execute();
34
35	while ( my( $id, $date, $minutes) = $sth->fetchrow_array ) {
36
37	my $uncompressed = uncompress( $minutes );
38
39	my $unix_date = unixtime( $date );
40
41
42	my $content = <<EOF;
43	<html>
44	<head>
45	<title>
46	Minutes for meeting on date $date
47	</title>
48	</head>
49	<body>
50	$uncompressed
51	</body>
52	</html>
53	EOF
54
55	my $length = length $content;
56
57
58
59	print <<EOF;
60	Content-Length: $length
61	Last-Mtime: $unix_date
62	Path-Name: /minutes/index.cgi?id=$id
63	Document-Type: HTML
64
65	EOF
66	print $content;
67
68	}
69
70	sub unixtime {
71	my ( $y, $m, $d ) = split /-/, shift;
72	return timelocal(0,0,0,$d,$m-1,$y-1900);
73	};
74