com.example.mealtrackerapp.databases

Class DayDataDBH

java.lang.Object

android.database.sqlite.SQLiteOpenHelper

com.example.mealtrackerapp.databases.DayDataDBH

All Implemented Interfaces:

java.lang.AutoCloseable

public class DayDataDBH
extends android.database.sqlite.SQLiteOpenHelper

SQLite database helper. It handles all methods related to the daydata.db. The first time the database helper is called, the daydata.db is created. The daydata.db contains all the information about a user's set goals for every day the app is used. In addition it contains the water count for each day.

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	COLUMN_CALORIC_GOAL
static java.lang.String	COLUMN_CARBS_GOAL
static java.lang.String	COLUMN_DATE
static java.lang.String	COLUMN_FAT_GOAL
static java.lang.String	COLUMN_ID
static java.lang.String	COLUMN_PROTEIN_GOAL
static java.lang.String	COLUMN_WATER_GOAL
static java.lang.String	COLUMN_WATER_INTAKE
static java.lang.String	COLUMN_WEIGHT
static java.lang.String	DAYDATA_TABLE

Constructor Summary

Constructors

Constructor and Description
DayDataDBH(android.content.Context context) On first construction, creates a database with a name and a version

Method Summary

Modifier and Type	Method and Description
void	addOneIgnore(java.lang.String date, int weight, int caloricGoal, int carbsGoal, int proteinGoal, int fatGoal, int waterGoal, int waterIntake) Adds a new row if no data exists for the given date.
void	addOneReplace(java.lang.String date, int weight, int caloricGoal, int carbsGoal, int proteinGoal, int fatGoal, int waterGoal, int waterIntake) Adds a new row or replaces an existing one.
int	getIntByDate(java.lang.String column, java.lang.String date) Getting data from a column in the database given a certain date
void	onCreate(android.database.sqlite.SQLiteDatabase db) Used only the first time.
void	onUpgrade(android.database.sqlite.SQLiteDatabase db, int oldVersion, int newVersion) Handles actions on upgrade to another version.
void	updateColumnWhereDateTo(java.lang.String column, java.lang.String date, int newValue) Update a column with new given values on a given date

Methods inherited from class android.database.sqlite.SQLiteOpenHelper

close, getDatabaseName, getReadableDatabase, getWritableDatabase, onConfigure, onDowngrade, onOpen, setIdleConnectionTimeout, setLookasideConfig, setOpenParams, setWriteAheadLoggingEnabled

Methods inherited from class java.lang.Object

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

Field Detail

COLUMN_ID

public static final java.lang.String COLUMN_ID

See Also:

Constant Field Values

DAYDATA_TABLE

public static final java.lang.String DAYDATA_TABLE

See Also:

Constant Field Values

COLUMN_DATE

public static final java.lang.String COLUMN_DATE

See Also:

Constant Field Values

COLUMN_WEIGHT

public static final java.lang.String COLUMN_WEIGHT

See Also:

Constant Field Values

COLUMN_CALORIC_GOAL

public static final java.lang.String COLUMN_CALORIC_GOAL

See Also:

Constant Field Values

COLUMN_CARBS_GOAL

public static final java.lang.String COLUMN_CARBS_GOAL

See Also:

Constant Field Values

COLUMN_PROTEIN_GOAL

public static final java.lang.String COLUMN_PROTEIN_GOAL

See Also:

Constant Field Values

COLUMN_FAT_GOAL

public static final java.lang.String COLUMN_FAT_GOAL

See Also:

Constant Field Values

COLUMN_WATER_GOAL

public static final java.lang.String COLUMN_WATER_GOAL

See Also:

Constant Field Values

COLUMN_WATER_INTAKE

public static final java.lang.String COLUMN_WATER_INTAKE

See Also:

Constant Field Values

Constructor Detail

DayDataDBH

public DayDataDBH(@Nullable
                  android.content.Context context)

On first construction, creates a database with a name and a version

Parameters:

context - activity class

Method Detail

onCreate

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

Used only the first time. On first construction, creates a database daydata.db with one table DAYDATA_TABLE with columns for int id (primary key and autoincrementing), String date, int weight, int caloricGoal, int carbsGoal, int proteinGoal, int fatGoal, int waterGoal, int waterIntake The date column has to be unique (only one row per date)

Specified by:

onCreate in class android.database.sqlite.SQLiteOpenHelper

Parameters:

db - database created

onUpgrade

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

Handles actions on upgrade to another version.

Specified by:

onUpgrade in class android.database.sqlite.SQLiteOpenHelper

Parameters:

db - database upgraded

oldVersion -

newVersion -

addOneReplace

public void addOneReplace(java.lang.String date,
                          int weight,
                          int caloricGoal,
                          int carbsGoal,
                          int proteinGoal,
                          int fatGoal,
                          int waterGoal,
                          int waterIntake)

Adds a new row or replaces an existing one.

Parameters:

date - date of data

weight - weight input by user for that date

caloricGoal - calorie intake goal input by user for that date

carbsGoal - carb intake goal input by user for that date

proteinGoal - protein intake goal input by user for that date

fatGoal - fat intake goal input by user for that date

waterGoal - water intake goal input by user for that date

waterIntake - water intake input by user for that day

addOneIgnore

public void addOneIgnore(java.lang.String date,
                         int weight,
                         int caloricGoal,
                         int carbsGoal,
                         int proteinGoal,
                         int fatGoal,
                         int waterGoal,
                         int waterIntake)

Adds a new row if no data exists for the given date.

Parameters:

date - date of data

weight - weight input by user for that date

caloricGoal - calorie intake goal input by user for that date

carbsGoal - carb intake goal input by user for that date

proteinGoal - protein intake goal input by user for that date

fatGoal - fat intake goal input by user for that date

waterGoal - water intake goal input by user for that date

waterIntake - water intake input by user for that day

getIntByDate

public int getIntByDate(java.lang.String column,
                        java.lang.String date)

Getting data from a column in the database given a certain date

Parameters:

column - column name of the data to be fetched

date - date at which the data should be fetched

Returns:

Integer of the value requested

updateColumnWhereDateTo

public void updateColumnWhereDateTo(java.lang.String column,
                                    java.lang.String date,
                                    int newValue)

Update a column with new given values on a given date

Parameters:

column - column to be updated

date - date where the modification should happen

newValue - new value for the column