public virtual void InitializeDatabase()
{
var scriptReplacements = new Dictionary <string, string>()
{
{ "pref", _connectionSettings.Schema }
};
var scriptInitializer = new ScriptInitializer(typeof(InstallScripts), scriptReplacements);
scriptInitializer.ScriptManager.ThrowOnUnknownScriptTypes = false;
using (SenderDbContext context = GetDbContext())
{
var creator = (RelationalDatabaseCreator)context.Database.GetService <IDatabaseCreator>();
bool dbExists = creator.Exists();
if (dbExists)
{
bool tableExists = CheckTableExists(context);
if (tableExists == false)
{
ScriptExtractor.ExtractFromDbContext(context);
scriptInitializer.ExecuteScripts(context);
}
}
else
{
context.Database.EnsureCreated();
scriptInitializer.ExecuteScripts(context);
}
}
}
protected override Task <string> ExtractDdlAsync(CancellationToken cancellationToken)
{
return(ScriptExtractor.ExtractSchemaObjectScriptAsync(((TableDetailsModel)DataContext).Table, cancellationToken));
}
protected override Task <string> ExtractDdlAsync(CancellationToken cancellationToken)
{
return(ScriptExtractor.ExtractSchemaObjectScriptAsync(((MaterializedViewDetailsModel)DataContext).MaterializedView, cancellationToken));
}
protected override Task <string> ExtractDdlAsync(CancellationToken cancellationToken)
{
return(ScriptExtractor.ExtractNonSchemaObjectScriptAsync(Tablespace.Name, "TABLESPACE", cancellationToken));
}
protected override Task <string> ExtractDdlAsync(CancellationToken cancellationToken)
{
return(ScriptExtractor.ExtractSchemaObjectScriptAsync((OracleSequence)DataContext, cancellationToken));
}
protected override Task <string> ExtractDdlAsync(CancellationToken cancellationToken)
{
var dataModel = (OracleSchemaModel)DataContext;
return(ScriptExtractor.ExtractNonSchemaObjectScriptAsync(dataModel.Schema.Name.Trim('"'), "USER", cancellationToken));
}
protected override Task <string> ExtractDdlAsync(CancellationToken cancellationToken)
{
return(ScriptExtractor.ExtractNonSchemaObjectScriptAsync(Profile.Name, "PROFILE", cancellationToken));
}
protected override Task <string> ExtractDdlAsync(CancellationToken cancellationToken)
{
return(ScriptExtractor.ExtractSchemaObjectScriptAsync(((OracleProgramMetadata)DataContext).Owner, cancellationToken));
}
