Metacat

Fixed a bug in the format of query result.

Modifying code so that nodedata is stored in xml_index table next to the paths.
This helps in making the search faster.

Some more modifications so that % search doesnt run a select on xml_nodes.

Modified code so that when a % search is done, a xml_nodes search is not done. This search is not required and hence saves time in doing a % search

Fixed a bug the text filed in path xml query maybe splited.

Fixed a bug in the new recursive SQL statements that prevented them from operating on oracle. Now they should work on both oracle and postgres.

Changed printAttributeQuery() to no longer depend on the xml_index table. Now, if useXMLIndex is false, the method will use a recursive query on xml_nodes to match paths instead of using xml_index.

Some refactoring of the printExtendedSQL()
methods to eliminate redundancy in the code and
to provide more readable documentation.

Moved decision about whether to use xml_index for
query to the metacat.properties as "usexmlindex". Default
is now false. Still have some refactoring to do to remove a
few more uses of the xml_index table.

Created new printExtendedSQL function that can get the extended
return fields using only xml_nodes and not xml_index. One
step closer to eliminating the dependence ofn xml_index.

Created test class QuerySpecificationTest and started process of removing the xml_index from the QuerySpecification code. Reformatted some classes for readability.

Removed the "getdataguide" action as it was always experimental and is no longer used in metacat or morpho.

removed the 3 versions of printPackageSQL which are no longer used by metacat. This eliminates some dependency on xml_index.

Fixed the bug for sessionid storing, revision couldn't be zero and Ldap DN is case sensitive.

Modified a debug Message.

Revise code so it can be called directly.

Revied the class.

Revise the query for access control return field.

Revise the sql for access control for return fields.

Add code to handle access control for return fields.

Fixed a bug that the column in sql is ambiguous.

Add nodes access control for print extended query.

In search query, add subtreeid is null this condition to make sure is for top level documents.

Add a access control query for return fields.

Change package query.

In extened query, parentnodeid was added.

Support returnfields has attributes.

add some methods and attributes to determine percentage search.

Add new feature to support attribute in query.

Add a piece of query to get rid of invalid number in nodedata.

Made a shortcut for % search. It will look like: LIKE '%' rather than: LIKE '%%%'.

In accessQuery, permission=READ or permission=ALL was added for both allow rule and deny rule.

Add three private method: createOwnerQuery, createAllowRuleQuery and createDenyRuleQuery. And three public methods: setUserName, setGroup and getAccessQuery.

made a ton of changes related to keeping oracle SQL code out of the main classes. fixed a bug where the timing of the index thread was off so when it went to index a document, the document was not already in xml_documents thus breaking the FK relation between xml_documents and xml_index. I think that bug might be the reason for the blank resultset screens in morpho. made the postgres implementation much more robust.

support for the new terms included in pathquery.dtd

Fixed bug in metacat where return doctypes were not being properly
back traced. Changed DBQuery.findDocuments() so that it no longer
takes a returndoc array, but instead retrieves the returndoc array
fromthe QUERYSpecification. The QuerySpecification was augmented...

Modifications that change the package handling behavior of metacat. Package
membership is now determined by an identifier being used as either the subject
or object in a triple. One can not request arbitrary returndocs -- only
those types that have package information embedded can be "returndoctype"...

Modifications to allow printing of SQL with and without INDEX option.

added print info and timing info

print the nested statements sql query

included flag in DBQuery to run pathqueries with or without the index,
but for the command line only.

there were more mentions of DOCTITLE attr - cleared them

added precise location information (class.method) to each catch statement so that errors are more easily traced.

Added license terms to source code files, and cleaned up some javadoc
documentation in a few places.

fixed sql error

Modified pathquery.dtd and QuerySpecification to allow some new constraints
on queries submitted to Metacat. Now, queries can contain an optional
set of <owner> tags that identify the users for which documents should be
returned, and a list of <site> tags constraining the site identifiers...

added functionality to return the doctype of a relation in a relationdoctype tag. This information is now returned automatically in the resultset under the path resultset/relation/relationdoctype.

Added backtrack functionality. Backtracking works by passing a returndoc parameter. There can be more than one. If a document that is hit by a query is not of type returndoc then it searches the database for a related file of type returndoc. If one is found it is displayed, if no relation is found, the original is displayed....

Added functionality for package specifications. metacatservlet now contains a new action called getrelateddocument that handles retrieving related documents using the metacatURL specification (metacatURL.java). DBQuery contains new code in runQuery that embeds relation tags in the returned hashtable describing the documents related to each docid. querySpecification contains a new method which prints the sql that does the relation query.

changed xslf for new returnfield scheme. the returnfields are now returned as <param name="<returnfield>"> tags.
hThe sql for the returnfield query was redone to fix a previous problem with slow queries

changed the field names to be case-sensitive in the returnfields

added support for the returnfield parameter
-QuerySpecification now sets a flag (containsExtendedSQL) when there are returnfield items in the pathquery document.
the accessor method containsExtendedSQL() can be called by other classes to check for extended return parameters...

Added "release" keyword to all metacat source files so that the release
number will be evident in software distributions.

Merged in substantial changes to DBWriter and associated classes and to
the MetaCatServlet in order to accomodate the new UPDATE and DELETE
functions. The command line tools and the parameters for the
servlet have changed substantially.

1) Simplified database connection creation by adding new utility routine in MetaCatUtil that reads configuration information from the properties file.
2) Created MetaCatUtil.getOption() to retrieve options from properties file.
3) Unified SAX Parser creation by specifying parser driver in the properties file and dynamically loading it using the XMLReaderFactory interface....

integrated new structured query facility (DBQuery) into the servlet demo (MetaCatServlet)

removed debugging code

fixed QuerySpecification to produce SQL that does UNION or INTERSECT set operations for query group combinations

completed work on creating structured query prototype in DBQuery and QuerySpecification classes

continued work on structured query. Now QuerySpecification generates SQL for a given xml input, and DBQuery uses that SQL to send the query to the db

continued work on structured query -- now it reads the queryspec xml docuemnt and can digest its contents

continued work on developing structured query functionality using the QuerySpecification class -- incomplete still

added incomplete classes for structured query