issue_comments: 1646688748

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/sqlite-utils/issues/574#issuecomment-1646688748 https://api.github.com/repos/simonw/sqlite-utils/issues/574 1646688748 IC_kwDOCGYnMM5iJnns 9599 2023-07-22T23:12:03Z 2023-07-22T23:13:14Z OWNER

Just tried this out by adding the example from the docs to my sqlite-utils-hello-world plugin and running: bash sqlite-utils install -e ../sqlite-utils-hello-world Obtaining file:///Users/simon/Dropbox/Development/sqlite-utils-hello-world ... Then: bash sqlite-utils memory "select hello('simon')" json [{"hello('simon')": "Hello, simon!"}] Also: ```pycon

import sqlite_utils db = sqlite_utils.Database(memory=True) list(db.query("select hello('simon')")) [{"hello('simon')": 'Hello, simon!'}] db2 = sqlite_utils.Database(memory=True, execute_plugins=False) list(db2.query("select hello('simon')")) Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/Users/simon/Dropbox/Development/sqlite-utils/sqlite_utils/db.py", line 494, in query cursor = self.execute(sql, params or tuple()) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/simon/Dropbox/Development/sqlite-utils/sqlite_utils/db.py", line 512, in execute return self.conn.execute(sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ sqlean.dbapi2.OperationalError: no such function: hello ```

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 1816918185