Skip to content

Instantly share code, notes, and snippets.

@infinitbility
Created April 1, 2020 15:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save infinitbility/05b2166f30894aa85b60440d802869e8 to your computer and use it in GitHub Desktop.
Save infinitbility/05b2166f30894aa85b60440d802869e8 to your computer and use it in GitHub Desktop.
import React from 'react';
import SQLite from 'react-native-sqlite-storage';
export default class SQLiteScreen extends React.Component {
constructor() {
super();
SQLite.DEBUG = true;
}
/**
* Execute sql queries
*
* @param sql
* @param params
*
* @returns {resolve} results
*/
ExecuteQuery = (sql, params = []) => new Promise((resolve, reject) => {
db.transaction((trans) => {
trans.executeSql(sql, params, (trans, results) => {
resolve(results);
},
(error) => {
reject(error);
});
});
});
/**
* Select Query Example
*/
async SelectQuery(){
let selectQuery = await this.ExecuteQuery("SELECT * FROM users",[]);
var rows = selectQuery.rows;
for (let i = 0; i < rows.length; i++) {
var item = rows.item(i);
console.log(item);
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment