[golang] Bootstrap contracting and refactor the agent code

1 files changed, 19 insertions, 0 deletions

diff --git a/golang/pkg/database/agents.go b/golang/pkg/database/agents.go
new file mode 100644
index 0000000..cd9e0a2
--- /dev/null
+++ b/golang/pkg/database/agents.go
@@ -0,0 +1,19 @@
+package database
+
+import (
+	"encoding/json"
+	"fmt"
+
+	"git.adyxax.org/adyxax/spacetraders/golang/pkg/model"
+)
+
+func (db *DB) SaveAgent(agent *model.Agent) error {
+	data, err := json.Marshal(agent)
+	if err != nil {
+		return fmt.Errorf("failed to marshal agent: %w", err)
+	}
+	if _, err := db.Exec(`INSERT INTO agents SET data = (json(?));`, data); err != nil {
+		return fmt.Errorf("failed to insert agent data: %w", err)
+	}
+	return nil
+}