private string GenerateSqlStatementConcrete(HistoryOperation migrationOperation) { SQLiteDdlBuilder ddlBuilder = new SQLiteDdlBuilder(); foreach (DbModificationCommandTree commandTree in migrationOperation.CommandTrees) { List <DbParameter> parameters; // Take care because here we have several queries so we can't use parameters... switch (commandTree.CommandTreeKind) { case DbCommandTreeKind.Insert: ddlBuilder.AppendSql(SQLiteDmlBuilder.GenerateInsertSql((DbInsertCommandTree)commandTree, out parameters, true)); break; case DbCommandTreeKind.Delete: ddlBuilder.AppendSql(SQLiteDmlBuilder.GenerateDeleteSql((DbDeleteCommandTree)commandTree, out parameters, true)); break; case DbCommandTreeKind.Update: ddlBuilder.AppendSql(SQLiteDmlBuilder.GenerateUpdateSql((DbUpdateCommandTree)commandTree, out parameters, true)); break; case DbCommandTreeKind.Function: case DbCommandTreeKind.Query: default: throw new InvalidOperationException(string.Format("Command tree of type {0} not supported in migration of history operations", commandTree.CommandTreeKind)); } ddlBuilder.AppendSql(BATCHTERMINATOR); } return(ddlBuilder.GetCommandText()); }
private string GenerateSqlStatementConcrete(AddColumnOperation migrationOperation) { SQLiteDdlBuilder ddlBuilder = new SQLiteDdlBuilder(); ddlBuilder.AppendSql("ALTER TABLE "); ddlBuilder.AppendIdentifier(migrationOperation.Table); ddlBuilder.AppendSql(" ADD COLUMN "); ColumnModel column = migrationOperation.Column; ddlBuilder.AppendIdentifier(column.Name); TypeUsage storeType = ProviderManifest.GetStoreType(column.TypeUsage); ddlBuilder.AppendType(storeType, column.IsNullable ?? true, column.IsIdentity); //DEFAULT VALUE if (column.DefaultValue != null) { if (column.DefaultValue is DateTime defaultValue) { var format = "yyyy-MM-dd HH:mm:ss.ffffff"; if (defaultValue.Kind == DateTimeKind.Utc) { format += 'Z'; } ddlBuilder.AppendSql($" DEFAULT '{defaultValue.ToString(format)}'"); } } ddlBuilder.AppendNewLine(); return(ddlBuilder.GetCommandText()); }
private string GenerateSqlStatementConcrete(DropTableOperation migrationOperation) { var ddlBuilder = new SQLiteDdlBuilder(); ddlBuilder.AppendSql("DROP TABLE "); ddlBuilder.AppendIdentifier(migrationOperation.Name); 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()); }
private string GenerateSqlStatementConcrete(DropPrimaryKeyOperation migrationOperation) { var ddlBuilder = new SQLiteDdlBuilder(); ddlBuilder.AppendSql("ALTER TABLE "); ddlBuilder.AppendIdentifier(migrationOperation.Table); ddlBuilder.AppendSql(" DROP CONSTRAINT "); ddlBuilder.AppendIdentifier(migrationOperation.Name); return(ddlBuilder.GetCommandText()); }
private string GenerateSqlStatementConcrete(DropIndexOperation migrationOperation) { SQLiteDdlBuilder ddlBuilder = new SQLiteDdlBuilder(); ddlBuilder.AppendSql("DROP INDEX "); ddlBuilder.AppendIdentifier(SQLiteProviderManifestHelper.GetFullIdentifierName(migrationOperation.Table, migrationOperation.Name)); ddlBuilder.AppendSql(" ON "); ddlBuilder.AppendIdentifier(migrationOperation.Table); return(ddlBuilder.GetCommandText()); }
private string GenerateSqlStatementConcrete(RenameTableOperation migrationOperation) { var ddlBuilder = new SQLiteDdlBuilder(); ddlBuilder.AppendSql("ALTER TABLE "); ddlBuilder.AppendIdentifier(migrationOperation.Name); ddlBuilder.AppendSql(" RENAME TO "); ddlBuilder.AppendIdentifier(migrationOperation.NewName); return(ddlBuilder.GetCommandText()); }
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(AddColumnOperation migrationOperation) { var ddlBuilder = new SQLiteDdlBuilder(); ddlBuilder.AppendSql("ALTER TABLE "); ddlBuilder.AppendIdentifier(migrationOperation.Table); ddlBuilder.AppendSql(" ADD COLUMN "); var column = migrationOperation.Column; ddlBuilder.AppendIdentifier(column.Name); ddlBuilder.AppendSql(" "); var storeType = this.ProviderManifest.GetStoreType(column.TypeUsage); ddlBuilder.AppendType(storeType, column.IsNullable ?? true, column.IsIdentity); ddlBuilder.AppendNewLine(); 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()); }