Flutter - sqflite：如何更改持久数据的顺序（索引）

如何使用Flutter的sqflite库更改持久数据的顺序（索引）？

yaml
dependencies:
  flutter:
    sdk: flutter
  sqflite: ^2.0.0+4
  path_provider: ^2.0.2

dart
import 'package:flutter/material.dart';
import 'package:sqflite/sqflite.dart';
import 'package:path/path.dart';
import 'dart:async';
void main() {
  runApp(MyApp());
}
class MyApp extends StatelessWidget {
  @override
  Widget build(BuildContext context) {
    return MaterialApp(
      title: 'Task Manager',
      theme: ThemeData(
        primarySwatch: Colors.blue,
      ),
      home: TaskListPage(),
    );
  }
}
class TaskListPage extends StatefulWidget {
  @override
  _TaskListPageState createState() => _TaskListPageState();
}
class _TaskListPageState extends State {
  List tasks = [];
  @override
  void initState() {
    super.initState();
    loadTasks();
  }
  Future loadTasks() async {
    var databasesPath = await getDatabasesPath();
    var path = join(databasesPath, 'tasks.db');
    Database database = await openDatabase(
      path,
      version: 1,
      onCreate: (Database db, int version) async {
        await db.execute(
          'CREATE TABLE tasks (id INTEGER PRIMARY KEY, name TEXT, priority INTEGER)',
        );
      },
    );
    List> taskMaps = await database.query('tasks');
    tasks = taskMaps.map((taskMap) => Task.fromMap(taskMap)).toList();
    setState(() {});
  }
  Future changeTaskOrder(int oldIndex, int newIndex) async {
    var databasesPath = await getDatabasesPath();
    var path = join(databasesPath, 'tasks.db');
    Database database = await openDatabase(path);
    if (newIndex > oldIndex) newIndex -= 1;
    Task task = tasks.removeAt(oldIndex);
    tasks.insert(newIndex, task);
    for (int i = 0; i < tasks.length; i++) {
      await database.update(
        'tasks',
        {'priority': i},
        where: 'id = ?',
        whereArgs: [tasks[i].id],
      );
    }
    setState(() {});
  }
  @override
  Widget build(BuildContext context) {
    return Scaffold(
      appBar: AppBar(
        title: Text('Task List'),
      ),
      body: ReorderableListView(
        onReorder: changeTaskOrder,
        children: tasks
            .map((task) => ListTile(
                  key: Key(task.id.toString()),
                  title: Text(task.name),
                  subtitle: Text('Priority: ${task.priority}'),
                ))
            .toList(),
      ),
    );
  }
}
class Task {
  final int id;
  final String name;
  final int priority;
  Task({required this.id, required this.name, required this.priority});
  factory Task.fromMap(Map map) {
    return Task(
      id: map['id'],
      name: map['name'],
      priority: map['priority'],
    );
  }
}