Favourite Item: flutter and supabase

Question

I have a tables in my supabase database called properties, profile and saved.

The schema for the tables looks like this:

properties
  id int8 (pk),
  created_at timestamptz,
  description text,
  price text,
  address text,

profiles
  id uuid (pk),
  updated_at timestamptz,
  username text,
  email text,

saved
  id uuid (pk),
  created_at timestamptz,
  userid uuid (fk) references id from profile,
  propertyid int8 fk) references id from properties

I created a CustomLikeButton in the below like_button.dart

import 'package:flutter/material.dart';

class CustomLikeButton extends StatelessWidget {
  final bool isLiked;
  void Function()? onTap;
  CustomLikeButton({super.key, required this.onTap, required this.isLiked});

  @override 
  Widget build(BuildContext context) {
    return GestureDetector(
      onTap: onTap,
      child: Icon(
        isLiked ? Icons.favorite : Icons.favorite_border,
        color: isLiked ? Colors.red : Colors.grey,
      )
    );
  }

}

I'm having trouble creating functions that can query the saved table, insert rows into the query table and also delete rows from the query table whenever a property listing is liked or unliked. Any help especially tried and tested will be helpful

Supabase Enjoyer · Accepted Answer · 2024-08-07 09:09:14Z

-1

Have you tried Postgres Functions and RPC?

answered Aug 7, 2024 at 9:09

Supabase Enjoyer

3804 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Chanda Musonda Over a year ago

I have but it doesn't seem to work. There's something wrong with the functions I have in my code but I don't know what it is

Collectives™ on Stack Overflow

Favourite Item: flutter and supabase

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related