Add page to check database sanity
Bug #691419 reported by
Paul Harrison
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Canon Lore |
New
|
Low
|
Paul Harrison |
Bug Description
From https:/
"I've been considereing if it might be nice if there were some sql reports
canon could regularly run to check on the database data. eg people with no
listed group.
I think people who belong to closed groups, especiially ones who have
recieved their last award after the group closed would be a useful one.
then again I don't know group closure dates, so maybe just people in closed
groups, with the date of thir last award (or registration once we have a
place for that)"
Check for duplicated names.
Check that foreign keys point to things that exist.
Changed in canonlore: | |
assignee: | nobody → Paul Harrison (paul-francis-harrison) |
importance: | Undecided → Medium |
Changed in canonlore: | |
importance: | Medium → Low |
To post a comment you must log in.
*people with no branch or branch =lochac, not "foreign rulers'
*branches with no parent
*list of dead branchs, list of live branches
*dates with no event
*events with no location
*kingdom reigns with no crown tourney date
*people with no mundane name
*people with awards with no rulers
*people with awards with no date
*awards with no recipients
*people with no awards (and later no award or name registrations)
*knotted sword/wreath valor/wreat chiv by date order
*identical (or very similar) mundane names
STATISTICS
*number of awards given
*number of people listed by kingdom
*number of reigns per kingdom entered
*number of awards entered per kingdom
I said I'd been thinking about it. But the above is fantasy wishlist stuff. I don't seriously expect it to be done, I was just doing a mental exercise thinking about what one might have. And much of it is reports that would be useless right now, but might be useful later when current data adding projects are complete.