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