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);

             }

           }

         });

   }

 }