//
function trim(s)
{
    var len = s.length;
    if (len == 0)
        return s;
        
    var idxLeft = 0, idxRight = len - 1;
    
    // trim left
    var i = idxLeft;
    while (i < len)
    {
        var ch = s.charAt(i);
        if (ch != " " && ch != "\t")
            break;
        i++;
    }
    if (i < len)
        idxLeft = i;
    
    // trim right
    i = idxRight;
    while (i > idxLeft)
    {
        var ch = s.charAt(i);
        if (ch != " " && ch != "\t")
            break;
        --i;
    }
    if (i > idxLeft)
        idxRight = i;

    return s.substring(idxLeft, idxRight+1);
}

// map of digital asset id
function IDMap(oldId, newId)
{
    this.oldId = oldId;
    this.newId = newId;
}
//updated DLP policy
function PolicyMap(PolicyId, newValue)
{
    this.PolicyId = PolicyId;
    this.newValue = newValue;  //new template list value
}

function wrongParam()
{
    WScript.StdErr.WriteLine("Usage: CScript //E:JavaScript dbUpgradeDLPTemplate.js working-directory data-source db-name auth-mode user-name password computer-name");
    var strParameterNumberWarn = "Current parameter number is "+WScript.Arguments.length;
    WScript.StdErr.WriteLine(strParameterNumberWarn);
    WScript.Quit(1);
}

if(WScript.Arguments.length!=8)
{
    wrongParam();
}

var fso = new ActiveXObject("Scripting.FileSystemObject");
var instalDir = WScript.Arguments(0);
var dataSource = WScript.Arguments(1);
var dbName = WScript.Arguments(2);
var authMode = WScript.Arguments(3);
var userName = WScript.Arguments(4);
var userPW = WScript.Arguments(5);
var computerName=WScript.Arguments(6);
var operation   = WScript.Arguments.length > 7 ? WScript.Arguments(7) : "create";

var sWorkingDirectory = instalDir+"\\config";
var DLPBackupXml = "DlpDataBackup.xml";
var DLPKeywordBackupXml = "DlpKeywordBackup.xml";
var DLPExpressBackupXml = "DlpExpressionBackup.xml";

WScript.StdOut.WriteLine("");
WScript.StdOut.WriteLine("--------------------------log started------------------------------");
var currentDate = new Date();
WScript.StdOut.WriteLine(currentDate);
WScript.StdOut.WriteLine("");


if (fso.FolderExists(sWorkingDirectory))
{
    try
    {
        var connectStr="";  
        if(authMode=="1")
        {
            connectStr="Provider=SQLNCLI11;Application Name=PortalProtect;Integrated Security=SSPI;Persist Security Info=False;Data Source="+dataSource+";Initial Catalog="+dbName+";";
            WScript.StdOut.WriteLine(connectStr);
        }
        else
        {
            connectStr="Provider=SQLNCLI11;Application Name=PortalProtect;Data Source="+dataSource+";Initial Catalog="+dbName+";Persist Security Info=True;User ID="+userName+";Password=";
            WScript.StdOut.WriteLine(connectStr);
            connectStr=connectStr+userPW+";";
        }
        var dbProfile = new DatabaseProfile(instalDir,connectStr);
        if (operation == "create")
            dbProfile.ImportDLPData();
        else if(operation == "rollback")
            dbProfile.RollbackDatabase();
    }
    catch(e)
    {
        WScript.StdErr.WriteLine("catch exception in the outest catch");
        WScript.StdErr.WriteLine(e.message + " (" +  e.number + ") ");
        WScript.Quit(e.number);
    }
}
else
{
    wrongParam();
}


function DatabaseProfile(instalDir,connectStr)
{
    var log = new Log(true);
    this.HomeDir = instalDir;
    this.Type = "SQLSVR";
    this.XmlType = "Conf_xml";

    var xProfile = XDoc();   
    filename =  sWorkingDirectory + "\\" + "dbconf_Conf.xml";
    xProfile.load(filename);
    
    strConnectforOperate = "Provider=SQLNCLI11;Connect Timeout=60;\
    Integrated Security=SSPI;Persist Security Info=FALSE;\
    Initial Catalog=&DATABASE_NAME;Data Source=&DATABASE_HOST;\
    User ID=&SQL_USERID;Password=";
    strConnectforOperate = strConnectforOperate.replace(/\&DATABASE_NAME/g, dbName);
    strConnectforOperate = strConnectforOperate.replace(/\&DATABASE_HOST/g, dataSource);
    strConnectforOperate = strConnectforOperate.replace(/\&SQL_USERID/g, userName);
    WScript.Echo("ConnectStringForOperate:" + strConnectforOperate);

    this.ConnectStringForOperate = strConnectforOperate + userPW;
    WScript.Echo("product_home_dir:" + this.HomeDir);
    
    ///////////////////////////////////////////////////////////////////////////////////////////////
    this.ImportDLPData = function()
    {
        var conn = new ActiveXObject("ADODB.Connection");
        conn.Open(connectStr);
        
        function SqlScriptIterator(sqlInstallScript, bHaltOnError)
        {
            try
            {
                sqlInstallScript=sqlInstallScript.replace(/\n/g,"\r\n");
                conn.Execute(sqlInstallScript);
                log.Write(sqlInstallScript);
            }
            catch(e)
            {
                if (bHaltOnError)
                {
                    throw e;
                }
                else
                {
                    WScript.Echo("catch exception in SqlScriptIterator");
                    log.Write(sqlInstallScript);
                    log.Write("Expected error: ", e.message, " (", e.number, ") ");
                }

            }
            return true;
        }
        
        var comp = XDoc();
        WScript.Echo("Is config db, importing dlp data...");
        var xml_path = sWorkingDirectory + "\\Compliance_Template.xml";
        WScript.Echo("loading " + xml_path + " ...");
        var loaded = comp.load(xml_path);
        
        if (loaded)
        {
            WScript.Echo("load success");
            this.GetDLPKeywordInstallScripts(comp, SqlScriptIterator,conn);
            this.GetDLPExpressionInstallScripts(comp, SqlScriptIterator,conn);
            this.GetDLPTemplateInstallScripts(comp, SqlScriptIterator, conn);
        }
        else
            WScript.Echo("load failed");
    }
    
    this.GetDLPKeywordInstallScripts = function(dom, visitor,cn)
    {
        WScript.Echo("Enter GetDLPKeywordInstallScripts");
	    // backup dlp keyword to xml file
		if (cn != null)
		{
			// backup templates
			var dom_temp = XDoc();
			dom_temp.loadXML("<dlp><keywords/><keywordMgr/></dlp>");
			var keywordsNode = dom_temp.selectSingleNode("/dlp/keywords");
			
			var sql = "SELECT CFG_INDEX,CFG_DEFAULT_INSTANCE,DLP_KEYWORD_NAME,DLP_KEYWORD_INTERNALNAME," +
				"DLP_KEYWORD_DESC,DLP_KEYWORD_CONDITION,DLP_KEYWORD_THRESHOLD,DLP_KEYWORD_NUMBER,"+
				"DLP_KEYWORD_MODIFIED,DLP_KEYWORD_BUILTIN,DLP_SUBKEYWORD_LIST FROM TM_DLPFilterKeyword"+computerName+" WHERE " +
				"CFG_INDEX<>'SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_KEYWORD_DEFAULT'";
			var rs = cn.Execute(sql);
			while (!rs.EOF)
			{
				var keyword = dom_temp.createElement("keyword");
				keyword.setAttribute("cfg_index", rs(0).Value);
				keyword.setAttribute("def_instance", rs(1).Value);
				keyword.setAttribute("name", rs(2).Value);
				keyword.setAttribute("internalname", rs(3).Value);
				keyword.setAttribute("description", rs(4).Value);
				keyword.setAttribute("condition", rs(5).Value);
				keyword.setAttribute("threshold", rs(6).Value);
				keyword.setAttribute("number", rs(7).Value);
				keyword.setAttribute("modify", rs(8).Value);
				keyword.setAttribute("builtin", rs(9).Value);
				keyword.text = rs(10).Value;
				keywordsNode.appendChild(keyword);
				
				rs.MoveNext();
			}
			rs.Close();
			
			// backup mgr table
			var mgrNode = dom_temp.selectSingleNode("/dlp/keywordMgr");
			sql = "SELECT CFG_INDEX,CFG_DLP_KEYWORD_LIST_CFGSETTING_MV FROM TM_DLPFilterKeywordMgr"+computerName;
			rs = cn.Execute(sql);
			while (!rs.EOF)
			{
				var mgr = dom_temp.createElement("mgr");
				mgr.setAttribute("cfg_index", rs(0).Value);
				mgr.text = rs(1).Value;
				mgrNode.appendChild(mgr);
				
				rs.MoveNext();
			}
			rs.Close();
			dom_temp.save(sWorkingDirectory + "\\" + DLPKeywordBackupXml);
		}
	    // delete built-in keywords
		var sql = "DELETE FROM TM_DLPFilterKeyword"+computerName+" WHERE DLP_KEYWORD_BUILTIN=" + ((this.Type == "SQLSVR") ? "1" : "True");
		visitor(sql, true);		
		var allUsrCfgIndexes = "";
		var allDefCfgIndexes = "";
		//get customize keyword index	
		if (cn != null)
		{
			var indexPrefix = "SMEX_PLC_NULL:";
			var rs = cn.Execute("SELECT CFG_INDEX FROM TM_DLPFilterKeyword"+computerName+" where CFG_INDEX!='SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_KEYWORD_DEFAULT'");
	        
	        while (!rs.EOF)
	        {
	        	var cfgIndex = rs(0).Value;
	            allUsrCfgIndexes += "TM_DLPFilterKeyword:" + cfgIndex.substr(indexPrefix.length) + ":";  
		        rs.MoveNext();
	        }
			rs.Close();
		}
		
    	var keywords = dom.selectNodes("/SAPolicy/digitalAssets/dictionary");
		var uniPref = (this.Type == "SQLSVR") ? "N" : "";
		
		for (var i=0; i<keywords.length; ++i)
		{
			var internalName = keywords[i].attributes.getNamedItem("name").text;
			var cfgIndex = "SMEX_SUB_CFG_DLP_KEYWORD" + internalName;
			allDefCfgIndexes += "TM_DLPFilterKeyword:" + cfgIndex + ":";
			var displayName = keywords[i].attributes.getNamedItem("display_name").text.replace(/'/g, "''");
			var desc = keywords[i].attributes.getNamedItem("description").text.replace(/'/g, "''");
			var condition = keywords[i].attributes.getNamedItem("type").text;
			var thresholdNode = keywords[i].attributes.getNamedItem("threshold");
			var threshold = thresholdNode == null ? 0 : thresholdNode.text;
			var numberNode = keywords[i].attributes.getNamedItem("number");
			var number = numberNode == null ? 0 : numberNode.text;
			var builtin = keywords[i].attributes.getNamedItem("pre-defined").text;
			if (this.Type == "SQLSVR")
				builtin = (builtin == "true") ? 1 : 0;
			else
				builtin = (builtin == "true") ? "True" : "False";
			var subKeywordsXml = keywords[i].xml.replace(/'/g, "''");

		
			if (!visitor("INSERT INTO TM_DLPFilterKeyword"+computerName+" (CFG_INDEX, CFG_DEFAULT_INSTANCE, DLP_KEYWORD_NAME, " +
				"DLP_KEYWORD_INTERNALNAME, DLP_KEYWORD_DESC, DLP_KEYWORD_CONDITION, DLP_KEYWORD_THRESHOLD, " +
				"DLP_KEYWORD_NUMBER, DLP_KEYWORD_BUILTIN, DLP_SUBKEYWORD_LIST) VALUES ('SMEX_PLC_NULL:" + 
				cfgIndex + "', 'SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_KEYWORD_DEFAULT', " + uniPref + "'" + displayName + "', " +
				uniPref + "'" + internalName + "', " + uniPref + "'" + desc + "', '" + condition + "', " + 
				threshold + ", " + number + ", " + builtin + ", " + uniPref + "'" + subKeywordsXml + "')", true))
				break;
			
		}
		var allCfgIndexes = allDefCfgIndexes+allUsrCfgIndexes;
		visitor("UPDATE TM_DLPFilterKeywordMgr"+computerName+" SET CFG_DLP_KEYWORD_LIST_CFGSETTING_MV='" + allDefCfgIndexes + 
			"' WHERE CFG_INDEX='SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_KEYWORD_MGR_DEFAULT'", true);
		visitor("UPDATE TM_DLPFilterKeywordMgr"+computerName+" SET CFG_DLP_KEYWORD_LIST_CFGSETTING_MV='" + allCfgIndexes + 
		    "' WHERE CFG_INDEX='SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_KEYWORD_MGR'", true);
		WScript.Echo("Leave GetDLPKeywordInstallScripts");
	}

	this.GetDLPExpressionInstallScripts = function(dom, visitor,cn)
	{
        WScript.Echo("Enter GetDLPExpressionInstallScripts");
	    // backup dlp data to xml file
		if (cn != null)
		{
			// backup expressions
			var dom_temp = XDoc();
			dom_temp.loadXML("<dlp><expressions/><expressionMgr/></dlp>");
			var expressionsNode = dom_temp.selectSingleNode("/dlp/expressions");
			
			var sql = "SELECT CFG_INDEX,CFG_DEFAULT_INSTANCE,DLP_EXPRESSION_NAME,DLP_EXPRESSION_INTERNALNAME," +
				"DLP_EXPRESSION_DESC,DLP_EXPRESSION_TYPE,DLP_EXPRESSION_MINLENGTH,DLP_EXPRESSION_MAXLENGTH,"+
				"DLP_EXPRESSION_MINLEFTRADIUS,DLP_EXPRESSION_MAXLEFTRADIUS,DLP_EXPRESSION_MAXRIGHTRADIUS,"+
				"DLP_EXPRESSION_SUFFIXLENGTH,DLP_EXPRESSION_ALPHABETCHARSET,DLP_EXPRESSION_CASESENSITIVE,"+
				"DLP_EXPRESSION_DISPLAYFORMAT,DLP_EXPRESSION_EXAMPLE,DLP_EXPRESSION_VALIDATOR,"+
				"DLP_EXPRESSION_MODIFIED,DLP_EXPRESSION_BUILTIN,DLP_EXPRESSION_PATTERN FROM TM_DLPFilterExpression"+computerName+" WHERE " +
				"CFG_INDEX<>'SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_EXPRESSION_DEFAULT'";
			var rs = cn.Execute(sql);
			while (!rs.EOF)
			{
				var expression = dom_temp.createElement("expression");
				expression.setAttribute("cfg_index", rs(0).Value);
				expression.setAttribute("def_instance", rs(1).Value);
				expression.setAttribute("name", rs(2).Value);
				expression.setAttribute("internalname", rs(3).Value);
				expression.setAttribute("description", rs(4).Value);
				expression.setAttribute("type", rs(5).Value);
				expression.setAttribute("minlength", rs(6).Value);
				expression.setAttribute("maxlength", rs(7).Value);
				expression.setAttribute("minleftradius", rs(8).Value);
				expression.setAttribute("maxleftradius", rs(9).Value);
				expression.setAttribute("maxrightradius", rs(10).Value);
				expression.setAttribute("suffixlength", rs(11).Value);
				expression.setAttribute("alphcharset", rs(12).Value);
				expression.setAttribute("casesensitive", rs(13).Value);
				expression.setAttribute("displayformat", rs(14).Value);
				expression.setAttribute("examp", rs(15).Value);
				expression.setAttribute("validator", rs(16).Value);
				expression.setAttribute("modify", rs(17).Value);
				expression.setAttribute("builtin", rs(18).Value);
				expression.text = rs(19).Value;
				expressionsNode.appendChild(expression);
				
				rs.MoveNext();
			}
			rs.Close();
			
			// backup mgr table
			var mgrNode = dom_temp.selectSingleNode("/dlp/expressionMgr");
			sql = "SELECT CFG_INDEX,CFG_DLP_EXPRESSION_LIST_CFGSETTING_MV FROM TM_DLPFilterExpressionMgr"+computerName;
			rs = cn.Execute(sql);
			while (!rs.EOF)
			{
				var mgr = dom_temp.createElement("mgr");
				mgr.setAttribute("cfg_index", rs(0).Value);
				mgr.text = rs(1).Value;
				mgrNode.appendChild(mgr);
				
				rs.MoveNext();
			}
			rs.Close();
			
			dom_temp.save(sWorkingDirectory + "\\" + DLPExpressBackupXml);
		}
		// delete built-in expressions
		var sql = "DELETE FROM TM_DLPFilterExpression"+computerName+" WHERE DLP_EXPRESSION_BUILTIN=" + ((this.Type == "SQLSVR") ? "1" : "True");
		visitor(sql, true);
		
		var allUsrCfgIndexes = "";
		var allDefCfgIndexes = "";
		//get customize expression index	
		if (cn != null)
		{
			var indexPrefix = "SMEX_PLC_NULL:";
			var rs = cn.Execute("SELECT CFG_INDEX FROM TM_DLPFilterExpression"+computerName+" where CFG_INDEX!='SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_EXPRESSION_DEFAULT'");
	        
	        while (!rs.EOF)
	        {
	        	var cfgIndex = rs(0).Value;
	            allUsrCfgIndexes += "TM_DLPFilterExpression:" + cfgIndex.substr(indexPrefix.length) + ":";  
		        rs.MoveNext();
	        }
			rs.Close();
		}
		
		var exps = dom.selectNodes("/SAPolicy/digitalAssets/entity");
		var uniPref = (this.Type == "SQLSVR") ? "N" : "";
		
		for (var i=0; i<exps.length; ++i)
		{
			var internalName = exps[i].attributes.getNamedItem("name").text;
			var cfgIndex = "SMEX_SUB_CFG_DLP_EXPRESSION" + internalName;
			var displayName = exps[i].attributes.getNamedItem("display_name").text.replace(/'/g, "''");
			var desc = exps[i].attributes.getNamedItem("description").text.replace(/'/g, "''");
			var type = exps[i].attributes.getNamedItem("type").text;
			var minLenNode = exps[i].attributes.getNamedItem("minLength");
			var minLen = minLenNode == null ? 0 : minLenNode.text;
			var maxLenNode = exps[i].attributes.getNamedItem("maxLength");
			var maxLen = maxLenNode == null ? 0 : maxLenNode.text;
			var minLeftRadiusNode = exps[i].attributes.getNamedItem("minLeftRadius");
			var minLeftRadius = minLeftRadiusNode == null ? 0 : minLeftRadiusNode.text;
			var maxLeftRadiusNode = exps[i].attributes.getNamedItem("maxLeftRadius");
			var maxLeftRadius = maxLeftRadiusNode == null ? 0 : maxLeftRadiusNode.text;
			var maxRightRadiusNode = exps[i].attributes.getNamedItem("maxRightRadius");
			var maxRightRadius = maxRightRadiusNode == null ? 0 : maxRightRadiusNode.text;
			var suffixLengthNode = exps[i].attributes.getNamedItem("suffixLength");
			var suffixLength = suffixLengthNode == null ? 0 : suffixLengthNode.text;
			var exp = exps[i].selectSingleNode("./regularExpression").text.replace(/'/g, "''");
			var alphaCharsetNode = exps[i].selectSingleNode("./alphabetCharset");
			var alphaCharset = alphaCharsetNode == null ? "" : alphaCharsetNode.text.replace(/'/g, "''");
			var caseSens = exps[i].attributes.getNamedItem("caseSensitive").text;
			if (this.Type == "SQLSVR")
				caseSens = (caseSens == "true") ? 1 : 0;
			else
				caseSens = (caseSens == "true") ? "True" : "False";
			var dispFormat = exps[i].selectSingleNode("./patternForDisplay").text.replace(/'/g, "''");
			var example = exps[i].selectSingleNode("./examples").text.replace(/'/g, "''");
			var vldr = exps[i].attributes.getNamedItem("validator").text.replace(/'/g, "''");
			var builtin = exps[i].attributes.getNamedItem("pre-defined").text;
			if (this.Type == "SQLSVR")
				builtin = (builtin == "true") ? 1 : 0;
			else
				builtin = (builtin == "true") ? "True" : "False";
			
			if (!visitor("INSERT INTO TM_DLPFilterExpression"+computerName+" (CFG_INDEX, CFG_DEFAULT_INSTANCE, DLP_EXPRESSION_NAME, " +
				"DLP_EXPRESSION_INTERNALNAME, DLP_EXPRESSION_DESC, DLP_EXPRESSION_TYPE, DLP_EXPRESSION_MINLENGTH, " +
				"DLP_EXPRESSION_MAXLENGTH, DLP_EXPRESSION_MINLEFTRADIUS, DLP_EXPRESSION_MAXLEFTRADIUS, " +
				"DLP_EXPRESSION_MAXRIGHTRADIUS, DLP_EXPRESSION_SUFFIXLENGTH, DLP_EXPRESSION_PATTERN, " +
				"DLP_EXPRESSION_ALPHABETCHARSET, DLP_EXPRESSION_CASESENSITIVE, DLP_EXPRESSION_DISPLAYFORMAT, " +
				"DLP_EXPRESSION_EXAMPLE, DLP_EXPRESSION_VALIDATOR, DLP_EXPRESSION_BUILTIN) VALUES ('SMEX_PLC_NULL:" + cfgIndex + 
				"', 'SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_EXPRESSION_DEFAULT', " + uniPref + "'" + displayName + "', '" +
				internalName + "', " + uniPref + "'" + desc + "', '" + type + "', " + minLen + ", " + maxLen + ", " + 
				minLeftRadius + ", " + maxLeftRadius + ", " + maxRightRadius + ", " + suffixLength + ", " + uniPref + 
				"'" + exp + "', '" + alphaCharset + "', " + caseSens + ", '" + dispFormat + "', '" + example + "', '" +
				vldr + "', " + builtin + ")", true))
				break;
			
			allDefCfgIndexes += "TM_DLPFilterExpression:" + cfgIndex + ":";
		}
		
		var allCfgIndexes = allDefCfgIndexes+allUsrCfgIndexes;
		visitor("UPDATE TM_DLPFilterExpressionMgr"+computerName+" SET CFG_DLP_EXPRESSION_LIST_CFGSETTING_MV='" + allDefCfgIndexes + 
			"' WHERE CFG_INDEX='SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_EXPRESSION_MGR_DEFAULT'", true);
		visitor("UPDATE TM_DLPFilterExpressionMgr"+computerName+" SET CFG_DLP_EXPRESSION_LIST_CFGSETTING_MV='" + allCfgIndexes + 
		    "' WHERE CFG_INDEX='SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_EXPRESSION_MGR'", true);
        WScript.Echo("Leave GetDLPExpressionInstallScripts");
	}
    this.GetDLPTemplateInstallScripts = function(dom, visitor, cn)
    {
        WScript.Echo("Enter GetDLPTemplateInstallScripts");
        
        var uniPref = "N";
        
        // backup dlp data to xml file
        if (cn != null)
        {
            // backup templates
            var dom_temp = XDoc();
            dom_temp.loadXML("<dlp><templates/><templateMgr/></dlp>");
            var templatesNode = dom_temp.selectSingleNode("/dlp/templates");
            
            var sql = "SELECT CFG_INDEX,CFG_DEFAULT_INSTANCE,DLP_TEMPLATE_NAME,DLP_TEMPLATE_DESCRIPTION," +
                "DLP_TEMPLATE_BUILTIN,DLP_TEMPLATE_ELEMENT FROM TM_DLPFilterTemplate"+computerName+" WHERE " +
                "CFG_INDEX<>'SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_TEMPLATE_DEFAULT'";
            var rs = cn.Execute(sql);
            while (!rs.EOF)
            {
                var tmpl = dom_temp.createElement("template");
                tmpl.setAttribute("cfg_index", rs(0).Value);
                tmpl.setAttribute("def_instance", rs(1).Value);
                tmpl.setAttribute("name", rs(2).Value);
                tmpl.setAttribute("description", rs(3).Value);
                tmpl.setAttribute("builtin", rs(4).Value);
                tmpl.text = rs(5).Value;
                templatesNode.appendChild(tmpl);
                
                rs.MoveNext();
            }
            rs.Close();
            
            // backup mgr table
            var mgrNode = dom_temp.selectSingleNode("/dlp/templateMgr");
            sql = "SELECT CFG_INDEX,DLP_TEMPLATE_LIST_CFGSETTING_MV FROM TM_DLPTemplateManagement"+computerName;
            rs = cn.Execute(sql);
            while (!rs.EOF)
            {
                var mgr = dom_temp.createElement("mgr");
                mgr.setAttribute("cfg_index", rs(0).Value);
                mgr.text = rs(1).Value;
                mgrNode.appendChild(mgr);
                
                rs.MoveNext();
            }
            rs.Close();
            
            dom_temp.save(sWorkingDirectory + "\\" + DLPBackupXml);
        }
        
        // delete built-in templates
        var sql = "DELETE FROM TM_DLPFilterTemplate"+computerName+" WHERE DLP_TEMPLATE_BUILTIN=" + "1" ;
        visitor(sql, true);
        
        var allUsrCfgIndexes = "";
        var allDefCfgIndexes = "";
        var arrSql = new Array();
        
        if (cn != null)
        {
            var indexPrefix = "SMEX_PLC_NULL:";
            // update the xml content of user created templates
            // and record their cfg_index
            var daMap = this.GetDigitalAssetMap();
            var rs = cn.Execute("SELECT CFG_INDEX,DLP_TEMPLATE_ELEMENT FROM TM_DLPFilterTemplate"+computerName);
            
            while (!rs.EOF)
            {
                var cfgIndex = rs(0).Value;
                var content = rs(1).Value;
                if (content.length > 0)
                {
                    for (var i=0; i<daMap.length; ++i)
                    {
                        var repExp = "sourceName=\"" + daMap[i].oldId + "\"";
                        repExp = repExp.replace(/\x2B/g, "\\+");
                        repExp = repExp.replace(/\x28/g, "\\(");
                        repExp = repExp.replace(/\x29/g, "\\)");
                        var newExp = "sourceName=\"" + daMap[i].newId + "\"";
                        var re = new RegExp(repExp, "g");
                        content = content.replace(re, newExp);
                    }
                    
                    var sql = "UPDATE TM_DLPFilterTemplate"+computerName+" SET DLP_TEMPLATE_ELEMENT=" + uniPref + "'" +
                        content + "' WHERE CFG_INDEX='" + cfgIndex + "'";
                    arrSql.push(sql);
                
                    allUsrCfgIndexes += "TM_DLPFilterTemplate:" + cfgIndex.substr(indexPrefix.length) + ":";
                }
                
                rs.MoveNext();
            }
            rs.Close();
            
            for (var i=0; i<arrSql.length; ++i)
                visitor(arrSql[i]);
                
            arrSql.length = 0;
        }
        
        // insert new built-in templates from xml
        var tmpls = dom.selectNodes("/SAPolicy/complianceTemplates/template");
        for (var i=0; i<tmpls.length; ++i)
        {
            var internalName = tmpls[i].attributes.getNamedItem("name").text;
            if (internalName == "00000000-0000-0000-0004-000000000219")
                continue;
            var cfgIndex = "SMEX_SUB_CFG_DLP_TEMPLATE" + internalName;
            var displayName = tmpls[i].attributes.getNamedItem("display_name").text.replace(/'/g, "''");
            var builtin = tmpls[i].attributes.getNamedItem("pre-defined").text;
            builtin = (builtin == "true") ? 1 : 0;
            var desc = tmpls[i].attributes.getNamedItem("description").text.replace(/'/g, "''");
            var content = tmpls[i].xml.replace(/'/g, "''");
            
            var industry = "";
            var collIndustry = dom.selectNodes("/SAPolicy/industries/industry[.//template_id='" + internalName + "']/@name");
            for (var j=0; j<collIndustry.length; ++j) 
            { 
                industry += collIndustry[j].text.replace(/'/g, "''")+";"; 
            }
            
            var region = "";
            var collRegion = dom.selectNodes("/SAPolicy/regions/region[.//template_id='" + internalName+ "']/@name");
            for (var k=0; k<collRegion.length; ++k) 
            { 
                region += collRegion[k].text.replace(/'/g, "''")+";"; 
            }
            
            if (!visitor("INSERT INTO TM_DLPFilterTemplate"+computerName+" (CFG_INDEX, DLP_TEMPLATE_NAME, DLP_TEMPLATE_BUILTIN, " +
                "DLP_TEMPLATE_DESCRIPTION, DLP_TEMPLATE_ELEMENT, DLP_TEMPLATE_INDUSTRY, DLP_TEMPLATE_REGION) VALUES ('SMEX_PLC_NULL:" + 
                cfgIndex + "', " + uniPref + "'" + displayName + "', " + builtin + ", " + uniPref + "'" + desc + "', '" + 
                content + "', '"+ industry + "', '"+ region + "')", true))
                return;
            
            allDefCfgIndexes += "TM_DLPFilterTemplate:" + cfgIndex + ":";
        }
        
        visitor("UPDATE TM_DLPTemplateManagement"+computerName+" SET DLP_TEMPLATE_LIST_CFGSETTING_MV='" + allDefCfgIndexes + 
            "' WHERE CFG_INDEX='SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_TEMPLATE_MANAGEMENT_DEFAULT'", true);
        visitor("UPDATE TM_DLPTemplateManagement"+computerName+" SET DLP_TEMPLATE_LIST_CFGSETTING_MV='" + allDefCfgIndexes + 
            allUsrCfgIndexes + "' WHERE CFG_INDEX='SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_TEMPLATE_MANAGEMENT'", true);
        
        if (cn != null)
        {
            // update built-in template id in policy table
            var tmplId = this.GetDLPTemplateIdMap();
            var nameMap = this.GetDLPRuleNameMap();
            rs = cn.Execute("SELECT CFG_INDEX,DLP_TEMPLATE_LIST_CFGSETTING_REF,DLP_RULE_NAME FROM TM_DLPFilterRule"+computerName);
            while (!rs.EOF)
            {
                var cfgIndex = rs(0).Value;
                var slist = rs(1).Value;
                if (slist.length > 0)
                {
                    for (var i=0; i<tmplId.length; ++i)
                    {
                        var re = new RegExp(tmplId[i].oldId, "");
                        slist = slist.replace(re, tmplId[i].newId);
                    }
                }
                var ruleName = rs(2).Value;
                if (ruleName.length > 0)
                {
                    for (var i=0; i<nameMap.length; ++i)
                    {
                        ruleName = ruleName.replace(nameMap[i].oldId, nameMap[i].newId);
                    }
                }
                
                arrSql.push("UPDATE TM_DLPFilterRule"+computerName+" SET DLP_TEMPLATE_LIST_CFGSETTING_REF='" + slist + "', DLP_RULE_NAME ='" + ruleName + "' WHERE CFG_INDEX='" + cfgIndex + "'");
                rs.MoveNext();
            }
            rs.Close();
            
            for (var i=0; i<arrSql.length; ++i)
                visitor(arrSql[i]);
        }
        
        WScript.Echo("Leave GetDLPTemplateInstallScripts");
    }
    
    this.GetDigitalAssetMap = function()
    {
        var arrMap = new Array();
        var daMapFile = sWorkingDirectory + "\\cfg_dlp_da_map.txt";
        var fso = new ActiveXObject("Scripting.FileSystemObject");
        var f = fso.OpenTextFile(daMapFile, 1, false);
        while (!f.AtEndOfStream)
        {
            var s = f.ReadLine();
            if (s.length > 0)
            {
                if (s.charAt(0) != "#")
                {
                    var tabIndex = s.indexOf("\t");
                    if (tabIndex > 0)
                    {
                        var left = s.substring(0, tabIndex);
                        var right = s.substr(tabIndex+1);
                        arrMap.push(new IDMap(trim(left), trim(right)));
                    }
                }
            }
        }
        f.Close();
        
        return arrMap;
    }
    
    this.GetDLPRuleNameMap = function()
    {
        var arr = [
            new IDMap("DATA PROTECTION (GLBA)","Data Loss Prevention (GLBA)"),
            new IDMap("DATA PROTECTION (HIPAA)","Data Loss Prevention (HIPAA)"),
            new IDMap("DATA PROTECTION (PCI-DSS)","Data Loss Prevention (PCI-DSS)"),
            new IDMap("DATA PROTECTION (SB-1386)","Data Loss Prevention (SB-1386)"),
            new IDMap("DATA PROTECTION (US PII)","Data Loss Prevention (US PII)")
        ];
        return arr;
    }
    
    this.GetDLPTemplateIdMap = function()
    {
        var arr = [
            new IDMap("F084907F-B35F-41ff-BD8E-DD174C69A5EE", "00000000-0000-0000-0004-000000000001"), //"glba"
            new IDMap("FE5D56B7-C127-4e1c-99F5-169622459EF9", "00000000-0000-0000-0004-000000000002"), //"hipaa"
            new IDMap("27EABD79-6D9D-440b-8681-5AB21B486645", "00000000-0000-0000-0004-000000000003"), //"pcidss"
            new IDMap("495F6370-8F6B-4ff2-9D18-6EF2DF8FD67E", "00000000-0000-0000-0004-000000000004"), //"sb1386"
            new IDMap("210566AE-D693-4f81-8416-EFF2A48FDA8C", "00000000-0000-0000-0004-000000000005"), //"uspii"
            new IDMap("E155E535-EF13-4dad-99F3-ED9E22CAEF9C", "00000000-0000-0000-0004-000000000048"), //"source_code"
            
            new IDMap("16F4538D-9CD8-43bf-8DCF-3D485EB56D52", "00000000-0000-0000-0004-000000000100"), //"jp_pi_100"
            new IDMap("525B0E99-C090-4496-B67E-62C93107EB2A", "00000000-0000-0000-0004-000000000099"), //"jp_pi_10"
            new IDMap("18FF6835-4EED-4c38-AB9B-835F86135FC0", "00000000-0000-0000-0004-000000000101"), //"jp_pi_50"
            new IDMap("D6CF7EBA-FE92-44f7-AB9A-7BC6908A7FAD", "00000000-0000-0000-0004-000000000097"), //"jp_pi_obk50"
            new IDMap("E58DBD06-99FD-4219-BF57-06C4F6EDD6BF", "00000000-0000-0000-0004-000000000098"), //"jp_pi_h50"
            new IDMap("B9DEA4EF-1C9F-4a6b-A222-395CAB45173B", "00000000-0000-0000-0004-000000000102") //"jp_pi_k50"
        ];
        return arr;
    }

    ///////////////////////////////////////////////////////////////////////////////////////////////
    this.RollbackDatabase = function()
    {
        WScript.Echo("Enter RollbackDatabase");
        var conn = new ActiveXObject("ADODB.Connection");        
        
        var ConnectString = this.ConnectStringForOperate;
        WScript.Echo("conn.Open");
        conn.Open(ConnectString);
        
        //add transaction
        WScript.Echo("conn.BeginTrans");
        conn.BeginTrans();
        
        function SqlScriptIterator(sqlInstallScript, bHaltOnError, timeout)
        {
            try
            {
                sqlInstallScript=sqlInstallScript.replace(/\n/g,"\r\n");
                var currentTimeout=conn.CommandTimeout;
                if(timeout!=null)
                {
                    log.Write("Current timeout = "+currentTimeout);
                    log.Write("Set timeout = "+timeout);
                    conn.CommandTimeout = timeout;
                }
                log.Write(sqlInstallScript);
                conn.Execute(sqlInstallScript);
                if(timeout!=null){
                    conn.CommandTimeout=currentTimeout
                }
            }
            catch(e)
            {
                if (bHaltOnError)
                {
                    throw e;
                }
                else
                {
                    WScript.Echo("catch exception in RollbackDatabase:SqlScriptIterator");
                    log.Write(sqlInstallScript);
                    log.Write("Expected error: ", e.message, " (", e.number, ") ");
                }

            }
            return true;
        }
        
        try
        {
            WScript.StdOut.WriteLine("begin rollback tables");
            this.GetRollbackScripts(SqlScriptIterator, conn);
        }
        catch(e)
        {
            WScript.Echo("catch exception in RollbackDatabase, RollbackTrans now"); 
            conn.RollbackTrans();
            conn.Close();
            throw e;
        }
        WScript.Echo("conn.CommitTrans");
        conn.CommitTrans();
        conn.Close();
        WScript.Echo("Leave RollbackDatabase");
    };

    
    this.RollbackDLPChanges = function(visitor, cn)
    {
        WScript.Echo("Enter RollbackDLPChanges");
        if (this.XmlType.substr(0, 4) != "Conf")
        {
            WScript.Echo("Not config db, skip rollback dlp data");
            return;
        }
        
        var uniPref = (this.Type == "SQLSVR") ? "N" : "";
        
        // delete templates
        visitor("DELETE FROM TM_DLPFilterTemplate"+computerName+" WHERE CFG_INDEX<>'SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_TEMPLATE_DEFAULT'", true);
        
        var arrSql = new Array();
        
        // recover data from backup xml file,
        var sTemplateIdList = "";
        var dom = new ActiveXObject("MSXML2.DOMDocument");
        if (dom.load(sWorkingDirectory + "\\" + DLPBackupXml))
        {
            // restore template
            var coll = dom.selectNodes("dlp/templates/template");
            var idxPrefix = "SMEX_PLC_NULL:";
            for (var i=0; i<coll.length; ++i)
            {
                var cfgIndex = coll[i].getAttribute("cfg_index");
                var defInstance = coll[i].getAttribute("def_instance");
                var displayName = coll[i].getAttribute("name").replace(/'/g, "''");
                var desc = coll[i].getAttribute("description").replace(/'/g, "''");
                var builtin = coll[i].getAttribute("builtin");
                var content = coll[i].text.replace(/'/g, "''");
                
                if (!visitor("INSERT INTO TM_DLPFilterTemplate"+computerName+" (CFG_INDEX,CFG_DEFAULT_INSTANCE," +
                    "DLP_TEMPLATE_NAME,DLP_TEMPLATE_BUILTIN,DLP_TEMPLATE_DESCRIPTION,DLP_TEMPLATE_ELEMENT) VALUES ('" + 
                    cfgIndex + "', '" + defInstance + "'," + uniPref + "'" + displayName + "', " + builtin + ", " + 
                    uniPref + "'" + desc + "', '" + content + "')", true))
                    return;
                
                sTemplateIdList += cfgIndex.substr(idxPrefix.length) + ",";
            }
            
            // restore mgr
            coll = dom.selectNodes("dlp/templateMgr/mgr");
            for (i=0; i<coll.length; ++i)
            {
                var cfgIndex = coll[i].getAttribute("cfg_index");
                var content = coll[i].text;
                
                if (!visitor("UPDATE TM_DLPTemplateManagement"+computerName+" SET DLP_TEMPLATE_LIST_CFGSETTING_MV='" +
                    content + "' WHERE CFG_INDEX='" + cfgIndex + "'", true))
                    return;
            }
        }
        else
        {
            if (dom.parseError.errorCode != 0) 
            {
                var Err = dom.parseError;
                WScript.Echo("Parse xml error: " + Err.reason);
            } 
        }
        dom = null;
        
        WScript.Echo("Leave RollbackDLPChanges");
    }
    
    this.RollbackDLPKeywordChanges = function(visitor, cn)
    {
        WScript.Echo("Enter RollbackDLPKeywordChanges");
        if (this.XmlType.substr(0, 4) != "Conf")
        {
            WScript.Echo("Not config db, skip rollback dlp data");
            return;
        }
        
        var uniPref = (this.Type == "SQLSVR") ? "N" : "";
        
        // delete keywords
        visitor("DELETE FROM TM_DLPFilterKeyword"+computerName+" WHERE CFG_INDEX<>'SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_KEYWORD_DEFAULT'", true);
        
        var arrSql = new Array();
        
        // recover data from backup xml file,
        var skeywordIdList = "";
        var dom = new ActiveXObject("MSXML2.DOMDocument");
        if (dom.load(sWorkingDirectory + "\\" + DLPKeywordBackupXml))
        {
            // restore keyword
            var coll = dom.selectNodes("dlp/keywords/keyword");
            var idxPrefix = "SMEX_PLC_NULL:";
            for (var i=0; i<coll.length; ++i)
            {
                var cfgIndex = coll[i].getAttribute("cfg_index");
                var defInstance = coll[i].getAttribute("def_instance");
                var displayName = coll[i].getAttribute("name").replace(/'/g, "''");
                var internalName = coll[i].getAttribute("internalname");
                var desc = coll[i].getAttribute("description").replace(/'/g, "''");
                var condition = coll[i].getAttribute("condition");
                var threshold = coll[i].getAttribute("threshold");
                var number = coll[i].getAttribute("number");
                var modify = coll[i].getAttribute("modify");
                var builtin = coll[i].getAttribute("builtin");
                var keywordcontent = coll[i].text.replace(/'/g, "''");
                
                if (!visitor("INSERT INTO TM_DLPFilterKeyword"+computerName+" (CFG_INDEX,CFG_DEFAULT_INSTANCE," +
                    "DLP_KEYWORD_NAME,DLP_KEYWORD_INTERNALNAME,DLP_KEYWORD_DESC,DLP_KEYWORD_CONDITION,"+
                    "DLP_KEYWORD_THRESHOLD,DLP_KEYWORD_NUMBER,DLP_KEYWORD_MODIFIED,DLP_KEYWORD_BUILTIN,DLP_SUBKEYWORD_LIST) VALUES ('" + 
                    cfgIndex + "', '" + defInstance + "'," + uniPref + "'" + displayName + "', '" + internalName + "', " + 
                    uniPref + "'" + desc + "', '" + condition + "',"+threshold+","+number+","+modify+","+builtin+","+uniPref + "'" + keywordcontent+ "')", true))
                    return;
                
                skeywordIdList += cfgIndex.substr(idxPrefix.length) + ",";
            }
            
            // restore mgr
            coll = dom.selectNodes("dlp/keywordMgr/mgr");
            for (i=0; i<coll.length; ++i)
            {
                var cfgIndex = coll[i].getAttribute("cfg_index");
                var content = coll[i].text;
                
                if (!visitor("UPDATE TM_DLPFilterKeywordMgr"+computerName+" SET CFG_DLP_KEYWORD_LIST_CFGSETTING_MV='" +
                    content + "' WHERE CFG_INDEX='" + cfgIndex + "'", true))
                    return;
            }
        }
        
        else
        {
            if (dom.parseError.errorCode != 0) 
            {
                var Err = dom.parseError;
                WScript.Echo("Parse xml error: " + Err.reason);
            } 
        }
        
        dom = null;
        
        WScript.Echo("Leave RollbackDLPKeywordChanges");
    }
    
    this.RollbackDLPExpressionChanges = function(visitor, cn)
    {
        WScript.Echo("Enter RollbackDLPExpressionChanges");
        if (this.XmlType.substr(0, 4) != "Conf")
        {
            WScript.Echo("Not config db, skip rollback dlp data");
            return;
        }
        
        var uniPref = (this.Type == "SQLSVR") ? "N" : "";
        
        // delete expressions
        visitor("DELETE FROM TM_DLPFilterExpression"+computerName+" WHERE CFG_INDEX<>'SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_EXPRESSION_DEFAULT'", true);

        var arrSql = new Array();
        
        // recover data from backup xml file,
        var sExpressionIdList = "";
        var dom = new ActiveXObject("MSXML2.DOMDocument");
        if (dom.load(sWorkingDirectory + "\\" + DLPExpressBackupXml))
        {
            // restore expression
            var coll = dom.selectNodes("dlp/expressions/expression");
            var idxPrefix = "SMEX_PLC_NULL:";
            for (var i=0; i<coll.length; ++i)
            {
                var cfgIndex = coll[i].getAttribute("cfg_index");
                //var defInstance = coll[i].getAttribute("def_instance");
                var displayName = coll[i].getAttribute("name").replace(/'/g, "''");
                var innerName = coll[i].getAttribute("internalname");
                var desc = coll[i].getAttribute("description").replace(/'/g, "''");
                var type = coll[i].getAttribute("type");
                var minLen = coll[i].getAttribute("minlength");
                var maxLen = coll[i].getAttribute("maxlength");
                var minLeftRadius = coll[i].getAttribute("minleftradius");
                var maxLeftRadius = coll[i].getAttribute("maxleftradius");
                var maxRightRadius = coll[i].getAttribute("maxrightradius");
                var suffixLength = coll[i].getAttribute("suffixlength");
                var alph = coll[i].getAttribute("alphcharset");
                var casesenitive = coll[i].getAttribute("casesensitive");
                var dispFormat = coll[i].getAttribute("displayformat");
                var example = coll[i].getAttribute("examp");
                var validator = coll[i].getAttribute("validator");
                var modify = coll[i].getAttribute("modify");
                var builtin = coll[i].getAttribute("builtin");
                var pattern = coll[i].text.replace(/'/g, "''");
                
                if (!visitor("INSERT INTO TM_DLPFilterExpression"+computerName+" (CFG_INDEX, CFG_DEFAULT_INSTANCE, DLP_EXPRESSION_NAME, " +
                "DLP_EXPRESSION_INTERNALNAME, DLP_EXPRESSION_DESC, DLP_EXPRESSION_TYPE, DLP_EXPRESSION_MINLENGTH, " +
                "DLP_EXPRESSION_MAXLENGTH, DLP_EXPRESSION_MINLEFTRADIUS, DLP_EXPRESSION_MAXLEFTRADIUS, " +
                "DLP_EXPRESSION_MAXRIGHTRADIUS, DLP_EXPRESSION_SUFFIXLENGTH, DLP_EXPRESSION_PATTERN, " +
                "DLP_EXPRESSION_ALPHABETCHARSET, DLP_EXPRESSION_CASESENSITIVE, DLP_EXPRESSION_DISPLAYFORMAT, " +
                "DLP_EXPRESSION_EXAMPLE, DLP_EXPRESSION_VALIDATOR, DLP_EXPRESSION_MODIFIED,DLP_EXPRESSION_BUILTIN) VALUES ('" + cfgIndex + 
                "', 'SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_EXPRESSION_DEFAULT', " + uniPref + "'" + displayName + "', '" +
                innerName + "', " + uniPref + "'" + desc + "', '" + type + "', " + minLen + ", " + maxLen + ", " + 
                minLeftRadius + ", " + maxLeftRadius + ", " + maxRightRadius + ", " + suffixLength + ", " + uniPref + 
                "'" + pattern + "', '" + alph + "', " + casesenitive + ", '" + dispFormat + "', '" + example + "', '" +
                validator + "', " + modify+","+builtin + ")", true))
                break;
                
                sExpressionIdList += cfgIndex.substr(idxPrefix.length) + ",";
            }
            
            // restore mgr
            coll = dom.selectNodes("dlp/expressionMgr/mgr");
            for (i=0; i<coll.length; ++i)
            {
                var cfgIndex = coll[i].getAttribute("cfg_index");
                var content = coll[i].text;
                if (!visitor("UPDATE TM_DLPFilterExpressionMgr"+computerName+" SET CFG_DLP_EXPRESSION_LIST_CFGSETTING_MV='" +
                    content + "' WHERE CFG_INDEX='" + cfgIndex + "'", true))
                    return;
            }
        }
        
        else
        {
            if (dom.parseError.errorCode != 0) 
            {
                var Err = dom.parseError;
                WScript.Echo("Parse xml error: " + Err.reason);
            } 
        }
        
        dom = null;
        
        WScript.Echo("Leave RollbackDLPExpressionChanges");
    }
    this.UpdateDLPPolicy = function(visitor, cn)
    {
        WScript.Echo("Enter UpdateDLPPolicy");
        if (this.XmlType.substr(0, 4) != "Conf")
        {
            WScript.Echo("Not config db, skip rollback dlp data");
            return;
        }
        
        var uniPref = (this.Type == "SQLSVR") ? "N" : "";
        var sql = "SELECT DLP_TEMPLATE_LIST_CFGSETTING_MV FROM TM_DLPTemplateManagement"+computerName+
                   " WHERE CFG_INDEX = 'SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_TEMPLATE_MANAGEMENT_DEFAULT'";                 
        var rsTemplateList = cn.Execute(sql);
        var lstTemplateList ="";
        while (!rsTemplateList.EOF)
        {
            lstTemplateList =  rsTemplateList(0).Value;
            break;
        }
        rsTemplateList.Close();
        if(lstTemplateList == "")
        {
            WScript.Echo("Error: Template list is empty in the TM_DLPTemplateManagement table.");
            return;
        }
        sql = "SELECT CFG_INDEX,DLP_TEMPLATE_LIST_CFGSETTING_REF FROM TM_DLPFilterRule"+computerName+" WHERE " +
            "CFG_INDEX not like 'SMEX_PLC_NULL:SMEX_SUB_CFG_DLP_RULE%_DEFAULT'";
        var arrPolicy = new Array();        
        var rs = cn.Execute(sql);
        while (!rs.EOF)
        {
            var index = rs(0).Value;
            var templateList =  rs(1).Value;
            var strUpdateValue = templateList;
            var iLastCharIndex = templateList.length -1;
            if(templateList.charAt(iLastCharIndex) ==":")
              templateList = templateList.substr(0,templateList.length -1); //remove the last ':'
              
            var templateArray = templateList.split(":");
            var iLength = templateArray.length;
            var bUpdate = false;
            for(var i = 0;i<iLength/2;i++)
            {
              var strTemplateID = templateArray[2*i] + ":" + templateArray[2*i+1];
              if(-1 == lstTemplateList.indexOf(strTemplateID))
              {
                  var strReplace = strTemplateID+":";
                  strUpdateValue = strUpdateValue.replace(strReplace,"");  
                  bUpdate = true;
              }
            }
            if(bUpdate)
            {
                arrPolicy.push(new PolicyMap(index,strUpdateValue));
            }
            rs.MoveNext();
        }
        rs.Close();
        var iPolicyLeng = arrPolicy.length;
        for(var j = 0;j<iPolicyLeng;j++)
        {
           var ID = arrPolicy[j].PolicyId;
           var strValue = arrPolicy[j].newValue;
           visitor("UPDATE TM_DLPFilterRule"+computerName+" SET DLP_TEMPLATE_LIST_CFGSETTING_REF='" + strValue + 
                "' WHERE CFG_INDEX='"+ID+"'", true);
        }
        WScript.Echo("Leave UpdateDLPPolicy");
    }
    ///////////////////////////////////////////////////////////////////////////////////////////////
    this.GetRollbackScripts = function (visitor, cn)
    {
        WScript.Echo("Enter GetRollbackScripts");
        //this.UpdateDLPPolicyAccount(visitor, cn);
        //this.UpdateABPolicyAccount(visitor, cn);
        var fSqlSatementCreation     = sWorkingDirectory + "\\" + "dbTableCreationSql.xslt";
        var xDatabaseInstallSql      = XDoc();
        var xDatabaseSchemaTransform = XDoc();
        
        xDatabaseSchemaTransform.load(fSqlSatementCreation);
        if(xDatabaseSchemaTransform.parseError.errorCode != 0) 
        {
            var Err = xDatabaseSchemaTransform.parseError;
            WScript.Echo("Parse xml error: " + Err.reason);
        }
        
        
        WScript.Echo("after xDatabaseSchemaTransform.load");
        //var xNodeInstall = xProfile.selectSingleNode("/database_configuration/database_uninstallation");
        //xNodeInstall.appendChild(GenerateSchemaUpgradeTables(this.ConnectStringForOperate, true));
        xDatabaseInstallSql.loadXML(xProfile.transformNode(xDatabaseSchemaTransform));
        WScript.Echo("after xDatabaseInstallSql.loadXML");
        var xSqlScriptsList = xDatabaseInstallSql.selectNodes("/database/database_uninstallation/sql");
        var xSql = null;
                
        WScript.Echo("begin execute the sql commands");
        WScript.Echo("*************************************************************");
        while (xSqlScriptsList && (xSql = xSqlScriptsList.nextNode()))
        {
            if (!visitor(xSql.text, (xSql.getAttribute("haltonerror") == null || xSql.getAttribute("haltonerror") == true), xSql.getAttribute("timeout")))
                break;
        }
        
        
        this.RollbackDLPChanges(visitor, cn);
        this.RollbackDLPKeywordChanges(visitor, cn);
        this.RollbackDLPExpressionChanges(visitor, cn);
        this.UpdateDLPPolicy(visitor, cn);
        //this.UpdateScheduleReport(visitor, cn);
        
        WScript.Echo("*************************************************************");
        WScript.Echo("end execute the sql commands");
        WScript.Echo("Leave GetRollbackScripts");
    }
}
///////////////////////////////////////////////////////////////////////////////////////////////////
function XDoc()
{
    var oXmlDoc = null;
    if (oXmlDoc == null) { try { oXmlDoc = new ActiveXObject("MSXML2.DOMDocument.6.0"); 
        oXmlDoc.setProperty("ProhibitDTD", false);    // MSXML 6 
        oXmlDoc.setProperty("UseInlineSchema", true); // MSXML 6 
        oXmlDoc.setProperty("AllowXsltScript", true); 
        oXmlDoc.setProperty("AllowDocumentFunction", true); } catch(e) {} }
    if (oXmlDoc == null) { try { oXmlDoc = new ActiveXObject("MSXML2.DOMDocument.4.0"); } catch(e) {} }
    if (oXmlDoc == null) { try { oXmlDoc = new ActiveXObject("MSXML2.DOMDocument.3.0"); } catch(e) {} }
    if (oXmlDoc == null) throw "unable to create a MSXML instance";
    oXmlDoc.validateOnParse = false;
    oXmlDoc.resolveExternals = true;
    return oXmlDoc;
}
///////////////////////////////////////////////////////////////////////////////////////////////////
function Log(enable)
{
    this.Write = function ()
    {
        for (i = 0; i != arguments.length; ++i)
            WriteImp(arguments[i]);
        WriteImp("\n");
    }
    this.WriteFormat = function(fmtString)
    {
        var strFormated = new String(fmtString);
        for (i = 1; i < arguments.length; ++i)
            strFormated = strFormated.replace("%" + i + "%", arguments[i]);
        WriteImp(strFormated);
        WriteImp("\n");
    }
    function WriteImp(item)
    {
        if (enable)
            WScript.Echo(item);
    }
}

