public Task <bool> InsertOrUpdateAsync(SearchWordModel model)
{
return(InsertOrUpdateAsync(model, null));
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env)
{
//if (env.IsDevelopment())
//{
// app.UseDeveloperExceptionPage();
// app.UseBrowserLink();
//}
//else
//{
// app.UseExceptionHandler("/Home/Error");
//}
app.UseStatusCodePages(ctx =>
{
ctx.HttpContext.Response.Redirect("/");
return(Task.CompletedTask);
});
app.UseLog4Net();
app.UseStaticFiles();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
routes.MapRoute("list", "list/{keyword}/{index}", new { controller = "list", action = "list", index = 1 }, new { keyword = ".+", index = "\\d+" });
routes.MapRoute("sortList", "list/{keyword}/{sort}/{index}", new { controller = "list", action = "list", index = 1 }, new { keyword = ".+", index = "\\d+", sort = "time|hot" });
routes.MapRoute("last", "last/{date}/{index}", new { controller = "list", action = "lastlist", index = 1 }, new { date = @"\d{4}-\d{2}-\d{2}", index = "\\d+" });
routes.MapRoute("lastest", "last/{index}", new { controller = "list", action = "lastestlist", index = 1 }, new { index = "\\d+" });
routes.MapRoute("detail", "infohash/{hash}.html", new { controller = "list", action = "detail" }, new { hash = "^[A-Za-z0-9]{40}$" });
routes.MapRoute("sitemap", "sitemap", new { controller = "home", action = "sitemap" });
});
app.UsePageHtmlStatic(async pageItem =>
{
var basePath = env.WebRootPath;
var filePath = pageItem.RequestPath.Trim('/');
var path = Path.Combine(basePath, filePath);
var fileInfo = new FileInfo(path);
if (fileInfo.Directory != null && !fileInfo.Directory.Exists)
{
fileInfo.Directory.Create();
}
using (var writer = fileInfo.OpenWrite())
{
await writer.WriteAsync(pageItem.Content, 0, pageItem.Content.Length);
}
});
var logger = LogManager.GetLogger(typeof(Startup));
Task.Run(async() =>
{
var wordQueue = app.ApplicationServices.GetService <IQueue <string> >();
var searchRepo = app.ApplicationServices.GetService <SearchWordRepository>();
while (true)
{
try
{
var searchWord = await wordQueue.DequeueAsync();
var item = new SearchWordModel()
{
Word = searchWord, Num = 1, SearchTime = DateTime.Now
};
await searchRepo.InsertOrUpdateAsync(item);
}
catch (Exception ex)
{
logger.Error("记录用户搜索关键字失败", ex);
}
}
});
Task.Run(async() =>
{
var visitQueue = app.ApplicationServices.GetService <IQueue <VisitedModel> >();
var visiteRepo = app.ApplicationServices.GetService <VisitedHistoryRepository>();
while (true)
{
try
{
var item = await visitQueue.DequeueAsync();
await visiteRepo.InsertOrUpdateAsync(item);
}
catch (System.Exception ex)
{
logger.Error("记录用户浏览历史失败", ex);
}
}
});
}
private async Task <bool> InsertOrUpdateAsync(SearchWordModel model, IDbTransaction transaction)
{
var sql = "INSERT INTO t_search_history AS t (word, num, last_search_time) VALUES (@word,@num,@time) ON CONFLICT(word) DO UPDATE SET num=t.num + @num ,last_search_time=@time;";
return(await Connection.ExecuteAsync(sql, new { word = model.Word, time = model.SearchTime, num = model.Num }, transaction) > 0);
}
