Summary
pastiche needs a better database scheme
Metadata
- Id: a7425646be46f661dc850faedcdc48a61fc2346d
- Trac id: 675
- Type: defect
- Reporter: mario
- Owner: ckeen
- Cc:
- Status: closed
- Component: extensions
- Estimated difficulty:
- Resolution: worksforme
- Priority: not urgent at all
- Milestone:
- Version: 4.7.x
- Changetime: 2012-03-11 20:50:21 UTC
- Created: 2011-08-26 16:27:22 UTC
- Keywords: pastiche sqlite db scheme
Description
Currently it is not possible to hand out the correct links for annotation in the "browse pastes" tab.
This is because we do not mark a db entry as being an annotation but this is detected on the fly when displaying all pastes with a certain hash. Annotations are defined to have the same sha1-hash as the original paste but a different timestamp.
So this is easy to do when displaying all entries for one hash and sorting them by timestamp, but this fails when we say "get me the last N additions to the database".
A better db scheme is needed