package org.madore.damlengine;

import java.util.HashMap;
import java.util.HashSet;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public final class WeblogSummary {

    public static final class EntrySummary {
	int id;
	String date;
	String lang;
	String title;  String titleXml;
	String doSinglePage;
	HashSet<String> catSet;
	public EntrySummary(int id, String date, String lang,
			    String title, String titleXml,
			    String doSinglePage) {
	    this.id = id;
	    this.date = date;
	    this.lang = lang;
	    this.title = title;
	    this.titleXml = titleXml;
	    this.doSinglePage = doSinglePage;
	    this.catSet = null;
	}
    }

    public HashMap<Integer,EntrySummary> entries;

    private static WeblogSummary singleton;

    private WeblogSummary() {
	this.entries = new HashMap<Integer,EntrySummary>();
    }

    public static synchronized WeblogSummary getSummary() {
	if ( singleton != null )
	    return singleton;
	singleton = new WeblogSummary();
	try {
	    final Connection conn = WeblogDatabaseConnection.getConnection();
	    final PreparedStatement selSt
		= conn.prepareStatement("SELECT id , edate , lang , title , title_xml , do_single_page FROM entries");
	    final ResultSet selRes = selSt.executeQuery();
	    while ( selRes.next() ) {
		int id = selRes.getInt(1);
		String date = selRes.getString(2);
		String lang = selRes.getString(3);
		String title = selRes.getString(4);
		String titleXml = selRes.getString(5);
		String doSinglePage = selRes.getString(6);
		singleton.entries.put(id, new EntrySummary(id, date, lang, title, titleXml, doSinglePage));
	    }
	    final PreparedStatement catSt
		= conn.prepareStatement("SELECT id , code FROM incat");
	    final ResultSet catRes = catSt.executeQuery();
	    while ( catRes.next() ) {
		int id = catRes.getInt(1);
		String code = catRes.getString(2);
		HashSet<String> catSet = singleton.entries.get(id).catSet;
		if ( catSet == null ) {
		    catSet = new HashSet<String>();
		    singleton.entries.get(id).catSet = catSet;
		}
		catSet.add(code);
	    }
	} catch (SQLException e) {
	    // Well, we'll have no summary.  Too bad, but better than abort.
	    singleton = null;
	}
	return singleton;
    }

}