@wuilmerj24/sqlite-secure

This a library for nativescript, compatible whit Android and iOS that provides transparent 256-bit AES encryption for SQLite database files. It ensures that data stored in the database is secure and protected from unauthorized access.

Install

npm install @wuilmerj24/sqlite-secure

Usage

| Method | Params | Description | | ------ | ------ | ----------- | | createDb():SqliteSecure | null | Initializes the creation of a new database. | | deleteDb(dbname:string) | dbname:string | Deletes the specified database. Returns true if the database was successfully deleted, otherwise returns false | | openDb(): any | null | For open database connection | | isOpen(): boolean | null | Check state connection.| | setVersion(version: number) | version:number | Change the version of db. | | getVersion():number | null | Get the current version of db | | execute(query: string, args?: any[]): any | query:string,args?: any[] | Executes a SQL query on the database. This method is used for running queries that modify data or schema, such as INSERT, UPDATE, or DELETE | select(query, args?: any[]):any | query, args?: any[] | Executes a SQL SELECT query on the database and returns the results. This method is used for retrieving data from the database based on the specified query. | | close():boolean | null | To close de connection db |

Examples

import { SqliteSecure } from '@wuilmerj24/sqlite-secure';
//Use
const sqlite: SqliteSecure = new SqliteSecure('dbname.db', 'password', 100);

//create db
sqlite.createDb();

// If need
sqlite.openDb();

// check connection to db is open
sqlite.isOpen();

// delete db
const delete_res = sqlite.deleteDb('dbname.db'); //return a boolean

// change db version
sqlite.setVersion(2000);

// get current db version
const version=sqlite.getVersion() // return number

// execute sql
const query = `CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT,age INTEGER)`;
sqlite.execute(query);

// insert 
const query = `INSERT INTO users (name,age) VALUES(?,?)`;
const res =await sqlite.execute(query, ['name', 25]);

// select
const query = `SELECT * FROM users`;
const result = await sqlite.select(query);

//select whit params 
const query = `SELECT * FROM users WHERE id=?`;
const result = await sqlite.select(query, [1]);

// execute sql
const query = `DROP TABLE IF EXISTS users`;
const result = await sqlite.execute(query);

// execute sql 
const query = `DELETE FROM users`;
const result = await sqlite.execute(query);

// execute sql
const query = `DELETE FROM users WHERE id=?`;
const result = await sqlite.execute(query, [1]);

// execute sql
const query = `UPDATE users SET age =?`;
const result = await sqlite.execute(query, [15]);

// execute sql 
const query = `UPDATE users SET name =? WHERE id = ?`;
const result = await sqlite.execute(query, ['name', 4]);

// close 
const result = sqlite.close() return a boolean;

License

Apache License Version 2.0