Migrate the scouting database to postgres
The existing database is sqlite3. That is not usable by Tableau which
is the visualization tool we use. Tableau also appears incapable of
scraping, say, JSON from our scouting app.
This patch migrates our application to use postgres instead of
sqlite3. That database will be accessible by Tableau.
I created a `testdb_server` application that sets up postgres in the
linux-sandbox in a bazel test. This is useful in the various tests
that we run on the scouting application.
Signed-off-by: Philipp Schrader <philipp.schrader@gmail.com>
Change-Id: I9cd260f8998b9607e1e3229ab70f243cdded5ec5
diff --git a/scouting/webserver/requests/requests.go b/scouting/webserver/requests/requests.go
index 6c4bdd1..245891a 100644
--- a/scouting/webserver/requests/requests.go
+++ b/scouting/webserver/requests/requests.go
@@ -372,7 +372,7 @@
return
}
// Add the match to the database.
- handler.db.AddToMatch(db.Match{
+ err = handler.db.AddToMatch(db.Match{
MatchNumber: int32(match.MatchNumber),
// TODO(phil): What does Round mean?
Round: 1,
@@ -384,6 +384,11 @@
B2: blue[1],
B3: blue[2],
})
+ if err != nil {
+ respondWithError(w, http.StatusInternalServerError, fmt.Sprintf(
+ "Failed to add match %d to the database: %v", match.MatchNumber, err))
+ return
+ }
}
var response RefreshMatchListResponseT