odbc-queries ( dsn strings -- results )

Vocabulary

odbc

Inputs

dsn	a DSN string
strings	a sequence of strings containing SQL

Outputs

results

a sequence

Word description

This word initializes odbc, connects to the database with the given DSN, executes the query strings and returns the result as a sequence. It cleans up all resources it uses.

Examples

"DSN=snowflake; UID=sheeple; PWD=sekrit" { "select 1" "select 2" "select 3" } odbc-queries

See also

odbc-init, odbc-connect, odbc-disconnect, odbc-prepare, odbc-free-statement, odbc-execute, odbc-next-row, odbc-number-of-columns, odbc-describe-column, odbc-get-field, odbc-get-row-fields, odbc-get-all-rows, odbc-query

Definition

USING: destructors kernel sequences ;

IN: odbc

: odbc-queries ( dsn strings -- results )
    [
        [
            odbc-init &odbc-free-env swap odbc-connect
            &odbc-disconnect
        ]
    ] dip [
        [
            odbc-prepare &odbc-free-statement
            [ odbc-execute ] [ odbc-get-all-rows ] [ dispose ]
            tri
        ] with map
    ] curry compose with-destructors ;