sqlite-utils create-table ... --if-not-exists

[simonw]

Inspired by:

• Support IF NOT EXISTS for table creation #397

To match the option on create-index: https://sqlite-utils.datasette.io/en/stable/cli-reference.html#create-index

  --if-not-exists        Ignore if index already exists

[simonw]

Actually this is not needed - there is already an option that does this, it's just called --ignore rather than --if-not-exists.

The lack of consistency here is a little annoying, but not annoying enough to justify making a backwards incompatible change.

% sqlite-utils create-table --help
Usage: sqlite-utils create-table [OPTIONS] PATH TABLE COLUMNS...

  Add a table with the specified columns. Columns should be specified using
  name, type pairs, for example:

      sqlite-utils create-table my.db people \
          id integer \
          name text \
          height float \
          photo blob --pk id

Options:
  --pk TEXT                 Column to use as primary key
  --not-null TEXT           Columns that should be created as NOT NULL
  --default <TEXT TEXT>...  Default value that should be set for a column
  --fk <TEXT TEXT TEXT>...  Column, other table, other column to set as a
                            foreign key
  --ignore                  If table already exists, do nothing
  --replace                 If table already exists, replace it
  --load-extension TEXT     SQLite extensions to load
  -h, --help                Show this message and exit.