import android.database.sqlite.SQLiteDatabase;
import android.util.Log;
+import net.fortuna.ical4j.model.Component;
import net.fortuna.ical4j.model.DateList;
import net.fortuna.ical4j.model.DateTime;
import net.fortuna.ical4j.model.Period;
*/
public class DatabaseManager {
private static final String DATABASE_NAME = "DHBWLoe.CampusApp.DEV";
- private static final int DATABASE_VERSION = 1;
+ private static final int DATABASE_VERSION = 2;
private CampusAppContext AppContext;
private SQLiteDatabase database;
private NewsDatabaseHelper newsDBHelper;
if(version < DATABASE_VERSION)
upgradeTables(version, DATABASE_VERSION);
-
+ //database.execSQL("DELETE FROM CourseCalendar");
+ //database.execSQL("DELETE FROM CourseCalendarEvent");
}
private void upgradeTables(int oldVersion, int newVersion) {
}
if(oldVersion < 2 && newVersion >= 2) {
// Version 2
+ database.execSQL("ALTER TABLE CourseCalendarEvent ADD EventType INT;");
+ }
+ if(oldVersion < 3 && newVersion >= 3) {
+ // Version 3
}
- database.execSQL("UPDATE Version SET Version = "+Integer.toString(newVersion));
+ database.execSQL("UPDATE Version SET Version = " + Integer.toString(newVersion));
}
public void addSearchIndices(SearchIndices[] indices) {
return nfcCardData;
}
- public void updateCourseCalendar(CourseEvent event) {
+ public void updateCourseCalendar(CourseEvent event, Component cevent) {
openDatabase();
if(vorlesungsplanDBHelper == null)
vorlesungsplanDBHelper = new VorlesungsplanDatabaseHelper(AppContext, database);
- vorlesungsplanDBHelper.updateCourseCalendar(event);
+ vorlesungsplanDBHelper.updateCourseCalendar(event, cevent);
}
public CourseEvent[] getCourseCalendarEvents(String coursename, long timeFrom, long timeTo) {
return vorlesungsplanDBHelper.getCourseCalendarEvents(coursename, timeFrom, timeTo);
}
+ public CourseEvent[] getCourseCalendarTimetable(String coursename, long timeFrom, int days) {
+ openDatabase();
+ if(vorlesungsplanDBHelper == null)
+ vorlesungsplanDBHelper = new VorlesungsplanDatabaseHelper(AppContext, database);
+ return vorlesungsplanDBHelper.getCourseCalendarTimetable(coursename, timeFrom, days);
+ }
+
public CourseGroup getCourseGroup(int courseGroupId) {
openDatabase();
if(vorlesungsplanDBHelper == null)
return vorlesungsplanDBHelper.addCourseGroup(coursename, groupname);
}
+ public CourseGroup[] getCourseGroups(String coursename, Date notBefore) {
+ openDatabase();
+ if(vorlesungsplanDBHelper == null)
+ vorlesungsplanDBHelper = new VorlesungsplanDatabaseHelper(AppContext, database);
+ return vorlesungsplanDBHelper.getCourseGroups(coursename, notBefore);
+ }
+
public void updateMensaTagesplan(MensaTagesplan plan) {
openDatabase();
if(mensaplanDBHelper == null)