// Path: src/main/java/com/upnext/blekit/BeaconEvent.java
// public enum BeaconEvent {
// 
//     /**
//      * A beacon has appeared in range
//      */
//     REGION_ENTER,
// 
//     /**
//      * A beacon has disappeared from range.
//      * This event is in reality delayed to prevent imemdiate enter-exit-enter events.
//      * Because of that LEAVE is delayed by {@link com.upnext.blekit.BLEKitService#LEAVE_MSG_DELAY_MILLIS} ms.
//      */
//     REGION_LEAVE,
// 
//     /**
//      * A beacon has just changed proximity to immediate
//      */
//     CAME_IMMEDIATE,
// 
//     /**
//      * A beacon has just changed proximity to near
//      */
//     CAME_NEAR,
// 
//     /**
//      * A beacon has just changed proximity to far
//      */
//     CAME_FAR;
// 
// 
//     /**
//      * Matches IBeacon proximity to BeaconEvent proximity change
//      *
//      * @param iBeacon ibeacon
//      * @return beacon event
//      */
//     public static BeaconEvent fromIBeaconProximity(IBeacon iBeacon) {
//         return fromIBeaconProximity(iBeacon.getProximity());
//     }
// 
//     /**
//      * Matches IBeacon proximity to BeaconEvent proximity change
//      *
//      * @param proximity proximity
//      * @return beacon event
//      */
//     public static BeaconEvent fromIBeaconProximity(int proximity) {
//         switch (proximity) {
//             case IBeacon.PROXIMITY_IMMEDIATE:
//                 return CAME_IMMEDIATE;
// 
//             case IBeacon.PROXIMITY_NEAR:
//                 return CAME_NEAR;
// 
//             case IBeacon.PROXIMITY_FAR:
//                 return CAME_FAR;
// 
//             default:
//                 return null;
//         }
//     }
// }
// 
// Path: src/main/java/com/upnext/blekit/EventOccurenceUnit.java
// public enum EventOccurenceUnit {
// 
//     /**
//      * hour time unit
//      */
//     HOUR,
// 
//     /**
//      * day time unit
//      */
//     DAY,
// 
//     /**
//      * month time unit
//      */
//     MONTH,
// 
//     /**
//      * year time unit
//      */
//     YEAR,
// 
//     /**
//      * total time unit - all events are counted
//      */
//     TOTAL;
// 
//     private static Map<String, EventOccurenceUnit> namesMap = new HashMap<String, EventOccurenceUnit>(5);
// 
//     static {
//         namesMap.put("hour", HOUR);
//         namesMap.put("day", DAY);
//         namesMap.put("month", MONTH);
//         namesMap.put("year", YEAR);
//         namesMap.put("total", TOTAL);
//     }
// 
//     @JsonCreator
//     public static EventOccurenceUnit forValue(String value) {
//         if( value==null ) return TOTAL;
//         EventOccurenceUnit event = namesMap.get(value.toLowerCase());
//         if( event==null ) return TOTAL;
//         return event;
//     }
// }


import com.upnext.blekit.BeaconEvent;
import com.upnext.blekit.EventOccurenceUnit;
import java.util.Date;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
/*
 * Copyright (c) 2014 UP-NEXT. All rights reserved.
 * http://www.up-next.com
 *
 * Permission is hereby granted, free of charge, to any person
 * obtaining a copy of this software and associated documentation
 * files (the "Software"), to deal in the Software without
 * restriction, including without limitation the rights to use,
 * copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the
 * Software is furnished to do so, subject to the following
 * conditions:
 *
 * The above copyright notice and this permission notice shall be
 * included in all copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
 * EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES
 * OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
 * NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT
 * HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,
 * WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
 * FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
 * OTHER DEALINGS IN THE SOFTWARE.
 */
package com.upnext.blekit.util;




/**
 * Local database used for storing BLEKit entities like events for counting their occurences.
 *
 * @author Roman Wozniak (roman@up-next.com)
 */
public class BeaconsDB extends SQLiteOpenHelper {

    // Database Version
    private static final int DATABASE_VERSION = 1;
    // Database Name
    private static final String DATABASE_NAME = "BeaconsDB";

    public BeaconsDB(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    /**
     * {@inheritDoc}
     */
    @Override
    public void onCreate(SQLiteDatabase db) {
        final String CREATE_BEACON_EVENTS_TABLE = "CREATE TABLE " + TABLE_BEACON_EVENTS + " ( " +
                KEY_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                KEY_EVENT + " TEXT, "+
                KEY_BEACON_ID + " TEXT, "+
                KEY_DATE + " INTEGER )";
        db.execSQL(CREATE_BEACON_EVENTS_TABLE);
    }

    /**
     * {@inheritDoc}
     */
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS " + TABLE_BEACON_EVENTS);
        this.onCreate(db);
    }

    private static final String TABLE_BEACON_EVENTS = "beacon_events";

    private static final String KEY_ID = "id";
    private static final String KEY_EVENT = "event";
    private static final String KEY_BEACON_ID = "beacon_id";
    private static final String KEY_DATE = "date";

    private static final String[] COLUMNS = {KEY_ID,KEY_EVENT,KEY_BEACON_ID,KEY_DATE};


    /**
     * Adds an event to the events database
     *
     * @param event beacon event
     * @param beaconId beacon identifier
     */
// Path: src/main/java/com/upnext/blekit/BeaconEvent.java
// public enum BeaconEvent {
// 
//     /**
//      * A beacon has appeared in range
//      */
//     REGION_ENTER,
// 
//     /**
//      * A beacon has disappeared from range.
//      * This event is in reality delayed to prevent imemdiate enter-exit-enter events.
//      * Because of that LEAVE is delayed by {@link com.upnext.blekit.BLEKitService#LEAVE_MSG_DELAY_MILLIS} ms.
//      */
//     REGION_LEAVE,
// 
//     /**
//      * A beacon has just changed proximity to immediate
//      */
//     CAME_IMMEDIATE,
// 
//     /**
//      * A beacon has just changed proximity to near
//      */
//     CAME_NEAR,
// 
//     /**
//      * A beacon has just changed proximity to far
//      */
//     CAME_FAR;
// 
// 
//     /**
//      * Matches IBeacon proximity to BeaconEvent proximity change
//      *
//      * @param iBeacon ibeacon
//      * @return beacon event
//      */
//     public static BeaconEvent fromIBeaconProximity(IBeacon iBeacon) {
//         return fromIBeaconProximity(iBeacon.getProximity());
//     }
// 
//     /**
//      * Matches IBeacon proximity to BeaconEvent proximity change
//      *
//      * @param proximity proximity
//      * @return beacon event
//      */
//     public static BeaconEvent fromIBeaconProximity(int proximity) {
//         switch (proximity) {
//             case IBeacon.PROXIMITY_IMMEDIATE:
//                 return CAME_IMMEDIATE;
// 
//             case IBeacon.PROXIMITY_NEAR:
//                 return CAME_NEAR;
// 
//             case IBeacon.PROXIMITY_FAR:
//                 return CAME_FAR;
// 
//             default:
//                 return null;
//         }
//     }
// }
// 
// Path: src/main/java/com/upnext/blekit/EventOccurenceUnit.java
// public enum EventOccurenceUnit {
// 
//     /**
//      * hour time unit
//      */
//     HOUR,
// 
//     /**
//      * day time unit
//      */
//     DAY,
// 
//     /**
//      * month time unit
//      */
//     MONTH,
// 
//     /**
//      * year time unit
//      */
//     YEAR,
// 
//     /**
//      * total time unit - all events are counted
//      */
//     TOTAL;
// 
//     private static Map<String, EventOccurenceUnit> namesMap = new HashMap<String, EventOccurenceUnit>(5);
// 
//     static {
//         namesMap.put("hour", HOUR);
//         namesMap.put("day", DAY);
//         namesMap.put("month", MONTH);
//         namesMap.put("year", YEAR);
//         namesMap.put("total", TOTAL);
//     }
// 
//     @JsonCreator
//     public static EventOccurenceUnit forValue(String value) {
//         if( value==null ) return TOTAL;
//         EventOccurenceUnit event = namesMap.get(value.toLowerCase());
//         if( event==null ) return TOTAL;
//         return event;
//     }
// }


// Path: src/main/java/com/upnext/blekit/util/BeaconsDB.java
import com.upnext.blekit.BeaconEvent;
import com.upnext.blekit.EventOccurenceUnit;
import java.util.Date;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/*
 * Copyright (c) 2014 UP-NEXT. All rights reserved.
 * http://www.up-next.com
 *
 * Permission is hereby granted, free of charge, to any person
 * obtaining a copy of this software and associated documentation
 * files (the "Software"), to deal in the Software without
 * restriction, including without limitation the rights to use,
 * copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the
 * Software is furnished to do so, subject to the following
 * conditions:
 *
 * The above copyright notice and this permission notice shall be
 * included in all copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
 * EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES
 * OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
 * NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT
 * HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,
 * WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
 * FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
 * OTHER DEALINGS IN THE SOFTWARE.
 */
package com.upnext.blekit.util;




/**
 * Local database used for storing BLEKit entities like events for counting their occurences.
 *
 * @author Roman Wozniak (roman@up-next.com)
 */
public class BeaconsDB extends SQLiteOpenHelper {

    // Database Version
    private static final int DATABASE_VERSION = 1;
    // Database Name
    private static final String DATABASE_NAME = "BeaconsDB";

    public BeaconsDB(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    /**
     * {@inheritDoc}
     */
    @Override
    public void onCreate(SQLiteDatabase db) {
        final String CREATE_BEACON_EVENTS_TABLE = "CREATE TABLE " + TABLE_BEACON_EVENTS + " ( " +
                KEY_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                KEY_EVENT + " TEXT, "+
                KEY_BEACON_ID + " TEXT, "+
                KEY_DATE + " INTEGER )";
        db.execSQL(CREATE_BEACON_EVENTS_TABLE);
    }

    /**
     * {@inheritDoc}
     */
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS " + TABLE_BEACON_EVENTS);
        this.onCreate(db);
    }

    private static final String TABLE_BEACON_EVENTS = "beacon_events";

    private static final String KEY_ID = "id";
    private static final String KEY_EVENT = "event";
    private static final String KEY_BEACON_ID = "beacon_id";
    private static final String KEY_DATE = "date";

    private static final String[] COLUMNS = {KEY_ID,KEY_EVENT,KEY_BEACON_ID,KEY_DATE};


    /**
     * Adds an event to the events database
     *
     * @param event beacon event
     * @param beaconId beacon identifier
     */
    public void addBeaconEvent( BeaconEvent event, String beaconId ) {