ok(my $schema = DBICTest->init_schema(), 'got schema');
{
- my $artist_rs = $schema->resultset('Artist')->order_by(col => 'artistid')->display();
+ my $artist_rs = $schema->resultset('Artist')->search({}, { order_by => 'artistid' })->display();
is_deeply($artist_rs, [
{
'artistid' => '1',
}
{
- my $artists = $schema->resultset('Artist')->order_by(col => 'artistid')->with_substr->display();
+ my $artists = $schema->resultset('Artist')->search({}, { order_by => 'artistid' })->with_substr->display();
is_deeply($artists, [
{
'artistid' => '1',
], 'display with substring okay');
}
+# {
+# my $artists = $schema->resultset('Artist')->search({}, { order_by => 'artistid' })->with_substr_old->display();
+# is_deeply($artists, [
+# {
+# 'artistid' => '1',
+# 'name' => 'Caterwauler McCrae',
+# 'substr' => 'Cat'
+# },
+# {
+# 'artistid' => '2',
+# 'name' => 'Random Boy Band',
+# 'substr' => 'Ran'
+# },
+# {
+# 'artistid' => '3',
+# 'name' => 'We Are Goth',
+# 'substr' => 'We '
+# }
+# ], 'display with substring okay');
+# }
+
{
- my $artists = $schema->resultset('Artist')->order_by(col => 'artistid')->with_substr->search({}, { prefetch => 'cds', rows => 1 })->display();
+ my $artists = $schema->resultset('Artist')->search({}, { order_by => 'artistid' })->with_substr->search({}, { prefetch => 'cds', rows => 1 })->display();
is_deeply($artists, [
{
'artistid' => 1,