From 9b46e7a889d446d62243cf768619d4615140f0e0 Mon Sep 17 00:00:00 2001
From: Runxi Yu <me@runxiyu.org>
Date: Thu, 6 Mar 2025 13:51:05 +0800
Subject: sql: Add purge and test scripts

---
 purge.sql |  2 ++
 test.sql  | 17 +++++++++++++++++
 2 files changed, 19 insertions(+)
 create mode 100644 purge.sql
 create mode 100644 test.sql

diff --git a/purge.sql b/purge.sql
new file mode 100644
index 0000000..03eecc3
--- /dev/null
+++ b/purge.sql
@@ -0,0 +1,2 @@
+DROP SCHEMA public CASCADE;
+CREATE SCHEMA public;
diff --git a/test.sql b/test.sql
new file mode 100644
index 0000000..43c898f
--- /dev/null
+++ b/test.sql
@@ -0,0 +1,17 @@
+WITH parent_group AS (
+	INSERT INTO groups (name, description)
+	VALUES ('lindenii', 'The Lindenii Project')
+	RETURNING id
+),
+child_group AS (
+	INSERT INTO groups (name, description, parent_group)
+	SELECT 'forge', 'Lindenii Forge', id
+	FROM parent_group
+	RETURNING id
+)
+INSERT INTO repos (name, group_id, contrib_requirements, filesystem_path)
+SELECT 'server', id, 'public', '/home/runxiyu/Lindenii/forge/server/.git'
+FROM child_group;
+
+SELECT * FROM groups;
+SELECT * FROM repos;
-- 
cgit v1.2.3