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.