import { DBNAME,DBPATH } from '@/common/config.js'

function openSqlite() {
	return new Promise((resolve, reject) => {
		plus.sqlite.openDatabase({
			name: DBNAME,
			path: DBPATH,
			success: e => {
				resolve(e)
			},
			fail: err => {
				reject(err)
			}
		})
	})
}

function closeSqlite() {
	return new Promise((resolve, reject) => {
		plus.sqlite.closeDatabase({
			name: DBNAME,
			success: () => {
				resolve()
			},
			fail: () => {
				reject()
			}
		})
	})
}

function isOpenSqlite() {
	return plus.sqlite.isOpenDatabase({
		name: DBNAME,
		path: DBPATH
	})
}

function executeSql(sql){
	return new Promise((resolve,reject) => {
		plus.sqlite.executeSql({
			name:DBNAME,
			sql,
			success:e => {
				resolve(e)
			},
			fail: err => {
				reject(err)
			}
		})
	})
}

function selectFromTable(sql){
	return new Promise((resolve,reject) => {
		plus.sqlite.selectSql({
			name:DBNAME,
			sql,
			success:e => {
				resolve(e)
			},
			fail:err => {
				reject(err)
			}
		})
	})
}

export {
	openSqlite,
	closeSqlite,
	isOpenSqlite,
	executeSql,
	selectFromTable,
}