◊(Local Yarn Code "Check-in [4e28f613]")

Overview
Comment:Correct scribble doc for select-rows!
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 4e28f61318bbc3a97e8f7ff5c07aa27e667caf75ef49fb853e5b2d57f24c6365
User & Date: joel on 2019-03-24 00:50:57
Other Links: manifest | tags
Context
2019-03-31
20:19
Remove attr-present (redundant) check-in: fdc47974 user: joel tags: trunk
2019-03-24
21:42
First draft of possible new license check-in: eb6e328e user: joel tags: licensing
00:50
Correct scribble doc for select-rows! check-in: 4e28f613 user: joel tags: trunk
2019-03-20
01:04
Fix missing cross-ref links [d8b9f6f7] check-in: d439b95f user: joel tags: trunk
Changes

Modified code-docs/sqlite-tools.scrbl from [abe45797] to [a2f9cc08].

187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203

already holds an active connection, it will be @racket[disconnect]ed and then replaced with the new
connection.

@defproc[(query! [query-statement statement?] [parameters any/c] ...) void?]

Executes a SQL statement using the current connection.

@defproc*[([(select-rows! [query statement?] [fieldnames (listof stringish?)]) hash?]
           [(select-rows! [table stringish?] [fieldnames (listof stringish?)] [where-clause
              stringish?]) hash?])]

Execute a SQL query that returns rows from the database, either using a raw query (first form
above), or using a table name, field names, and a @racket[_where-clause] (second form above).
Returns a hash table whose keys are the field names supplied.

In the first form, @racket[_fieldnames] should list all the fields that will be returned by the
query, in order, since this list will be used as the keys for the hash table result.








|

|



|

|
|
>
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
already holds an active connection, it will be @racket[disconnect]ed and then replaced with the new
connection.

@defproc[(query! [query-statement statement?] [parameters any/c] ...) void?]

Executes a SQL statement using the current connection.

@defproc*[([(select-rows! [query statement?] [fieldnames (listof stringish?)]) (listof hash?)]
           [(select-rows! [table stringish?] [fieldnames (listof stringish?)] [where-clause
              stringish?]) (listof hash?)])]

Execute a SQL query that returns rows from the database, either using a raw query (first form
above), or using a table name, field names, and a @racket[_where-clause] (second form above).
Returns a list of hashes whose keys are the values supplied in @racket[_fieldnames].

In the first form, @racket[_fieldnames] should list @emph{in order} all the fields that will be
returned by the query. If this isn’t done, the keys for each row’s hash will likely point to values
for the wrong fields.