Untitled :: IKAN ALM Documentation

DEPLOYENVIRONMENT

Table Description

Key	NULL	Column	Type (Size)
P	No	OID	NUMBER
	No	NAME	VARCHAR2(50)
	No	SOURCELOCATION	VARCHAR2(255)
	No	TARGETLOCATION	VARCHAR2(255)
	No	DEBUG	NUMBER(1)
	No	PARTIALDEPLOY	NUMBER(1)
	Yes	DEPLOYSCRIPT	VARCHAR2(255)
	No	SEQUENCENUMBER	NUMBER
F	No	SCMLEVELOID	NUMBER
F	No	MACHINEOID	NUMBER
	No	TOOLOID	NUMBER
F	No	BUILDENVIRONMENTOID	NUMBER
	Yes	ARCHIVED	NUMBER(1)
	Yes	ARCHIVEDDATETIME	DATE
	No	VERSION	NUMBER

Key

NULL

Column

Type (Size)

NUMBER

VARCHAR2(50)

VARCHAR2(255)

VARCHAR2(255)

NUMBER(1)

NUMBER(1)

Yes

VARCHAR2(255)

NUMBER

NUMBER

NUMBER

NUMBER

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

Key	NULL	Column	Type (Size)
P	No	OID	NUMBER

NAME

Name of the Deploy Environment.

Key	NULL	Column	Type (Size)
	No	NAME	VARCHAR2(50)

Key

NULL

Column

Type (Size)

NAME

VARCHAR2(50)

SOURCELOCATION

The path to the physical location where the unpacked build result is placed.

IKAN ALM adds the Deploy OID: SourceLocation/DeployOID

This location is passed to the Deploy Script as a parameter named source.

(For ANT, this is a property.)

Key	NULL	Column	Type (Size)
	No	SOURCELOCATION	VARCHAR2(255)

Key

NULL

Column

Type (Size)

SOURCELOCATION

VARCHAR2(255)

TARGETLOCATION

The path to the physical location where the Deploy Script will deploy the Build result.

Key	NULL	Column	Type (Size)
	No	TARGETLOCATION	VARCHAR2(255)

Key

NULL

Column

Type (Size)

TARGETLOCATION

VARCHAR2(255)

DEBUG

Indication whether or not the Debug option is activated for the Deploy Environment.

If Debug is activated for a Deploy Environment, the Build Clean-up action will not be performed, so that the user may use the available build results to run the deploy script manually for testing purposes.

Key	NULL	Column	Type (Size)
	No	DEBUG	NUMBER(1)

Key

NULL

Column

Type (Size)

DEBUG

NUMBER(1)

Value List

0 = no

1 = yes

PARTIALDEPLOY

Indication whether the Partial Deploy option must be activated or not for this Deploy Environment.

If the option is activated, IKAN ALM will analyze the differences between the two build results on the IKAN ALM Server and only new and modified files will be transported to the Agent.

This is achieved as follows:

Both the newly compiled Build result and the base-line Build (the one the new Build results are compared with) are decompressed (unzipped).

The decompressed files are compared and the following actions are taken:

Identical files are deleted and not deployed.
Modified and new files (available in the new but not in the base-line

Build results) are transported.

For deleted files (available in the base-line Build result, but not in the new one), dummy files with names in the format FileName. to_be_deleted are created. The Deploy Script must be written in such a way, that it deletes the matching files from the Deploy Environment’s Source Location.

Key	NULL	Column	Type (Size)
	No	PARTIALDEPLOY	NUMBER(1)

Key

NULL

Column

Type (Size)

PARTIALDEPLOY

NUMBER(1)

Value List

0 = no

1 = yes

DEPLOYSCRIPT

The relative path to the Deploy Script that is selected specifically for this Deploy Environment.

If the field is empty, the default Deploy Script whose relative path is defined on the Project Settings screen will be used for this Deploy Environment.

Key	NULL	Column	Type (Size)
	Yes	DEPLOYSCRIPT	VARCHAR2(255)

Key

NULL

Column

Type (Size)

Yes

DEPLOYSCRIPT

VARCHAR2(255)

SEQUENCENUMBER

Number indicating the position of the Deploy Environment within the sequence of Deploy Environments associated with the Level.

Key	NULL	Column	Type (Size)
	No	SEQUENCENUMBER	NUMBER

Key

NULL

Column

Type (Size)

SEQUENCENUMBER

NUMBER

SCMLEVELOID

Identifier for the SCMLEVEL table.

For more information, refer to the description of the foreign key DEPLOYENVIRONMENT_FK_1.

Key	NULL	Column	Type (Size)
F	No	SCMLEVELOID	NUMBER

MACHINEOID

Identifier for the MACHINE table.

For more information, refer to the description of the foreign key DEPLOYENVIRONMENT_FK_2.

Key	NULL	Column	Type (Size)
F	No	MACHINEOID	NUMBER

TOOLOID

OID identifying the tool used by the Deploy Environment. Refers to the primary key of the appropriate tool table: ANT, NANT, MAVEN2 or Gradle.

Key	NULL	Column	Type (Size)
	No	TOOLOID	NUMBER

Key

NULL

Column

Type (Size)

TOOLOID

NUMBER

BUILDENVIRONMENTOID

Identifier for the BUILDENVIRONMENT table.

For more information, refer to the description of the foreign key DEPLOYENVIRONMENT_FK_3.

Key	NULL	Column	Type (Size)
F	No	BUILDENVIRONMENTOID	NUMBER

ARCHIVED

For internal use only.

Key	NULL	Column	Type (Size)
	Yes	ARCHIVED	NUMBER(1)

Key

NULL

Column

Type (Size)

Yes

ARCHIVED

NUMBER(1)

Value List

0 = no

1 = yes

ARCHIVEDDATETIME

For internal use only.

Key	NULL	Column	Type (Size)
	Yes	ARCHIVEDDATETIME	DATE

Key

NULL

Column

Type (Size)

Yes

ARCHIVEDDATETIME

DATE

VERSION

For internal use only.

Key	NULL	Column	Type (Size)
	No	VERSION	NUMBER

Key

NULL

Column

Type (Size)

VERSION

NUMBER

Indexes

Index	Primary	Unique	Column(s)	Source Table
DEPLOYENVIRONMENT_PK	Yes	Yes	OID
DEPLOYENVIRONMENT_FK_1	No	No	SCMLEVELOID	SCMLEVEL
DEPLOYENVIRONMENT_FK_2	No	No	MACHINEOID	MACHINE
DEPLOYENVIRONMENT_FK_3	No	No	BUILDENVIRONMENTOID	BUILDENVIRONMENT

Index

Primary

Unique

Column(s)

Source Table

DEPLOYENVIRONMENT_PK

Yes

OID

DEPLOYENVIRONMENT_FK_1

SCMLEVELOID

SCMLEVEL

DEPLOYENVIRONMENT_FK_2

MACHINEOID

MACHINE

DEPLOYENVIRONMENT_FK_3

BUILDENVIRONMENTOID

BUILDENVIRONMENT

Relationships

Referenced Tables

BUILDENVIRONMENT

Refer to the chapter BUILDENVIRONMENT for a detailed description of the table.

Foreign Key	Referenced Column(s)
DEPLOYENVIRONMENT_FK_3	OID

Foreign Key

Referenced Column(s)

DEPLOYENVIRONMENT_FK_3

OID

MACHINE

Refer to the chapter MACHINE for a detailed description of the table.

Foreign Key	Referenced Column(s)
DEPLOYENVIRONMENT_FK_2	OID

Foreign Key

Referenced Column(s)

DEPLOYENVIRONMENT_FK_2

OID

SCMLEVEL

Refer to the chapter SCMLEVEL for a detailed description of the table.

Foreign Key	Referenced Column(s)
DEPLOYENVIRONMENT_FK_1	OID

Foreign Key

Referenced Column(s)

DEPLOYENVIRONMENT_FK_1

OID

Referencing Tables

DEPLOY

Refer to the chapter DEPLOY for a detailed description of the table.

Foreign Key	Referencing Column
DEPLOY_FK_2	DEPLOYENVIRONMENTOID

Foreign Key

Referencing Column

DEPLOY_FK_2

DEPLOYENVIRONMENTOID

DEPLOYPARAMETER

Refer to the chapter DEPLOYPARAMETER for a detailed description of the table.

Foreign Key	Referencing Column
DEPLOYPARAMETER_FK_1	DEPLOYENVIRONMENTOID

Foreign Key

Referencing Column

DEPLOYPARAMETER_FK_1

DEPLOYENVIRONMENTOID

Report Labels

DEPLOYENVIRONMENT_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

DEPLOYENVIRONMENT_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

DEPLOYENVIRONMENT_BUILDENVIRONMENTOID_LABEL

English:

OID

French:

OID

German:

OID

DEPLOYENVIRONMENT_DEBUG_LABEL

English:

Debug Option

French:

Option débogage

German:

Debug

DEPLOYENVIRONMENT_DEPLOYSCRIPT_LABEL

English:

Deploy Script

French:

Script de déploiement

German:

Auslieferungsskript

DEPLOYENVIRONMENT_MACHINEOID_LABEL

English:

OID

French:

OID

German:

OID

DEPLOYENVIRONMENT_NAME_LABEL

English:

Name

French:

Nom

German:

Name

DEPLOYENVIRONMENT_OID_LABEL

English:

OID

French:

OID

German:

OID

DEPLOYENVIRONMENT_PARTIALDEPLOY_LABEL

English:

Partial Deploy

French:

Déploiement partiel

German:

Partielle Auslieferung

DEPLOYENVIRONMENT_SCMLEVELOID_LABEL

English:

OID

French:

OID

German:

OID

DEPLOYENVIRONMENT_SEQUENCENUMBER_LABEL

English:

Sequence Number

French:

Numéro de séquence

German:

Sequenznummer

DEPLOYENVIRONMENT_SOURCELOCATION_LABEL

English:

Source Location

French:

Emplacement Source

German:

Quellstandort

DEPLOYENVIRONMENT_TARGETLOCATION_LABEL

English:

Target Location

French:

Emplacement Cible

German:

Zielstandort

DEPLOYENVIRONMENT_TOOLOID_LABEL

English:

OID

French:

OID

German:

OID

DEPLOYENVIRONMENT_VERSION_LABEL

English:

Version

French:

Version

German:

Version