Monday, April 8, 2024

Sqflite use two model handle conflicts name (List result) in flutter

 Sqflite use two model handle conflicts name (List<Result> result) in flutter


import 'dart:convert';
import 'dart:io';


import 'package:healthtick/model/user_model.dart';
import 'package:healthtick/model/vendor_dj_model.dart';
import 'package:path_provider/path_provider.dart';
import 'package:sqflite/sqflite.dart';
import 'package:path/path.dart';

import 'package:healthtick/model/vendor_dj_model.dart' as vendor_dj_model;
import 'package:healthtick/model/book_model.dart' as book_model;


class DbHandler {
Database?
_database;

Future<Database?>
get database async {
if (_database != null) {
return _database;
}

// Create Database file in your mobile
Directory directory = await getApplicationDocumentsDirectory();
String path = join(directory.
path, "mydatabase.db");

// open & create table in database file
_database = await openDatabase(path, version: 1, onCreate: (db, version) {
db.execute(
'''
CREATE TABLE DatabaseTable(
id INTEGER PRIMARY KEY,
name TEXT,
age INTEGER
)
''');
db.execute(
'''
CREATE TABLE Bt(
id INTEGER PRIMARY KEY,
book TEXT,
price INTEGER
)
''');
db.execute(
'''
CREATE TABLE Bt2(
id INTEGER PRIMARY KEY,
book TEXT,
price INTEGER
)
''');
});
return _database!;
}

Future<int> insertBook(book_model.Result book) async {
Database? db =
await database;
return await db!.insert('books', book.toJson());
}

Future<int>
insertVendorDj(vendor_dj_model.Result vendorDj) async {
Database? db =
await database;
return await db!.insert('vendor_djs', vendorDj.toJson());
}


}

No comments:

Post a Comment

Featured post

Compress Image With Show File Size & Resolution in Flutter

 Compress Image With Show File Size & Resolution  1.Multiple File Image Compress with file Size import 'dart:io' ; import 'p...

LightBlog