supabase-postgres.git / summary / log / commit / refs

commit    e4aeadb4e558f350702febc616dd1357290cca55
Author:   Oliver Rice <github@oliverrice.com>
Commit:   GitHub <noreply@github.com>
Date:     Fri Aug 23 17:12:37 2024 +0000

    test vault (#1172)


 nix/tests/expected/vault.out | 42 ++++++++++++++++++++++++++++++++++++++++++
 nix/tests/sql/vault.sql      | 30 ++++++++++++++++++++++++++++++
 2 files changed, 72 insertions(+)

diff --git a/nix/tests/expected/vault.out b/nix/tests/expected/vault.out
new file mode 100644
index 00000000..e4eaff2e
--- /dev/null
+++ b/nix/tests/expected/vault.out
@@ -0,0 +1,42 @@
+select
+  1
+from
+  vault.create_secret('my_s3kre3t');
+ ?column? 
+----------
+        1
+(1 row)
+
+select
+  1
+from
+  vault.create_secret(
+    'another_s3kre3t',
+    'unique_name',
+    'This is the description'
+  );
+ ?column? 
+----------
+        1
+(1 row)
+
+insert into vault.secrets (secret)
+values
+  ('s3kre3t_k3y');
+select
+  name,
+  description
+from
+  vault.decrypted_secrets 
+order by
+  created_at desc 
+limit
+  3;
+    name     |       description       
+-------------+-------------------------
+             | 
+ unique_name | This is the description
+             | 
+(3 rows)
+
+ 
diff --git a/nix/tests/sql/vault.sql b/nix/tests/sql/vault.sql
new file mode 100644
index 00000000..bafcb4df
--- /dev/null
+++ b/nix/tests/sql/vault.sql
@@ -0,0 +1,30 @@
+select
+  1
+from
+  vault.create_secret('my_s3kre3t');
+
+select
+  1
+from
+  vault.create_secret(
+    'another_s3kre3t',
+    'unique_name',
+    'This is the description'
+  );
+
+insert into vault.secrets (secret)
+values
+  ('s3kre3t_k3y');
+
+select
+  name,
+  description
+from
+  vault.decrypted_secrets 
+order by
+  created_at desc 
+limit
+  3;
+ 
+
+


[parent: aadd7263c180]