Android Open Source - android-grog-db Grog D B

• Back to SQLite/API  ↑

From Project

Back to project page android-grog-db.

License

The source code is released under:

Apache License

Java Source Code

/***
  Copyright (c) 2012 sprogcoder <sprogcoder@gmail.com>
  //from  w  w  w . j ava  2  s.c o m
  Licensed under the Apache License, Version 2.0 (the "License"); you may
  not use this file except in compliance with the License. You may obtain
  a copy of the License at
  
    http://www.apache.org/licenses/LICENSE-2.0
    
  Unless required by applicable law or agreed to in writing, software
  distributed under the License is distributed on an "AS IS" BASIS,
  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  See the License for the specific language governing permissions and
  limitations under the License.
 */

package com.sprogcoder.grogdb;

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

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

public class GrogDB
{

  private List<GrogTable> tables;
  private String databaseName;
  private String databaseTag;
  private int databaseVersion;
  private DatabaseHelper mDbHelper;
  private GrogDBListener listener;

  public GrogDB(String databaseName, String databaseTag, int databaseVersion, GrogDBListener listener)
  {
    this.listener = listener;
    this.tables = new ArrayList<GrogTable>();
    this.databaseName = databaseName;
    this.databaseTag = databaseTag;
    this.databaseVersion = databaseVersion;
  }

  public GrogDB addTable(GrogTable table)
  {
    tables.add(table);
    return this;
  }

  public GrogDB create(Context context)
  {
    if (mDbHelper == null)
    {
      synchronized (GrogDB.class)
      {
        if (mDbHelper == null)
        {
          mDbHelper = new DatabaseHelper(context);
          setTablesDatabaseHelper();
        }
      }
    }
    return this;
  }

  private void setTablesDatabaseHelper()
  {
    for (GrogTable table : tables)
    {
      table.setDatabaseHelper(mDbHelper);
    }
  }

  /**
   * Internal Database
   */
  private class DatabaseHelper extends SQLiteOpenHelper
  {

    DatabaseHelper(Context context)
    {
      super(context, databaseName, null, databaseVersion);
      Log.v(databaseTag, "DatabaseHelper() - Database " + databaseName + " Ready - Version: " + databaseVersion);
    }

    @Override
    public void onCreate(SQLiteDatabase db)
    {
      createTables(db);
      Log.v(databaseTag, "onCreate() - Created New Database - DatabaseName: " + databaseName);
    }

    private void createTables(SQLiteDatabase db)
    {
      for (GrogTable table : tables)
      {
        db.execSQL(table.getSqlCreate());
      }
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
    {
      listener.upgradeDatabase(db, oldVersion, newVersion);
      Log.v(databaseTag, "onUpgrade() - Upgrading Database - DatabaseName: " + databaseName);
    }

  }

}

Java Source Code List

• Back to SQLite/API  ↑