db-open ( db -- db-connection )
Furnace framework » Database library » Low-level database protocol

Next:

db-close ( handle -- )

Vocabulary
db

Inputs

db	a database configuration object

Outputs

db-connection

a db-connection

Word description
Opens a database using the configuration data stored in a database configuration object tuple. The database object now references a database handle that must be cleaned up. Therefore, it is better to use the with-db combinator than calling this word directly.

See also
db-close, with-db

Definition

IN: db

GENERIC: db-open ( db -- db-connection )

Methods

USING: accessors alien.c-types alien.data combinators db
db.mysql db.mysql.ffi db.private kernel ;

M: mysql-db db-open
    f mysql_init dup
    [ "Not enough memory to allocate mysql handle." throw ]
    unless dup 20 1 int <ref> mysql_options drop dup rot {
        [ host>> ]
        [ user>> ]
        [ password>> ]
        [ db>> ]
        [ port>> 0 or ]
    } cleave f 0 mysql_real_connect [ mysql_error throw ] unless
    mysql-db-connection new-db-connection swap >>handle ;


USING: accessors combinators db db.postgresql db.postgresql.lib
db.postgresql.private ;

M: postgresql-db db-open
    {
        [ host>> ]
        [ port>> ]
        [ pgopts>> ]
        [ pgtty>> ]
        [ database>> ]
        [ username>> ]
        [ password>> ]
    } cleave connect-postgres <postgresql-db-connection> ;


USING: accessors db db.sqlite db.sqlite.lib db.sqlite.private ;

M: sqlite-db db-open path>> sqlite-open <sqlite-db-connection> ;