1 use DBIx::Class::Optional::Dependencies -skip_all_without => 'cdbicompat';
7 use lib 't/cdbi/testlib';
10 #-----------------------------------------------------------------------
11 # Make sure that we can set up columns properly
12 #-----------------------------------------------------------------------
15 use base 'DBIC::Test::SQLite';
17 State->table('State');
18 State->columns(Essential => qw/Abbreviation Name/);
19 State->columns(Primary => 'Name');
20 State->columns(Weather => qw/Rain Snowfall/);
21 State->columns(Other => qw/Capital Population/);
22 #State->has_many(cities => "City");
24 sub accessor_name_for {
25 my ($class, $column) = @_;
26 my $return = $column eq "Rain" ? "Rainfall" : $column;
30 sub mutator_name_for {
31 my ($class, $column) = @_;
32 my $return = $column eq "Rain" ? "set_Rainfall" : "set_$column";
41 use base 'DBIC::Test::SQLite';
44 City->columns(All => qw/Name State Population/);
47 # Disable the `no such table' warning
48 local $SIG{__WARN__} = sub {
50 warn $warning unless ($warning =~ /\Qno such table: City(1)\E/);
53 City->has_a(State => 'State');
56 #-------------------------------------------------------------------------
58 use base 'DBIC::Test::SQLite';
61 CD->columns('All' => qw/artist title length/);
63 #-------------------------------------------------------------------------
67 is(State->table, 'State', 'State table()');
68 is(State->primary_column, 'name', 'State primary()');
69 is_deeply [ State->columns('Primary') ] => [qw/name/],
70 'State Primary:' . join ", ", State->columns('Primary');
71 is_deeply [ sort State->columns('Essential') ] => [qw/abbreviation name/],
72 'State Essential:' . join ", ", State->columns('Essential');
73 is_deeply [ sort State->columns('All') ] =>
74 [ sort qw/name abbreviation rain snowfall capital population/ ],
75 'State All:' . join ", ", State->columns('All');
77 is(CD->primary_column, 'artist', 'CD primary()');
78 is_deeply [ CD->columns('Primary') ] => [qw/artist/],
79 'CD primary:' . join ", ", CD->columns('Primary');
80 is_deeply [ sort CD->columns('All') ] => [qw/artist length title/],
81 'CD all:' . join ", ", CD->columns('All');
82 is_deeply [ sort CD->columns('Essential') ] => [qw/artist/],
83 'CD essential:' . join ", ", CD->columns('Essential');
85 ok(State->find_column('Rain'), 'find_column Rain');
86 ok(State->find_column('rain'), 'find_column rain');
87 ok(!State->find_column('HGLAGAGlAG'), '!find_column HGLAGAGlAG');
91 can_ok +State => qw/Rainfall _Rainfall_accessor set_Rainfall
92 _set_Rainfall_accessor Snowfall _Snowfall_accessor set_Snowfall
93 _set_Snowfall_accessor/;
95 foreach my $method (qw/Rain _Rain_accessor rain snowfall/) {
96 ok !State->can($method), "State can't $method";
103 local $TODO = "No column objects";
105 eval { my @grps = State->__grouper->groups_for("Huh"); };
106 ok $@, "Huh not in groups";
109 my @grps = sort State->__grouper->groups_for(State->_find_columns(qw/rain capital/));
110 is @grps, 2, "Rain and Capital = 2 groups";
111 @grps = sort @grps; # Because the underlying API is hash-based
112 is $grps[0], 'Other', " - Other";
113 is $grps[1], 'Weather', " - Weather";
119 # @DieTest::ISA = qw(DBIx::Class);
120 # DieTest->load_components(qw/CDBICompat::Retrieve Core/);
122 # local $SIG{__WARN__} = sub { };
123 # eval { DieTest->retrieve(1) };
124 # like $@, qr/unless primary columns are defined/, "Need primary key for retrieve";
127 #-----------------------------------------------------------------------
128 # Make sure that columns inherit properly
129 #-----------------------------------------------------------------------
133 @A::ISA = qw(DBIx::Class);
134 __PACKAGE__->load_components(qw/CDBICompat Core/);
135 __PACKAGE__->table('dummy');
136 __PACKAGE__->columns(Primary => 'id');
140 __PACKAGE__->table('dummy2');
141 __PACKAGE__->columns(All => qw(id b1));
145 __PACKAGE__->table('dummy3');
146 __PACKAGE__->columns(All => qw(id c1 c2 c3));
149 is join (' ', sort A->columns), 'id', "A columns";
150 is join (' ', sort A::B->columns), 'b1 id', "A::B columns";
151 is join (' ', sort A::C->columns), 'c1 c2 c3 id', "A::C columns";