# ----------------------------------------
# LOGGING

LOG-FILE: combined-log

collection.log_file: @LOG-FILE
identifiers.log_file: @LOG-FILE
metadata.log_file: @LOG-FILE
query.log_file: @LOG-FILE

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

VALIDATION: off

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

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

DATABASE-DRIVER-CLASS: com.informix.jdbc.IfxDriver
DATABASE-URL: jdbc:informix-sqli://db02.alexandria.ucsb.edu:1525/drg_teale:INFORMIXSERVER=adl_db02
DATABASE-PROPERTIES: /export/home/gjanee/tomcat/database-props
DATABASE-NAME: informix@@db02

identifiers.database_driver_class: @DATABASE-DRIVER-CLASS
identifiers.database_url: @DATABASE-URL
identifiers.database_properties: @DATABASE-PROPERTIES

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

query.database_driver_class: @DATABASE-DRIVER-CLASS
query.database_url: @DATABASE-URL
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

# ----------------------------------------
# IDENTIFIERS

metadata.identifier_datatype: string

identifiers.query: SELECT ocode FROM ingest

# ----------------------------------------
# ITEM-LEVEL METADATA

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.columns: ocode,mbytesize_tif_rounded,mrsid_size_approximation,local_call_num
ACCESS-MAIN-QUERY.num_rows_expected: 1

FGDC.name: FGDC
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: 1h
query.connection_reaper_cycle_time: 10m
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:
translator.python_class_path:
translator.python_jar_path:

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

# This collection doesn't require or use
# the vocabulary interface, and so the
# 'translator.vocabularies' property
# should have an empty value.  But we
# include an example vocabulary here just
# to show what's possible.

translator.vocabularies: TYPES

TYPE-DATABASE-DRIVER-CLASS: com.informix.jdbc.IfxDriver
TYPE-DATABASE-URL: jdbc:informix-sqli://db02.alexandria.ucsb.edu:1525/catalog99:INFORMIXSERVER=adl_db02
TYPE-DATABASE-PROPERTIES: /export/home/gjanee/tomcat/database-props

TYPES.class: edu.ucsb.adl.bucket99.DatabaseCodedVocabulary
TYPES.name: ADL Object Type Thesaurus
TYPES.bucket: adl:types
TYPES.vocabulary_database_driver_class: @TYPE-DATABASE-DRIVER-CLASS
TYPES.vocabulary_database_url: @TYPE-DATABASE-URL
TYPES.vocabulary_database_properties: @TYPE-DATABASE-PROPERTIES
TYPES.term_code_query: SELECT name, type_id FROM j_type
TYPES.code_graph_query: SELECT parent_type_id, type_id FROM j_type_parent
TYPES.code_usage_query: SELECT DISTINCT type_id FROM j_holding_type
TYPES.usage_database_driver_class: @TYPE-DATABASE-DRIVER-CLASS
TYPES.usage_database_url: @TYPE-DATABASE-URL
TYPES.usage_database_properties: @TYPE-DATABASE-PROPERTIES