Method formatCreateTable

cmd/gosqlx/cmd/sql_formatter.go:359–403

formatCreateTable formats CREATE TABLE statements

(stmt *ast.CreateTableStatement)

// formatCreateTable formats CREATE TABLE statements
func (f *SQLFormatter) formatCreateTable(stmt *ast.CreateTableStatement) error {
	f.writeKeyword("CREATE")
	if stmt.Temporary {
		f.builder.WriteString(" ")
		f.writeKeyword("TEMPORARY")
	}
	f.builder.WriteString(" ")
	f.writeKeyword("TABLE")

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

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

	if !f.compact {
		f.writeNewline()
		f.increaseIndent()
	}

	for i, col := range stmt.Columns {
		col := col // G601: Create local copy to avoid memory aliasing
		if i > 0 {
			f.builder.WriteString(",")
			if !f.compact {
				f.writeNewline()
			} else {
				f.builder.WriteString(" ")
			}
		}
		if !f.compact {
			f.builder.WriteString(f.currentIndent())
		}
		f.formatColumnDef(&col)
	}

	if !f.compact {
		f.decreaseIndent()
		f.writeNewline()
	}
	f.builder.WriteString(")")

	return nil
}

// formatCreateIndex formats CREATE INDEX statements
func (f *SQLFormatter) formatCreateIndex(stmt *ast.CreateIndexStatement) error {