Add created_date and updated_date fields to all tables
Bug #815313 reported by
Barry van Oudtshoorn
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenLP |
Fix Released
|
Low
|
Tim Bentley |
Bug Description
I was just asked to produce a report showing which songs have been added to OpenLP in the past six months. Unfortunately, however, there's no easy way to do this, as the data simply isn't available in the database. What I would propose is the addition of two fields to most (all?) tables in the "songs" db, to track the timestamps for insertion and last update.
Yes, there is the "songusage" database, but that solves a slightly different problem, although admittedly with some cross-over. (I was able to get useful data out of it to satisfy the request.)
Related branches
lp:~trb143/openlp/bug-815313
- Raoul Snyman: Approve
-
Diff: 70 lines (+20/-5)2 files modifiedopenlp/plugins/songs/lib/db.py (+5/-1)
openlp/plugins/songs/lib/upgrade.py (+15/-4)
Changed in openlp: | |
importance: | Undecided → Wishlist |
Changed in openlp: | |
assignee: | nobody → Tim Bentley (trb143) |
milestone: | none → 1.9.7 |
status: | New → In Progress |
Changed in openlp: | |
importance: | Wishlist → Low |
status: | In Progress → Fix Released |
To post a comment you must log in.