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
66
67
68
69
70
71
72
73
74
75
|
use lib 't';
BEGIN {
# to handle systems with no installed Test module
# we include the t dir (where a copy of Test.pm is located)
# as a fallback
eval { require Test; };
use Test;
use DBStagTest;
plan tests => 2;
}
use DBIx::DBStag;
use DBI;
use Data::Stag;
use FileHandle;
my $ddl = <<EOM
CREATE TABLE person (
person_id serial NOT NULL PRIMARY KEY,
fname varchar(255),
lname varchar(255),
address varchar(255),
UNIQUE (fname, lname)
);
EOM
;
my $data = <<EOM
(personset
(person
(fname "joe")
(lname "bloggs")
(address "1 a street"))
(person
(fname "fred")
(lname "flob")
(address "23 acacia avenue")))
EOM
;
drop(qw(person));
my $dbh = dbh();
#DBI->trace(1);
$dbh->do(cvtddl($ddl));
my $personset = Data::Stag->from('sxprstr', $data);
my @persons = $personset->getnode_person;
foreach (@persons) {
$dbh->storenode($_);
}
our $NEW_ADDRESS = "some new address";
my $rset = $dbh->selectall_stag("SELECT * FROM person WHERE fname = 'joe'",
);
my $joe = $rset->getnode_person;
my $OLD_ADDRESS = $joe->get_address;
$joe->set_address($NEW_ADDRESS);
$dbh->storenode($joe);
$rset = $dbh->selectall_stag("SELECT * FROM person WHERE fname = 'joe'",
);
$joe = $rset->getnode_person;
ok($joe->sget_address eq $NEW_ADDRESS);
$joe->unset_person_id;
$joe->set_address($OLD_ADDRESS);
$dbh->storenode($joe);
$rset = $dbh->selectall_stag("SELECT * FROM person WHERE fname = 'joe'",
);
$joe = $rset->getnode_person;
ok($joe->sget_address eq $OLD_ADDRESS);
$dbh->disconnect;
|
