public int CreateOrUpdateStats(string ticket, TransitBrowser[] t_browsers, TransitReferrerHost[] t_rhs, TransitReferrerSearchQuery[] t_rsqs)
{
using (DBlog.Data.Hibernate.Session.OpenConnection(GetNewConnection()))
{
ISession session = DBlog.Data.Hibernate.Session.Current;
int increment = 0;
if (t_browsers != null)
{
if (t_browsers.Length > increment) increment = t_browsers.Length;
foreach (TransitBrowser t_browser in t_browsers)
{
Browser browser = t_browser.GetBrowser(session);
session.SaveOrUpdate(browser);
}
}
if (t_rhs != null)
{
if (t_rhs.Length > increment) increment = t_rhs.Length;
foreach (TransitReferrerHost t_rh in t_rhs)
{
ReferrerHost rh = t_rh.GetReferrerHost(session);
session.SaveOrUpdate(rh);
}
}
if (t_rsqs != null)
{
if (t_rsqs.Length > increment) increment = t_rsqs.Length;
foreach (TransitReferrerSearchQuery t_rsq in t_rsqs)
{
ReferrerSearchQuery rsq = t_rsq.GetReferrerSearchQuery(session);
session.SaveOrUpdate(rsq);
}
}
TransitCounter.IncrementCounters(session, increment);
session.Flush();
return Math.Max(t_browsers.Length, t_rhs.Length);
}
}
public void Flush(SessionManager manager)
{
if (mRequests == null)
return;
List<TransitBrowser> browsers = new List<TransitBrowser>();
List<TransitReferrerHost> rhs = new List<TransitReferrerHost>();
List<TransitReferrerSearchQuery> rsqs = new List<TransitReferrerSearchQuery>();
// TODO: use a unique sorted collection
foreach(HttpRequest request in mRequests)
{
try
{
if (request.Browser != null)
{
TransitBrowser browser = new TransitBrowser();
browser.Name = request.Browser.Browser;
browser.Platform = request.Browser.Platform;
browser.Version = request.Browser.Version;
browsers.Add(browser);
}
string host = string.Empty;
try
{
host = request.Url.Host;
}
catch (ArgumentException)
{
// host isn't available on localhost
}
string urlreferrer = string.Empty;
try
{
if (request.UrlReferrer != null)
{
urlreferrer = request.UrlReferrer.Host;
}
}
catch (ArgumentException)
{
// referrer host not available
}
// don't track navigation between pages
if (! string.IsNullOrEmpty(urlreferrer) && urlreferrer != host)
{
TransitReferrerHost rh = new TransitReferrerHost();
rh.Name = request.UrlReferrer.Host;
rh.LastSource = request.UrlReferrer.ToString();
rh.LastUrl = request.RawUrl;
rh.RequestCount = 1;
rhs.Add(rh);
string q = request.QueryString["q"];
if (string.IsNullOrEmpty(q)) q = request.QueryString["s"];
if (string.IsNullOrEmpty(q)) q = request.QueryString["search"];
if (string.IsNullOrEmpty(q)) q = request.QueryString["query"];
if (!string.IsNullOrEmpty(q))
{
TransitReferrerSearchQuery trsq = new TransitReferrerSearchQuery();
trsq.RequestCount = 1;
trsq.SearchQuery = q;
rsqs.Add(trsq);
}
}
}
catch (Exception ex)
{
manager.BlogService.EventLogWriteEntry(string.Format("CreateOrUpdateStats for a single request failed. {0}",
ex.Message), EventLogEntryType.Warning);
}
}
try
{
manager.BlogService.CreateOrUpdateStats(
manager.Ticket, browsers.ToArray(), rhs.ToArray(), rsqs.ToArray());
}
catch (Exception ex)
{
manager.BlogService.EventLogWriteEntry(string.Format("CreateOrUpdateStats failed. {0}",
ex.Message), EventLogEntryType.Error);
}
mRequests = new List<HttpRequest>();
try
{
manager.BlogService.IncrementPostCounters(manager.Ticket, mPostCounters.ToArray());
}
catch (Exception ex)
{
manager.BlogService.EventLogWriteEntry(string.Format("IncrementPostCounters failed. {0}",
ex.Message), EventLogEntryType.Error);
}
mPostCounters = new List<int>();
try
{
manager.BlogService.IncrementImageCounters(manager.Ticket, mImageCounters.ToArray());
}
catch (Exception ex)
{
manager.BlogService.EventLogWriteEntry(string.Format("IncrementImageCounters failed. {0}",
ex.Message), EventLogEntryType.Error);
}
mImageCounters = new List<int>();
LastFlush = DateTime.UtcNow;
}
public int CreateOrUpdateReferrerSearchQuery(string ticket, TransitReferrerSearchQuery t_referrersearchquery)
{
using (DBlog.Data.Hibernate.Session.OpenConnection(GetNewConnection()))
{
ISession session = DBlog.Data.Hibernate.Session.Current;
CheckAdministrator(session, ticket);
ReferrerSearchQuery referrersearchquery = t_referrersearchquery.GetReferrerSearchQuery(session);
session.SaveOrUpdate(referrersearchquery);
session.Flush();
return referrersearchquery.Id;
}
}
