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	#!/usr/bin/env perl
2	use warnings;
3	use strict;
4
5	use blib;
6
7	=head1 DESCRIPTION
8
9	A basic test harness for the Database model.
10
11	=cut
12
13	use Jifty::Test tests => 11;
14
15	my $b = 2; # number of bootstrap records
16
17	# 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	my ($id) = $o->create(
27	name => 'foo',
28	dsn => 'bar',
29	);
30	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	$o->create(
36	name => 'baz',
37	dsn => 'baz',
38	);
39	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	is($collection->count, $b + 2, "Finds two records");
46
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	is($collection->count, $b + 1, "Still one left");
59