如何在sqflite flutter中使用propper更新

dependencies:
  sqflite: ^2.0.0

import 'package:sqflite/sqflite.dart';
import 'package:path/path.dart';

class DatabaseHelper {
  static final DatabaseHelper _instance = DatabaseHelper.internal();
  factory DatabaseHelper() => _instance;

  static Database? _db;

  Future<Database?> get db async {
    if (_db != null) {
      return _db;
    }
    _db = await initDb();
    return _db;
  }

  DatabaseHelper.internal();

  Future<Database> initDb() async {
    String databasesPath = await getDatabasesPath();
    String path = join(databasesPath, 'mydatabase.db');

    // 打开数据库
    return await openDatabase(
      path,
      version: 1,
      onCreate: (Database db, int version) async {
        // 创建表
        await db.execute(
          'CREATE TABLE mytable (id INTEGER PRIMARY KEY, name TEXT)',
        );
      },
      onUpgrade: (Database db, int oldVersion, int newVersion) async {
        // 数据库升级逻辑
        if (oldVersion < newVersion) {
          // 添加新的字段或表
          await db.execute(
            'ALTER TABLE mytable ADD COLUMN age INTEGER',
          );
        }
      },
    );
  }

  // 其他数据库操作方法...
}

Future<void> updateData(int id, String newName) async {
  Database? db = await DatabaseHelper().db;
  if (db != null) {
    await db.update(
      'mytable',
      {'name': newName},
      where: 'id = ?',
      whereArgs: [id],
    );
  }
}