/// <summary>
/// Closes the file.
/// </summary>
public override void Close()
{
_indexInput.Close();
_indexInput = null;
_sqlServerDirectory = null;
GC.SuppressFinalize(this);
}
/// <summary>
/// Initializes a new instance of the <see cref="SqlIndexOutput"/> class.
/// </summary>
/// <param name="sqlServerDirectory">The SQL server directory.</param>
/// <param name="sqlStorageProviderUtility">The SQL storage provider utility.</param>
/// <param name="connString">The connection string.</param>
/// <param name="wiki">The wiki.</param>
/// <param name="fileName">The name of the file.</param>
public SqlIndexOutput(SqlDirectory sqlServerDirectory, ISqlStorageProviderUtility sqlStorageProviderUtility, string connString, string wiki, string fileName)
{
_sqlServerDirectory = sqlServerDirectory;
_sqlStorageProviderUtility = sqlStorageProviderUtility;
_connString = connString;
_wiki = wiki;
_fileName = fileName;
// create the local cache one we will operate against...
_indexOutput = CacheDirectory.CreateOutput(_fileName);
}
/// <summary>
/// Initializes a new instance of the <see cref="SqlIndexInput"/> class.
/// </summary>
/// <param name="cloneInput">The clone input.</param>
public SqlIndexInput(SqlIndexInput cloneInput)
{
try {
_sqlServerDirectory = cloneInput._sqlServerDirectory;
_sqlStorageProviderUtility = cloneInput._sqlStorageProviderUtility;
_indexInput = cloneInput._indexInput.Clone() as IndexInput;
}
catch (Exception)
{
// sometimes we get access denied on the 2nd stream...but not always. I haven't tracked it down yet
// but this covers our tail until I do
}
}
/// <summary>
/// Initializes a new instance of the <see cref="SqlIndexInput"/> class.
/// </summary>
/// <param name="sqlServerDirectory">The Sql Server Directory object.</param>
/// <param name="sqlStorageProviderUtility">The SQL storage provider utility.</param>
/// <param name="connString">The connection string.</param>
/// <param name="wiki">The wiki.</param>
/// <param name="name">The name of the file.</param>
public SqlIndexInput(SqlDirectory sqlServerDirectory, ISqlStorageProviderUtility sqlStorageProviderUtility, string connString, string wiki, string name)
{
_sqlServerDirectory = sqlServerDirectory;
_sqlStorageProviderUtility = sqlStorageProviderUtility;
bool fFileNeeded = false;
if (!CacheDirectory.FileExists(name))
{
fFileNeeded = true;
}
if (name.Contains("segments"))
{
fFileNeeded = true;
}
if (fFileNeeded)
{
StreamOutput fileStream = _sqlServerDirectory.CreateCachedOutputAsStream(name);
ICommandBuilder builder = _sqlStorageProviderUtility.GetCommandBuilder2();
DbConnection connection = builder.GetConnection(connString);
DbTransaction transaction = _sqlStorageProviderUtility.BeginTransaction(connection);
if (!FileExists(transaction, wiki, name))
{
_sqlStorageProviderUtility.RollbackTransaction(transaction);
_sqlStorageProviderUtility.CloseDbConnection(connection);
throw new FileNotFoundException();
}
QueryBuilder queryBuilder = new QueryBuilder(builder);
string query = queryBuilder.SelectFrom("SearchIndex", new string[] { "Size", "Data" });
query = queryBuilder.Where(query, "Wiki", WhereOperator.Equals, "Wiki");
query = queryBuilder.AndWhere(query, "Name", WhereOperator.Equals, "Name");
List <Parameter> parameters = new List <Parameter>(2);
parameters.Add(new Parameter(ParameterType.String, "Wiki", wiki));
parameters.Add(new Parameter(ParameterType.String, "Name", name));
DbCommand command = builder.GetCommand(transaction, query, parameters);
DbDataReader reader = _sqlStorageProviderUtility.ExecuteReader(command);
if (reader != null)
{
bool done = false;
if (reader.Read())
{
int read = _sqlStorageProviderUtility.ReadBinaryColumn(reader, "Data", fileStream);
done = (long)read == (long)reader["Size"];
}
_sqlStorageProviderUtility.CloseReader(reader);
if (!done)
{
_sqlStorageProviderUtility.RollbackTransaction(transaction);
}
_sqlStorageProviderUtility.CommitTransaction(transaction);
}
else
{
_sqlStorageProviderUtility.RollbackTransaction(transaction);
}
fileStream.Flush();
fileStream.Close();
// and open it as an input
_indexInput = CacheDirectory.OpenInput(name);
}
else
{
_indexInput = CacheDirectory.OpenInput(name);
}
}
