scan/examples_values_columns_test.go at master · blockloop/scan · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
package scan_test

import (
	"fmt"

	"github.com/blockloop/scan/v2"
)

func ExampleValues() {
	person := struct {
		ID   int    `db:"id"`
		Name string `db:"name"`
	}{
		ID:   1,
		Name: "Brett",
	}

	cols := []string{"id", "name"}
	vals, _ := scan.Values(cols, &person)
	fmt.Printf("%+v", vals)
	// Output:
	// [1 Brett]
}

func ExampleValues_nested() {
	type Address struct {
		Street string
		City   string
	}

	person := struct {
		ID   int
		Name string
		Address
	}{
		Name: "Brett",
		ID:   1,
		Address: Address{
			City: "San Francisco",
		},
	}

	cols := []string{"Name", "City"}
	vals, _ := scan.Values(cols, &person)
	fmt.Printf("%+v", vals)
	// Output:
	// [Brett San Francisco]
}

func ExampleColumns() {
	var person struct {
		ID   int `db:"person_id"`
		Name string
	}

	cols, _ := scan.Columns(&person)
	fmt.Printf("%+v", cols)
	// Output:
	// [person_id Name]
}

func ExampleColumns_exclude() {
	var person struct {
		ID   int    `db:"id"`
		Name string `db:"name"`
		Age  string `db:"-"`
	}

	cols, _ := scan.Columns(&person)
	fmt.Printf("%+v", cols)
	// Output:
	// [id name]
}

func ExampleColumnsStrict() {
	var person struct {
		ID   int `db:"id"`
		Name string
		Age  string `db:"age"`
	}

	cols, _ := scan.ColumnsStrict(&person)
	fmt.Printf("%+v", cols)
	// Output:
	// [id age]
}

func ExampleColumnsNested() {
	var person struct {
		ID      int    `db:"person.id"`
		Name    string `db:"person.name"`
		Company struct {
			ID   int `db:"company.id"`
			Name string
		}
	}

	cols, _ := scan.Columns(&person)
	fmt.Printf("%+v", cols)
	// Output:
	// [person.id person.name company.id Name]
}

func ExampleColumnsNestedStrict() {
	var person struct {
		ID      int    `db:"person.id"`
		Name    string `db:"person.name"`
		Company struct {
			ID   int `db:"company.id"`
			Name string
		}
	}

	cols, _ := scan.ColumnsStrict(&person)
	fmt.Printf("%+v", cols)
	// Output:
	// [person.id person.name company.id]
}

func ExampleColumnsNested_exclude() {
	var person struct {
		ID      int    `db:"person.id"`
		Name    string `db:"person.name"`
		Company struct {
			ID   int    `db:"-"`
			Name string `db:"company.name"`
		}
	}

	cols, _ := scan.Columns(&person)
	fmt.Printf("%+v", cols)
	// Output:
	// [person.id person.name company.name]
}