Running error in python3, ubuntu18.04 environment，Where is the problem?

[ericwang321]

Running error in python3, ubuntu18.04 environment，Where is the problem?

[mikealfare]

@myahl You're correct, I should add that to the docs. I also have an outstanding issue (#11) to specify it on the Connection instance. I might actually get to that in the next few weeks.

[ari-bradharker]

Hey Eric, I have been able to follow what you and Mike are discussing and am wondering what you mean by "solved by directly adjusting the bcp command line through python"? You are changing the output from the library and then calling the execution?

[ericwang321]

Python directly calls the external command /opt/mssql-tools/bin/bcp....

[mikealfare]

Good catch. The readme is incorrect. DataFile() is expecting a Path object, not a string. I should probably handle that in the class itself and allow a string to be passed in. In the meantime, import pathlib.Path and wrap your file_path in Path().

[ericwang321]

Added path lib, the operation is still wrong, compared to the bcp command line, found that Python BCP originally lacked the database option -d.
currently it is solved by directly adjusting the bcp command line through python.

hope there is time to change the readme. Thank you!

[ericwang321]

close issue temporarily

[myahl]

@ericwang321 I don't understand how to specify the database option either.

Added path lib, the operation is still wrong, compared to the bcp command line, found that Python BCP originally lacked the database option -d.
currently it is solved by directly adjusting the bcp command line through python.

This doesn't really clear it up for me.

Python directly calls the external command /opt/mssql-tools/bin/bcp....

What exactly do I need to do in order to specify the database?

Edit: Never mind. I see in the tests that you're specifying it as part of the table name database.schema.table. This could probably be made clearer in the docs though.