private string GenerateSqlStatementConcrete(AddPrimaryKeyOperation migrationOperation)
{
// Actually primary key creation is supported only during table creation
var ddlBuilder = new SQLiteDdlBuilder();
ddlBuilder.AppendSql(" PRIMARY KEY (");
ddlBuilder.AppendIdentifierList(migrationOperation.Columns);
ddlBuilder.AppendSql(")");
return(ddlBuilder.GetCommandText());
}
private string GenerateSqlStatementConcrete(CreateIndexOperation migrationOperation)
{
SQLiteDdlBuilder ddlBuilder = new SQLiteDdlBuilder();
ddlBuilder.AppendSql("CREATE ");
if (migrationOperation.IsUnique)
{
ddlBuilder.AppendSql("UNIQUE ");
}
ddlBuilder.AppendSql("INDEX ");
ddlBuilder.AppendIdentifier(SQLiteProviderManifestHelper.GetFullIdentifierName(migrationOperation.Table, migrationOperation.Name));
ddlBuilder.AppendSql(" ON ");
ddlBuilder.AppendIdentifier(migrationOperation.Table);
ddlBuilder.AppendSql(" (");
ddlBuilder.AppendIdentifierList(migrationOperation.Columns);
ddlBuilder.AppendSql(")");
return(ddlBuilder.GetCommandText());
}