/// <summary> /// /// </summary> /// <param name="table"></param> public static void UpdateNonIdentityCompleteTableProperties(NonIdentityCompleteTable table) { var now = DateTime.SpecifyKind( DateTime.Parse(DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss.fffff")), DateTimeKind.Unspecified); table.ColumnBigInt = Convert.ToInt64(2); table.ColumnBigIntAsArray = new long[] { 1, 2, 3, 4, 5 }; table.ColumnBigSerial = Convert.ToInt64(2); //table.ColumnBit = true; table.ColumnBoolean = (Randomizer.Next() % 2 != 0); table.ColumnChar = 'C'; table.ColumnCharacter = "C"; table.ColumnCharacterVarying = "ColumnCharacterVarying"; table.ColumnDate = now.Date; table.ColumnDateAsArray = new[] { now.Date, now.Date, now.Date }; table.ColumnInteger = Convert.ToInt32(2); table.ColumnIntegerAsArray = new[] { 1, 2, 3, 4, 5 }; table.ColumnInterval = now.TimeOfDay; table.ColumnIntervalAsArray = new[] { now.TimeOfDay, now.TimeOfDay, now.TimeOfDay }; //table.ColumnJson = "{\"field1\": 1, \"field2\": 2}"; table.ColumnMoney = Convert.ToDecimal(2); table.ColumnName = $"{table.ColumnName}(Updated) - {Guid.NewGuid()}"; table.ColumnReal = Convert.ToSingle(2); table.ColumnSmallInt = Convert.ToInt16(2); table.ColumnText = $"{table.ColumnText} (Updated)"; table.ColumnTimestampWithoutTimeZone = now; }
/// <summary> /// Update the properties of <see cref="NonIdentityCompleteTable"/> instance. /// </summary> /// <param name="table">The instance to be updated.</param> public static void UpdateNonIdentityCompleteTableProperties(NonIdentityCompleteTable table) { var now = DateTime.SpecifyKind( DateTime.Parse(DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss.fffff")), DateTimeKind.Unspecified); table.ColumnVarchar = $"ColumnVarChar:{1}"; table.ColumnInt = 1; table.ColumnDecimal2 = Convert.ToDecimal(1); table.ColumnDateTime = EpocDate; table.ColumnBlob = Encoding.Default.GetBytes($"ColumnBlob:{1}"); table.ColumnBlobAsArray = Encoding.Default.GetBytes($"ColumnBlobAsArray:{1}"); table.ColumnBinary = Encoding.Default.GetBytes($"ColumnBinary:{1}"); table.ColumnLongBlob = Encoding.Default.GetBytes($"ColumnLongBlob:{1}"); table.ColumnMediumBlob = Encoding.Default.GetBytes($"ColumnMediumBlob:{1}"); table.ColumnTinyBlob = Encoding.Default.GetBytes($"ColumnTinyBlob:{1}"); table.ColumnVarBinary = Encoding.Default.GetBytes($"ColumnVarBinary:{1}"); table.ColumnDate = EpocDate; table.ColumnDateTime2 = now; table.ColumnTime = EpocDate.AddHours(5).AddMinutes(7).AddSeconds(12).TimeOfDay; table.ColumnTimeStamp = now; table.ColumnYear = Convert.ToInt16(now.Year); //table.ColumnGeometry = Encoding.Default.GetBytes($"ColumnGeometry:{1}"); //table.ColumnLineString = Encoding.Default.GetBytes($"ColumnLineString:{1}"); //table.ColumnMultiLineString = Encoding.Default.GetBytes($"ColumnMultiLineString:{1}"); //table.ColumnMultiPoint = Encoding.Default.GetBytes($"ColumnMultiPoint:{1}"); //table.ColumnMultiPolygon = Encoding.Default.GetBytes($"ColumnMultiPolygon:{1}"); //table.ColumnPoint = Encoding.Default.GetBytes($"ColumnPoint:{1}"); //table.ColumnPolygon = Encoding.Default.GetBytes($"ColumnPolygon:{1}"); table.ColumnBigint = Convert.ToInt64(1); table.ColumnDecimal = Convert.ToDecimal(1); table.ColumnDouble = Convert.ToDouble(1); table.ColumnFloat = Convert.ToSingle(1); table.ColumnInt2 = 1; table.ColumnMediumInt = 1; table.ColumnReal = Convert.ToDouble(1); table.ColumnSmallInt = Convert.ToInt16(1); table.ColumnTinyInt = (SByte)1; table.ColumnChar = "C"; table.ColumnJson = "{\"Field\": \"Value\"}"; table.ColumnNChar = "C"; table.ColumnNVarChar = $"ColumnNVarChar:{1}"; table.ColumnLongText = $"ColumnLongText:{1}"; table.ColumnMediumText = $"ColumnMediumText:{1}"; table.ColumnText = $"ColumText:{1}"; table.ColumnTinyText = $"ColumnTinyText:{1}"; table.ColumnBit = (UInt64)1; }
/// <summary> /// Update the properties of <see cref="NonIdentityCompleteTable"/> instance. /// </summary> /// <param name="table">The instance to be updated.</param> public static void UpdateNonIdentityCompleteTableProperties(NonIdentityCompleteTable table) { var now = DateTime.SpecifyKind( DateTime.Parse(DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss.fffff")), DateTimeKind.Unspecified); table.ColumnBigInt = Convert.ToInt64(1); table.ColumnBoolean = (Randomizer.Next() % 2 != 0); table.ColumnCharacter = "C"; table.ColumnDate = now.Date; table.ColumnInteger = Convert.ToInt32(1); table.ColumnInterval = now.TimeOfDay; table.ColumMoney = Convert.ToDecimal(1); table.ColumName = $"ColumnName{1}"; table.ColumnReal = Convert.ToSingle(1); table.ColumnSmallInt = Convert.ToInt16(1); table.ColumnText = $"ColumnText{1}"; table.ColumnTimestampWithoutTimeZone = now; }
/// <summary> /// Update the properties of <see cref="NonIdentityCompleteTable"/> instance. /// </summary> /// <param name="table">The instance to be updated.</param> public static void UpdateNonIdentityCompleteTableProperties(NonIdentityCompleteTable table) { table.ColumnBigInt = long.MaxValue; table.ColumnBlob = Encoding.UTF32.GetBytes(Guid.NewGuid().ToString()); table.ColumnBoolean = true; table.ColumnChar = char.Parse("C").ToString(); table.ColumnDate = DateTime.SpecifyKind(DateTime.UtcNow, DateTimeKind.Unspecified).Date; table.ColumnDateTime = DateTime.SpecifyKind(DateTime.UtcNow, DateTimeKind.Unspecified); table.ColumnDecimal = Convert.ToDecimal(Randomizer.Next(1000000)); table.ColumnDouble = Convert.ToDouble(Randomizer.Next(1000000)); table.ColumnInt = Randomizer.Next(1000000); table.ColumnInteger = Convert.ToInt64(Randomizer.Next(1000000)); table.ColumnNumeric = Convert.ToDecimal(Randomizer.Next(1000000)); table.ColumnReal = Convert.ToSingle(Randomizer.Next(1000000)); table.ColumnString = $"{table.ColumnString} - Updated with {Guid.NewGuid().ToString()}"; table.ColumnText = $"{table.ColumnText} - Updated with {Guid.NewGuid().ToString()}"; table.ColumnTime = DateTime.SpecifyKind(DateTime.UtcNow, DateTimeKind.Unspecified); table.ColumnVarChar = $"{table.ColumnVarChar} - Updated with {Guid.NewGuid().ToString()}"; }
/// <summary> /// Update the properties of <see cref="NonIdentityCompleteTable"/> instance. /// </summary> /// <param name="table">The instance to be updated.</param> public static void UpdateNonIdentityCompleteTableProperties(NonIdentityCompleteTable table) { var now = DateTime.SpecifyKind( DateTime.Parse(DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss.fffff")), DateTimeKind.Unspecified); table.ColumnBigInt = Convert.ToInt64(2); table.ColumnBinary = (byte[])null; table.ColumnBit = true; table.ColumnChar = "C"; table.ColumnDate = now.Date; table.ColumnDateTime = now.Date; table.ColumnDateTime2 = now; table.ColumnDateTimeOffset = new DateTimeOffset(now.Date).ToOffset(TimeSpan.FromHours(2)); table.ColumnDecimal = Convert.ToDecimal(2); table.ColumnFloat = Convert.ToDouble(2); //table.ColumnGeography = (object)null; //table.ColumnGeometry = (object)null; //table.ColumnHierarchyId = (object)null; table.ColumnImage = (byte[])null; table.ColumnInt = Convert.ToInt32(2); table.ColumnMoney = Convert.ToDecimal(2); table.ColumnNChar = "C"; table.ColumnNText = "NText - Updated"; table.ColumnNumeric = Convert.ToDecimal(2); table.ColumnNVarChar = "NVarChar - Updated"; table.ColumnReal = Convert.ToSingle(2); table.ColumnSmallDateTime = now.Date; table.ColumnSmallInt = Convert.ToInt16(2); table.ColumnSmallMoney = Convert.ToDecimal(2); table.ColumnSqlVariant = (object)null; table.ColumnText = "Text - Updated"; table.ColumnTime = now.TimeOfDay; //table.ColumnTimestamp = (byte[])null; table.ColumnTinyInt = (byte)0; table.ColumnUniqueIdentifier = Guid.NewGuid(); table.ColumnVarBinary = (byte[])null; table.ColumnVarChar = "VarChar - Updated"; table.ColumnXml = (string)null; table.SessionId = Guid.NewGuid(); }