sqlite-utils create-table command

[simonw]

Spun off from #24 - it would be useful if CLI users could create new tables (with explicit column types, not null rules and defaults) without having to insert an example record.

• Get it working
• Support --pk
• Support --not-null
• Support --default
• Support --fk colname othertable othercol
• Support --replace and --ignore
• Documentation

[simonw]

Potential syntax:

$ sqlite-utils create-table foo.db dogs \
    id integer \
    name string \
    age integer \
    --pk=id

[simonw]

Copy the design for --not-null and --default from the insert command:

$ sqlite-utils insert dogs.db dogs_with_scores dogs-with-scores.json \
    --not-null=age \
    --not-null=name \
    --default age 2 \
    --default score 5

[simonw]

Could take --ignore to ignore if table already exists, and --replace to drop and replace it if it exists.

[simonw]

I need tests for what happens if table already exists, or if the user provides invalid column types.

[simonw]

Supporting --fk colname othertable othercol would be neat too.

[simonw]

Be nice if you could do --fk colname and have it guess the rest, but I'm not sure how to do that with a CLI option - they need a fixed number of arguments so that they don't consume the next batch of options.

[simonw]

I'll stick with requiring all three fk arguments.

[simonw]

Documentation: https://github.com/simonw/sqlite-utils/blob/78264b738cd72ffad6e5c32ede3f074f8aad0ca4/docs/cli.rst#creating-tables