Create a folder for the scouting app
Change-Id: Ia9561e3fa35c213bbe645b461fcae36ecaf722fa
Signed-off-by: Sabina Leaver <100027607@mvla.net>
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))
+ }
+}