(sqlite-bind-type) ( handle key value type -- )

Vocabulary

db.sqlite.lib

Inputs

handle	an object
key	an object
value	an object
type	an object

Outputs

None

Definition

USING: arrays calendar.format combinators db.types kernel
present sequences serialize ;

IN: db.sqlite.lib

: (sqlite-bind-type) ( handle key value type -- )
    dup array? [ first ] when {
        { INTEGER [ sqlite-bind-int-by-name ] }
        { BIG-INTEGER [ sqlite-bind-int64-by-name ] }
        { SIGNED-BIG-INTEGER [ sqlite-bind-int64-by-name ] }
        { UNSIGNED-BIG-INTEGER [ sqlite-bind-uint64-by-name ] }
        { BOOLEAN [ sqlite-bind-boolean-by-name ] }
        { TEXT [ sqlite-bind-text-by-name ] }
        { VARCHAR [ sqlite-bind-text-by-name ] }
        { DOUBLE [ sqlite-bind-double-by-name ] }
        { DATE [ timestamp>ymd sqlite-bind-text-by-name ] }
        { TIME [ duration>hms sqlite-bind-text-by-name ] }
        {
            DATETIME
            [ timestamp>ymdhms sqlite-bind-text-by-name ]
        }
        {
            TIMESTAMP
            [ timestamp>ymdhms sqlite-bind-text-by-name ]
        }
        { BLOB [ sqlite-bind-blob-by-name ] }
        {
            FACTOR-BLOB
            [ object>bytes sqlite-bind-blob-by-name ]
        }
        { URL [ present sqlite-bind-text-by-name ] }
        { +db-assigned-id+ [ sqlite-bind-int-by-name ] }
        { +random-id+ [ sqlite-bind-int64-by-name ] }
        { NULL [ sqlite-bind-null-by-name ] }
        [ no-sql-type ]
    } case ;