db

import { openDatabase,enablePromise } from ‘react-native-sqlite-storage’;

enablePromise(true);

export const getdbConnection = async()=>{

 

vardb = openDatabase({name:’agribridge_farmer.db’, location:”default”}, (success) => {

// alert()

returnsuccess;

},

(error) => {

console.log(‘Error opening database: ‘ + error.message);

});

returndb;

}

export const DbService = async(query,params)=>{

vardb = awaitgetdbConnection();

console.log(db)

returndb.executeSql(query,params);

 

}

export const createTable = async()=>{

constquery = ‘CREATE TABLE IF NOT EXISTS tbl_farmer_update_report(id INTEGER PRIMARY KEY AUTOINCREMENT, farmerupdateOBJ MEDIUMBLOB,frm_id INTEGER,cfa_id INTEGER, showingOBJ MEDIUMBLOB)’;

vardb = awaitgetdbConnection();

returndb.executeSql(query);

}

// export const createCropStageTable = async()=>{

// const query = ‘CREATE TABLE IF NOT EXISTS tbl_farmer_crop_stage(id INTEGER PRIMARY KEY AUTOINCREMENT, stageobj MEDIUMBLOB)’;

// var db = await getdbConnection();

// return db.executeSql(query);

// }

export const DbServiceNew = {

// Create a table

query: (query, params) => {

// Promise added to handle async calls

returnnewPromise(async(resolve, reject) => {

vardb = awaitgetdbConnection();

db.transaction(function (txn) {

txn.executeSql(

query,

params,

function (tx, response) {

resolve(response);

},

function (tx, error) {

reject(error);

},

);

});

});

},

};