Metacat

/**

 *  '$RCSfile$'

 *  Copyright: 2000 Regents of the University of California and the

 *             National Center for Ecological Analysis and Synthesis

 *    Authors: Jivka Bojilova

 *    Release: @release@

 *

 *   '$Author: tao $'

 *     '$Date: 2002-11-01 18:09:24 -0800 (Fri, 01 Nov 2002) $'

 * '$Revision: 1322 $'

 *

 * 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 2 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, write to the Free Software

 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

 */

package edu.ucsb.nceas.metacat;

import java.io.*;

import java.sql.*;

import java.util.Stack;

import java.util.Vector;

import java.util.Hashtable;

import java.net.URL;

import java.net.MalformedURLException;

/** 

 * A Class to get access rules from xml_access table

 */

public class AccessRulesFromDB {

  private String aclid      = null;  

  private String principal  = null;

  private int    permision  = 0;

  private String allowType  = null;

  private String allowOrder = null;

  private Vector docidAccessRuleApplied = new Vector();

  private Vector accessRuleVector = new Vector();

  /**

   * Construct an instance of the AccessRulesFromDB

   * @param aclid the Accession# of the document with the acl data

   */

  public AccessRulesFromDB(String aclid)

                  throws IOException, McdbException, SQLException

  {

    this.aclid = aclid;

    selectAccessRules();

    selectDocIdAccessRuleApplied();

  }

  /**

   * Method to get accessRuleVector

   */

  public Vector getAccessRuleVector()

  {

    return accessRuleVector;

  }

  /**

   * Method to get docidAccessRuleApplied

   */

  public Vector getDocidAccessRuleApplied()

  {

    return docidAccessRuleApplied;

  }

  /* Get all objects associated with @aclid from db.*/

  private void selectAccessRules() throws SQLException 

  {

    String accessRule = null;

    DBConnection conn = null;

    int serialNumber = -1;

    PreparedStatement pstmt = null;

    try

    {

      //get connection from DBConnectionPool

      conn = DBConnectionPool.

                getDBConnection("AccessRulesFromDB.selectAccessRules");

      serialNumber=conn.getCheckOutSerialNumber();

      // delete all acl records for resources related to @aclid if any

      pstmt = conn.prepareStatement("SELECT principal_name, perm_type, " +

                                    "permission, perm_order  FROM xml_access " +

                                    "WHERE accessfileid = ? ");

      pstmt.setString(1,aclid);

      pstmt.execute();

      ResultSet rs = pstmt.getResultSet();

      boolean hasRows = rs.next();

      int i = 0;

      while (hasRows) 

      {

        principal  = rs.getString(1);

        if (principal != null)

        {

          principal = principal.trim();

        }

        allowType  = rs.getString(2);

        if ( allowType != null)

        {

          allowType = allowType.trim();

        }

        permision  = rs.getInt(3);

        allowOrder = rs.getString(4);

        if (allowOrder != null)

        {

          allowOrder.trim();

        }

        //combine access rule

        accessRule = principal + CleanupAccessTable.DELIMITER;

        accessRule = accessRule + allowType + CleanupAccessTable.DELIMITER;

        accessRule = accessRule + permision + CleanupAccessTable.DELIMITER;

        accessRule = accessRule + allowOrder;

        // if hashtable doesn't has the rule add to hashtable

        if (!accessRuleVector.contains(accessRule))

        {

          accessRuleVector.addElement(accessRule);

          i++;

        }

        hasRows = rs.next();

        // reset value

        accessRule = null;

        principal  = null;

        permision  = 0;

        allowType  = null;

        allowOrder = null;

      }//while

    }

    catch (SQLException e)

    {

      throw e;

    }

    finally

    {

      try

      {

        pstmt.close();

      }

      finally

      {

        //retrun DBConnection

        DBConnectionPool.returnDBConnection(conn,serialNumber);

      }

    }

  }

 /* Get all objects associated with @aclid from db.*/

  private void selectDocIdAccessRuleApplied() throws SQLException 

  {

    String docid = null;

    DBConnection conn = null;

    int serialNumber = -1;

    PreparedStatement pstmt = null;

    try

    {

      //get connection from DBConnectionPool

      conn = DBConnectionPool.

              getDBConnection("AccessRulesFromDB.selectDocIdAccessRuleApplied");

      serialNumber=conn.getCheckOutSerialNumber();

      // delete all acl records for resources related to @aclid if any

      pstmt = conn.prepareStatement("SELECT docid FROM xml_access " +

                                    "WHERE accessfileid = ? ");

      pstmt.setString(1,aclid);

      pstmt.execute();

      ResultSet rs = pstmt.getResultSet();

      boolean hasRows = rs.next();

      int i = 0;

      while (hasRows) 

      {

        docid  = rs.getString(1);

        // if hashtable doesn't has the rule add to hashtable

        if (!docidAccessRuleApplied.contains(docid) && !docid.equals(aclid))

        {

          docidAccessRuleApplied.addElement(docid);

          i++;

        }

        hasRows = rs.next();

        // reset value

        docid = null;

      }//while

    }

    catch (SQLException e)

    {

      throw e;

    }

    finally

    {

      try

      {

        pstmt.close();

      }

      finally

      {

        //retrun DBConnection

        DBConnectionPool.returnDBConnection(conn,serialNumber);

      }

    }

  }

  public static void main(String[] agus)

  {

    if(agus.length == 0)

    {

      System.out.println("you should specify a docid!");

      return;

    }

    String docID = agus[0];

    try

    {

      DBConnectionPool pool = DBConnectionPool.getInstance();

      AccessRulesFromDocument xmlDocument = new AccessRulesFromDocument(docID);

      Vector rules = xmlDocument.getAccessRuleVector();

      Vector docid = xmlDocument.getACLObjects();

      AccessRulesFromDB db = new AccessRulesFromDB(docID);

      Vector rulesFromDB = db.getAccessRuleVector();

      Vector docidFromDB = db.getDocidAccessRuleApplied();

      for (int i = 0; i<rulesFromDB.size(); i++)

      {

        System.out.println("rule: "+(String)rulesFromDB.elementAt(i));

        if (!rules.contains(rulesFromDB.elementAt(i)))

        {

          System.out.println("find a new rule!!!");

        }

      }

      for (int i = 0; i<docidFromDB.size(); i++)

      {

        System.out.println("docid: "+(String)docidFromDB.elementAt(i));

        if (!docid.contains(docidFromDB.elementAt(i)))

        {

          System.out.println("find a new triple");

        }

      }

    }

    catch(Exception e)

    {

      System.out.println("exception is: "+e.getMessage());

    }

  }

}