com.airs.database

Class AIRS_database

java.lang.Object

SQLiteOpenHelper

com.airs.database.AIRS_database

public class AIRS_database
extends SQLiteOpenHelper

Field Summary

Fields

Modifier and Type	Field and Description
static String	DATABASE_NAME Name of AIRS database
static String	DATABASE_TABLE_CREATE SQL command for creating the main 'airs_values' table
static String	DATABASE_TABLE_CREATE2 SQL command for creating the 'airs_dates' table, which holds the dates at which something was recorded
static String	DATABASE_TABLE_CREATE3 SQL command for creating the 'airs_sensors_used' table, which holds the sensors being used at a particular date
static String	DATABASE_TABLE_INDEX3 SQL command for creating the index 'airs_sensors_used_timestamp'
static String	DATABASE_TABLE_NAME name of main DB table with recording values

Constructor Summary

Constructors

Constructor and Description
AIRS_database(Context context) Constructor for opening the database class

Method Summary

Methods

Modifier and Type	Method and Description
void	onCreate(SQLiteDatabase db) Called when creating the AIRS tables for the first time
void	onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

DATABASE_NAME

public static final String DATABASE_NAME

Name of AIRS database

See Also:

Constant Field Values

DATABASE_TABLE_NAME

public static final String DATABASE_TABLE_NAME

name of main DB table with recording values

See Also:

Constant Field Values

DATABASE_TABLE_CREATE

public static final String DATABASE_TABLE_CREATE

SQL command for creating the main 'airs_values' table

See Also:

Constant Field Values

DATABASE_TABLE_CREATE2

public static final String DATABASE_TABLE_CREATE2

SQL command for creating the 'airs_dates' table, which holds the dates at which something was recorded

See Also:

Constant Field Values

DATABASE_TABLE_CREATE3

public static final String DATABASE_TABLE_CREATE3

SQL command for creating the 'airs_sensors_used' table, which holds the sensors being used at a particular date

See Also:

Constant Field Values

DATABASE_TABLE_INDEX3

public static final String DATABASE_TABLE_INDEX3

SQL command for creating the index 'airs_sensors_used_timestamp'

See Also:

Constant Field Values

Constructor Detail

AIRS_database

public AIRS_database(Context context)

Constructor for opening the database class

Parameters:

context - Android Context in which the database is opened

Method Detail

onCreate

public void onCreate(SQLiteDatabase db)

Called when creating the AIRS tables for the first time

Parameters:

db - SQliteDatabase variable being used

onUpgrade

public void onUpgrade(SQLiteDatabase db,
             int oldVersion,
             int newVersion)