Add function to add event into local database

[unical.git] / src / ro / ieval / unical / MySQLiteHelper.java

package ro.ieval.unical;

import java.sql.SQLClientInfoException;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class MySQLiteHelper extends SQLiteOpenHelper {
	public static final String Name="Events";
	
	public static final String ID = "_id";
	public static final String title = "Title";
	public static final String description = "Description";
	public static final String date = "Date";
	public static final String duration = "Duration";
	public static final String repeat = "repeat";
	public static final String repeatIn = "repeatInterval";
	public static final String location = "Location";
	
	private static final int dbversion=1;
	
	private static final String Database_create = "create table " + Name + "(" + 
			ID + " integer primary key autoincrement, " +
			title + " text not null, " + 
			description + " text, " + 
			date + " integer, " + 
			duration + " integer, " +
			repeat + " integer, "+
			repeatIn + " integer, " +
			location + " text);"
			;
	
	public MySQLiteHelper(Context context) {
		super(context,Name, null, dbversion);
		// TODO Auto-generated constructor stub
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		// TODO Auto-generated method stub
		db.execSQL(Database_create);
		
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// TODO Auto-generated method stub
		Log.w(MySQLiteHelper.class.getName(),
		        "Upgrading database from version " + oldVersion + " to "
		            + newVersion + ", which will destroy all old data");
		    db.execSQL("DROP TABLE IF EXISTS " + Name);
		    onCreate(db);
	}
	
}