AlbumDatabase.java

package com.sound.ampache.utility;

/* Copyright (c) 2010 Jacob Alexander < haata@users.sf.net >
 *
 * +------------------------------------------------------------------------+
 * | 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 2         |
 * | 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, write to the Free Software            |
 * | Foundation, Inc., 59 Temple Place - Suite 330,                         |
 * | Boston, MA  02111-1307, USA.                                           |
 * +------------------------------------------------------------------------+
 */


import android.content.Context;
import android.util.Log;

import com.sound.ampache.objects.Album;

import java.util.ArrayList;
import java.util.Date;

public class AlbumDatabase extends Database
{

	// Constructors **************************************************

	AlbumDatabase(Context context, String databaseName)
	{
		super(context);

		type = "Album";

		DATABASE_NAME = databaseName;
		TABLE_NAME = "AlbumCache";

		COLUMN_NAMES.add("artist");
		COLUMN_NAMES.add("tracks");
		COLUMN_NAMES.add("disk");
		COLUMN_NAMES.add("year");

		completeTableCreateParam();
	}


	// Functions *****************************************************

	public boolean addEntry(String id, String albumName, String numberOfTracks, String disk, String year)
	{
		// Get the current time, and convert it to a string
		String time = Long.toString((new Date()).getTime() / 1000); // NOTE: will be used later

		// Build Insert Query
		String queryString = "INSERT INTO " + TABLE_NAME + " " + columnList() + " VALUES (" +
				id + ", '" +
				albumName + "', '" +
				numberOfTracks + "', '" +
				disk + "', '" +
				year + ");";

		try {
			db.execSQL(queryString);
		} catch (Exception exc) {
			// Damn...
			Log.e("Amdroid", "Database/Artist - Insertion Failure... " + queryString);
			return false;
		}

		return true;
	}

	public boolean addEntry(Album entry)
	{
		return addEntry(entry.id, entry.name, entry.tracks, entry.disk, entry.year);
	}

	public boolean addEntries(ArrayList<Album> list)
	{
		for (int c = 0; c < list.size(); c++)
			if (!addEntry(list.get(c)))
				return false;

		return true;
	}

}