//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);
}
}
