Cyberax · Mar 9, 2020 · Mar 20, 2020
diff --git a/examples/authors/db_test.go b/examples/authors/db_test.go
@@ -10,6 +10,26 @@ import (
 	"github.com/kyleconroy/sqlc/internal/sqltest"
 )
 
+// An example of an application-level structure
+type AppAuthor struct {
+	ID   int64
+	Name string
+	Bio  string
+}
+
+// A mapper that uses a face interface
+func MapToAuthor(a interface {
+	GetID() int64
+	GetName() string
+	GetBio() sql.NullString
+}) AppAuthor {
+	return AppAuthor{
+		ID:   a.GetID(),
+		Name: a.GetName(),
+		Bio:  a.GetBio().String,
+	}
+}
+
 func TestAuthors(t *testing.T) {
 	sdb, cleanup := sqltest.PostgreSQL(t, "schema.sql")
 	defer cleanup()
@@ -40,4 +60,5 @@ func TestAuthors(t *testing.T) {
 		t.Fatal(err)
 	}
 	t.Log(fetchedAuthor)
+	t.Log(MapToAuthor(&fetchedAuthor))
 }
diff --git a/examples/authors/models.go b/examples/authors/models.go
diff --git a/examples/booktest/mysql/models.go b/examples/booktest/mysql/models.go
diff --git a/examples/booktest/postgresql/models.go b/examples/booktest/postgresql/models.go
diff --git a/examples/jets/models.go b/examples/jets/models.go
diff --git a/examples/ondeck/models.go b/examples/ondeck/models.go
diff --git a/internal/dinosql/gen.go b/internal/dinosql/gen.go
@@ -1159,7 +1159,7 @@ func (e *{{.Name}}) Scan(src interface{}) error {
 }
 {{end}}
 
-{{range .Structs}}
+{{range $s := .Structs}}
 {{if .Comment}}{{comment .Comment}}{{end}}
 type {{.Name}} struct { {{- range .Fields}}
   {{- if .Comment}}
@@ -1168,6 +1168,17 @@ type {{.Name}} struct { {{- range .Fields}}
   {{.Name}} {{.Type}} {{if $.EmitJSONTags}}{{$.Q}}{{.Tag}}{{$.Q}}{{end}}
   {{- end}}
 }
+
+{{- range $f := .Fields}}
+{{- if $f.Comment}}
+// {{$f.Comment}}
+{{- end}}
+func (t *{{$s.Name}}) Get{{$f.Name}}() {{$f.Type}} {
+  return t.{{$f.Name}}
+}
+
+{{- end}}
+
 {{end}}
 {{end}}
 

diff --git a/internal/endtoend/testdata/alias/go/models.go b/internal/endtoend/testdata/alias/go/models.go
diff --git a/internal/endtoend/testdata/any/go/models.go b/internal/endtoend/testdata/any/go/models.go
diff --git a/internal/endtoend/testdata/as/go/models.go b/internal/endtoend/testdata/as/go/models.go
diff --git a/internal/endtoend/testdata/case_stmt_bool/go/models.go b/internal/endtoend/testdata/case_stmt_bool/go/models.go
diff --git a/internal/endtoend/testdata/cast_coalesce/go/models.go b/internal/endtoend/testdata/cast_coalesce/go/models.go
diff --git a/internal/endtoend/testdata/coalesce/go/models.go b/internal/endtoend/testdata/coalesce/go/models.go
diff --git a/internal/endtoend/testdata/column_as/go/models.go b/internal/endtoend/testdata/column_as/go/models.go
diff --git a/internal/endtoend/testdata/comparisons/go/models.go b/internal/endtoend/testdata/comparisons/go/models.go
diff --git a/internal/endtoend/testdata/composite_type/go/models.go b/internal/endtoend/testdata/composite_type/go/models.go
diff --git a/internal/endtoend/testdata/cte_count/go/models.go b/internal/endtoend/testdata/cte_count/go/models.go
diff --git a/internal/endtoend/testdata/cte_filter/go/models.go b/internal/endtoend/testdata/cte_filter/go/models.go