Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  com 2532 over 19 years sgarg renaming enum to catalogEnum to prevent compila...
  edu 7420 about 12 years Chris Jones In CNodeService.updateReplicationMetadata(), we...
  org 5030 about 15 years daigle Change location of PropertyService to propertie...
  perl 7226 over 12 years ben leinfelder use kepler account as default
  php 3134 almost 18 years perry added gpl header to php metacat lib
  python 6926 almost 13 years Matt Jones An example python script that uses the python c...
  query-client 2824 almost 19 years tyburczy Unix port of transform.bat
  ruby 3132 almost 18 years perry Initial import of Chad Burt's ruby metacat client
  scripts 7357 about 12 years ben leinfelder include certificate export SSL options as an ex...
LTER_DOI_conversion.sql 717 Bytes 7283 over 12 years ben leinfelder remove the non-doi identifiers before updating ...
addforeignkeyfortable.sql 135 Bytes 1626 over 21 years Jing Tao Create a foreign key for table accesssubtree.
alter-datafile-for-knbbackup.sql 1.66 KB 2662 about 19 years Jing Tao Add a new sql file to alter control file which ...
apply-xmlconstraints-postgres-knb.sql 6.23 KB 7181 over 12 years ben leinfelder script for re-applying missing FK constraints o...
clear.sql 312 Bytes 704 over 23 years berkley added removal of relations
convert_denyFirst.sql 2.12 KB 7227 over 12 years ben leinfelder script to aid in converting denyFirst rules to ...
delete-xml-documents.sql 937 Bytes 3123 almost 18 years Jing Tao Add a script to delete documents manually.
delete-xml-revisions.sql 110 Bytes 3125 almost 18 years Jing Tao Add a script can delete xml_revision records.
delete_all_by_pid.sql 4.1 KB 7392 about 12 years ben leinfelder shorten the systemmetadata* table names for Ora...
doi_registration.sql 27.9 KB 7416 about 12 years ben leinfelder update pub_date when the length of that field i...
drop-postgres.sql 2.24 KB 5956 almost 14 years Matt Jones Updated DROP script that was missing tables and...
increase-xml-queryresult-size-postgres.sql 952 Bytes 3297 over 17 years Jing Tao A sql to increase column size of queryresult_st...
loaddtd.sql 2.07 KB 4080 over 16 years daigle Merge 1.9 changes into Head
loaddtdschema-oracle.sql 5.57 KB 7393 about 12 years ben leinfelder use version 2.0.5
loaddtdschema-postgres.sql 5.57 KB 7393 about 12 years ben leinfelder use version 2.0.5
loadschema.sql 395 Bytes 4080 over 16 years daigle Merge 1.9 changes into Head
package-count.sql 373 Bytes 2283 about 20 years Matt Jones Added sql for counting packages.
rollback-db-from-1.9-oracle.sql 903 Bytes 4818 over 15 years daigle Add db rollback scripts
rollback-db-from-1.9-postgres.sql 465 Bytes 4818 over 15 years daigle Add db rollback scripts
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...
system_metadata_revisions.sql 1.38 KB 7353 over 12 years ben leinfelder correct the update statement for setting archiv...
tsvector.sql 788 Bytes 3751 over 16 years Jing Tao Add new code for xml_nodes table.
upgrade-db-to-1.2-oracle.sql 600 Bytes 4104 over 16 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.2-postgres.sql 637 Bytes 4080 over 16 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.3-oracle.sql 1.44 KB 4104 over 16 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.3-postgres.sql 2.56 KB 4080 over 16 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.4-oracle.sql 4.36 KB 4104 over 16 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.4-postgres.sql 5.03 KB 4080 over 16 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.5-oracle.sql 5.9 KB 4413 about 16 years daigle Add nodedatanumerical column and associated pop...
upgrade-db-to-1.5-postgres.sql 5.65 KB 4080 over 16 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.6-oracle.sql 9.66 KB 4414 about 16 years daigle Re-add the xml_node id trigger. In oracle, thi...
upgrade-db-to-1.6-postgres.sql 7.66 KB 4080 over 16 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.7-oracle.sql 509 Bytes 4104 over 16 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.7-postgres.sql 509 Bytes 3052 about 18 years Matt Jones Modifications to the table definitions to add i...
upgrade-db-to-1.8-oracle.sql 214 Bytes 4104 over 16 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.8-postgres.sql 1.43 KB 3607 almost 17 years Jing Tao A file rename from 1.7.1 since we decide to rel...
upgrade-db-to-1.9-oracle.sql 1.03 KB 4818 over 15 years daigle Add db rollback scripts
upgrade-db-to-1.9-postgres.sql 903 Bytes 4797 almost 16 years daigle Add the service registration xml schema to the ...
upgrade-db-to-1.9.1-oracle.sql 127 Bytes 4873 over 15 years daigle Update version to 1.9.1. Add nrs ldap properti...
upgrade-db-to-1.9.1-postgres.sql 125 Bytes 4873 over 15 years daigle Update version to 1.9.1. Add nrs ldap properti...
upgrade-db-to-1.9.2-oracle.sql 1.62 KB 7035 over 12 years ben leinfelder fixed Oracle script issues identified by: Brian...
upgrade-db-to-1.9.2-postgres.sql 1.34 KB 5012 over 15 years daigle Added end time to workflow scheduler.
upgrade-db-to-1.9.3-oracle.sql 127 Bytes 5507 over 14 years ben leinfelder add 1.9.3 upgrade scripts to trunk
upgrade-db-to-1.9.3-postgres.sql 125 Bytes 5507 over 14 years ben leinfelder add 1.9.3 upgrade scripts to trunk
upgrade-db-to-1.9.4-oracle.sql 127 Bytes 6209 over 13 years ben leinfelder merge changes from 1.9.5 branch for upgrade pro...
upgrade-db-to-1.9.4-postgres.sql 125 Bytes 6209 over 13 years ben leinfelder merge changes from 1.9.5 branch for upgrade pro...
upgrade-db-to-1.9.5-oracle.sql 195 Bytes 6209 over 13 years ben leinfelder merge changes from 1.9.5 branch for upgrade pro...
upgrade-db-to-1.9.5-postgres.sql 194 Bytes 6209 over 13 years ben leinfelder merge changes from 1.9.5 branch for upgrade pro...
upgrade-db-to-2.0.0-oracle.sql 8.21 KB 7392 about 12 years ben leinfelder shorten the systemmetadata* table names for Ora...
upgrade-db-to-2.0.0-postgres.sql 8.2 KB 7386 about 12 years ben leinfelder use correct column (guid) for temporary index
upgrade-db-to-2.0.1-oracle.sql 164 Bytes 7276 over 12 years ben leinfelder update for 2.0.1 upgrade -- scripts, docs, readme
upgrade-db-to-2.0.1-postgres.sql 163 Bytes 7276 over 12 years ben leinfelder update for 2.0.1 upgrade -- scripts, docs, readme
upgrade-db-to-2.0.2-oracle.sql 164 Bytes 7300 over 12 years ben leinfelder prep for 2.0.2 release by updating the version ...
upgrade-db-to-2.0.2-postgres.sql 163 Bytes 7300 over 12 years ben leinfelder prep for 2.0.2 release by updating the version ...
upgrade-db-to-2.0.3-oracle.sql 164 Bytes 7347 over 12 years ben leinfelder prep for 2.0.3 release
upgrade-db-to-2.0.3-postgres.sql 163 Bytes 7347 over 12 years ben leinfelder prep for 2.0.3 release
upgrade-db-to-2.0.4-oracle.sql 838 Bytes 7372 about 12 years ben leinfelder include missing identifier mappings during 2.0....
upgrade-db-to-2.0.4-postgres.sql 837 Bytes 7372 about 12 years ben leinfelder include missing identifier mappings during 2.0....
upgrade-db-to-2.0.5-oracle.sql 543 Bytes 7392 about 12 years ben leinfelder shorten the systemmetadata* table names for Ora...
upgrade-db-to-2.0.5-postgres.sql 393 Bytes 7392 about 12 years ben leinfelder shorten the systemmetadata* table names for Ora...
xmlpackage.sql 1.94 KB 439 about 24 years berkley sql file defining the table structure for eml-p...
xmltables-oracle.sql 24.6 KB 7392 about 12 years ben leinfelder shorten the systemmetadata* table names for Ora...
xmltables-postgres.sql 21.6 KB 7392 about 12 years ben leinfelder shorten the systemmetadata* table names for Ora...
xmltables-sqlserver.sql 12.2 KB 6012 over 13 years ben leinfelder add support for temporal element query in pathq...

Latest revisions

# Date Author Comment
7420 11/09/2012 10:57 AM Chris Jones

In CNodeService.updateReplicationMetadata(), we are setting the replicaVerifiedDate() when we update or wholesale add a new replica. However, in setReplicationStatus(), we only do so when there's a new entry. Change setReplicationStatus() to also update the replicaVerifiedDate on updates of existing entries to be more consistent with other changes. This affects node prioritization based on this date timestamp. Thanks to Skye for pointing this out.

7419 11/09/2012 08:56 AM Chris Jones

To attempt to address performance and stability WRT Hazelcast communication, we're upgrading to the 2.x series of Hazelcast. remove the 1.9.x jar files, and add the 2.4.1-SNAPSHOT jars. Modify HazelcastService to handle the minor change in the ItemListener interface (now passes ItemEvent<Identifier> as an argument)....

7418 11/07/2012 04:27 PM ben leinfelder

implement query description for pathquery -- only tells callers about the pre-indexed paths we have in Metacat since there are an infinite number of "fields" when storing arbitrary XML, but we really don't want people using non-indexed paths for performance reasons anyway. I've typed all the fields as String, even though some are not just strings and can be used for numeric or data comparisons.

7417 11/07/2012 02:53 PM ben leinfelder

Implement MNQuery for "pathquery" engine. Optionally include guid in the pathquery results (https://redmine.dataone.org/issues/3083)

7416 11/05/2012 09:15 AM ben leinfelder

update pub_date when the length of that field is != 4 (use date_created in this scenario). There were 2 entries that had "193" as the pub_date.

7415 11/01/2012 09:03 AM ben leinfelder

replace new lines in creator with spaces. set blank " " titles and creators to "unknown". use "Baltimore Ecosystem Study LTER" for publisher on all BES objects.

7414 10/26/2012 06:50 PM ben leinfelder

include John Kunze's latest suggestions for improved metadata -- a lot of clean-up, especially on characters in the file. Note UTF-8 encoding of the script.

7412 10/26/2012 09:11 AM ben leinfelder

use ObjectFormatInfo libclient utility to look up mimeType and filename extension during get() calls. Configurable mapping file is deployed by default to /var/metacat/dataone where it can then be augmented as needed. This location is controlled in the metacat.properties file (which is injected into the DataONE Settings values during weapp intitialization)....

7411 10/26/2012 09:08 AM ben leinfelder

add count for the total processed pids (from ISet iterator)

7410 10/22/2012 01:38 PM ben leinfelder

handle /object?count=0 queries using simpler (quicker) sql
https://redmine.dataone.org/issues/3065

View revisions

Also available in: Atom