Csvs To Sqlite Versions Save

• New options for populating a fixed column - so every inserted row will have the same column with the same value. Options are --fixed-column column-name string-value, --fixed-column-int column-name integer-value and --fixed-column-float column-name float-value. Thanks, William Rowell. #81

• Upgraded dependencies, including Pandas. #73

• --just-strings feature to disable type detection and import columns as strings by default. Thanks, Dan Nguyen!. #58

This release drops support for Python 2.x #55

Bumped dependencies and pinned pytest to version 4 (5 is incompatible with Python 2.7).

• Fixed bug where -f option used FTS4 even when FTS5 was available (#41)

• Support for loading CSVs directly from URLs, thanks @betatim - #38
• New -pk/--primary-key options, closes #22
• Create FTS index for extracted column values
• Added --no-fulltext-fks option, closes #32
• Now using black for code formatting
• Bumped versions of dependencies

• -d and -df options for specifying date/datetime columns, closes #33

• Maintain lookup tables in SQLite, refs #17

• --index option to specify which columns to index, closes #24

• Test confirming --shape and --filename-column and -c work together #25

• Use usecols when loading CSV if shape specified

• --filename-column is now compatible with --shape, closes #10

• --no-index-fks option

  By default, csvs-to-sqlite creates an index for every foreign key column that is added using the --extract-column option.

  For large tables, this can dramatically increase the size of the resulting database file on disk. The new --no-index-fks option allows you to disable this feature to save on file size.

  Refs #24 which will allow you to explicitly list which columns SHOULD have an index created.

• Added --filename-column option, refs #10

• Fixes for Python 2, refs #25

• Implemented new --shape option - refs #25

• --table option for specifying table to write to, refs #10

• Updated README to cover --skip-errors, refs #20

• Add --skip-errors option (#20) [Jani Monoses]

• Less verbosity (#19) [Jani Monoses]

  Only log extract_columns info when that option is passed.

• Add option for field quoting behaviour (#15) [Jani Monoses]

• Add -s option to specify input field separator (#13) [Jani Monoses]

• -f and -c now work for single table multiple columns.

  Fixes #12