public void NullUtils_GetNullOrDateTime_Value_Success() { DateTime?value = new DateTime(1981, 1, 21); Assert.AreEqual(new DateTime(1981, 1, 21), NullUtils.GetNullOrDateTime(value), "GetNullOrDateTime(value) did not return the expected value"); }
public void NullUtils_GetNullOrDouble_Value_Success() { double?value = 321D; Assert.AreEqual(321D, NullUtils.GetNullOrDouble(value), "GetNullOrDouble(value) did not return the expected value"); }
public void NullUtils_GetNullOrDecimal_Value_Success() { decimal?value = 444M; Assert.AreEqual(444M, NullUtils.GetNullOrDecimal(value), "GetNullOrDecimal(value) did not return the expected value"); }
public void NullUtils_GetBoolean_NotNull_Success() { var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(true)); reader.Read(); Assert.IsTrue(NullUtils.GetBoolean(reader, "unit_test"), "GetBoolean(true) should have returned true"); }
public void NullUtils_GetNullOrInt32_Value_Success() { Int32?value = 27; Assert.AreEqual(27, NullUtils.GetNullOrInt32(value), "GetNullOrInt32(value) did not return the expected value"); }
public void NullUtils_GetNullOrInt64_Value_Success() { Int64?value = 5L; Assert.AreEqual(5L, NullUtils.GetNullOrInt64(value), "GetNullOrInt64(value) did not return the expected value"); }
public void TestNullUtils() { var a = (decimal?)3.0; //1 var b = "3"; var c = (float?)null; //3 var d = (int?)null; var e = new Test123(); //5 Test123 f = null; var a1 = NullUtils.IsNullThen(a, val => val.Value + 1, 30); var a2 = NullUtils.IsNullThen(b, val => val + "1", "30"); var a3 = NullUtils.IsNullThen(c, val => val.Value + 1, 30); var a4 = NullUtils.IsNullThen(d, val => val.Value + 1, 30); var a5 = NullUtils.IsNullThen(e, val => new Test123 { Col1 = 11 }, new Test123 { Col1 = 30 }); var a6 = NullUtils.IsNullThen(f, val => new Test123 { Col1 = 11 }, new Test123 { Col1 = 30 }); Assert.AreEqual(a1.Value, 4); Assert.AreEqual(a2, "31"); Assert.AreEqual(a3.Value, 30); Assert.AreEqual(a4.Value, 30); Assert.AreEqual(a5.Col1, 11); Assert.AreEqual(a6.Col1, 30); }
public void NullUtils_GetNullOrInt16_Value_Success() { Int16?value = (short)12; Assert.AreEqual((short)12, NullUtils.GetNullOrInt16(value), "GetNullOrInt16(value) did not return the expected value"); }
public void NullUtils_GetNullOrFloat_Value_Success() { float?value = 291F; Assert.AreEqual(291F, NullUtils.GetNullOrFloat(value), "GetNullOrFloat(value) did not return the expected value"); }
public void NullUtils_GetDateTime_Value_Success() { var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(new DateTime(2004, 12, 13))); reader.Read(); Assert.AreEqual(new DateTime(2004, 12, 13), NullUtils.GetDateTime(reader, "unit_test"), "GetDateTime(value) should have returned a value"); }
public void NullUtils_GetDateTimeOrNull_Null_Success() { var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(DBNull.Value)); reader.Read(); Assert.IsNull(NullUtils.GetDateTimeOrNull(reader, "unit_test"), "GetDateTime(null) should have returned null"); }
public void NullUtils_GetString_Null_Success() { var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(DBNull.Value)); reader.Read(); Assert.AreEqual(String.Empty, NullUtils.GetString(reader, "unit_test"), "GetString(null) should have returned an empty string"); }
public void NullUtils_GetInt64_Value_Success() { var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(5L)); reader.Read(); Assert.AreEqual(5L, NullUtils.GetInt64(reader, "unit_test"), "GetInt64(value) did not return the expected value"); }
public void NullUtils_GetInt64_Null_Success() { var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(DBNull.Value)); reader.Read(); Assert.AreEqual(default(long), NullUtils.GetInt64(reader, "unit_test"), "GetInt64(null) should have returned the default long value"); }
public void NullUtils_GetInt16OrNull_Value_Success() { var reader = new StubDataReader(new StubResultSet("unit_test").AddRow((short)17)); reader.Read(); Assert.AreEqual((short)17, NullUtils.GetInt16OrNull(reader, "unit_test").Value, "GetInt16OrNull(value) did not return the expected value"); }
public void NullUtils_GetStringOrNull_Value_Success() { var reader = new StubDataReader(new StubResultSet("unit_test").AddRow("123")); reader.Read(); Assert.AreEqual("123", NullUtils.GetStringOrNull(reader, "unit_test"), "GetStringOrNull(value) did not return the expected value"); }
public void NullUtils_GetDateTime_Null_Success() { var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(DBNull.Value)); reader.Read(); Assert.AreEqual(default(DateTime), NullUtils.GetDateTime(reader, "unit_test"), "GetDateTime(null) should not have returned a default DateTime"); }
public void NullUtils_GetNullOrGuid_Value_Success() { var guid = Guid.NewGuid(); Guid?value = guid; Assert.AreEqual(guid, NullUtils.GetNullOrGuid(value), "GetNullOrGuid(value) did not return the expected value"); }
protected override TweetStatModel MapRow(SQLiteDataReader reader) { TweetStatModel model = new TweetStatModel(); model.Total = NullUtils.GetInt(reader, reader.GetOrdinal("total"), 0); return(model); }
public void NullUtils_GetGuidOrNull_Value_Success() { var guid = Guid.NewGuid(); var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(guid)); reader.Read(); Assert.AreEqual(guid, NullUtils.GetGuidOrNull(reader, "unit_test").Value, "GetGuidOrNull(value) did not return the expected value"); }
protected override EmojiModel MapRow(SQLiteDataReader reader) { EmojiModel model = new EmojiModel(); model.Total = NullUtils.GetInt(reader, reader.GetOrdinal("total"), 0); model.Emoji = NullUtils.GetString(reader, reader.GetOrdinal("emoji")); return(model); }
protected override HashtagModel MapRow(SQLiteDataReader reader) { HashtagModel model = new HashtagModel(); model.Total = NullUtils.GetInt(reader, reader.GetOrdinal("total"), 0); model.Tag = NullUtils.GetString(reader, reader.GetOrdinal("tag")); return(model); }
protected override UrlModel MapRow(SQLiteDataReader reader) { UrlModel model = new UrlModel(); model.Domain = NullUtils.GetString(reader, reader.GetOrdinal("hostname")); model.Total = NullUtils.GetInt(reader, reader.GetOrdinal("total"), 0); return(model); }
protected override MentionModel MapRow(SQLiteDataReader reader) { MentionModel model = new MentionModel(); model.Total = NullUtils.GetInt(reader, reader.GetOrdinal("total"), 0); model.User = NullUtils.GetString(reader, reader.GetOrdinal("user")); return(model); throw new NotImplementedException(); }
protected override LanguageModel MapRow(SQLiteDataReader reader) { LanguageModel model = new LanguageModel(); model.Total = NullUtils.GetInt(reader, reader.GetOrdinal("total"), 0); model.Language = NullUtils.GetString(reader, reader.GetOrdinal("language")); return(model); throw new NotImplementedException(); }
protected override TweetStatModel MapRow(SQLiteDataReader reader) { TweetStatModel tweetStats = new TweetStatModel(); decimal total = NullUtils.GetInt(reader, reader.GetOrdinal("total"), 0); tweetStats.TotalLikes = NullUtils.GetInt(reader, reader.GetOrdinal("totalLikes"), 0); tweetStats.TotalRetweet = NullUtils.GetInt(reader, reader.GetOrdinal("totalRetweets"), 0); decimal totalEmoji = NullUtils.GetInt(reader, reader.GetOrdinal("totalEmojis"), 0); decimal totalImages = NullUtils.GetInt(reader, reader.GetOrdinal("totalImages"), 0); decimal totalUrls = NullUtils.GetInt(reader, reader.GetOrdinal("totalUrls"), 0); int LastSecond = NullUtils.GetInt(reader, reader.GetOrdinal("lastSecond"), 0); int LastMinute = NullUtils.GetInt(reader, reader.GetOrdinal("lastMinute"), 0); int LastHour = NullUtils.GetInt(reader, reader.GetOrdinal("lastHour"), 0); if (total > 0) { var emojiPercent = (totalEmoji / total) * 100; tweetStats.PercentContainsEmoji = (int)emojiPercent; var imagePercent = (totalImages / total) * 100; tweetStats.PercentContainsImage = (int)imagePercent; var urlPercent = (totalUrls / total) * 100; tweetStats.PercentContainsUrl = (int)urlPercent; } tweetStats.Total = (int)total; List <AverageModel> averages = new List <AverageModel>(); AverageModel second = new AverageModel() { Title = "Second", Amount = LastSecond }; averages.Add(second); AverageModel minute = new AverageModel() { Title = "Minute", Amount = LastMinute }; averages.Add(minute); AverageModel hour = new AverageModel() { Title = "Hour", Amount = LastHour }; averages.Add(hour); tweetStats.Averages = averages; return(tweetStats); }
public void NullUtils_GetNullOrFloat_Null_Success() { float?value = null; Assert.IsNull(NullUtils.GetNullOrFloat(value), "GetNullOrFloat(null) should have returned null"); }
public void NullUtils_GetNullOrDouble_Null_Success() { double?value = null; Assert.IsNull(NullUtils.GetNullOrDouble(value), "GetNullOrDouble(null) should have returned null"); }
public void NullUtils_GetNullOrGuid_Null_Success() { Guid?value = null; Assert.IsNull(NullUtils.GetNullOrGuid(value), "GetNullOrGuid(null) should have returned null"); }
public void NullUtils_GetNullOrInt64_Null_Success() { Int64?value = null; Assert.IsNull(NullUtils.GetNullOrInt64(value), "GetNullOrInt64(null) should have returned null"); }