første xml update

[virt-orchestrator.git] / vFLOWER / content / Workflows / uio / lib / log / info.workflow.xml

<?xml version="1.0" encoding="UTF-8"?>
<workflow xmlns="http://vmware.com/vco/workflow" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://vmware.com/vco/workflow http://vmware.com/vco/workflow/Workflow-v4.xsd" root-name="item3" object-name="workflow:name=generic" id="25832524-da3e-407e-a64a-d4418bcb3174" version="1.0.3" api-version="3.1.0" allowed-operations="fve" icon-id="93015d83-b1ba-42d0-9b3c-bb3ebb862beb" restartMode="1" resumeFromFailedMode="0">
    <display-name>info</display-name>

    <description>Logger hendelser som skjer til databasen. Også mulig å logge til email dersom variablen enable_mail settes til true</description>

    <position x="100.0" y="50.0"/>

    <input>
        <param name="message" type="string"/>
    </input>

    <attrib name="query" type="string" read-only="false">
        <value encoded="n"/>
        <description>sql error query</description>
    </attrib>
    <attrib name="rowsAffected" type="number" read-only="false">
        <value encoded="n">__NULL__</value>
        <description>The number of rows affected by the query</description>
    </attrib>
    <attrib name="mailto" type="string" read-only="false">
        <value encoded="n">__NULL__</value>
        <description>Default mailto parameter</description>
    </attrib>
    <attrib name="smtp_server" type="string" read-only="false">
        <value encoded="n">__NULL__</value>
        <description>Default SMTP server</description>
    </attrib>
    <attrib name="smtp_port" type="string" read-only="false">
        <value encoded="n">__NULL__</value>
        <description>Default SMTP port</description>
    </attrib>
    <attrib name="database" type="SQL:Database" read-only="false">
        <value encoded="n">__NULL__</value>
        <description>Default database</description>
    </attrib>
    <attrib name="state" type="string" read-only="false">
        <value encoded="n">INFO</value>
        <description>Log state</description>
    </attrib>
    <attrib name="enable_mail" type="string" read-only="false">
        <value encoded="n">false</value>
        <description>If true, send email for all events</description>
    </attrib>
    <attrib name="vmPassword" type="SecureString" read-only="false">
        <value encoded="n"/>
    </attrib>

    <workflow-item name="item0" type="end" end-mode="0">
        <position x="684.5" y="99.95454545454544"/>
    </workflow-item>

    <workflow-item name="item1" out-name="item0" type="link" linked-workflow-id="028080808080808080808080808080809F808080013264596926189e8150e1493">
        <display-name>Execute a custom query on a database</display-name>

        <in-binding>
            <bind name="database" type="SQL:Database" export-name="database">
                <description>The database to use for the query</description>
            </bind>
            <bind name="query" type="string" export-name="query">
                <description>The query to execute</description>
            </bind>
        </in-binding>

        <out-binding>
            <bind name="rowsAffected" type="number" export-name="rowsAffected">
                <description>The number of rows affected by the query</description>
            </bind>
        </out-binding>

        <description>Executes a custom query on a specified database and returns the number of affected rows. You can run the workflow to update, delete, and insert queries.</description>

        <position x="504.5" y="55.40909090909091"/>
    </workflow-item>

    <workflow-item name="item2" out-name="item4" type="task">
        <display-name>Generate SQL error string</display-name>

        <script encoded="false">
//get name of the current workflow
var wname = workflow.rootWorkflow.name;

// System.debug("Root Workflow "+WorkFlow);


//var date = System.getDateFromFormat(Date);

var currentdate = new Date();
var date = System.formatDate(currentdate, 'yyyy-MM-dd HH:mm:ss');

// Get current user 
try {
	var user = Server.getCredential().username;
}
catch(err) {
	// Not able to get user, setting vCAC
	user = 'vCAC';
}

var dbmesg = message.replace(/[`'']/g,'"');
var wname = wname.replace(/[`'']/g,'"');
query="insert into log "
	+"(log_source, log_date, log_level, log_line, log_category, log_mesg)"
	+" values "
	+"('"+user+"@Orchestrator', '"+date+"', '"+state+"', 0, '"+wname+"', '" + dbmesg + "');";

if (enable_mail == "true") {
	var mail = new EmailMessage() ;
	mail.fromAddress='virtprov@usit.uio.no';
	mail.toAddress=mailto;
	mail.subject=state+" from "+user+"@Orchestrator/"+wname+"";
	mail.smtpPort=smtp_port;
	mail.smtpHost=smtp_server;


	var body=state+" message from Vmware Orchestrator\n"
		+"User "+user+" has run a workflow which generated "+state+"\n"
		+"\n"
		+state+" message: \n"
		+message+"";

	mail.addMimePart(body)
	mail.sendMessage();
}
        </script>

        <in-binding>
            <bind name="enable_mail" type="string" export-name="enable_mail">
                <description>If true, send email for all events</description>
            </bind>
            <bind name="mailto" type="string" export-name="mailto">
                <description>Default mailto parameter</description>
            </bind>
            <bind name="message" type="string" export-name="message"/>
            <bind name="smtp_port" type="string" export-name="smtp_port">
                <description>Default SMTP port</description>
            </bind>
            <bind name="smtp_server" type="string" export-name="smtp_server">
                <description>Default SMTP server</description>
            </bind>
            <bind name="state" type="string" export-name="state">
                <description>Log state</description>
            </bind>
        </in-binding>

        <out-binding>
            <bind name="query" type="string" export-name="query">
                <description>The query to execute</description>
            </bind>
        </out-binding>

        <position x="364.5" y="55.40909090909091"/>
    </workflow-item>

    <workflow-item name="item3" out-name="item2" type="link" linked-workflow-id="1f0fc470-006c-4c15-a3b9-95e2e7540f22">
        <display-name>global_parameters</display-name>

        <in-binding/>

        <out-binding>
            <bind name="mailto" type="string" export-name="mailto"/>
            <bind name="smtp_server" type="string" export-name="smtp_server"/>
            <bind name="smtp_port" type="string" export-name="smtp_port"/>
            <bind name="database" type="SQL:Database" export-name="database"/>
            <bind name="vmPassword" type="SecureString" export-name="vmPassword"/>
        </out-binding>

        <position x="204.5" y="55.40909090909091"/>
    </workflow-item>

    <workflow-item name="item4" out-name="item1" type="condition" alt-out-name="item0" comparator="0">
        <display-name>Decision</display-name>

        <script encoded="false">
//Generated by the system, cannot be edited
return (database  != null ) ;
        </script>

        <in-binding>
            <bind name="database" type="SQL:Database" export-name="database"/>
        </in-binding>
        <condition name="database" type="SQL:Database" comparator="0" label="null"/>

        <position x="445.0" y="99.95454545454544"/>
    </workflow-item>

    <presentation>
        <p-param name="message">
            <desc>message</desc>
        </p-param>
    </presentation>
</workflow>