Metacat

/**

 *  '$RCSfile$'

 *    Purpose: A Class that loads eml-access.xml file containing ACL

 *             for a metadata document into relational DB

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

 *             National Center for Ecological Analysis and Synthesis

 *    Authors: Jivka Bojilova

 *    Release: @release@

 *

 *   '$Author$'

 *     '$Date$'

 * '$Revision$'

 */

package edu.ucsb.nceas.metacat;

import java.io.*;

import java.sql.*;

import java.util.Stack;

import java.util.Vector;

import org.xml.sax.Attributes;

import org.xml.sax.InputSource;

import org.xml.sax.SAXException;

import org.xml.sax.SAXParseException;

import org.xml.sax.XMLReader;

import org.xml.sax.helpers.XMLReaderFactory;

import org.xml.sax.helpers.DefaultHandler;

/**

 * A Class that loads eml-access.xml file containing ACL for a metadata

 * document into relational DB. It extends DefaultHandler class to handle

 * SAX parsing events when processing the XML stream.

 */

public class AccessControlList extends DefaultHandler {

  static final int ALL = 1;

  static final int WRITE = 2;

  static final int READ = 4;

  private Stack elementStack;

  private Vector principalName;

  private int    permission;

  private String permType;

  private String permOrder;

  private String beginTime;

  private String endTime;

  private int    ticketCount;

  /**

   * Construct an instance of the AccessControlList class.

   *

   * @param conn the JDBC connection where acl data are loaded

   */

  public AccessControlList ( Connection conn )

  {

    this.conn = conn;

  }

  /**

   * Construct an instance of the AccessControlList class.

   *

   * @param conn the JDBC connection where acl data are loaded

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

  public AccessControlList ( Connection conn, String docid, Reader acl )

                  throws SAXException, IOException, ClassNotFoundException

  {

    // Get an instance of the parser

    MetaCatUtil util = new MetaCatUtil();

    String parserName = util.getOption("saxparser");

    this.conn = conn;

    this.parserName = parserName;

    this.principalName = new Vector();

    this.permission = 0;

    this.ticketCount = 0;

    // Initialize the parser and read the queryspec

    XMLReader parser = initializeParser();

    parser.parse(new InputSource(acl));

  }

   * Construct an instance of the AccessControlList class.

   * It parse acl file and loads acl data into db connection.

   *

   * @param conn the JDBC connection where acl data are loaded

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

   * @param aclfilename the name of acl file containing acl data

   */

                  throws SAXException, IOException, ClassNotFoundException

  {

    this(conn,docid,new FileReader(new File(aclfilename).toString()));

  }

  /**

   * Set up the SAX parser for reading the XML serialized ACL

   */

  private XMLReader initializeParser() throws SAXException

  {

    XMLReader parser = null;

    // Get an instance of the parser

    parser = XMLReaderFactory.createXMLReader(parserName);

    // Set the ContentHandler to this instance

    parser.setContentHandler(this);

    // Set the ErrorHandler to this instance

    parser.setErrorHandler(this);

    return parser;

  }

  /**

   * callback method used by the SAX Parser when the start tag of an

   * element is detected. Used in this context to parse and store

   * the acl information in class variables.

   */

  public void startElement (String uri, String localName,

                            String qName, Attributes atts)

         throws SAXException

  {

    BasicNode currentNode = new BasicNode(localName);

    if (atts != null) {

      int len = atts.getLength();

      for (int i = 0; i < len; i++) {

        currentNode.setAttribute(atts.getLocalName(i), atts.getValue(i));

      }

    }

      permOrder = currentNode.getAttribute("order");

    }

  }

  /**

   * callback method used by the SAX Parser when the text sequences of an

   * xml stream are detected. Used in this context to parse and store

   * the acl information in class variables.

   */

  public void characters(char ch[], int start, int length)

         throws SAXException

  {

    String inputString = new String(ch, start, length);

    BasicNode currentNode = (BasicNode)elementStack.peek();

    String currentTag = currentNode.getTagName();

      resourceId = inputString;

    } else if (currentTag.equals("principalName")) {

      principalName.addElement(new String(inputString));

      if ( inputString.trim().toUpperCase().equals("READ") ) {

        permission = permission | READ;

      } else if ( inputString.trim().toUpperCase().equals("WRITE") ) {

        permission = permission | WRITE;

      } else if ( inputString.trim().toUpperCase().equals("ALL") ) {

        permission = permission | ALL;

      }

    } else if (currentTag.equals("duration") &&

        endTime = inputString.substring(inputString.indexOf(" ")+1);

      ticketCount = (new Integer(inputString.trim())).intValue();

  }

  /**

   * callback method used by the SAX Parser when the end tag of an

   * element is detected. Used in this context to parse and store

   * the acl information in class variables.

   */

  public void endElement (String uri, String localName, String qName)

         throws SAXException

  {

    BasicNode leaving = (BasicNode)elementStack.pop();

      if ( permission > 0 ) {

        try {

          insertPermissions("allowed");

        } catch (SQLException sqle) {

          throw new SAXException(sqle);

        }

      }

      endTime = null;

      ticketCount = 0;

      if ( permission > 0 ) {

        try {

          insertPermissions("denied");

        } catch (SQLException sqle) {

          throw new SAXException(sqle);

      }

      principalName = new Vector();

      permission = 0;

      beginTime = null;

      endTime = null;

      ticketCount = 0;

      // reset the resource identifier

      resourceId = null;

      permOrder = null;

    }

  }

  private void insertPermissions( String permType )

  {

    PreparedStatement pstmt;

    //

    try {

      pstmt = conn.prepareStatement(

              "INSERT INTO xml_access " +

              "begin_time,end_time,ticket_count) VALUES " +

              "(?,?,?,?,?,to_date(?,'mm/dd/yy'),to_date(?,'mm/dd/yy'),?)");

      pstmt.setInt(3, permission);

      pstmt.setString(4, permType);

      pstmt.setString(5, permOrder);

      pstmt.setString(6, beginTime);

      pstmt.setString(7, endTime);

      if ( ticketCount > 0 ) {

        pstmt.setString(8, "" + ticketCount);

      } else {

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

        pstmt.setString(2, (String)principalName.elementAt(i));

        pstmt.execute();

      }

      throw new

      SQLException("AccessControlList.insertPermissions(): " + e.getMessage());

    }

  }

  /** Check for @permission for @principal on @resourceId from db connection */

  public boolean hasPermission ( String permission, String principal,

                                 String resourceId )

                 throws SQLException

  {

    PreparedStatement pstmt;

    // check public access to @resourceId from xml_documents table

    if ( permission.equals("READ") ) {

      try {

        pstmt = conn.prepareStatement(

                "SELECT 'x' FROM xml_documents " +

                "WHERE docid LIKE ? AND public_access = 1");

        // Bind the values to the query

        pstmt.setString(1, principal);

        boolean hasRow = rs.next();

        pstmt.close();

        if (hasRow) {

          return true;

        }

//System.out.println("Passed the check for public access");

      } catch (SQLException e) {

        throw new

        SQLException("Error checking document's public access: "

                      + e.getMessage());

    // since owner of resource has all permission on it,

    // check if @principal is owner of @resourceId in xml_documents table

    if ( principal != null ) {

      try {

        pstmt = conn.prepareStatement(

                "SELECT 'x' FROM xml_documents " +

                "WHERE docid LIKE ? AND user_owner LIKE ?");

        // Bind the values to the query

        pstmt.setString(1, resourceId);

        pstmt.setString(2, principal);

        ResultSet rs = pstmt.getResultSet();

        boolean hasRow = rs.next();

        pstmt.close();

        if (hasRow) {

          return true;

      } catch (SQLException e) {

        throw new

        SQLException("AccessControlList.hasPermission(): " +

                     "Error checking document's ownership. " + e.getMessage());

      }

      // check @principal's @permission on @resourceId from xml_access table

      int accessValue = 0;

      int ticketCount = 0;

      String permOrder = "";

      try {

        pstmt = conn.prepareStatement(

                "SELECT permission, perm_order, ticket_count " +

                "FROM xml_access " +

                "WHERE docid LIKE ? " +

                "AND principal_name LIKE ? " +

                "AND sysdate BETWEEN nvl(begin_time,sysdate) " +

                                "AND nvl(end_time,sysdate) " +

                "AND perm_type LIKE ?");

        // check if it is "denied" first

        // Bind the values to the query

        pstmt.setString(1, resourceId);

        pstmt.setString(2, principal);

        pstmt.setString(3, "denied");

        pstmt.execute();

        ResultSet rs = pstmt.getResultSet();

        boolean hasRows = rs.next();

        while ( hasRows ) {

          accessValue = rs.getInt(1);

          permOrder = rs.getString(2);

          ticketCount = rs.getInt(3);

          if ( ( accessValue & intValue(permission) ) == intValue(permission) &&

               ( permOrder.equals("allow first") ) &&

               ( rs.wasNull() || ticketCount > 0 ) ) {

            if ( !rs.wasNull() && ticketCount > 0 ) {

              decreaseNumberOfAccess(accessValue,principal,resourceId,"denied");

            }

            pstmt.close();

            return false;

          }

          hasRows = rs.next();

        // Bind the values to the query

        pstmt.setString(1, resourceId);

        pstmt.setString(2, principal);

        pstmt.setString(3, "allowed");

        hasRows = rs.next();

        while ( hasRows ) {

          accessValue = rs.getInt(1);

          ticketCount = rs.getInt(3);

          if ( ( accessValue & intValue(permission) )==intValue(permission) &&

               ( rs.wasNull() || ticketCount > 0 ) ) {

            if ( !rs.wasNull() && ticketCount > 0 ) {

              decreaseNumberOfAccess(accessValue,principal,resourceId,"allowed");

            }

            pstmt.close();

            return true;

          }

          hasRows = rs.next();

        }

//System.out.println("Passed the check for allowed access");

        // ???

        // here there could be a check for the group's permission like

        // selfrecursive call to hasPermission(conn,permission,group,recourceId)

        //

        pstmt.close();

        return false;

      } catch (SQLException e) {

        throw new

        SQLException("AccessControlList.hasPermission(): " +

                     "Error checking document's permission. " + e.getMessage());

    return false;

  }

  private void decreaseNumberOfAccess(int permission, String principal,

                                      String resourceId, String permType)

               throws SQLException

  {

    PreparedStatement pstmt;

    pstmt = conn.prepareStatement(

            "UPDATE xml_access SET ticket_count = ticket_count - 1 " +

            "WHERE docid LIKE ? " +

            "AND principal_name LIKE ? " +

            "AND permission LIKE ? " +

            "AND sysdate BETWEEN nvl(begin_time,sysdate) " +

                            "AND nvl(end_time,sysdate) " +

            "AND perm_type LIKE ?");

    // Bind the values to the query

    pstmt.setString(1, resourceId);

    pstmt.setString(2, principal);

    pstmt.setInt(3, permission);

    pstmt.setString(4, permType);

    pstmt.execute();

    pstmt.close();

  }

  // get the int value of READ, WRITE or ALL

  private int intValue ( String permission )

  {

    if ( permission.equals("READ") ) {

      return READ;

    } else if ( permission.equals("WRITE") ) {

      return WRITE;

    } else if ( permission.equals("ALL") ) {

      return ALL;

    return -1;

}