Project

General

Profile

Statistics
| Revision:

metacat / src @ 7370

Name Size Revision Age Author Comment
  com 2532 almost 16 years sgarg renaming enum to catalogEnum to prevent compila...
  edu 7370 over 8 years ben leinfelder use SchemaLocationResolver to fetch remote entr...
  org 5030 over 11 years daigle Change location of PropertyService to propertie...
  perl 7226 almost 9 years ben leinfelder use kepler account as default
  php 3134 over 14 years perry added gpl header to php metacat lib
  python 6926 over 9 years Matt Jones An example python script that uses the python c...
  query-client 2824 over 15 years tyburczy Unix port of transform.bat
  ruby 3132 over 14 years perry Initial import of Chad Burt's ruby metacat client
  scripts 7357 over 8 years ben leinfelder include certificate export SSL options as an ex...
LTER_DOI_conversion.sql 717 Bytes 7283 almost 9 years ben leinfelder remove the non-doi identifiers before updating ...
addforeignkeyfortable.sql 135 Bytes 1626 about 18 years Jing Tao Create a foreign key for table accesssubtree.
alter-datafile-for-knbbackup.sql 1.66 KB 2662 over 15 years Jing Tao Add a new sql file to alter control file which ...
apply-xmlconstraints-postgres-knb.sql 6.23 KB 7181 almost 9 years ben leinfelder script for re-applying missing FK constraints o...
clear.sql 312 Bytes 704 about 20 years berkley added removal of relations
convert_denyFirst.sql 2.12 KB 7227 almost 9 years ben leinfelder script to aid in converting denyFirst rules to ...
delete-xml-documents.sql 937 Bytes 3123 over 14 years Jing Tao Add a script to delete documents manually.
delete-xml-revisions.sql 110 Bytes 3125 over 14 years Jing Tao Add a script can delete xml_revision records.
delete_all_by_pid.sql 4.14 KB 7294 almost 9 years ben leinfelder include parameter for deleting system metadata ...
doi_registration.sql 20.5 KB 7365 over 8 years ben leinfelder use resourceMapLocation (resolve url for the or...
drop-postgres.sql 2.24 KB 5956 about 10 years Matt Jones Updated DROP script that was missing tables and...
increase-xml-queryresult-size-postgres.sql 952 Bytes 3297 almost 14 years Jing Tao A sql to increase column size of queryresult_st...
loaddtd.sql 2.07 KB 4080 almost 13 years daigle Merge 1.9 changes into Head
loaddtdschema-oracle.sql 5.57 KB 7369 over 8 years ben leinfelder prep for 2.0.4 release
loaddtdschema-postgres.sql 5.57 KB 7369 over 8 years ben leinfelder prep for 2.0.4 release
loadschema.sql 395 Bytes 4080 almost 13 years daigle Merge 1.9 changes into Head
package-count.sql 373 Bytes 2283 over 16 years Matt Jones Added sql for counting packages.
rollback-db-from-1.9-oracle.sql 903 Bytes 4818 about 12 years daigle Add db rollback scripts
rollback-db-from-1.9-postgres.sql 465 Bytes 4818 about 12 years daigle Add db rollback scripts
showdoc.sql 340 Bytes 390 over 20 years Matt Jones Added new utility query to return all of the xm...
sqlcatlist.sql 253 Bytes 123 almost 21 years Matt Jones Modifying storage model to use DOM TEXT nodes
sqldoclist.sql 209 Bytes 531 over 20 years Matt Jones Changed utility query to include the user_owner...
sqlnodeslist.sql 94 Bytes 108 almost 21 years Matt Jones added utility files and queries
sqlnodesview.sql 358 Bytes 166 almost 21 years Matt Jones minor modifications to fix problems introduced ...
sqlrevisions.sql 205 Bytes 203 almost 21 years Matt Jones Merged in substantial changes to DBWriter and a...
system_metadata_revisions.sql 1.38 KB 7353 over 8 years ben leinfelder correct the update statement for setting archiv...
tsvector.sql 788 Bytes 3751 about 13 years Jing Tao Add new code for xml_nodes table.
upgrade-db-to-1.2-oracle.sql 600 Bytes 4104 almost 13 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.2-postgres.sql 637 Bytes 4080 almost 13 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.3-oracle.sql 1.44 KB 4104 almost 13 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.3-postgres.sql 2.56 KB 4080 almost 13 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.4-oracle.sql 4.36 KB 4104 almost 13 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.4-postgres.sql 5.03 KB 4080 almost 13 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.5-oracle.sql 5.9 KB 4413 over 12 years daigle Add nodedatanumerical column and associated pop...
upgrade-db-to-1.5-postgres.sql 5.65 KB 4080 almost 13 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.6-oracle.sql 9.66 KB 4414 over 12 years daigle Re-add the xml_node id trigger. In oracle, thi...
upgrade-db-to-1.6-postgres.sql 7.66 KB 4080 almost 13 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.7-oracle.sql 509 Bytes 4104 almost 13 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.7-postgres.sql 509 Bytes 3052 over 14 years Matt Jones Modifications to the table definitions to add i...
upgrade-db-to-1.8-oracle.sql 214 Bytes 4104 almost 13 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.8-postgres.sql 1.43 KB 3607 over 13 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 about 12 years daigle Add db rollback scripts
upgrade-db-to-1.9-postgres.sql 903 Bytes 4797 about 12 years daigle Add the service registration xml schema to the ...
upgrade-db-to-1.9.1-oracle.sql 127 Bytes 4873 about 12 years daigle Update version to 1.9.1. Add nrs ldap properti...
upgrade-db-to-1.9.1-postgres.sql 125 Bytes 4873 about 12 years daigle Update version to 1.9.1. Add nrs ldap properti...
upgrade-db-to-1.9.2-oracle.sql 1.62 KB 7035 about 9 years ben leinfelder fixed Oracle script issues identified by: Brian...
upgrade-db-to-1.9.2-postgres.sql 1.34 KB 5012 almost 12 years daigle Added end time to workflow scheduler.
upgrade-db-to-1.9.3-oracle.sql 127 Bytes 5507 over 10 years ben leinfelder add 1.9.3 upgrade scripts to trunk
upgrade-db-to-1.9.3-postgres.sql 125 Bytes 5507 over 10 years ben leinfelder add 1.9.3 upgrade scripts to trunk
upgrade-db-to-1.9.4-oracle.sql 127 Bytes 6209 almost 10 years ben leinfelder merge changes from 1.9.5 branch for upgrade pro...
upgrade-db-to-1.9.4-postgres.sql 125 Bytes 6209 almost 10 years ben leinfelder merge changes from 1.9.5 branch for upgrade pro...
upgrade-db-to-1.9.5-oracle.sql 195 Bytes 6209 almost 10 years ben leinfelder merge changes from 1.9.5 branch for upgrade pro...
upgrade-db-to-1.9.5-postgres.sql 194 Bytes 6209 almost 10 years ben leinfelder merge changes from 1.9.5 branch for upgrade pro...
upgrade-db-to-2.0.0-oracle.sql 8.12 KB 7194 almost 9 years ben leinfelder include eml2.0.0beta4 DTD during Metacat build ...
upgrade-db-to-2.0.0-postgres.sql 8.2 KB 7194 almost 9 years ben leinfelder include eml2.0.0beta4 DTD during Metacat build ...
upgrade-db-to-2.0.1-oracle.sql 164 Bytes 7276 almost 9 years ben leinfelder update for 2.0.1 upgrade -- scripts, docs, readme
upgrade-db-to-2.0.1-postgres.sql 163 Bytes 7276 almost 9 years ben leinfelder update for 2.0.1 upgrade -- scripts, docs, readme
upgrade-db-to-2.0.2-oracle.sql 164 Bytes 7300 almost 9 years ben leinfelder prep for 2.0.2 release by updating the version ...
upgrade-db-to-2.0.2-postgres.sql 163 Bytes 7300 almost 9 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 8 years ben leinfelder prep for 2.0.3 release
upgrade-db-to-2.0.3-postgres.sql 163 Bytes 7347 over 8 years ben leinfelder prep for 2.0.3 release
upgrade-db-to-2.0.4-oracle.sql 164 Bytes 7369 over 8 years ben leinfelder prep for 2.0.4 release
upgrade-db-to-2.0.4-postgres.sql 163 Bytes 7369 over 8 years ben leinfelder prep for 2.0.4 release
xmlpackage.sql 1.94 KB 439 over 20 years berkley sql file defining the table structure for eml-p...
xmltables-oracle.sql 24.6 KB 7053 about 9 years ben leinfelder increase amount of text the 'xml_path_index.pat...
xmltables-postgres.sql 21.7 KB 7053 about 9 years ben leinfelder increase amount of text the 'xml_path_index.pat...
xmltables-sqlserver.sql 12.2 KB 6012 about 10 years ben leinfelder add support for temporal element query in pathq...

Latest revisions

# Date Author Comment
7370 09/04/2012 03:43 PM ben leinfelder

use SchemaLocationResolver to fetch remote entries for the xml_catalog -- we want to be able to fetch included xsd files as well as use any error handling it provides for checking the schemas.

7369 09/03/2012 09:05 PM ben leinfelder

prep for 2.0.4 release

7368 09/03/2012 01:50 PM ben leinfelder

when performing query, make sure we are using the access rules of the latest revision of a given docid, otherwise we may include documents that used to be public but have been made private in subsequent revisions.
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5696

7367 08/31/2012 03:05 PM ben leinfelder

correct the number of prepared statement parameters when inserting to xml_revisions table.
Errors like the following were showing in the replication log file:
knb 20120831-19:42:38: [ERROR]: DocumentImpl.writeReplication - Failed to create access rule for package: john.15950.1 because The column index is out of range: 12, number of columns: 11. [ReplicationLogging]

7366 08/24/2012 08:24 AM ben leinfelder

include WHERE in the sql where clause - encountered by SAEON's node admin, Alex Niehaus.

7365 08/23/2012 10:41 PM ben leinfelder

use resourceMapLocation (resolve url for the ore map) as the datacite_relatedIdentifier_isPartOf property

7364 08/23/2012 10:38 PM ben leinfelder

use lowercase 'metadata' and 'data' for the resourceType

7363 08/23/2012 10:36 PM ben leinfelder

set publisher to the source system when publisher == creator (we want them to be different, even if just for appearances)

7362 08/23/2012 10:25 PM ben leinfelder

only include public (readable) DOIs in the final output

7361 08/23/2012 10:24 PM ben leinfelder

use "lastname, firstname" convention throughout

View revisions

Also available in: Atom