Database Wiki

Contents

1. CreateTable
2. InsertRow
3. GetAllDatabaseNames
4. GetColumnNames
5. GetTable

Database Structure

Master

• Dataset Names
• Date of last update
• X-axis Column
• Timeformat

Dataset

• Name
• Columns
• Timestamp

DatabaseHelper

Input: Context
Output: SQLiteOpenHelper
Description: Initializes the database

createTable

Parameters

• DatasetName: String
• Schema: MutableList<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