static void Main(string[] args)
{
_mlContext = new MLContext(seed: 0);
using (var contex = new TweetsDbContext())
{
_trainingDataView = _mlContext.Data.LoadFromEnumerable(contex.Tweets.ToList());
}
var pipeline = ProcessData();
var trainingPipeline = BuildAndTrainModel(_trainingDataView, pipeline);
Evaluate(_trainingDataView.Schema);
SaveModelAsFile(_mlContext, _trainingDataView.Schema, _trainedModel);
PredictIssue();
}
static async Task ExtractTweetsAsync()
{
IAuthorizer auth = DoSingleUserAuth();
await auth.AuthorizeAsync();
var twitterCtx = new TwitterContext(auth);
ulong lastTweetId = 0;
var tweetsAmount = 0;
while (tweetsAmount < 3200)
{
using (var context = new TweetsDbContext())
{
lastTweetId = await context.Tweets.CountAsync() > 0 ? (ulong)await context.Tweets.MaxAsync(tweet => tweet.TweetId) : 0;
var tweets = await SearchContext.DoSearchAsync(twitterCtx, lastTweetId);
if (tweets.Count <= 0)
{
break;
}
context.Tweets.AddRange(tweets);
await context.Database.OpenConnectionAsync();
try
{
await context.Database.ExecuteSqlInterpolatedAsync($"SET IDENTITY_INSERT dbo.Tweets ON");
await context.SaveChangesAsync();
await context.Database.ExecuteSqlInterpolatedAsync($"SET IDENTITY_INSERT dbo.Tweets OFF");
}
finally
{
await context.Database.CloseConnectionAsync();
}
tweetsAmount += tweets.Count;
}
}
}
static void Main(string[] args)
{
using (var context = new TweetsDbContext())
{
var uncategorizedTweets = context.Tweets.Where(tweet => tweet.Category == ServiceCategory.None).ToList();
if (uncategorizedTweets.Count <= 0)
{
return;
}
foreach (var tweet in uncategorizedTweets)
{
var category = ServiceCategory.None;
do
{
Console.WriteLine($"Tweet: {tweet.Text}");
Console.WriteLine($"\t0 - UserExperience");
Console.WriteLine($"\t1 - UserAttention");
Console.WriteLine($"\t2 - General");
Console.WriteLine($"\t3 - Tickets");
Console.WriteLine($"\tQ - To quit application");
Console.WriteLine("Press the category this tweet fit on");
var option = Console.ReadKey(true);
if (option.KeyChar == 'Q' || option.KeyChar == 'q')
{
break;
}
category = GetCategory(option);
} while (category == ServiceCategory.None);
if (category == ServiceCategory.None)
{
break;
}
tweet.Category = category;
}
context.SaveChanges();
}
}
public TweetsController()
{
contexto = new TweetsDbContext();
}
