Create a folder for the scouting app
Change-Id: Ia9561e3fa35c213bbe645b461fcae36ecaf722fa
Signed-off-by: Sabina Leaver <100027607@mvla.net>
diff --git a/go.mod b/go.mod
index fa311ec..7c0e058 100644
--- a/go.mod
+++ b/go.mod
@@ -6,6 +6,7 @@
github.com/buildkite/go-buildkite v2.2.0+incompatible
github.com/golang/protobuf v1.5.2
github.com/google/flatbuffers v2.0.5+incompatible
+ github.com/mattn/go-sqlite3 v1.14.10
google.golang.org/grpc v1.43.0
)
diff --git a/go.sum b/go.sum
index 0db981f..c832e6c 100644
--- a/go.sum
+++ b/go.sum
@@ -53,6 +53,8 @@
github.com/google/go-querystring v1.1.0/go.mod h1:Kcdr2DB4koayq7X8pmAG4sNG59So17icRSOU623lUBU=
github.com/google/uuid v1.1.2/go.mod h1:TIyPZe4MgqvfeYDBFedMoGGpEw/LqOeaOT+nhxU+yHo=
github.com/grpc-ecosystem/grpc-gateway v1.16.0/go.mod h1:BDjrQk3hbvj6Nolgz8mAMFbcEtjT1g+wF4CSlocrBnw=
+github.com/mattn/go-sqlite3 v1.14.10 h1:MLn+5bFRlWMGoSRmJour3CL1w/qL96mvipqpwQW/Sfk=
+github.com/mattn/go-sqlite3 v1.14.10/go.mod h1:NyWgC/yNuGj7Q9rpYnZvas74GogHl5/Z4A/KQRfk6bU=
github.com/pmezard/go-difflib v1.0.0/go.mod h1:iKH77koFhYxTK1pcRnkKkqfTogsbg7gZNVY4sRDYZ/4=
github.com/prometheus/client_model v0.0.0-20190812154241-14fe0d1b01d4/go.mod h1:xMI15A0UPsDsEKsMN9yxemIoYk6Tm2C1GtYGdfGttqA=
github.com/rogpeppe/fastuuid v1.2.0/go.mod h1:jVj6XXZzXRy/MSR5jhDC/2q6DgLz+nrA6LYCDYWNEvQ=
diff --git a/go_deps.bzl b/go_deps.bzl
index 5e215ef..30d0311 100644
--- a/go_deps.bzl
+++ b/go_deps.bzl
@@ -129,6 +129,12 @@
version = "v1.16.0",
)
maybe_override_go_dep(
+ name = "com_github_mattn_go_sqlite3",
+ importpath = "github.com/mattn/go-sqlite3",
+ sum = "h1:MLn+5bFRlWMGoSRmJour3CL1w/qL96mvipqpwQW/Sfk=",
+ version = "v1.14.10",
+ )
+ maybe_override_go_dep(
name = "com_github_pmezard_go_difflib",
importpath = "github.com/pmezard/go-difflib",
sum = "h1:4DBwDE0NGyQoBHbLQYPwSUPoCMWR5BEzIk/f1lZbAQM=",
diff --git a/scouting/BUILD b/scouting/BUILD
new file mode 100644
index 0000000..8188a20
--- /dev/null
+++ b/scouting/BUILD
@@ -0,0 +1,17 @@
+load("@io_bazel_rules_go//go:def.bzl", "go_binary", "go_library")
+
+go_binary(
+ name = "sql_demo",
+ embed = [":scouting_lib"],
+ target_compatible_with = ["@platforms//cpu:x86_64"],
+ visibility = ["//visibility:public"],
+)
+
+go_library(
+ name = "scouting_lib",
+ srcs = ["sql_demo.go"],
+ importpath = "github.com/frc971/971-Robot-Code/scouting",
+ target_compatible_with = ["@platforms//cpu:x86_64"],
+ visibility = ["//visibility:private"],
+ deps = ["@com_github_mattn_go_sqlite3//:go_default_library"],
+)
diff --git a/scouting/sql_demo.go b/scouting/sql_demo.go
new file mode 100644
index 0000000..561571a
--- /dev/null
+++ b/scouting/sql_demo.go
@@ -0,0 +1,36 @@
+package main
+
+import (
+ "database/sql"
+ "fmt"
+ "strconv"
+
+ _ "github.com/mattn/go-sqlite3"
+)
+
+func main() {
+ var alliancecolour string
+ var teamnumber int
+ var id int
+
+ database, _ := sql.Open("sqlite3", "./bogo.db")
+ statement, _ := database.Prepare("DROP TABLE IF EXISTS robots")
+ statement.Exec()
+ statement, _ = database.Prepare("CREATE TABLE robots (id INTEGER PRIMARY KEY, alliancecolour TEXT, teamnumber TEXT)")
+ statement.Exec()
+ for i := 0; i < 6; i++ {
+ if i < 3 {
+ alliancecolour = "red" + strconv.Itoa(i+1)
+ } else if i >= 3 {
+ alliancecolour = "blue" + strconv.Itoa(i-2)
+ }
+ statement, _ = database.Prepare("INSERT INTO robots (alliancecolour, teamnumber) VALUES (?, ?)")
+ statement.Exec(alliancecolour, "971")
+ }
+ rows, _ := database.Query("SELECT id, alliancecolour, teamnumber FROM robots")
+
+ for rows.Next() {
+ rows.Scan(&id, &alliancecolour, &teamnumber)
+ fmt.Println(alliancecolour + ": " + strconv.Itoa(teamnumber))
+ }
+}
diff --git a/tools/go/go_mirrors.bzl b/tools/go/go_mirrors.bzl
index 9addcef..0e8f394 100644
--- a/tools/go/go_mirrors.bzl
+++ b/tools/go/go_mirrors.bzl
@@ -315,4 +315,11 @@
"strip_prefix": "golang.org/x/xerrors@v0.0.0-20200804184101-5ec99f83aff1",
"version": "v0.0.0-20200804184101-5ec99f83aff1",
},
+ "com_github_mattn_go_sqlite3": {
+ "filename": "com_github_mattn_go_sqlite3__v1.14.10.zip",
+ "importpath": "github.com/mattn/go-sqlite3",
+ "sha256": "3c1e6497b023fc4741bf1bbfb39ae657b99cf44cfb33f5cbf1e88b315d25a306",
+ "strip_prefix": "github.com/mattn/go-sqlite3@v1.14.10",
+ "version": "v1.14.10",
+ },
}