create-table command does not handle compound primary keys

[simonw]

I tried running this:

sqlite-utils create-table compound.db compound \
  category text id integer value text --pk category --pk id

And got this schema:

CREATE TABLE [compound] (
   [category] TEXT,
   [id] INTEGER PRIMARY KEY,
   [value] TEXT
);

[simonw]

The documentation doesn't indicate that this works, but it should work for consistency with how transform works.

https://sqlite-utils.datasette.io/en/stable/cli.html#cli-create-table

[simonw]

Looking at https://sqlite-utils.datasette.io/en/latest/cli-reference.html there are other commands that should accept multiple primary keys as well:

• insert
• upsert
• insert-files

The transform command accepts multiple --pk already.