.execute error with Supabase and Flutter (PostgrestFilterBuilder)

Question

VS Code says that .execute isn't defined for the type 'PostgrestFilterBuilder'.

Here is my Code:

text_service.dart

import 'package:thrive/main.dart';

class TextService {
  Future<List<String>> fetchTexts() async {
    final response = await supabase
        .from('profiles')
        .select('community')
        .execute();

    if (response.error != null) {
      throw response.error!;
    }

    final data = response.data as List<dynamic>;
    return data.map((item) => item['community'] as String).toList();
  }
}

I tried to use .get instead of .execute but this also doesn't work. Can someone help me?

Shayan Poursadeghi · Accepted Answer · 2024-10-30 12:53:08Z

0

In the latest Supabase SDK versions, the ".execute()" method has been deprecated. Instead, you could directly use the PostgrestFilterBuilder object to fetch data.

`import 'package:thrive/main.dart';

class TextService {
  Future<List<String>> fetchTexts() async {
    final response = await supabase
        .from('profiles')
        .select('community');

    if (response != null) {
      throw response;
    }

    final data = response as List<dynamic>;
    return data.map((item) => item['community'] as String).toList();
  }
}`

answered Oct 30, 2024 at 12:53

Shayan Poursadeghi

1013 bronze badges

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

Collectives™ on Stack Overflow

.execute error with Supabase and Flutter (PostgrestFilterBuilder)

Here is my Code:

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Here is my Code:

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related