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/go.mod b/go.mod
index fb6a573..c495e61 100644
--- a/go.mod
+++ b/go.mod
@@ -12,11 +12,23 @@
require (
github.com/cenkalti/backoff v2.2.1+incompatible // indirect
- github.com/davecgh/go-spew v1.1.0
+ github.com/davecgh/go-spew v1.1.1
github.com/google/go-querystring v1.1.0 // indirect
- golang.org/x/net v0.0.0-20200822124328-c89045814202 // indirect
- golang.org/x/sys v0.0.0-20200323222414-85ca7c5b95cd // indirect
- golang.org/x/text v0.3.0 // indirect
+ github.com/jackc/pgx v3.6.2+incompatible
+ github.com/phst/runfiles v0.0.0-20220125203201-388095b3a22d
+ golang.org/x/net v0.0.0-20210226172049-e18ecbb05110 // indirect
+ golang.org/x/sys v0.0.0-20210615035016-665e8c7367d1 // indirect
+ golang.org/x/text v0.3.6 // indirect
google.golang.org/genproto v0.0.0-20200526211855-cb27e3aa2013 // indirect
google.golang.org/protobuf v1.26.0 // indirect
)
+
+require (
+ github.com/cockroachdb/apd v1.1.0 // indirect
+ github.com/gofrs/uuid v4.0.0+incompatible // indirect
+ github.com/jackc/fake v0.0.0-20150926172116-812a484cc733 // indirect
+ github.com/lib/pq v1.10.2 // indirect
+ github.com/pkg/errors v0.8.1 // indirect
+ github.com/shopspring/decimal v1.2.0 // indirect
+ golang.org/x/crypto v0.0.0-20210711020723-a769d52b0f97 // indirect
+)