package de.philipphager.disclosure.database;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import de.philipphager.disclosure.database.app.model.App;
import de.philipphager.disclosure.database.feature.model.Feature;
import de.philipphager.disclosure.database.library.model.Library;
import de.philipphager.disclosure.database.library.model.LibraryApp;
import de.philipphager.disclosure.database.library.model.LibraryFeature;
import de.philipphager.disclosure.database.library.populator.LibraryPopulator;
import de.philipphager.disclosure.database.migration.Migrator;
import de.philipphager.disclosure.database.version.model.Version;
import javax.inject.Inject;

public class DatabaseOpenHelper extends SQLiteOpenHelper {
  private static final String DB_NAME = "disclosure.db";
  private static final int DB_VERSION = 24;
  private final Migrator migrator;
  private final LibraryPopulator libraryPopulator;

  @Inject
  public DatabaseOpenHelper(Context context, Migrator migrator, LibraryPopulator libraryPopulator) {
    super(context, DB_NAME, null, DB_VERSION);
    this.migrator = migrator;
    this.libraryPopulator = libraryPopulator;
  }

  @Override public void onCreate(SQLiteDatabase db) {
    // Initial SQL schema creation
    db.execSQL(App.CREATE_TABLE);
    db.execSQL(Version.CREATE_TABLE);
    db.execSQL(Library.CREATE_TABLE);
    db.execSQL(LibraryApp.CREATE_TABLE);
    db.execSQL(Feature.CREATE_TABLE);
    db.execSQL(LibraryFeature.CREATE_TABLE);

    // Populate db with initial values
    libraryPopulator.populate(db);
  }

  @Override public void onConfigure(SQLiteDatabase db) {
    db.setForeignKeyConstraintsEnabled(true);
  }

  @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    migrator.migrate(db, oldVersion, newVersion);
  }
}

package de.philipphager.disclosure.database;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import de.philipphager.disclosure.database.app.model.App;
import de.philipphager.disclosure.database.feature.model.Feature;
import de.philipphager.disclosure.database.library.model.Library;
import de.philipphager.disclosure.database.library.model.LibraryApp;
import de.philipphager.disclosure.database.library.model.LibraryFeature;
import de.philipphager.disclosure.database.library.populator.LibraryPopulator;
import de.philipphager.disclosure.database.migration.Migrator;
import de.philipphager.disclosure.database.version.model.Version;
import javax.inject.Inject;

public class DatabaseOpenHelper extends SQLiteOpenHelper {
  private static final String DB_NAME = "disclosure.db";
  private static final int DB_VERSION = 24;
  private final Migrator migrator;
  private final LibraryPopulator libraryPopulator;

  @Inject
  public DatabaseOpenHelper(Context context, Migrator migrator, LibraryPopulator libraryPopulator) {
    super(context, DB_NAME, null, DB_VERSION);
    this.migrator = migrator;
    this.libraryPopulator = libraryPopulator;
  }

  @Override public void onCreate(SQLiteDatabase db) {
    // Initial SQL schema creation
    db.execSQL(App.CREATE_TABLE);
    db.execSQL(Version.CREATE_TABLE);
    db.execSQL(Library.CREATE_TABLE);
    db.execSQL(LibraryApp.CREATE_TABLE);
    db.execSQL(Feature.CREATE_TABLE);
    db.execSQL(LibraryFeature.CREATE_TABLE);
  }

  @Override public void onConfigure(SQLiteDatabase db) {
    db.setForeignKeyConstraintsEnabled(true);
  }

  @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    migrator.migrate(db, oldVersion, newVersion);
  }
}

Remove debug population of database