import 'package:sqflite/sqflite.dart';
import 'dart:async';
import 'dart:io';
import 'package:path_provider/path_provider.dart';
import '../models/note.dart';
import 'package:path/path.dart';
class DatabaseHelper {
static DatabaseHelper _databaseHelper; //Singleton DatabaseHelper
static Database _database; //Singleton Database
//Database table name along with column name
String noteTable = 'note_table';
String colId = 'id';
String colTitle = 'title';
String colDescription = 'description';
String colPriority = 'priority';
String colDate = 'date';
DatabaseHelper._createInstance();
factory DatabaseHelper() {
if (_databaseHelper == null) {
_databaseHelper = DatabaseHelper._createInstance();
}
return _databaseHelper;
}
Future<Database> get database async {
if (_database == null) {
_database = await intializeDatabase();
}
return _database;
}
Future<Database> intializeDatabase() async {
Directory directory = await getApplicationDocumentsDirectory();
String path = join(directory.path, 'notes.db');
var notesDatabase = openDatabase(path, version: 1, onCreate: _createDb);
return notesDatabase;
}
void _createDb(Database db, int newVersion) async {
await db.execute(
'CREATE TABLE $noteTable($colId INTEGER PRIMARY KEY AUTOINCREMENT, $colTitle TEXT, '
'$colDescription TEXT, $colPriority INTEGER, $colDate TEXT)');
}
//Fetch Operation :Get all Noteobject from database
Future<List<Map<String, dynamic>>> getNoteMapList() async {
Database db = await this.database;
//var result= db.rawQuery('SELECT * FROM $noteTable order by $colPriority ASC');
var result = db.query(noteTable, orderBy: '$colPriority ASC');
return result;
}
//Insert Operation :Insert a Noteboject to database
Future<int> insertNote(Note note) async {
Database db = await this.database;
var result = await db.insert(noteTable, note.toMap());
return result;
}
//Update Operation :Update a Note object and save it to Database
Future<int> updateNote(Note note) async {
var db = await this.database;
var result = await db.update(noteTable, note.toMap(),
where: '$colId =?', whereArgs: [note.id]);
return result;
}
//Delete Operation :Delete a Note object from DataBase
Future<int> deleteNote(int id) async {
var db = await this.database;
var result = await db.rawDelete('DELETE FROM $noteTable WHERE $colId =$id');
return result;
}
//Get number of objects
Future<int> getCount() async {
Database db = await this.database;
List<Map<String, dynamic>> x=await db.rawQuery('SELECT COUNT (*) from $noteTable');
int result =Sqflite.firstIntValue(x);
return result;
}
}