diff options
| author | Runxi Yu <me@runxiyu.org> | 2025-03-06 13:51:05 +0800 |
|---|---|---|
| committer | Runxi Yu <me@runxiyu.org> | 2025-03-06 13:51:05 +0800 |
| commit | 9b46e7a889d446d62243cf768619d4615140f0e0 (patch) | |
| tree | 99611cbae63597cebb5e403cb3c4d45968e46b4d | |
| parent | sql: Add potential for recursive groups (diff) | |
| download | forge-9b46e7a889d446d62243cf768619d4615140f0e0.tar.gz forge-9b46e7a889d446d62243cf768619d4615140f0e0.tar.zst forge-9b46e7a889d446d62243cf768619d4615140f0e0.zip | |
sql: Add purge and test scripts
| -rw-r--r-- | purge.sql | 2 | ||||
| -rw-r--r-- | test.sql | 17 |
2 files changed, 19 insertions, 0 deletions
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; |