Android Open Source - AquaBase Database Helper

• Back to Development/data  ↑

From Project

Back to project page AquaBase.

License

The source code is released under:

GNU General Public License

Java Source Code

/*
 *  This file is part of AquaBase./*from  w w w  .j a  v a 2 s .  c o  m*/
 *
 *  AquaBase 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.
 *
 *  AquaBase 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 AquaBase.  If not, see <http://www.gnu.org/licenses/>.
 *
 *  Copyright (c) 2014 Cdric Bosdonnat <cedric@bosdonnat.fr>
 */
package org.aquabase.data;

import java.text.MessageFormat;

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

public class DatabaseHelper extends SQLiteOpenHelper {

    private static final String DATABASE_NAME = "aquabase.db"; //$NON-NLS-1$
    private static final int DATABASE_VERSION = 1;

    public static final String COLUMN_ID = "_id";                      //$NON-NLS-1$
    public static final String COLUMN_SCI_NAME = "scientificName";     //$NON-NLS-1$

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

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(CrustaceanTableHelper.getCreateSQL());
        db.execSQL(FishTableHelper.getCreateSQL());
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        String pattern = "Upgrading database from version {0} to {1}," //$NON-NLS-1$
                       + "which will destroy all old data"; //$NON-NLS-1$
        String msg = MessageFormat.format(pattern, oldVersion, newVersion);
        Log.w(DatabaseHelper.class.getName(), msg);

        db.execSQL(CrustaceanTableHelper.getDropSql());
        db.execSQL(FishTableHelper.getDropSql());
        onCreate(db);
    }

    public static void delete(Context context) {
        context.deleteDatabase(DATABASE_NAME);
    }

    public static void loadCsv(Context context) {
        // Make sure we have the database file
        CrustaceanTableHelper.loadCsv(context);
        FishTableHelper.loadCsv(context);
    }
}

Java Source Code List

• Back to Development/data  ↑