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