/**
 * Copyright (c) 2013, Sana
 * All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions are met:
 *
 *     * Redistributions of source code must retain the above copyright
 *       notice, this list of conditions and the following disclaimer.
 *     * Redistributions in binary form must reproduce the above copyright
 *       notice, this list of conditions and the following disclaimer in the
 *       documentation and/or other materials provided with the distribution.
 *     * Neither the name of the Sana nor the
 *       names of its contributors may be used to endorse or promote products
 *       derived from this software without specific prior written permission.
 * 
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" 
 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE 
 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE 
 * ARE DISCLAIMED. IN NO EVENT SHALL Sana BE LIABLE FOR ANY DIRECT, INDIRECT,
 * INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT 
 * NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, 
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY 
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT 
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF 
 * THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 */
package org.sana.android.db.impl;

import android.content.ContentValues;
import android.net.Uri;
import android.util.Log;

import org.sana.android.db.TableHelper;
import org.sana.android.provider.Concepts;
import org.sana.core.Concept;

/**
 * A database table helper for a table of concepts.
 * 
 * @author Sana Development
 *
 */
public class ConceptsHelper extends TableHelper<Concept>{
	public static final String TAG = ConceptsHelper.class.getSimpleName();

	private static final ConceptsHelper HELPER = new ConceptsHelper();
	
	/**
	 * Gets the singleton instance of this class.
	 * 
	 * @return An instance of this class.
	 */
	public static ConceptsHelper getInstance(){
		return HELPER;
	}
	
	protected ConceptsHelper(){
		super(Concept.class);
	}
	
	/* (non-Javadoc)
	 * @see org.sana.android.db.InsertHelper#onInsert(android.net.Uri, android.content.ContentValues)
	 */
	@Override
	public ContentValues onInsert(ContentValues values) {
		if(values.containsKey(Concepts.Contract.MEDIA_TYPE) == false) {
            values.put(Concepts.Contract.MEDIA_TYPE, "text/plain");
        }
		return super.onInsert(values);
	}

	/* (non-Javadoc)
	 * @see org.sana.android.db.UpdateHelper#onUpdate(java.lang.String, android.content.ContentValues, java.lang.String, java.lang.String[])
	 */
	@Override
	public ContentValues onUpdate(Uri uri, ContentValues values) {
		return super.onUpdate(uri, values);
	}

	/* (non-Javadoc)
	 * @see org.sana.android.db.CreateHelper#onCreate(android.database.sqlite.SQLiteDatabase)
	 */
	@Override
	public String onCreate() {
		Log.i(TAG, "onCreate()");
		return "CREATE TABLE " + getTable() + " ("
		+ Concepts.Contract._ID 			+ " INTEGER PRIMARY KEY,"
		+ Concepts.Contract.UUID 			+ " TEXT,"
        + Concepts.Contract.NAME 			+ " INTEGER NOT NULL,"
        + Concepts.Contract.DISPLAY_NAME 	+ " TEXT NOT NULL,"
        + Concepts.Contract.DESCRIPTION 	+ " TEXT NOT NULL,"
        + Concepts.Contract.DATA_TYPE 		+ " TEXT NOT NULL,"
        + Concepts.Contract.MEDIA_TYPE 		+ " TEXT,"
        + Concepts.Contract.CONSTRAINT 		+ " TEXT,"
        + Concepts.Contract.CREATED 		+ " TEXT,"
        + Concepts.Contract.MODIFIED 		+ " TEXT"
        + ");";
		
	}

	/* (non-Javadoc)
	 * @see org.sana.android.db.UpgradeHelper#onUpgrade(int, int)
	 */
	@Override
	public String onUpgrade(int oldVersion, int newVersion) {
		// TODO Auto-generated method stub
		return null;
	}
	
}