sqlc - Playground

sqlc generate failed.

Input
query.sql
sqlc.json
sqlc-version.txt

xxxxxxxxxx
 
-- name: CTERecursive :many
WITH RECURSIVE t(n) AS (
    VALUES (1)
  UNION ALL
    SELECT n+1 FROM t WHERE n < 100
)
SELECT sum(n) FROM t;
​

Output
db/db.go
db/models.go
db/query.sql.go

xxxxxxxxxx
 
// Code generated by sqlc. DO NOT EDIT.
// versions:
//   sqlc v1.15.0
// source: query.sql
​
package db
​
import (
    "context"
)
​
const cTERecursive = `-- name: CTERecursive :many
WITH RECURSIVE t(n) AS (
    VALUES (1)
  UNION ALL
    SELECT n+1 FROM t WHERE n < 100
)
SELECT sum(n) FROM t
`
​
func (q *Queries) CTERecursive(ctx context.Context) ([]int64, error) {
    rows, err := q.db.QueryContext(ctx, cTERecursive)
    if err != nil {
        return nil, err
    }
    defer rows.Close()
    var items []int64
    for rows.Next() {
        var sum int64
        if err := rows.Scan(&sum); err != nil {
            return nil, err
        }
        items = append(items, sum)
    }
    if err := rows.Close(); err != nil {
        return nil, err
    }
    if err := rows.Err(); err != nil {
        return nil, err
    }
    return items, nil
}
​