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
53
54
55
56
57
58
59
60
61
62
63
64
65
|
#!/usr/bin/perl -w
# Example of an EekBoek application.
# Author : Johan Vromans
# Created On : Sun Apr 13 17:25:07 2008
# Last Modified By: Johan Vromans
# Last Modified On: Wed Jan 23 13:31:52 2013
# Update Count : 97
# Status : Unknown, Use with caution!
################ Common stuff ################
use strict;
use warnings;
# EekBoek modules.
use EekBoek; # optional (but we'll use $PACKAGE)
use EB; # common
################ Presets ################
binmode( STDOUT, ':encoding(utf-8)' );
################ The Process ################
#### W A R N I N G #### W A R N I N G #### W A R N I N G #####
#
# Querying the database may give unexpected results except for
# trivial things like names of customers, grootboekrekeningen.
#
################ ################ ################ ###########
# Initialise.
# The app name passed will be used for the config files,
# e.g., Foo -> /etc/foo.conf, ~/.foo/foo.conf, ./.foo.conf
# By using $EekBoek::PACKAGE we'll use the standard EekBoek
# config files.
my $eb = EB->app_init( { app => $EekBoek::PACKAGE,
config => "eekboek.conf", # local
} );
# Connect to the data base.
# Returns the database handle.
# NOTE: This is not a DBI object!
my $dbh = $eb->connect_db;
# SQL query.
my $sql =
"SELECT acc_id, acc_desc, acc_balres".
" FROM Accounts".
" ORDER BY acc_id";
# Parse SQL and execute.
my $sth = $dbh->sql_exec($sql);
# Bind result columns.
$sth->bind_columns(\my($acc_id, $acc_desc, $acc_balans));
# Fetch results.
while ( $sth->fetch ) {
# Print balansrekeningen.
printf("%5d %s\n", $acc_id, $acc_desc) if $acc_balans;
}
|
