brick_supabase 0.1.1+1

Supabase connector for Brick, a data persistence library. Includes annotations, adapter, model, and provider.

Supabase Provider

Connecting Brick with Supabase.

Supported Query Configuration

providerArgs:

Name	Type	Description
'limit'	int	Forwards to Supabase's limit param in Brick's #get action
'limitByReferencedTable'	String?	Forwards to Supabase's referencedTable property
'orderBy'	String	Use field names not column names and always specify direction.For example, given a final DateTime createdAt; field: {'orderBy': 'createdAt ASC'}.
'orderByReferencedTable'	String?	Forwards to Supabase's referencedTable property

where:

Brick currently does not support all of Supabase's filtering methods. Consider the associated Compare enum value to Supabase's method when building a Brick query:

Brick	Supabase
Compare.exact	.eq
Compare.notEqual	.neq
Compare.contains	.like
Compare.doesNotContain	.not.like
Compare.greaterThan	.gt
Compare.greaterThanOrEqualTo	.gte
Compare.lessThen	.lt
Compare.lessThenOrEqualTo	.lte
Compare.between	.adj

Models

@SupabaseSerializable(tableName:)

The Supabase table name must be specified to connect from, upsert and delete invocations:

@SupabaseSerializable(tableName: 'users')
class User

copied to clipboard

@SupabaseSerializable(fieldRename:)

By default, Brick assumes the Dart field name is the camelized version of the Supabase column name (i.e. final String lastName => 'last_name'). However, this can be changed to rename all fields.

@SupabaseSerializable(fieldRename: FieldRename.pascal)
class User

copied to clipboard

fieldRename is only the default transformation. Naming can be overriden on a field-by-field basis with @Supabase(name:).

@SupabaseSerializable(defaultToNull:)

Forwards to Supabase's defaultToNull during upsert operations.

@SupabaseSerializable(ignoreDuplicates:)

Forwards to Supabase's ignoreDuplicates during upsert operations.

@SupabaseSerializable(onConflict:)

Forwards to Supabase's onConflict during upsert operations.

Fields

@Supabase(unique:)

Connect Supabase's primary key (or any other index) to your application code. This is useful for upsert and delete logic when mutating instances.

@Supabase(unique: true, name: 'uuid')
final String supabaseUuid;

copied to clipboard

@Supabase(foreignKey:)

Specify the foreign key to use on the table when fetching for a remote association.

For example, given the orders table has a customer_id column that associates the customers table, an Order class in Dart may look like:

@SupabaseSerializeable(tableName: 'orders')
class Order {
  @Supabase(foreignKey: 'customer_uuid')
  final Customer customer;
}

@SupabaseSerializeable(tableName: 'customers')
class Customer {
  @Supabase(unique: true)
  final String uuid;
}

copied to clipboard

@Supabase(enumAsString:)

Brick by default assumes enums from a Supabase API will be delivered as integers matching the index in the Flutter app. However, if your API delivers strings instead, the field can be easily annotated without writing a custom generator.

Given the API:

{ "user": { "hats": ["bowler", "birthday"] } }

copied to clipboard

Simply convert hats into a Dart enum:

enum Hat { baseball, bowler, birthday }

...

@Supabase(enumAsString: true)
final List<Hat> hats;

copied to clipboard

@Supabase(name:)

Supabase keys can be renamed per field. This will override the default set by SupabaseSerializable#fieldRename.

@Supabase(
  name: "full_name"  // "full_name" is used in from and to requests to Supabase instead of "last_name"
)
final String lastName;

copied to clipboard

@Supabase(ignoreFrom:) and @Supabase(ignoreTo:)

When true, the field will be ignored by the (de)serializing function in the adapter.

Unsupported Field Types

The following are not serialized to Supabase. However, unsupported types can still be accessed in the model as non-final fields.

• Nested List<> e.g. <List<List<int>>>
• Many-to-many associations