public static int GetNumberOfRows()
{
var session = FluentNHibernateHelper.OpenSession();
return(session.QueryOver <ScoredHandle>()
.Select(Projections.RowCount())
.FutureValue <int>()
.Value);
}
public static void BatchInsertRecords(IEnumerable <TwitterHandle> scoredHandles)
{
var handles = GetScoredHandlesList(scoredHandles);
var insertedHandles = new List <string>();
var session = FluentNHibernateHelper.OpenStatelessSession();
using (session)
{
Console.WriteLine(@"Received {0} handles for insert.", handles.Count());
Console.WriteLine(@"Records before insert: " + GetNumberOfRows());
session.SetBatchSize(handles.Count);
var inserted = 0;
foreach (var handle in handles)
{
try
{
session.Insert(handle);
inserted++;
insertedHandles.Add(handle.Username);
}
catch (GenericADOException ex)
{
var errorMessage = ex.InnerException.ToString().Contains("Cannot insert duplicate key") ? string.Format("Duplicate handle '{0}' not inserted.", handle.Username) : string.Format("Error when inserting handle '{0}' : {1} : {2}", handle.Username, ex.Message, ex.InnerException);
Console.WriteLine(errorMessage);
}
}
Console.WriteLine(@"Inserted {0} handles.", inserted);
Console.WriteLine(@"Records after insert: " + GetNumberOfRows());
var handlesNotInserted = handles.Select(h => h.Username).Except(insertedHandles);
var notInserted = handlesNotInserted as IList <string> ?? handlesNotInserted.ToList();
Console.WriteLine(@"{0} handles not inserted.", notInserted.Count());
foreach (var h in notInserted)
{
Console.WriteLine(h);
}
}
}