DataHelper.java

/*  Subspace Mobile - A Android Subspace Client
    Copyright (C) 2012 Kingsley Masters. All Rights Reserved.
    
    kingsley dot masters at gmail dot com

    This program is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/

package com.subspace.redemption.database;

import java.util.ArrayList;
import java.util.List;

import com.subspace.redemption.R;
import com.subspace.redemption.dataobjects.Zone;

import android.content.*;



import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class DataHelper {
	   private static final String DATABASE_NAME = "ssmobile.db";
	   private static final int DATABASE_VERSION = 1;
	   
	   private static final String TBL_ZONE = "tbl_Zone";
	   
	   private Context context;
	   private SQLiteDatabase db;
	   
	   public DataHelper(Context context)
	   {
		   this.context = context;
		   OpenHelper openHelper = new OpenHelper(context);
		   db = openHelper.getWritableDatabase();		   
	   }
	   
	   public void ExecuteSQL(String sql)
	   {
		   db.beginTransaction();
		   db.execSQL(sql);
		   db.endTransaction();		   
	   }
	   
	   public void addZone(Zone zone)
	   {    
		    ContentValues values = new ContentValues();
		    values.put("name",zone.Name);
		    values.put("description", zone.Description);
		    values.put("ip", zone.Ip);
		    values.put("port", zone.Port);
		    values.put("iscustom", zone.IsCustom);
		 
		    // Inserting Row
		    db.insert(TBL_ZONE, null, values);		      
	   }
	   
	   public ArrayList<Zone> getAllZones() {
		   ArrayList<Zone> zoneList = new ArrayList<Zone>();
		    // Select All Query
		    String selectQuery = "SELECT id,name,description,ip,port,iscustom FROM " + TBL_ZONE;
		 
		    Cursor cursor = db.rawQuery(selectQuery, null);
		 
		    // looping through all rows and adding to list
		    if (cursor.moveToFirst()) {
		        do {
		            Zone zone = new Zone(cursor);
		            

		            // Adding contact to list
		            zoneList.add(zone);
		        } while (cursor.moveToNext());
		    }
		 
		    // return contact list
		    return zoneList;
		}
	   
	   public Zone getZone(int selectedZoneId) {
		   Zone zone = null;
		   // Select All Query
		    String selectQuery = "SELECT id,name,description,ip,port,iscustom FROM " + TBL_ZONE 
		    + " WHERE Id = " + selectedZoneId;
		 
		    Cursor cursor = db.rawQuery(selectQuery, null);
		 		    
		    if (cursor.moveToFirst()) {
		       	  zone = new Zone(cursor);
		    }
		 
		    cursor.close();		    
		    // return contact list
		    return zone;
		}
	   
	   public void clearZones() {		  
		    db.delete(TBL_ZONE, "iscustom = ?",
		            new String[] { String.valueOf(0) });
		}
	   
	   private static class OpenHelper extends SQLiteOpenHelper {
		   	 
		   	   private Context context;
		   
	   	      OpenHelper(Context context) {	   	    	 
	   	         super(context, DATABASE_NAME, null, DATABASE_VERSION);
	   	         this.context = context;
	   	      }
	   	 
	   	      @Override
	   	      public void onCreate(SQLiteDatabase db) {
		   	     Log.d("Database", "Creating Subspace Redemption Database");
		   	    	 
		   	     Log.d("Database", context.getString(R.string.tbl_Zone));
		   	     db.execSQL(context.getString(R.string.tbl_Zone));
	   	      }
	   	 
	   	      @Override
	   	      public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
	   	  //       Log.w("Example", "Upgrading database, this will drop tables and recreate.");
	   	    //     db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
	   	         onCreate(db);
	   	      }
	   }

	
}