private static string GetCreateTableSpaceSqlTemplate(TableSpaceType tableSpaceType)
{
var tableSpace = tableSpaceType == TableSpaceType.Temp
? CreateTempTableSpaceSqlTemplate
: CreateDefaultTableSpaceSqlTemplate;
return(tableSpace);
}
public string GetTableSpaceName(TableSpaceType tableSpaceType)
{
var tableSpace = tableSpaceType == TableSpaceType.Temp
? DbMigrationConfig.TempTablespace
: DbMigrationConfig.DefaultTablespace;
return(tableSpace?.ToUpper());
}
public string GenerateCreateTableSpaceSql(TableSpaceType tableSpaceType)
{
var tableSpaceName = GetTableSpaceName(tableSpaceType);
if (string.IsNullOrEmpty(tableSpaceName))
{
return(null);
}
return(string.Format(GetCreateTableSpaceSqlTemplate(tableSpaceType), tableSpaceName));
}
private bool TableSpaceExists(TableSpaceType tableSpaceType)
{
var sql = ExtendedGenerator.GenerateTableSpaceExistsSql(tableSpaceType);
if (string.IsNullOrEmpty(sql))
{
return(true);
}
return(Exists(sql));
}
private void SetupTableSpace(TableSpaceType tableSpaceType)
{
if (TableSpaceExists(tableSpaceType))
{
return;
}
Logger.LogSay($"Creating Oracle {tableSpaceType} tablespace: {ExtendedGenerator.GetTableSpaceName(tableSpaceType)}...");
Process(ExtendedGenerator.GenerateCreateTableSpaceSql(tableSpaceType));
Logger.LogSay($"Created Oracle {tableSpaceType} tablespace: {ExtendedGenerator.GetTableSpaceName(tableSpaceType)}...");
}
private bool TableSpaceExists(TableSpaceType tableSpaceType)
{
return(Exists(ExtendedGenerator.GenerateTableSpaceExistsSql(tableSpaceType)));
}
public string GenerateCreateTableSpaceSql(TableSpaceType tableSpaceType)
{
throw new NotImplementedException();
}
public string GetTableSpaceName(TableSpaceType tableSpaceType)
{
throw new NotImplementedException();
}
public string GenerateCreateTableSpaceSql(TableSpaceType tableSpaceType)
{
return(string.Format(GetCreateTableSpaceSqlTemplate(tableSpaceType), GetTableSpaceName(tableSpaceType)));
}
public string GenerateTableSpaceExistsSql(TableSpaceType tableSpaceType)
{
return(string.Format(TableSpaceExistsSqlTemplate, GetTableSpaceName(tableSpaceType)));
}
