str and int as aliases for text and integer

[simonw]

I keep making this mistake:

sqlite-utils add-column content.db assets _since int

Usage: sqlite-utils add-column [OPTIONS] PATH TABLE COL_NAME [[integer|float|b
                               lob|text|INTEGER|FLOAT|BLOB|TEXT]]
Try 'sqlite-utils add-column -h' for help.

Error: Invalid value for '[[integer|float|blob|text|INTEGER|FLOAT|BLOB|TEXT]]':
  'int' is not one of 'integer', 'float', 'blob', 'text', 'INTEGER', 'FLOAT', 'BLOB', 'TEXT'.

[simonw]

I'll add bytes too - float already works. This makes sense because when you are working with the Python API you use str and float and bytes and int to specify column types.

[simonw]

Updated documentation:

• https://sqlite-utils.datasette.io/en/latest/cli.html#cli-add-column
• https://sqlite-utils.datasette.io/en/latest/cli-reference.html#add-column