trunk/t/00-model-Database.t

#!/usr/bin/env perl
use warnings;
use strict;

use blib;

=head1 DESCRIPTION

A basic test harness for the Database model.

=cut

use Jifty::Test tests => 11;

my $b = 2;      # number of bootstrap records

# Make sure we can load the model
use_ok('SQLSession::Model::Database');

# Grab a system user
my $system_user = SQLSession::CurrentUser->superuser;
ok($system_user, "Found a system user");

# Try testing a create
my $o = SQLSession::Model::Database->new(current_user => $system_user);
my ($id) = $o->create(
        name => 'foo',
        dsn => 'bar',
);
ok($id, "Database create returned success");
ok($o->id, "New Database has valid id set");
is($o->id, $id, "Create returned the right id");

# And another
$o->create(
        name => 'baz',
        dsn => 'baz',
);
ok($o->id, "Database create returned another value");
isnt($o->id, $id, "And it is different from the previous one");

# Searches in general
my $collection =  SQLSession::Model::DatabaseCollection->new(current_user => $system_user);
$collection->unlimit;
is($collection->count, $b + 2, "Finds two records");

# Searches in specific
$collection->limit(column => 'id', value => $o->id);
is($collection->count, 1, "Finds one record with specific id");

# Delete one of them
$o->delete;
$collection->redo_search;
is($collection->count, 0, "Deleted row is gone");

# And the other one is still there
$collection->unlimit;
is($collection->count, $b + 1, "Still one left");

1	dpavlin	1	#!/usr/bin/env perl
2			use warnings;
3			use strict;
4
5	dpavlin	15	use blib;
6
7	dpavlin	1	=head1 DESCRIPTION
8
9			A basic test harness for the Database model.
10
11			=cut
12
13			use Jifty::Test tests => 11;
14
15	dpavlin	15	my $b = 2; # number of bootstrap records
16
17	dpavlin	1	# Make sure we can load the model
18			use_ok('SQLSession::Model::Database');
19
20			# Grab a system user
21			my $system_user = SQLSession::CurrentUser->superuser;
22			ok($system_user, "Found a system user");
23
24			# Try testing a create
25			my $o = SQLSession::Model::Database->new(current_user => $system_user);
26	dpavlin	15	my ($id) = $o->create(
27			name => 'foo',
28			dsn => 'bar',
29			);
30	dpavlin	1	ok($id, "Database create returned success");
31			ok($o->id, "New Database has valid id set");
32			is($o->id, $id, "Create returned the right id");
33
34			# And another
35	dpavlin	15	$o->create(
36			name => 'baz',
37			dsn => 'baz',
38			);
39	dpavlin	1	ok($o->id, "Database create returned another value");
40			isnt($o->id, $id, "And it is different from the previous one");
41
42			# Searches in general
43			my $collection = SQLSession::Model::DatabaseCollection->new(current_user => $system_user);
44			$collection->unlimit;
45	dpavlin	15	is($collection->count, $b + 2, "Finds two records");
46	dpavlin	1
47			# Searches in specific
48			$collection->limit(column => 'id', value => $o->id);
49			is($collection->count, 1, "Finds one record with specific id");
50
51			# Delete one of them
52			$o->delete;
53			$collection->redo_search;
54			is($collection->count, 0, "Deleted row is gone");
55
56			# And the other one is still there
57			$collection->unlimit;
58	dpavlin	15	is($collection->count, $b + 1, "Still one left");
59	dpavlin	1