start save users

store.go

@@ -4,7 +4,9 @@ import (
 	"crypto/rand"
 	"database/sql"
 	"encoding/base64"
-	"github.com/go-sql-driver/mysql"
+	"fmt"
+	"time"
+	_ "github.com/go-sql-driver/mysql"
 	"github.com/go-webauthn/webauthn/webauthn"
 )
 
@@ -69,6 +71,21 @@ func (i *InMem) GetOrCreateUser(userName string) PasskeyUser {
 
 func (i *InMem) SaveUser(user PasskeyUser) {
 	// Store user in MySQL database
+	db, err := sql.Open("mysql", "root:password@/oworganizer")
+	if err != nil {
+		panic(err)
+	}
+	// See "Important settings" section.
+	db.SetConnMaxLifetime(time.Minute * 3)
+	db.SetMaxOpenConns(10)
+	db.SetMaxIdleConns(10)
+
+	insert, err := db.Query("INSERT INTO users (username, key) VALUES(" + user.WebAuthnName(), user.WebAuthnCredentials())
+    if err !=nil {
+        panic(err.Error())
+    }
+    defer insert.Close()
+    fmt.Println("Yay, values added!")
 
 	i.log.Printf("[DEBUG] SaveUser: %v", user.WebAuthnName())
 	i.users[user.WebAuthnName()] = user