Skip to content

Instantly share code, notes, and snippets.

@infinitbility
Created April 1, 2020 15:30
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/b752652af162071f5a3b092cc9910e36 to your computer and use it in GitHub Desktop.
Save infinitbility/b752652af162071f5a3b092cc9910e36 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);
});
});
});
/**
* Example Of update query
*/
async UpdateQuery(){
let updateQuery = await this.ExecuteQuery('UPDATE users SET first_name = ? , last_name = ? WHERE id = ?', ["Doctor", "Strange", 3]);
console.log(updateQuery);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment