grahamc/hydra - Change 34O5UJ63CP5D5F2GP7HYN77UVEMLP2GR2G7VUZ4DK6SS5HUPB2AQC

Remove unnecessary join against releases table

This gets rid of the warning:

DBIx::Class::Storage::DBI::select_single(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /home/eelco/Dev/hydra/src/script/../lib/Hydra/Controller/Project.pm line 15

Created by Eelco Dolstra on May 1, 2014

34O5UJ63CP5D5F2GP7HYN77UVEMLP2GR2G7VUZ4DK6SS5HUPB2AQC

Dependencies

[2] 7ECJWNVXNO3BKM7B7FIFIRBE77QET5PK2C3XKVQUXCYKHDP3V4UQC
[3] 3PNG7NIBQQURUUPRVQXYL342OT7JUUYOMY2JJNP6YDX7SYJDZMYAC
[4] FPK5LF53CFUEKFYJ3IYXT4UTVC6IITWJOCFATMC4PLHEUP5SIEAAC

In channels

main

upstream

Change contents

Replacement in src/lib/Hydra/Controller/Project.pm at line 15 [4.1245]

B:BD[3.2215] → [2.0:170]

    $c->stash->{project} = $c->model('DB::Projects')->find($projectName, {
        join => [ 'releases' ],
        order_by => { -desc => "releases.timestamp" },
    });

[3.2215]

[4.1712]

    $c->stash->{project} = $c->model('DB::Projects')->find($projectName);