Android Open Source - SQLiteGlue-test-Android S Q Lite Glue Test

• Back to App/test  ↑

From Project

Back to project page SQLiteGlue-test-Android.

License

The source code is released under:

This is free and unencumbered software released into the public domain. Anyone is free to copy, modify, publish, use, compile, sell, or distribute this software, either in source code form or as a co...

Java Source Code

package org.sqlg;
/*  w w w.j a v  a  2  s . c om*/
import android.app.Activity;
import android.os.Bundle;

import org.sqlg.SQLiteGlue;

import java.io.File;

public class SQLiteGlueTest extends Activity
{
  static
  {
    System.loadLibrary("sqlg");
  }

  /** Called when the activity is first created. */
  @Override
  public void onCreate(Bundle savedInstanceState)
  {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.main);

    File dbfile = new File(getFilesDir(), "DB.db");

    long mydb = SQLiteGlue.sqlg_db_open(dbfile.getAbsolutePath(),
      SQLiteGlue.SQLG_OPEN_READWRITE | SQLiteGlue.SQLG_OPEN_CREATE);

    if (mydb < 0) {
      android.util.Log.w("SQLiteGlueTest", "DB open error: " + -mydb);
      return;
    }

    long st = SQLiteGlue.sqlg_db_prepare_st(mydb, "select upper('How about ascii text?') as caps");

    if (st < 0) {
      android.util.Log.w("SQLiteGlueTest", "prepare statement error: " + -st);
      SQLiteGlue.sqlg_db_close(mydb);
      return;
    }

    SQLiteGlue.sqlg_st_step(st);

    int colcount = SQLiteGlue.sqlg_st_column_count(st);
    android.util.Log.i("SQLiteGlueTest", "column count: " + colcount);

    String colname = SQLiteGlue.sqlg_st_column_name(st, 0);
    android.util.Log.i("SQLiteGlueTest", "column name: " + colname);

    int coltype = SQLiteGlue.sqlg_st_column_type(st, 0);
    android.util.Log.i("SQLiteGlueTest", "column type: " + coltype);

    String first = SQLiteGlue.sqlg_st_column_text(st, 0);

    android.util.Log.i("SQLiteGlueTest", "upper: " + first);

    SQLiteGlue.sqlg_st_finish(st);

    st = SQLiteGlue.sqlg_db_prepare_st(mydb, "drop table if exists test_table;");
    if (st < 0) {
      android.util.Log.w("SQLiteGlueTest", "prepare statement error: " + -st);
      SQLiteGlue.sqlg_db_close(mydb);
      return;
    }
    SQLiteGlue.sqlg_st_step(st);
    SQLiteGlue.sqlg_st_finish(st);

    // source: https://github.com/pgsqlite/PG-SQLitePlugin-iOS
    st = SQLiteGlue.sqlg_db_prepare_st(mydb, "CREATE TABLE IF NOT EXISTS test_table (id integer primary key, data text, data_num integer)");
    if (st < 0) {
      android.util.Log.w("SQLiteGlueTest", "prepare statement error: " + -st);
      SQLiteGlue.sqlg_db_close(mydb);
      return;
    }
    SQLiteGlue.sqlg_st_step(st);
    SQLiteGlue.sqlg_st_finish(st);

    st = SQLiteGlue.sqlg_db_prepare_st(mydb, "INSERT INTO test_table (data, data_num) VALUES (?,?)");
    if (st < 0) {
      android.util.Log.w("SQLiteGlueTest", "prepare statement error: " + -st);
      SQLiteGlue.sqlg_db_close(mydb);
      return;
    }
    SQLiteGlue.sqlg_st_bind_text(st, 1, "test");
    SQLiteGlue.sqlg_st_bind_int(st, 2, 100);
    int sr = SQLiteGlue.sqlg_st_step(st);
    while (sr == 100) {
      android.util.Log.i("SQLiteGlueTest", "step next");
      sr = SQLiteGlue.sqlg_st_step(st);
    }
    android.util.Log.i("SQLiteGlueTest", "last step " + sr);
    SQLiteGlue.sqlg_st_finish(st);

    st = SQLiteGlue.sqlg_db_prepare_st(mydb, "select * from test_table;");
    if (st < 0) {
      android.util.Log.w("SQLiteGlueTest", "prepare statement error: " + -st);
      SQLiteGlue.sqlg_db_close(mydb);
      return;
    }

    sr = SQLiteGlue.sqlg_st_step(st);
    while (sr == 100) {
      android.util.Log.i("SQLiteGlueTest", "step next");

      colcount = SQLiteGlue.sqlg_st_column_count(st);
      android.util.Log.i("SQLiteGlueTest", "column count: " + colcount);

      for (int i=0;i<colcount;++i) {
        colname = SQLiteGlue.sqlg_st_column_name(st, i);
        android.util.Log.i("SQLiteGlueTest", "column " + i + " name: " + colname);

        coltype = SQLiteGlue.sqlg_st_column_type(st, i);
        android.util.Log.i("SQLiteGlueTest", "column " + i + " type: " + coltype);

        String text = SQLiteGlue.sqlg_st_column_text(st, i);
        android.util.Log.i("SQLiteGlueTest", "col " + i + " text " + text);
      }

      sr = SQLiteGlue.sqlg_st_step(st);
    }
    android.util.Log.i("SQLiteGlueTest", "last step " + sr);

    SQLiteGlue.sqlg_st_finish(st);

    SQLiteGlue.sqlg_db_close(mydb);
  }
}

Java Source Code List

• Back to App/test  ↑