Helper functions are located in @/supabase/.... Use the exported classes to GET and SET to access and modify the values in the Supabase database.

Each method returns a { data, error } object, where data is a list/object (depending on the query). If the query is successful, error returns NULL.

For example:

import { paymentDatabase } from "@/supabase/database";

async function payments() {
  const { data, error } = await paymentDatabase.getPaymentDetails(
    "sample-username"
  );
  if (error) console.log(error);
  else {
    console.log(data);
  }
}

If successful, data returns:

[{...}, {...},...]

users database

CREATE TABLE users (
    username TEXT PRIMARY KEY NOT NULL,
    password VARCHAR NOT NULL,
    safekeys VARCHAR[] NOT NULL,
    salt TEXT NOT NULL
)

user_payments database

CREATE TABLE user_payments (
    username TEXT,
    balance INTEGER,
    payments JSON[],
    PRIMARY KEY username,
    FOREGIN KEY username REFERENCES users.username
)

payments JSON returns an list of objects with the following parameters: ID, labelName, amount, serviceName, dateOfPayment.

For example:

{
    labelName: "Grab Unlimited Subcription", // string (primary key)
    amount: 8, // number
    serviceName: "Grab" // string
    dateOfPayment: "26-08-2023" // maintain this format DD-MM-YYYY
}