CommentaireManager.java

/**
 * Copyright (C) 2013 Romain Guefveneu.
 *   
 *  This file is part of naonedbus.
 *   
 *  Naonedbus 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.
 *  
 *  Naonedbus 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/>.
 */
package net.naonedbus.manager.impl;

import java.io.IOException;
import java.util.List;

import net.naonedbus.bean.Commentaire;
import net.naonedbus.manager.SQLiteManager;
import net.naonedbus.provider.impl.CommentaireProvider;
import net.naonedbus.provider.table.CommentaireTable;
import net.naonedbus.rest.controller.impl.CommentaireController;

import org.json.JSONException;

import android.content.ContentResolver;
import android.content.ContentValues;
import android.database.Cursor;
import android.net.Uri;

public class CommentaireManager extends SQLiteManager<Commentaire> {

	private static CommentaireManager sInstance;

	private static final long UP_TO_DATE_DELAY = 300000; // 5 min de cache

	private long mLastUpdateTimestamp = -1;

	private int mColId;
	private int mColCodeLigne;
	private int mColCodeSens;
	private int mColCodeArret;
	private int mColMessage;
	private int mColSource;
	private int mColTimestamp;

	public static synchronized CommentaireManager getInstance() {
		if (sInstance == null) {
			sInstance = new CommentaireManager();
		}

		return sInstance;
	}

	private CommentaireManager() {
		super(CommentaireProvider.CONTENT_URI);
	}

	public boolean isUpToDate() {
		return mLastUpdateTimestamp + UP_TO_DATE_DELAY >= System.currentTimeMillis();
	}

	public List<Commentaire> getAll(final ContentResolver contentResolver, final String codeLigne,
			final String codeSens, final String codeArret) {

		final Uri.Builder builder = CommentaireProvider.CONTENT_URI.buildUpon();
		if (codeLigne != null) {
			builder.appendPath(codeLigne);
			if (codeSens != null) {
				builder.appendPath(codeSens);
				if (codeArret != null) {
					builder.appendPath(codeArret);
				}
			}
		}

		final Cursor c = contentResolver.query(builder.build(), null, null, null, null);
		return getFromCursor(c);
	}

	public void updateCache(final ContentResolver contentResolver) throws IOException, JSONException {
		final CommentaireController commentaireController = new CommentaireController();

		try {
			final List<Commentaire> data = commentaireController.getAll(null, null, null);
			clear(contentResolver);
			fillDB(contentResolver, data);
		} finally {
			mLastUpdateTimestamp = System.currentTimeMillis();
		}

	}

	public void clear(final ContentResolver contentResolver) {
		contentResolver.delete(CommentaireProvider.CONTENT_URI, null, null);
	}

	@Override
	public void onIndexCursor(final Cursor c) {
		mColId = c.getColumnIndex(CommentaireTable._ID);
		mColCodeLigne = c.getColumnIndex(CommentaireTable.CODE_LIGNE);
		mColCodeSens = c.getColumnIndex(CommentaireTable.CODE_SENS);
		mColCodeArret = c.getColumnIndex(CommentaireTable.CODE_ARRET);
		mColMessage = c.getColumnIndex(CommentaireTable.MESSAGE);
		mColSource = c.getColumnIndex(CommentaireTable.SOURCE);
		mColTimestamp = c.getColumnIndex(CommentaireTable.TIMESTAMP);
	}

	@Override
	public Commentaire getSingleFromCursor(final Cursor c) {
		final Commentaire commentaire = new Commentaire();
		commentaire.setId(c.getInt(mColId));
		commentaire.setCodeLigne(c.getString(mColCodeLigne));
		commentaire.setCodeSens(c.getString(mColCodeSens));
		commentaire.setCodeArret(c.getString(mColCodeArret));
		commentaire.setMessage(c.getString(mColMessage));
		commentaire.setSource(c.getString(mColSource));
		commentaire.setTimestamp(c.getLong(mColTimestamp));
		return commentaire;
	}

	@Override
	protected ContentValues getContentValues(final Commentaire commentaire) {
		final ContentValues values = new ContentValues();
		values.put(CommentaireTable.CODE_LIGNE, commentaire.getCodeLigne());
		values.put(CommentaireTable.CODE_SENS, commentaire.getCodeSens());
		values.put(CommentaireTable.CODE_ARRET, commentaire.getCodeArret());
		values.put(CommentaireTable.MESSAGE, commentaire.getMessage());
		values.put(CommentaireTable.SOURCE, commentaire.getSource());
		values.put(CommentaireTable.TIMESTAMP, commentaire.getTimestamp());
		return values;
	}

	private void fillDB(final ContentResolver contentResolver, final List<Commentaire> commentaires) {
		final ContentValues[] values = new ContentValues[commentaires.size()];
		for (int i = 0; i < commentaires.size(); i++) {
			values[i] = getContentValues(commentaires.get(i));
		}

		contentResolver.bulkInsert(CommentaireProvider.CONTENT_URI, values);
	}
}