gsqlcmd Version History
Version 6.10, October 10, 2023
- Updated providers: MySqlConnector, Npgsql, Oracle.ManagedDataAccess, and System.Data.SQLite.
- gsqlcmd does not read an SQL query from a file in the /table option.
Version 6.9, July 12, 2023
- gsqlcmd ignores the /cookie and /cookieFile options.
- The registration wizard does not display the names of the available languages.
Version 6.8, April 10, 2023
The mode is similar to "make /insert"; however, it generates seed files instead of SQL commands.
You may use the "knex" synonym instead of the "make /knex" command.
You may use a new option, /truncate, to generate the truncate() method instead of delete().
To generate TypeScript files, specify the *.ts file extension.
- gsqlcmd allows specifying MySQL objects without schemas. It uses the active connection database name in this case.
Version 6.7, February 21, 2023
- gsqlcmd uses the MySql.Data.MySqlClient data provider installed on the system.
Prior, gsqlcmd used the provider shipped with the application.
This solution allows installing and using the newest version of the provider:
- gsqlcmd dynamically replaces the missing MySql.Data.MySqlClient data provider with the built-in MySqlConnector provider.
- gsqlcmd reopens Snowflake connections automatically when tokens expire.
- gsqlcmd throws various exceptions when connecting to MySQL 8 using the MySql.Data.MySqlClient.
Version 6.6, January 23, 2023
- Updated .NET and .NET Framework data providers for Snowflake
- Updated the registration wizards (RegisterProduct for Windows and register for Linux)
- Updated AutoUpdate, dbsetup.exe, grx.exe utilities
- gsqlcmd removes leading and trailing spaces in CSV output.
- gsqlcmd may lose decimal precision when outputting data from databases to CSV.
Version 6.5, December 13, 2022
- gsqlcmd is available for .NET 6.0 for Linux and Windows.
- The gsqlcmd examples are released under the MIT license.
Version 6.4, October 19, 2022
- gsqlcmd formats decimal values in CSV format like 6E+09.00.
Version 6.3, October 13, 2022
- gsqlcmd formats integer values with two dots, such as 1..00.
Version 6.2, October 5, 2022
- gsqlcmd rounds output to four or two decimal places if it does not result in loss of precision.
To disable the new mode, use the /noround option.
- gsqlcmd formats numeric values as text in some cases.
- The /DateTimeFormat option ignores date-only formats.
Version 6.1, August 17, 2022
- CSV based SQL commands contain an empty string value instead of NULL in the first line for empty string columns.
- gsqlcmd sometimes incorrectly defines quotes for CSV files in the output FMT file.
Version 6.0, July 5, 2022
A new major release has three new big features:
- gsqlcmd natively supports the Basic, Windows, Forms, OAuth1, OAuth2 authorization methods, contains a complete set of the required options, and allows acquiring the authorization interactively.
- SELECT queries from files and URLs support WHERE and ORDER BY clauses.
- An auto-update tool allows checking and installing software updates.
Changes in End-User License Agreement:
gsqlcmd includes an updated End-User License Agreement.
The most important change:
"Consent to Be Included in the Client List: By purchasing the software on behalf of your company, you implicitly consent to the listing of your company name as our customer. You can revoke this consent at any time by submitting a request."
- gsqlcmd includes the AutoUpdate tool to check and install gsqlcmd updates.
gsqlcmd checks updates according to a customized scheduler.
You can run the update tool manually using the AutoUpdate mode.
- gsqlcmd supports WHERE and ORDER BY clauses in SELECT queries from files and URLs.
- gsqlcmd uses the convert mode by default for inline SELECT queries from files and URLs.
- gsqlcmd supports the following authorization schemas with the Auth option: Auto, None, Basic, Windows, Forms, OAuth1, OAuth2, Custom.
Use a new /interactive option to acquire authorization credentials in the interactive mode.
- gsqlcmd has new OAuth2-specific modes and options.
Modes: get-authcode, get-token, refresh-token, and revoke-token.
Options: /authorizationUrlFormat, /getTokenUrlFormat, /getTokenBodyFormat, /refreshTokenUrlFormat, /refreshTokenBodyFormat, /revokeTokenUrlFormat, /revokeTokenBodyFormat, /authorizationUrl, /getTokenUrl, /refreshTokenUrl, /revokeTokenUrl, /code, /validTo.
- gsqlcmd has new OAuth1-specific modes and options.
Modes: get-authcode, get-token, and refresh-token.
Options: /consumerKey, /consumerSecret, /callback, /requestTokenUrl, /authorizationUrl, /accessTokenUrl, /oauthToken, /oauthTokenSecret, /oauthSessionHandle, /oauthExpiresIn, /validTo.
- gsqlcmd supports user-defined options used in OAuth1 and OAuth2 authorization.
For example, you can set values of the accounts-server option acquired from ZohoCRM to use the values in the /get_token_url_format and /refresh_token_url_format options.
- gsqlcmd has new /cookie and /cookieFile options especially useful with the Forms authorization.
- gsqlcmd has new /urlParameters and /authorizationHeader options used with the custom authorization.
gsqlcmd adds URL parameters to a URL and sets the authorization header of the web requests.
You can achieve the same result specifying an initial URL with the parameters and the header like /header=Authorization: <AuthorizationHeader>.
- gsqlcmd has a new /tokenFields option that explicitly allows specifying fields to save in the /tokenJson file.
- gsqlcmd has a new /serviceJson option designed to load service configurations from JSON or plain text files.
You can split client, service, and token options across the files like /clientJson=client.json /serviceJson=service.json /tokenJson=token.json
- gsqlcmd has a new /acceptEncoding option with the default value: gzip, deflate.
- gsqlcmd reads the default values of the Accept and UserAgent headers from the gsqlcmd.exe.config file.
- Plain text option files can contain line comments starting with the # character.
- gsqlcmd shows the shortest help by default. Use /? to get more help and the help mode to get the full help.
- gsqlcmd outputs the last put options only from Yahoo Finance.
- Version 6.10, October 10, 2023
- Version 6.9, July 12, 2023
- Version 6.8, April 10, 2023
- Version 6.7, February 21, 2023
- Version 6.6, January 23, 2023
- Version 6.5, December 13, 2022
- Version 6.4, October 19, 2022
- Version 6.3, October 13, 2022
- Version 6.2, October 5, 2022
- Version 6.1, August 17, 2022
- Version 6.0, July 5, 2022