Ability to execute insert/update statements with the CLI

[simonw]

$ sqlite-utils github.db "update stars set starred_at = ''"
Traceback (most recent call last):
  File "/Users/simon/.local/bin/sqlite-utils", line 8, in <module>
    sys.exit(cli())
  File "/Users/simon/.local/pipx/venvs/sqlite-utils/lib/python3.8/site-packages/click/core.py", line 829, in __call__
    return self.main(*args, **kwargs)
  File "/Users/simon/.local/pipx/venvs/sqlite-utils/lib/python3.8/site-packages/click/core.py", line 782, in main
    rv = self.invoke(ctx)
  File "/Users/simon/.local/pipx/venvs/sqlite-utils/lib/python3.8/site-packages/click/core.py", line 1259, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/Users/simon/.local/pipx/venvs/sqlite-utils/lib/python3.8/site-packages/click/core.py", line 1066, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/Users/simon/.local/pipx/venvs/sqlite-utils/lib/python3.8/site-packages/click/core.py", line 610, in invoke
    return callback(*args, **kwargs)
  File "/Users/simon/.local/pipx/venvs/sqlite-utils/lib/python3.8/site-packages/sqlite_utils/cli.py", line 673, in query
    headers = [c[0] for c in cursor.description]
TypeError: 'NoneType' object is not iterable

[simonw]

sqlite-utils/tests/test_cli.py

Lines 1112 to 1128 in 03ee97d

	@pytest.mark.parametrize(
	"args,expected",
	[
	([], '[{"rows_affected": 1}]',),
	(["-t"], "rows_affected\n---------------\n 1"),
	],
	)
	def test_query_update(db_path, args, expected):
	db = Database(db_path)
	with db.conn:
	db["dogs"].insert_all(
	[{"id": 1, "age": 4, "name": "Cleo"},]
	)
	result = CliRunner().invoke(
	cli.cli, [db_path, "update dogs set age = 5 where name = 'Cleo'"] + args
	)
	assert expected == result.output.strip()