Method recreateTable

plugins/destination/sqlite/client/migrate.go:183–189

(ctx context.Context, table *schema.Table)

}

func (c *Client) recreateTable(ctx context.Context, table *schema.Table) error {
	sql := "drop table if exists " + identifier(table.Name)
	if _, err := c.db.ExecContext(ctx, sql); err != nil {
		return fmt.Errorf("failed to drop table %s: %w", table.Name, err)
	}
	return c.createTableIfNotExist(table)
}

func (c *Client) addColumn(ctx context.Context, tableName string, columnName string, columnType string) error {
	sql := "alter table " + identifier(tableName) + " add column " + identifier(columnName) + " " + identifier(columnType)