andpor / react-native-sqlite-storage Goto Github PK

params.push((v === null || v === void 0 || t === 'number' || t === 'string' ? v : v instanceof Blob ? v.valueOf() : v.toString()));

Expected receiver of type org.json.JSONArray, but got java.lang.reflect.Field

var SQLite = require('react-native-sqlite-storage');
function errorCB(err) {
  console.log("SQL Error: " + err);
}

function successCB() {
  console.log("SQL executed fine");
}

function openCB() {
  console.log("Database OPENED");
}

var db = SQLite.openDatabase("test.db", "1.0", "Test Database", 200000, openCB, errorCB);
db.executeSql("DROP TABLE IF EXISTS tt");
db.executeSql("CREATE TABLE tt (data)");
db.transaction((tx) => {
  tx.executeSql("INSERT INTO tt values (?)", 'something', successCB, errorCB);
}, (err) => {
  console.log('transaction error: ', err.message);
}, () => {
  db.executeSql('select count(*) from tt', [], (res) => {
    console.log('got count: ', JSON.stringify(res.rows.item(0)));
  }, (err) => {
    console.log('error getting count: ', err.message);
  });
});

var db = SQLite.openDatabase("test.db", "1.0", "Test Database", 200000, openCB, errorCB);
db.executeSql("DROP TABLE IF EXISTS tt");
db.executeSql("CREATE TABLE tt (data)");
db.transaction((tx) => {
  // tx.executeSql("INSERT INTO tt values (?)", 'something', successCB, errorCB);
  tx.executeSql("SELECT LENGTH('tenletters') AS stringlength", [], function(tx, res) {
    console.log('got stringlength: ' + res.rows.item(0).stringlength);
  });
}, (err) => {
  console.log('transaction error: ', err.message);
});

JS server already running.
Building and installing the app on the device (cd android && ./gradlew installDebug)...

FAILURE: Build failed with an exception.

* Where:
Build file '/media/Storage/easyship/android/build.gradle' line: 9

* What went wrong:
A problem occurred evaluating root project 'easyship'.
> Could not find method compile() for arguments [project ':react-native-sqlite-storage'] on org.gradle.api.internal.artifacts.dsl.dependencies.DefaultDependencyHandler_Decorated@501df9bd.

* Try:
Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output.

BUILD FAILED

Total time: 1.629 secs
Could not install the app on the device, read the error above for details.
Make sure you have an Android emulator running or a device connected and have
set up your Android development environment:
https://facebook.github.io/react-native/docs/android-setup.html

with the location option set to one the following choices (affects iOS only):
0 (default): Documents - visible to iTunes and backed up by iCloud
1: Library - backed up by iCloud, NOT visible to iTunes
2: Library/LocalDatabase - NOT visible to iTunes and NOT backed up by iCloud (same as using "default")

Undefined symbols for architecture x86_64:
  "_sqlite3_bind_double", referenced from:
      -[SQLite bindStatement:withArg:atIndex:] in SQLite.o
      -[SQLite bindStatement:withArg:atIndex:] in libSQLite.a(SQLite.o)
  "_sqlite3_bind_int", referenced from:
      -[SQLite bindStatement:withArg:atIndex:] in SQLite.o
      -[SQLite bindStatement:withArg:atIndex:] in libSQLite.a(SQLite.o)
  "_sqlite3_bind_int64", referenced from:
      -[SQLite bindStatement:withArg:atIndex:] in SQLite.o
      -[SQLite bindStatement:withArg:atIndex:] in libSQLite.a(SQLite.o)
  "_sqlite3_bind_null", referenced from:
      -[SQLite bindStatement:withArg:atIndex:] in SQLite.o
      -[SQLite bindStatement:withArg:atIndex:] in libSQLite.a(SQLite.o)
  "_sqlite3_bind_text", referenced from:
      -[SQLite bindStatement:withArg:atIndex:] in SQLite.o
      -[SQLite bindStatement:withArg:atIndex:] in libSQLite.a(SQLite.o)
  "_sqlite3_close", referenced from:
      -[SQLite close:success:error:] in SQLite.o
      -[SQLite dealloc] in SQLite.o
      -[SQLite close:success:error:] in libSQLite.a(SQLite.o)
      -[SQLite dealloc] in libSQLite.a(SQLite.o)
  "_sqlite3_column_blob", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in SQLite.o
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_column_bytes", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in SQLite.o
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_column_count", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in SQLite.o
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_column_double", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in SQLite.o
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_column_int64", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in SQLite.o
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_column_name", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in SQLite.o
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_column_text", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in SQLite.o
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_column_type", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in SQLite.o
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_create_function", referenced from:
      -[SQLite open:success:error:] in SQLite.o
      -[SQLite open:success:error:] in libSQLite.a(SQLite.o)
  "_sqlite3_errcode", referenced from:
      +[SQLite captureSQLiteErrorFromDb:] in SQLite.o
      +[SQLite captureSQLiteErrorFromDb:] in libSQLite.a(SQLite.o)
  "_sqlite3_errmsg", referenced from:
      +[SQLite captureSQLiteErrorFromDb:] in SQLite.o
      +[SQLite captureSQLiteErrorFromDb:] in libSQLite.a(SQLite.o)
  "_sqlite3_exec", referenced from:
      -[SQLite open:success:error:] in SQLite.o
      -[SQLite open:success:error:] in libSQLite.a(SQLite.o)
  "_sqlite3_finalize", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in SQLite.o
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_last_insert_rowid", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in SQLite.o
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_open", referenced from:
      -[SQLite open:success:error:] in SQLite.o
      -[SQLite open:success:error:] in libSQLite.a(SQLite.o)
  "_sqlite3_prepare_v2", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in SQLite.o
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_result_error", referenced from:
      _sqlite_regexp in SQLite.o
      _sqlite_regexp in libSQLite.a(SQLite.o)
  "_sqlite3_result_int", referenced from:
      _sqlite_regexp in SQLite.o
      _sqlite_regexp in libSQLite.a(SQLite.o)
  "_sqlite3_step", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in SQLite.o
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_threadsafe", referenced from:
      -[SQLite open:success:error:] in SQLite.o
      -[SQLite open:success:error:] in libSQLite.a(SQLite.o)
  "_sqlite3_total_changes", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in SQLite.o
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_value_text", referenced from:
      _sqlite_regexp in SQLite.o
      _sqlite_regexp in libSQLite.a(SQLite.o)
ld: symbol(s) not found for architecture x86_64
clang: error: linker command failed with exit code 1 (use -v to see invocation)

'use strict';
import React, { Component } from 'react';
import {
  AppRegistry,
  StyleSheet,
  Text,
  View,
  TabBarIOS,
  NavigatorIOS,
} from 'react-native';

import SQLite from 'react-native-sqlite-storage';
SQLite.DEBUG(true);

var Courses = require("./courses.ios");
var Evaluation = require("./evaluation.ios");
var Schedule = require("./schedule.ios");
var More = require("./more.ios");
var Register = require("./register.ios");
var Login = require("./login.ios");
var AuthService = require("./AuthService");

class OpenCampus extends Component {

  constructor(props){
    super(props);
    this.state = {
      selectedTab: 'courses',
      isLoggedIn: false,
    };
  }

  /////// Database
  callDB(){
    SQLite.open("oc.db", function(error, database){
      if (error) {
        console.log("Failed to open database:", error);
        return;
      }
    });
  }
  /////// End Database


  onLogin(results) {
    this.setState({
      isLoggedIn: true,
    });
  }

  render() {
    callDB();

    if(!this.state.isLoggedIn){
      return(
        <Login onLogin={this.onLogin.bind(this)} />
      );
    } else {

      return(
        <TabBarIOS
        selectedTab={this.state.selectedTab}
        >

        <TabBarIOS.Item
        icon={{uri: 'courses.png', scale: 5}}
        title="Courses"
        badge={undefined}
        selected={this.state.selectedTab === 'courses'}
        onPress={() => {
          this.setState({
            selectedTab: 'courses',
          });
        }}>
        <Courses />
        </TabBarIOS.Item>

        <TabBarIOS.Item
        icon={{uri: 'register.png', scale: 5}}
        title="Register"
        badge={undefined}
        selected={this.state.selectedTab === 'register'}
        onPress={() => {
          this.setState({
            selectedTab: 'register',
          });
        }}>
        <Register />
        </TabBarIOS.Item>

        <TabBarIOS.Item
          title="Evaluation"
          icon={{uri: 'evaluate.png', scale: 10}}
          badge={undefined}
          selected={this.state.selectedTab === 'evaluation'}
          onPress={() => {
            this.setState({
              selectedTab: 'evaluation',
            });
          }}>
          <Evaluation />
          </TabBarIOS.Item>

          <TabBarIOS.Item
            title="Schedule"
            icon={{uri: 'schedule.png', scale: 5}}
            badge={undefined}
            selected={this.state.selectedTab === 'schedule'}
            onPress={() => {
              this.setState({
                selectedTab: 'schedule',
              });
            }}>
            <Schedule />
            </TabBarIOS.Item>

            <TabBarIOS.Item
              systemIcon="more"
              badge={undefined}
              selected={this.state.selectedTab === 'more'}
              onPress={() => {
                this.setState({
                  selectedTab: 'more',
                });
              }}>
              <More />
              </TabBarIOS.Item>

        </TabBarIOS>
      );
    }
  }
}

AppRegistry.registerComponent('OpenCampus', () => OpenCampus);

render(){
SQLite.open("oc.db", function(error, database){
      if (error) {
        console.log("Failed to open database:", error);
        return;
      }
    });
.
.
.

MainActivity.java:40: error: constructor SQLitePluginPackage in class SQLitePluginPackage cannot be applied to given types;
            new SQLitePluginPackage()
            ^
  required: Activity
  found: no arguments
  reason: actual and formal argument lists differ in length
1 error
:app:compileDebugJavaWithJavac FAILED

Undefined symbols for architecture x86_64:
  "_sqlite3_bind_double", referenced from:
      -[SQLite bindStatement:withArg:atIndex:] in libSQLite.a(SQLite.o)
  "_sqlite3_bind_int", referenced from:
      -[SQLite bindStatement:withArg:atIndex:] in libSQLite.a(SQLite.o)
  "_sqlite3_bind_int64", referenced from:
      -[SQLite bindStatement:withArg:atIndex:] in libSQLite.a(SQLite.o)
  "_sqlite3_bind_null", referenced from:
      -[SQLite bindStatement:withArg:atIndex:] in libSQLite.a(SQLite.o)
  "_sqlite3_bind_text", referenced from:
      -[SQLite bindStatement:withArg:atIndex:] in libSQLite.a(SQLite.o)
  "_sqlite3_close", referenced from:
      -[SQLite close:success:error:] in libSQLite.a(SQLite.o)
      -[SQLite dealloc] in libSQLite.a(SQLite.o)
  "_sqlite3_column_blob", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_column_bytes", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_column_count", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_column_double", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_column_int64", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_column_name", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_column_text", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_column_type", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_create_function", referenced from:
      -[SQLite open:success:error:] in libSQLite.a(SQLite.o)
  "_sqlite3_errcode", referenced from:
      +[SQLite captureSQLiteErrorFromDb:] in libSQLite.a(SQLite.o)
  "_sqlite3_errmsg", referenced from:
      +[SQLite captureSQLiteErrorFromDb:] in libSQLite.a(SQLite.o)
  "_sqlite3_exec", referenced from:
      -[SQLite open:success:error:] in libSQLite.a(SQLite.o)
  "_sqlite3_finalize", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_last_insert_rowid", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_open", referenced from:
      -[SQLite open:success:error:] in libSQLite.a(SQLite.o)
  "_sqlite3_prepare_v2", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_result_error", referenced from:
      _sqlite_regexp in libSQLite.a(SQLite.o)
  "_sqlite3_result_int", referenced from:
      _sqlite_regexp in libSQLite.a(SQLite.o)
  "_sqlite3_step", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_threadsafe", referenced from:
      -[SQLite open:success:error:] in libSQLite.a(SQLite.o)
  "_sqlite3_total_changes", referenced from:
      -[SQLite executeSqlWithDict:andArgs:] in libSQLite.a(SQLite.o)
  "_sqlite3_value_text", referenced from:
      _sqlite_regexp in libSQLite.a(SQLite.o)
ld: symbol(s) not found for architecture x86_64
clang: error: linker command failed with exit code 1 (use -v to see invocation)

  try {
    db = await SQLite.openDatabase('test.db');
    await db.transaction(tx => {
        tx.executeSql('INCORRECT SQL');
    });
  }
  catch (e) {
   // Never called, the transaction has been committed
    console.log(e);
  } 

aFunction: function(){
  DBHelper.doSomething("SQL HERE", this.successCB, this.errorCB)
},

successCB: function(response){
  // intentional crash..
  var x = b;
  // this error does not trigger a RSOD.
},

errorCB: function(){
},

-(void)dealloc
{
  int i;
  NSArray *keys = [openDBs allKeys];
  NSDictionary *dbInfo;
  NSString *key;
  sqlite3 *db;

  /* close db the user forgot */
  for (i=0; i<[keys count]; i++) {
    key = [keys objectAtIndex:i];
    dbInfo = [openDBs objectForKey:key];
    db = [((NSValue *) dbInfo[@"dbPointer"]) pointerValue];
    sqlite3_close (db);
  }

#if !__has_feature(objc_arc)
  [openDBs release];
  [appDBPaths release];
  [super dealloc];
#endif
}

2016-05-01 18:37:32.774 [info][tid:com.facebook.React.JavaScript] OPEN database: fufm.db
2016-05-01 18:37:32.775 [info][tid:com.facebook.React.JavaScript] SQLite.open({"name":"fufm.db","dblocation":"docs"})
2016-05-01 18:37:32.784 fufmapp[2442:98559] using db location: docs
2016-05-01 18:37:32.784 fufmapp[2442:98559] open full db path: /Users/Bing/Library/Developer/CoreSimulator/Devices/EA31E7E2-57FC-47DE-9FC5-82624C501283/data/Containers/Data/Application/160C3855-0D8B-4820-A8EB-17DA0B783B4C/Documents/fufm.db

11-17 12:20:43.383 28403-28502/com.reactapp V/sqlg: sqlc_st_column_name 0xb3ac4928 1
11-17 12:20:43.383 28403-28502/com.reactapp V/sqlg: sqlc_st_column_type 0xb3ac4928 1
11-17 12:20:43.383 28403-28502/com.reactapp V/sqlg: sqlc_st_column_name 0xb3ac4928 3

var db = SQLite.openDatabase("test.db", "1.0", "Test Database", 200000, openCB, errorCB);
db.transaction((tx) => {
  tx.executeSql('SELECT * FROM testdb', [], (tx, results) => {
      console.log("Query completed");
    });
});

npm WARN peerDependencies The peer dependency react-native@>=0.14.0 included from react-native-sqlite-storage will no
npm WARN peerDependencies longer be automatically installed to fulfill the peerDependency 
npm WARN peerDependencies in npm 3+. Your application will need to depend on it explicitly.
npm ERR! Linux 3.19.0-42-generic
npm ERR! argv "/usr/bin/nodejs" "/usr/bin/npm" "install" "--save" "react-native-sqlite-storage"
npm ERR! node v4.2.4
npm ERR! npm  v2.14.12
npm ERR! code EPEERINVALID

npm ERR! peerinvalid The package [email protected] does not satisfy its siblings' peerDependencies requirements!
npm ERR! peerinvalid Peer [email protected] wants react-native@>=0.14.0

var database_name = "authio-verity.db";
var database_version = "1.0";
var database_displayname = "Authio Database";
var database_size = 200000;
var database_current_version = 0;
var database_latest_version = 1;
var database_ready_callback = null;
var db;

var AuthioDB = {
    openErrorCallback() {
        database_ready_callback(false);
    },

    openDatabase(readyCallback) {
        var that = this;
        database_ready_callback = readyCallback;
        db = SQLite.openDatabase(database_name, database_version, database_displayname, database_size, function() {
            that.populateDatabase(db);
        }, this.openErrorCallback);
    },

    populateDatabase(db){
        var that = this;

        db.executeSql('SELECT version_id FROM Version ORDER BY version_id DESC LIMIT 1', [], function(results) {
            console.log("Post version query (success)");
            var len = results.rows.length;
            for (let i = 0; i < len; i++) {
                let row = results.rows.item(i);
                database_current_version = row.version_id;
            }

            this.setState(this.state);

            db.transaction(that.upgradeTables, function() {
                database_ready_callback(false);
            }, function() {
                database_ready_callback(true);
            });

        }, function() {
            console.log("Post version query (failed)");
            db.transaction(that.upgradeTables, function() {
                database_ready_callback(false);
            }, function() {
                console.log("Upgrade success");
                database_ready_callback(true);
            });
        });

        //database_ready_callback(true);
    },

    upgradeTables(tx) {
        console.log("Database running version "+database_current_version);
        if(database_current_version < 1) {
            tx.executeSql("CREATE TABLE IF NOT EXISTS Version ( " +
                "version_id INTEGER PRIMARY KEY" +
                ");", []);
            tx.executeSql("CREATE TABLE IF NOT EXISTS Service (" +
                "id INTEGER PRIMARY KEY, " +
                "name TEXT" +
                ");", []);
            tx.executeSql("INSERT INTO Version (version_id) VALUES (?)", [1]);
        }
    },

    addService(callback, obj) {
        var that = this;
        db.transaction(tx).then(() => {
            callback(true);
        });
    },

    addAccountTransaction(tx, obj) {
        tx.executeSql("INSERT INTO Service (name) VALUES (?)", [obj.name]);
    },

    getServices(callback) {
        db.executeSql("SELECT id FROM Service", [], function(results) {
            console.log("Got service results "+JSON.stringify(results));
            var len = results.rows.length;
            console.log("len = "+len);
            for (var i = 0; i < len; i++) {
                let row = results.row.item(i);
                console.log("row "+i+" = "+row.id);
            }

            callback(results);
        });
    },

    executeQuery(query, params) {
        console.log("Executing query "+query);
        return db.executeSql(query, params);
    },

    executeQueryCallback(query, params, callbackSuccess, callbackFailure) {
        db.executeSql(query, params, callbackSuccess, callbackFailure);
    },

    executeTransaction(func, callback) {
        console.log("Executing transaction on AuthioDB");
        db.transaction(func).then((results) => {
            callback(true, results);
        }).catch((error) => {
            callback(false);
        });
    },
    closeDatabase(){
        var that = this;
        if (db) {
            console.log("Closing database ...");
            //db.close();
        } else {
        }
    },

    getDbResource() {
        return db;
    }
}