From d97985a694b218713ddf63ed684b6a509f931f3b Mon Sep 17 00:00:00 2001
From: Julien Dessaux
Date: Fri, 14 Feb 2025 00:14:15 +0100
Subject: [golang] implement automation loop and add contract accepting

---
 golang/pkg/database/db.go | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'golang/pkg/database/db.go')

diff --git a/golang/pkg/database/db.go b/golang/pkg/database/db.go
index cb15e52..f094039 100644
--- a/golang/pkg/database/db.go
+++ b/golang/pkg/database/db.go
@@ -5,6 +5,7 @@ import (
 	"database/sql"
 	"fmt"
 	"runtime"
+	"strings"
 )
 
 func initDB(ctx context.Context, url string) (*sql.DB, error) {
@@ -90,6 +91,21 @@ func (db *DB) Close() error {
 	return nil
 }
 
+func (db *DB) Reset() error {
+	_, err := db.Exec(strings.Join([]string{
+		"DELETE FROM agents;",
+		"DELETE FROM markets;",
+		"DELETE FROM systems;",
+		"DELETE FROM tokens;",
+		"DELETE FROM transactions;",
+		"DELETE FROM waypoints;",
+	}, ""))
+	if err != nil {
+		return fmt.Errorf("failed to reset database: %w", err)
+	}
+	return nil
+}
+
 func (db *DB) Exec(query string, args ...any) (sql.Result, error) {
 	return db.writeDB.ExecContext(db.ctx, query, args...)
 }
-- 
cgit v1.2.3