diff options
| -rw-r--r-- | test.sql | 26 |
1 files changed, 23 insertions, 3 deletions
@@ -8,10 +8,30 @@ child_group AS ( 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 repos (name, group_id, contrib_requirements, filesystem_path) -SELECT 'server', id, 'public', '/home/runxiyu/Lindenii/forge/server/.git' -FROM child_group; +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; + |