private string GenerateSqlStatementConcrete(CreateIndexOperation migrationOperation)
{
SQLiteDdlBuilder ddlBuilder = new SQLiteDdlBuilder();
ddlBuilder.AppendSql("CREATE ");
if (migrationOperation.IsUnique)
{
ddlBuilder.AppendSql("UNIQUE ");
}
ddlBuilder.AppendSql("INDEX ");
ddlBuilder.AppendIdentifier(migrationOperation.Name + "_" + GetRandomString());
ddlBuilder.AppendSql(" ON ");
ddlBuilder.AppendIdentifier(migrationOperation.Table);
ddlBuilder.AppendSql(" (");
ddlBuilder.AppendIdentifierList(migrationOperation.Columns);
ddlBuilder.AppendSql(")");
return(ddlBuilder.GetCommandText());
}
private string GenerateSqlStatementConcrete(CreateIndexOperation migrationOperation)
{
var 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());
}
private string GenerateSqlStatementConcrete(CreateTableOperation migrationOperation)
{
SQLiteDdlBuilder ddlBuilder = new SQLiteDdlBuilder();
ddlBuilder.AppendSql("CREATE TABLE ");
ddlBuilder.AppendIdentifier(migrationOperation.Name);
ddlBuilder.AppendSql(" (");
ddlBuilder.AppendNewLine();
bool first = true;
string autoincrementColumnName = null;
foreach (ColumnModel column in migrationOperation.Columns)
{
if (first)
{
first = false;
}
else
{
ddlBuilder.AppendSql(",");
}
ddlBuilder.AppendSql(" ");
ddlBuilder.AppendIdentifier(column.Name);
ddlBuilder.AppendSql(" ");
if (column.IsIdentity)
{
autoincrementColumnName = column.Name;
ddlBuilder.AppendSql(" integer constraint ");
ddlBuilder.AppendIdentifier(ddlBuilder.CreateConstraintName("PK", migrationOperation.Name));
ddlBuilder.AppendSql(" primary key autoincrement");
ddlBuilder.AppendNewLine();
}
else
{
TypeUsage storeTypeUsage = ProviderManifest.GetStoreType(column.TypeUsage);
ddlBuilder.AppendType(storeTypeUsage, column.IsNullable ?? true, column.IsIdentity);
if (!String.IsNullOrEmpty(column.DefaultValueSql))
{
ddlBuilder.AppendSql(" DEFAULT ");
ddlBuilder.AppendSql(column.DefaultValueSql);
}
ddlBuilder.AppendNewLine();
}
}
if (migrationOperation.PrimaryKey != null && autoincrementColumnName == null)
{
ddlBuilder.AppendSql(",");
ddlBuilder.AppendSql(GenerateSqlStatementConcrete(migrationOperation.PrimaryKey));
}
ddlBuilder.AppendSql(")");
return(ddlBuilder.GetCommandText());
}