liquid_feedback_frontend
annotate model/snapshot.lua @ 1852:e593570a23c5
More efficient algorithm
| author | bsw |
|---|---|
| date | Tue Mar 22 10:35:44 2022 +0100 (2022-03-22) |
| parents | c5c18a861b85 |
| children |
| rev | line source |
|---|---|
| bsw@1629 | 1 Snapshot = mondelefant.new_class() |
| bsw@1629 | 2 Snapshot.table = 'snapshot' |
| bsw@1629 | 3 Snapshot.primary_key = "id" |
| bsw@1629 | 4 |
| bsw@1629 | 5 function Snapshot:latest_by_issue_id(issue_id) |
| bsw@1629 | 6 return self:new_selector() |
| bsw@1629 | 7 :add_where{ "issue_id = ?", issue_id } |
| bsw@1629 | 8 :add_order_by("id DESC") |
| bsw@1629 | 9 :limit(1) |
| bsw@1629 | 10 :optional_object_mode() |
| bsw@1629 | 11 :exec() |
| bsw@1629 | 12 end |