react-native-fts-sqlite-library
Typescript Support
Getting started
$ npm install react-native-fts-sqlite-library --save
Mostly automatic installation
$ react-native link react-native-fts-sqlite-library
Manual installation
Android
- Open up
android/app/src/main/java/[...]/MainActivity.java
- Add
import com.fts.RNFtsSqliteLibraryPackage;
to the imports at the top of the file - Add
new RNFtsSqliteLibraryPackage()
to the list returned by thegetPackages()
method
- Append the following lines to
android/settings.gradle
:include ':react-native-fts-sqlite-library' project(':react-native-fts-sqlite-library').projectDir = new File(rootProject.projectDir, '../node_modules/react-native-fts-sqlite-library/android')
- Insert the following lines inside the dependencies block in
android/app/build.gradle
:compile project(':react-native-fts-sqlite-library')
Usage
Create Table
; let error = null; let DBClient = null; try DBClient = await RNFtsSqliteLibrary; catcherr error = err; try await DBClient; catcherr error = err; try await DBClient; catcherr error = err; try await DBClient; catcherr error = err; if error try await DBClient; console; catcherr console; try await DBClient; catcherr console; return; try await DBClient; catcherr console; try await DBClient; catcherr console;
Insert
; let error = null; let DBClient = null; try DBClient = await RNFtsSqliteLibrary; catcherr error = err; const tableManager = DBClienttableManager; try await tableManager; catcherr error = err; const createdAt = ; const car1ToSave = model: 'Volkswagen' brand: 'Jetta GLI' year: type: 'date' value: '2018' format: 'YYYY' //moment format created_at: type: 'date' value: createdAt format: 'YYYY-MM-DD HH:mm:ss.SSS' //moment format; let car1Id; try car1Id = await tableManager; if car1Id && Numbercar1Id < 1 error = "insert fail"; catcherr error = err; const inventory1ToSave = total: 290 car_id: car1Id; try let inventory1Id = await tableManager; if inventory1Id && Numberinventory1Id < 1 error = "insert fail"; catcherr error = err; const car2ToSave = model: 'Mercedes' brand: 'A 200' year: type: 'date' value: '2019' format: 'YYYY' //moment format created_at: type: 'date' value: createdAt format: 'YYYY-MM-DD HH:mm:ss.SSS' //moment format; let car2Id; try car2Id = await tableManager; if car2Id && Numbercar2Id < 1 error = "insert fail"; catcherr error = err; const inventory2ToSave = total: 94 car_id: car2Id; try let inventory2Id = await tableManager; if inventory2Id && Numberinventory2Id < 1 error = "insert fail"; catcherr error = err; if error try await tableManager; console; catcherr console; try await DBClient; catcherr console; return; try await tableManager; catcherr console; try await DBClient; catcherr console;
Search Query
; let DBClient = null; try DBClient = await RNFtsSqliteLibrary; catcherr error = err; const tableManager = DBClienttableManager; let resultSearch1;let resultSearch2; try resultSearch1 = await tableManager; resultSearch2 = await tableManager; catcherr console; console;console; if NumberresultSearch1totalHits > 0 resultSearch1hits; if NumberresultSearch2totalHits > 0 resultSearch2hits; try await DBClient; catcherr console;
Search Criteria
//in progress
Update
; let error = null; let DBClient = null; try DBClient = await RNFtsSqliteLibrary; catcherr error = err; const tableManager = DBClienttableManager; try await tableManager; catcherr error = err; const inventoryUpdate = total: 1000; try let updatedInventory1Rows = await tableManager; if updatedInventory1Rows && NumberupdatedInventory1Rows < 1 error = "insert fail"; catcherr error = err; const carUpdate = year: type: 'date' value: '2020' format: 'YYYY' //moment format try let updatedCar1Rows = await tableManager; if updatedCar1Rows && NumberupdatedCar1Rows < 1 error = "insert fail"; catcherr error = err; if error try await tableManager; console; catcherr console; try await DBClient; catcherr console; return; try await tableManager; catcherr console; try await DBClient; catcherr console;
Delete
; let error = null; let DBClient = null; try DBClient = await RNFtsSqliteLibrary; catcherr error = err; const tableManager = DBClienttableManager; try await tableManager; catcherr error = err; try let deletedInventory1Rows = await tableManager; if deletedInventory1Rows && NumberdeletedInventory1Rows < 1 error = "insert fail"; catcherr error = err; try let deletedCar1Rows = await tableManager; if deletedCar1Rows && NumberdeletedCar1Rows < 1 error = "insert fail"; catcherr error = err; if error try await tableManager; console; catcherr console; try await DBClient; catcherr console; return; try await tableManager; catcherr console; try await DBClient; catcherr console;