1 # ----------------------------------------
2 # LOGGING
3 
4 LOG-FILE: /export/home/gjanee/tomcat/logs/drg_24k_ca.log
5 
6 collection.log_file: @LOG-FILE
7 metadata.log_file: @LOG-FILE
8 query.log_file: @LOG-FILE
9 
10 # ----------------------------------------
11 # VALIDATION
12 
13 VALIDATION: off
14 
15 metadata.validation: @VALIDATION
16 query.validation: @VALIDATION
17 
18 # ----------------------------------------
19 # DATABASE
20 
21 DATABASE-DRIVER-CLASS: com.informix.jdbc.IfxDriver
22 DATABASE-URL: jdbc:informix-sqli://db02.alexandria.ucsb.edu:1525/drg_teale:INFORMIXSERVER=adl_db02
23 DATABASE-PROPERTIES: /export/home/gjanee/tomcat/database-props
24 DATABASE-NAME: informix@db02
25 
26 metadata.database_driver_class: @DATABASE-DRIVER-CLASS
27 metadata.database_url: @DATABASE-URL
28 metadata.database_properties: @DATABASE-PROPERTIES
29 
30 query.database_driver_class: @DATABASE-DRIVER-CLASS
31 query.database_url: @DATABASE-URL
32 query.database_properties: @DATABASE-PROPERTIES
33 query.database_name: @DATABASE-NAME
34 
35 # ----------------------------------------
36 # COLLECTION-LEVEL METADATA
37 
38 collection.metadata_url: http://collections.alexandria.ucsb.edu/drg_24k_ca/metadata.xml
39 
40 # ----------------------------------------
41 # ITEM-LEVEL METADATA
42 
43 metadata.identifier_datatype: string
44 
45 metadata.views: BUCKET,BROWSE,ACCESS,FGDC
46 
47 BUCKET.name: adl:bucket
48 BUCKET.class: edu.ucsb.adl.bucket99.GenericQueryMetadataSubdriver
49 BUCKET.template: bucket-report-template.xml
50 BUCKET.queries: BUCKET-MAIN-QUERY
51 BUCKET-MAIN-QUERY.prefix: main
52 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 = ?
53 BUCKET-MAIN-QUERY.columns: ocode,title,mapname,state,n_b_coord,s_b_coord,e_b_coord,w_b_coord,year
54 BUCKET-MAIN-QUERY.num_rows_expected: 1
55 
56 BROWSE.name: adl:browse
57 BROWSE.class: edu.ucsb.adl.bucket99.GenericQueryMetadataSubdriver
58 BROWSE.template: browse-report-template.xml
59 BROWSE.queries: BROWSE-MAIN-QUERY
60 BROWSE-MAIN-QUERY.prefix: main
61 BROWSE-MAIN-QUERY.query: SELECT ocode, bytesize_browse, bytesize_thumb FROM ingest WHERE ocode = ?
62 BROWSE-MAIN-QUERY.columns: ocode,bytesize_browse,bytesize_thumb
63 BROWSE-MAIN-QUERY.num_rows_expected: 1
64 
65 ACCESS.name: adl:access
66 ACCESS.class: edu.ucsb.adl.bucket99.GenericQueryMetadataSubdriver
67 ACCESS.template: access-report-template.xml
68 ACCESS.queries: ACCESS-MAIN-QUERY
69 ACCESS-MAIN-QUERY.prefix: main
70 ACCESS-MAIN-QUERY.query: SELECT ocode, ROUND(mbytesize_tif), ROUND(mbytesize_tif*0.4), local_call_num FROM ingest WHERE ocode = ?
71 ACCESS-MAIN-QUERY.columns: ocode,mbytesize_tif_rounded,mrsid_size_approximation,local_call_num
72 ACCESS-MAIN-QUERY.num_rows_expected: 1
73 
74 FGDC.name: FGDC
75 FGDC.class: edu.ucsb.adl.bucket99.GenericQueryMetadataSubdriver
76 FGDC.template: fgdc-report-template.xml
77 FGDC.queries: FGDC-MAIN-QUERY
78 FGDC-MAIN-QUERY.prefix: main
79 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 = ?
80 FGDC-MAIN-QUERY.columns: title,year,n_b_coord,s_b_coord,e_b_coord,w_b_coord,mapname,state
81 FGDC-MAIN-QUERY.num_rows_expected: 1
82 
83 # ----------------------------------------
84 # QUERY PROCESSING
85 
86 query.minimum_connections: 1
87 query.maximum_connections: 2
88 query.connection_lifetime: 1h
89 query.connection_reaper_cycle_time: 10m
90 query.test_query: SELECT COUNT(*) FROM ingest
91 
92 # ----------------------------------------
93 # QUERY TRANSLATION
94 
95 query.translator_class: edu.ucsb.adl.bucket99.PythonQueryTranslator
96 
97 translator.script: query-translator.py
98 translator.python_module_path: ../../../modules
99 translator.python_class_path: ../../../classes
100 translator.python_jar_path: ../../../lib
101 
102 # ----------------------------------------
103 # VOCABULARIES
104 
105 # This collection doesn't require or use
106 # the vocabulary interface, and so the
107 # 'translator.vocabularies' property
108 # should have an empty value. But we
109 # include an example vocabulary here just
110 # to show what's possible.
111 
112 translator.vocabularies: TYPES
113 
114 TYPE-DATABASE-DRIVER-CLASS: com.informix.jdbc.IfxDriver
115 TYPE-DATABASE-URL: jdbc:informix-sqli://db02.alexandria.ucsb.edu:1525/catalog99:INFORMIXSERVER=adl_db02
116 TYPE-DATABASE-PROPERTIES: /export/home/gjanee/tomcat/database-props
117 
118 TYPES.class: edu.ucsb.adl.bucket99.DatabaseCodedVocabulary
119 TYPES.name: ADL Object Type Thesaurus
120 TYPES.bucket: adl:types
121 TYPES.vocabulary_database_driver_class: @TYPE-DATABASE-DRIVER-CLASS
122 TYPES.vocabulary_database_url: @TYPE-DATABASE-URL
123 TYPES.vocabulary_database_properties: @TYPE-DATABASE-PROPERTIES
124 TYPES.term_code_query: SELECT name, type_id FROM j_type
125 TYPES.code_graph_query: SELECT parent_type_id, type_id FROM j_type_parent
126 TYPES.code_usage_query: SELECT DISTINCT type_id FROM j_holding_type
127 TYPES.usage_database_driver_class: @TYPE-DATABASE-DRIVER-CLASS
128 TYPES.usage_database_url: @TYPE-DATABASE-URL
129 TYPES.usage_database_properties: @TYPE-DATABASE-PROPERTIES