Can't use trustservercertificate=yes bcp

[raulcsouza]

Was not possible to set the parameter -u that permit Trust server certificate. (available since bcp version 18).

https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/connecting-with-bcp?view=sql-server-ver16

I did the modification below and works:

def bcp(sql_table, flat_file, batch_size):
"""Runs the bcp command to transfer the input flat file to the input
SQL Server table.
:param sql_table: The destination Sql Server table
:type sql_table: SqlTable
:param flat_file: Source flat file
:type flat_file: FlatFile
:param batch_size: Batch size (chunk size) to send to SQL Server
:type batch_size: int
"""
if sql_table.with_krb_auth:
auth = ['-T']
else:
auth = ['-U', sql_table.username , '-P', sql_table.password ]
full_table_string =
f'{sql_table.database}.{sql_table.schema}.{sql_table.table}'
try:
bcp_command = ['bcp', full_table_string, 'IN', flat_file.path, '-f',
flat_file.get_format_file_path(), '-S',
sql_table.server, '-b', str(batch_size), '-u'] + auth