Method formatCreateView

cmd/gosqlx/cmd/sql_formatter.go:1160–1201

formatCreateView formats CREATE VIEW statements

(stmt *ast.CreateViewStatement)

// formatCreateView formats CREATE VIEW statements
func (f *SQLFormatter) formatCreateView(stmt *ast.CreateViewStatement) error {
	f.writeKeyword("CREATE")
	if stmt.OrReplace {
		f.builder.WriteString(" ")
		f.writeKeyword("OR REPLACE")
	}
	if stmt.Temporary {
		f.builder.WriteString(" ")
		f.writeKeyword("TEMPORARY")
	}
	f.builder.WriteString(" ")
	f.writeKeyword("VIEW")

	if stmt.IfNotExists {
		f.builder.WriteString(" ")
		f.writeKeyword("IF NOT EXISTS")
	}

	f.builder.WriteString(" " + stmt.Name)

	if len(stmt.Columns) > 0 {
		f.builder.WriteString(" (")
		for i, col := range stmt.Columns {
			if i > 0 {
				f.builder.WriteString(", ")
			}
			f.builder.WriteString(col)
		}
		f.builder.WriteString(")")
	}

	f.builder.WriteString(" ")
	f.writeKeyword("AS")
	f.writeNewline()
	f.increaseIndent()
	if err := f.formatStatement(stmt.Query); err != nil {
		return err
	}
	f.decreaseIndent()

	return nil
}

// formatCreateMaterializedView formats CREATE MATERIALIZED VIEW statements
func (f *SQLFormatter) formatCreateMaterializedView(stmt *ast.CreateMaterializedViewStatement) error {