mirror of https://github.com/artifacthub/hub.git
44 lines
1.5 KiB
SQL
44 lines
1.5 KiB
SQL
-- Start transaction and plan tests
|
|
begin;
|
|
select plan(3);
|
|
|
|
-- Declare some variables
|
|
\set user1ID '00000000-0000-0000-0000-000000000001'
|
|
\set code1ID '00000000-0000-0000-0000-000000000001'
|
|
\set user2ID '00000000-0000-0000-0000-000000000002'
|
|
\set code2ID '00000000-0000-0000-0000-000000000002'
|
|
|
|
-- Seed some data
|
|
insert into "user" (user_id, alias, email)
|
|
values (:'user1ID', 'user1', 'user1@email.com');
|
|
insert into "user" (user_id, alias, email)
|
|
values (:'user2ID', 'user2', 'user2@email.com');
|
|
insert into password_reset_code (password_reset_code_id, user_id, created_at)
|
|
values (:'code1ID', :'user1ID', current_timestamp - '5 minute'::interval);
|
|
insert into password_reset_code (password_reset_code_id, user_id, created_at)
|
|
values (:'code2ID', :'user2ID', current_timestamp - '30 minute'::interval);
|
|
|
|
-- Password reset should succeed
|
|
select lives_ok(
|
|
$$ select verify_password_reset_code('00000000-0000-0000-0000-000000000001') $$,
|
|
'Verify password reset code succeeded'
|
|
);
|
|
|
|
-- Password reset should fail in the following cases
|
|
select throws_ok(
|
|
$$ select verify_password_reset_code('00000000-0000-0000-0000-000000000003') $$,
|
|
'P0001',
|
|
'invalid password reset code',
|
|
'Verify password reset code failed because code did not exist'
|
|
);
|
|
select throws_ok(
|
|
$$ select verify_password_reset_code('00000000-0000-0000-0000-000000000002') $$,
|
|
'P0001',
|
|
'invalid password reset code',
|
|
'Verify password reset code failed because code has expired'
|
|
);
|
|
|
|
-- Finish tests and rollback transaction
|
|
select * from finish();
|
|
rollback;
|