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 7006 almost 13 years ben leinfelder use IdMan method to find docids that do not alr...
  org 5030 over 15 years daigle Change location of PropertyService to propertie...
  perl 6769 about 13 years ben leinfelder ROLLBACK: check for non-public session in Metac...
  php 3134 about 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 about 19 years tyburczy Unix port of transform.bat
  ruby 3132 about 18 years perry Initial import of Chad Burt's ruby metacat client
  scripts 6812 almost 13 years ben leinfelder include SSL settings for client certificate-bas...
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 ...
clear.sql 312 Bytes 704 almost 24 years berkley added removal of relations
delete-xml-documents.sql 937 Bytes 3123 about 18 years Jing Tao Add a script to delete documents manually.
delete-xml-revisions.sql 110 Bytes 3125 about 18 years Jing Tao Add a script can delete xml_revision records.
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 3.2 KB 6658 about 13 years ben leinfelder remove DataONE schema reference in xml_catalog
loaddtdschema-postgres.sql 3.2 KB 6658 about 13 years ben leinfelder remove DataONE schema reference in xml_catalog
loadschema.sql 395 Bytes 4080 over 16 years daigle Merge 1.9 changes into Head
package-count.sql 373 Bytes 2283 over 20 years Matt Jones Added sql for counting packages.
rollback-db-from-1.9-oracle.sql 903 Bytes 4818 almost 16 years daigle Add db rollback scripts
rollback-db-from-1.9-postgres.sql 465 Bytes 4818 almost 16 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...
tsvector.sql 788 Bytes 3751 almost 17 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 about 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 almost 16 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.7 KB 5311 over 14 years daigle Merge 1.9.2 changes back into the trunk
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 5.87 KB 6952 almost 13 years ben leinfelder eliminate the cross product that occurred when ...
upgrade-db-to-2.0.0-postgres.sql 5.95 KB 6952 almost 13 years ben leinfelder eliminate the cross product that occurred when ...
xmlpackage.sql 1.94 KB 439 over 24 years berkley sql file defining the table structure for eml-p...
xmltables-oracle.sql 24.6 KB 6933 almost 13 years Matt Jones Added DOI generation to the 2.0.0 upgrade proce...
xmltables-postgres.sql 21.7 KB 6933 almost 13 years Matt Jones Added DOI generation to the 2.0.0 upgrade proce...
xmltables-sqlserver.sql 12.2 KB 6012 almost 14 years ben leinfelder add support for temporal element query in pathq...

Latest revisions

# Date Author Comment
7006 02/09/2012 03:48 PM ben leinfelder

use IdMan method to find docids that do not already have system metadata records -- this lets us re-run without re computing system metadata for every entry (in case the process is interrupted). I haven' been using this option because I wanted to continually regenerate all SM for everything in my test DBs, but we are so close to release that I want to get this in there.

7005 02/09/2012 02:39 PM ben leinfelder

for testing: limit and randomize the docs to generate metadata for

7004 02/09/2012 08:39 AM ben leinfelder

FOR TESTING ONLY: limit number of records to 100 so that we can get an estimate

7003 02/08/2012 03:46 PM ben leinfelder

update the memberNodeId in existing system metadata only after the register/update is successful with the CN -- we can avoid unneeded SM updates in cases when the register/update fails because we gave the CN bad info that it rejects.
https://redmine.dataone.org/issues/2308

7002 02/08/2012 03:12 PM ben leinfelder

include member node id text field now that the CN is not assigning random Ids.
https://redmine.dataone.org/issues/2308

7001 02/08/2012 01:20 PM ben leinfelder

1. lookup and use the guid when processing obsoletes/obsoletedBy entries -- had previously been assuming localId==guid but now that we have introduced DOIs as part of the Metacat upgrade process, we may have DOIs for the guid that map to localIds.
2. base ORE guids on the localid of the data package they are describing and not on their DOI -- otherwise we might mash up the DOI prefix (or other id scheme that we are unaware of). By using resourceMapPreix + localId we are sure to have a valid localid and guid for the ORE map we create and add to the system

7000 02/08/2012 11:23 AM ben leinfelder

use updated authorization policies as discussed in:
https://redmine.dataone.org/issues/2277
and
http://epad.dataone.org/20120131-authn-authz-questions

6999 02/08/2012 10:58 AM ben leinfelder

refactor D1-specific upgrade utilities into their own package

6998 02/08/2012 10:53 AM ben leinfelder

remove createAndInsertSystemMetadat() method that acts on a single localId -- incorporated this into the localId-list-based method.

6997 02/08/2012 10:50 AM ben leinfelder

refactor IdentityManager.createSystemMetadata(sm) to be insertSystemMetadata(sm) so that it is clear that this method inserts the SM object into the backing store. This differentiates it from the "generation" methods we use when we need to create SM about pre-existing objects or objects we get from non-D1 api calls.

View revisions

Also available in: Atom