public override string Translate(SqlCompilerContext context,
SequenceDescriptor descriptor, SequenceDescriptorSection section)
{
switch (section)
{
case SequenceDescriptorSection.RestartValue:
if (descriptor.StartValue.HasValue)
{
throw new NotSupportedException(Strings.ExAlterSequenceRestartWithIsNotSupported);
}
break;
case SequenceDescriptorSection.AlterMaxValue:
if (!descriptor.MaxValue.HasValue)
{
return("NOMAXVALUE");
}
break;
case SequenceDescriptorSection.AlterMinValue:
if (!descriptor.MinValue.HasValue)
{
return("NOMINVALUE");
}
break;
}
return(base.Translate(context, descriptor, section));
}
public static SqlAlterIdentityInfo Alter(
TableColumn column, SequenceDescriptor descriptor, SqlAlterIdentityInfoOptions infoOption)
{
ArgumentValidator.EnsureArgumentNotNull(column, "column");
ArgumentValidator.EnsureArgumentNotNull(descriptor, "info");
return(new SqlAlterIdentityInfo(column, descriptor, infoOption));
}
internal SqlAlterSequence(Sequence sequence, SequenceDescriptor sequenceDescriptor, SqlAlterIdentityInfoOptions infoOption)
: base(SqlNodeType.Alter)
{
this.sequence = sequence;
this.sequenceDescriptor = sequenceDescriptor;
this.infoOption = infoOption;
}
protected override void ReadSequenceDescriptor(DbDataReader reader, SequenceDescriptor descriptor)
{
descriptor.Increment = Convert.ToInt64(reader["seqincrement"]);
descriptor.IsCyclic = Convert.ToBoolean(reader["seqcycle"]);
descriptor.MinValue = Convert.ToInt64(reader["seqmin"]);
descriptor.MaxValue = Convert.ToInt64(reader["seqmax"]);
descriptor.StartValue = Convert.ToInt64(reader["seqstart"]);
}
/// <inheritdoc/>
public override string Translate(SqlCompilerContext context, SequenceDescriptor descriptor, SequenceDescriptorSection section)
{
//switch (section) {
// case SequenceDescriptorSection.Increment:
// if (descriptor.Increment.HasValue)
// return "AUTOINCREMENT";
// return string.Empty;
//}
return(string.Empty);
}
private void CreateSequence(Schema schema, StorageSequenceInfo sequenceInfo, string name)
{
var sequence = schema.CreateSequence(name);
var descriptor = new SequenceDescriptor(sequence, sequenceInfo.Seed, sequenceInfo.Increment)
{
MinValue = sequenceInfo.Seed
};
sequence.SequenceDescriptor = descriptor;
}
public override string Translate(SqlCompilerContext context, SequenceDescriptor descriptor, SequenceDescriptorSection section)
{
if (descriptor.Owner is Sequence)
{
return(TranslateSequenceDescriptorDefault(context, descriptor, section));
}
if (descriptor.Owner is TableColumn)
{
return(TranslateIdentityDescriptor(context, descriptor, section));
}
throw new NotSupportedException();
}
internal override object Clone(SqlNodeCloneContext context)
{
if (context.NodeMapping.ContainsKey(this))
{
return(context.NodeMapping[this]);
}
var clone = new SqlAlterIdentityInfo(Column, (SequenceDescriptor)SequenceDescriptor.Clone(), InfoOption);
context.NodeMapping[this] = clone;
return(clone);
}
protected string TranslateIdentityDescriptor(SqlCompilerContext context, SequenceDescriptor descriptor, SequenceDescriptorSection section)
{
switch (section)
{
case SequenceDescriptorSection.StartValue:
case SequenceDescriptorSection.RestartValue:
if (descriptor.StartValue.HasValue)
{
return("IDENTITY (" + descriptor.StartValue.Value + RowItemDelimiter);
}
return(String.Empty);
case SequenceDescriptorSection.Increment:
if (descriptor.Increment.HasValue)
{
return(descriptor.Increment.Value + ")");
}
return(String.Empty);
default:
return(String.Empty);
}
}
/// <inheritdoc/>
public override string Translate(SqlCompilerContext context, SequenceDescriptor descriptor,
SequenceDescriptorSection section)
{
switch (section)
{
case SequenceDescriptorSection.StartValue:
return(string.Empty);
case SequenceDescriptorSection.RestartValue:
if (descriptor.StartValue.HasValue)
{
return("RESTART WITH " + descriptor.StartValue.Value);
}
return(string.Empty);
case SequenceDescriptorSection.Increment:
return(string.Empty);
case SequenceDescriptorSection.MaxValue:
return(string.Empty);
case SequenceDescriptorSection.MinValue:
return(string.Empty);
case SequenceDescriptorSection.AlterMaxValue:
return(string.Empty);
case SequenceDescriptorSection.AlterMinValue:
return(string.Empty);
case SequenceDescriptorSection.IsCyclic:
return(string.Empty);
default:
return(string.Empty);
}
}
protected override void ReadSequenceDescriptor(DbDataReader reader, SequenceDescriptor descriptor)
{
base.ReadSequenceDescriptor(reader, descriptor);
descriptor.StartValue = Convert.ToInt64(reader["start_value"]);
}
/// <inheritdoc/>
/// <exception cref="NotSupportedException">Method is not supported.</exception>
protected override IPathNode VisitSequenceDescriptor(SequenceDescriptor sequenceDescriptor)
{
throw new NotSupportedException();
}
public override string Translate(SqlCompilerContext context, SequenceDescriptor descriptor, SequenceDescriptorSection section)
{
return(TranslateIdentityDescriptor(context, descriptor, section));
}
/// <inheritdoc/>
public override string Translate(SqlCompilerContext context, SequenceDescriptor descriptor,
SequenceDescriptorSection section)
{
return(string.Empty);
//throw new NotSupportedException(Strings.ExDoesNotSupportSequences);
}
internal SqlAlterIdentityInfo(TableColumn column, SequenceDescriptor sequenceDescriptor, SqlAlterIdentityInfoOptions infoOption)
{
Column = column;
SequenceDescriptor = sequenceDescriptor;
InfoOption = infoOption;
}
public static SqlAlterSequence Alter(Sequence sequence, SequenceDescriptor descriptor)
{
ArgumentValidator.EnsureArgumentNotNull(sequence, "sequence");
ArgumentValidator.EnsureArgumentNotNull(descriptor, "info");
return(new SqlAlterSequence(sequence, descriptor, SqlAlterIdentityInfoOptions.All));
}
