function
/usr/local/lib/janet/db/sqlite/db.janet on line 45 , column 1
(query sql &opt params table-name )
Executes a query against a sqlite database.
Example:
(import db )
(db/query "select * from todos" )
# or
(db/query "select * from todos where id = :id" {:id 1 })
=> [{:id 1 :name "name" } {... } ... ]
# can execute query from a file like:
(db/query (slurp "db/sql/random.sql" ))
# In context:
(defn show [request ]
(when-let [[name ] (request :wildcard )
name (uri/unescape name ) # escaping is important for = and especially %
name (string/replace "_q" "?" name )
binding (first (db/query (slurp "db/sql/search.sql" ) [name ]))]
[:vstack {:spacing "m" }
(binding-header binding )
(examples/index (merge request {:binding binding }))]))
# From https://codeberg.org/veqq/janetdocs/src/commit/ac1dc9e3e82f17e8e9ac047297b00803b68034d0/routes/examples.janet#L217