I have a flutter app where I use sqflite to create database. I want to make a backup and restore for this database so that when the app is reinstalled the database remains existing.

I found this SQL statement for backup:

BACKUP DATABASE databasename

TO DISK = ‘filepath’;

But I don’t know how to add the file path or how to implement this in the app.

Here’s the sql helper class from my app:

import 'package:flutter/foundation.dart';

import 'package:sqflite/sqflite.dart';
import 'package:sqflite_common_ffi_web/sqflite_ffi_web.dart';

class SqlHelper {
  Database? db;

  Future<void> init() async {
    try {
      if (kIsWeb) {
        var factory = databaseFactoryFfiWeb;
        db = await factory.openDatabase('pos.db');
      } else {
        db = await openDatabase(
          'pos.db',
          version: 1,
          onCreate: (db, version) {
            if (kDebugMode) {
              print('database created successfully');
            }
          },
        );
      }
    } catch (e) {
      if (kDebugMode) {
        print('Error in creating database: $e');
      }
    }
  }

  Future<void> registerForeignKeys() async {
    await db!.rawQuery("PRAGMA foreign_keys = ON");
    var result = await db!.rawQuery("PRAGMA foreign_keys");

    if (kDebugMode) {
      print('foreign keys result : $result');
    }
  }

  Future<bool> createTables() async {
    try {
      await registerForeignKeys();

      var batch = db!.batch();

      batch.execute("""
        Create table if not exists categories(
          id integer primary key,
          name text not null,
          description text not null
          ) 
          """);

      batch.execute("""
        Create table if not exists products(
          id integer primary key,
          name text not null,
          description text not null,
          price double not null,
          stock integer not null,
          isAvailable boolean not null,
          image text,
          categoryId integer not null,
          foreign key(categoryId) references categories(id)
          on delete restrict
          ) 
          """);

      batch.execute("""
        Create table if not exists clients(
          id integer primary key,
          name text not null,
          email text,
          phone text,
          address text
          ) 
          """);

      batch.execute("""
        Create table if not exists orders(
          id integer primary key,
          label text,
          totalPrice real,
          discount real,
          clientId integer not null,
          foreign key(clientId) references clients(id)
          on delete restrict
          ) 
          """);

      batch.execute("""
        Create table if not exists orderProductItems(
         orderId integer,
         productCount integer,
         productId integer,
         foreign key(productId) references products(id)
         on delete restrict
          ) 
          """);

      var result = await batch.commit();
      if (kDebugMode) {
        print('results $result');
      }
      return true;
    } catch (e) {
      if (kDebugMode) {
        print('Error in creating table: $e');
      }
      return false;
    }
  }
}

Please help and thanks in advance.