drop_table.go

package sqls

import (
	"strings"
)

type dropTableBuilder struct {
	builder  *sqlBuilder
	table    string
	ifExists bool
}

func newDropTableBuilder() *dropTableBuilder {
	builder := &dropTableBuilder{}
	builder.builder = newSqlBuilder()
	builder.ifExists = false
	return builder
}

func DROP_TABLE(table string) *dropTableBuilder {
	s := newDropTableBuilder()
	s.table = table
	return s
}

func (s *dropTableBuilder) IF_EXISTS() *dropTableBuilder {
	s.ifExists = true
	return s
}

func (s *dropTableBuilder) Param(v any) string {
	return s.builder.Param(v)
}

func (s *dropTableBuilder) Params() []any {
	return s.builder.Params(s.String())
}

func (s *dropTableBuilder) String() string {
	var sqlString string
	keyword := "DROP TABLE"
	if s.ifExists {
		keyword += " IF EXISTS"
	}

	sqlString += s.builder.join(keyword, "", []string{s.table}, ", ", "")
	return strings.Trim(sqlString, " ")
}