Metacat

     * This sql command will selecet startnodeid and endnodeid that user can

     * NOT access

     */

    {

        StringBuffer sql = new StringBuffer();

        String allowString = constructAllowString();

        logMetacat.info("accessControlSQLForReturnField: "

                + sql.toString());

        return sql.toString();

    /**

     * This method prints sql based upon the <returnfield> tag in the

     * @param useXMLIndex a boolean flag indicating whether to search using

     *            xml_index

     */

    {

        if (useXMLIndex && !containsPredicates)

        {

        }

        else

        {

                self.append(") AND xml_nodes.nodetype = 'TEXT'");

                self.append(" AND xml_nodes.rootnodeid = xml_documents.rootnodeid");

            }

            return self.toString();

     * @param unaccessableNodePair the node pairs (start id and end id)

     *            which this user should not access

     */

    {

        logMetacat.info("querySpecification.printExtendedSQL called\n");

        StringBuffer self = new StringBuffer();

        }

        return self.toString();

    }

     * @param unaccessableNodePair hash of start/end nodeid pairs to restrict

     * @param self a stringbuffer to which the genrated SQL is appended

     */

            StringBuffer self)

    {

        // add control part for extended query

            self.append(endNodeId);

            self.append(")");

        }

    /**

     * This method prints sql that finds the values of attributes in the xml

          Hashtable controlPairs = new Hashtable();

          double extendedQueryStart = System.currentTimeMillis() / 1000;

          doclist.deleteCharAt(doclist.length() - 1); //remove the last comma

          // check if user has permission to see the return field data

                 qspec.printAccessControlSQLForReturnField(doclist.toString());

          pstmt = dbconn.prepareStatement(accessControlSQL);

          //increase dbconnection usage count

          dbconn.increaseUsageCount(1);

          pstmt.execute();

          rs = pstmt.getResultSet();

          while (tableHasRows)

          {

            long startNodeId = rs.getLong(1);

            long endNodeId = rs.getLong(2);

            controlPairs.put(new Long(startNodeId), new Long(endNodeId));

            tableHasRows = rs.next();

           double extendedAccessQueryEnd = System.currentTimeMillis() / 1000;

           logMetacat.info( "Time for execute access extended query: "

                          + (extendedAccessQueryEnd - extendedQueryStart));

           String extendedQuery =

           logMetacat.info("Extended query: " + extendedQuery);

           if(extendedQuery != null){