GenomicsDBData/gus.config.sample at main · NIAGADS/GenomicsDBData · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
##
## GUS Configuration
##
## @version $Revision: 11821 $ $Date: 2013-04-07 15:41:45 -0400 (Sun, 07 Apr 2013) $
##

### GUS End User Configuration

# RDBMS Connection Strings
## dbVendor is the RDBMS Vendor.  Postgres or Oracle
## dbiDsn is for Perl ( dbi:Oracle:NAME_OF_DATABASE )
## jdbcDsn is for Java ( eg jdbc:oracle:thin:@HOSTNAME:PORT:NAME_OF_DATABASE )
## NAME_OF_DATABASE can be the full service name or a valid alias
dbVendor=Postgres
dbiDsn=DBI:Pg:dbname=@DB_NAME@;host=@DB_HOST@;port=@DB_PORT@
jdbcDsn=jdbc:postgresql://@DB_HOST@:@DB_PORT@/@DB_NAME@

# Your login and Password to the RDBMS
databaseLogin=@DB_USER@
databasePassword=@DB_PASSWORD@

# Username, group, and project info from the relevant Core tables
# All rows written by you will be tagged with this information
userName=@DB_USER@
group=NIAGADS
project=NIAGADS

# override "tablespace=" attribute of <table> entities in gus_schema.xml
tablespace=GUS

# Path to Perl Executable
perl=/usr/bin/perl

# Path to MD5 Executable
md5sum=/usr/bin/md5sum

################################################################################
###   Warning:  Do not change items below here unless you know what you're doing
################################################################################
# GUS 4.0 candidate schemata
gusSchemas=Core,DoTS,SRes,Study,Platform,Model,Results
coreSchemaName=CORE

sequenceStart=1

### Comma-delimited list of housekeeping columns.  In order as they should appear in the tables
housekeepingColumns=MODIFICATION_DATE,USER_READ,USER_WRITE,GROUP_READ,GROUP_WRITE,OTHER_READ,OTHER_WRITE,ROW_USER_ID,ROW_GROUP_ID,ROW_PROJECT_ID,ROW_ALG_INVOCATION_ID
housekeepingColumnsVer=MODIFICATION_DATE,USER_READ,USER_WRITE,GROUP_READ,GROUP_WRITE,OTHER_READ,OTHER_WRITE,ROW_USER_ID,ROW_GROUP_ID,ROW_PROJECT_ID,ROW_ALG_INVOCATION_ID,VERSION_ALG_INVOCATION_ID,VERSION_DATE,VERSION_TRANSACTION_ID

### type,length,precision,nullable

hkspec.MODIFICATION_DATE=DATE,0,0,false
hkspec.USER_READ=NUMBER,1,0,false
hkspec.USER_WRITE=NUMBER,1,0,false
hkspec.GROUP_READ=NUMBER,1,0,false
hkspec.GROUP_WRITE=NUMBER,1,0,false
hkspec.OTHER_READ=NUMBER,1,0,false
hkspec.OTHER_WRITE=NUMBER,1,0,false
hkspec.ROW_USER_ID=NUMBER,12,0,false
hkspec.ROW_GROUP_ID=NUMBER,4,0,false
hkspec.ROW_PROJECT_ID=NUMBER,4,0,false
hkspec.ROW_ALG_INVOCATION_ID=NUMBER,12,0,false

hkspec.VERSION_ALG_INVOCATION_ID=NUMBER,12,0,true
hkspec.VERSION_DATE=DATE,0,0,true
hkspec.VERSION_TRANSACTION_ID=NUMBER,12,0,true