package org.paneris.bibliomania;
   
   import java.sql.ResultSet;
   import java.util.Hashtable;
   import java.util.Properties;
   import java.util.Vector;
   
   import org.melati.poem.AccessToken;
   import org.melati.poem.PoemTask;
  import org.melati.poem.UnexpectedExceptionPoemException;
  import org.melati.poem.util.EnumUtils;
  import org.paneris.bibliomania.fti.IndexCursor;
  
  public class ShowNotIndexed {
  
    public static void showNotIndexed(BibliomaniaDatabase db
                                      // , Unit start, Unit end
                                      ) throws Exception {
      Hashtable texts = new Hashtable();
  
      System.err.println("Running through index: this will take a LONG time!");
  
      int n = 1;
      IndexCursor cursor = db.fti().allEntries();
      try {
        while (cursor.next()) {
          texts.put(new Long(cursor.textID()), Boolean.TRUE);
          if (n % 10000 == 0)
            System.err.println("... " + n);
          ++n;
        }
      }
      finally {
        try { cursor.close(); } catch (Exception e) {}
      }
  
      System.err.println("Running through chapters in database");
  
      int currentBook = -1;
      Vector chaps = new Vector();
      String path = null;
      n = 1;
      for (ResultSet c = db.sqlQuery(
               "SELECT textid, id, path, book FROM chapter ORDER BY textid");
           c.next();) {
        int book = c.getInt(4);
        if (book != currentBook) {
          if (chaps.size() != 0) {
            System.out.println(currentBook + " " + path + " " +
                                   EnumUtils.concatenated(" ", chaps.elements()));
            chaps.setSize(0);
          }
  
          currentBook = book;
          path = c.getString(3);
        }
  
        if (!texts.containsKey(new Long(c.getLong(1)))) {
          if (chaps.size() < 10) chaps.addElement(new Integer(c.getInt(2)));
          else if (chaps.size() == 10) chaps.addElement("...");
        }
  
        if (n % 1000 == 0)
          System.err.println("... " + n);
        ++n;
      }
    }
  
    public static void main(String[] args) {
  
      Properties conf = new Properties();
      conf.put("idOfWord.cacheSize", "0");
      conf.put("occurrences.cacheSize", "131072");
      conf.put("anchorOfIndex.cacheSize", "0");
  
      final BibliomaniaDatabase db = new BibliomaniaDatabase(false, true, conf);
      db.connect("bibliomania","org.melati.poem.dbms.Postgresql",
                  "jdbc:postgresql:bibliomania", "postgres", "*",8);
  
      db.inSession(
          AccessToken.root,       // FIXME
          new PoemTask() {
            public void run() {
              try {
                showNotIndexed(db
                               //,args.length < 2 ?
                               //   null :
                               //   (Unit)db.getTable(args[0]).getObject(args[1]),
                               // args.length < 4 ?
                               //   null :
                               //   (Unit)db.getTable(args[2]).getObject(args[3])
                            );
              }
              catch (Exception e) {
                throw new UnexpectedExceptionPoemException(e);
              }
            }
          });
    }
 }