Database Wiki

DatabaseHelper

Input: Context
Output: SQLiteOpenHelper
Description: Initializes the database

createTable

Parameters

• DatasetName: String
• Schema: ArrayList<String>

Description
Creates a table named DatasetName with the provided Schema.
Schema is a list of column names

insertRow

Parameters

• DatasetName: String
• Data: Array
• ByColumn: Boolean=false

Description
Inserts data into the specified table (by row is the default)

getAllDatabaseNames

Output: ArrayList<String>
Description
Retrieves names of all existing datasets

getColumnNames

Parameters

• DatasetName: String
  Output: ArrayList<String>

Description Retrieves name

getTable

Parameters

• DatasetName: String
  Output: Dictionary<String, ArrayList<String>>

Description
Returns a dictionary whose key is column name and value is data in that column