db vocabulary
Factor handbook > Vocabulary index


Documentation
Database library

Meta-data
Tags:enterprise
Authors:Doug Coleman


Words

Tuple classes
ClassSuperclassSlots
db-connection tuplehandle insert-statements update-statements delete-statements
prepared-statement statement
result-set tuplesql in-params out-params handle n max
simple-statement statement
statement tuplehandle sql in-params out-params bind-params bound? type retries


Generic words
WordStack effect
#columns( result-set -- n )
#rows( result-set -- n )
<prepared-statement>( string in out -- statement )
<simple-statement>( string in out -- statement )
advance-row( result-set -- )
begin-transaction( -- )
bind-statement*( statement -- )
bind-tuple( tuple statement -- )
commit-transaction( -- )
db-close( handle -- )
db-open( db -- db-connection )
execute-statement*( statement type -- )
low-level-bind( statement -- )
more-rows?( result-set -- ? )
parse-db-error( error -- error' )
prepare-statement( statement -- )
query-results( query -- result-set )
rollback-transaction( -- )
row-column( result-set column -- obj )
row-column-typed( result-set column -- sql )


Symbol words
in-transaction


Ordinary words
WordStack effect
(sql-command)( string -- )
bind-statement( obj statement -- )
default-query( query -- result-set )
dispose-statements( assoc -- )
execute-one-statement( statement -- )
execute-statement( statement -- )
in-transaction?( -- ? )
init-result-set( result-set -- )
new-result-set( query handle class -- result-set )
new-statement( sql in out class -- statement )
query-each( statement quot: ( statement -- ) -- )
query-map( statement quot -- seq )
sql-command( sql -- )
sql-query( sql -- rows )
sql-row( result-set -- seq )
sql-row-typed( result-set -- seq )
with-db( db quot -- )
with-transaction( quot -- )


Class predicate words
WordStack effect
db-connection?( object -- ? )
prepared-statement?( object -- ? )
result-set?( object -- ? )
simple-statement?( object -- ? )
statement?( object -- ? )


Files


Children from resource:basis
VocabularySummary
db.errorsErrors thrown by database library
db.poolsDatabase connection pooling
db.postgresqlPostgreSQL database connector
db.queriesDatabase queries
db.sqliteSQLite database connector
db.testerdb.tester vocabulary
db.tuplesO/R mapper
db.typesSQL data type support


Children
VocabularySummary
db.privatedb.private vocabulary