Add page to check database sanity

Bug #691419 reported by Paul Harrison
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Canon Lore
New
Low
Paul Harrison

Bug Description

From https://bugs.launchpad.net/bugs/600890 , Teffania writes:

"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
Revision history for this message
Teffania (teffania) wrote :

*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.

Teffania (teffania)
Changed in canonlore:
importance: Medium → Low
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.