2 files changed, 23 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
+}
diff --git a/golang/pkg/database/sql/001_trading.sql b/golang/pkg/database/sql/001_trading.sql
index fa8cbfe..68f2568 100644
--- a/golang/pkg/database/sql/001_trading.sql
+++ b/golang/pkg/database/sql/001_trading.sql
@@ -1,3 +1,7 @@
+CREATE TABLE agents (
+  id INTEGER PRIMARY KEY,
+  data TEXT NOT NULL
+);
 CREATE TABLE markets (
   id INTEGER PRIMARY KEY,
   systemSymbol TEXT NOT NULL,