public string Convert(CSchema schema)
{
string[] parts = { schema.SchemaName };
var createSchemaStatement = new CreateSchemaStatement();
createSchemaStatement.Name = new Identifier {
Value = schema.SchemaName
};
//generate DDL
var script = new TSqlScript();
var batch = new TSqlBatch();
script.Batches.Add(batch);
batch.Statements.Add(createSchemaStatement);
var dacpacModel = new TSqlModel(SqlServerVersion.Sql120, new TSqlModelOptions());
var existing = dacpacModel.GetObject(Schema.TypeClass, new ObjectIdentifier(parts), DacQueryScopes.All);
if (existing != null)
{
return(existing.GetScript());
}
dacpacModel.AddObjects(script);
existing = dacpacModel.GetObject(Schema.TypeClass, new ObjectIdentifier(parts), DacQueryScopes.All);
return(existing.GetScript());
}
private string GetSchema()
{
var createSchema = new CreateSchemaStatement();
createSchema.Name = new Identifier(){Value = _procedureName};
createSchema.Owner = new Identifier(){Value = "dbo"};
return GenerateScript(createSchema);
}
public override void ExplicitVisit(CreateSchemaStatement node)
{
_buffer.Append("create schema ");
PgExpressionVisitor visitor = new PgExpressionVisitor(_buffer);
node.Name.Accept(visitor);
_buffer.Append(";");
_buffer.AppendLine();
}
private string GetSchema(string schemaName)
{
var createSchema = new CreateSchemaStatement();
createSchema.Name = new Identifier {
Value = schemaName.UnQuote(), QuoteType = QuoteType.SquareBracket
};
createSchema.Owner = new Identifier {
Value = "dbo"
};
return(GenerateScript(createSchema));
}
protected override void VisitCreateSchemaStatement(CreateSchemaStatement statement)
{
var schemaName = ResolveName(statement.Name);
State.Write(Symbols.CREATE);
State.Write(Symbols.SCHEMA);
if (statement.CheckIfNotExists)
{
State.Write(Symbols.IF);
State.Write(Symbols.NOT);
State.Write(Symbols.EXISTS);
}
State.Write(schemaName);
}
protected override void VisitCreateSchemaStatement(CreateSchemaStatement statement)
{
var schemaName = ResolveName(statement.Name);
State.Write(Symbols.CREATE);
State.Write(Symbols.SCHEMA);
if (statement.CheckIfNotExists)
{
State.Write(Symbols.IF);
State.Write(Symbols.NOT);
State.Write(Symbols.EXISTS);
}
State.Write(schemaName);
if (!string.IsNullOrWhiteSpace(statement.Owner))
{
State.Write(Symbols.AUTHORIZATION);
State.Write(this.IdentifierOpenQuote, statement.Owner, this.IdentifierCloseQuote);
}
}
private string GetSchema(string schemaName)
{
var createSchema = new CreateSchemaStatement();
createSchema.Name = new Identifier {Value = schemaName.UnQuote(), QuoteType = QuoteType.SquareBracket};
createSchema.Owner = new Identifier {Value = "dbo"};
return GenerateScript(createSchema);
}
public override void Visit(CreateSchemaStatement node) { this.action(node); }
public override void ExplicitVisit(CreateSchemaStatement fragment)
{
_fragments.Add(fragment);
}
protected abstract void VisitCreateSchemaStatement(CreateSchemaStatement statement);
protected override void VisitCreateSchemaStatement(CreateSchemaStatement statement)
{
throw new NotImplementedException();
}
public override void Visit(CreateSchemaStatement node)
{
Schemas.Add(new SqlSchema(node.Name.Value.UnQuote(), _path));
base.Visit(node);
}
