//example: //Driver={Adaptive Server Enterprise};server=profastsv2syb;port=5000;schemaRoot=AdventureWorks;uid=SA;Pwd=SA1992; private string ConvertSybaseConnectionStringToOdbc(string sybaseConnectionString) { string odbcConnectionString = string.Empty; PFParseString sqlConnBuilder = new PFParseString(); string val = string.Empty; if (_connectionString.Trim().Length > 0) { sqlConnBuilder.KeyType = PFParseString.PFArgumentKeyType.NamedKey; sqlConnBuilder.Delimiters = ";"; sqlConnBuilder.StringToParse = sybaseConnectionString; _str.Length = 0; _str.Append("Driver={Adaptive Server Enterprise};"); PFParseString.PFKeyValuePair kv = new PFParseString.PFKeyValuePair(); kv = sqlConnBuilder.GetFirstKeyValue(); while (kv.Key != string.Empty) { if (kv.Key.ToLower() == "data source") { _str.Append("server="); _str.Append(kv.Value); _str.Append(";"); } if (kv.Key.ToLower() == "port") { _str.Append("port="); _str.Append(kv.Value); _str.Append(";"); } if (kv.Key.ToLower() == "database") { _str.Append("schemaRoot="); _str.Append(kv.Value); _str.Append(";"); } if (kv.Key.ToLower() == "uid") { _str.Append("uid="); _str.Append(kv.Value); _str.Append(";"); } if (kv.Key.ToLower() == "pwd") { _str.Append("pwd="); _str.Append(kv.Value); _str.Append(";"); } kv = sqlConnBuilder.GetNextKeyValue(); } } odbcConnectionString = _str.ToString(); return(odbcConnectionString); }
public static void RunCommandLineParseTest(MainForm frm) { PFParseString parse = new PFParseString(); try { _msg.Length = 0; _msg.Append("RunCommandLineParseTest running ..."); Program._messageLog.WriteLine(_msg.ToString()); parse.QuotedValues = frm.chkQuotedValues.Checked; parse.KeyType = frm.cboKeyType.Text == "NoKey" ? PFParseString.PFArgumentKeyType.NoKey : frm.cboKeyType.Text == "CharKey" ? PFParseString.PFArgumentKeyType.CharKey : PFParseString.PFArgumentKeyType.NamedKey; parse.Delimiters = frm.txtDelimiters.Text; parse.StringToParse = frm.txtCommandLineToParse.Text; _msg.Length = 0; _msg.Append("Key type: "); _msg.Append(parse.KeyType.ToString()); _msg.Append("\r\n"); _msg.Append("Delimiters: "); _msg.Append(parse.Delimiters); _msg.Append("\r\n"); _msg.Append("QuotedValues: "); _msg.Append(parse.QuotedValues.ToString()); _msg.Append("\r\n"); _msg.Append("String to parse: "); _msg.Append(parse.StringToParse); _msg.Append("\r\n"); Program._messageLog.WriteLine(_msg.ToString()); _msg.Length = 0; if (parse.KeyType == PFParseString.PFArgumentKeyType.NoKey) { string val = string.Empty; _msg.Append("Show first to last:\r\n"); val = parse.GetFirst(); while (parse.EOL == false) { _msg.Append(val); _msg.Append("\r\n"); val = parse.GetNext(); } _msg.Append("Show last to first:\r\n"); val = parse.GetLast(); while (parse.EOL == false) { _msg.Append(val); _msg.Append("\r\n"); val = parse.GetPrev(); } Program._messageLog.WriteLine(_msg.ToString()); } else { //is either CharKey or NamedKey PFParseString.PFKeyValuePair kv = new PFParseString.PFKeyValuePair(); _msg.Append("Show first to last:\r\n"); kv = parse.GetFirstKeyValue(); while (kv.Key != string.Empty) { _msg.Append("Key = "); _msg.Append(kv.Key); _msg.Append(" Val = "); _msg.Append(kv.Value); _msg.Append("\r\n"); kv = parse.GetNextKeyValue(); } _msg.Append("Show last to first:\r\n"); kv = parse.GetLastKeyValue(); while (kv.Key != string.Empty) { _msg.Append("Key = "); _msg.Append(kv.Key); _msg.Append(" Val = "); _msg.Append(kv.Value); _msg.Append("\r\n"); kv = parse.GetPrevKeyValue(); } Program._messageLog.WriteLine(_msg.ToString()); } } catch (System.Exception ex) { _msg.Length = 0; _msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex)); Program._messageLog.WriteLine(_msg.ToString()); AppMessages.DisplayErrorMessage(_msg.ToString(), _saveErrorMessagesToAppLog); } finally { ; } }
public static void ParseStringAutomaticTest() { try { Program._messageLog.WriteLine("\r\n\r\nRunning ParseStringAutomaticTest ..."); PFParseString parse = new PFParseString(); string stringToParse = ""; Program._messageLog.WriteLine("\r\nNoKey"); parse.KeyType = PFParseString.PFArgumentKeyType.NoKey; parse.Delimiters = " ,"; parse.QuotedValues = true; stringToParse = (string)("parm1 parm2 third_parm \"this is fourth param\""); Program._messageLog.WriteLine("StringToParse = " + stringToParse); parse.StringToParse = stringToParse; DisplayParsedItems(parse); GetParseKey(parse, 2); Program._messageLog.WriteLine("\r\n\r\n"); Program._messageLog.WriteLine("CharKey"); parse.KeyType = PFParseString.PFArgumentKeyType.CharKey; parse.Delimiters = "-/"; parse.QuotedValues = false; stringToParse = "/Usa -Ume -ppassword -sSERV01 /Iineturl /Ierror"; //sStringToParse = "/Usa -ppassword -sSERV01 /Iineturl" //sStringToParse = "/Usa -ppassword -s""SERV01 """"-moi-"""""" /Iineturl" Program._messageLog.WriteLine("StringToParse = " + stringToParse); parse.StringToParse = stringToParse; DisplayParsedItems(parse); GetParseKey(parse, "U"); GetParseKey(parse, "s"); GetParseKey(parse, "i"); GetParseKey(parse, "/x"); Program._messageLog.WriteLine("\r\n\r\n"); Program._messageLog.WriteLine("NamedKey"); parse.KeyType = PFParseString.PFArgumentKeyType.NamedKey; //parse.Delimiters = ","; parse.Delimiters = " ,"; parse.QuotedValues = true; stringToParse = " Application=MineVer01, Username=\"Me ,And You\", Password=moi1999, Server=DOWN24HRADAY, InternetConnection=\"On The Fritz\""; Program._messageLog.WriteLine("StringToParse = " + stringToParse); //sStringToParse = "Mojo, Application=MineVer01, MidLife and cries, Username=moi, Password=moi1999, Server=DOWN24HRADAY, InternetConnection=OnTheFritz, BadLast" parse.StringToParse = stringToParse; DisplayParsedItems(parse); GetParseKey(parse, "Nothing"); GetParseKey(parse, "Application"); GetParseKey(parse, "username"); GetParseKey(parse, "password"); GetParseKey(parse, "InternetConnection"); Program._messageLog.WriteLine("\r\n\r\n"); Program._messageLog.WriteLine("NamedKey (second run)"); parse.KeyType = PFParseString.PFArgumentKeyType.NamedKey; parse.Delimiters = " ,"; parse.QuotedValues = false; stringToParse = "Mojo, Application=MineVer01, MidLife and cries, Username=moi, Password=moi1999, Server=DOWN24HRADAY, InternetConnection=OnTheFritz, BadLast"; parse.StringToParse = stringToParse; Program._messageLog.WriteLine("StringToParse = " + stringToParse); DisplayParsedItems(parse); GetParseKey(parse, "Nothing"); GetParseKey(parse, "Application"); GetParseKey(parse, "username"); GetParseKey(parse, "password"); GetParseKey(parse, "InternetConnection"); GetParseKey(parse, parse.NumItems - 1); GetParseKey(parse, "BadLast"); Program._messageLog.WriteLine("\r\n\r\n"); Program._messageLog.WriteLine("CharKey (using keylist"); parse.KeyType = PFParseString.PFArgumentKeyType.CharKey; parse.Delimiters = "-/"; parse.QuotedValues = false; stringToParse = "/Usa -xme -ppassword -sSERV01 /Iineturl /eerror"; Program._messageLog.WriteLine("StringToParse = " + stringToParse); parse.StringToParse = stringToParse; DisplayParsedItems(parse); Program._messageLog.WriteLine("Show KV first to last ..."); if (parse.NumKeys > 0) { PFParseString.PFKeyValuePair kv = parse.GetKeyValuePair(PFParseString.PFScroll.First); while (kv.Key != string.Empty) { _msg.Length = 0; _msg.Append("Key = "); _msg.Append(kv.Key); _msg.Append(", value = "); _msg.Append(kv.Value); Program._messageLog.WriteLine(_msg.ToString()); kv = parse.GetKeyValuePair(PFParseString.PFScroll.Next); } } else { Program._messageLog.WriteLine("ERROR: No keys found in string that was parsed. There should have been some keys."); } Program._messageLog.WriteLine("\r\n\r\nShow KV last to first ..."); if (parse.NumKeys > 0) { PFParseString.PFKeyValuePair kv = parse.GetKeyValuePair(PFParseString.PFScroll.Last); while (kv.Key != string.Empty) { _msg.Length = 0; _msg.Append("Key = "); _msg.Append(kv.Key); _msg.Append(", value = "); _msg.Append(kv.Value); Program._messageLog.WriteLine(_msg.ToString()); kv = parse.GetKeyValuePair(PFParseString.PFScroll.Previous); } } else { Program._messageLog.WriteLine("ERROR: No keys found in string that was parsed. There should have been some keys."); } Program._messageLog.WriteLine("\r\nShow params first to last ..."); if (parse.NumItems > 0) { string itm = parse.Get(PFParseString.PFScroll.First); while (parse.EOL == false) { _msg.Length = 0; _msg.Append("Parsed Item = "); _msg.Append(itm); Program._messageLog.WriteLine(_msg.ToString()); itm = parse.Get(PFParseString.PFScroll.Next); } } else { Program._messageLog.WriteLine("ERROR: No parsed items found in string that was parsed. There should have been some parameters."); } Program._messageLog.WriteLine("\r\nShow params last to first ..."); if (parse.NumItems > 0) { string itm = parse.Get(PFParseString.PFScroll.Last); while (parse.EOL == false) { _msg.Length = 0; _msg.Append("Parsed Item = "); _msg.Append(itm); Program._messageLog.WriteLine(_msg.ToString()); itm = parse.Get(PFParseString.PFScroll.Previous); } } else { Program._messageLog.WriteLine("ERROR: No parsed items found in string that was parsed. There should have been some parameters."); } } catch (Exception ex) { string sMessage; sMessage = (string)("Error occured while trying to run parse test." + "\r\n" + "\r\n" + AppMessages.FormatErrorMessage(ex)); AppMessages.DisplayErrorMessage(sMessage, true, true); } }