damionw/pythonbcp

BCP for SQLServer from Python

Python BCP

Overview

Python BCP is a python module that facilitates direct BCP data transfers to a SQL Server database

Build requirements

FreeTDS is required, as are the Python development headers and libraries.

Running setup.py works as you'd normally expect

Windows

On Windows, Anaconda is recommended

See:

• Building Packages with Anaconda and ...the build tutorial
• Installing FreeTDS
• Binaries

TODO

• Test suite
• OSX build

pythonbcp's Issues

Malformed data being sent to the database

I'm not sure how much it's a bug and how much some kind of "undocumented behavior".
environment: CentOS 7, Python 3.7.7, package installed with pip install .
My code:

@contextmanager
def connection():
    bcp_connection = bcp.Connection(
        server="*", username="*", password="*", database="*", batchsize=16,
    )
    yield bcp_connection
    bcp_connection.disconnect()


def main():
    datasets = [
        [[1, 1], [2, 2]],
        [[5, 5], [6, 6]],
        [[1, 1], [2, 2]]  # this should cause a PK conflict
    ]
    with connection() as bcp_connection:
        for data in datasets:
            bcp_connection.init(TABLE)
            for row in data:
                bcp_connection.send(row)
            bcp_connection.commit()


if __name__ == "__main__":
    main()

Final result in database is:

1		1
2		2
35848246	35848246
1726742581	1726742581
35848242	35848242
1726742577	1726742577

Everything works as it should when I make a reconnection after each commit.