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 dup <odbc-env-destructor> &dispose drop
            swap odbc-connect
            dup <odbc-dbc-destructor> &dispose drop
        ]
    ] dip [
        [
            odbc-prepare
            dup <odbc-statement-destructor> &dispose
            [ drop odbc-execute ] [ drop odbc-get-all-rows ]
            [ nip dispose ] 2tri
        ] with map
    ] curry compose with-destructors ;