private void CreateFakeTableDefinition(ObjectIdentifier table)
{
var fakeTable = new ExecuteStatement();
fakeTable.ExecuteSpecification = new ExecuteSpecification();
var procedureReference = new ProcedureReference();
procedureReference.Name = new SchemaObjectName();
procedureReference.Name.Identifiers.Add("tSQLt".ToIdentifier());
procedureReference.Name.Identifiers.Add("FakeTable".ToIdentifier());
var entity = new ExecutableProcedureReference();
entity.ProcedureReference = new ProcedureReferenceName();
entity.ProcedureReference.ProcedureReference = procedureReference;
entity.Parameters.Add(
ParametersHelper.CreateStoredProcedureParameter(string.Format("{0}", table.GetSchema())));
entity.Parameters.Add(
ParametersHelper.CreateStoredProcedureParameter(string.Format("{0}", table.GetName())));
fakeTable.ExecuteSpecification.ExecutableEntity = entity;
_testProcedure.StatementList.Statements.Add(fakeTable);
}
public static SchemaObjectName ToSchemaObjectName(this ObjectIdentifier source)
{
var target = new SchemaObjectName();
target.Identifiers.Add(source.GetSchema().ToScriptDomIdentifier().Quote());
target.Identifiers.Add(source.GetName().ToScriptDomIdentifier().Quote());
return(target);
}
public static bool EqualsName(this ObjectIdentifier source, SchemaObjectName target)
{
if (target.SchemaIdentifier == null)
{
return(Quote.Name(source.GetName()) == Quote.Name(target.BaseIdentifier.Value));
}
return(Quote.Name(source.GetSchema()) == Quote.Name(target.SchemaIdentifier.Value) &&
Quote.Name(source.GetName()) == Quote.Name(target.BaseIdentifier.Value));
}
public static string GetSchemaObjectName(this ObjectIdentifier name)
{
return(string.Format("{0}.{1}", name.GetSchema(), name.GetName()));
}
private void CreateFakeTableDefinition(ObjectIdentifier table)
{
var fakeTable = new ExecuteStatement();
fakeTable.ExecuteSpecification = new ExecuteSpecification();
var procedureReference = new ProcedureReference();
procedureReference.Name = new SchemaObjectName();
procedureReference.Name.Identifiers.Add("tSQLt".ToIdentifier());
procedureReference.Name.Identifiers.Add("FakeTable".ToIdentifier());
var entity = new ExecutableProcedureReference();
entity.ProcedureReference = new ProcedureReferenceName();
entity.ProcedureReference.ProcedureReference = procedureReference;
entity.Parameters.Add(
ParametersHelper.CreateStoredProcedureParameter(string.Format("{0}", table.GetSchema())));
entity.Parameters.Add(
ParametersHelper.CreateStoredProcedureParameter(string.Format("{0}", table.GetName())));
fakeTable.ExecuteSpecification.ExecutableEntity = entity;
_testProcedure.StatementList.Statements.Add(fakeTable);
}
