# Rules and Syntax for this file:
#
#  If the property you are currently specifying
#  fits in one of the categories herein (delimited by -------)
#  then define it in the group
#
#  If the property does not fit in one of the categories,
#  please choose an appropriate name for a category
#  and add it to the file, following the same logic present
#
#  Please prefix your property with a lower case simple
#  identifier so that it can be easely identified elsewhere
# 
#  Please specify a @message metadata that is easy to understand
#  by non-technical personel
#
#  Please use the @type most appropriate for the property 
#  you are defining and only use the general string type
#  if your property is freeform
#   
#  Use the type "default" or "nullableDefault" if your property has just 
#  one possible value, even if you indicate the options and
#  optionsValues for later replacement by a "menu" type
# 
#  Please clean all the properties that are not used anymore
#  and don't expect others to comment on the properties that
#  you defined... Do it yourself from the beggining. It will
#  be easier even for you in the future.  
#
#  Mainly this indications are just common sense rules...
#  Follow them so that the system is easy for you and others 
#  to build...
# 
#  Please feel free to propose and write additional rules
#  that you find important to keep the system clean.
# 
#----------------------------------------------------------------
# Tomcat installer
#----------------------------------------------------------------
#
# @message = Tomcat deployment type (to use Link to workspace build you must be on linux)
# @type = menu
# @options = {"War file copy","Exploded war copy","link to workspace build"}
# @optionsValues = {"war","exploded.war","link.workspace"}
installer.tomcat.deploy.type=link.workspace

# @message = Tomcat home directory for deployement
# @type = path
# @required = yes
installer.tomcat.home=/home/jpereira/tomcat_test


#----------------------------------------
# Database Installer  - install & upgrade
#----------------------------------------
#
# @message = Install or upgrade fenix and slide databases
# @type = menu
# @options={"Install from scratch","Upgrade existing"}
# @optionsValues={"install","upgrade"}
# @required=false
dbinstaller.installOrUpgrade=

# @message = Database Driver Class for connection to Fenix and Slide databases
# @type = menu
# @options={"MySQL Driver class"}
# @optionsValues={"com.mysql.jdbc.Driver"}
# @dependency=dbinstaller.installOrUpgrade=*
dbinstaller.driverClassName=com.mysql.jdbc.Driver

# @message = Database URL Schema for connecting to Fenix and Slide databases and execute
# multiple DDL statements
# @type = string
# @dependency=dbinstaller.installOrUpgrade=*
dbinstaller.connectionUrlSchema=jdbc:mysql://${host}:${port}/${dbname}?jdbcCompliantTruncation=false&allowMultiQueries=true&useUnicode=true&characterEncoding=latin1&zeroDateTimeBehavior=convertToNull

# @message = Should slide database be installed? 
# @type = default
# @yesOption=y
# @yesOptionValue=true
# @noOption=n 
# @noOptionValue=false
# @persist = true
# @dependency=dbinstaller.installOrUpgrade=install
dbinstaller.installSlide=false

# @message = DDL Schema to create database
# @type = string
# @dependency=dbinstaller.installOrUpgrade=install
dbinstaller.createDatabaseDDLSchema=create database if not exists ${dbname}

# @message = DDL Schema to create users and give them privileges to the fenix and slide databases
# @type = string
# @dependency=dbinstaller.installOrUpgrade=install
dbinstaller.createUserDDLSchema=grant select, update, delete, insert, create on ${dbname}.* to '${username}'@'%' identified by '${password}'; flush privileges;

# @message = DDL Schema to create full privileges on the fenix and slide databases to the administration user
# @type = string
# @dependency=dbinstaller.installOrUpgrade=install
dbinstaller.grantFullPrivsUserDDLSchema=grant ALL on ${dbname}.* to '${username}'@'%' identified by '${password}'; flush privileges;

# @message = The database host
# @type = string
# @dependency=dbinstaller.installOrUpgrade=*
dbinstaller.dbHost=${repository.db.host}

# @message = The database port
# @type = string
# @dependency=dbinstaller.installOrUpgrade=*
dbinstaller.dbPort=${repository.db.port}

# @message = The database administrator user (must have permissions to create databases, users and privileges)
# @type = string
# @persist = false
# @dependency=dbinstaller.installOrUpgrade=*
dbinstaller.dbAdminUser=root

# @message = The database administrator user's password
# @type = password
# @persist = false
# @dependency=dbinstaller.installOrUpgrade=*
dbinstaller.dbAdminPassword=

# @message = The fenix database user for application access
# @type = string
# @persist = true
# @dependency=dbinstaller.installOrUpgrade=install
dbinstaller.fenixDBUser=${repository.db.user}

# @message = The fenix database user's password for application access
# @type = string
# @persist = true
# @dependency=dbinstaller.installOrUpgrade=install
dbinstaller.fenixDBPassword=${repository.db.password}

# @message = The slide database user for application access
# @type = string
# @persist = true
# @dependency=dbinstaller.installSlide=true
dbinstaller.slideDBUser=${repository.slide.db.user}

# @message = The slide database user's password for application access
# @type = string
# @persist = true
# @dependency=dbinstaller.installSlide=true
dbinstaller.slideDBPassword=${repository.slide.db.password}

# @message = The fenix database name
# @type = string
# @persist = true
# @dependency=dbinstaller.installOrUpgrade=*
dbinstaller.dbNameFenix=${repository.db.name}

# @message = The slide database name
# @type = string
# @persist = true
# @dependency=dbinstaller.installSlide=true
dbinstaller.dbNameSlide=${repository.slide.db.name}

# @message = The base catalog database name 
# @type = string
# @persist = true
# @dependency=dbinstaller.installOrUpgrade=install
dbinstaller.dbNameBase=mysql


# @message = Create also Some test data
# @type = boolean
# @yesOption=y
# @yesOptionValue=true
# @noOption=n 
# @noOptionValue=false
# @persist = true
# @dependency=dbinstaller.installOrUpgrade=install
dbinstaller.createTestData=false

# @message = Create also one Fenix Management user
# @type = boolean
# @yesOption=y
# @yesOptionValue=true
# @noOption=n 
# @noOptionValue=false
# @persist = true
# @dependency=dbinstaller.installOrUpgrade=install
# @dependency=dbinstaller.createTestDate=false
dbinstaller.createFenixManagerUser=true

# @message = Fenix Management username (for login)
# @type = string
# @persist = false
# @dependency=dbinstaller.createFenixManagerUser=true
dbinstaller.fenixManagerUser=admin

# @message = Fenix Management user's password
# @type = password
# @persist = false
# @dependency=dbinstaller.createFenixManagerUser=true
dbinstaller.fenixManagerUserPassword=pass

# @message = Fenix Management user's full name 
# @type = string
# @persist = true
# @dependency=dbinstaller.createFenixManagerUser=true
dbinstaller.fenixManagerUserName=Fenix System Administrator

# @message = Fenix Management user's gender
# @type = menu
# @options = {"Female","Male"}
# @optionsValues = {"FEMALE","MALE"}
# @persist = true
# @dependency=dbinstaller.createFenixManagerUser=true
dbinstaller.fenixManagerUserGender=MALE

# @message = Create default Degree Administrative Office
# @type = boolean
# @persist = true
# @yesOption=y
# @yesOptionValue=true
# @noOption=n 
# @noOptionValue=false
dbinstaller.createDegreeAdministrativeOffice=true

# @message = Degree Administrative Office name
# @type = string
# @persist = true
# @dependency=dbinstaller.createDegreeAdministrativeOffice=true
dbinstaller.degreeAdministrativeOfficeName=Secretaria de Graduação

# @message = Degree Administrative Office acronym
# @type = string
# @persist = true
# @dependency=dbinstaller.createDegreeAdministrativeOffice=true
dbinstaller.degreeAdministrativeOfficeAcronym=SG

# @message = Create default Pos Grad Administrative Office
# @type = boolean
# @persist = true
# @yesOption=y
# @yesOptionValue=true
# @noOption=n 
# @noOptionValue=false
dbinstaller.createPosGradDegreeAdministrativeOffice=true

# @message = Pos Grad Administrative Office name
# @type = string
# @persist = true
# @dependency=dbinstaller.createPosGradDegreeAdministrativeOffice=true
dbinstaller.posGradAdministrativeOfficeName=Secretaria de Pós-Graduação

# @message = Pos Grad Administrative Office Acronym
# @type = string
# @persist = true
# @dependency=dbinstaller.createPosGradDegreeAdministrativeOffice=true
dbinstaller.posGradAdministrativeOfficeAcronym=SPG


# @message = University Name
# @type = string
# @persist = true
dbinstaller.topUnitName=Universidade

# @message = University URL
# @type = string
# @persist = true
dbinstaller.topUnitURL=


# @message = University Acronym
# @type = string
# @persist = true
dbinstaller.topUnitAcronym=Uni


# @message = External Institutions base Unit Name
# @type = string
# @persist = true
dbinstaller.externalInstitutionUnitName=Instituições Externas


# @message = database direct client command line simple execution
# @type = string
# @dependency=dbinstaller.installOrUpgrade=upgrade
dbinstaller.dbDDLClientSchemaExecute=mysql -u${username} -f -p${password} ${dbname} < ${file}

# @message = database direct client command line execution with temporary file
# @type = string
# @dependency=dbinstaller.installOrUpgrade=upgrade
dbinstaller.dbDDLClientSchemaExecuteToTempFile=mysql -u${username} -f -p${password} ${dbname} < ${file} > ${tempfile};

# @message = keep the generated temporary sql files
# @type = boolean
# @yesOption = y 
# @yesOptionValue = true
# @noOption = y
# @noOptionValue = false
# @dependency=dbinstaller.installOrUpgrade=upgrade
dbinstaller.keepDDLTempFile=false

# @message = database upgrades base directory
# @type = path
# @validatePath = yes
# @dependency=dbinstaller.installOrUpgrade=upgrade
dbinstaller.upgradesDirectory=etc/database_operations

#------------------------------------------------------------------------------
# End of build.properties.sample file
#------------------------------------------------------------------------------