public IChangeCountReport CreateChangeCountReport()
{
var sqls = GetSqls(false);
var added = @"SELECT COUNT(*) FROM (" + sqls.Item1 + ")";
var deleted = @"SELECT COUNT(*) FROM (" + sqls.Item2 + ")";
var modified = @"SELECT COUNT(*) FROM (" + sqls.Item3 + ")";
using (var cmd = m_connection.CreateCommand())
{
cmd.Transaction = m_transaction;
var result = new ChangeCountReport();
result.AddedFolders = ToInt64(cmd.ExecuteScalar(added, (int)Library.Interface.ListChangesElementType.Folder));
result.AddedSymlinks = ToInt64(cmd.ExecuteScalar(added, (int)Library.Interface.ListChangesElementType.Symlink));
result.AddedFiles = ToInt64(cmd.ExecuteScalar(added, (int)Library.Interface.ListChangesElementType.File));
result.DeletedFolders = ToInt64(cmd.ExecuteScalar(deleted, (int)Library.Interface.ListChangesElementType.Folder));
result.DeletedSymlinks = ToInt64(cmd.ExecuteScalar(deleted, (int)Library.Interface.ListChangesElementType.Symlink));
result.DeletedFiles = ToInt64(cmd.ExecuteScalar(deleted, (int)Library.Interface.ListChangesElementType.File));
result.ModifiedFolders = ToInt64(cmd.ExecuteScalar(modified, (int)Library.Interface.ListChangesElementType.Folder));
result.ModifiedSymlinks = ToInt64(cmd.ExecuteScalar(modified, (int)Library.Interface.ListChangesElementType.Symlink));
result.ModifiedFiles = ToInt64(cmd.ExecuteScalar(modified, (int)Library.Interface.ListChangesElementType.File));
return(result);
}
}
public IChangeCountReport CreateChangeCountReport()
{
var sqls = GetSqls(false);
var added = @"SELECT COUNT(*) FROM (" + sqls.Item1 + ")";
var deleted = @"SELECT COUNT(*) FROM (" + sqls.Item2 + ")";
var modified = @"SELECT COUNT(*) FROM (" + sqls.Item3 + ")";
using(var cmd = m_connection.CreateCommand())
{
cmd.Transaction = m_transaction;
var result = new ChangeCountReport();
result.AddedFolders = cmd.ExecuteScalarInt64(added, 0, (int)Library.Interface.ListChangesElementType.Folder);
result.AddedSymlinks = cmd.ExecuteScalarInt64(added, 0, (int)Library.Interface.ListChangesElementType.Symlink);
result.AddedFiles = cmd.ExecuteScalarInt64(added, 0, (int)Library.Interface.ListChangesElementType.File);
result.DeletedFolders = cmd.ExecuteScalarInt64(deleted, 0, (int)Library.Interface.ListChangesElementType.Folder);
result.DeletedSymlinks = cmd.ExecuteScalarInt64(deleted, 0, (int)Library.Interface.ListChangesElementType.Symlink);
result.DeletedFiles = cmd.ExecuteScalarInt64(deleted, 0, (int)Library.Interface.ListChangesElementType.File);
result.ModifiedFolders = cmd.ExecuteScalarInt64(modified, 0, (int)Library.Interface.ListChangesElementType.Folder);
result.ModifiedSymlinks = cmd.ExecuteScalarInt64(modified, 0, (int)Library.Interface.ListChangesElementType.Symlink);
result.ModifiedFiles = cmd.ExecuteScalarInt64(modified, 0, (int)Library.Interface.ListChangesElementType.File);
return result;
}
}
