Can't use type from the same package #819

Activity

1. kyleconroy

   added

   documentationImprovements or additions to documentationImprovements or additions to documentation

   🔧 golang

   📚 postgresql

   on Jan 23, 2021
2. kyleconroy commented on Jan 23, 2021

   

   kyleconroy

   on Jan 23, 2021

   Collaborator

   More actions

   @maratori This was actually fixed in #785, but I haven't updated the documentation in the README. You need to change how you're using the go_type value in the override. Also note that your example had a typo /s/BooksParams/BookParams.

   # sqlc.yaml
   version: "1"
   packages:
     - name: "db"
       path: "db"
       queries: "db/queries.sql"
       schema: "db/schema.sql"
   overrides:
     - column: "books.params"
       go_type:
         type: "BookParams"
   

   Here's the rest of the working code:

   $ tree .
   .
   ├── db
   │   ├── db.go
   │   ├── models.go
   │   ├── params.go
   │   ├── queries.sql
   │   └── schema.sql
   └── sqlc.yaml

   -- db/schema.sql
   
   CREATE TABLE books (
       id UUID NOT NULL PRIMARY KEY,
       title VARCHAR NOT NULL,
       params JSONB NOT NULL
   );

   -- db/queries.sql
   
   --name: ListBooks :many
   SELECT * FROM books;

   // db/params.go
   
   package db
   
   import (
   	"database/sql/driver"
   	"encoding/json"
   	"fmt"
   )
   
   type BookParams struct {
   	Foo string `json:"foo,omitempty"`
   	Bar *int   `json:"bar,omitempty"`
   }
   
   func (p BookParams) Value() (driver.Value, error) {
   	return json.Marshal(p)
   }
   
   func (p *BookParams) Scan(src interface{}) error {
   	var source []byte
   	switch t := src.(type) {
   	case string:
   		source = []byte(t)
   	case []byte:
   		source = t
   	case nil:
   		return nil
   	default:
   		return fmt.Errorf("incompatible data type %T", src)
   	}
   	if len(source) == 0 {
   		return nil
   	}
   	return json.Unmarshal(source, p)
   }

   The following works on my machine:

   $ sqlc generate
   $ go build ./...
3. kyleconroy

   closed this as completedon Jan 23, 2021
4. maratori commented on Jan 23, 2021

   

   maratori

   on Jan 23, 2021

   Author

   More actions

   @kyleconroy Thanks, it works!