◊(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



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?)]) hash?]
@defproc*[([(select-rows! [query statement?] [fieldnames (listof stringish?)]) (listof hash?)]
           [(select-rows! [table stringish?] [fieldnames (listof stringish?)] [where-clause
              stringish?]) hash?])]
              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 hash table whose keys are the field names supplied.
Returns a list of hashes whose keys are the values supplied in @racket[_fieldnames].

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.
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.