Ejemplo n.º 1
0
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
   Logger.dLog(
       TAG,
       "=============== upgrade database"
           + "oldVersion is:"
           + oldVersion
           + "newVersion is:"
           + newVersion
           + "DATABASE_VERSION is:"
           + DATABASE_VERSION);
   upgradeBookTable(db, oldVersion, newVersion);
   upgradeBookMarkTable(db, oldVersion, newVersion);
 }
Ejemplo n.º 2
0
  // modify by zenki-zha-xxx
  static {
    IEngineService ies = (IEngineService) ERManager.getService(ERManager.ERENGINE_SERVICE);

    String libPath = ies.getConfig().getLibraryPath();
    String soPath = libPath + File.separator + "libDeflatingDecompressor-v3.so";

    try {
      if (libPath.equals(EngineConfig.DEFAULT_LIBRARY_LOCAL)) {
        System.loadLibrary("DeflatingDecompressor-v3");
      } else {
        System.load(soPath);
      }
    } catch (Exception e) {
      Logger.eLog("EREngine", "load libDeflatingDecompressor-v3.so = " + e.getMessage());
    }
  }
Ejemplo n.º 3
0
  private void createBookTable(SQLiteDatabase db) {
    String createString;
    String bookColumns;

    bookColumns =
        BookColumns.FILE_PATH
            + " TEXT, "
            + BookColumns.FILE_NAME
            + " TEXT, "
            + BookColumns.FILE_TYPE
            + " TEXT ,"
            + BookColumns.LAST_LOCATION
            + " TEXT, "
            + BookColumns.LAST_PAGE_NUM
            + " INTEGER, "
            + BookColumns.TOTAL_PAGE_NUM
            + " INTEGER, "
            + BookColumns.LAST_ACCESS_TIME
            + " BIGINT, "
            + BookColumns.META_TITLE
            + " TEXT, "
            + BookColumns.META_AUTHOR
            + " TEXT, "
            + BookColumns.META_PUBLISHER
            + " TEXT, "
            + BookColumns.META_ENCODING
            + " TEXT, "
            + BookColumns.META_LANGUAGE
            + " TEXT, "
            + BookColumns.USER_NAME
            + " TEXT, "
            + BookColumns.PASSWORD
            + " TEXT, "
            + BookColumns.VIEW_WIDTH
            + " INTEGER, "
            + BookColumns.VIEW_HEIGHT
            + " INTEGER, "
            + BookColumns.FONT_LEVEL
            + " INTEGER, "
            + BookColumns.FILE_SIZE
            + " INTEGER "
            + ");";

    createString = " (" + BookColumns._ID + " integer primary key autoincrement, " + bookColumns;
    db.execSQL("create table " + BOOKINFO_TABLE_NAME + createString);

    // set index
    String indexColumns[] = {BookColumns.FILE_PATH, BookColumns.FILE_NAME, BookColumns.META_AUTHOR};

    // add index to book table
    for (String columnName : indexColumns) {
      db.execSQL(createIndex(BOOKINFO_TABLE_NAME, columnName));
    }

    // add trigger to book table
    // when book delete, in bookMark table,bookMark.book_id = book._id this
    // record is delete

    try {
      db.execSQL(
          "CREATE TRIGGER delete_book_table_trigger AFTER DELETE ON "
              + BOOKINFO_TABLE_NAME
              + " for each row BEGIN "
              + " DELETE FROM "
              + BOOKMARK_TABLE_NAME
              + " WHERE book_id = OLD._id;"
              + " END;");

      db.execSQL(
          "CREATE TRIGGER delete_book_table_trigger2 AFTER DELETE ON "
              + BOOKINFO_TABLE_NAME
              + " for each row BEGIN "
              + " DELETE FROM "
              + BOOKEMPHASIS_TABLE_NAME
              + " WHERE book_id = OLD._id;"
              + " END;");
    } catch (SQLException e) {
      Logger.eLog(TAG, "create trigger exception = " + e);
    }
  }