Android Open Source - twitt4droid Twitt4droid Database Helper

From Project

Back to project page twitt4droid.

License

The source code is released under:

Apache License

If you think the Android project twitt4droid 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 2014 Daniel Pedraza-Arcega//w w  w.j  ava  2s  .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.twitt4droid.data.source;

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

import com.twitt4droid.R;

import java.io.IOException;
import java.io.InputStream;

/**
 * Creates and manages the twitt4droid SQLite database. 
 * 
 * @author Daniel Pedraza-Arcega
 * @since version 1.0
 */
public class Twitt4droidDatabaseHelper extends SQLiteOpenHelper {

    private static final int CURRENT_VERSION = 1;
    private static final String TAG = Twitt4droidDatabaseHelper.class.getSimpleName();
    private static final String NAME = "twitt4droid";
    
    private final int version;
    private final Context context;

    /**
     * Creates a Twitt4droidDatabaseHelper.
     * 
     * @param context the application context.
     */
    public Twitt4droidDatabaseHelper(Context context) {
        super(context, NAME, null, CURRENT_VERSION);
        this.context = context;
        version = CURRENT_VERSION;
    }

    /** {@inheritDoc} */
    @Override
    public void onCreate(SQLiteDatabase database) {
        Log.v(TAG, "Creating database version " + version + "...");
        InputStream fileStream = context.getResources().openRawResource(R.raw.db_schema);
        String[] statements = SQLFileParser.getSqlStatements(fileStream);
        for (String statement : statements) database.execSQL(statement);
        if (fileStream != null) {
            try {
                fileStream.close();
            } catch (IOException ex) {
                Log.e(TAG, "Couldn't close stream", ex);
            }
        }
    }

    /** {@inheritDoc} */
    @Override
    public void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) {
        Log.v(TAG, "Destroying version " + oldVersion + "...");
        destroyDb(context);
        onCreate(database);
    }

    /**
     * Destroys the twitt4droid database.
     * 
     * @param context the application context.
     */
    public static void destroyDb(Context context) {
        context.deleteDatabase(NAME);
    }
}

Java Source Code List