v0.3.0

Enhancements

• Added parameter to specify which shell to use for the BCP command. Useful on Linux if BCP is only found in PATH for some shells and not others

Deprecated read_sql

General

• Deprecated the read_sql function
• Added support for Python 3.8

Documentation

• Added section about not using the bcpandas read_sql
• Added benchmark for read_sql

to_sql fully tested and benchmarked; removed sqlcmd dep

General

• Fully tested the to_sql method
• Added cases in to_sql when the table doesn't exists
• Started improving and testing read_sql, still not done. Not fully tested yet.
• Removed all dependencies on the SqlCmd tool
• Added initial support for Linux

Development Tools

• Created .devcontainer.json for working in VS Code, with a DockerFile and docker-compose.yml
• Now uses pre-commit
• Now uses hypothesis in testing
• Created env.yml for use with conda
• Config file for flake8, pytest, isort, and mypy

Documentation

• Added benchmarks code and graph for to_sql
• Added table to compare using bcpandas vs. regular pandas

Initial Linux Support in subprocess

v0.2.6

added Shell=True param in run_cmd for linux

Added back license

v0.2.5

v0.2.5

Distribution fixes

v0.2.3

fixed dist stuff, cleaned up

Bug fix with GitHub Actions

v0.2.2

Update dist.json

Tweaked docs, added GitHub Actions

v0.2.1

Create pythonpublish.yml

v0.2.0 Release

Major Changes:

• Better docs
• Suppressed output from command line tools in __init__.py
• In to_sql with if_exists='replace', now uses pandas's own internal code to create the new SQL table from the dataframe, including preserving the column types and other schema information. Big improvement over the default NVARCHAR columns that was until now.
• SqlCreds now creates a sqlalchemy.Engine, and can also be created from one.
• bcp now outputs STDOUT in real time, instead of waiting until the process is complete
• Bug fix in creating BCP format file if the column name was not a string
• Started working on benchmark tests, using pytest-benchmark
• Added dependencies to support the sqlalchemy.Engine object

v0.1.8 Release

• Added flags to BCP and SqlCmd to SET QUOTED_IDENTIFIERS to ON, needed for Azure SQL Data Warehouse