/// <summary>
/// Generate the SQL DELETE that deletes all rows
/// </summary>
/// <returns></returns>
protected override SqlCommandInfo GenerateDeleteString()
{
SqlDeleteBuilder delete = new SqlDeleteBuilder(Factory.Dialect, Factory)
.SetTableName(qualifiedTableName)
.SetIdentityColumn(KeyColumnNames, KeyType);
if (HasWhere)
delete.AddWhereFragment(sqlWhereString);
if (Factory.Settings.IsCommentsEnabled)
delete.SetComment("delete collection " + Role);
return delete.ToSqlCommandInfo();
}
public MultiTableDeleteExecutor(IStatement statement)
: base(statement, log)
{
if (!Factory.Dialect.SupportsTemporaryTables)
{
throw new HibernateException("cannot perform multi-table deletes using dialect not supporting temp tables");
}
var deleteStatement = (DeleteStatement) statement;
FromElement fromElement = deleteStatement.FromClause.GetFromElement();
string bulkTargetAlias = fromElement.TableAlias;
persister = fromElement.Queryable;
idInsertSelect = GenerateIdInsertSelect(persister, bulkTargetAlias, deleteStatement.WhereClause);
log.Debug("Generated ID-INSERT-SELECT SQL (multi-table delete) : " + idInsertSelect);
string[] tableNames = persister.ConstraintOrderedTableNameClosure;
string[][] columnNames = persister.ContraintOrderedTableKeyColumnClosure;
string idSubselect = GenerateIdSubselect(persister);
deletes = new SqlString[tableNames.Length];
for (int i = tableNames.Length - 1; i >= 0; i--)
{
// TODO : an optimization here would be to consider cascade deletes and not gen those delete statements;
// the difficulty is the ordering of the tables here vs the cascade attributes on the persisters ->
// the table info gotten here should really be self-contained (i.e., a class representation
// defining all the needed attributes), then we could then get an array of those
SqlDeleteBuilder delete = new SqlDeleteBuilder(Factory.Dialect, Factory)
.SetTableName(tableNames[i])
.SetWhere("(" + StringHelper.Join(", ", columnNames[i]) + ") IN (" + idSubselect + ")");
if (Factory.Settings.IsCommentsEnabled)
{
delete.SetComment("bulk delete");
}
deletes[i] = delete.ToSqlString();
}
}
protected SqlCommandInfo[] GenerateSQLDeleteStrings(object[] loadedState)
{
int span = TableSpan;
SqlCommandInfo[] deleteStrings = new SqlCommandInfo[span];
for (int j = span - 1; j >= 0; j--)
{
SqlDeleteBuilder delete = new SqlDeleteBuilder(Factory.Dialect, Factory)
.SetTableName(GetTableName(j))
.SetIdentityColumn(GetKeyColumns(j), IdentifierType);
if (Factory.Settings.IsCommentsEnabled)
{
delete.SetComment("delete " + EntityName + " [" + j + "]");
}
bool[] versionability = PropertyVersionability;
IType[] types = PropertyTypes;
for (int i = 0; i < entityMetamodel.PropertySpan; i++)
{
bool include = versionability[i] &&
IsPropertyOfTable(i, j);
if (include)
{
// this property belongs to the table and it is not specifically
// excluded from optimistic locking by optimistic-lock="false"
string[] _propertyColumnNames = GetPropertyColumnNames(i);
bool[] propertyNullness = types[i].ToColumnNullness(loadedState[i], Factory);
SqlType[] sqlt = types[i].SqlTypes(Factory);
for (int k = 0; k < propertyNullness.Length; k++)
{
if (propertyNullness[k])
{
delete.AddWhereFragment(_propertyColumnNames[k], sqlt[k], " = ");
}
else
{
delete.AddWhereFragment(_propertyColumnNames[k] + " is null");
}
}
}
}
deleteStrings[j] = delete.ToSqlCommandInfo();
}
return deleteStrings;
}
protected virtual SqlCommandInfo GenerateDeleteString(int j)
{
var deleteBuilder = new SqlDeleteBuilder(Factory.Dialect, Factory);
deleteBuilder
.SetTableName(GetTableName(j))
.SetIdentityColumn(GetKeyColumns(j), IdentifierType);
// NH: Only add version to where clause if optimistic lock mode is Version
if (j == 0 && IsVersioned && entityMetamodel.OptimisticLockMode == Versioning.OptimisticLock.Version)
{
deleteBuilder.SetVersionColumn(new[] { VersionColumnName }, VersionType);
}
if (Factory.Settings.IsCommentsEnabled)
{
deleteBuilder.SetComment("delete " + EntityName);
}
return deleteBuilder.ToSqlCommandInfo();
}
protected SqlCommandInfo GenerateDeleteString(int j)
{
SqlDeleteBuilder deleteBuilder = new SqlDeleteBuilder(Factory.Dialect, Factory);
deleteBuilder
.SetTableName(GetTableName(j))
.SetIdentityColumn(GetKeyColumns(j), IdentifierType);
if (j == 0 && IsVersioned)
{
deleteBuilder.SetVersionColumn(new string[] { VersionColumnName }, VersionType);
}
if (Factory.Settings.IsCommentsEnabled)
{
deleteBuilder.SetComment("delete " + EntityName);
}
return deleteBuilder.ToSqlCommandInfo();
}
/// <summary>
/// Generate the SQL DELETE that deletes a particular row
/// </summary>
/// <returns></returns>
protected override SqlCommandInfo GenerateDeleteRowString()
{
SqlDeleteBuilder delete = new SqlDeleteBuilder(Factory.Dialect, Factory);
delete.SetTableName(qualifiedTableName);
if (hasIdentifier)
{
delete.AddWhereFragment(new string[] { IdentifierColumnName }, IdentifierType, " = ");
}
else if (HasIndex && !indexContainsFormula)
{
delete
.AddWhereFragment(KeyColumnNames, KeyType, " = ")
.AddWhereFragment(IndexColumnNames, IndexType, " = ");
}
else
{
string[] cnames = ArrayHelper.Join(KeyColumnNames, ElementColumnNames, elementColumnIsInPrimaryKey);
SqlType[] ctypes = ArrayHelper.Join(KeyType.SqlTypes(Factory), ElementType.SqlTypes(Factory), elementColumnIsInPrimaryKey);
delete.AddWhereFragment(cnames, ctypes, " = ");
}
if (Factory.Settings.IsCommentsEnabled)
delete.SetComment("delete collection row " + Role);
return delete.ToSqlCommandInfo();
}
