summaryrefslogtreecommitdiff
path: root/regress/mysql/getline.pl
blob: 50d1525879118898c4fd7b42534968e8518324ff (plain)
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/pkg/bin/perl
#
# $Id$
#

use strict;
use Carp;
use IO::MapAdapter;

my $map = 'mysql:toymodel';


my $map_params = {
    $map => {
	sql_server    => 'localhost',
	user          => 'fukachan',
	user_password => 'uja',
	database      => 'fml',
	table         => 'ml',
	params        => {
	    ml_name   => 'elena',
	    file      => 'members',
	},
    },
};


my $obj = new IO::MapAdapter ($map, $map_params);

_dump($obj); print "\n";

$obj->open();
$obj->add( 'rudo@nuinui.net' );
$obj->close();

_dump($obj); print "\n";

$obj->open();
$obj->delete( 'rudo@nuinui.net' );
$obj->close();

_dump($obj); print "\n";

exit 0;


sub _dump
{
    my ($obj) = @_;

    if (defined $obj) {
	if (defined $obj->open()) {
	    while ($_ = $obj->getline()) {
		print $_, "\n";
	    }
	    $obj->close;
	}
	else {
	    croak("cannot open()");
	}
    }
    else {
	croak("cannot make object");
    }
}