pyocient Release Notes

3 4 0 added support for the preview ddl sql statement support cryptography versions greater than 42 0 0 fixed an issue that returned 1 rows modified fixed the handling of an invalid dsn on the pyocient cli formatted unicode characters in json output fixed an issue where not all warnings were reported added the messages attribute to the cursor improved parameter expansion supported loglevel and logfile parameters on dsns preserved the connection object for reconnects 3 3 2 fixed ending sso sessions when you close the connection 3 3 0 pinned the cryptography package to a version earlier than 42 0 0 for stability purposes added oidc single sign on (sso) added the performance mode command enabled the display of nulls as null when using the table format set the command line default fetch size to 30000 fixed the implementation of the set serviceclass command changed pyocient warning to be a subclass of the {{python}} warning class added the set printuuid on command added the version option at the command line set the tcp keepalive options on connections added a valid error message when the system rejects a connection without ssl encryption 3 0 3 the typecodes class has been changed to a python intenum gis types stpoint, stlinestring, and stpolygon have been renamed to stpoint, stlinestring, and stpolygon, respectively the user and password fields have been removed from the connection object this object no longer stores these fields you can pass the security token from another connection to the connect function the session object has been removed the custom type to json function has been moved into the pyocient api to allow the consistent conversion of the result set to the json format the patch portion of the pyocient version is sent to and logged in the database the nooutput command line parameter does not throw a python exception the local variable 'return code' referenced before assignment error has been fixed added the rows argument to the command line program to load the result set in batches 2 0 0 packaging has been significantly refactored to match python® packaging standards python context manager support has been added to connections and cursors python type annotations have been added to the pyocient api fixed the command line interface (cli) to return a non zero code for statements that fail cli output has been standardized to either go to the output file or standard output (stdout) the option to echo statements has been added as a command line option the pyocient syntaxerror exception, which conflicted with the built in python syntaxexception , has been removed pyocient version has been removed in favor of the more standard pyocient version 1 0 15 the dependency on protobuf has been upgraded from >=3 12 0 , <=3 19 1 to >=3 20 0 , <=4 22 0 fixed an error that occurs when you do not specify the host parameter in the connect() api 1 0 14 updated pyocient dependencies to eliminate some unused dependencies and tighten the dependencies on protobuf and dsnparse 1 0 13 fixed bug that left cursor rowcount unset after data manipulation language (dml) query execution the cryptography package requirement of version 36 or lower is no longer required 1 0 12 added nohistory command line option the history file does not store commands from the session added ignorespace option to command line history the history file omits lines that begin with a white space character 1 0 11 added a link to the release notes to the package description 1 0 10 fixed error in the parameter substitution docstring added support for serviceclass , adjustfactor , adjusttime , and pso query settings added support for the show command added support for the cancel task command removed support for priority adjustment factor , priority adjustment time , min priority , and max priority query settings deprecate support for the check data command fixed output of binary types at the command line 1 0 9 added csv output support updated cryptography package dependency from <3 4 to <=36 0 updated cffi and google auth dependencies improved decoding performance by caching the decoders added formal stpoint, stlinestring, and stpolygon classes rather than using tuples and lists added support for priority adjustment factor, priority adjustment time, min priority, and max priority query settings enabled the handling of invalid dns names received from the database 1 0 7 fixed crash on invalid utf 8 characters received from the database fixed a bug related to specifying the user through the connect api standardized python(r) code formatting 1 0 6 updated handling of the force option on connections for accuracy 1 0 5 added additional debug logging to the redirection of connection 1 0 4 updated the redirect logic for accuracy 1 0 3 added multiple host support to the dsn removed tables, systables, and views command line options added support for the source, connect to, and set commands added support for starting without a dsn