GetAccountState

Folder description:


Folder	Description
AccountState	This application simulate get bank account state process which using rating of client bonita.
/ProcessDefinitions	All process definitions
/ProcessDefinitions/GetAccountState	Main AccountState processes

Process description:


Load AccountState of concrete user's account from xml file

Process definition:

Full process path: ProcessDefinitions/GetAccountState/GetAccountState.process

Diagram:

Process starter activity:

Name: Start

Description: Start process with account owner name.

Input Parameters:

+ root (Complex Type, required )
- - Name (XML Element Reference, required )
- - ID(xsd:int,required)

Process end activity:

Name: End

Output Parameters:

- Account (XML Element Reference, required )

Return bindings:

Mapping table
Target Source
[COPY-OF] < $Schema0/pfx:Account >

Target	Source
	[COPY-OF] < $Schema0/pfx:Account >

Mapping tree


Account = [COPY-OF] < $Schema0/pfx:Account >

Source code


        <xsl:copy-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:pd="http://xmlns.tibco.com/bw/process/2003" xmlns:ns="http://www.tibco.com/pe/DeployedVarsType" xmlns:pfx="http://www.tibco.com/schemas/AccountState/SharedResources/Schema.xsd" xmlns:ns1="http://www.tibco.com/namespaces/tnt/plugins/file" xmlns:ns2="http://www.tibco.com/namespaces/tnt/plugins/file/v2" xmlns:xsd="http://www.w3.org/2001/XMLSchema" select="$Schema0/pfx:Account"/>

Process variables:

Schema: Schema0

Activities:

Name: Assign ActualAccount

Type: com.tibco.pe.core.AssignActivity
Resource Type: ae.activities.assignActivity
Description: Assign Account data when the owner name and input name are same
Configuration:
- variableName = Schema0

Input bindings:

Mapping table
Target Source
[COPY-OF] < $ParseXML-AccountsList/pfx:AccountsList[$AccountIndex]/pfx:Account >

Target	Source
	[COPY-OF] < $ParseXML-AccountsList/pfx:AccountsList[$AccountIndex]/pfx:Account >

Mapping tree


Account = [COPY-OF] < $ParseXML-AccountsList/pfx:AccountsList[$AccountIndex]/pfx:Account >

Source code


                <xsl:copy-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:pd="http://xmlns.tibco.com/bw/process/2003" xmlns:ns="http://www.tibco.com/pe/DeployedVarsType" xmlns:pfx="http://www.tibco.com/schemas/AccountState/SharedResources/Schema.xsd" xmlns:ns1="http://www.tibco.com/namespaces/tnt/plugins/file" xmlns:ns2="http://www.tibco.com/namespaces/tnt/plugins/file/v2" xmlns:xsd="http://www.w3.org/2001/XMLSchema" select="$ParseXML-AccountsList/pfx:AccountsList[$AccountIndex]/pfx:Account"/>

Name: Assign NullAccount

Type: com.tibco.pe.core.AssignActivity
Resource Type: ae.activities.assignActivity
Description: Set default result as null Account structure
Configuration:
- variableName = Schema0

Input bindings:

Mapping table
Target Source
/Account/Number ""
/Account/Name ""
/Account/Value 0
/Account/MonthIncrement 0
/Account/Password ""

Target	Source
/Account/Number	""
/Account/Name	""
/Account/Value	0
/Account/MonthIncrement	0
/Account/Password	""

Mapping tree


Account
 Number = ""
 Name = ""
 Value = 0
 MonthIncrement = 0
 Password = ""

Source code


            <pfx:Account xmlns:pfx="http://www.tibco.com/schemas/AccountState/SharedResources/Schema.xsd" xmlns:pd="http://xmlns.tibco.com/bw/process/2003" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ns="http://www.tibco.com/pe/DeployedVarsType" xmlns:ns1="http://www.tibco.com/namespaces/tnt/plugins/file" xmlns:ns2="http://www.tibco.com/namespaces/tnt/plugins/file/v2" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
                <pfx:Number>
                    <xsl:value-of select="&quot;&quot;"/>
                </pfx:Number>
                <pfx:Name>
                    <xsl:value-of select="&quot;&quot;"/>
                </pfx:Name>
                <pfx:Value>
                    <xsl:value-of select="0"/>
                </pfx:Value>
                <pfx:MonthIncrement>
                    <xsl:value-of select="0"/>
                </pfx:MonthIncrement>
                <pfx:Password>
                    <xsl:value-of select="&quot;&quot;"/>
                </pfx:Password>
            </pfx:Account>

Name: GetAccount

Type: com.tibco.plugin.jdbc.JDBCQueryActivity
Resource Type: ae.activities.JDBCQueryActivity
Description:
Configuration:
- timeout = 10
- commit = false
- maxRows = 100
- emptyStrAsNil = false
- jdbcSharedConfig = /SharedConnections/Tibco.sharedjdbc
- statement = SELECT ID, NAME, VALUE, MONTH_INCREMENT FROM ACCOUNTS WHERE ID = ?
- processInSubsets = true
- Prepared_Param_DataType
  - parameter
    - parameterName = id
    - dataType = INTEGER

Input bindings:

Mapping table
Target Source
/jdbcQueryActivityInput/subsetSize 1

Target	Source
/jdbcQueryActivityInput/subsetSize	1

Mapping tree


jdbcQueryActivityInput
 subsetSize = 1

Source code


                <jdbcQueryActivityInput xmlns:pd="http://xmlns.tibco.com/bw/process/2003" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ns="http://www.tibco.com/pe/DeployedVarsType" xmlns:pfx="http://www.tibco.com/schemas/AccountState/SharedResources/Schema.xsd" xmlns:ns1="http://www.tibco.com/namespaces/tnt/plugins/file" xmlns:ns2="http://www.tibco.com/namespaces/tnt/plugins/file/v2" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
                    <subsetSize>
                        <xsl:value-of select="1"/>
                    </subsetSize>
                </jdbcQueryActivityInput>

Name: ParseXML AccountsList

Type: com.tibco.plugin.xml.XMLParseActivity
Resource Type: ae.activities.XMLParseActivity
Description: Parse text input to xml according to Accounts xsd schema
Configuration:
- inputStyle = text
- xsdVersion = default
- validateOutput = true
- term
  - - AccountsList (XML Element Reference, required )

Input bindings:

Mapping table
Target Source
/xmlString $ReadFile-Accounts/ns1:ReadActivityOutputTextClass/fileContent/textContent

Target	Source
/xmlString	$ReadFile-Accounts/ns1:ReadActivityOutputTextClass/fileContent/textContent

Mapping tree


xmlString = $ReadFile-Accounts/ns1:ReadActivityOutputTextClass/fileContent/textContent

Source code


            <xmlString xmlns:pd="http://xmlns.tibco.com/bw/process/2003" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ns="http://www.tibco.com/pe/DeployedVarsType" xmlns:pfx="http://www.tibco.com/schemas/AccountState/SharedResources/Schema.xsd" xmlns:ns1="http://www.tibco.com/namespaces/tnt/plugins/file" xmlns:ns2="http://www.tibco.com/namespaces/tnt/plugins/file/v2" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
                <xsl:value-of select="$ReadFile-Accounts/ns1:ReadActivityOutputTextClass/fileContent/textContent"/>
            </xmlString>

Name: ReadFile Accounts

Type: com.tibco.plugin.file.FileReadActivity
Resource Type: ae.activities.FileReadActivity
Description: Read file as text
Configuration:
- encoding = text

Input bindings:

Mapping table
Target Source
/ReadActivityInputClass/fileName $_globalVariables/ns:GlobalVariables/DefaultAccountsFile

Target	Source
/ReadActivityInputClass/fileName	$_globalVariables/ns:GlobalVariables/DefaultAccountsFile

Mapping tree


ReadActivityInputClass
 fileName = $_globalVariables/ns:GlobalVariables/DefaultAccountsFile

Source code


            <ns2:ReadActivityInputClass xmlns:ns2="http://www.tibco.com/namespaces/tnt/plugins/file/v2" xmlns:pd="http://xmlns.tibco.com/bw/process/2003" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ns="http://www.tibco.com/pe/DeployedVarsType" xmlns:pfx="http://www.tibco.com/schemas/AccountState/SharedResources/Schema.xsd" xmlns:ns1="http://www.tibco.com/namespaces/tnt/plugins/file" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
                <fileName>
                    <xsl:value-of select="$_globalVariables/ns:GlobalVariables/DefaultAccountsFile"/>
                </fileName>
            </ns2:ReadActivityInputClass>

Name: UpdateCustomerDB

Type: com.tibco.plugin.jdbc.JDBCUpdateActivity
Resource Type: ae.activities.JDBCUpdateActivity
Description:
Configuration:
- timeout = 10
- commit = false
- emptyStrAsNil = false
- jdbcSharedConfig = /SharedConnections/SharedTibco.sharedjdbc
- statement = UPDATE CUSTOMER SET DATE = ? WHERE ID = ?
- Prepared_Param_DataType
  - parameter
    - parameterName = date_now
    - dataType = VARCHAR
  - parameter
    - parameterName = id
    - dataType = INTEGER

Input bindings:

Mapping table
Target Source
/jdbcUpdateActivityInput/date_now current-dateTime()
/jdbcUpdateActivityInput/id $Start/root/ID

Target	Source
/jdbcUpdateActivityInput/date_now	current-dateTime()
/jdbcUpdateActivityInput/id	$Start/root/ID

Mapping tree


jdbcUpdateActivityInput
 date_now = current-dateTime()
 id = $Start/root/ID

Source code


                <jdbcUpdateActivityInput xmlns:pd="http://xmlns.tibco.com/bw/process/2003" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ns="http://www.tibco.com/pe/DeployedVarsType" xmlns:pfx="http://www.tibco.com/schemas/AccountState/SharedResources/Schema.xsd" xmlns:ns1="http://www.tibco.com/namespaces/tnt/plugins/file" xmlns:ns2="http://www.tibco.com/namespaces/tnt/plugins/file/v2" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
                    <date_now>
                        <xsl:value-of select="current-dateTime()"/>
                    </date_now>
                    <id>
                        <xsl:value-of select="$Start/root/ID"/>
                    </id>
                </jdbcUpdateActivityInput>

Transitions:

From: Assign ActualAccount -To: UpdateCustomerDB
- Label:
- Condition: Success
- Description:

From: Assign NullAccount -To: CycleGroup
- Label:
- Condition: Success
- Description:

From: CycleGroup -To: End
- Label:
- Condition: Success
- Description:

From: GetAccount -To: Assign ActualAccount
- Label:
- Condition: Success
- Description:

From: ParseXML AccountsList -To: Assign NullAccount
- Label:
- Condition: Success
- Description:

From: ReadFile Accounts -To: ParseXML AccountsList
- Label:
- Condition: Success
- Description:

From: start -To: GetAccount
- Label:
- Condition: Success
- Description:

From: Start -To: ReadFile Accounts
- Label:
- Condition: Success
- Description:

From: UpdateCustomerDB -To: end
- Label:
- Condition: Success
- Description:

Groups:

Name: CycleGroup
- Type: com.tibco.pe.core.LoopGroup
- Resource Type: ae.process.group
- Configuration:
  - groupType = repeat
  - serializable = false
  - indexSlot = AccountIndex
  - activityOutputName =
  - repeatCondition = ($AccountIndex >= $ParseXML-AccountsList/pfx:AccountsList/@Count) or ($ParseXML-AccountsList/pfx:AccountsList/pfx:Account[$AccountIndex]/pfx:Name =$Start/pfx:Name)
  - accumulateOutput = false