static/talks/bread_board_yapc_na_2012/003.pl.html


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52

<html>
<head>
<title>003.pl</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<script>
function navigate(e) {
    var keynum = (window.event) // IE
        ? e.keyCode
        : e.which;
    if (keynum == 8) {
        window.location = "002" + ".html";
        return false;
    }
    if (keynum == 13 || keynum == 32) {
        window.location = "004.pl" + ".html";
        return false;
    }
    if (keynum == 73 || keynum == 105) {
        window.location = "index.html";
        return false;
    }
    return true;
}
</script>
</head>
<body onkeypress="return navigate(event)">
<pre>


package MyApp;
use MyFramework;

sub call {
    my $self = shift;

    my $dbh = DBI-&gt;connect('dbi:mysql:myapp_db');
    my $hello = $dbh-&gt;selectall_arrayref('SELECT * FROM my_table')-&gt;[0][0];

    my $template = Template-&gt;new(INCLUDE_PATH =&gt; 'root/template');
    $template-&gt;process('hello.tt', { hello =&gt; $hello }, \(my $output));

    return $output;
}


</pre>
</body>