Android Open Source - Look Look S Q L Helper

From Project

Back to project page Look.

License

The source code is released under:

====================== LOOK! LICENSING TERMS ====================== look! is licensed under the BSD 3-Clause (also known as "BSD New" or "BSD Simplified"), as follows: Copyright (c) 2010-2012, Look...

If you think the Android project Look listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.

Java Source Code

/**
*-----------------------------------------------------------------------------
* Copyright (c) 2012, Look! Development Team
* All rights reserved.//ww  w.j a v a  2  s  . c  o  m
*
* Distributed under the terms of the BSD Simplified License.
*
* The full license is in the LICENSE file, distributed with this software.
*-----------------------------------------------------------------------------
*/
package es.ucm.look.data.local.contentprovider.sql;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import es.ucm.look.data.local.contentprovider.LookContentProvider;
import es.ucm.look.data.remote.LookProperties;

/**
 * It class help to {@link LookContentProvider}, it has the Database Version,
 * the Tables Names and it creates a new Database SQLite on the device if it not
 * exits
 * 
 * @author Sergio
 * 
 */
public class LookSQLHelper extends SQLiteOpenHelper {

  public static final int DATABASE_VERSION = 1;

  public static final String MAIN_TABLENAME = "mainTable";
  public static final String PROPERTIES_TABLENAME = "propertiesTable";

  public static final String MAIN_PROJECTION_ALL_FIELDS[] = new String[] {
      LookProperties.FIELD_ID, LookProperties.FIELD_POS_X,
      LookProperties.FIELD_POS_Y, LookProperties.FIELD_POS_Z,
      LookProperties.FIELD_LAST_UPDATE };

  public static final String PROPERTIES_PROJECTION_ALL_FIELDS[] = new String[] {
      LookProperties.FIELD_ID, LookProperties.FIELD_PROPERTY,
      LookProperties.FIELD_VALUE };

  public static final String PROPERTIES_PROJECTION_ID[] = new String[] { LookProperties.FIELD_ID };

  public LookSQLHelper(Context context, String databaseName) {
    super(context, databaseName, null, DATABASE_VERSION);
  }

  @Override
  public void onCreate(SQLiteDatabase db) {
    /*
     * Esto se ejecutara solo si se va a crear la base de datos. Si solo se
     * va a acceder a ella no se ejecutara
     */

    db.execSQL("CREATE TABLE " + MAIN_TABLENAME + " ("
        + LookProperties.FIELD_ID + " INTEGER PRIMARY KEY,"
        + LookProperties.FIELD_POS_X + " REAL,"
        + LookProperties.FIELD_POS_Y + " REAL,"
        + LookProperties.FIELD_POS_Z + " REAL,"
        + LookProperties.FIELD_LAST_UPDATE + " DATE)");

    db.execSQL("CREATE TABLE " + PROPERTIES_TABLENAME + " ("
        + LookProperties.FIELD_ID + " INTEGER,"
        + LookProperties.FIELD_PROPERTY + " TEXT,"
        + LookProperties.FIELD_VALUE + " TEXT," + "PRIMARY KEY("
        + LookProperties.FIELD_ID + "," + LookProperties.FIELD_PROPERTY
        + "))");

  }

  @Override
  public void onUpgrade(SQLiteDatabase db, int arg1, int arg2) {

  }

  @Override
  public void onOpen(SQLiteDatabase db) {

  }

}

Java Source Code List