如何在flutter中获取sqflite中列值的总和？

dependencies:
  sqflite: ^2.0.0+3

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

Future<int> getColumnSum() async {
  // 获取数据库路径
  String path = join(await getDatabasesPath(), 'your_database.db');

  // 打开数据库
  Database database = await openDatabase(path);

  // 执行查询操作并获取总和
  List<Map<String, dynamic>> result = await database.rawQuery('SELECT SUM(column_name) FROM table_name');
  int sum = result[0]['SUM(column_name)'];

  // 关闭数据库连接
  await database.close();

  // 返回总和值
  return sum;
}

getColumnSum().then((sum) {
  print('列值的总和为: $sum');
}).catchError((error) {
  print('获取列值总和时出错: $error');
});