Пример #1
0
 public IEnumerable <IBlockWithSources> GetSourceFilesWithBlocks(long blocksize)
 {
     using (var cmd = m_connection.CreateCommand(m_transaction.Parent))
         using (var rd = cmd.ExecuteReader(string.Format(@"SELECT DISTINCT ""{0}"".""Hash"", ""{0}"".""Size"", ""File"".""Path"", ""BlocksetEntry"".""Index"" * {1} FROM  ""{0}"", ""Block"", ""BlocksetEntry"", ""File"" WHERE ""File"".""BlocksetID"" = ""BlocksetEntry"".""BlocksetID"" AND ""Block"".""ID"" = ""BlocksetEntry"".""BlockID"" AND ""{0}"".""Hash"" = ""Block"".""Hash"" AND ""{0}"".""Size"" = ""Block"".""Size"" AND ""{0}"".""Restored"" = ? ", m_tablename, blocksize), 0))
             if (rd.Read())
             {
                 var bs = new BlockWithSources(rd);
                 while (!bs.Done)
                 {
                     yield return((IBlockWithSources)bs);
                 }
             }
 }
Пример #2
0
 public IEnumerable<IBlockWithSources> GetSourceFilesWithBlocks(long blocksize)
 {
     using(var cmd = m_connection.CreateCommand(m_transaction.Parent))
         using(var rd = cmd.ExecuteReader(string.Format(@"SELECT DISTINCT ""{0}"".""Hash"", ""{0}"".""Size"", ""File"".""Path"", ""BlocksetEntry"".""Index"" * {1} FROM  ""{0}"", ""Block"", ""BlocksetEntry"", ""File"" WHERE ""File"".""BlocksetID"" = ""BlocksetEntry"".""BlocksetID"" AND ""Block"".""ID"" = ""BlocksetEntry"".""BlockID"" AND ""{0}"".""Hash"" = ""Block"".""Hash"" AND ""{0}"".""Size"" = ""Block"".""Size"" AND ""{0}"".""Restored"" = ? ", m_tablename, blocksize), 0))
             if (rd.Read())
             {
                 var bs = new BlockWithSources(rd);
                 while (!bs.Done)
                     yield return (IBlockWithSources)bs;
             }
 }