From ff58c1200bb7e787918a48bfc309b8268257546d Mon Sep 17 00:00:00 2001
From: Runxi Yu <me@runxiyu.org>
Date: Sat, 5 Apr 2025 12:46:21 +0800
Subject: SQL: Remove purge.sql and test.sql as outdated and unnecessary

---
 sql/test.sql | 40 ----------------------------------------
 1 file changed, 40 deletions(-)
 delete mode 100644 sql/test.sql

(limited to 'sql/test.sql')

diff --git a/sql/test.sql b/sql/test.sql
deleted file mode 100644
index a016df9..0000000
--- a/sql/test.sql
+++ /dev/null
@@ -1,40 +0,0 @@
--- SPDX-License-Identifier: AGPL-3.0-only
--- SPDX-FileCopyrightText: Copyright (c) 2025 Runxi Yu <https://runxiyu.org>
-
-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
-),
-create_repos AS (
-	INSERT INTO repos (name, group_id, contrib_requirements, filesystem_path)
-	SELECT 'server', id, 'public', '/home/runxiyu/Lindenii/forge/server/.git'
-	FROM child_group
-),
-new_user AS (
-	INSERT INTO users (username, type, password)
-	VALUES ('test', 'registered', '$argon2id$v=19$m=4096,t=3,p=1$YWFhYWFhYWFhYWFh$i40k7TPFHqXRH4eQOAYGH3LvzwQ38jqqlfap9Rtiy3c')
-	RETURNING id
-),
-new_ssh AS (
-	INSERT INTO ssh_public_keys (key_string, user_id)
-	SELECT 'ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIAuavKDhEM1L6CufIecy2P712gp151CqZuwSYahTWvmq', id
-	FROM new_user
-	RETURNING user_id
-)
-INSERT INTO user_group_roles (group_id, user_id)
-SELECT child_group.id, new_ssh.user_id
-FROM child_group, new_ssh;
-
-SELECT * FROM groups;
-SELECT * FROM repos;
-SELECT * FROM users;
-SELECT * FROM ssh_public_keys;
-SELECT * FROM user_group_roles;
-
-- 
cgit v1.2.3

