Flutter数据库交互插件deposit_supabase的使用

Flutter数据库交互插件deposit_supabase的使用

deposit_supabase 是一个为 deposit 包提供 Supabase 适配器的插件。通过它，你可以在 Flutter 应用中方便地与 Supabase 进行数据交互。

安装

首先，在你的 pubspec.yaml 文件中添加 deposit_supabase 依赖：

dependencies:
  flutter:
    sdk: flutter
  deposit_supabase: ^x.x.x  # 请替换为最新版本号

然后运行 flutter pub get 来安装依赖。

初始化

在你的 Flutter 项目中初始化 deposit_supabase。通常，这一步会在 main.dart 文件中完成：

import 'package:flutter/material.dart';
import 'package:deposit_supabase/deposit_supabase.dart';

void main() {
  WidgetsFlutterBinding.ensureInitialized();
  
  // 配置 Supabase 客户端
  SupabaseClient client = SupabaseClient(
    supabaseUrl: 'https://your-supabase-url.supabase.co',
    supabaseKey: 'your-supabase-key',
  );

  runApp(MyApp(client: client));
}

class MyApp extends StatelessWidget {
  final SupabaseClient client;

  MyApp({required this.client});

  @override
  Widget build(BuildContext context) {
    return MaterialApp(
      title: 'Flutter Deposit Supabase Demo',
      theme: ThemeData(
        primarySwatch: Colors.blue,
      ),
      home: MyHomePage(title: 'Flutter Deposit Supabase Demo', client: client),
    );
  }
}

使用示例

接下来，我们将展示如何使用 deposit_supabase 插件来执行基本的 CRUD 操作。

创建记录

class MyHomePage extends StatefulWidget {
  final String title;
  final SupabaseClient client;

  MyHomePage({required this.title, required this.client});

  @override
  _MyHomePageState createState() => _MyHomePageState();
}

class _MyHomePageState extends State<MyHomePage> {
  final _formKey = GlobalKey<FormState>();
  final _nameController = TextEditingController();
  final _emailController = TextEditingController();

  Future<void> _createRecord() async {
    if (_formKey.currentState!.validate()) {
      final record = await widget.client.from('users').insert({
        'name': _nameController.text,
        'email': _emailController.text,
      }).execute();

      if (record.error == null) {
        ScaffoldMessenger.of(context).showSnackBar(
          SnackBar(content: Text('Record created successfully!')),
        );
      } else {
        ScaffoldMessenger.of(context).showSnackBar(
          SnackBar(content: Text('Failed to create record: ${record.error}')),
        );
      }
    }
  }

  @override
  Widget build(BuildContext context) {
    return Scaffold(
      appBar: AppBar(
        title: Text(widget.title),
      ),
      body: Padding(
        padding: const EdgeInsets.all(16.0),
        child: Form(
          key: _formKey,
          child: Column(
            children: [
              TextFormField(
                controller: _nameController,
                decoration: InputDecoration(labelText: 'Name'),
                validator: (value) {
                  if (value == null || value.isEmpty) {
                    return 'Please enter your name';
                  }
                  return null;
                },
              ),
              TextFormField(
                controller: _emailController,
                decoration: InputDecoration(labelText: 'Email'),
                validator: (value) {
                  if (value == null || value.isEmpty) {
                    return 'Please enter your email';
                  }
                  return null;
                },
              ),
              ElevatedButton(
                onPressed: _createRecord,
                child: Text('Create Record'),
              ),
            ],
          ),
        ),
      ),
    );
  }
}

查询记录

Future<void> _fetchRecords() async {
  final records = await widget.client.from('users').select().execute();

  if (records.error == null) {
    print(records.data);
  } else {
    print('Failed to fetch records: ${records.error}');
  }
}

更新记录

Future<void> _updateRecord(int id) async {
  final updatedRecord = await widget.client.from('users')
    .update({'name': 'Updated Name'})
    .eq('id', id)
    .execute();

  if (updatedRecord.error == null) {
    ScaffoldMessenger.of(context).showSnackBar(
      SnackBar(content: Text('Record updated successfully!')),
    );
  } else {
    ScaffoldMessenger.of(context).showSnackBar(
      SnackBar(content: Text('Failed to update record: ${updatedRecord.error}')),
    );
  }
}

删除记录

Future<void> _deleteRecord(int id) async {
  final deletedRecord = await widget.client.from('users').delete().eq('id', id).execute();

  if (deletedRecord.error == null) {
    ScaffoldMessenger.of(context).showSnackBar(
      SnackBar(content: Text('Record deleted successfully!')),
    );
  } else {
    ScaffoldMessenger.of(context).showSnackBar(
      SnackBar(content: Text('Failed to delete record: ${deletedRecord.error}')),
    );
  }
}