com.gedder.gedderalarm.db

Class AlarmClockDBHelper

java.lang.Object

android.database.sqlite.SQLiteOpenHelper

com.gedder.gedderalarm.db.AlarmClockDBHelper

public class AlarmClockDBHelper
extends android.database.sqlite.SQLiteOpenHelper

A SQLite wrapper class to help in creating, reading, updating, and deleting Alarm Clocks.

Constructor Summary

Constructors

Constructor and Description
AlarmClockDBHelper(android.content.Context context) Default constructor requiring context.

Method Summary

Modifier and Type	Method and Description
void	addAlarmClock(AlarmClock alarmClock) Adds an alarm clock to the database, including the time for its alarm, and whether it is currently set or not.
int	deleteAlarmClock(java.util.UUID uuid) Deletes the alarm clock that has UUID uuid.
android.database.Cursor	getAlarmClock(java.util.UUID uuid) Gets the alarm clock with UUID uuid, if it exists in the database.
int	getAlarmClockCount() Returns the number of alarm clocks in the database, active or not.
android.database.Cursor	getAllAlarmClocks() Returns a list of all alarm clocks currently in the database, active or not.
void	onCreate(android.database.sqlite.SQLiteDatabase db) Creates all tables for the database.
void	onUpgrade(android.database.sqlite.SQLiteDatabase db, int oldVersion, int newVersion) Will drop all tables if they exist and recreate them.
int	updateAlarmClock(AlarmClock alarmClock) Updates an existing alarm clock to the parameters of the passed in alarm clock.

Methods inherited from class android.database.sqlite.SQLiteOpenHelper

close, getDatabaseName, getReadableDatabase, getWritableDatabase, onConfigure, onDowngrade, onOpen, setWriteAheadLoggingEnabled

Methods inherited from class java.lang.Object

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

Constructor Detail

AlarmClockDBHelper

public AlarmClockDBHelper(android.content.Context context)

Default constructor requiring context.

Parameters:

context - The context of the database.

Method Detail

onCreate

public void onCreate(android.database.sqlite.SQLiteDatabase db)

Creates all tables for the database.

Specified by:

onCreate in class android.database.sqlite.SQLiteOpenHelper

Parameters:

db - The database we create tables for.

See Also:

AlarmClockDBSchema

onUpgrade

public void onUpgrade(android.database.sqlite.SQLiteDatabase db,
                      int oldVersion,
                      int newVersion)

Will drop all tables if they exist and recreate them.

Specified by:

onUpgrade in class android.database.sqlite.SQLiteOpenHelper

Parameters:

db - The database to drop and recreate.

oldVersion - Old version of the database.

newVersion - New version of the database.

See Also:

AlarmClockDBSchema

addAlarmClock

public void addAlarmClock(AlarmClock alarmClock)

Adds an alarm clock to the database, including the time for its alarm, and whether it is currently set or not. Also adds its UUID to the database.

Parameters:

alarmClock - The AlarmClock object to add to the database.

getAlarmClock

public android.database.Cursor getAlarmClock(java.util.UUID uuid)

Gets the alarm clock with UUID uuid, if it exists in the database.

Parameters:

uuid - The UUID of the alarm clock to get.

Returns:

The AlarmClock object having UUID uuid.

getAllAlarmClocks

public android.database.Cursor getAllAlarmClocks()

Returns a list of all alarm clocks currently in the database, active or not.

Returns:

A list of all alarm clocks currently existing in the database.

getAlarmClockCount

public int getAlarmClockCount()

Returns the number of alarm clocks in the database, active or not.

Returns:

The number of alarm clocks in the database.

updateAlarmClock

public int updateAlarmClock(AlarmClock alarmClock)

Updates an existing alarm clock to the parameters of the passed in alarm clock.

Parameters:

alarmClock - The alarm clock whose values to copy into the alarm clock with UUID uuid.

Returns:

Number of rows affected by the update. Not 1 if failed.

deleteAlarmClock

public int deleteAlarmClock(java.util.UUID uuid)

Deletes the alarm clock that has UUID uuid.

Parameters:

uuid - The UUID of the alarm clock to delete.