Changeset 36410 in project


Ignore:
Timestamp:
08/25/18 13:31:28 (3 months ago)
Author:
svnwiki
Message:

Anonymous wiki edit for IP [185.220.101.44]:

File:
1 edited

Legend:

Unmodified
Added
Removed
  • wiki/eggref/5/sqlite3pth

    r36409 r36410  
    1717== API
    1818
    19 Currently only lightly documented at
    20 [[https://github.com/0-8-15/sqlite3pth/|documented here]] at github.
    21 
    2219<procedure>(:sql-result: string --> (or false fixnum))</procedure>
    2320convert field name to index
     21
    2422<procedure>(: sqlite3-prepare ((struct <sqlite3-database>) string --> (struct <sqlite3-statement>)))</procedure>
     23
     24Prepare query.
     25
    2526<procedure>(: sqlite3-exec ((struct <sqlite3-database>) (or string (struct <sqlite3-statement>)) #!rest -> :sql-result:))</procedure>
    26 <procedure>(: sqlite3-call-with-transaction
    27        ((struct <sqlite3-database>)
    28         (procedure ((procedure (string #!rest) :sql-result:)) :sql-result:)
    29        -> :sql-result:))</procedure>
     27
     28Execute statement or prepared query.
     29
     30<procedure>(: sqlite3-call-with-transaction ((struct <sqlite3-database>) (procedure ((procedure (string #!rest) :sql-result:)) :sql-result:) -> :sql-result:))</procedure>
     31
     32Call procedure in a sqlite transaction.
     33
    3034<procedure>sqlite3-call-test/set</procedure>
    3135questionable, undocumented
     36
    3237<procedure>(: sqlite3-close ((struct <sqlite3-database>) -> . *))</procedure>
     38
     39Close database.
     40
    3341<procedure>sqlite3-interrupt!</procedure>
     42
     43Call sqlite_interrupt to abort running query.
     44
    3445<procedure>sql-result?</procedure>
    35 test result type
     46
     47Test predicate for the sql result type.
     48
    3649<procedure>(sql-value RESULT ROW FIELD) --> *</procedure>
    3750
     51Result Accessor.
     52
    3853<procedure>(: sql-ref (:sql-result: (or boolean fixnum) (or boolean fixnum string symbol) --> *))</procedure>
     54
    3955<procedure>(: sql-fold (:sql-result: (procedure ((procedure (fixnum) *) *) *) * -> *))</procedure>
     56
     57Fold procedure over results.
    4058
    4159<procedure>sqlite3-open</procedure>
     
    5775
    5876    sqlite3-error? sqlite3-error-code sqlite3-error-args
    59 <procedure>sqlite3-error-db-locked?
     77
     78<procedure>sqlite3-error-db-locked?</procedure>
    6079
    6180=== debug aid
    62 <procedure>(sqlite3-debug-statements FLAG)
     81<procedure>(sqlite3-debug-statements FLAG)</procedure>
    6382
    6483Log queries.
     84
     85== VFS Interface
     86
     87The VFS allows to call back to Chicken when sqlite need to read data.
     88
     89This is currently only lightly documented in
     90[[https://github.com/0-8-15/sqlite3pth/blob/master/tests/run.scm|tests/run.scm]].
     91
    6592
    6693== Examples
Note: See TracChangeset for help on using the changeset viewer.