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/tools/go/go_mirrors.bzl b/tools/go/go_mirrors.bzl
index bfee0a9..e830d81 100644
--- a/tools/go/go_mirrors.bzl
+++ b/tools/go/go_mirrors.bzl
@@ -70,13 +70,20 @@
"strip_prefix": "github.com/cncf/xds/go@v0.0.0-20211011173535-cb28da3451f1",
"version": "v0.0.0-20211011173535-cb28da3451f1",
},
- "com_github_davecgh_go_spew": {
- "filename": "com_github_davecgh_go_spew__v1.1.0.zip",
- "importpath": "github.com/davecgh/go-spew",
- "sha256": "0b5a691aeb8b6af31bd2bb640973ea7e8bf1ed9bc5889da220bf44dc06d9692c",
- "strip_prefix": "github.com/davecgh/go-spew@v1.1.0",
+ "com_github_cockroachdb_apd": {
+ "filename": "com_github_cockroachdb_apd__v1.1.0.zip",
+ "importpath": "github.com/cockroachdb/apd",
+ "sha256": "fef7ec2fae220f84bfacb17fbfc1b04a666ab7f6fc04f3ff6d2b1e05c380777d",
+ "strip_prefix": "github.com/cockroachdb/apd@v1.1.0",
"version": "v1.1.0",
},
+ "com_github_davecgh_go_spew": {
+ "filename": "com_github_davecgh_go_spew__v1.1.1.zip",
+ "importpath": "github.com/davecgh/go-spew",
+ "sha256": "6b44a843951f371b7010c754ecc3cabefe815d5ced1c5b9409fb2d697e8a890d",
+ "strip_prefix": "github.com/davecgh/go-spew@v1.1.1",
+ "version": "v1.1.1",
+ },
"com_github_envoyproxy_go_control_plane": {
"filename": "com_github_envoyproxy_go_control_plane__v0.9.10-0.20210907150352-cf90f659a021.zip",
"importpath": "github.com/envoyproxy/go-control-plane",
@@ -98,6 +105,13 @@
"strip_prefix": "github.com/ghodss/yaml@v1.0.0",
"version": "v1.0.0",
},
+ "com_github_gofrs_uuid": {
+ "filename": "com_github_gofrs_uuid__v4.0.0+incompatible.zip",
+ "importpath": "github.com/gofrs/uuid",
+ "sha256": "8cadafda9aea197d34898d6945692173ac1d8abf3b559c4e5a59a577fc60f55e",
+ "strip_prefix": "github.com/gofrs/uuid@v4.0.0+incompatible",
+ "version": "v4.0.0+incompatible",
+ },
"com_github_golang_glog": {
"filename": "com_github_golang_glog__v0.0.0-20160126235308-23def4e6c14b.zip",
"importpath": "github.com/golang/glog",
@@ -147,6 +161,27 @@
"strip_prefix": "github.com/grpc-ecosystem/grpc-gateway@v1.16.0",
"version": "v1.16.0",
},
+ "com_github_jackc_fake": {
+ "filename": "com_github_jackc_fake__v0.0.0-20150926172116-812a484cc733.zip",
+ "importpath": "github.com/jackc/fake",
+ "sha256": "bf8b5b51ae03f572a70a0582dc663c5733bba9aca785d39bb0367797148e6d64",
+ "strip_prefix": "github.com/jackc/fake@v0.0.0-20150926172116-812a484cc733",
+ "version": "v0.0.0-20150926172116-812a484cc733",
+ },
+ "com_github_jackc_pgx": {
+ "filename": "com_github_jackc_pgx__v3.6.2+incompatible.zip",
+ "importpath": "github.com/jackc/pgx",
+ "sha256": "73675895baa0da97b2f0ce6e895c69b7c77ad994e30ce6a1add2abc3bb17e375",
+ "strip_prefix": "github.com/jackc/pgx@v3.6.2+incompatible",
+ "version": "v3.6.2+incompatible",
+ },
+ "com_github_lib_pq": {
+ "filename": "com_github_lib_pq__v1.10.2.zip",
+ "importpath": "github.com/lib/pq",
+ "sha256": "0f50cfc8d4ed4bbb39767aacc04d6b23e1105d2fa50dcb8e4ae204b2c90018f0",
+ "strip_prefix": "github.com/lib/pq@v1.10.2",
+ "version": "v1.10.2",
+ },
"com_github_mattn_go_sqlite3": {
"filename": "com_github_mattn_go_sqlite3__v1.14.10.zip",
"importpath": "github.com/mattn/go-sqlite3",
@@ -154,6 +189,20 @@
"strip_prefix": "github.com/mattn/go-sqlite3@v1.14.10",
"version": "v1.14.10",
},
+ "com_github_phst_runfiles": {
+ "filename": "com_github_phst_runfiles__v0.0.0-20220125203201-388095b3a22d.zip",
+ "importpath": "github.com/phst/runfiles",
+ "sha256": "f58f97414074227c39abce3f1b4cf8780446630b23f963232458092c126b5541",
+ "strip_prefix": "github.com/phst/runfiles@v0.0.0-20220125203201-388095b3a22d",
+ "version": "v0.0.0-20220125203201-388095b3a22d",
+ },
+ "com_github_pkg_errors": {
+ "filename": "com_github_pkg_errors__v0.8.1.zip",
+ "importpath": "github.com/pkg/errors",
+ "sha256": "4e47d021340b7396a7dee454f527552faf7360a9fc34038b1dc32ba3b5a951d8",
+ "strip_prefix": "github.com/pkg/errors@v0.8.1",
+ "version": "v0.8.1",
+ },
"com_github_pmezard_go_difflib": {
"filename": "com_github_pmezard_go_difflib__v1.0.0.zip",
"importpath": "github.com/pmezard/go-difflib",
@@ -175,6 +224,13 @@
"strip_prefix": "github.com/rogpeppe/fastuuid@v1.2.0",
"version": "v1.2.0",
},
+ "com_github_shopspring_decimal": {
+ "filename": "com_github_shopspring_decimal__v1.2.0.zip",
+ "importpath": "github.com/shopspring/decimal",
+ "sha256": "65c34c248e7f736cadf03a7caa0c0870d15499eb593f933fe106c96c2b7699a7",
+ "strip_prefix": "github.com/shopspring/decimal@v1.2.0",
+ "version": "v1.2.0",
+ },
"com_github_stretchr_objx": {
"filename": "com_github_stretchr_objx__v0.1.0.zip",
"importpath": "github.com/stretchr/objx",
@@ -253,11 +309,11 @@
"version": "v1.26.0",
},
"org_golang_x_crypto": {
- "filename": "org_golang_x_crypto__v0.0.0-20200622213623-75b288015ac9.zip",
+ "filename": "org_golang_x_crypto__v0.0.0-20210711020723-a769d52b0f97.zip",
"importpath": "golang.org/x/crypto",
- "sha256": "aeaac2684d693207a90f491b0303e881e58c014e96d27b0ebb7fe6937dfc1e76",
- "strip_prefix": "golang.org/x/crypto@v0.0.0-20200622213623-75b288015ac9",
- "version": "v0.0.0-20200622213623-75b288015ac9",
+ "sha256": "b2b28fcf49bf385183f0369851145ddd93989f68d9e675db536a3dd482ca6d76",
+ "strip_prefix": "golang.org/x/crypto@v0.0.0-20210711020723-a769d52b0f97",
+ "version": "v0.0.0-20210711020723-a769d52b0f97",
},
"org_golang_x_exp": {
"filename": "org_golang_x_exp__v0.0.0-20190121172915-509febef88a4.zip",
@@ -274,11 +330,11 @@
"version": "v0.0.0-20190313153728-d0100b6bd8b3",
},
"org_golang_x_net": {
- "filename": "org_golang_x_net__v0.0.0-20200822124328-c89045814202.zip",
+ "filename": "org_golang_x_net__v0.0.0-20210226172049-e18ecbb05110.zip",
"importpath": "golang.org/x/net",
- "sha256": "22ea306ad6c9100c636c165dc05a64265d0f985452a9f1edf32b561b620ae762",
- "strip_prefix": "golang.org/x/net@v0.0.0-20200822124328-c89045814202",
- "version": "v0.0.0-20200822124328-c89045814202",
+ "sha256": "17ae555c0bec70b583d84ec7a099db3fdc5b3b688cb2814f8c388d174e7ada15",
+ "strip_prefix": "golang.org/x/net@v0.0.0-20210226172049-e18ecbb05110",
+ "version": "v0.0.0-20210226172049-e18ecbb05110",
},
"org_golang_x_oauth2": {
"filename": "org_golang_x_oauth2__v0.0.0-20200107190931-bf48bf16ab8d.zip",
@@ -295,18 +351,25 @@
"version": "v0.0.0-20190423024810-112230192c58",
},
"org_golang_x_sys": {
- "filename": "org_golang_x_sys__v0.0.0-20200323222414-85ca7c5b95cd.zip",
+ "filename": "org_golang_x_sys__v0.0.0-20210615035016-665e8c7367d1.zip",
"importpath": "golang.org/x/sys",
- "sha256": "d00ccd67cf0f2dd8622ed2721b8824fcbaf4f5730f47387fd5e39adbd5f6972e",
- "strip_prefix": "golang.org/x/sys@v0.0.0-20200323222414-85ca7c5b95cd",
- "version": "v0.0.0-20200323222414-85ca7c5b95cd",
+ "sha256": "0d25c11d65a4ac84a6e2c3bd56a6afeb1da3923d2752a5aa59b7e99a94359fcb",
+ "strip_prefix": "golang.org/x/sys@v0.0.0-20210615035016-665e8c7367d1",
+ "version": "v0.0.0-20210615035016-665e8c7367d1",
+ },
+ "org_golang_x_term": {
+ "filename": "org_golang_x_term__v0.0.0-20201126162022-7de9c90e9dd1.zip",
+ "importpath": "golang.org/x/term",
+ "sha256": "475a86f11dd148b474ce405c5dbdd5f6bcae056c3e44e52445a45926dd69a552",
+ "strip_prefix": "golang.org/x/term@v0.0.0-20201126162022-7de9c90e9dd1",
+ "version": "v0.0.0-20201126162022-7de9c90e9dd1",
},
"org_golang_x_text": {
- "filename": "org_golang_x_text__v0.3.0.zip",
+ "filename": "org_golang_x_text__v0.3.6.zip",
"importpath": "golang.org/x/text",
- "sha256": "ea3068395503d3c7ef8ce16a286f75c8c93882c25a66c2aa6c8e2ad4da7a9ae0",
- "strip_prefix": "golang.org/x/text@v0.3.0",
- "version": "v0.3.0",
+ "sha256": "2afade648a4cb240afb7b3bf8e3719b615169c90d6281bd6d4ba34629c744579",
+ "strip_prefix": "golang.org/x/text@v0.3.6",
+ "version": "v0.3.6",
},
"org_golang_x_tools": {
"filename": "org_golang_x_tools__v0.0.0-20190524140312-2c0ae7006135.zip",