Add code to load bug categories and patterns from the FindBugs messages.xml file.

[cfb.git] / prod / net / jaekl / cfb / db / CfbSchema.java

diff --git a/prod/net/jaekl/cfb/db/CfbSchema.java b/prod/net/jaekl/cfb/db/CfbSchema.java
index b298f5768c9f1f9cad6ac460c4bc69d9d1f78f21..e214b1bc59172dda99363b7b4865266dce20ec74 100644 (file)
--- a/prod/net/jaekl/cfb/db/CfbSchema.java
+++ b/prod/net/jaekl/cfb/db/CfbSchema.java
@@ -1,5 +1,7 @@
 package net.jaekl.cfb.db;
 
+// Copyright (C) 2015 Christian Jaekl
+
 import static net.jaekl.cfb.db.Column.Null.*;
 import static net.jaekl.cfb.db.Column.Type.*;
 import net.jaekl.cfb.db.driver.DbDriver;
@@ -13,21 +15,19 @@ public class CfbSchema extends Schema {
        // }
        private static final Object[][][] TABLES = {
                {
-                       { "BUGS" },
+                       // Description of each possible bug
+                       { "BUG" },
                        { "BUGID", INTEGER, -1, NOT_NULL },
-                       { "TYPE", VARCHAR, 80, NOT_NULL },
-                       { "SHORTDESCR", VARCHAR, 128, NOT_NULL },
-                       { "LONGDESCR", VARCHAR, 128, NOT_NULL },
-                       { "DETAILS", VARCHAR, 4096, NOT_NULL }
+                       { "TYPE", VARCHAR, 80, NOT_NULL }
                },
                {
-                       { "CATEGORIES" },
+                       // Description of each possible bug category
+                       { "CATEGORY" },
                        { "CATEGORYID", INTEGER, -1, NOT_NULL },
-                       { "DESCRIPTION", VARCHAR, 128, NOT_NULL },
-                       { "ABBREVIATION", CHAR, 1, NOT_NULL },
-                       { "DETAILS", VARCHAR, 4096, NOT_NULL }
+                       { "CATEGORY", VARCHAR, 80, NOT_NULL }
                },
                { 
+                       // One BugInstance, found during an analysis
                        { "FOUND" },
                        { "FOUNDID", INTEGER, -1, NOT_NULL },
                        { "BUGID", INTEGER, -1, NOT_NULL },
@@ -37,6 +37,7 @@ public class CfbSchema extends Schema {
                        { "THIRDLOCID", INTEGER, -1, NULL }
                },
                {
+                       // Location in the source code referenced by a BugInstance
                        { "LOCATION" },
                        { "LOCID", INTEGER, -1, NOT_NULL },
                        { "CLASSNAME", VARCHAR, 256, NOT_NULL },
@@ -45,11 +46,11 @@ public class CfbSchema extends Schema {
                },
                {
                        // Runs of FindBugs, normally one per build version
-                       { "RUNS " },
+                       { "RUN" },
                        { "RUNID", INTEGER, -1, NOT_NULL },
                        { "VERSION", VARCHAR, 32, NULL },
-                       { "START", TIMESTAMPTZ, -1, NOT_NULL },
-                       { "END", TIMESTAMPTZ, -1, NOT_NULL }
+                       { "STARTTIME", TIMESTAMPTZ, -1, NOT_NULL },
+                       { "ENDTIME", TIMESTAMPTZ, -1, NOT_NULL }
                }
        };