diff options
| author | Matthew Somerville <matthew-github@dracos.co.uk> | 2018-11-20 16:40:53 +0000 |
|---|---|---|
| committer | Matthew Somerville <matthew-github@dracos.co.uk> | 2018-11-26 12:49:23 +0000 |
| commit | eb2aba46eabc8d90656b760cf4900f56119de9ca (patch) | |
| tree | afdf23b1a49424aa0c46019f8354f46b778dcf5c /perllib/FixMyStreet/DB/Result/Problem.pm | |
| parent | d04d807989eaedb1bd46d08bf80e1b42ed7800ae (diff) | |
Store all moderation change history in database.
Currently keeping the same front end functionality of only reverting to
the original.
Diffstat (limited to 'perllib/FixMyStreet/DB/Result/Problem.pm')
| -rw-r--r-- | perllib/FixMyStreet/DB/Result/Problem.pm | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/perllib/FixMyStreet/DB/Result/Problem.pm b/perllib/FixMyStreet/DB/Result/Problem.pm index 0b8bc4de0..ffc6aba93 100644 --- a/perllib/FixMyStreet/DB/Result/Problem.pm +++ b/perllib/FixMyStreet/DB/Result/Problem.pm @@ -177,11 +177,15 @@ __PACKAGE__->has_one( { cascade_copy => 0, cascade_delete => 0 }, ); +# This will return the oldest moderation_original_data, if any. +# The plural can be used to return all entries. __PACKAGE__->might_have( "moderation_original_data", "FixMyStreet::DB::Result::ModerationOriginalData", { "foreign.problem_id" => "self.id" }, { where => { 'comment_id' => undef }, + order_by => 'id', + rows => 1, cascade_copy => 0, cascade_delete => 1 }, ); |