example_test.go

package twowaysql_test

import (
	"context"
	"fmt"
	"log"

	"github.com/future-architect/go-twowaysql"
)

var (
	tw  *twowaysql.Twowaysql
	ctx context.Context
)

func ExampleTwowaysql_Exec() {

	type Info struct {
		Name       string   `twowaysql:"name"`
		EmpNo      int      `twowaysql:"EmpNo"`
		MaxEmpNo   int      `twowaysql:"maxEmpNo"`
		DeptNo     int      `twowaysql:"deptNo"`
		Email      string   `twowaysql:"email"`
		GenderList []string `twowaysql:"gender_list"`
		IntList    []int    `twowaysql:"int_list"`
	}

	var params = Info{
		MaxEmpNo: 3,
		DeptNo:   12,
	}

	result, err := tw.Exec(ctx, `UPDATE persons SET dept_no = /*deptNo*/1 WHERE employee_no = /*EmpNo*/1`, &params)
	if err != nil {
		log.Fatal(err)
	}

	rows, err := result.RowsAffected()
	if err != nil {
		log.Fatal(err)
	}

	if rows != 1 {
		log.Fatalf("expected to affect 1 row. affected %d", rows)
	}
}

func ExampleTwowaysql_Select() {
	type Person struct {
		FirstName string `db:"first_name"`
		LastName  string `db:"last_name"`
		Email     string `db:"email"`
	}

	type Info struct {
		Name       string   `twowaysql:"name"`
		EmpNo      int      `twowaysql:"EmpNo"`
		MaxEmpNo   int      `twowaysql:"maxEmpNo"`
		DeptNo     int      `twowaysql:"deptNo"`
		Email      string   `twowaysql:"email"`
		GenderList []string `twowaysql:"gender_list"`
		IntList    []int    `twowaysql:"int_list"`
	}

	var params = Info{
		MaxEmpNo: 3,
		DeptNo:   12,
	}

	var people []Person
	err := tw.Select(ctx, &people, `SELECT first_name, last_name, email FROM persons WHERE employee_no < /*maxEmpNo*/1000 /* IF deptNo */ AND dept_no < /*deptNo*/1 /* END */`, &params)
	if err != nil {
		log.Fatal(err)
	}
}

func ExampleEval() {

	type Info struct {
		Name       string   `twowaysql:"name"`
		EmpNo      int      `twowaysql:"EmpNo"`
		MaxEmpNo   int      `twowaysql:"maxEmpNo"`
		DeptNo     int      `twowaysql:"deptNo"`
		Email      string   `twowaysql:"email"`
		GenderList []string `twowaysql:"gender_list"`
		IntList    []int    `twowaysql:"int_list"`
	}

	var params = Info{
		Name:       "Jeff",
		MaxEmpNo:   3,
		DeptNo:     12,
		GenderList: []string{"M", "F"},
		IntList:    []int{1, 2, 3},
	}
	var before = `SELECT * FROM person WHERE employee_no = /*maxEmpNo*/1000 AND /* IF int_list !== null */  person.gender in /*int_list*/(3,5,7) /* END */`

	after, afterParams, _ := twowaysql.Eval(before, &params)

	fmt.Println(after)
	fmt.Println(afterParams)

	// Output:
	// SELECT * FROM person WHERE employee_no = ?/*maxEmpNo*/ AND person.gender in (?, ?, ?)/*int_list*/
	// [3 1 2 3]

}