db vocabulary
Factor handbook » Vocabulary index

Documentation
Database library

Metadata

Tags:	enterprise
Authors:	Doug Coleman

Words

Tuple classes

Class	Superclass	Slots
db-connection	disposable	handle insert-statements update-statements delete-statements
prepared-statement	statement
result-set	disposable	sql in-params out-params handle n max
simple-statement	statement
statement	disposable	handle sql in-params out-params bind-params bound? type retries

Generic words

Word	Stack 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

Word	Stack 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	( ... result-set quot: ( ... result-set -- ... ) -- ... )
query-map	( result-set quot: ( result-set -- elt ) -- 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

Word	Stack effect
db-connection?	( object -- ? )
prepared-statement?	( object -- ? )
result-set?	( object -- ? )
simple-statement?	( object -- ? )
statement?	( object -- ? )

Files

resource:basis/db/db.factor
resource:basis/db/db-docs.factor
resource:basis/db/db-tests.factor

Metadata files

resource:basis/db/authors.txt
resource:basis/db/summary.txt
resource:basis/db/tags.txt

Children from resource:basis

Vocabulary	Summary
db.errors	Errors thrown by database library
db.pools	Database connection pooling
db.postgresql	PostgreSQL database connector
db.queries	Database queries
db.sqlite	SQLite database connector
db.tester
db.tuples	O/R mapper
db.types	SQL data type support

Children from resource:extra

Vocabulary	Summary
db.mysql	MySQL database binding