From be2efe80d7f11b695cb542ae94b4d5f1f69ba537 Mon Sep 17 00:00:00 2001
From: Rose Hogenson <rosehogenson@posteo.net>
Date: Tue, 6 Feb 2024 22:32:09 -0800
Subject: Use reflect.VisibleFields to find struct fields.

---
 sqlr_test.go | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

(limited to 'sqlr_test.go')

diff --git a/sqlr_test.go b/sqlr_test.go
index 4323f11..4625fde 100644
--- a/sqlr_test.go
+++ b/sqlr_test.go
@@ -54,6 +54,17 @@ func TestScan(t *testing.T) {
 			ColA int    `sql:"col_a"`
 			ColB string `sql:"col_b"`
 		}{100, "test"},
+	}, {
+		desc: "embedded struct",
+		db: `
+			CREATE TABLE Tbl (Col);
+			INSERT INTO Tbl VALUES (100)`,
+		query: "SELECT Col FROM Tbl",
+		want: func() any {
+			type Inner struct{ Col int }
+			type outer struct{ Inner }
+			return &outer{Inner{100}}
+		}(),
 	}} {
 		t.Run(tc.desc, func(t *testing.T) {
 			db, err := sql.Open("sqlite3", ":memory:")
@@ -129,6 +140,13 @@ func TestScan_Errors(t *testing.T) {
 		out: new(struct {
 			Col int `sql:"-"`
 		}),
+	}, {
+		desc: "unexported field",
+		db: `
+			CREATE TABLE Tbl (col);
+			INSERT INTO Tbl VALUES (100)`,
+		query: "SELECT col FROM Tbl",
+		out:   new(struct{ col int }),
 	}} {
 		t.Run(tc.desc, func(t *testing.T) {
 			db, err := sql.Open("sqlite3", ":memory:")
-- 
cgit v1.3.1