RecentStationsDao.java

package fm.last.android.db;

import java.util.Collections;
import java.util.List;

import android.content.ContentValues;
import android.database.Cursor;
import fm.last.api.Station;

/**
 * The DAO to access the table containing the recently played stations.
 * @author twa
 */
public class RecentStationsDao extends AbstractDao<Station>
{
	
	/**
	 * The table for the recent stations list.
	 */
	public static final String DB_TABLE_RECENTSTATIONS = "t_recentstations";
	
	/*
	 * (non-Javadoc)
	 * @see fm.last.android.db.AbstractDao#getTableName()
	 */
	@Override
	protected String getTableName() 
	{	
		return DB_TABLE_RECENTSTATIONS;
	}
	
	/**
	 * The {@link RecentStationsDao} singleton instance.
	 */
	private static RecentStationsDao instance = null;

	/**
	 * @return the {@link RecentStationsDao} singleton instance.
	 */
	public static RecentStationsDao getInstance() 
	{
		if(instance != null) {
			return instance;
		} 
		else {
			instance = new RecentStationsDao();
			return instance;
		}
	}

	/**
	 * Append a new station to the list
	 * @param url the station's Last.fm URL
	 * @param name the station's display name
	 */
	public synchronized void appendRecentStation(String url, String name) 
	{
		save(Collections.singletonList(new Station(name, null, url, null)));
	}
	
	/**
	 * Read the last added station.
	 * @return the last station that has been added to the list.
	 */
	public synchronized Station getLastStation() 
	{
		List<Station> stations = loadWithQualification("ORDER BY Timestamp DESC LIMIT 4");
		if (stations!=null && stations.size()>0) {
			return stations.get(0);
		}
		return null;
	}
	
	/**
	 * Get the list of recent stations.
	 * @return all stations in the table.
	 */
	public synchronized List<Station> getRecentStations() 
	{
		return loadWithQualification("ORDER BY Timestamp DESC LIMIT 10");
	}
	
	/*
	 * (non-Javadoc)
	 * @see fm.last.android.db.AbstractDao#buildObject(android.database.Cursor)
	 */
	@Override
	protected synchronized Station buildObject(Cursor c) 
	{
		String name = c.getString(c.getColumnIndex("Name"));
		String url = c.getString(c.getColumnIndex("Url"));
		return new Station(name, "", url, "");
	}
	
	/*
	 * (non-Javadoc)
	 * @see fm.last.android.db.AbstractDao#fillContent(android.content.ContentValues, java.lang.Object)
	 */
	@Override
	protected synchronized void fillContent(ContentValues content, Station data) 
	{
		content.put("Url", data.getUrl());
		content.put("Name", data.getName());
		content.put("Timestamp", System.currentTimeMillis());
	}
		
}