collection.log_file: none
metadata.log_file: none
query.log_file: none

# ----------------------------------------
# VALIDATION

VALIDATION: off

metadata.validation: @VALIDATION
query.validation: @VALIDATION

# ----------------------------------------
# DATABASE

DATABASE-DRIVER-CLASS: org.hsqldb.jdbcDriver
#DATABASE-URL: jdbc:informix-sqli://db02.alexandria.ucsb.edu:1525/drg_teale:INFORMIXSERVER=adl_db02
#DATABASE-URL: jdbc:hsqldb:hsql://localhost
#DATABASE-URL: jdbc:hsqldb:hsql://localhost:9001
DATABASE-URL: jdbc:hsqldb:hsql://piru:9001
#DATABASE-URL: jdbc:hsqldb:C:/adl_builds/mw2_wc/build/WEB-INF/config/collections/sample-collection/morePartsAreHere/drg
#DATABASE-URL: jdbc:hsqldb://C:/adl_builds/mw2_wc/build/WEB-INF/config/collections/sample-collection/morePartsAreHere/drg

DATABASE-PROPERTIES: database.properties
DATABASE-NAME: HSQLdb02

metadata.database_driver_class: @DATABASE-DRIVER-CLASS
metadata.database_url: @DATABASE-URL
#metadata.database_properties: @DATABASE-PROPERTIES
metadata.database_properties: database.properties

query.database_driver_class: @DATABASE-DRIVER-CLASS
query.database_url: @DATABASE-URL
#query.database_properties: @DATABASE-PROPERTIES
query.database_properties: database.properties
query.database_name: @DATABASE-NAME

# ----------------------------------------
# COLLECTION-LEVEL METADATA

#collection.metadata_url: http://collections.alexandria.ucsb.edu/drg_24k_ca/metadata.xml
collection.metadata_file: metadata.xml
# ----------------------------------------
# ITEM-LEVEL METADATA

metadata.identifier_datatype: string

metadata.views: BUCKET,BROWSE,ACCESS,FGDC

BUCKET.name: adl:bucket
BUCKET.class: edu.ucsb.adl.bucket99.GenericQueryMetadataSubdriver
BUCKET.template: bucket-report-template.xml
BUCKET.queries: BUCKET-MAIN-QUERY
BUCKET-MAIN-QUERY.prefix: main
BUCKET-MAIN-QUERY.query: SELECT ocode, title, mapname, state, n_b_coord, s_b_coord, e_b_coord, w_b_coord, year FROM ingest WHERE ocode = ?
BUCKET-MAIN-QUERY.columns: ocode,title,mapname,state,n_b_coord,s_b_coord,e_b_coord,w_b_coord,year
BUCKET-MAIN-QUERY.num_rows_expected: 1

BROWSE.name: adl:browse
BROWSE.class: edu.ucsb.adl.bucket99.GenericQueryMetadataSubdriver
BROWSE.template: browse-report-template.xml
BROWSE.queries: BROWSE-MAIN-QUERY
BROWSE-MAIN-QUERY.prefix: main
BROWSE-MAIN-QUERY.query: SELECT ocode, bytesize_browse, bytesize_thumb FROM ingest WHERE ocode = ?
BROWSE-MAIN-QUERY.columns: ocode,bytesize_browse,bytesize_thumb
BROWSE-MAIN-QUERY.num_rows_expected: 1

ACCESS.name: adl:access
ACCESS.class: edu.ucsb.adl.bucket99.GenericQueryMetadataSubdriver
ACCESS.template: access-report-template.xml
ACCESS.queries: ACCESS-MAIN-QUERY
ACCESS-MAIN-QUERY.prefix: main
#ACCESS-MAIN-QUERY.query: SELECT ocode, ROUND(mbytesize_tif), ROUND(mbytesize_tif*0.4), local_call_num FROM ingest WHERE ocode = ?
ACCESS-MAIN-QUERY.query: SELECT ocode, mbytesize_tif, mbytesize_tif, local_call_num FROM ingest WHERE ocode = ?
ACCESS-MAIN-QUERY.columns: ocode,mbytesize_tif_rounded,mrsid_size_approximation,local_call_num
ACCESS-MAIN-QUERY.num_rows_expected: 1

FGDC.name: FGDC CSDGM
FGDC.class: edu.ucsb.adl.bucket99.GenericQueryMetadataSubdriver
FGDC.template: fgdc-report-template.xml
FGDC.queries: FGDC-MAIN-QUERY
FGDC-MAIN-QUERY.prefix: main
FGDC-MAIN-QUERY.query: SELECT title, year, n_b_coord, s_b_coord, e_b_coord, w_b_coord, mapname, state FROM ingest WHERE ocode = ?
FGDC-MAIN-QUERY.columns: title,year,n_b_coord,s_b_coord,e_b_coord,w_b_coord,mapname,state
FGDC-MAIN-QUERY.num_rows_expected: 1

# ----------------------------------------
# QUERY PROCESSING

query.minimum_connections: 1
query.maximum_connections: 2
query.connection_lifetime: 3600000
query.connection_reaper_cycle_time: 300000
query.test_query: SELECT COUNT(*) FROM ingest

# ----------------------------------------
# QUERY TRANSLATION

query.translator_class: edu.ucsb.adl.bucket99.PythonQueryTranslator

translator.script: query-translator.py
translator.python_module_path: ../../../modules
translator.python_class_path: ../../../classes
translator.python_jar_path: ../../../lib

# ----------------------------------------
# VOCABULARIES

# This collection doesn't require or use
# the vocabulary interface, but we include
# it here just to show what's possible.

translator.vocabularies: