DBAdapterV6.java

package org.ebookdroid.common.settings.books;

import org.ebookdroid.common.settings.types.DocumentViewMode;
import org.ebookdroid.common.settings.types.PageAlign;
import org.ebookdroid.common.settings.types.RotationType;
import org.ebookdroid.core.PageIndex;
import org.ebookdroid.core.curl.PageAnimationType;

import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

import java.util.Map;

class DBAdapterV6 extends DBAdapterV5 {

    public static final int VERSION = 6;

    public static final long F_NIGHT_MODE = 1 << 2;

    public static final long F_AUTO_LEVELS = 1 << 3;

    public static final long F_NIGHT_MODE_POS_IMAGES = 1 << 4;

    public static final long F_ROTAION_OVR = 1 << 5;

    public static final long F_ROTAION_LAND = 1 << 6;

    public static final long F_SPLIT_RTL = 1 << 7;

    public static final long F_ROTATION_AUTO = 1 << 8;

    public static final String DB_BOOK_CREATE = "create table book_settings ("
    // Book file path
            + "book varchar(1024) primary key, "
            // Last update time
            + "last_updated integer not null, "
            // Current document page
            + "doc_page integer not null, "
            // Current view page - dependent on view mode
            + "view_page integer not null, "
            // Page zoom
            + "zoom integer not null, "
            // View mode
            + "view_mode integer not null, "
            // Page align
            + "page_align integer not null, "
            // Page animation type
            + "page_animation integer not null, "
            // Book flags
            + "flags long not null, "
            // Offset x
            + "offset_x integer not null, "
            // Offset y
            + "offset_y integer not null, "
            // Contrast
            + "contrast integer not null, "
            // Exposure
            + "exposure integer not null"
            // ...
            + ");"
    //
    ;

    public static final String DB_BOOK_GET_ALL = "SELECT book, last_updated, doc_page, view_page, zoom, view_mode, page_align, page_animation, flags, offset_x, offset_y, contrast, exposure FROM book_settings ORDER BY book ASC";

    public static final String DB_BOOK_GET_RNT = "SELECT book, last_updated, doc_page, view_page, zoom, view_mode, page_align, page_animation, flags, offset_x, offset_y, contrast, exposure FROM book_settings where last_updated > 0 ORDER BY last_updated DESC";

    public static final String DB_BOOK_GET_ONE = "SELECT book, last_updated, doc_page, view_page, zoom, view_mode, page_align, page_animation, flags, offset_x, offset_y, contrast, exposure FROM book_settings WHERE book=?";

    public static final String DB_BOOK_STORE = "INSERT OR REPLACE INTO book_settings (book, last_updated, doc_page, view_page, zoom, view_mode, page_align, page_animation, flags, offset_x, offset_y, contrast, exposure) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

    public DBAdapterV6(final DBSettingsManager manager) {
        super(manager);
    }

    @Override
    public void onCreate(final SQLiteDatabase db) {
        db.execSQL(DB_BOOK_CREATE);
        db.execSQL(DB_BOOKMARK_CREATE);
    }

    @Override
    public Map<String, BookSettings> getAllBooks() {
        return getBookSettings(DB_BOOK_GET_ALL, true);
    }

    @Override
    public Map<String, BookSettings> getRecentBooks(final boolean all) {
        return getBookSettings(DB_BOOK_GET_RNT, all);
    }

    @Override
    public BookSettings getBookSettings(final String fileName) {
        return getBookSettings(DB_BOOK_GET_ONE, fileName);
    }

    @Override
    protected void storeBookSettings(final BookSettings bs, final SQLiteDatabase db) {
        final Object[] args = new Object[] {
                // File name
                bs.fileName,
                // Last update
                bs.lastUpdated,
                // Current document page
                bs.currentPage.docIndex,
                // Current view page
                bs.currentPage.viewIndex,
                // Current page zoom
                bs.zoom,
                // Single page on/off
                bs.viewMode.ordinal(),
                // Page align
                bs.pageAlign.ordinal(),
                // Page animation type
                bs.animationType.ordinal(),
                // Flags
                getFlags(bs),
                // Offset x
                (int) (bs.offsetX * OFFSET_FACTOR),
                // Offset y
                (int) (bs.offsetY * OFFSET_FACTOR),
                // Contrast
                bs.contrast,
                // Contrast
                bs.exposure
        // ...
        };

        db.execSQL(DB_BOOK_STORE, args);

        updateBookmarks(bs, db);
    }

    @Override
    protected BookSettings createBookSettings(final Cursor c) {
        int index = 0;

        final BookSettings bs = new BookSettings(c.getString(index++));
        bs.lastUpdated = c.getLong(index++);
        bs.currentPage = new PageIndex(c.getInt(index++), c.getInt(index++));
        bs.zoom = c.getInt(index++);
        bs.viewMode = DocumentViewMode.getByOrdinal(c.getInt(index++));
        bs.pageAlign = PageAlign.values()[c.getInt(index++)];
        bs.animationType = PageAnimationType.values()[c.getInt(index++)];

        setFlags(bs, c.getLong(index++));

        bs.offsetX = c.getInt(index++) / OFFSET_FACTOR;
        bs.offsetY = c.getInt(index++) / OFFSET_FACTOR;

        bs.contrast = c.getInt(index++);
        bs.exposure = c.getInt(index++);

        return bs;
    }

    protected long getFlags(final BookSettings bs) {
        return
        /* Split page flag */
        (bs.splitPages ? F_SPLIT_PAGES : 0) |
        /* Crop page flag */
        (bs.cropPages ? F_CROP_PAGES : 0) |
        /* Night mode flag */
        (bs.nightMode ? F_NIGHT_MODE : 0) |
        /* Auto-level flag */
        (bs.autoLevels ? F_AUTO_LEVELS : 0) |
        /* Positive image flag */
        (bs.positiveImagesInNightMode ? F_NIGHT_MODE_POS_IMAGES : 0) |
        /* Rotation flags */
        getRotationFlags(bs) |
        /* Positive image flag */
        (bs.splitRTL ? F_SPLIT_RTL : 0);

    }

    protected long getRotationFlags(final BookSettings bs) {
        if (bs.rotation == null || bs.rotation == RotationType.UNSPECIFIED) {
            return 0;
        }
        if (bs.rotation == RotationType.AUTOMATIC) {
            return F_ROTAION_OVR | F_ROTATION_AUTO;
        }
        return F_ROTAION_OVR | (bs.rotation == RotationType.LANDSCAPE ? F_ROTAION_LAND : 0);
    }

    protected void setFlags(final BookSettings bs, final long flags) {
        bs.splitPages = (flags & F_SPLIT_PAGES) != 0;
        bs.cropPages = (flags & F_CROP_PAGES) != 0;
        bs.nightMode = (flags & F_NIGHT_MODE) != 0;
        bs.positiveImagesInNightMode = (flags & F_NIGHT_MODE_POS_IMAGES) != 0;
        bs.autoLevels = (flags & F_AUTO_LEVELS) != 0;

        if ((flags & F_ROTAION_OVR) != 0) {
            if ((flags & F_ROTATION_AUTO) != 0) {
                bs.rotation = RotationType.AUTOMATIC;
            } else {
                bs.rotation = (flags & F_ROTAION_LAND) != 0 ? RotationType.LANDSCAPE : RotationType.PORTRAIT;
            }
        } else {
            bs.rotation = RotationType.UNSPECIFIED;
        }

        bs.splitRTL = (flags & F_SPLIT_RTL) != 0;
    }
}