From 8d018d996c1eddb882dc64ebbd228bb0135944f3 Mon Sep 17 00:00:00 2001 From: sadbeast Date: Sun, 23 Jun 2024 15:36:59 -0700 Subject: wtf --- test/users.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 test/users.sql (limited to 'test/users.sql') diff --git a/test/users.sql b/test/users.sql new file mode 100644 index 0000000..ec6f046 --- /dev/null +++ b/test/users.sql @@ -0,0 +1,14 @@ +BEGIN; +SELECT plan(7); + +SELECT has_table('users'); +SELECT columns_are('users', ARRAY[ 'user_id', 'username', 'password', 'name', 'modified_at', 'created_at']); +SELECT has_sequence('users_user_id_seq'); +SELECT has_index('teamdraft', 'users', 'users_pk', 'user_id'); + +SELECT has_table('sessions'); +SELECT columns_are('sessions', ARRAY[ 'session_id', 'user_id', 'expires', 'modified', 'created']); +SELECT has_index('teamdraft', 'sessions', 'sessions_pkey', 'session_id'); + +SELECT * FROM finish(); +ROLLBACK; -- cgit v1.2.3