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