Pfthb

I am trying to use an already existing sqLite database in my android app. I have verified that it is loaded into the project in the assets folder and I can browse it in DB browser when I open it directly from the project.

This is the schema for the table I am trying to query

CREATE TABLE "ACTIVITY_LIST_TBL" ( 
`_ID` INTEGER NOT NULL, 
`ACT_NAME` VARCHAR NOT NULL, 
`ACT_CODE` VARCHAR, 
`IS_ACTIVE` INTEGER DEFAULT -1, 
PRIMARY KEY(`_ID`) )

Below is the activity that creates the sqlite helper and then on a button click I execute a query on the ACTIVITY_LIST_TBL. When the query is executed this exception is thrown:

android.database.sqlite.SQLiteException: no such table: ACTIVITY_LIST_TBL (code 1 SQLITE_ERROR): , while compiling: SELECT * FROM ACTIVITY_LIST_TBL

class CalendarActivity : AppCompatActivity() {

private var cursor:Cursor? = null

override fun onCreate(savedInstanceState:Bundle?) {
 super.onCreate(savedInstanceState)
 setContentView(R.layout.calendar_activity)

 findViewById<Button>(R.id.CalTestButton).setOnClickListener 

 val myDbHelper = DatabaseHelper(this)

 try myDbHelper.createDataBase() 
 catch (ioE: IOException) throw Error("Unable to create database") 

 try myDbHelper.openDataBase() 
 catch (sqlE: SQLException) throw sqlE 

 Toast.makeText(this, "Successfully Imported", Toast.LENGTH_SHORT).show()

 cursor = myDbHelper.query("ACTIVITY_LIST_TBL", null, null, null, null, null, null)

 cursor?.let 
 if (cursor!!.moveToFirst()) 
 do 
 Toast.makeText(this,
 "ACTIVITY_ID: " + cursor!!.getString(0) + "n" +
 "ACTIVITY_NAME: " + cursor!!.getString(1) + "n" +
 "ACTIVITY_CODE: " + cursor!!.getString(2) + "n" +
 "IS_ACTIVE: " + cursor!!.getString(3),
 Toast.LENGTH_LONG).show()
 while (cursor!!.moveToNext())
 
 

This is my db helper (the actual query I am running can be found at the bottom of this file - I purposely hardcoded the table name for debugging):

class DatabaseHelper(private val myContext: Context) : SQLiteOpenHelper(myContext, DB_NAME, null, DB_VERSION) 

private var DB_PATH: String? = null
private var calendarDatabase: SQLiteDatabase? = null


companion object 
 private val DB_NAME = "calendarDb"
 private val DB_VERSION = 1




init 
 this.DB_PATH = "/data/data/" + myContext.packageName + "/" + "databases/"
 Timber.e("Path 1: $DB_PATH")



@Throws(IOException::class)
fun createDataBase() 
 val dbExist = checkDataBase()
 if (dbExist) 
 else 
 this.readableDatabase
 try 
 copyDataBase()
 catch (e: IOException) 
 throw Error("Error copying database")
 

 


private fun checkDataBase(): Boolean 
 var checkDB: SQLiteDatabase? = null
 try 
 val myPath = DB_PATH!! + DB_NAME
 checkDB = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY)
 catch (e: SQLiteException) 
 

 checkDB?.close()
 return if (checkDB != null) true else false


@Throws(IOException::class)
private fun copyDataBase() 
 val myInput = myContext.assets.open(DB_NAME)
 val outFileName = DB_PATH!! + DB_NAME
 val myOutput = FileOutputStream(outFileName)
 val buffer = ByteArray(10)

 var length: Int = myInput.read(buffer)

 while (length > 0) 
 myOutput.write(buffer, 0, length)
 length = myInput.read(buffer)
 
 myOutput.flush()
 myOutput.close()
 myInput.close()



@Throws(SQLException::class)
fun openDataBase() 
 val myPath = DB_PATH!! + DB_NAME
 calendarDatabase = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY)



@Synchronized
override fun close() 
 if (calendarDatabase != null)
 calendarDatabase!!.close()
 super.close()



override fun onCreate(db: SQLiteDatabase) 

override fun onUpgrade(db: SQLiteDatabase, oldVersion: Int, newVersion: Int) 
 if (newVersion > oldVersion)
 try 
 copyDataBase()
 catch (e: IOException) 
 e.printStackTrace()

 



fun query(table: String, columns: Array<String>?, selection: String?, selectionArgs: Array<String>?, groupBy: String?, having: String?, orderBy: String?): Cursor 

 return calendarDatabase!!.query("ACTIVITY_LIST_TBL", null, null, null, null, null, null)

It seems like I must be loading in the database in the wrong way somehow, any help is greatly appreciated.

Please note I have already set up the database to be compatible with Android by executing these lines in the db browser:

CREATE TABLE "android_metadata" ("locale" TEXT DEFAULT 'en_US')

INSERT INTO "android_metadata" VALUES ('en_US')

I do not think this matters (I have already tested this), but I decided not to make every table's primary key '_id'