Csv2db

Latest version: v1.6.1

Safety actively analyzes 681812 Python packages for vulnerabilities to keep your Python projects secure.

Scan your dependencies

Page 1 of 2

1.6.1

Fixed
- Upgraded to oracledb 2.0 driver which no longer supports `encoding` of the connection() function.
- Fixed psycopg binary dependency and install documentation

1.6.0

Added
- New option `--log` to log erroneous lines in a `*.bad` file of the same name (ER 46)
- New option `--ignore` to ignore errors in file and continue loading (ER 46)
- New option `--truncate` to empty (truncate) the target table before the load (ER 45)
- New option `--encoding` to specify the file encoding, if not compatible with `UTF-8` (bug 50)
- New option `--case-insensitive-identifiers` to uppercase all identifiers (ER 60)
- New option `--quote-identifiers` to quote all table and column identifiers (ER 61)
- Release `csv2db` as a Python package (ER 53)

Changed
- Read all input files with `UTF-8` encoding by default
- Upgraded to `oracledb` driver for Oracle Database
- Upgraded to `psycopg (3)` driver for Postgres
- Remove usage of `psycopg2.extras.execute_batch()` as psycopg 3 now supports `executemany()` natively
- Change testing strategy to separate DB loading tests
- Implemented GitHub Action testing

Fixed
- Raise an error when empty column names in the header are encountered (bug 56)

1.5.1

Added
- Added loading tests for all databases
- Enhanced error reporting (ER 37)

Changed
- Added `PROTOCOL=TCPIP` and `AUTHENTICATION=SERVER` to the Db2 connect string.
- Using `psycopg2.extras.execute_batch()` to speed up data load with Postgres (ER 39)

Fixed
- Convert row to tuple on array append (bug 35)
- Use `UTF-8` connection encoding for Oracle (bug 36)

1.5.0

Added
- Interactive password entry (PR 33)

1.4.2

Changed
- Change csv2db description from "the CSV command line loader" to "the CSV to database command line loader"

1.4.1

Added
- Introduce Windows .bat file wrapper

Fixed
- Don't print color codes on Windows (bug 29)

Page 1 of 2

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.