private string GetExtendedProperty(string schemaName) { var execExtendedProperty = new ExecuteStatement(); execExtendedProperty.ExecuteSpecification = new ExecuteSpecification(); var name = new ChildObjectName(); name.Identifiers.Add(new Identifier { Value = _scripts }); var procedureReference = new ProcedureReference(); procedureReference.Name = "sp_addextendedproperty".ToSchemaObjectName(); var entity = new ExecutableProcedureReference(); entity.ProcedureReference = new ProcedureReferenceName(); entity.ProcedureReference.ProcedureReference = procedureReference; entity.Parameters.Add(ParametersHelper.CreateStoredProcedureParameter("@name", "tSQLt.TestClass")); entity.Parameters.Add(ParametersHelper.CreateStoredProcedureParameter("@value", 1)); entity.Parameters.Add(ParametersHelper.CreateStoredProcedureParameter("@level0type", "SCHEMA")); entity.Parameters.Add(ParametersHelper.CreateStoredProcedureParameter("@level0name", schemaName.UnQuote())); execExtendedProperty.ExecuteSpecification.ExecutableEntity = entity; return(GenerateScript(execExtendedProperty)); }
/// <summary> /// Create a SqlName from a ChildObjectName. /// </summary> /// <param name="name">the name to convert</param> /// <returns>a SqlName or null</returns> public static SqlName From(ChildObjectName name) { if (name is null) { return(null); } SqlName result = null; if (name.ServerIdentifier != null) { result = new SqlName(result, name.ServerIdentifier.Value, ObjectLevel.Server); } if ((name.DatabaseIdentifier != null) || (result != null)) { result = new SqlName(result, (name.DatabaseIdentifier?.Value) ?? string.Empty, ObjectLevel.Database); } if ((name.SchemaIdentifier != null) || (result != null)) { result = new SqlName(result, (name.SchemaIdentifier?.Value) ?? string.Empty, ObjectLevel.Schema); } if ((name.BaseIdentifier != null) || (result != null)) { result = new SqlName(result, (name.BaseIdentifier?.Value) ?? string.Empty, ObjectLevel.Object); } if ((name.ChildIdentifier != null) || (result != null)) { result = new SqlName(result, (name.ChildIdentifier?.Value) ?? string.Empty, ObjectLevel.Child); } return(result); }
private string GetExtendedProperty() { var execExtendedProperty = new ExecuteStatement(); execExtendedProperty.ExecuteSpecification = new ExecuteSpecification(); var name = new ChildObjectName(); name.Identifiers.Add(new Identifier(){Value = _procedureName}); var procedureReference = new ProcedureReference(); procedureReference.Name = "sp_addextendedproperty".ToSchemaObjectName(); var entity = new ExecutableProcedureReference(); entity.ProcedureReference = new ProcedureReferenceName(); entity.ProcedureReference.ProcedureReference = procedureReference; entity.Parameters.Add(ParametersHelper.CreateStoredProcedureParameter("@name", "tSQLt.TestClass")); entity.Parameters.Add(ParametersHelper.CreateStoredProcedureParameter("@value", 1)); entity.Parameters.Add(ParametersHelper.CreateStoredProcedureParameter("@level0type", "SCHEMA")); entity.Parameters.Add(ParametersHelper.CreateStoredProcedureParameter("@level0name", _procedureName)); execExtendedProperty.ExecuteSpecification.ExecutableEntity = entity; return GenerateScript(execExtendedProperty); }
public override void Visit(ChildObjectName node) { this.action(node); }
public override void ExplicitVisit(ChildObjectName fragment) { _fragments.Add(fragment); }