1. show one current record: ``` CurrentRecord.objects.filter( environment=Environment.objects.get(name='foo-dev'), key=Key.objects.get(name='Ursula'), ).select_related() 2. show env current records: ``` CurrentRecord.objects.filter( environment=Environment.objects.get(name='foo-dev'), ).select_related() 3. show key across all envs: ``` CurrentRecord.objects.filter( key=Key.objects.get(name='Ursula'), ).select_related()``` 4. create/update current record: `CurrentRecord.objects.update_or_create(environment=rec.environment, key=rec.key, record=rec)` 5. show entry usage: ``` CurrentRecord.objects.filter(record__entry__in=[Entry.objects.get(id=205)]) CurrentRecord.objects.filter(record__entry__id__in=[205]) 6. show record history ```Record.objects.filter( environment=Environment.objects.get(name='foo-dev'), key=Key.objects.get(name='Ursula'), approved=True, used=True, ).select_related() 7. show record candidates: ``` Record.objects.filter( environment=Environment.objects.get(name='foo-dev'), key=Key.objects.get(name='Ursula'), declined=False, used=False, ).select_related() 8. show env candidates ``` Record.objects.filter( environment=Environment.objects.get(name='foo-dev'), declined=False, used=False, ).select_related() 9. show all candidates ``` Record.objects.filter( environment=Environment.objects.get(name='foo-dev'), declined=False, used=False, ).select_related() 10. show entry historical usage: ``` Record.objects.filter(entry__in=[Entry.objects.get(id=205)]) Record.objects.filter(entry__id__in=[205]) * show user permitted records 11. count approvals `RecordApproval.objects.filter(record=Record.objects.get(id=123)).count()` 12. show approvals `RecordApproval.objects.filter(record=Record.objects.get(id=123)).select_related()` 13. approve a candidate ``` RecordApproval( record=Record.objects.get(id=123), reviewer=user, ).save() 14. disapprove a candidate ``` RecordApproval( record=Record.objects.get(id=123), reviewer=user, approved=False, ).save() 15. show created by a user 16. show approved by a user 17. create env (inluding user owner or group owner, creator != owner, creator not null) 18. de/activate env? (unique na name-active=true?) 19. clone env 20. current record - history * ficzer - keys ---- 21. show envs by owner 22. show records by owner