StarDataSource.java

/**
 * Copyright (C) 2013 by Raphael Michel under the MIT license:
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), 
 * to deal in the Software without restriction, including without limitation 
 * the rights to use, copy, modify, merge, publish, distribute, sublicense, 
 * and/or sell copies of the Software, and to permit persons to whom the Software 
 * is furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in 
 * all copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR 
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, 
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. 
 * IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, 
 * DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, 
 * ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER 
 * DEALINGS IN THE SOFTWARE.
 */
package de.geeksfactory.opacclient.storage;

import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;

import de.geeksfactory.opacclient.OpacClient;
import de.geeksfactory.opacclient.objects.SearchResult;
import de.geeksfactory.opacclient.objects.Starred;
import de.geeksfactory.opacclient.searchfields.SearchField;

public class StarDataSource {

    private Activity context;

    public StarDataSource(Activity context) {
        this.context = context;
    }

    public static Starred cursorToItem(Cursor cursor) {
        Starred item = new Starred();
        item.setId(cursor.getInt(0));
        item.setMNr(cursor.getString(1));
        item.setTitle(cursor.getString(3));
        try {
            item.setMediaType(
                    cursor.getString(4) != null ?
                            SearchResult.MediaType.valueOf(cursor.getString(4)) :
                            null);
        } catch (IllegalArgumentException e) {
            // Do not crash on invalid media types stored in the database
        }
        return item;
    }

    public void star(String nr, String title, String bib, SearchResult.MediaType mediaType) {
        ContentValues values = new ContentValues();
        values.put("medianr", nr);
        values.put("title", title);
        values.put("bib", bib);
        values.put("mediatype", mediaType != null ? mediaType.toString() : null);
        context.getContentResolver()
               .insert(((OpacClient) context.getApplication()).getStarProviderStarUri(), values);
    }

    public List<Starred> getAllItems(String bib) {
        List<Starred> items = new ArrayList<>();
        String[] selA = {bib};
        Cursor cursor = context
                .getContentResolver()
                .query(((OpacClient) context.getApplication())
                                .getStarProviderStarUri(),
                        StarDatabase.COLUMNS, StarDatabase.STAR_WHERE_LIB,
                        selA, null);

        cursor.moveToFirst();
        while (!cursor.isAfterLast()) {
            Starred item = cursorToItem(cursor);
            items.add(item);
            cursor.moveToNext();
        }
        // Make sure to close the cursor
        cursor.close();
        return items;
    }

    public Starred getItemByTitle(String bib, String title) {
        String[] selA = {bib, title};
        Cursor cursor = context
                .getContentResolver()
                .query(((OpacClient) context.getApplication())
                                .getStarProviderStarUri(),
                        StarDatabase.COLUMNS,
                        StarDatabase.STAR_WHERE_TITLE_LIB, selA, null);
        Starred item = null;

        cursor.moveToFirst();
        if (!cursor.isAfterLast()) {
            item = cursorToItem(cursor);
            cursor.moveToNext();
        }
        // Make sure to close the cursor
        cursor.close();
        return item;
    }

    public Starred getItem(String bib, String id) {
        String[] selA = {bib, id};
        Cursor cursor = context
                .getContentResolver()
                .query(((OpacClient) context.getApplication())
                                .getStarProviderStarUri(),
                        StarDatabase.COLUMNS, StarDatabase.STAR_WHERE_NR_LIB,
                        selA, null);
        Starred item = null;

        cursor.moveToFirst();
        if (!cursor.isAfterLast()) {
            item = cursorToItem(cursor);
            cursor.moveToNext();
        }
        // Make sure to close the cursor
        cursor.close();
        return item;
    }

    public Starred getItem(long id) {
        String[] selA = {String.valueOf(id)};
        Cursor cursor = context
                .getContentResolver()
                .query(((OpacClient) context.getApplication())
                                .getStarProviderStarUri(),
                        StarDatabase.COLUMNS, StarDatabase.STAR_WHERE_ID, selA,
                        null);
        Starred item = null;

        cursor.moveToFirst();
        if (!cursor.isAfterLast()) {
            item = cursorToItem(cursor);
            cursor.moveToNext();
        }
        // Make sure to close the cursor
        cursor.close();
        return item;
    }

    public boolean isStarred(String bib, String id) {
        if (id == null) {
            return false;
        }
        String[] selA = {bib, id};
        Cursor cursor = context
                .getContentResolver()
                .query(((OpacClient) context.getApplication())
                                .getStarProviderStarUri(),
                        StarDatabase.COLUMNS, StarDatabase.STAR_WHERE_NR_LIB,
                        selA, null);
        int c = cursor.getCount();
        cursor.close();
        return (c > 0);
    }

    public boolean isStarredTitle(String bib, String title) {
        if (title == null) {
            return false;
        }
        String[] selA = {bib, title};
        Cursor cursor = context
                .getContentResolver()
                .query(((OpacClient) context.getApplication())
                                .getStarProviderStarUri(),
                        StarDatabase.COLUMNS,
                        StarDatabase.STAR_WHERE_TITLE_LIB, selA, null);
        int c = cursor.getCount();
        cursor.close();
        return (c > 0);
    }

    public void remove(Starred item) {
        String[] selA = {"" + item.getId()};
        context.getContentResolver()
               .delete(((OpacClient) context.getApplication())
                               .getStarProviderStarUri(),
                       StarDatabase.STAR_WHERE_ID, selA);
    }

    public void renameLibraries(Map<String, String> map) {
        for (Entry<String, String> entry : map.entrySet()) {
            ContentValues cv = new ContentValues();
            cv.put("bib", entry.getValue());

            context.getContentResolver()
                   .update(((OpacClient) context.getApplication())
                                   .getStarProviderStarUri(),
                           cv, StarDatabase.STAR_WHERE_LIB,
                           new String[]{entry.getKey()});
        }
    }
}