Supabase Common

Usage

import * as common from "https://deno.land/x/supabase_common/mod.ts"

TOTP

const { TOTP} = common
const { createTOTP,verifyTOTP } = TOTP
// Create TOTP
const {secret:any,uri:string} = createTOTP(project_name,user_name,google2fa_secret)

// Verify TOTP
const isCodeCorrect = verifyTOTP(params.uri,params.google2fa_code)

Token

Add database functions on supabase

1. generate token

begin
    return extensions.generate(
        payload:= payload,
        secret:= secret,
        algorithm:= algorithm,
    );
end;

2. verify_token

  declare
    params json;
    pass boolean;
  begin
    select payload,valid
    into params,pass
    from extensions.verify(
        token:= token,
        secret:= secret,
        algorithm:= algorithm
    );
    return json_build_object(
        'params',params,
        'valid',pass
    );
  end;

Usage

const { generateToken,verifyToken } = common
// Generate token
const token = generateToken(payload,expires_in,supabaseClient)
// Verify token
const { params,valid } = verifyToken(token,supabaseClient)

Password

const { password_hash, password_verify } = common
// Hash password
const hashedPassword = password_hash(password)
// Verify password
const isPasswordCorret = password_verify(params.login_password, adminInfo.login_hash)