protected override TweetStatModel MapRow(SQLiteDataReader reader)
{
TweetStatModel model = new TweetStatModel();
model.Total = NullUtils.GetInt(reader, reader.GetOrdinal("total"), 0);
return(model);
}
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 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 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 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);
}
