diff options
| -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; |