Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  com 2447 over 19 years sgarg Removed occurence of enum which is a keyword in...
  edu 2489 over 19 years sgarg Adding the call to normalize function for now -...
  perl 2478 over 19 years sgarg Modified the code so that lastid file is create...
addforeignkeyfortable.sql 135 Bytes 1626 over 21 years Jing Tao Create a foreign key for table accesssubtree.
clear.sql 312 Bytes 704 almost 24 years berkley added removal of relations
drop-postgres.sql 1.93 KB 2457 over 19 years Matt Jones dropping the sequences as well in the postgres ...
loaddtd.sql 2.36 KB 979 over 22 years Jing Tao Change every "http://@server@ to "@systemidserv...
loaddtdschema.sql 2.92 KB 2394 over 19 years sgarg Added sql command to delete also schema entries...
loadschema.sql 476 Bytes 2229 over 20 years sgarg Modified directory name for eml-2.0.x checkouts...
package-count.sql 373 Bytes 2283 about 20 years Matt Jones Added sql for counting packages.
showdoc.sql 340 Bytes 390 over 24 years Matt Jones Added new utility query to return all of the xm...
sqlcatlist.sql 253 Bytes 123 over 24 years Matt Jones Modifying storage model to use DOM TEXT nodes
sqldoclist.sql 209 Bytes 531 about 24 years Matt Jones Changed utility query to include the user_owner...
sqlnodeslist.sql 94 Bytes 108 over 24 years Matt Jones added utility files and queries
sqlnodesview.sql 358 Bytes 166 over 24 years Matt Jones minor modifications to fix problems introduced ...
sqlrevisions.sql 205 Bytes 203 over 24 years Matt Jones Merged in substantial changes to DBWriter and a...
upgrade-db-to-1.2-postgres.sql 637 Bytes 2276 about 20 years Matt Jones New schema changes, including upgrade scripts. ...
upgrade-db-to-1.2.sql 596 Bytes 1827 about 21 years Matt Jones Renamed the upgrade sql files to more understan...
upgrade-db-to-1.3-postgres.sql 2.56 KB 2276 about 20 years Matt Jones New schema changes, including upgrade scripts. ...
upgrade-db-to-1.3.sql 1.44 KB 1827 about 21 years Matt Jones Renamed the upgrade sql files to more understan...
upgrade-db-to-1.4-postgres.sql 5.11 KB 2314 about 20 years sgarg Added code that changes the node column size
upgrade-db-to-1.4.sql 4.44 KB 2279 about 20 years Matt Jones Added lines for updating xml_catalog in the upg...
upgrade-db-to-1.5-postgres.sql 5.63 KB 2434 over 19 years sgarg Modified code such that nodedata column in xml_...
upgrade-db-to-1.5.sql 5.79 KB 2443 over 19 years sgarg Removed the code which created triggers. Added ...
upgrade_db_to_1_5.java 4.76 KB 2484 over 19 years Matt Jones Modified the upgrade java script to provide mor...
xmlpackage.sql 1.94 KB 439 about 24 years berkley sql file defining the table structure for eml-p...
xmltables-postgres.sql 13.2 KB 2442 over 19 years sgarg Removing code added for creating nodedata colum...
xmltables-sqlserver.sql 11.8 KB 2359 almost 20 years sgarg Modified database creation sql code so that in ...
xmltables.sql 15.7 KB 2442 over 19 years sgarg Removing code added for creating nodedata colum...

Latest revisions

# Date Author Comment
2489 04/14/2005 01:51 PM sgarg

Adding the call to normalize function for now -- too many calls to normalize function are made and this needs to be looked into. Removing call to normalize function caused trouble in text like this "A&B"

2487 04/13/2005 06:22 PM sgarg

Fixed a bug in last commit. Doing a search like
pathquery version="1.2">
<returndoctype>eml://ecoinformatics.org/eml-2.0.0</returndoctype><returnfield>originator/individualName/surName</returnfield><querygroup operator="INTERSECT"><queryterm casesensitive="false" searchmode="contains"><value>%</value></queryterm><queryterm casesensitive="false" searchmode="contains"><value>National Center for Ecological Analysis and Synthesis</value><pathexpr>organizationName</pathexpr></queryterm></querygroup></pathquery>...

2486 04/13/2005 11:38 AM sgarg

Fixed a bug - when returnfield_id is not found in xml_returnfield, records are not added to xml_queryresults

2484 04/12/2005 11:44 PM Matt Jones

Modified the upgrade java script to provide more effective feedback during the
nodedata copy operation so that users don't think it has failed or crashed.

2478 04/08/2005 01:34 PM sgarg

Modified the code so that lastid file is created in a skin when lastid file is not found.
Commented out the code which uses AdminDB module and uncommented the test function.

2474 04/07/2005 05:04 PM sgarg

1. removed the call to QuerySpecification.printAttributeSQL() from QuerySpecification.printExtendedSQL()
2. in QuerySpecification.printExtendedSQL() if ( returnFieldList.size() == 0 ) then it returns null
3. DBQuery.addReturnfield() doesnt execute the element query if printExtendedSQL returns null

2473 04/07/2005 04:08 PM Chris Jones

A minor change from containAtrributeReturnField to
containsAttributeReturnField

2472 04/07/2005 04:06 PM Chris Jones

I've added in a test in QuerySpecification.printExtendedSQL that checks
to see if attributes, and sometimes only attributes, are in the original
returnfield request. If so, the printAttributeQuery is called.

2467 04/07/2005 10:53 AM Chris Jones

Changed the handleReturnField() method so that it handles path expressions with
only attributes in the path.

2466 04/06/2005 07:04 PM sgarg

Added a check if printAttributeQuery() for returnPath to see that it is not null so that that this doesnt happen

xml_index.path like 'null' AND xml_nodes.nodename like 'id'

View revisions

Also available in: Atom