private static void ExecuteAppend(MachConnection aConn, int aRecordCount)
{
using (MachCommand sAppendCommand = new MachCommand(aConn))
{
MachAppendWriter sWriter = sAppendCommand.AppendOpen(TABLE_NAME);
Random randomSeed = new Random();
DateTime sStartTime = DateTime.Now;
var sList = new List <object>();
for (int i = 1; i <= aRecordCount; i++)
{
sList.Add((Int16)i); //SEQ SHORT
sList.Add((Int64)i * 4); //TOTAL LONG
sList.Add((Single)(i * 2.2)); //PERCENTAGE FLOAT
sList.Add((Double)(i * 16.4)); //RATIO DOUBLE
sList.Add(i * 2); //ID INTEGER
sList.Add(String.Format("NAME_{0}", i % 100)); //NAME VARCHAR(20)
sList.Add(GetRandomTimeString(randomSeed, "2020-01-01")); //ETIME DATETIME
sList.Add(String.Format("MESSAGE_TEXT_MESSAGE_TEXT_MESSAGE_TEXT_MESSAGE_TEXT_MESSAGE_TEXT_MESSAGE_TEXT_MESSAGE_TEXT_MESSAGE_TEXT_MESSAGE_TEXT_MESSAGE_TEXT_MESSAGE_TEXT_MESSAGE_TEXT_MESSAGE_TEXT_MESSAGE_TEXT_MESSAGE_TEXT_{0}", i % 100)); //MESSAGE text
sList.Add(GetRandomIPv4(randomSeed)); //SRC_IP IPv4
sList.Add(GetRandomIPv6(randomSeed)); //DEST_IP IPv6
sList.Add(Encoding.UTF8.GetBytes(String.Format("IMAGE_BINARY_IMAGE_BINARY_IMAGE_BINARY_IMAGE_BINARY_IMAGE_BINARY_IMAGE_BINARY_IMAGE_BINARY_IMAGE_BINARY_IMAGE_BINARY_IMAGE_BINARY_IMAGE_BINARY_IMAGE_BINARY_IMAGE_BINARY_IMAGE_BINARY_IMAGE_BINARY_{0}", i % 100))); //image binary
sAppendCommand.AppendData(sWriter, sList);
sList.Clear();
}
sAppendCommand.AppendClose(sWriter);
Console.WriteLine(String.Format("Success Count : {0}", sWriter.SuccessCount));
Console.WriteLine(String.Format("Elapsed Time : {0}", DateTime.Now.Subtract(sStartTime)));
}
}
private static void ExecuteQuery(MachConnection aConn, string aQueryString, ErrorCheckType aCheckType)
{
using (MachCommand sCommand = new MachCommand(aQueryString, aConn))
{
try
{
sCommand.ExecuteNonQuery();
}
catch (MachException me)
{
switch (aCheckType)
{
case ErrorCheckType.ERROR_CHECK_YES:
throw me;
break;
case ErrorCheckType.ERROR_CHECK_WARNING:
Console.WriteLine("[WARNING!]");
Console.WriteLine("{0}", me.ToString());
break;
case ErrorCheckType.ERROR_CHECK_NO:
default:
break;
}
}
}
}
private static void ExecuteSelect(MachConnection aConn, string aSelectQueryString)
{
using (MachCommand sSelectCommand = new MachCommand(aSelectQueryString, aConn))
{
MachDataReader sDataReader = sSelectCommand.ExecuteReader();
int sCount = 0;
while (sDataReader.Read())
{
Console.WriteLine("------------------");
for (int i = 0; i < sDataReader.FieldCount; i++)
{
Console.WriteLine(String.Format("{0} : {1}",
sDataReader.GetName(i),
sDataReader.GetValue(i)));
}
sCount++;
}
Console.WriteLine("\n------------------");
Console.WriteLine("{0} Rows selected", sCount);
}
}
