interface{} generated but I think sqlc should generate NullString #1095

Activity

1. kyleconroy commented on Aug 11, 2021

   

   kyleconroy

   on Aug 11, 2021

   Collaborator

   More actions

   Fixed in #1113

   create table companies (sid text not null, description text);
   
   create table controllers (sid text not null, company_sid text, name text);
   
   -- name: GetCompanySlug :many
   SELECT *, (
       SELECT description
       FROM companies
       WHERE controllers.company_sid = companies.sid
   ) AS "company_slug"
   FROM controllers WHERE controllers.name = $1;

   const getCompanySlug = `-- name: GetCompanySlug :many
   SELECT sid, company_sid, name, (
       SELECT description
       FROM companies
       WHERE controllers.company_sid = companies.sid
   ) AS "company_slug"
   FROM controllers WHERE controllers.name = $1
   `
   
   type GetCompanySlugRow struct {
   	Sid         string
   	CompanySid  sql.NullString
   	Name        sql.NullString
   	CompanySlug sql.NullString
   }
   
   func (q *Queries) GetCompanySlug(ctx context.Context, name sql.NullString) ([]GetCompanySlugRow, error) {
   	rows, err := q.db.QueryContext(ctx, getCompanySlug, name)
   	if err != nil {
   		return nil, err
   	}
   	defer rows.Close()
   	var items []GetCompanySlugRow
   	for rows.Next() {
   		var i GetCompanySlugRow
   		if err := rows.Scan(
   			&i.Sid,
   			&i.CompanySid,
   			&i.Name,
   			&i.CompanySlug,
   		); err != nil {
   			return nil, err
   		}
   		items = append(items, i)
   	}
   	if err := rows.Close(); err != nil {
   		return nil, err
   	}
   	if err := rows.Err(); err != nil {
   		return nil, err
   	}
   	return items, nil
   }
2. kyleconroy

   closed this as completedon Aug 11, 2021