Saving Data on Android

build.gradle(Module:app)
 and add the following code into the 
android
 section:
testOptions { 
  unitTests { 
    includeAndroidResources = 
true
 
  } 
}
This will tell gradle to use the 
includeAndroidResources
 flag, and the name pretty 
much explains what that means! Next, add the following dependency in the 
dependencies
 section:
testImplementation 
"org.robolectric:robolectric:3.6.1"
Sync the gradle file after making these changes. Next, open 
ToDoDatabaseHandler.kt
 and add the following code inside the class, after 
deleteToDo()
:
// 1
 
fun
 
clearDbAndRecreate
()
 { 
  clearDb() 
  onCreate(writableDatabase) 
} 
   
fun
 
clearDb
()
 { 
  writableDatabase.execSQL(
"DROP TABLE IF EXISTS 
$TABLE_NAME
"
) 
} 
 
// 2
 
fun
 
getAllText
()
: String { 
  
var
 result = 
""
 
  
val
 cols = arrayOf(KEY_TODO_NAME, KEY_TODO_IS_COMPLETED) 
  
val
 cursor = writableDatabase.query(TABLE_NAME, cols, 
      
null
, 
null
, 
null
, 
null
, KEY_TODO_ID) 
  
val
 indexColumnName = 
cursor.getColumnIndexOrThrow(KEY_TODO_NAME) 
  
while
 (cursor != 
null
 && cursor.moveToNext()) { 
    result += cursor.getString(indexColumnName) 
  } 
 
  cursor.close() 
  
return
 result 
}
Saving Data on Android
Chapter 3: SQLite Database
raywenderlich.com
65

---

Here's what's happening above:
1. You will erase and recreate the database once the testing is done. This will allow 
the test to be run multiple times and ensure that residual test data isn't left in 
the database.
2.
getAllText()
 has one job, to create a 
String
 that consists of the TODO item 
names in the database all concatenated together. In the test you will write, you 
will see if the database contains the values you expect to see after inserting a few 
items.
Now, to create the test. Unit tests are contained in the 
test
 folder. Right click on