Method Format

parser/node.go:972–1072

Format returns a canonical string representation of the type and all relevant options

(buf *nodeBuffer)

// Format returns a canonical string representation of the type and all relevant options
func (ct *ColumnType) Format(buf *nodeBuffer) {
	buf.Printf("%s", ct.Type)

	if ct.Length != nil && ct.Scale != nil {
		buf.Printf("(%v,%v)", ct.Length, ct.Scale)

	} else if ct.Length != nil {
		buf.Printf("(%v)", ct.Length)
	}

	if ct.EnumValues != nil {
		quotedValues := make([]string, len(ct.EnumValues))
		for i, v := range ct.EnumValues {
			quotedValues[i] = "'" + v + "'"
		}
		buf.Printf("(%s)", strings.Join(quotedValues, ", "))
	}

	if ct.Unsigned {
		buf.Printf(" %s", keywordStrings[UNSIGNED])
	}
	if ct.Zerofill {
		buf.Printf(" %s", keywordStrings[ZEROFILL])
	}
	if ct.Charset != "" {
		buf.Printf(" %s %s %s", keywordStrings[CHARACTER], keywordStrings[SET], ct.Charset)
	}
	if ct.Collate != "" {
		buf.Printf(" %s %s", keywordStrings[COLLATE], ct.Collate)
	}
	if ct.Timezone {
		buf.Printf(" %s %s %s", keywordStrings[WITH], keywordStrings[TIME], keywordStrings[ZONE])
	}
	if ct.NotNull != nil && *ct.NotNull {
		buf.Printf(" %s %s", keywordStrings[NOT], keywordStrings[NULL])
	}
	if ct.Default != nil {
		buf.Printf(" %s", keywordStrings[DEFAULT])
		if _, ok := ct.Default.Expression.Expr.(*SQLVal); ok {
			buf.Printf(" %s", String(ct.Default.Expression.Expr))
		} else {
			buf.Printf("(%v)", ct.Default.Expression.Expr)
		}
	}
	if ct.OnUpdate != nil {
		buf.Printf(" %s %s %s", keywordStrings[ON], keywordStrings[UPDATE], String(ct.OnUpdate))
	}
	if ct.Autoincrement {
		buf.Printf(" %s", keywordStrings[AUTO_INCREMENT])
	}
	if ct.Comment != nil {
		buf.Printf(" %s %s", keywordStrings[COMMENT_KEYWORD], String(ct.Comment))
	}
	if ct.Check != nil {
		buf.Printf(" %s %s", keywordStrings[CHECK], String(&ct.Check.Where))
	}
	if !ct.References.Name.IsEmpty() {
		buf.Printf(" references %v", ct.References)