Documentation
¶
Overview ¶
Package series gives SQLite generate_series, the table-valued function of SQLite's series extension (ext/misc/series.c), ported to Go:
sqlite.NewConnector(dsn, series.Option())
Then:
SELECT value FROM generate_series(start, stop, step)
gives start, start+step, ... up to stop. stop defaults to 4294967295 and step to 1, a step of 0 is 1, and a negative step counts down from start to stop. start may be left out when a WHERE clause bounds value instead: generate_series WHERE value BETWEEN 1 AND 10. A NULL argument gives no rows. The hidden columns start, stop and step give the arguments.
The arguments are 64-bit integers. A REAL is cut to an integer as SQLite's own does. A TEXT or BLOB argument, or one compared with value in the WHERE clause (value = '5', or a Go string bound to value = ?), is an error where SQLite's would read the number at its start: write CAST(x AS INTEGER).
Where SQLite's own gives wrong rows or fails, this one gives the right rows: a LIMIT with an ORDER BY the sequence does not follow on its own (ORDER BY rowid DESC LIMIT 3), a REAL compared with value at the ends of the 64-bit range, a join that gives the start through value (JOIN generate_series s ON s.value = t.x), and a LIMIT on a sequence that counts down.
Example ¶
package main
import (
"database/sql"
"fmt"
"github.com/liustack/sqlite"
"github.com/liustack/sqlite/ext/series"
)
func main() {
c, err := sqlite.NewConnector(":memory:", series.Option())
if err != nil {
panic(err)
}
db := sql.OpenDB(c)
defer db.Close()
rows, err := db.Query(`SELECT value FROM generate_series(0, 20, 5)`)
if err != nil {
panic(err)
}
defer rows.Close()
for rows.Next() {
var v int
if err := rows.Scan(&v); err != nil {
panic(err)
}
fmt.Print(v, " ")
}
if err := rows.Err(); err != nil {
panic(err)
}
fmt.Println()
}
Output: 0 5 10 15 20
Index ¶
Examples ¶
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
Types ¶
This section is empty.