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