diff options
| author | Runxi Yu <me@runxiyu.org> | 2025-03-06 22:37:06 +0800 |
|---|---|---|
| committer | Runxi Yu <me@runxiyu.org> | 2025-03-06 22:37:06 +0800 |
| commit | db3253c44336bfafbf9fef7ba408ec99b0f131c2 (patch) | |
| tree | fa081473303614da070708c594f35618c5d3f670 /test.sql | |
| parent | *: Add column headers to tables (diff) | |
| download | forge-db3253c44336bfafbf9fef7ba408ec99b0f131c2.tar.gz forge-db3253c44336bfafbf9fef7ba408ec99b0f131c2.tar.zst forge-db3253c44336bfafbf9fef7ba408ec99b0f131c2.zip | |
scripts, sql: Reorganize
Diffstat (limited to 'test.sql')
| -rw-r--r-- | test.sql | 37 |
1 files changed, 0 insertions, 37 deletions
diff --git a/test.sql b/test.sql deleted file mode 100644 index b270b76..0000000 --- a/test.sql +++ /dev/null @@ -1,37 +0,0 @@ -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; - |