bug: imports time in querier.go when inserting TIMESTAMP column

[marmiha]

Version

1.21.0

What happened?

Generating code with the given database schema the corresponding querier is generated as such:

// Code generated by sqlc. DO NOT EDIT.
// versions:
// sqlc v1.21.0

package repository

import (
	"context"
	"time"
)

type Querier interface{
	CreateTemporaryDoorLink(ctx context.Context, arg CreateTemporaryDoorLinkParams) (*TemporaryDoorLink, error)
}

var _ Querier = (*Queries)(nil)

where the import time is not used, resulting in unrunable code. I also use golang-migrate.

Relevant log output

No response

Database schema

CREATE TABLE IF NOT EXISTS temporary_door_links (
 id SERIAL PRIMARY KEY,
 token VARCHAR(256) NOT NULL,
 expires_at TIMESTAMP NOT NULL DEFAULT 'now'::timestamp + '14 day'::interval, 
 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
);

SQL queries

-- name: CreateTemporaryDoorLink :one
INSERT INTO temporary_door_links (
 token, max_uses, expires_at
) VALUES (
 $1, $2, $3
) RETURNING *;

Configuration

version: "2"
sql:
 - schema: ../../db/migrations
 queries: sqlc.queries.sql
 engine: postgresql
 database:
 uri: postgresql://${DB_USER}:${DB_PASSWORD}@${DB_HOST}:${DB_PORT}/{DB_NAME}
 gen:
 go:
 package: repository
 out: .
 emit_db_tags: true
 emit_interface: true
 emit_json_tags: true
 emit_result_struct_pointers: true
 rename:
 id: "Id"
 account_id: "AccountId"

Playground URL

No response

What operating system are you using?

Linux

What database engines are you using?

PostgreSQL

What type of code are you generating?

Go

[orisano]

This issue has already been resolved by #2709 (Not yet released)

[marmiha]

Great, thanks, didn't seem to find the linked issue.