gen.go

package golang

import (
	"bufio"
	"bytes"
	"fmt"
	"go/format"
	"strings"
	"text/template"

	"github.com/shhwang1227/sqlc/internal/codegen"
	"github.com/shhwang1227/sqlc/internal/compiler"
	"github.com/shhwang1227/sqlc/internal/config"
)

type Generateable interface {
	Structs(settings config.CombinedSettings) []Struct
	GoQueries(settings config.CombinedSettings) []Query
	Enums(settings config.CombinedSettings) []Enum
}

var templateSet = `
{{define "dbFile"}}// Code generated by sqlc. DO NOT EDIT.

package {{.Package}}

import (
	{{range imports .SourceName}}
	{{range .}}{{.}}
	{{end}}
	{{end}}
)

{{template "dbCode" . }}
{{end}}

{{define "dbCode"}}
type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

func New(db DBTX) *Queries {
	return &Queries{db: db}
}

{{if .EmitPreparedQueries}}
func Prepare(ctx context.Context, db DBTX) (*Queries, error) {
	q := Queries{db: db}
	var err error
	{{- if eq (len .GoQueries) 0 }}
	_ = err
	{{- end }}
	{{- range .GoQueries }}
	if q.{{.FieldName}}, err = db.PrepareContext(ctx, {{.ConstantName}}); err != nil {
		return nil, fmt.Errorf("error preparing query {{.MethodName}}: %w", err)
	}
	{{- end}}
	return &q, nil
}

func (q *Queries) Close() error {
	var err error
	{{- range .GoQueries }}
	if q.{{.FieldName}} != nil {
		if cerr := q.{{.FieldName}}.Close(); cerr != nil {
			err = fmt.Errorf("error closing {{.FieldName}}: %w", cerr)
		}
	}
	{{- end}}
	return err
}

func (q *Queries) exec(ctx context.Context, stmt *sql.Stmt, query string, args ...interface{}) (sql.Result, error) {
	switch {
	case stmt != nil && q.tx != nil:
		return q.tx.StmtContext(ctx, stmt).ExecContext(ctx, args...)
	case stmt != nil:
		return stmt.ExecContext(ctx, args...)
	default:
		return q.db.ExecContext(ctx, query, args...)
	}
}

func (q *Queries) query(ctx context.Context, stmt *sql.Stmt, query string, args ...interface{}) (*sql.Rows, error) {
	switch {
	case stmt != nil && q.tx != nil:
		return q.tx.StmtContext(ctx, stmt).QueryContext(ctx, args...)
	case stmt != nil:
		return stmt.QueryContext(ctx, args...)
	default:
		return q.db.QueryContext(ctx, query, args...)
	}
}

func (q *Queries) queryRow(ctx context.Context, stmt *sql.Stmt, query string, args ...interface{}) (*sql.Row) {
	switch {
	case stmt != nil && q.tx != nil:
		return q.tx.StmtContext(ctx, stmt).QueryRowContext(ctx, args...)
	case stmt != nil:
		return stmt.QueryRowContext(ctx, args...)
	default:
		return q.db.QueryRowContext(ctx, query, args...)
	}
}
{{end}}

type Queries struct {
	db DBTX

    {{- if .EmitPreparedQueries}}
	tx         *sql.Tx
	{{- range .GoQueries}}
	{{.FieldName}}  *sql.Stmt
	{{- end}}
	{{- end}}
}

func (q *Queries) WithTx(tx *sql.Tx) *Queries {
	return &Queries{
		db: tx,
     	{{- if .EmitPreparedQueries}}
		tx: tx,
		{{- range .GoQueries}}
		{{.FieldName}}: q.{{.FieldName}},
		{{- end}}
		{{- end}}
	}
}
{{end}}

{{define "interfaceFile"}}// Code generated by sqlc. DO NOT EDIT.
//go:generate  mockgen -source=./querier.go  -destination=./mock/querier.go

package {{.Package}}

import (
	{{range imports .SourceName}}
	{{range .}}{{.}}
	{{end}}
	{{end}}
)

{{template "interfaceCode" . }}
{{end}}

{{define "interfaceCode"}}
type Querier interface {
	{{- range .GoQueries}}
	{{- if eq .Cmd ":one"}}
	{{.MethodName}}(ctx context.Context, {{.Arg.Pair}}) ({{.Ret.Type}}, error)
	{{- end}}
	{{- if eq .Cmd ":many"}}
	{{.MethodName}}(ctx context.Context, {{.Arg.Pair}}) ([]{{.Ret.Type}}, error)
	{{- end}}
	{{- if eq .Cmd ":exec"}}
	{{.MethodName}}(ctx context.Context, {{.Arg.Pair}}) error
	{{- end}}
	{{- if eq .Cmd ":execrows"}}
	{{.MethodName}}(ctx context.Context, {{.Arg.Pair}}) (int64, error)
	{{- end}}
	{{- if eq .Cmd ":execresult"}}
	{{.MethodName}}(ctx context.Context, {{.Arg.Pair}}) (sql.Result, error)
	{{- end}}
	{{- end}}
}

var _ Querier = (*Queries)(nil)
{{end}}

{{define "modelsFile"}}// Code generated by sqlc. DO NOT EDIT.

package {{.Package}}

import (
	{{range imports .SourceName}}
	{{range .}}{{.}}
	{{end}}
	{{end}}
)

{{template "modelsCode" . }}
{{end}}

{{define "modelsCode"}}
{{range .Enums}}
{{if .Comment}}{{comment .Comment}}{{end}}
type {{.Name}} string

const (
	{{- range .Constants}}
	{{.Name}} {{.Type}} = "{{.Value}}"
	{{- end}}
)

func (e *{{.Name}}) Scan(src interface{}) error {
	switch s := src.(type) {
	case []byte:
		*e = {{.Name}}(s)
	case string:
		*e = {{.Name}}(s)
	default:
		return fmt.Errorf("unsupported scan type for {{.Name}}: %T", src)
	}
	return nil
}
{{end}}

{{range .Structs}}
{{if .Comment}}{{comment .Comment}}{{end}}
type {{.Name}} struct { {{- range .Fields}}
  {{- if .Comment}}
  {{comment .Comment}}{{else}}
  {{- end}}
  {{.Name}} {{.Type}} {{if or ($.EmitJSONTags) ($.EmitDBTags)}}{{$.Q}}{{.Tag}}{{$.Q}}{{end}}
  {{- end}}
}
{{end}}
{{end}}

{{define "queryFile"}}// Code generated by sqlc. DO NOT EDIT.
// source: {{.SourceName}}

package {{.Package}}

import (
	{{range imports .SourceName}}
	{{range .}}{{.}}
	{{end}}
	{{end}}
)

{{template "queryCode" . }}
{{end}}

{{define "queryCode"}}
{{ $ContainSlice := false }}
{{range .GoQueries}}
{{if $.OutputQuery .SourceName}}
const {{.ConstantName}} = {{$.Q}}-- name: {{.MethodName}} {{.Cmd}}
{{escape .SQL}}
{{$.Q}}

{{if .Arg.EmitStruct}}
type {{.Arg.Type}} struct { {{- range .Arg.Struct.Fields}}
  {{if eq .IsSlice true}}
  {{.Name}} []{{.Type}} {{if or ($.EmitJSONTags) ($.EmitDBTags)}}{{$.Q}}{{.Tag}}{{$.Q}}{{end}}
  {{else}}
  {{.Name}} {{.Type}} {{if or ($.EmitJSONTags) ($.EmitDBTags)}}{{$.Q}}{{.Tag}}{{$.Q}}{{end}}
  {{- end}} 
  {{- end}}
}
{{end}}

{{if .Ret.EmitStruct}}
type {{.Ret.Type}} struct { {{- range .Ret.Struct.Fields}}
  {{.Name}} {{.Type}} {{if or ($.EmitJSONTags) ($.EmitDBTags)}}{{$.Q}}{{.Tag}}{{$.Q}}{{end}}
  {{- end}}
}
{{end}}

{{if eq $ContainSlice false }}
{{if eq .Arg.ContainSlice true }}
{{ $ContainSlice = true }}
{{end -}}
{{end -}}

{{if eq .Cmd ":one"}}
{{range .Comments}}//{{.}}
{{end -}}
func (q *Queries) {{.MethodName}}(ctx context.Context, {{.Arg.Pair}}) ({{.Ret.Type}}, error) {
	{{if .Arg.EmitStruct}}
	{{$ConstantName := .ConstantName}}
	{{$argNmae := .Arg.Name}}
	{{$ConstantName}}:={{$ConstantName}}
	{{$DefaultValueByType := .Ret.GetDefaultValueByType}}
	{{- range .Arg.Struct.Fields}}
	{{if eq .IsSlice true}}
	if len({{$argNmae}}.{{.Name}}) <=0{
		return {{$DefaultValueByType}},fmt.Errorf("{{$argNmae}}.{{.Name}} length is invalid")
	}
	{
	param:="?"
	for i:=0;i<len({{$argNmae}}.{{.Name}})-1;i++{
	 param+=",?"   
	}
	{{$ConstantName}}=replaceNth({{$ConstantName}}, "(?)", "( "+param+" )", 1)
    }
	{{- end}}
	{{- end}}
	{{- end}}
	{{ if eq .Arg.IsSliceType true}}
	if len({{.Arg.Name}})<=0 {
		return {{.Ret.GetDefaultValueByType}},fmt.Errorf("{{.Arg.Name}} length is invalid")
	}
	   param:="?"
	   for i:=0;i<len({{.Arg.Name}})-1;i++{
		param+=",?"   
	   }
	   {{.ConstantName}}:=replaceNth({{.ConstantName}}, "(?)", "( "+param+" )", 1)
	{{end -}}
	{{- if $.EmitPreparedQueries}}
	row := q.queryRow(ctx, q.{{.FieldName}}, {{.ConstantName}}, {{.Arg.Params}})
	{{- else}}
	row := q.db.QueryRowContext(ctx, {{.ConstantName}}, {{.Arg.Params}})
	{{- end}}
	var {{.Ret.Name}} {{.Ret.Type}}
	err := row.Scan({{.Ret.Scan}})
	return {{.Ret.Name}}, err
}
{{end}}

{{if eq .Cmd ":many"}}
{{range .Comments}}//{{.}}
{{end -}}
func (q *Queries) {{.MethodName}}(ctx context.Context, {{.Arg.Pair}}) ([]{{.Ret.Type}}, error) {
	{{if .Arg.EmitStruct}}
	{{$ConstantName := .ConstantName}}
	{{$argNmae := .Arg.Name}}
	{{$ConstantName}}:={{$ConstantName}}
	{{- range .Arg.Struct.Fields}}
	{{if eq .IsSlice true}}
	if len({{$argNmae}}.{{.Name}}) <=0{
		return nil,fmt.Errorf("{{$argNmae}}.{{.Name}} length is invalid")
	}
	{
	param:="?"
	for i:=0;i<len({{$argNmae}}.{{.Name}})-1;i++{
	 param+=",?"   
	}
	{{$ConstantName}}=replaceNth({{$ConstantName}}, "(?)", "( "+param+" )", 1)
    }
	{{- end}}
	{{- end}}
	{{- end}}
	{{ if eq .Arg.IsSliceType true}}
	if len({{.Arg.Name}})<=0 {
		return nil,fmt.Errorf("{{.Arg.Name}} length is invalid")
	}
	   param:="?"
	   for i:=0;i<len({{.Arg.Name}})-1;i++{
		param+=",?"   
	   }
	   {{.ConstantName}}:=replaceNth({{.ConstantName}}, "(?)", "( "+param+" )", 1)
	
	{{end -}}
	{{- if $.EmitPreparedQueries}}
	rows, err := q.query(ctx, q.{{.FieldName}}, {{.ConstantName}}, {{.Arg.Params}})
  	{{- else}}
	rows, err := q.db.QueryContext(ctx, {{.ConstantName}}, {{.Arg.Params}})
  	{{- end}}
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	{{- if $.EmitEmptySlices}}
	items := []{{.Ret.Type}}{}
	{{else}}
	var items []{{.Ret.Type}}
	{{end -}}
	for rows.Next() {
		var {{.Ret.Name}} {{.Ret.Type}}
		if err := rows.Scan({{.Ret.Scan}}); err != nil {
			return nil, err
		}
		items = append(items, {{.Ret.Name}})
	}
	if err := rows.Close(); err != nil {
		return nil, err
	}
	if err := rows.Err(); err != nil {
		return nil, err
	}
	return items, nil
}
{{end}}

{{if eq .Cmd ":exec"}}
{{range .Comments}}//{{.}}
{{end -}}
func (q *Queries) {{.MethodName}}(ctx context.Context, {{.Arg.Pair}}) error {
	{{if .Arg.EmitStruct}}
	{{$ConstantName := .ConstantName}}
	{{$argNmae := .Arg.Name}}
	{{$ConstantName}}:={{$ConstantName}}
	{{- range .Arg.Struct.Fields}}
	{{if eq .IsSlice true}}
	if len({{$argNmae}}.{{.Name}}) <=0{
		return fmt.Errorf("{{$argNmae}}.{{.Name}} length is invalid")
	}
	{
	param:="?"
	for i:=0;i<len({{$argNmae}}.{{.Name}})-1;i++{
	 param+=",?"   
	}
	{{$ConstantName}}=replaceNth({{$ConstantName}}, "(?)", "( "+param+" )", 1)
    }
	{{- end}}
	{{- end}}
	{{- end}}
	{{ if eq .Arg.IsSliceType true}}
	 if len({{.Arg.Name}})<=0{
		return fmt.Errorf("{{.Arg.Name}} length is invalid")
	 }
	   param:="?"
	   for i:=0;i<len({{.Arg.Name}})-1;i++{
		param+=",?"   
	   }
	   {{.ConstantName}}:=replaceNth({{.ConstantName}}, "(?)", "( "+param+" )", 1)
	{{end -}}
	{{- if $.EmitPreparedQueries}}
	_, err := q.exec(ctx, q.{{.FieldName}}, {{.ConstantName}}, {{.Arg.Params}})
  	{{- else}}
	_, err := q.db.ExecContext(ctx, {{.ConstantName}}, {{.Arg.Params}})
  	{{- end}}
	return err
}
{{end}}

{{if eq .Cmd ":execrows"}}
{{range .Comments}}//{{.}}
{{end -}}
func (q *Queries) {{.MethodName}}(ctx context.Context, {{.Arg.Pair}}) (int64, error) {
	{{if .Arg.EmitStruct}}
	{{$ConstantName := .ConstantName}}
	{{$argNmae := .Arg.Name}}
	{{$ConstantName}}:={{$ConstantName}}
	{{- range .Arg.Struct.Fields}}
	{{if eq .IsSlice true}}
	if len({{$argNmae}}.{{.Name}})  <=0{
		return nil,fmt.Errorf("{{$argNmae}}.{{.Name}} length is invalid")
	}
	 {
	param:="?"
	for i:=0;i<len({{$argNmae}}.{{.Name}})-1;i++{
	 param+=",?"   
	}
	{{$ConstantName}}=replaceNth({{$ConstantName}}, "(?)", "( "+param+" )", 1)
    }
	{{- end}}
	{{- end}}
	{{- end}}
	{{- if $.EmitPreparedQueries}}
	result, err := q.exec(ctx, q.{{.FieldName}}, {{.ConstantName}}, {{.Arg.Params}})
  	{{- else}}
	result, err := q.db.ExecContext(ctx, {{.ConstantName}}, {{.Arg.Params}})
  	{{- end}}
	if err != nil {
		return 0, err
	}
	return result.RowsAffected()
}
{{end}}

{{if eq .Cmd ":execresult"}}
{{range .Comments}}//{{.}}
{{end -}}
func (q *Queries) {{.MethodName}}(ctx context.Context, {{.Arg.Pair}}) (sql.Result, error) {
	{{if .Arg.EmitStruct}}
	{{$ConstantName := .ConstantName}}
	{{$argNmae := .Arg.Name}}
	{{$ConstantName}}:={{$ConstantName}}
	{{- range .Arg.Struct.Fields}}
	{{if eq .IsSlice true}}
	if len({{$argNmae}}.{{.Name}}) <=0{
		return nil,fmt.Errorf("{{$argNmae}}.{{.Name}} length is invalid")
	}
	{
	param:="?"
	for i:=0;i<len({{$argNmae}}.{{.Name}})-1;i++{
	 param+=",?"   
	}
	{{$ConstantName}}=replaceNth({{$ConstantName}}, "(?)", "( "+param+" )", 1)
    }
	{{- end}}
	{{- end}}
	{{- end}}
	{{ if eq .Arg.IsSliceType true}}
	   if len({{.Arg.Name}}) <=0 {
		   return nil,fmt.Errorf("{{.Arg.Name}} length is invalid")
	   }
		   param:="?"
	   for i:=0;i<len({{.Arg.Name}})-1;i++{
		param+=",?"   
	   }
	   {{.ConstantName}}:=replaceNth({{.ConstantName}}, "(?)", "( "+param+" )", 1)
	
	{{end -}}
	{{- if $.EmitPreparedQueries}}
	return q.exec(ctx, q.{{.FieldName}}, {{.ConstantName}}, {{.Arg.Params}})
  	{{- else}}
	return q.db.ExecContext(ctx, {{.ConstantName}}, {{.Arg.Params}})
  	{{- end}}
}
{{end}}
{{end}}
{{end}}
{{end}}

{{define "utilFile"}}// Code generated by sqlc. DO NOT EDIT.

package {{.Package}}

import (
	{{range imports .SourceName}}
	{{range .}}{{.}}
	{{end}}
	{{end}}
)

// Replace the nth occurrence of old in s by new.
func replaceNth(s, old, new string, n int) string {
	i := 0
	for m := 1; m <= n; m++ {
		x := strings.Index(s[i:], old)
		if x < 0 {
			break
		}
		i += x
		if m == n {
			return s[:i] + new + s[i+len(old):]
		}
		i += len(old)
	}
	return s
}

{{range .GoQueries}}
{{- if .Arg.ContainSlice -}}
{{- if .Arg.ShouldGenFunctions -}}
//{{.SourceName}}   {{.MethodName}}
{{.Arg.GenerateFunctions}}
{{- end -}}
{{- end -}}
{{- end -}}
{{end}}
`

type tmplCtx struct {
	Q         string
	Package   string
	Enums     []Enum
	Structs   []Struct
	GoQueries []Query
	Settings  config.Config

	// TODO: Race conditions
	SourceName string

	EmitJSONTags        bool
	EmitDBTags          bool
	EmitPreparedQueries bool
	EmitInterface       bool
	EmitEmptySlices     bool
}

func (t *tmplCtx) OutputQuery(sourceName string) bool {
	return t.SourceName == sourceName
}

func Generate(r *compiler.Result, settings config.CombinedSettings) (map[string]string, error) {
	enums := buildEnums(r, settings)
	structs := buildStructs(r, settings)
	queries := buildQueries(r, settings, structs)
	return generate(settings, enums, structs, queries)
}

func generate(settings config.CombinedSettings, enums []Enum, structs []Struct, queries []Query) (map[string]string, error) {
	i := &importer{
		Settings: settings,
		Queries:  queries,
		Enums:    enums,
		Structs:  structs,
	}

	funcMap := template.FuncMap{
		"lowerTitle": codegen.LowerTitle,
		"comment":    codegen.DoubleSlashComment,
		"escape":     codegen.EscapeBacktick,
		"imports":    i.Imports,
	}

	tmpl := template.Must(template.New("table").Funcs(funcMap).Parse(templateSet))

	golang := settings.Go
	tctx := tmplCtx{
		Settings:            settings.Global,
		EmitInterface:       golang.EmitInterface,
		EmitJSONTags:        golang.EmitJSONTags,
		EmitDBTags:          golang.EmitDBTags,
		EmitPreparedQueries: golang.EmitPreparedQueries,
		EmitEmptySlices:     golang.EmitEmptySlices,
		Q:                   "`",
		Package:             golang.Package,
		GoQueries:           queries,
		Enums:               enums,
		Structs:             structs,
	}

	output := map[string]string{}

	execute := func(name, sourceName, templateName string) error {
		var b bytes.Buffer
		w := bufio.NewWriter(&b)
		tctx.SourceName = name
		if sourceName != "" {
			tctx.SourceName = sourceName
		}
		err := tmpl.ExecuteTemplate(w, templateName, &tctx)
		w.Flush()
		if err != nil {
			return err
		}
		code, err := format.Source(b.Bytes())
		if err != nil {
			return fmt.Errorf("source error: %w %s", err, b.String())
		}
		if !strings.HasSuffix(name, ".go") {
			name += ".go"
		}
		output[name] = string(code)
		return nil
	}

	if err := execute("db.go", "", "dbFile"); err != nil {
		return nil, err
	}
	if err := execute("models.go", "", "modelsFile"); err != nil {
		return nil, err
	}
	if golang.EmitInterface {
		if err := execute("querier.go", "", "interfaceFile"); err != nil {
			return nil, err
		}
	}

	if err := execute("util.go", "", "utilFile"); err != nil {
		return nil, err
	}

	files := map[string]struct{}{}
	for _, gq := range queries {
		files[gq.SourceName] = struct{}{}
	}

	for source := range files {
		if err := execute(source, source, "queryFile"); err != nil {
			return nil, err
		}
	}
	return output, nil
}