org.solovyev.android.db.CommonSQLiteOpenHelper Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of android-common-samples Show documentation
There is a newer version: 1.1.18
Show newest version
/*
 * Copyright 2013 serso aka se.solovyev
 *
 * 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.
 *
 * ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 * Contact details
 *
 * Email: [email protected]
 * Site:  http://se.solovyev.org
 */

package org.solovyev.android.db;

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

import javax.annotation.Nonnull;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.text.DecimalFormat;
import java.text.DecimalFormatSymbols;
import java.util.Locale;
import java.util.Scanner;

public class CommonSQLiteOpenHelper extends SQLiteOpenHelper {

	private static final String TAG = "DbOperation";

	@Nonnull
	protected final Context context;

	@Nonnull
	private String databaseName;

	private int version;

	public CommonSQLiteOpenHelper(@Nonnull Context context, @Nonnull SQLiteOpenHelperConfiguration configuration) {
		super(context.getApplicationContext(), configuration.getName(), configuration.getCursorFactory(), configuration.getVersion());
		this.context = context.getApplicationContext();
		this.databaseName = configuration.getName();
		this.version = configuration.getVersion();
	}

	@Override
	public void onCreate(@Nonnull SQLiteDatabase db) {
		onUpgrade(db, 0, this.version);
	}

	@Override
	public void onUpgrade(@Nonnull SQLiteDatabase db, int oldVersion, int newVersion) {
		Log.d(TAG, "Upgrading database, old version: " + oldVersion + ", new version: " + newVersion);

		final DecimalFormat decimalFormat = new DecimalFormat("000", new DecimalFormatSymbols(Locale.US));

		for (int version = oldVersion + 1; version <= newVersion; version++) {
			try {
				// prepare version based postfix
				final String fileVersionPostfix = decimalFormat.format(version);

				final String fileName = "db_" + databaseName + "_" + fileVersionPostfix + ".sql";

				Log.d(TAG, "Reading " + fileName + "...");

				// read sqls from file
				final String sqls = convertStreamToString(context.getAssets().open(fileName));

				Log.d(TAG, fileName + " successfully read, size: " + sqls.length());


				// batch execute
				new BatchDbTransaction(sqls, ";\n").batchQuery(db);

			} catch (FileNotFoundException e) {
				Log.d(TAG, e.getMessage());
				// ok, probably file not exists
			} catch (IOException e) {
				Log.e(TAG, e.getMessage());
				throw new RuntimeException(e);
			}
		}
	}

	@Nonnull
	public String convertStreamToString(java.io.InputStream is) {
		try {
			return new Scanner(is, "UTF-8").useDelimiter("\\A").next();
		} catch (java.util.NoSuchElementException e) {
			return "";
		}
	}
}