public IChangeSizeReport CreateChangeSizeReport()
{
var sqls = GetSqls(true);
var added = sqls.Item1;
var deleted = sqls.Item2;
//var modified = sqls.Item3;
using (var cmd = m_connection.CreateCommand())
{
cmd.Transaction = m_transaction;
var result = new ChangeSizeReport();
result.PreviousSize = ToInt64(cmd.ExecuteScalar(string.Format(@"SELECT SUM(""Size"") FROM ""{0}"" ", m_previousTable)));
result.CurrentSize = ToInt64(cmd.ExecuteScalar(string.Format(@"SELECT SUM(""Size"") FROM ""{0}"" ", m_currentTable)));
result.AddedSize = ToInt64(cmd.ExecuteScalar(string.Format(@"SELECT SUM(""Size"") FROM ""{0}"" WHERE ""{0}"".""Path"" IN ({1}) ", m_currentTable, added)));
result.DeletedSize = ToInt64(cmd.ExecuteScalar(string.Format(@"SELECT SUM(""Size"") FROM ""{0}"" WHERE ""{0}"".""Path"" IN ({1}) ", m_previousTable, deleted)));
return(result);
}
}
public IChangeSizeReport CreateChangeSizeReport()
{
var sqls = GetSqls(true);
var added = sqls.Item1;
var deleted = sqls.Item2;
//var modified = sqls.Item3;
using(var cmd = m_connection.CreateCommand())
{
cmd.Transaction = m_transaction;
var result = new ChangeSizeReport();
result.PreviousSize = cmd.ExecuteScalarInt64(string.Format(@"SELECT SUM(""Size"") FROM ""{0}"" ", m_previousTable), 0);
result.CurrentSize = cmd.ExecuteScalarInt64(string.Format(@"SELECT SUM(""Size"") FROM ""{0}"" ", m_currentTable), 0);
result.AddedSize = cmd.ExecuteScalarInt64(string.Format(@"SELECT SUM(""Size"") FROM ""{0}"" WHERE ""{0}"".""Path"" IN ({1}) ", m_currentTable, added), 0);
result.DeletedSize = cmd.ExecuteScalarInt64(string.Format(@"SELECT SUM(""Size"") FROM ""{0}"" WHERE ""{0}"".""Path"" IN ({1}) ", m_previousTable, deleted), 0);
return result;
}
}
