use-rn-sqlite
v1.0.1
Published
React Native SQLite hooks.For now, only expo-sqlite is supported, but others will be supported in the future.
Downloads
7
Readme
use-rn-sqlite v1.0
SQLite hooks for react-native.(For now only expo-sqlite is supported.)
- Support for multiple queries in transaction
- Support for async await
Installation
This package use expo-sqlite
, so you have to download with expo-sqlite
.
$ npm install --save expo-sqlite use-rn-sqlite
Demo
https://snack.expo.io/dW-5EZHud
Usage
...
import { useRNSQLite } from 'use-rn-sqlite';
export default function App() {
const { executeSqlAsync, switchDatabase, closeDatabase } = useRNSQLite('db.db');
/* execute transaction queries */
const onInsertPress = async () => {
const result = await executeSqlAsync(
['insert into user(name,age) VALUES("user1",30);'],
(results, i) => {
const age = results[i - 1].insertId + 1;
return [`insert into user(name,age) VALUES("user2",${age});`]
},
['select * from user']
);
console.log(result);
}
/* switch database */
const onSwitchPress = () => {
switchDatabase('db2.db');
}
useEffect(() => {
executeSqlAsync([`create table if not exists user (
id integer primary key not null,
name text,
age integer
)`]);
return () => {
closeDatabase();
}
},[]);
...
}
Changelog
See CHANGELOG.md