issue_comments: 982078527

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/346#issuecomment-982078527 https://api.github.com/repos/simonw/sqlite-utils/issues/346 982078527 IC_kwDOCGYnMM46iVQ_ 9599 2021-11-29T22:23:03Z 2021-11-29T22:23:03Z OWNER

Here's a modified version of the dump command that works even with pysqlite3:

```python @cli.command() @click.argument( "path", type=click.Path(exists=True, file_okay=True, dir_okay=False, allow_dash=False), required=True, ) @load_extension_option def dump(path, load_extension): """Output a SQL dump of the schema and full contents of the database""" db = sqlite_utils.Database(path) _load_extensions(db, load_extension) # pysqlite3 doesn't implement .iterdump() from sqlite3.dump import _iterdump

for line in _iterdump(db.conn):
    click.echo(line)

```

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