/// <summary>
/// Specifies MySQL TIMESTAMP data type for column.
/// </summary>
/// <param name="column">The column.</param>
/// <param name="precision">The precision of the data type.</param>
/// <returns>This column for fluent coding.</returns>
public static _DateTime AsMySqlTimestamp(this _DateTime column, int precision = 0)
{
column.VerifyNotNull(nameof(column));
VerifyTimePrecision(precision, nameof(precision));
column.SetMySqlType(MySqlType.Timestamp(column, precision));
return(column);
}
/// <summary>
/// Specifies SQL Server DATETIME2 data type for column.
/// </summary>
/// <param name="column">The column.</param>
/// <param name="precision">The precision of the data type.</param>
/// <returns>This column for fluent coding.</returns>
public static _DateTime AsSqlDateTime2(this _DateTime column, byte precision)
{
column.VerifyNotNull(nameof(column));
if (precision < MIN_DATETIME2_PRECISION || precision > MAX_DATETIME2_PRECISION)
{
throw new ArgumentOutOfRangeException(nameof(precision));
}
column.SetSqlType(SqlType.DateTime2(column, precision));
return(column);
}
public void TestMGetDaysTillEndOfMonth_01012016_30returned()
{
//arrange
DateTime date = new DateTime(2016, 1, 1);
int expected = 30;
//act
_DateTime x = new _DateTime(date);
int actual = x.GetDaysTillEndOfMonth();
//assert
Assert.AreEqual(expected, actual);
}
public static string formatTimeDelta(double delta)
{
var dt = new _DateTime(delta, KSPUtil.dateTimeFormatter.Year, KSPUtil.dateTimeFormatter.Day);
if (dt.years > 0)
{
return($"{dt.years}y {dt.days,3}d {dt.hours,2}:{dt.minutes:00}:{dt.seconds:00}");
}
if (dt.days > 0)
{
return($"{dt.days,3}d {dt.hours,2}:{dt.minutes:00}:{dt.seconds:00}");
}
return($"{dt.hours,2}:{dt.minutes:00}:{dt.seconds:00}");
}
public void Column_intercepted_MySqlType()
{
{
var binary = new _Binary().AsMySqlBinary(255);
VerifyMySqlType(MySqlVersion.LowestSupported, binary, MySqlDbType.Binary, 255, "BINARY(255)");
}
{
var varBinary = new _Binary().AsMySqlVarBinary(4000);
VerifyMySqlType(MySqlVersion.LowestSupported, varBinary, MySqlDbType.VarBinary, 4000, "VARBINARY(4000)");
}
{
var binary = new _Binary().AsMySqlTinyBlob();
VerifyMySqlType(MySqlVersion.LowestSupported, binary, MySqlDbType.TinyBlob, "TINYBLOB");
}
{
var binary = new _Binary().AsMySqlBlob();
VerifyMySqlType(MySqlVersion.LowestSupported, binary, MySqlDbType.Blob, "BLOB");
}
{
var binary = new _Binary().AsMySqlMediumBlob();
VerifyMySqlType(MySqlVersion.LowestSupported, binary, MySqlDbType.MediumBlob, "MEDIUMBLOB");
}
{
var binary = new _Binary().AsMySqlLongBlob();
VerifyMySqlType(MySqlVersion.LowestSupported, binary, MySqlDbType.LongBlob, "LONGBLOB");
}
{
var timestamp = new _DateTime().AsMySqlTimestamp();
VerifyMySqlType(MySqlVersion.LowestSupported, timestamp, MySqlDbType.Timestamp, "TIMESTAMP");
}
{
var decimalColumn = new _Decimal().AsMySqlDecimal(28, 8);
VerifyMySqlType(MySqlVersion.LowestSupported, decimalColumn, MySqlDbType.Decimal, "DECIMAL(28, 8)", 28, 8);
}
{
var money = new _Decimal().AsMySqlMoney();
VerifyMySqlType(MySqlVersion.LowestSupported, money, MySqlDbType.Decimal, "DECIMAL(19, 4)", 19, 4);
}
{
var date = new _DateTime().AsMySqlDate();
VerifyMySqlType(MySqlVersion.LowestSupported, date, MySqlDbType.Date, "DATE");
}
{
var time = new _DateTime().AsMySqlTime();
VerifyMySqlType(MySqlVersion.LowestSupported, time, MySqlDbType.Time, "TIME");
}
{
var dateTime = new _DateTime().AsMySqlDateTime();
VerifyMySqlType(MySqlVersion.LowestSupported, dateTime, MySqlDbType.DateTime, "DATETIME");
}
{
var charColumn = new _String().AsMySqlChar(255, "utf8mb4");
VerifyMySqlType(MySqlVersion.LowestSupported, charColumn, MySqlDbType.String, 255, "CHAR(255) CHARACTER SET utf8mb4");
}
{
var varchar = new _String().AsMySqlVarChar(512, "utf8mb4");
VerifyMySqlType(MySqlVersion.LowestSupported, varchar, MySqlDbType.VarString, 512, "VARCHAR(512) CHARACTER SET utf8mb4");
}
{
var singleChar = new _Char().AsMySqlChar();
VerifyMySqlType(MySqlVersion.LowestSupported, singleChar, MySqlDbType.String, 1, "CHAR(1)");
singleChar = new _Char().AsMySqlChar("utf8mb4");
VerifyMySqlType(MySqlVersion.LowestSupported, singleChar, MySqlDbType.String, 1, "CHAR(1) CHARACTER SET utf8mb4");
}
{
var text = new _String().AsMySqlTinyText("utf8mb4");
VerifyMySqlType(MySqlVersion.LowestSupported, text, MySqlDbType.TinyText, "TINYTEXT CHARACTER SET utf8mb4");
}
{
var text = new _String().AsMySqlText("utf8mb4");
VerifyMySqlType(MySqlVersion.LowestSupported, text, MySqlDbType.Text, "TEXT CHARACTER SET utf8mb4");
}
{
var text = new _String().AsMySqlMediumText("utf8mb4");
VerifyMySqlType(MySqlVersion.LowestSupported, text, MySqlDbType.MediumText, "MEDIUMTEXT CHARACTER SET utf8mb4");
}
{
var text = new _String().AsMySqlLongText("utf8mb4");
VerifyMySqlType(MySqlVersion.LowestSupported, text, MySqlDbType.LongText, "LONGTEXT CHARACTER SET utf8mb4");
}
}
/// <summary>
/// Specifies SQL Server DATETIME data type for column.
/// </summary>
/// <param name="column">The column.</param>
/// <returns>This column for fluent coding.</returns>
public static _DateTime AsSqlDateTime(this _DateTime column)
{
column.VerifyNotNull(nameof(column));
column.SetSqlType(SqlType.DateTime(column));
return(column);
}
public void Column_intercepted_SqlType()
{
{
var binary = new _Binary().AsSqlBinary(500);
VerifySqlType(SqlVersion.Sql13, binary, SqlDbType.Binary, 500, "BINARY(500)");
}
{
var binaryMax = new _Binary().AsSqlBinaryMax();
VerifySqlType(SqlVersion.Sql13, binaryMax, SqlDbType.Binary, -1, "BINARY(MAX)");
}
{
var varBinary = new _Binary().AsSqlVarBinary(225);
VerifySqlType(SqlVersion.Sql13, varBinary, SqlDbType.VarBinary, 225, "VARBINARY(225)");
}
{
var varBinaryMax = new _Binary().AsSqlVarBinaryMax();
VerifySqlType(SqlVersion.Sql13, varBinaryMax, SqlDbType.VarBinary, -1, "VARBINARY(MAX)");
}
{
var timestamp = new _Binary().AsSqlTimestamp();
VerifySqlType(SqlVersion.Sql13, timestamp, SqlDbType.Timestamp, "TIMESTAMP");
}
{
var decimalColumn = new _Decimal().AsSqlDecimal(28, 8);
VerifySqlType(SqlVersion.Sql13, decimalColumn, SqlDbType.Decimal, "DECIMAL(28, 8)", 28, 8);
}
{
var smallMoney = new _Decimal().AsSqlSmallMoney();
VerifySqlType(SqlVersion.Sql13, smallMoney, SqlDbType.SmallMoney, "SMALLMONEY");
}
{
var money = new _Decimal().AsSqlMoney();
VerifySqlType(SqlVersion.Sql13, money, SqlDbType.Money, "MONEY");
}
{
var date = new _DateTime().AsSqlDate();
VerifySqlType(SqlVersion.Sql13, date, SqlDbType.Date, "DATE");
}
{
var time = new _DateTime().AsSqlTime();
VerifySqlType(SqlVersion.Sql13, time, SqlDbType.Time, "TIME");
}
{
var dateTime = new _DateTime().AsSqlDateTime();
VerifySqlType(SqlVersion.Sql13, dateTime, SqlDbType.DateTime, "DATETIME");
}
{
var smallDateTime = new _DateTime().AsSqlSmallDateTime();
VerifySqlType(SqlVersion.Sql13, smallDateTime, SqlDbType.SmallDateTime, "SMALLDATETIME");
}
{
var dateTime2 = new _DateTime().AsSqlDateTime2(5);
VerifySqlType(SqlVersion.Sql13, dateTime2, SqlDbType.DateTime2, "DATETIME2(5)", 5);
}
{
var charColumn = new _String().AsSqlChar(478);
VerifySqlType(SqlVersion.Sql13, charColumn, SqlDbType.Char, 478, "CHAR(478)");
}
{
var charMax = new _String().AsSqlCharMax();
VerifySqlType(SqlVersion.Sql13, charMax, SqlDbType.Char, -1, "CHAR(MAX)");
}
{
var nchar = new _String().AsSqlNChar(333);
VerifySqlType(SqlVersion.Sql13, nchar, SqlDbType.NChar, 333, "NCHAR(333)");
}
{
var ncharMax = new _String().AsSqlNCharMax();
VerifySqlType(SqlVersion.Sql13, ncharMax, SqlDbType.NChar, -1, "NCHAR(MAX)");
}
{
var varchar = new _String().AsSqlVarChar(512);
VerifySqlType(SqlVersion.Sql13, varchar, SqlDbType.VarChar, 512, "VARCHAR(512)");
}
{
var varcharMax = new _String().AsSqlVarCharMax();
VerifySqlType(SqlVersion.Sql13, varcharMax, SqlDbType.VarChar, -1, "VARCHAR(MAX)");
}
{
var nvarchar = new _String().AsSqlNVarChar(1024);
VerifySqlType(SqlVersion.Sql13, nvarchar, SqlDbType.NVarChar, 1024, "NVARCHAR(1024)");
}
{
var nvarcharMax = new _String().AsSqlNVarCharMax();
VerifySqlType(SqlVersion.Sql13, nvarcharMax, SqlDbType.NVarChar, -1, "NVARCHAR(MAX)");
}
{
var singleChar = new _Char().AsSqlChar(true);
VerifySqlType(SqlVersion.Sql13, singleChar, SqlDbType.NChar, 1, "NCHAR(1)");
singleChar = new _Char().AsSqlChar(false);
VerifySqlType(SqlVersion.Sql13, singleChar, SqlDbType.Char, 1, "CHAR(1)");
}
}
