typesafe_supabase 0.0.1-dev.19

A dart package that enables type-safe queries to a Supabase database.

example/lib/main.dart

import 'dart:io';

import 'package:supabase/supabase.dart';
import 'package:typesafe_supabase/typesafe_supabase.dart';
import 'package:typesafe_supabase_example/secrets.dart';
import 'package:typesafe_supabase_example/tables/authors.dart';
import 'package:typesafe_supabase_example/tables/books.dart';

void main() async {
  final supabaseClient = SupabaseClient(
    SUPABASE_PROJECT_URL,
    SUPABASE_ANON_KEY,
  );

  // Create the books table.
  final books = Books(supabaseClient: supabaseClient);

  // Fetch a Paddington book.
  final book = await books.fetch(
    columns: {
      Books.title,
      Books.author({Authors.name}),
    },
    filter: books.textSearch(Books.title('Paddington')),
    modifier: books.order(Books.title).limit(1).single(),
  );

  // Print the title of the book.
  print(book.title);
  print(book.author.name);

  // Insert a new Paddington book.
  await books.insert(
    records: [
      BooksInsert(title: 'To be updated', authorID: BigInt.two, pages: 160),
    ],
    modifier: books.none(),
  );

  // Update the title and author of the book with the ID 4.
  await books.update(
    values: {
      Books.title('Paddington Here and Now'),
      Books.authorID(BigInt.one),
    },
    filter: books.equal(Books.id(BigInt.from(4))),
    modifier: books.none(),
  );

  // Delete all Paddington books that were not written by Michael Bond.
  await books.delete(
    filter: books
        .textSearch(Books.title('Paddington'))
        .notEqual(Books.authorID(BigInt.one)),
    modifier: books.none(),
  );

  exit(0);
}