Flutter删除sqlite表中的所有数据，然后插入记录

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

Future<Database> openDatabase() async {
  final databasePath = await getDatabasesPath();
  final path = join(databasePath, 'my_database.db');
  return await openDatabase(path, version: 1,
      onCreate: (Database db, int version) async {
    await db.execute('CREATE TABLE IF NOT EXISTS my_table (id INTEGER PRIMARY KEY, name TEXT)');
  });
}

final database = await openDatabase();

await database.delete('my_table');

await database.insert('my_table', {'id': 1, 'name': 'John'});

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

Future<Database> openDatabase() async {
  final databasePath = await getDatabasesPath();
  final path = join(databasePath, 'my_database.db');
  return await openDatabase(path, version: 1,
      onCreate: (Database db, int version) async {
    await db.execute('CREATE TABLE IF NOT EXISTS my_table (id INTEGER PRIMARY KEY, name TEXT)');
  });
}

void main() async {
  final database = await openDatabase();
  
  await database.delete('my_table');
  
  await database.insert('my_table', {'id': 1, 'name': 'John'});
  
  // 关闭数据库连接
  await database.close();
}