1 BEGIN { do "./t/lib/ANFANG.pm" or die ( $@ || $! ) }
9 my $schema = DBICTest->init_schema();
11 my $rs = $schema->resultset ('CD')->search ({}, {
13 { substr => [ 'title', 1, 1 ], -as => 'initial' },
16 as => [qw/title_initial cnt/],
17 group_by => ['initial'],
18 order_by => { -desc => 'initial' },
19 result_class => 'DBIx::Class::ResultClass::HashRefInflator',
25 { title_initial => 'S', cnt => '1' },
26 { title_initial => 'G', cnt => '1' },
27 { title_initial => 'F', cnt => '1' },
28 { title_initial => 'C', cnt => '2' },
33 is ($rs->count, 4, 'Correct count');