Android Open Source - magicAnnotator Player Dao Impl

• Back to Game/golf  ↑

From Project

Back to project page magicAnnotator.

License

The source code is released under:

GNU General Public License

Java Source Code

/*
 * Magic Annotator - The only thing you need to write down whatever you want.
 * Copyright (C) 2013 Nahuel Barrios <barrios.nahuel@gmail.com>.
 */* w  w  w.j  av  a  2  s.  co m*/
 *     This program is free software: you can redistribute it and/or modify
 *     it under the terms of the GNU General Public License as published by
 *     the Free Software Foundation, either version 3 of the License, or
 *     (at your option) any later version.
 *
 *     This program is distributed in the hope that it will be useful,
 *     but WITHOUT ANY WARRANTY; without even the implied warranty of
 *     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *     GNU General Public License for more details.
 *
 *     You should have received a copy of the GNU General Public License
 *     along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */

/**
 * Created by: Nahuel Barrios.
 * On: 17/10/12 at 09:00hs.
 */
package com.nbempire.android.magicannotator.dao.impl;

import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;
import com.nbempire.android.magicannotator.dao.PlayerDao;
import com.nbempire.android.magicannotator.domain.Player;
import com.nbempire.android.magicannotator.storage.schema.PlayerTable;

import java.util.ArrayList;
import java.util.List;

/**
 * Implementatino of PlayerDao for the Player entity.
 *
 * @author Nahuel Barrios.
 * @since 13
 */
public class PlayerDaoImpl implements PlayerDao {

    /**
     * Tag for class' log.
     */
    private static final String LOG_TAG = "PlayerDaoImpl";

    /**
     * Application DB.
     */
    private final SQLiteDatabase magicAnnotatorDB;

    /**
     * Constructor method for this DAO.
     *
     * @param database
     *         The database where the table is.
     *
     * @since 13
     */
    public PlayerDaoImpl(SQLiteDatabase database) {
        this.magicAnnotatorDB = database;
    }

    @Override
    public List<Player> findAll() {
        List<Player> players = new ArrayList<Player>();

        Cursor cursor = magicAnnotatorDB.query(PlayerTable.TABLE_NAME, null, null, null, null, null, null);
        for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) {

            Player player = new Player(cursor.getString(cursor.getColumnIndex(PlayerTable.NICKNAME)));
            player.setId(cursor.getInt(cursor.getColumnIndex(PlayerTable.ID)));

            Log.d(LOG_TAG, "Getting " + player.getNickName() + "\twith ID: " + player.getId() + "\tfrom DB.");
            players.add(player);
        }

        //  TODO : Refactor : Should I close this Cursor object? Check startManagingCursor(cursor) method.

        return players;
    }

    @Override
    public void save(Player player) {
        ContentValues columnsAndValues = new ContentValues();

        columnsAndValues.put(PlayerTable.NICKNAME, player.getNickName());
        long createdId = magicAnnotatorDB.insert(PlayerTable.TABLE_NAME, "null", columnsAndValues);

        if (createdId == -1) {
            Log.e(LOG_TAG, "There was an error trying to save the Player: " + player.getNickName());
        } else {
            Log.i(LOG_TAG, "Created Player with ID: " + createdId);
        }

    }

    @Override
    public void deleteAll() {
        String tableName = PlayerTable.TABLE_NAME;
        int deletedRows = magicAnnotatorDB.delete(tableName, "1", null);
        Log.i(LOG_TAG, "Deleted " + deletedRows + " rows from table " + tableName + " in DB.");
    }
}

Java Source Code List

• Back to Game/golf  ↑