example_test.go

package sqlinsert_test

import (
	"fmt"

	sqlinsert "github.com/zachvictor/sqlinsert/v2"
)

type CandyInsert struct {
	Id     string  `col:"id"`
	Name   string  `col:"candy_name"`
	Weight float64 `col:"weight_grams"`
}

func ExampleInsert_SQL() {
	ins := sqlinsert.Insert{
		Table: `candy`,
		Data:  CandyInsert{Id: `a`, Name: `Gougat`, Weight: 1.1618},
	}
	query, err := ins.SQL()
	if err != nil {
		fmt.Println(err)
		return
	}
	fmt.Println(query)
	// Output: INSERT INTO candy (id,candy_name,weight_grams) VALUES (?,?,?)
}

func ExampleInsert_SQL_postgres() {
	ins := sqlinsert.Insert{
		Table:     `candy`,
		Data:      CandyInsert{Id: `a`, Name: `Gougat`, Weight: 1.1618},
		TokenType: sqlinsert.OrdinalNumberTokenType,
	}
	query, err := ins.SQL()
	if err != nil {
		fmt.Println(err)
		return
	}
	fmt.Println(query)
	// Output: INSERT INTO candy (id,candy_name,weight_grams) VALUES ($1,$2,$3)
}

func ExampleInsert_SQL_multiRow() {
	ins := sqlinsert.Insert{
		Table: `candy`,
		Data: []CandyInsert{
			{Id: `a`, Name: `Gougat`, Weight: 1.1618},
			{Id: `b`, Name: `Nussnicht`, Weight: 2.71828},
		},
		TokenType: sqlinsert.OrdinalNumberTokenType,
	}
	query, err := ins.SQL()
	if err != nil {
		fmt.Println(err)
		return
	}
	fmt.Println(query)
	// Output: INSERT INTO candy (id,candy_name,weight_grams) VALUES ($1,$2,$3),($4,$5,$6)
}

func ExampleInsert_Args() {
	ins := sqlinsert.Insert{
		Table: `candy`,
		Data:  CandyInsert{Id: `a`, Name: `Gougat`, Weight: 1.1618},
	}
	args, err := ins.Args()
	if err != nil {
		fmt.Println(err)
		return
	}
	fmt.Println(args)
	// Output: [a Gougat 1.1618]
}