com.example.mealtrackerapp.databases

Class FoodLogDBH

java.lang.Object

android.database.sqlite.SQLiteOpenHelper

com.example.mealtrackerapp.databases.FoodLogDBH

All Implemented Interfaces:

java.lang.AutoCloseable

public class FoodLogDBH
extends android.database.sqlite.SQLiteOpenHelper

SQLite database helper. It handles all methods related to the foodLogs.db The first time the database helper is called, the foodLogs.db is created. The daydata.db contains all the information about a user's food diary for every day the app is used.

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	COLUMN_CALORIES
static java.lang.String	COLUMN_CARBS
static java.lang.String	COLUMN_DATE
static java.lang.String	COLUMN_FAT
static java.lang.String	COLUMN_FOOD
static java.lang.String	COLUMN_ID
static java.lang.String	COLUMN_MEAL
static java.lang.String	COLUMN_PROTEIN
static java.lang.String	COLUMN_TIME
static java.lang.String	FOODLOGS_TABLE

Constructor Summary

Constructors

Constructor and Description
FoodLogDBH(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	addArray(java.util.ArrayList<FoodLog> foodlogList) Inserting an ArrayList of food log objects given in parameters into the db
void	deleteOne(FoodLog foodlog) Delete a row in the table where the id equals to the id of the food log given as a parameter
int	getCaloriesByDate(java.lang.String date) Get the sum of all calories eaten for a given date.
int	getCaloriesByMealByDate(java.lang.String meal, java.lang.String date) Get the sum of all calories eaten on a specific meal on a given date.
java.util.List<FoodLog>	getFoodLog(java.lang.String dateDisplayed) Get an ArrayList of all the food logs for a given date.
int	getSumByDate(java.lang.String column, java.lang.String date) Get the sum of any column for a given 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	updateOne(FoodLog foodLog, java.lang.String name, java.lang.String meal, java.lang.String time, int calories, double carbs, double protein, double fat) Updates the values of an entry for a given food log.

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_DATE

public static final java.lang.String COLUMN_DATE

See Also:

Constant Field Values

COLUMN_FOOD

public static final java.lang.String COLUMN_FOOD

See Also:

Constant Field Values

FOODLOGS_TABLE

public static final java.lang.String FOODLOGS_TABLE

See Also:

Constant Field Values

COLUMN_MEAL

public static final java.lang.String COLUMN_MEAL

See Also:

Constant Field Values

COLUMN_ID

public static final java.lang.String COLUMN_ID

See Also:

Constant Field Values

COLUMN_TIME

public static final java.lang.String COLUMN_TIME

See Also:

Constant Field Values

COLUMN_CALORIES

public static final java.lang.String COLUMN_CALORIES

See Also:

Constant Field Values

COLUMN_CARBS

public static final java.lang.String COLUMN_CARBS

See Also:

Constant Field Values

COLUMN_PROTEIN

public static final java.lang.String COLUMN_PROTEIN

See Also:

Constant Field Values

COLUMN_FAT

public static final java.lang.String COLUMN_FAT

See Also:

Constant Field Values

Constructor Detail

FoodLogDBH

public FoodLogDBH(@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, String name, String meal, String time, int calories, double carbs, double protein, double fat

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 -

updateOne

public void updateOne(FoodLog foodLog,
                      java.lang.String name,
                      java.lang.String meal,
                      java.lang.String time,
                      int calories,
                      double carbs,
                      double protein,
                      double fat)

Updates the values of an entry for a given food log. Date stays the same.

Parameters:

foodLog - food log object to be altered

name - name of the food log

meal - meal of the food log

time - time of the food log

calories - caloric value of the food log

carbs - carb value of the food log

protein - protein value of the food log

fat - fat value of the food log

deleteOne

public void deleteOne(FoodLog foodlog)

Delete a row in the table where the id equals to the id of the food log given as a parameter

Parameters:

foodlog - to be deleted

addArray

public void addArray(java.util.ArrayList<FoodLog> foodlogList)

Inserting an ArrayList of food log objects given in parameters into the db

Parameters:

foodlogList - ArrayList to be inserted

getFoodLog

public java.util.List<FoodLog> getFoodLog(java.lang.String dateDisplayed)

Get an ArrayList of all the food logs for a given date. They are ordered by time (latest log first). A query is made for all rows where the date corresponds to the one given in parameter. Each of these rows is then converted into a FoodLog object and added to an ArrayList, which is then returned.

Parameters:

dateDisplayed - date for the food logs to display

Returns:

ArrayList of FoodLog objects

getCaloriesByDate

public int getCaloriesByDate(java.lang.String date)

Get the sum of all calories eaten for a given date.

Parameters:

date - date for which calories will be summed

Returns:

Integer sum of all calories for the given date

getCaloriesByMealByDate

public int getCaloriesByMealByDate(java.lang.String meal,
                                   java.lang.String date)

Get the sum of all calories eaten on a specific meal on a given date.

Parameters:

meal - meal for which calories will be summed

date - date for which calories will be summed

Returns:

Integer sum of calories for a meal on the given date

getSumByDate

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

Get the sum of any column for a given date

Parameters:

column - column for which calories will be summed

date - date for which calories will be summed

Returns:

Integer sum of the specified column on a given date