/*

 *   StarOffice News Server

 *   see AUTHORS for the list of contributors

 *

 *   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/>.

 */

package com.so.news.storage;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import com.so.news.Debug;

/**

 * Represents a logical Group within this newsserver.

 * @author Christian Lins

 */

public class Group

{

  private long   id;

  private String name;

  /**

   * Private constructor.

   * @param name

   * @param id

   */

  Group(String name, long id)

  {

    this.id   = id;

    this.name = name;

  }

  /**

   * Returns a Group identified by its full name.

   * @param name

   * @return

   */

  public static Group getByName(String name)

  {

    try

    {

      return Database.getInstance().getGroup(name);

    }

    catch(SQLException ex)

    {

      System.err.println(ex.getLocalizedMessage());

      ex.printStackTrace(Debug.getInstance().getStream());

      return null;

    }

  }

  /**

   * Returns a list of all groups this server handles.

   * @return

   */

  public static ArrayList<Group> getAll()

  {

    ArrayList<Group> buffer = new ArrayList<Group>();

    try

    {

      ResultSet rs = Database.getInstance().getGroups();

      while(rs.next())

      {

        String name = rs.getString("name");

        long   id   = rs.getLong("group_id");

        Group group = new Group(name, id);

        buffer.add(group);

      }

    }

    catch(SQLException ex)

    {

      ex.printStackTrace(Debug.getInstance().getStream());

      System.err.println(ex.getLocalizedMessage());

    }

    return buffer;

  }

  public List<Article> getAllArticles()

    throws SQLException

  {

    return getAllArticles(getFirstArticle(), getLastArticle());

  }

  public List<Article> getAllArticles(int first, int last)

  {

    return null;

  }

  public int getFirstArticle()

    throws SQLException

  {

    return Database.getInstance().getFirstArticleNumber(this);

  }

  public long getID()

  {

    return id;

  }

  public int getLastArticle()

    throws SQLException

  {

    return Database.getInstance().getLastArticleNumber(this);

  }

  public String getName()

  {

    return name;

  }

  public void setName(String name)

  {

    this.name = name;

  }

  public int getEstimatedArticleCount()

    throws SQLException

  {

    if (getLastArticle() < getFirstArticle())

      return 0;

    return getLastArticle() - getFirstArticle() + 1;

  }

}