Skip to content

A Dart/Flutter package working with Moor, that allows exporting SQL-based Moor databases to a CSV form, for external storage or sharing. Works on all platforms except Web.

License

Notifications You must be signed in to change notification settings

Dhi13man/moor2csv

Repository files navigation

drift2csv / moor2csv

License Language Language Contributors GitHub forks GitHub Repo stars Last Commit Flutter Format, Analyse moor2csv version

"Buy Me A Coffee"

Supporting package for SQL/Drift/Moor, that allows easily exporting SQL-based Moor database to a CSV form, for external storage or sharing. Works on all platforms except Web.

Find Package on Official Dart Pub:

drift2csv version

Usage Steps

First, perform necessary steps to provide Storage capability in the device you are developing for. Example: Editing android\app\src\main\AndroidManifest.xml and providing permissions for Android.

  1. Set up a Moor/Drift Database in your flutter project and create necessary Data Structures and tables. Example:

    class Employees extends Table {
      TextColumn get employeeID => text()();
      TextColumn get name => text().withLength(max: 100).nullable()();
      IntColumn get phoneNo => integer().nullable()();
      TextColumn get deviceID => text().nullable()();
    
      @override
      Set<Column> get primaryKey => {employeeID};
    }
    
    @DriftDatabase(tables: [Employees])
    class Database extends _$Database {
      Database(QueryExecutor e) : super(e);
    
      @override
      int get schemaVersion => 1;
    
      // DATABASE OPERATIONS
      //EMPLOYEES
      Future<List<Employee>> getAllEmployees({
        String orderBy = 'asce',
        String mode = 'name',
      }) =>
          (select(employees)
                ..orderBy(
                  [
                    (u) {
                      GeneratedColumn<String?> criteria = employees.employeeID;
                      final OrderingMode order =
                          (mode == 'desc') ? OrderingMode.desc : OrderingMode.asc;
                      if (orderBy == 'id') {
                        criteria = employees.employeeID;
                      } else if (orderBy == 'name') {
                        criteria = employees.name;
                      } else if (orderBy == 'device') {
                        criteria = employees.deviceID;
                      }
                      return OrderingTerm(expression: criteria, mode: order);
                    }
                  ],
                ))
              .get();
    }
  2. Run a query to get your List<DataClass> item from the Database.
    Example: List<Employee> _employees = await db.getAllEmployees(); in an async function gets us our List<DataClass> item from database db.

  3. Simply Create a DriftSQLToCSV object and then use the writeToCSV() method by passing in the the List<DataClass> object as parameter to it (and optionally the CSV file name to save it as):

    // Assuming Employee is a DataClass
    final List<Employee> employees = [
        Employee(employeeID: '1', name: 'testA'),
        Employee(employeeID: '2', name: 'tenstB', phoneNo: 1203123112),
        Employee(employeeID: '3', name: 'temstC', deviceID: 'testDevice'),
        Employee(
            employeeID: '4', name: 'test,D', phoneNo: 132123124, deviceID: 's'),
      ]; // Replaced with values from database in actual implementation using select query get()
    
    // Using DriftSQLToCSV
    final DriftSQLToCSV DriftSQLToCSV = DriftSQLToCSV();
    await DriftSQLToCSV.writeToCSV(_employees, csvFileName: 'employees');

    It will do all the necessary work to export your Database to a CSV file. Example to store _employees object of type Employee table in employees.csv

  4. The method also returns a Future<File> object that can be used to perform further operations on the saved CSV.

  5. If the Database was successfully created, you will find it in:

    a. Android and IoS: Your Flutter App's internal Storage directory (eg. Android\Data\com.*.*\appName for Android), provided the permissions were given and the CSV was succesfully generated.

    b. Desktop Systems: Downloads Directory.

Dependencies

  1. Moor/Drift (with Tables and DataClasses ready). (Moor requires dependencies like moor_generator and build_runner for full functioning. Make sure you are familiar before using this package)
  2. Path Provider: To provide paths to Download folder (in desktop) and App Internal Storage Directory (in Mobile platforms) which are the only places storage of files is allowed
  3. Permission Handler: To provide Storage read/write permission on Mobile devices. Moor itself requires it too.
  4. Also uses dart:io library for file handling.

Available Methods

1. DriftSQLToCSV (Class constuctor): To create a DriftSQLToCSV object.

2. writeToCSV (Method): To write the CSV file to the device's storage. Returns a Future<File> object of the CSV file created.

3. permissionStatus / hasFileWritePermission (Getter): To get the current permission status of the app to write to storage.

Potential Contribution Ideas

  1. Implement a way to view the generated CSVs that works across platforms. Right now I can't think of any. Tested out Open package and url_launcher with failure in one or more platforms. The only way to browse the generated CSVs is to manually browse to the storage folder.

  2. Better documentation.

Getting Started

This project is a starting point for a Dart package, a library module containing code that can be shared easily across multiple Flutter or Dart projects.

For help getting started with Flutter, view our online documentation, which offers tutorials, samples, guidance on mobile development, and a full API reference.

About

A Dart/Flutter package working with Moor, that allows exporting SQL-based Moor databases to a CSV form, for external storage or sharing. Works on all platforms except Web.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages