protected override void TruncateTables(Sql.ManagementSession session, SchemaTable table)
{
var sql = new StringBuilder();
sql.Append("TRUNCATE TABLE " + table.StatementName);
session.ExecuteSql(sql.ToString());
}
protected override void CreateTable(Sql.ManagementSession session, SchemaTable schemaTable)
{
var keys = new List <SchemaColumn>();
var sql = new StringBuilder();
sql.Append("CREATE TABLE " + schemaTable.StatementName);
sql.Append("(");
foreach (SchemaColumn column in schemaTable)
{
sql.Append(column.StatementName + " " + this.GetSqlType(column));
if (column.IsKey)
{
keys.Add(column);
}
sql.Append(",\n");
}
sql.Append("CONSTRAINT " + schemaTable.Name + "_pk PRIMARY KEY ( ");
for (int i = 0; i < keys.Count; i++)
{
if (i > 0)
{
sql.Append(", ");
}
sql.Append(keys[i].Name);
}
sql.Append(" )\n");
sql.Append(")");
session.ExecuteSql(sql.ToString());
}
protected override void DropTable(Sql.ManagementSession session, SchemaTable schemaTable)
{
var sql = new StringBuilder();
sql.Append(
@"DROP TABLE IF EXISTS " + schemaTable + " CASCADE;");
session.ExecuteSql(sql.ToString());
}
protected override void ResetSequence(Sql.ManagementSession session)
{
//var sql = new StringBuilder();
//sql.Append("DROP SEQUENCE IF EXISTS " + this.Schema.Objects.Name + "_SEQ");
//session.ExecuteSql(sql.ToString());
//sql = new StringBuilder();
//sql.Append("CREATE SEQUENCE " + this.Schema.Objects.Name + "_SEQ");
//session.ExecuteSql(sql.ToString());
}
public override void DropIndex(Sql.ManagementSession session, SchemaTable table, SchemaColumn column)
{
var indexName = Sql.Schema.AllorsPrefix + table.Name + "_" + column.Name;
try
{
var sql = new StringBuilder();
sql.Append("DROP INDEX IF EXISTS " + indexName);
session.ExecuteSql(sql.ToString());
}
catch (Exception e)
{
throw new Exception("Could not drop index " + indexName, e);
}
}
protected override void CreateIndex(Sql.ManagementSession session, SchemaTable table, SchemaColumn column)
{
var indexName = Sql.Schema.AllorsPrefix + table.Name + "_" + column.Name;
if (column.IndexType == SchemaIndexType.Single)
{
var sql = new StringBuilder();
sql.Append("CREATE INDEX " + indexName + "\n");
sql.Append("ON " + table + " (" + column + ")");
session.ExecuteSql(sql.ToString());
}
else
{
var sql = new StringBuilder();
sql.Append("CREATE INDEX " + indexName + "\n");
sql.Append("ON " + table + " (" + column + ", " + table.FirstKeyColumn + ")");
session.ExecuteSql(sql.ToString());
}
}
protected override void CreateProcedure(Sql.ManagementSession session, SchemaProcedure storedProcedure)
{
session.ExecuteSql(storedProcedure.Definition);
}
protected override void DropProcedures(Sql.ManagementSession session)
{
}
protected override void DropUserDefinedTypes(Sql.ManagementSession session)
{
}
