A small library to properly open a sqflite DB and handle the migrations.
- Uses transactions for all schema changes.
- Almost identical interface to sqflite.openDatabase()
Example usage #
import 'package:sqflite_helper/sqflite_helper.dart'; import 'package:sqflite/sqflite.dart'; Database db = openMigratedDatabase("path/to/db.db", [ """CREATE TABLE mytable (name varchar);""", """ALTER TABLE mytable RENAME TO users;""", ] );
All notable changes to this project will be documented in this file.
[0.1.0] - 2019-08-3
- openMigratedDatabase wrapper.
Use this package as a library
1. Depend on it
Add this to your package's pubspec.yaml file:
dependencies: sqflite_helper: ^0.1.1
2. Install it
You can install packages from the command line:
$ flutter pub get
Alternatively, your editor might support
flutter pub get.
Check the docs for your editor to learn more.
3. Import it
Now in your Dart code, you can use:
Describes how popular the package is relative to other packages. [more]
Code health derived from static analysis. [more]
Reflects how tidy and up-to-date the package is. [more]
Weighted score of the above. [more]
We analyzed this package on Oct 20, 2019, and provided a score, details, and suggestions below. Analysis was completed with status completed using:
- Dart: 2.5.1
- pana: 0.12.21
- Flutter: 1.9.1+hotfix.4
Detected platforms: Flutter
References Flutter, and has no conflicting libraries.
Health issues and suggestions
Document public APIs. (-1 points)
2 out of 2 API elements have no dartdoc comment.Providing good documentation for libraries, classes, functions, and other API elements improves code readability and helps developers find and use your API.
flutter format to format
Maintain an example. (-10 points)
Create a short demo in the
example/ directory to show how to use this package.
Common filename patterns include
sqflite_helper.dart. Packages with multiple examples should provide
For more information see the pub package layout conventions.