WWC Supabase DB Gen

file.md

Prompt:

Create a database. Create a habits table with an id, a habit name, an isCompletedToday flag, a userID foreign key relation, a color property, and a start_date. Create another table called users with userID, email. I need a third table for logging habit completions. Related to a habit ID, a completion date.

SQL:

-- Create a users table
create table users (
  user_id uuid primary key default uuid_generate_v4(),
  email text
);

-- Create a habits table
create table habits (
  id integer primary key generated always as identity,
  habit_name text,
  is_completed_today boolean,
  user_id uuid references users(user_id),
  color text,
  start_date date
);

-- Create a habit completions table
create table habit_completions (
  id integer primary key generated always as identity,
  habit_id integer references habits(id),
  completion_date date
);

Row level policy for habits table: (auth.uid() = user_id)

Flutterflow AIGen prompt:

habit dashboard page containing an appbar with title "dashboard", a floating action button with a plus icon and text "add habit", and a listview with list items containing a habit's name, description

Color1: #2B825B

Color2: #4D39F8

Here's the clonable project if you want to use it as a starting point or if you forgot to bring your laptop or anything.

Here, are some additional Row Level Security policies to make it just a bit more secure:

users table

code: (auth.uid() = user_id)

habits table

code:

(
  auth.uid () = (
    SELECT
      habits.user_id
    FROM
      habits
    WHERE
      (habits.id = habit_completions.habit_id)
  )
)

NOTE: the example Flutterflow project WILL NOT run because I've changed the Supabase credentials. Don't forget to update with your credentials after cloning.