To Do List

A list of things to do

Must have fail job and record trace in chronology when automagic transitions fail.
NTH shitloads of testing
NTH Add check for maximum depth of a job parent chain to prevent infinite job chains to to the equivalent of recursion of infinite loops in the protocols
NTH Add columns for agency authority to all network edges - default to CoRE
**DONE - Add network attributes to all edges
DONE - Must have Add column on the job that points to the protocol that created it.
DONE - Must have Either protocols should be fired only on job insert or only on specific job status changes, but not every time a job changes status.
DONE - Must have JobChronology.notes should be nullable
DONE - Must have Track every job field in job chronology
DONE (NTH) Force users to log all job changes through JobModel, rather than on the job object directly, or rewrite the triggers
NTH rationalize the SQL error codes returned from the various stored procedures. Right now they suck.
NTH Agency authority column population
(NTH) TestDebuggingUtils
(NTH)Allow use of (Any) in network inference to simplify inductions that traverse any relationships
(NTH)Add case insensitive uniqueness index on attribute.name+type, relationship.name, unit.name
(done) Add a constraint to jobs such that no job can enter into a terminal state until all its children are in a terminal state
(done) Add constraint to ensure that only the initial state of a job can be entered from the unset state.
(NTH) Add constraint that checks to see if a state graph has more than one initial state, and throw an error in that case.
(done) Add a constraint to jobs such that no children can be added to a job that is in a terminal state.
(NTH) Audit what ruleforms should be immutable
Networks (yes)
Jobs (yes) except for status
Inference rules (yes)
Protocols ?
etc.
**(done)**implement the recursive network delete
(done) add pointer to inference rule that generated the inferred edge, also the edge that derived the inference.
(done) use inference rule on edge and the edge where it was inferred from in deletion to ensure inferential integrity.
(NTH)inference rules have to be immutable.
(done) All foreign key columns should be set to ON DELETE CASCADE.
(Hallie) All foreign key columns are NON UPDATEABLE
(Hallie) job.parent points to itself if no parent
(done) (Hallie) get rid of the maven dependency for Pair and use something else
(Hallie) rename Protocol fields so it's more obvious which fields correspond to which jobs
(NTH)Either do something with the ClassifiedAttributeAuth value columns or remove them
(NTH)ClassifiedAttributeAuth validation. Figure out if a particular Existential Ruleform should have a particular attribute based on ClassifiedAttributeAuths
(NTH)Figure out how to restrict the number of edges of a given type coming off a node.