com.cvlcondorcet.condor

Class Database

java.lang.Object

com.cvlcondorcet.condor.Database

class Database
extends java.lang.Object

Class for handling database operations.

Author:

Quentin DE MUYNCK

Field Summary

Fields

Modifier and Type	Field and Description
private boolean	canteen
private android.content.Context	ctx
private boolean	cvl
private android.database.sqlite.SQLiteDatabase	database
private java.util.ArrayList<java.lang.Integer>	events
private DBOpenHelper	helper
private boolean	maps
private java.util.ArrayList<java.lang.Integer>	posts

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
(package private) void	beginSync() Saves current date & time into the db for further synchronizations (avoid useless syncs).
(package private) void	close()
(package private) void	deleteAllTables()
(package private) void	deleteTable(java.lang.String table)
(package private) boolean	endingSync() End synchronisation by storing new values in Preferences for notifications within the app and displaying notification according to user's preferences.
(package private) java.util.ArrayList<java.lang.String>	getCategories() Gets categories from DBOpenHelper.GEN_TABLE and parsing it (JSON format).
(package private) Event	getEvent(java.lang.String id)
(package private) java.util.ArrayList<Event>	getEvents()
(package private) android.database.Cursor	getPlace(long id)
(package private) long	getPlaceId(java.lang.String name)
(package private) Post	getPost(java.lang.String id) Retrieves post datas for displaying in PostsFragment
(package private) java.util.ArrayList<Post>	getPosts() Retrieves all posts.
(package private) android.database.Cursor	getQuery(java.lang.String table, java.lang.String[] columns, java.lang.String clause)
(package private) android.support.v4.widget.CursorAdapter	getSuggestions() Used for the Maps module, retrives suggestions according to user's entry
(package private) java.util.ArrayList<TeachersAbsence>	getTeachersAbsence() Retrieves all rows from teachers absences tables
(package private) void	initialiseSync() Initialises variables for sync (count for new content)
(package private) boolean	isOpen()
(package private) void	open()
(package private) static java.util.ArrayList<java.lang.String>	parseCategories(java.lang.String categories) Static method that parses a JSON String and returning it into an ArrayList
(package private) static java.util.ArrayList<java.lang.Integer>	parsePrefNot(java.lang.String key, android.content.Context ctx) Static method to prevent code repetition
(package private) java.lang.String	timestamp(java.lang.String name) Retrieves a value from DBOpenHelper.GEN_TABLE
(package private) void	updateEvents(org.json.JSONArray array)
(package private) java.util.ArrayList	updateGen(org.json.JSONArray array) Updates data in database from JSONArray got from sync.
(package private) void	updateMaps(org.json.JSONArray array) Updates maps table, empty it and refill it with new datas.
(package private) void	updatePosts(org.json.JSONArray array) Updates posts from data got from sync.
(package private) static void	updatePrefValue(java.lang.String key, java.util.ArrayList<java.lang.Integer> array, android.content.Context ctx) Turns an ArrayList with id of new posts||events and stores it in SharedPreferences

Methods inherited from class java.lang.Object

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

Field Detail

database

private android.database.sqlite.SQLiteDatabase database

helper

private final DBOpenHelper helper

ctx

private final android.content.Context ctx

posts

private java.util.ArrayList<java.lang.Integer> posts

events

private java.util.ArrayList<java.lang.Integer> events

canteen

private boolean canteen

cvl

private boolean cvl

maps

private boolean maps

Constructor Detail

Database

Database(android.content.Context context)

Default constructor.

Parameters:

context - Context

Method Detail

isOpen

boolean isOpen()

initialiseSync

void initialiseSync()

Initialises variables for sync (count for new content)

open

void open()
   throws android.database.SQLException

Throws:

android.database.SQLException

close

void close()

updateGen

java.util.ArrayList updateGen(org.json.JSONArray array)

Updates data in database from JSONArray got from sync.

Parameters:

array - updated data

Returns:

files that must be downloaded

See Also:

Sync.get(String), Sync.downloadFile(String)

updatePosts

void updatePosts(org.json.JSONArray array)

Updates posts from data got from sync.

Parameters:

array - Updated data

See Also:

Sync.get(String)

updateMaps

void updateMaps(org.json.JSONArray array)

Updates maps table, empty it and refill it with new datas.

Parameters:

array - Updated data

See Also:

Sync.get(String)

updateEvents

void updateEvents(org.json.JSONArray array)

timestamp

java.lang.String timestamp(java.lang.String name)

Retrieves a value from DBOpenHelper.GEN_TABLE

Parameters:

name - the key of value

Returns:

the value corresponding to the key

See Also:

DBOpenHelper.GEN_TABLE

beginSync

void beginSync()

Saves current date & time into the db for further synchronizations (avoid useless syncs).

deleteTable

void deleteTable(java.lang.String table)

deleteAllTables

void deleteAllTables()

getTeachersAbsence

java.util.ArrayList<TeachersAbsence> getTeachersAbsence()

Retrieves all rows from teachers absences tables

Returns:

Array containing all rows

See Also:

DBOpenHelper.PROFS_TABLE

getPosts

java.util.ArrayList<Post> getPosts()

Retrieves all posts.

Returns:

Array containing all posts.

See Also:

DBOpenHelper.POSTS_TABLE

getCategories

java.util.ArrayList<java.lang.String> getCategories()

Gets categories from DBOpenHelper.GEN_TABLE and parsing it (JSON format).

Returns:

Array containing all categories

getEvents

java.util.ArrayList<Event> getEvents()

getSuggestions

android.support.v4.widget.CursorAdapter getSuggestions()

Used for the Maps module, retrives suggestions according to user's entry

Returns:

CursorAdapter with suggestions

getPost

Post getPost(java.lang.String id)

Retrieves post datas for displaying in PostsFragment

Parameters:

id - the corresponding id in database for the post

Returns:

a Post object, containing main information and short description

See Also:

Post, PostsLoader.loadInBackground(), RecyclerViewAdapterPosts.onBindViewHolder(RecyclerView.ViewHolder, int)

getEvent

Event getEvent(java.lang.String id)

getPlace

android.database.Cursor getPlace(long id)

getQuery

android.database.Cursor getQuery(java.lang.String table,
                                 java.lang.String[] columns,
                                 java.lang.String clause)

getPlaceId

long getPlaceId(java.lang.String name)

parseCategories

static java.util.ArrayList<java.lang.String> parseCategories(java.lang.String categories)

Static method that parses a JSON String and returning it into an ArrayList

Parameters:

categories - the JSON String

Returns:

the corresponding ArrayList

parsePrefNot

static java.util.ArrayList<java.lang.Integer> parsePrefNot(java.lang.String key,
                                                           android.content.Context ctx)

Static method to prevent code repetition

Parameters:

key - "posts" or "events" value only

ctx - Context to access SharedPreferences

Returns:

Returns an ArrayList with the id of new events or posts depending on the key

updatePrefValue

static void updatePrefValue(java.lang.String key,
                            java.util.ArrayList<java.lang.Integer> array,
                            android.content.Context ctx)

Turns an ArrayList with id of new posts||events and stores it in SharedPreferences

Parameters:

key - "posts" or "events' only

array - The array with the new values

ctx - Context to access SharedPreferences

endingSync

boolean endingSync()

End synchronisation by storing new values in Preferences for notifications within the app and displaying notification according to user's preferences.

Returns:

true if new content, false otherwise.