mirrors
/
pgcli
mirror of https://github.com/dbcli/pgcli
1
0
Fork 0
Code
pgcli/changelog.rst

Ignoring revisions in .git-blame-ignore-revs. Click here to bypass and see the normal blame view.

1225 lines
47 KiB
ReStructuredText
Raw Permalink Normal View History

Fix short host (\h) display in prompt when using an IP address (#1441) When connecting to an IPv4 address (`pgcli -h 127.0.0.1`), trying to use the "short host" in the prompt (with `\h`) would only display the first octet (127). Now it shows the full IP. Fixes #964.
2023-11-18 06:38:50 +00:00
Upcoming
========
Support PGAPPNAME (#1444) The application_name to be used when connecting to a database can now be specified as a command line argument (--application-name) or be taken directly from environment variables (PGAPPNAME). It still defaults to 'pgcli' when not specified. Closes #1421.
2023-12-09 04:21:28 +00:00
Features:
---------
* Support `PGAPPNAME` as an environment variable and `--application-name` as a command line argument.
Add verbose_errors config and special command (#1455) * Add verbose_errors config * Update changelog * Add special command * Blackify
2024-03-26 22:31:38 +00:00
* Add `verbose_errors` config and `\v` special command which enable the
displaying of all Postgres error fields received.
* Show Postgres notifications.
dependencies: add support for sqlparse 0.5.x (#1458)
2024-04-25 17:37:29 +00:00
* Support sqlparse 0.5.x
Add --log-file & \log-file option to always capture output (#1461) * Add --log-file & \log-file option to always capture output Currently outputting to a file via \o disables the console output This patch adds a `--log-file` cli arg with similar behavior to `psql`* and a \log-file special command to enable/disable it from the console *https://www.postgresql.org/docs/current/app-psql.html#APP-PSQL-OPTION-LOG-FILE * switch to use context manager Co-authored-by: Irina Truong <637013+j-bennet@users.noreply.github.com> * switch to use context manager Co-authored-by: Irina Truong <637013+j-bennet@users.noreply.github.com> * use isoformat explicitly Co-authored-by: Irina Truong <637013+j-bennet@users.noreply.github.com> * change test to use a mock, update changelog & authors * reformat * black --------- Co-authored-by: Irina Truong <637013+j-bennet@users.noreply.github.com>
2024-05-01 02:03:31 +00:00
* Add `--log-file [filename]` cli argument and `\log-file [filename]` special commands to
log to an external file in addition to the normal output
Support PGAPPNAME (#1444) The application_name to be used when connecting to a database can now be specified as a command line argument (--application-name) or be taken directly from environment variables (PGAPPNAME). It still defaults to 'pgcli' when not specified. Closes #1421.
2023-12-09 04:21:28 +00:00
Fix short host (\h) display in prompt when using an IP address (#1441) When connecting to an IPv4 address (`pgcli -h 127.0.0.1`), trying to use the "short host" in the prompt (with `\h`) would only display the first octet (127). Now it shows the full IP. Fixes #964.
2023-11-18 06:38:50 +00:00
Bug fixes:
----------
* Fix display of "short host" in prompt (with `\h`) for IPv4 addresses ([issue 964](https://github.com/dbcli/pgcli/issues/964)).
Raised notices (#1450) * Fix - Raised notices are printed backwards #1443 * updated changelog * removed a print * fixed up syntax error * removing unneeded Nones from output * rem var due to github recommendation * adjusting if statements.
2024-02-06 05:41:28 +00:00
* Fix backwards display of NOTICEs from a Function ([issue 1443](https://github.com/dbcli/pgcli/issues/1443))
Fix psycopg installation error on windows, Issue #1413 (#1449) * Fix Issue #1413, win32 psycopg * Fix Issue #1413, win32 psycopg * fixing syntax error * black fix to a test --------- Co-authored-by: Irina Truong <637013+j-bennet@users.noreply.github.com>
2024-02-06 05:44:05 +00:00
* Fix psycopg errors when installing on Windows. ([issue 1413](https://https://github.com/dbcli/pgcli/issues/1413))
feat: Replace pendulum by home-made duration-to-words function `pgcli` uses Pendulum to display the query execution time in words: > select pg_sleep(62) +----------+ | pg_sleep | |----------| | | +----------+ SELECT 1 Time: 62.066s (1 minute 2 seconds), executed in: 62.063s (1 minute 2 seconds) Pendulum 3 (which has been released in December 2023 and is now written in Rust) does not build on 32-bit architectures [1]. As such, installing `pgcli` on such architectures fails. We could pin Pendulum to version 2 (which was written in Python and builds "everywhere"), but requiring a whole library and its own dependencies for such a small feature seems unwarranted. This commit thus removes the requirement on Pendulum and replaces it by a simple "duration-to-words" function. Fixes #1451. [1] Upstream issue: https://github.com/sdispater/pendulum/issues/784
2024-02-19 08:36:46 +00:00
* Use a home-made function to display query duration instead of relying on a third-party library (the general behaviour does not change), which fixes the installation of `pgcli` on 32-bit architectures ([issue 1451](https://github.com/dbcli/pgcli/issues/1451))
Fix short host (\h) display in prompt when using an IP address (#1441) When connecting to an IPv4 address (`pgcli -h 127.0.0.1`), trying to use the "short host" in the prompt (with `\h`) would only display the first octet (127). Now it shows the full IP. Fixes #964.
2023-11-18 06:38:50 +00:00
Update changelog before release. (#1432)
2023-10-27 22:55:44 +00:00
==================
Fix changelog date (#1438) * Fix changelog date * Add my name to authors
2023-11-09 01:07:21 +00:00
4.0.1 (2023-10-30)
Update changelog before release. (#1432)
2023-10-27 22:55:44 +00:00
==================
Changed destructive_warning to take a list of destructive commands (#1328) * Changed destructive_warning to take a list of destructive commands and added the dsn_alias as part of the destructive command warning * Updated parse_destructive_warning to handle None * Reverted auto formatted change to AUTHORS * Reverted auto formatted change to AUTHORS
2022-10-13 21:42:22 +00:00
Release the pendulum unbump. (#1435)
2023-10-30 02:18:09 +00:00
Internal:
downgrade pendulum to released version (#1434) * downgrade pendulum to released version * install beta version of pendulum for 3.12
2023-10-29 23:04:00 +00:00
---------
Release the pendulum unbump. (#1435)
2023-10-30 02:18:09 +00:00
* Allow stable version of pendulum.
downgrade pendulum to released version (#1434) * downgrade pendulum to released version * install beta version of pendulum for 3.12
2023-10-29 23:04:00 +00:00
==================
Fix changelog date (#1438) * Fix changelog date * Add my name to authors
2023-11-09 01:07:21 +00:00
4.0.0 (2023-10-27)
downgrade pendulum to released version (#1434) * downgrade pendulum to released version * install beta version of pendulum for 3.12
2023-10-29 23:04:00 +00:00
==================
Changed destructive_warning to take a list of destructive commands (#1328) * Changed destructive_warning to take a list of destructive commands and added the dsn_alias as part of the destructive command warning * Updated parse_destructive_warning to handle None * Reverted auto formatted change to AUTHORS * Reverted auto formatted change to AUTHORS
2022-10-13 21:42:22 +00:00
Features:
---------
Ask for confirmation to quit cli if a transaction is ongoing. (#1400) If user tries to quit the cli while a transaction is ongoing (i.e. begun, but not committed or rolled back yet), pgcli now asks for a confirmation. The user can choose to commit, rollback or cancel the exit. If the user chooses to commit or rollback, we exit only if the commit/rollback succeeds. Fixes #1071.
2023-09-27 04:36:59 +00:00
* Ask for confirmation when quitting cli while a transaction is ongoing.
Add config option to require a transaction for destructive statements When this option is on, any statement that is deemed destructive (through the use of the `destructive_warning` config option) will not be executed unless a transaction has been started.
2023-03-01 16:49:32 +00:00
* New `destructive_statements_require_transaction` config option to refuse to execute a
destructive SQL statement if outside a transaction. This option is off by default.
Changelog.
2023-01-02 22:53:08 +00:00
* Changed the `destructive_warning` config to be a list of commands that are considered
Changed destructive_warning to take a list of destructive commands (#1328) * Changed destructive_warning to take a list of destructive commands and added the dsn_alias as part of the destructive command warning * Updated parse_destructive_warning to handle None * Reverted auto formatted change to AUTHORS * Reverted auto formatted change to AUTHORS
2022-10-13 21:42:22 +00:00
destructive. This would allow you to be warned on `create`, `grant`, or `insert` queries.
* Destructive warnings will now include the alias dsn connection string name if provided (-D option).
magic: use pgcli.connect_uri instead of connect (#1375) This makes %pgcli work even if you use non-password (e.g. TLS cert) authentication
2022-10-28 00:40:19 +00:00
* pgcli.magic will now work with connection URLs that use TLS client certificates for authentication
Add config option to not automatically retry connections with operational errors (#1380)
2022-11-11 17:36:41 +00:00
* Have config option to retry queries on operational errors like connections being lost.
Also prevents getting stuck in a retry loop.
Add config option to not automatically restart connection on destructive warning abort; defaults to not restarting. (#1379)
2022-11-18 04:13:05 +00:00
* Config option to not restart connection when cancelling a `destructive_warning` query. By default,
it will now not restart.
Add config option to always run with a single connection (#1386) Co-authored-by: Irina Truong <i.chernyavska@gmail.com>
2023-01-03 21:52:31 +00:00
* Config option to always run with a single connection.
add comment to pgclirc pager section on default LESS (#1395)
2023-02-27 22:14:48 +00:00
* Add comment explaining default LESS environment variable behavior and change example pager setting.
Drop python 3.7, add 3.12 (#1426) * Fix deprecation. * Drop python 3.7 and add 3.12. * Bump pendulum. * Changelog. * Update gh actions. * See if things pass without this scenario. * Skip failing scenarios in 3.12.
2023-10-11 04:34:59 +00:00
* Added `\echo` & `\qecho` special commands. ([issue 1335](https://github.com/dbcli/pgcli/issues/1335)).
Changelog.
2023-01-02 22:53:08 +00:00
Bug fixes:
----------
Drop python 3.7, add 3.12 (#1426) * Fix deprecation. * Drop python 3.7 and add 3.12. * Bump pendulum. * Changelog. * Update gh actions. * See if things pass without this scenario. * Skip failing scenarios in 3.12.
2023-10-11 04:34:59 +00:00
* Fix `\ev` not producing a correctly quoted "schema"."view"
Changelog.
2023-01-02 22:53:08 +00:00
* Fix 'invalid connection option "dsn"' ([issue 1373](https://github.com/dbcli/pgcli/issues/1373)).
fix explain output when running with auto-vertical-output or max_width (#1396)
2023-02-27 23:20:59 +00:00
* Fix explain mode when used with `expand`, `auto_expand`, or `--explain-vertical-output` ([issue 1393](https://github.com/dbcli/pgcli/issues/1393)).
Fix sql-insert format emits NULL as 'None' (#1409) * Sub: Fix issue #1408 Body: 1. Fix issue #1408 sql-insert format emits NULL as 'None'; 2. Fix DUAL displays as ""DUAL""; ==== End ==== * Sub: Update changelog.rst Body: ==== End ==== * Sub: Optimize if logic Body: ==== End ====
2023-06-23 05:05:58 +00:00
* Fix sql-insert format emits NULL as 'None' ([issue 1408](https://github.com/dbcli/pgcli/issues/1408)).
For Python >= 3.11 directly use packaging to compare package versions (#1416) * For Python >= 3.11 directly use packaging to compare package versions * Improve prompt-toolkit check to test for feature explicitly
2023-09-12 19:46:34 +00:00
* Improve check for prompt-toolkit 3.0.6 ([issue 1416](https://github.com/dbcli/pgcli/issues/1416)).
Allow defining a json file with preferred aliases (#1382) * fix psycopg.sql.Identifier in \ev handling (#1384) * Allow defining a json file with preferred aliases At $WORK we have a lot of tables with names like `foo_noun_verb` or `foo_noun_related-noun_verb` and so while the default aliasing is very helpful for shortening unwieldy names we do end up with lots of aliases like `LEFT JOIN fnv on fnv2.id = fnv.fnv2_id` This change will allow defining a json file of preferred aliases ``` > cat ~/.config/pgcli/aliases.json { "foo_user": "user", "foo_user_group": "user_group" } ``` so the alias suggestion for `SELECT * FROM foo_user` will be `SELECT * FROM foo_user AS user` instead of the default `SELECT * FROM foo_user AS fu` * When cannot open or parse alias_map_file raise error Raise a (hopefully) helpful exception when the alias_map_file cannot be parsed or does not exist * Add tests for load_alias_map_file * Add tests for generate_alias * Update AUTHORS file * Remove comment. Discussed this on the PR with a project maintainer --------- Co-authored-by: Andy Schoenberger <akschoenberger@gmail.com> Co-authored-by: Rob B <rob@example.com> Co-authored-by: Irina Truong <i.chernyavska@gmail.com>
2023-10-06 23:13:28 +00:00
* Allow specifying an `alias_map_file` in the config that will use
predetermined table aliases instead of generating aliases programmatically on
the fly
fixed #1403, improved comment handling (#1404) * fixed #1403, improved comment handling * black + hooks + changelog --------- Co-authored-by: Irina Truong <i.chernyavska@gmail.com>
2023-10-13 05:28:11 +00:00
* Fixed SQL error when there is a comment on the first line: ([issue 1403](https://github.com/dbcli/pgcli/issues/1403))
confirm_destructive_query: Use confirm rather than prompt (#1410) * confirm_destructive_query: Use confirm rather than prompt * Fix tests
2023-10-18 16:25:29 +00:00
* Fix wrong usage of prompt instead of confirm when confirm execution of destructive query
Changed destructive_warning to take a list of destructive commands (#1328) * Changed destructive_warning to take a list of destructive commands and added the dsn_alias as part of the destructive command warning * Updated parse_destructive_warning to handle None * Reverted auto formatted change to AUTHORS * Reverted auto formatted change to AUTHORS
2022-10-13 21:42:22 +00:00
Drop python 3.7, add 3.12 (#1426) * Fix deprecation. * Drop python 3.7 and add 3.12. * Bump pendulum. * Changelog. * Update gh actions. * See if things pass without this scenario. * Skip failing scenarios in 3.12.
2023-10-11 04:34:59 +00:00
Internal:
---------
* Drop support for Python 3.7 and add 3.12.
Changelog update to release 3.5.0. (#1369)
2022-09-15 22:23:53 +00:00
3.5.0 (2022/09/15):
===================
Port to psycopg3 (#1324) * WIP. * Add some comments about porting from psycopg 2 to 3 (#1318) * WIP * Disable _set_wait_callback() * TransactionStatus. * First working query. * More pg3 changes. * test_pgexecute still fails. * Fix bytea support. * Fix json and enum unicode. * Get unit tests to pass. * Behave tests still break, WIP. * Prompt seems to be displayed fine, why don't the tests see the whitespace? * Python version. * Fix test. * Black. * Added black to dev reqs. * nbu link for donations. * Use psycopg.sql to format statement. * Special case for show help in pgbouncer. * Fix test. * Added integration test. * Install pgbouncer in ci. * Fix integration test. * Remove tmate session. * Revert commenting out python versions. * Pin pgspecial to >=2. * Changelog. Co-authored-by: Daniele Varrazzo <daniele.varrazzo@gmail.com> Co-authored-by: Amjith Ramanujam <amjith.r@gmail.com>
2022-06-06 18:20:48 +00:00
Feature: Add new formatter to export data to sql like mycli (#1366) * Sub: Add new formatter to export data to sql like mycli Body: New formatter is added, we can export query result to sql insertion like mycli ==== End ==== * Sub: Install black and reformat code Body: ==== End ==== * Sub: Add unit tests for new formatter Body: ==== End ==== * Sub: Add new formatter to pgclirc
2022-09-15 00:41:40 +00:00
Features:
---------
* New formatter is added to export query result to sql format (such as sql-insert, sql-update) like mycli.
More generic try/catch when dealing with keyring.
2022-06-10 17:14:57 +00:00
Bug fixes:
----------
* Fix exception when retrieving password from keyring ([issue 1338](https://github.com/dbcli/pgcli/issues/1338)).
Updated changelog.rst.
2022-09-01 02:46:26 +00:00
* Fix using comments with special commands ([issue 1362](https://github.com/dbcli/pgcli/issues/1362)).
Small developer improvements for Windows-based devs.
2022-09-01 15:32:36 +00:00
* Small improvements to the Windows developer experience
Changelog.
2022-09-14 22:01:09 +00:00
* Fix submitting queries in safe multiline mode ([1360](https://github.com/dbcli/pgcli/issues/1360)).
More generic try/catch when dealing with keyring.
2022-06-10 17:14:57 +00:00
Port to psycopg3 (#1324) * WIP. * Add some comments about porting from psycopg 2 to 3 (#1318) * WIP * Disable _set_wait_callback() * TransactionStatus. * First working query. * More pg3 changes. * test_pgexecute still fails. * Fix bytea support. * Fix json and enum unicode. * Get unit tests to pass. * Behave tests still break, WIP. * Prompt seems to be displayed fine, why don't the tests see the whitespace? * Python version. * Fix test. * Black. * Added black to dev reqs. * nbu link for donations. * Use psycopg.sql to format statement. * Special case for show help in pgbouncer. * Fix test. * Added integration test. * Install pgbouncer in ci. * Fix integration test. * Remove tmate session. * Revert commenting out python versions. * Pin pgspecial to >=2. * Changelog. Co-authored-by: Daniele Varrazzo <daniele.varrazzo@gmail.com> Co-authored-by: Amjith Ramanujam <amjith.r@gmail.com>
2022-06-06 18:20:48 +00:00
Internal:
---------
Changelog update to release 3.5.0. (#1369)
2022-09-15 22:23:53 +00:00
* Port to psycopg3 (https://github.com/psycopg/psycopg).
Fix typos (#1345) Co-authored-by: Irina Truong <i.chernyavska@gmail.com>
2022-06-08 18:38:29 +00:00
* Fix typos
Port to psycopg3 (#1324) * WIP. * Add some comments about porting from psycopg 2 to 3 (#1318) * WIP * Disable _set_wait_callback() * TransactionStatus. * First working query. * More pg3 changes. * test_pgexecute still fails. * Fix bytea support. * Fix json and enum unicode. * Get unit tests to pass. * Behave tests still break, WIP. * Prompt seems to be displayed fine, why don't the tests see the whitespace? * Python version. * Fix test. * Black. * Added black to dev reqs. * nbu link for donations. * Use psycopg.sql to format statement. * Special case for show help in pgbouncer. * Fix test. * Added integration test. * Install pgbouncer in ci. * Fix integration test. * Remove tmate session. * Revert commenting out python versions. * Pin pgspecial to >=2. * Changelog. Co-authored-by: Daniele Varrazzo <daniele.varrazzo@gmail.com> Co-authored-by: Amjith Ramanujam <amjith.r@gmail.com>
2022-06-06 18:20:48 +00:00
Changelog update to release 3.4.1. (#1325)
2022-03-19 20:59:32 +00:00
3.4.1 (2022/03/19)
==================
Prepare to release 3.4.0. (#1315) * Prepare to release 3.4.0. * Add the TBD section.
2022-02-21 20:27:39 +00:00
Changelog.
2022-03-02 04:19:51 +00:00
Bug fixes:
----------
Changelog update to release 3.4.1. (#1325)
2022-03-19 20:59:32 +00:00
* Fix the bug with Redshift not displaying word count in status ([related issue](https://github.com/dbcli/pgcli/issues/1320)).
Changelog.
2022-09-14 22:01:09 +00:00
* Show the error status for CSV output format.
Prepare to release 3.4.0. (#1315) * Prepare to release 3.4.0. * Add the TBD section.
2022-02-21 20:27:39 +00:00
3.4.0 (2022/02/21)
==================
Features:
---------
* Add optional support for automatically creating an SSH tunnel to a machine with access to the remote database ([related issue](https://github.com/dbcli/pgcli/issues/459)).
Update changelog.
2022-01-18 20:57:53 +00:00
3.3.1 (2022/01/18)
==================
Update changelog for 3.3.0
2022-01-11 16:36:26 +00:00
Bug fixes:
----------
Update changelog.
2022-01-13 18:13:43 +00:00
* Prompt for password when -W is provided even if there is a password in keychain. Fixes #1307.
Upgrade cli_helpers to workaround the Pygments regression. (#1310)
2022-01-18 20:33:26 +00:00
* Upgrade cli_helpers to 2.2.1
Update changelog for 3.3.0
2022-01-11 16:36:26 +00:00
3.3.0 (2022/01/11)
Fix the changelog format again.
2022-01-13 21:05:58 +00:00
==================
Update changelog for 3.2.0 release.
2021-08-23 16:01:33 +00:00
Features:
---------
Add setting in config to control truncating field values. (#1285) * Add setting in config to truncate field value. * Black. * Changelog. * Fix tests.
2021-09-03 23:58:03 +00:00
* Add `max_field_width` setting to config, to enable more control over field truncation ([related issue](https://github.com/dbcli/pgcli/issues/1250)).
Re-run last query with bare `\watch` (#1283) * Re-run last query with bare `\watch` * add test * clean up post test refactor * lint * rerun tests
2021-09-30 19:00:31 +00:00
* Re-run last query via bare `\watch`. (Thanks: `Saif Hakim`_)
Add setting in config to control truncating field values. (#1285) * Add setting in config to truncate field value. * Black. * Changelog. * Fix tests.
2021-09-03 23:58:03 +00:00
Update changelog for 3.2.0 release.
2021-08-23 16:01:33 +00:00
Bug fixes:
----------
Update changelog for 3.3.0
2022-01-11 16:36:26 +00:00
* Pin the version of pygments to prevent breaking change
Add setting in config to control truncating field values. (#1285) * Add setting in config to truncate field value. * Black. * Changelog. * Fix tests.
2021-09-03 23:58:03 +00:00
3.2.0
Update changelog for 3.2.0 release.
2021-08-23 16:01:33 +00:00
=====
Release date: 2021/08/23
Fix issue where `syntax_style` config value would not have any effect (#1241) These config properties got introduced in 41dd24e8 as a means to have more granular control over the syntax highlighting. The problem is that these cannot be in the default config file since `get_config()` always reads both the default config file and the user specified one, and there is no way to unset these variables in the user specified config file to restore their default behavior. Even if there would be a way, it wouldn't be intuitive at all to be required to unset some random settings under the `[colors]` section just to be able to use the well documented `syntax_style` setting. Note that one *can* still set these three lines in their user config file if they want to utilize them. Resolves #1212
2021-02-10 23:06:19 +00:00
Finer control over destructive warning. (#1242) * Finer control over destructive warning. * Review feedback. * Changelog. * Run integration tests with --warn=moderate. * Fix typo. * Black.
2021-02-13 05:09:38 +00:00
Features:
---------
* Consider `update` queries destructive and issue a warning. Change
`destructive_warning` setting to `all|moderate|off`, vs `true|false`. (#1239)
skip initial comment in pg_session file (#1245) * skip initial comment in pg_session file * add test
2021-02-22 22:55:55 +00:00
* Skip initial comment in .pg_session even if it doesn't start with '#'
Include functions from search_path in completion.
2021-05-07 04:09:45 +00:00
* Include functions from schemas in search_path. (`Amjith Ramanujam`_)
add explain visualizer (#1279) * add explain visualizer * format files * remove humanize dependency * disable by default * add explain visualizer * run black
2022-04-04 02:20:02 +00:00
* Easy way to show explain output under F5
Finer control over destructive warning. (#1242) * Finer control over destructive warning. * Review feedback. * Changelog. * Run integration tests with --warn=moderate. * Fix typo. * Black.
2021-02-13 05:09:38 +00:00
Fix issue where `syntax_style` config value would not have any effect (#1241) These config properties got introduced in 41dd24e8 as a means to have more granular control over the syntax highlighting. The problem is that these cannot be in the default config file since `get_config()` always reads both the default config file and the user specified one, and there is no way to unset these variables in the user specified config file to restore their default behavior. Even if there would be a way, it wouldn't be intuitive at all to be required to unset some random settings under the `[colors]` section just to be able to use the well documented `syntax_style` setting. Note that one *can* still set these three lines in their user config file if they want to utilize them. Resolves #1212
2021-02-10 23:06:19 +00:00
Bug fixes:
----------
* Fix issue where `syntax_style` config value would not have any effect. (#1212)
fixed unknown symbol REPLACE_SINGLE in prompt_toolkit < 3.0.6 (#1246) * fixed unknown symbol REPLACE_SINGLE in prompt_toolkit < 3.0.6 * changelog
2021-02-22 22:54:23 +00:00
* Fix crash because of not found `InputMode.REPLACE_SINGLE` with prompt-toolkit < 3.0.6
Changelog.
2021-02-26 21:18:31 +00:00
* Fix comments being lost in config when saving a named query. (#1240)
fix IPython magic (#1253)
2021-03-12 18:16:14 +00:00
* Fix IPython magic for ipython-sql >= 0.4.0
Use configured pager if table format is csv. (#1260) * Use configured pager if table format is csv. * Changelog. * Simplify.
2021-03-12 22:14:09 +00:00
* Fix pager not being used when output format is set to csv. (#1238)
Merge branch 'master' into func-pr
2021-05-06 15:12:31 +00:00
* Add function literals random, generate_series, generate_subscripts
Modify changelog
2021-05-02 22:27:55 +00:00
* Fix ANSI escape codes in first line make the cli choose expanded output incorrectly
Another attempt to fix pgbouncer error (1093.) (#1097) * Another attempt to fix pgbouncer error (1093.) * Fixes for various pgbouncer problems. * different approach with custom cursor. * Fix rebase. * Missed this. * Fix completion refresher test. * Black. * Unused import. * Changelog. * Fix race condition in test. * Switch from is_pgbouncer to more generic is_virtual_database, and duck-type it. Add very dumb unit test for virtual cursor. * Remove debugger code.
2021-05-21 22:32:34 +00:00
* Fix pgcli crashing with virtual `pgbouncer` database. (#1093)
Fix issue where `syntax_style` config value would not have any effect (#1241) These config properties got introduced in 41dd24e8 as a means to have more granular control over the syntax highlighting. The problem is that these cannot be in the default config file since `get_config()` always reads both the default config file and the user specified one, and there is no way to unset these variables in the user specified config file to restore their default behavior. Even if there would be a way, it wouldn't be intuitive at all to be required to unset some random settings under the `[colors]` section just to be able to use the well documented `syntax_style` setting. Note that one *can* still set these three lines in their user config file if they want to utilize them. Resolves #1212
2021-02-10 23:06:19 +00:00
Changelog update before release. (#1227)
2020-12-11 23:33:09 +00:00
3.1.0
=====
Update changelog for the compact output.
2020-04-19 02:08:07 +00:00
Features:
---------
* Make the output more compact by removing the empty newline. (Thanks: `laixintao`_)
Add support for using pspg as the pager. (#1173) * Stop printing "status" when table_format is "csv" * Use the "unix" dialect on *nix for CSV output. * Use a pager when `pspg` has been configured with CSV "table_format". Fix #1102
2020-04-23 17:17:40 +00:00
* Add support for using [pspg](https://github.com/okbob/pspg) as a pager (#1102)
Update python version from 2.7 to 3.8 in Dockerfile (#1181) * Update python version from 2.7 to 3.8 in Dockerfile * Update AUTHORS and changelog.rst
2020-05-11 16:51:23 +00:00
* Update python version in Dockerfile
Add custom color (#1196) * Updated author, changelog for supporting color of string, number, keyword * Added string, number, keyword custom color
2020-07-08 03:19:22 +00:00
* Support setting color for null, string, number, keyword value
Keep support for prompt_toolkit 2 (#1197) * Keep support for prompt_toolkit 2 * include prompt toolkit 3
2020-07-08 19:28:24 +00:00
* Support Prompt Toolkit 2
dependencies: add support for sqlparse 0.4.x (#1224)
2020-12-02 00:03:38 +00:00
* Support sqlparse 0.4.x
Update suggestion literals (#1195) * Updated all data types literals * Updated sql functions literals * Updated changelog and auther * Updated test code * Added datatype test case
2020-07-31 17:21:58 +00:00
* Update functions, datatypes literals for auto-suggestion field
Add schema suggestion for functions (#1206) * Add schema suggestion for functions - Update sqlcompletion.py - Update metadata files * Move autocomletion for function under condition - Make sure suggestion are only added under drop, alter etc.
2020-09-08 17:02:25 +00:00
* Add suggestion for schema in function auto-complete
Update changelog for the compact output.
2020-04-19 02:08:07 +00:00
Bug fixes:
----------
Add info to changelog.rst and AUTHORS
2020-05-26 13:12:42 +00:00
* Minor typo fixes in `pgclirc`. (Thanks: `anthonydb`_)
Fix for #1193 list index out of range on sql comment.
2020-06-26 20:39:31 +00:00
* Fix for list index out of range when executing commands from a file (#1193). (Thanks: `Irina Truong`_)
Move from humanize to pendulum library for displaying query durations (#1199)
2020-07-29 06:08:19 +00:00
* Move from `humanize` to `pendulum` for displaying query durations (#1015)
More explicit error message when DSN alias is not found (#1198) * add a specific error message when DSN with provided alias is not found * update changelog & authors file
2020-07-31 17:25:06 +00:00
* More explicit error message when connecting using DSN alias and it is not found.
Update changelog for the compact output.
2020-04-19 02:08:07 +00:00
New release 3.0.0. (#1165)
2020-04-10 22:14:56 +00:00
3.0.0
=====
add main file to allow python3 -m pgcli execution
2019-11-25 21:46:28 +00:00
Features:
---------
* Add `__main__.py` file to execute pgcli as a package directly (#1123).
* Add support for ANSI escape sequences for coloring the prompt (#1122).
Add Support for partitioned tables. (#1145) * partitioned tables: add support Starting from 9.6+ relkind has new members (more info here: https://www.postgresql.org/docs/12/catalog-pg-class.html) * Update AUTHORS * Update changelog.rst * foreign tables: add support Starting from 9.6+ relkind has new members (more info here: https://www.postgresql.org/docs/12/catalog-pg-class.html)
2020-02-13 22:24:37 +00:00
* Add support for partitioned tables (relkind "p").
Add pg_service.conf handling (#1155) * add parse_service_info * added tests * changelog + AUTHORS * py35
2020-04-17 21:52:19 +00:00
* Add support for `pg_service.conf` files
show_bottom_toolbar - Feature to Show/Hide Toolbar (#1170) * adds ternary to decide whether bottom_toolbar is shown based on config value * runs black format * adds name to authors * modifies changelog.rst * removes change in changelog.rst * formats config * removes unused variable, adds change to changelog * changes default back to true * removed reference to var
2020-04-18 05:58:13 +00:00
* Add config option show_bottom_toolbar.
add main file to allow python3 -m pgcli execution
2019-11-25 21:46:28 +00:00
Fix warning raised for using `is not` to compare string literal (#1139) Using `is not` for comparing string literals raises warning that != should be used. Fixes #1138
2020-01-15 04:56:07 +00:00
Bug fixes:
Update changelog for the compact output.
2020-04-19 02:08:07 +00:00
----------
Fix warning raised for using `is not` to compare string literal (#1139) Using `is not` for comparing string literals raises warning that != should be used. Fixes #1138
2020-01-15 04:56:07 +00:00
* Fix warning raised for using `is not` to compare string literal
Fix: Unable to drop previously connected-to database (#1152) * close connections + added to authors + changelog * check conn exists
2020-03-12 20:45:59 +00:00
* Close open connection in completion_refresher thread
Fix warning raised for using `is not` to compare string literal (#1139) Using `is not` for comparing string literals raises warning that != should be used. Fixes #1138
2020-01-15 04:56:07 +00:00
Add lines to changelog.rst.
2020-01-01 12:48:32 +00:00
Internal:
---------
add main file to allow python3 -m pgcli execution
2019-11-25 21:46:28 +00:00
python3.8: add travis test and setup.py class. (#1157)
2020-03-18 16:11:10 +00:00
* Drop Python2.7, 3.4, 3.5 support. (Thanks: `laixintao`_)
* Support Python3.8. (Thanks: `laixintao`_)
Add my name to changelog.
2020-01-02 23:50:34 +00:00
* Fix dead link in development guide. (Thanks: `BrownShibaDog`_)
upgrade prompt-toolit to 3.0 (#1149) * upgrade prompt-toolit to 3.0 fix: https://github.com/dbcli/pgcli/issues/1148 related: https://github.com/prompt-toolkit/python-prompt-toolkit/issues/886 in order to make the `behave` test pass, I have to: - extend timeout for database connection test. - extend timeout for basic command expect. - extend timeout for features/steps/crud_table.py:: see data selected. - disable cpr for features but "run the cli" * [ci] disable CPR for all behave tests. * bugfix: remove duplicated prompt expect. * [ci] delete CPR env setting. * Revert "[ci] delete CPR env setting." This reverts commit fe4d5b565e01be6237b6df646429d26eaa0c6d92. * revert the extending timeout back. * [ci] test when didn't disable CPR. * Revert "[ci] test when didn't disable CPR." This reverts commit d379b1e736dcc6623ba53fc3d4e6f095fd3e8344.
2020-04-06 03:56:31 +00:00
* Upgrade python-prompt-toolkit to v3.0. (Thanks: `laixintao`_)
Fix warning raised for using `is not` to compare string literal (#1139) Using `is not` for comparing string literals raises warning that != should be used. Fixes #1138
2020-01-15 04:56:07 +00:00
Drop Python 3.4 support (#1141) * remove python3.4 support. Python 3.4 has reached end-of-life. https://www.python.org/downloads/release/python-340/ * drop maximun version of pytest * update changelog * add laixintao to contributors, delete py34 from tox
2020-01-16 06:45:16 +00:00
J bennet/release 2.2.0 (#1126) * Changelog. * Bump pgspecial. * Restrict prompt_toolkit to <3.0.0.
2019-12-04 17:24:17 +00:00
2.2.0:
======
Allow escape to switch to vi navigation mode (#1039)
2019-04-13 20:22:03 +00:00
Update changelog.
2019-06-03 00:59:31 +00:00
Features:
---------
* Add `\\G` as a terminator to sql statements that will show the results in expanded mode. This feature is copied from mycli. (Thanks: `Amjith Ramanujam`_)
Issue 1018 display first 1k rows (#1092) * Added changes to remove the prompt on >1000 rows queries * Reformatted with black * Changed comment on row_limit parameter * Added contribution to changelog and name to AUTHORS * Refactored test to reflect new functionality * Removed argument * Removed debug echo statement * Reformatted with black * Added changes to remove the prompt on >1000 rows queries * Reformatted with black * Changed comment on row_limit parameter * Added contribution to changelog and name to AUTHORS * Refactored test to reflect new functionality * Removed argument * Removed debug echo statement * Reformatted with black * Added missing issue numbers in changelog * Reformatted code using black
2019-08-23 20:44:36 +00:00
* Removed limit prompt and added automatic row limit on queries with no LIMIT clause (#1079) (Thanks: `Sebastian Janko`_)
Take account of table aliases when completing function args (#1048)
2019-10-12 15:19:04 +00:00
* Function argument completions now take account of table aliases (#1048). (Thanks: `Owen Stephens`_)
Changelog update before release. (#1062)
2019-05-31 00:10:15 +00:00
Partial fix for #1058. (#1068)
2019-06-09 15:05:28 +00:00
Bug fixes:
----------
Changelog.
2019-10-28 16:19:59 +00:00
* Error connecting to PostgreSQL 12beta1 (#1058). (Thanks: `Irina Truong`_ and `Amjith Ramanujam`_)
Issue 1018 display first 1k rows (#1092) * Added changes to remove the prompt on >1000 rows queries * Reformatted with black * Changed comment on row_limit parameter * Added contribution to changelog and name to AUTHORS * Refactored test to reflect new functionality * Removed argument * Removed debug echo statement * Reformatted with black * Added changes to remove the prompt on >1000 rows queries * Reformatted with black * Changed comment on row_limit parameter * Added contribution to changelog and name to AUTHORS * Refactored test to reflect new functionality * Removed argument * Removed debug echo statement * Reformatted with black * Added missing issue numbers in changelog * Reformatted code using black
2019-08-23 20:44:36 +00:00
* Empty query caused error message (#1019) (Thanks: `Sebastian Janko`_)
Add key bindings to consistently move up and down in history (#1084)
2019-07-29 20:00:33 +00:00
* History navigation bindings in multiline queries (#1004) (Thanks: `Pedro Ferrari`_)
Changelog.
2019-09-02 19:35:49 +00:00
* Can't connect to pgbouncer database (#1093). (Thanks: `Irina Truong`_)
Handle a multi-line query on Enter key-press (fixes #1031) Use a (conditional) Enter key-binding to force-handle a multi-line buffer, rather than doing so by (conditionally) disabling the multiline mode of prompt_toolkit. This has the benefit of being more efficient (the multiline Condition filter is called very often, which (due to the repeated query parsing) causes editing to become slow with a large buffer that ends in a semicolon), clearer in intent (we want to force-handle the query, rather than (temporarily) disable multiline mode which indirectly forces the buffer to be handled) and avoids a bug in multi-line history search (issue #1031)
2019-10-13 00:07:57 +00:00
* Fix broken multi-line history search (#1031). (Thanks: `Owen Stephens`_)
fixup! fixup! Handle a multi-line query on Enter key-press (fixes #1031)
2019-10-16 21:26:25 +00:00
* Fix slow typing/movement when multi-line query ends in a semicolon (#994). (Thanks: `Owen Stephens`_)
Changelog.
2019-10-26 20:22:54 +00:00
* Fix for PQconninfo not available in libpq < 9.3 (#1110). (Thanks: `Irina Truong`_)
Partial fix for #1058. (#1068)
2019-06-09 15:05:28 +00:00
add optional but default squash merge request to PULL_REQUEST_TEMPLATE (#1095)
2019-09-28 02:34:34 +00:00
Internal:
---------
* Add optional but default squash merge request to PULL_REQUEST_TEMPLATE
Changelog update before release. (#1062)
2019-05-31 00:10:15 +00:00
2.1.1
=====
Allow escape to switch to vi navigation mode (#1039)
2019-04-13 20:22:03 +00:00
Bug fixes:
----------
* Escape switches to VI navigation mode when not canceling completion popup. (Thanks: `Nathan Verzemnieks`_)
Allow application_name to be overridden (#1044) * Allow application_name to be overridden * Fixed broken link. * Default password value is empty str? * Make pep8 happier.
2019-04-28 03:25:19 +00:00
* Allow application_name to be overridden. (Thanks: `raylu`_)
Possibly fix #1040. (#1042) Fix #1040
2019-04-28 06:00:40 +00:00
* Fix for "no attribute KeyringLocked" (#1040). (Thanks: `Irina Truong`_)
More intelligent dsn format (#1045) * Psycopg2 already has a method to format a dsn. We should use it. Fix for #1043. * Changelog. * pep8.
2019-04-28 22:06:01 +00:00
* Pgcli no longer works with password containing spaces (#1043). (Thanks: `Irina Truong`_)
lazy load keyring. (#1046) fix issue: https://github.com/dbcli/pgcli/issues/1041
2019-05-01 15:53:55 +00:00
* Load keyring only when keyring is enabled in the config file (#1041). (Thanks: `Zhaolong Zhu`_)
Merge branch 'master' into pr1047
2019-05-06 18:11:47 +00:00
* No longer depend on sqlparse as being less than 0.3.0 with the release of sqlparse 0.3.0. (Thanks: `VVelox`_)
Update changelog.
2019-05-06 14:29:48 +00:00
* Fix the broken support for pgservice . (Thanks: `Xavier Francisco`_)
Dsn parameters not always present. (#1054) * Dsn parameters not always present.
2019-05-11 05:57:45 +00:00
* Connecting using socket is broken in current master. (#1053). (Thanks: `Irina Truong`_)
Allow psycopg2 up to 2.8.2 (#1060) * Allow psycopg2 up to 2.8.2 This fixes the issue with pgcli not working on Arch Linux, since the package `python2-psycopg2` is already on 2.8.2. * Added name to 'AUTHORS' and contribution to 'changelog.rst' referring to #2de6266 * Allow for newer versions of psycopg2 to be used
2019-05-30 04:14:32 +00:00
* Allow usage of newer versions of psycopg2 (Thanks: `Telmo "Trooper"`_)
README.rst: tidy up redundant instructions (#1061) * README.rst: tidy up redundant instructions Remove the README section which detailed how to force `psycopg2` 2.7 dependency installation from source rather than binary. `psycopg2` 2.7 would automatically favour installation from binary. A bug affecting some users made it desirable to have the option to install from source instead. The README detailed how to do this using pip's `--no-binary` option (nice!). `psycopg2` 2.8 has now split the binary and source dependencies into different packages with different names (source: [psycopg2 docs](http://initd.org/psycopg/docs/install.html#change-in-binary-packages-between-psycopg-2-7-and-2-8)) which makes the `--no-binary` instructions redundant. To specify source/binary you now need to explicitly specify the desired package. As of #1060, installing `pgcli` from pip will result in the installation of `psycopg2` 2.8 from source. * README: additional instructions for psycopg2 2.7 users Anyone limited to psycopg2 2.7 may still encounter some known issues when installing from binary. Add a link to the README to acknowledge this, and help those users install it from source. * Update changelog.rst * Update AUTHORS * Update changelog
2019-05-30 17:03:47 +00:00
* Update README in alignment with the usage of newer versions of psycopg2 (Thanks: `Alexander Zawadzki`_)
Allow escape to switch to vi navigation mode (#1039)
2019-04-13 20:22:03 +00:00
changelog.
2019-05-04 11:33:28 +00:00
Internal:
---------
* Add python 3.7 to travis build matrix. (Thanks: `Irina Truong`_)
black all the things. (#1049) * added black to develop guide * no need for pep8radius. * changelog. * Add pre-commit checkbox. * Add pre-commit to dev reqs. * Add pyproject.toml for black. * Pre-commit config. * Add black to travis and dev reqs. * Install and run black in travis. * Remove black from dev reqs. * Lower black target version. * Re-format with black.
2019-05-25 20:08:56 +00:00
* Apply `black` to code. (Thanks: `Irina Truong`_)
Allow escape to switch to vi navigation mode (#1039)
2019-04-13 20:22:03 +00:00
Changelog update before release. Bump cli_helpers. (#1030)
2019-04-06 00:24:10 +00:00
2.1.0
=====
Changelog update to release 1.11.0.
2018-09-24 23:23:26 +00:00
keybinding for dismissing autocompletelist (#1007) * +added esc key to dismiss the autocomple list * +added esc key to dismiss the autocomple list
2019-02-13 00:18:32 +00:00
Features:
---------
Changelog.
2019-03-05 00:16:47 +00:00
* Keybindings for closing the autocomplete list. (Thanks: `easteregg`_)
* Reconnect automatically when server closes connection. (Thanks: `Scott Brenstuhl`_)
keybinding for dismissing autocompletelist (#1007) * +added esc key to dismiss the autocomple list * +added esc key to dismiss the autocomple list
2019-02-13 00:18:32 +00:00
Determine hstore OID from the system view (#992) Avoid error message on the server side if hstore extension is not installed in the current database. Issue: https://github.com/dbcli/pgcli/issues/991
2019-01-22 00:00:25 +00:00
Bug fixes:
----------
* Avoid error message on the server side if hstore extension is not installed in the current database (#991). (Thanks: `Marcin Cieślak`_)
Use pexpect.TIMEOUT instead of pexpect.exceptions.TIMEOUT All pexpect submodules have been moved into the pexpect package as of version 3.0.
2019-01-21 09:22:00 +00:00
* All pexpect submodules have been moved into the pexpect package as of version 3.0. Use pexpect.TIMEOUT (Thanks: `Marcin Cieślak`_)
Changelog update.
2019-03-16 03:32:23 +00:00
* Resizing pgcli terminal kills the connection to postgres in python 2.7 (Thanks: `Amjith Ramanujam`_)
Changelog.
2019-03-05 00:16:47 +00:00
* Fix crash retrieving server version with ``--single-connection``. (Thanks: `Irina Truong`_)
Changelog.
2019-03-05 00:55:48 +00:00
* Cannot quit application without reconnecting to database (#1014). (Thanks: `Irina Truong`_)
Changelog.
2019-03-22 16:55:16 +00:00
* Password authentication failed for user "postgres" when using non-default password (#1020). (Thanks: `Irina Truong`_)
Changelog update for bugfix release. (#984)
2019-01-03 00:31:05 +00:00
fixup! Clean up and add behave logging (#956)
2019-01-22 18:18:39 +00:00
Internal:
---------
* (Fixup) Clean up and add behave logging. (Thanks: `Marcin Cieślak`_, `Dick Marinus`_)
* Override VISUAL environment variable for behave tests. (Thanks: `Marcin Cieślak`_)
Remove build dir before running sdist (#1002)
2019-01-25 20:37:17 +00:00
* Remove build dir before running sdist, remove stray files from wheel distribution. (Thanks: `Dick Marinus`_)
fix unhashable formatted text
2019-02-08 20:24:36 +00:00
* Fix unit tests, unhashable formatted text since new python prompttoolkit version. (Thanks: `Dick Marinus`_)
fixup! Clean up and add behave logging (#956)
2019-01-22 18:18:39 +00:00
Changelog update for bugfix release. (#984)
2019-01-03 00:31:05 +00:00
2.0.2:
======
allow passing -u flag (lowercase) to specify username (#975) * added -u flag
2018-11-30 23:21:12 +00:00
Features:
---------
* Allows passing the ``-u`` flag to specify a username. (Thanks: `Ignacio Campabadal`_)
Remove some functions completions (#982) Remove extension and private functions from completer.
2019-01-03 00:15:59 +00:00
* Fix for lag in v2 (#979). (Thanks: `Irina Truong`_)
Support multihost connection string (#978) * Switch to psycopg2 parse_dsn instead of urlparse * Added wronglink to contributors and updated changelog * Fix test codestyle * Support for PGPORT customization in tests * Support for PGPORT customization in tests * Refactored PGExecute init and moved short_host generation to object property * Fix test util codestyle * Fix local tests run * Store PGExecute initial params in _conn_params and added PGExecute.copy method * Fix codestyle * Added docstring to PGExecute.copy() method
2019-01-03 22:27:47 +00:00
* Support for multihost connection string that is convenient if you have postgres cluster. (Thanks: `Mikhail Elovskikh`_)
allow passing -u flag (lowercase) to specify username (#975) * added -u flag
2018-11-30 23:21:12 +00:00
Fix special commands (#973) * Add tests for special commands completion.
2018-11-27 15:49:54 +00:00
Internal:
---------
* Added tests for special command completion. (Thanks: `Amjith Ramanujam`_)
going to release. (#972)
2018-11-19 04:16:29 +00:00
2.0.1:
======
Clean up and add behave logging (#956)
2018-10-14 20:53:19 +00:00
Bug fixes:
----------
Missed changelog update. (#960)
2018-10-30 14:41:38 +00:00
Updated changelog
2018-07-27 16:15:32 +00:00
* Tab press on an empty line increases the indentation instead of triggering
the auto-complete pop-up. (Thanks: `Artur Balabanov`_)
Bugfix for #938: load named queries from provided config file
2018-10-31 17:42:27 +00:00
* Fix for loading/saving named queries from provided config file (#938). (Thanks: `Daniel Egger`_)
* Set default port in `connect_uri` when none is given. (Thanks: `Daniel Egger`_)
Fix for pgcli --list. (#952) Fix for pgcli --list
2018-10-03 00:10:43 +00:00
* Fix for error listing databases (#951). (Thanks: `Irina Truong`_)
Enable suspend using C-Z. (#970) * Enable suspend using C-Z. * Update changelog.
2018-11-18 03:41:34 +00:00
* Enable Ctrl-Z to suspend the app (Thanks: `Amjith Ramanujam`_).
Fix the StopIteration issue in Python 3.7 (#971) * Fix the StopIteration issue in Python 3.7
2018-11-19 04:11:15 +00:00
* Fix StopIteration exception raised at runtime for Python 3.7 (Thanks: `Amjith Ramanujam`_).
Changelog update to release 1.11.0.
2018-09-24 23:23:26 +00:00
Clean up and add behave logging (#956)
2018-10-14 20:53:19 +00:00
Internal:
---------
* Clean up and add behave logging. (Thanks: `Dick Marinus`_)
Require prompt_toolkit>=2.0.6.
2018-11-11 13:16:32 +00:00
* Require prompt_toolkit>=2.0.6. (Thanks: `Dick Marinus`_)
allow passing -u flag (lowercase) to specify username (#975) * added -u flag
2018-11-30 23:21:12 +00:00
* Improve development guide. (Thanks: `Ignacio Campabadal`_)
Clean up and add behave logging (#956)
2018-10-14 20:53:19 +00:00
Changelog update to release 2.0.0.
2018-09-28 21:25:54 +00:00
2.0.0:
======
* Update to ``prompt-toolkit`` 2.0. (Thanks: `Jonathan Slenders`_, `Dick Marinus`_, `Irina Truong`_)
Changelog update to release 1.11.0.
2018-09-24 23:23:26 +00:00
1.11.0
======
Respect \pset pager on expected behavior "\pset pager" has three possible values: "always", "on", and "off". pgcli previously treated all non-"off" values as "always". This change implements the expected behavior, which is to use the pager when the output is larger than the terminal height (See \pset pager in https://www.postgresql.org/docs/9.2/static/app-psql.html). Pgcli adds to this by also using the pager when the output is wider than the terminal width. Fixes #813
2018-05-15 17:42:21 +00:00
Features:
---------
* Respect `\pset pager on` and use pager when output is longer than terminal height (Thanks: `Max Rothman`_)
Let's release more bugfixes.
2018-07-27 19:03:12 +00:00
1.10.3
======
Changelog update to release 1.10.0.
2018-07-13 20:45:48 +00:00
Changelog.
2018-07-24 22:17:08 +00:00
Bug fixes:
----------
Adapt the query used to get functions metadata to PG11 This fixes #919.
2018-07-24 15:47:35 +00:00
* Adapt the query used to get functions metadata to PG11 (#919). (Thanks: `Lele Gaifax`_).
Let's release more bugfixes.
2018-07-27 19:03:12 +00:00
* Fix for error retrieving version in Redshift (#922). (Thanks: `Irina Truong`_)
Changelog.
2018-07-26 05:11:41 +00:00
* Fix for keyring not disabled properly (#920). (Thanks: `Irina Truong`_)
Changelog update to release 1.10.2.
2018-07-24 00:08:09 +00:00
1.10.2
======
make keyring optional
2018-07-22 05:34:56 +00:00
Features:
---------
Changelog update to release 1.10.2.
2018-07-24 00:08:09 +00:00
make keyring optional
2018-07-22 05:34:56 +00:00
* Make `keyring` optional (Thanks: `Dick Marinus`_)
Bugfix release.
2018-07-20 05:11:02 +00:00
1.10.1
======
Changelog.
2018-07-20 01:24:35 +00:00
Bug fixes:
Changelog.
2018-07-24 22:17:08 +00:00
----------
Changelog.
2018-07-20 01:24:35 +00:00
* Fix for missing keyring. (Thanks: `Kenny Do`_)
* Fix for "-l" Flag Throws Error (#909). (Thanks: `Irina Truong`_)
Changelog update to release 1.10.0.
2018-07-13 20:45:48 +00:00
1.10.0
======
Changelog update, and bump pgspecial for the release.
2018-03-02 18:24:41 +00:00
Add entries to changelog and AUTHORS
2018-05-14 16:23:28 +00:00
Features:
---------
* Add quit commands to the completion menu. (Thanks: `Jason Ribeiro`_)
Add completion for table formats
2018-05-14 20:52:26 +00:00
* Add table formats to ``\T`` completion. (Thanks: `Jason Ribeiro`_)
Changelog update to release 1.10.0.
2018-07-13 20:45:48 +00:00
* Support `\\ev``, ``\ef`` (#754). (Thanks: `Catherine Devlin`_)
* Add ``application_name`` to help identify pgcli connection to database (issue #868) (Thanks: `François Pietka`_)
* Add `--user` option, duplicate of `--username`, the same cli option like `psql` (Thanks: `Alexandr Korsak`_)
Add entries to changelog and AUTHORS
2018-05-14 16:23:28 +00:00
Mark tests requiring a running database server as dbtest
2018-04-05 19:15:01 +00:00
Internal changes:
-----------------
* Mark tests requiring a running database server as dbtest (Thanks: `Dick Marinus`_)
Correct changelog
2018-05-15 05:34:48 +00:00
* Add an is_special command flag to MetaQuery (Thanks: `Rishi Ramraj`_)
Updated AUTHORS and the changelog.rst
2018-05-17 10:14:12 +00:00
* Ported Destructive Warning from mycli.
Refactor destructive warning in behave tests
2018-05-26 13:49:41 +00:00
* Refactor Destructive Warning behave tests (Thanks: `Dick Marinus`_)
Changelog update to release 1.9.1.
2018-03-31 20:25:42 +00:00
Disable pager when using \watch
2018-05-14 18:20:37 +00:00
Bug Fixes:
----------
* Disable pager when using \watch (#837). (Thanks: `Jason Ribeiro`_)
Fix lint, update AUTHORS, and changelog
2018-07-04 08:28:24 +00:00
* Don't offer to reconnect when we can't change a param in realtime (#807). (Thanks: `Amjith Ramanujam`_ and `Saif Hakim`_)
make keyring optional
2018-05-26 09:26:06 +00:00
* Make keyring optional. (Thanks: `Dick Marinus`_)
Changelog.
2018-06-01 15:27:09 +00:00
* Fix ipython magic connection (#891). (Thanks: `Irina Truong`_)
Changelog link.
2018-06-06 16:48:48 +00:00
* Fix not enough values to unpack. (Thanks: `Matthieu Guilbert`_)
Update changelog.
2018-06-10 08:37:00 +00:00
* Fix unbound local error when destructive_warning is false. (Thanks: `Matthieu Guilbert`_)
Updated the changelog with the bug fix description
2018-07-06 16:42:53 +00:00
* Render tab characters as 4 spaces instead of `^I`. (Thanks: `Artur Balabanov`_)
Disable pager when using \watch
2018-05-14 18:20:37 +00:00
Changelog update to release 1.9.1.
2018-03-31 20:25:42 +00:00
1.9.1:
======
add feature in changelog
2018-03-29 16:58:43 +00:00
Features:
---------
* Change ``\h`` format string in prompt to only return the first part of the hostname,
up to the first '.' character. Add ``\H`` that returns the entire hostname (#858).
(Thanks: `Andrew Kuchling`_)
* Add Color of table by parameter. The color of table is function of syntax style
Internal changes:
-----------------
* Add tests, AUTHORS and changelog.rst to release. (Thanks: `Dick Marinus`_)
Bug Fixes:
----------
* Fix broken pgcli --list command line option (#850). (Thanks: `Dmitry B`_)
Changelog update, and bump pgspecial for the release.
2018-03-02 18:24:41 +00:00
1.9.0
=====
change msg if ValueError
2018-01-03 21:05:45 +00:00
Features:
---------
Update changelog.rst
2018-01-17 11:49:21 +00:00
* manage pager by \pset pager and add enable_pager to the config file (Thanks: `Frederic Aoustin`_).
change msg if ValueError
2018-01-03 21:05:45 +00:00
* Add support for `\T` command to change format output. (Thanks: `Frederic Aoustin`_).
add alias-dsn in changelog
2018-02-10 16:08:03 +00:00
* Add option list-dsn (Thanks: `Frederic Aoustin`_).
change msg if ValueError
2018-01-03 21:05:45 +00:00
Removed support for Python 3.3.
2018-01-16 03:10:06 +00:00
Internal changes:
-----------------
* Removed support for Python 3.3. (Thanks: `Irina Truong`_)
Changelog update to release 1.8.2.
2017-12-05 03:12:11 +00:00
1.8.2
=====
More changes added to 1.8.2 release.
2017-12-21 04:44:36 +00:00
Features:
---------
* Use other prompt (prompt_dsn) when connecting using --dsn parameter. (Thanks: `Marcin Sztolcman`_)
* Include username into password prompt. (Thanks: `Bojan Delić`_)
use temp dir as config location in tests
2017-09-20 20:49:12 +00:00
Internal changes:
-----------------
Changelog update to release 1.8.2.
2017-12-05 03:12:11 +00:00
* Use temporary dir as config location in tests. (Thanks: `Dmitry B`_)
Changelog.
2017-10-06 18:25:28 +00:00
* Fix errors in the ``tee`` test (#795 and #797). (Thanks: `Irina Truong`_)
Increase timeout for quitting pgcli
2017-10-24 07:03:21 +00:00
* Increase timeout for quitting pgcli. (Thanks: `Dick Marinus`_)
Changelog update to release 1.8.1.
2017-09-19 18:29:36 +00:00
Do NOT escape database names.
2017-10-11 19:56:46 +00:00
Bug Fixes:
----------
* Do NOT quote the database names in the completion menu (Thanks: `Amjith Ramanujam`_)
Changelog.
2017-10-21 18:14:58 +00:00
* Fix error in ``unix_socket_directories`` (#805). (Thanks: `Irina Truong`_)
-- added fix contrbution to changelog -- added name to AUTHORS
2017-12-16 22:57:48 +00:00
* Fix the --list command line option tries to connect to 'personal' DB (#816). (Thanks: `Isank`_)
Do NOT escape database names.
2017-10-11 19:56:46 +00:00
Changelog update to release 1.8.1.
2017-09-19 18:29:36 +00:00
1.8.1
=====
Remove shebang and git execute permission from pgcli/main.py.
2017-09-15 18:46:51 +00:00
Internal changes:
-----------------
* Remove shebang and git execute permission from pgcli/main.py. (Thanks: `Dick Marinus`_)
Changelog update to release 1.8.1.
2017-09-19 18:29:36 +00:00
* Require cli_helpers 0.2.3 (fix #791). (Thanks: `Dick Marinus`_)
Changelog update to release 1.8.0.
2017-09-13 03:10:27 +00:00
1.8.0
=====
Add fish-style autosuggestion.
2017-07-16 22:06:25 +00:00
Features:
---------
* Add fish-style auto-suggestion from history. (Thanks: `Amjith Ramanujam`_)
Improve formatting of array output Before this change, e.g. `SELECT '{1}'::numeric` would output `[Decimal(1)]`. Now it instead outputs `{1}`.
2017-08-06 17:13:46 +00:00
* Improved formatting of arrays in output (Thanks: `Joakim Koljonen`_)
Don't quote identifiers that coïncide with non-reserved keywords Keep track of which keywords are reserved, and quote identifiers that coïncide with those. https://www.postgresql.org/docs/10/static/sql-keywords-appendix.html
2017-08-06 06:59:03 +00:00
* Don't quote identifiers that are non-reserved keywords. (Thanks: `Joakim Koljonen`_)
Changelog update.
2017-07-24 17:34:54 +00:00
* Remove the ``...`` in the continuation prompt and use empty space instead. (Thanks: `Amjith Ramanujam`_)
Update changelog
2017-08-06 22:24:09 +00:00
* Add \conninfo and handle more parameters with \c (issue #716) (Thanks: `François Pietka`_)
Add fish-style autosuggestion.
2017-07-16 22:06:25 +00:00
Preliminary work for a future change in outputting results that uses less memory
2017-08-18 18:40:16 +00:00
Internal changes:
-----------------
* Preliminary work for a future change in outputting results that uses less memory. (Thanks: `Dick Marinus`_)
Remove OrderedDict workaround for python < 2.7
2017-08-20 13:33:46 +00:00
* Remove import workaround for OrderedDict, required for python < 2.7. (Thanks: `Andrew Speed`_)
use cursor from psycopg in pgcli
2017-08-19 06:48:41 +00:00
* Use less memory when formatting results for display (Thanks: `Dick Marinus`_).
Port auto_vertical feature test from mycli to pgcli
2017-09-05 18:39:13 +00:00
* Port auto_vertical feature test from mycli to pgcli. (Thanks: `Dick Marinus`_)
Drop wcwidth dependency
2017-09-10 13:15:23 +00:00
* Drop wcwidth dependency (Thanks: `Dick Marinus`_)
Preliminary work for a future change in outputting results that uses less memory
2017-08-18 18:40:16 +00:00
Add fish-style autosuggestion.
2017-07-16 22:06:25 +00:00
Bug Fixes:
----------
Use psycopg2 to get database details
2017-07-29 13:59:30 +00:00
* Fix the way we get host when using DSN (issue #765) (Thanks: `François Pietka`_)
Update changelog
2017-08-06 22:20:46 +00:00
* Add missing keyword COLUMN after DROP (issue #769) (Thanks: `François Pietka`_)
Update changelog
2017-08-06 06:29:24 +00:00
* Don't include arguments in function suggestions for backslash commands (Thanks: `Joakim Koljonen`_)
Fix TODO, optionally use POSTGRES_USER, POSTGRES_HOST POSTGRES_PASSWORD from environment
2017-08-18 04:52:29 +00:00
* Optionally use POSTGRES_USER, POSTGRES_HOST POSTGRES_PASSWORD from environment (Thanks: `Dick Marinus`_)
Changelog update to release 1.7.0.
2017-07-16 02:20:46 +00:00
1.7.0
=====
Refresh completions after COMMIT or ROLLBACK.
2017-05-29 00:56:48 +00:00
* Refresh completions after `COMMIT` or `ROLLBACK`. (Thanks: `Irina Truong`_)
Updated changelog.
2017-05-28 22:04:57 +00:00
* Fixed DSN aliases not being read from custom pgclirc (issue #717). (Thanks: `Irina Truong`_).
Add homebrew update to changelog.
2017-06-02 19:13:53 +00:00
* Use dbcli's Homebrew tap for installing pgcli on macOS (issue #718) (Thanks: `Thomas Roten`_).
Changelog.
2017-06-09 18:17:04 +00:00
* Only set `LESS` environment variable if it's unset. (Thanks: `Irina Truong`_)
Changelog.
2017-06-09 21:44:56 +00:00
* Quote schema in `SET SCHEMA` statement (issue #469) (Thanks: `Irina Truong`_)
Include arguments in function completions E.g. instead of suggesting `my_func()`, suggest `my_func(arg1 :=, arg2 :=)` or `my_func(arg1 text, arg2 bigint)`, depending on the context.
2017-03-20 20:28:40 +00:00
* Include arguments in function suggestions (Thanks: `Joakim Koljonen`_)
Add cli helpers to changelog.
2017-06-19 14:27:10 +00:00
* Use CLI Helpers for pretty printing query results (Thanks: `Thomas Roten`_).
Add change to changelog
2017-07-06 08:42:39 +00:00
* Skip serial columns when expanding * for `INSERT INTO foo(*` (Thanks: `Joakim Koljonen`_).
Update changelog
2017-07-14 23:07:40 +00:00
* Command line option to list databases (issue #206) (Thanks: `François Pietka`_)
Preparing to release 1.6.0.
2017-05-18 03:09:21 +00:00
1.6.0
=====
Update changelog.rst
2017-03-14 21:37:39 +00:00
Features:
---------
Updating AUTHORS and changelog
2017-05-10 17:49:08 +00:00
* Add time option for prompt (Thanks: `Gustavo Castro`_)
Update changelog.rst
2017-03-14 21:37:39 +00:00
* Suggest objects from all schemas (not just those in search_path) (Thanks: `Joakim Koljonen`_)
Casing for column headers (based on casing file) ``` koljonen@localhost:koljonen> SELECT transferid, parenttransferid, amount from transfers ╒══════════════╤════════════════════╤══════════╕ │ TransferID │ ParentTransferID │ Amount │ ╞══════════════╪════════════════════╪══════════╡ ... ... ... ```
2017-01-16 04:58:52 +00:00
* Casing for column headers (Thanks: `Joakim Koljonen`_)
Allow configurable multiline continuation char
2017-03-30 10:12:25 +00:00
* Allow configurable character to be used for multi-line query continuations. (Thanks: `Owen Stephens`_)
Suggest columns for `ORDER BY` and `DISTINCT` (fixes #685) Having typed an alias name in an `ORDER BY` or (`SELECT`) `DISTINCT` clause, the alias was not taken account of, and the completion simply listed all columns. This change fixes that, and makes the autocompletion behave the same as in `SELECT` and `WHERE` clauses.
2017-04-23 11:13:06 +00:00
* Completions after ORDER BY and DISTINCT now take account of table aliases. (Thanks: `Owen Stephens`_)
Complete keywords depending on previous token Keywords list is based on https://www.postgresql.org/docs/9.6/static/sql-commands.html.
2017-04-26 10:12:35 +00:00
* Narrow keyword candidates based on previous keyword. (Thanks: `Étienne Bersac`_)
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Opening an external editor will edit the last-run query. (Thanks: `Thomas Roten`_)
Update AUTHORS and changelog.rst
2017-05-25 12:46:51 +00:00
* Support query options in postgres URIs such as ?sslcert=foo.pem (Thanks: `Alexander Schmolck`_)
Update changelog.rst
2017-03-14 21:37:39 +00:00
Added fix to changelog.
2017-03-22 04:31:26 +00:00
Bug fixes:
----------
* Fixed external editor bug (issue #668). (Thanks: `Irina Truong`_).
Standardize command line option names This standardizes on the same names as psql and removes some conflicts.
2017-04-05 13:25:04 +00:00
* Standardize command line option names. (Thanks: `Russell Davies`_)
Update changelog, AUTHORS
2017-04-28 23:16:35 +00:00
* Improve handling of ``lock_not_available`` error (issue #700). (Thanks: `Jackson Popkin <https://github.com/jdpopkin>`_)
Changelog.
2017-04-30 23:46:09 +00:00
* Fixed user option precedence (issue #697). (Thanks: `Irina Truong`_).
Added fix to changelog.
2017-03-22 04:31:26 +00:00
Add behave to tox
2017-05-22 18:44:02 +00:00
Internal changes:
-----------------
Ported pep8radius addition from mycli.
2017-04-08 00:00:35 +00:00
* Run pep8 checks in travis (Thanks: `Irina Truong`_).
behave pager wrapper
2017-04-25 05:37:53 +00:00
* Add pager wrapper for behave tests (Thanks: `Dick Marinus`_).
behave quit pgcli nicely
2017-04-28 16:00:51 +00:00
* Behave quit pgcli nicely (Thanks: `Dick Marinus`_).
behave test source command
2017-04-28 19:16:11 +00:00
* Behave test source command (Thanks: `Dick Marinus`_).
behave fix clean up In an earlier commit I've changed the current working directory and the removal of a temporary file didn't take that into account.
2017-04-29 06:21:48 +00:00
* Behave fix clean up. (Thanks: `Dick Marinus`_).
Test using behave the tee command
2017-04-29 19:35:06 +00:00
* Test using behave the tee command (Thanks: `Dick Marinus`_).
Behave remove boiler plate code
2017-05-02 18:20:13 +00:00
* Behave remove boiler plate code (Thanks: `Dick Marinus`_).
fix pgspecial update in behave tests
2017-05-06 13:51:47 +00:00
* Behave fix pgspecial update (Thanks: `Dick Marinus`_).
Add behave to tox
2017-05-22 18:44:02 +00:00
* Add behave to tox (Thanks: `Dick Marinus`_).
Changelog for bugfix release 1.5.1.
2017-03-14 05:52:14 +00:00
1.5.1
=====
Find statements inside function body Consider this script ``` CREATE FUNCTION foo() returns text LANGUAGE SQL AS $func$ SELECT 1 FROM Bar; SELECT <cursor> FROM Baz; $func$; ``` The change here is that `SELECT <cursor> FROM Baz;` will be seen as the current statement, instead of the whole function definition. This means we'll no longer get column suggestions from `Bar`.
2016-06-28 08:40:14 +00:00
Features:
---------
* Better suggestions when editing functions (Thanks: `Joakim Koljonen`_)
Track recent changes in changelog.
2017-03-11 23:23:48 +00:00
* Command line option for ``--less-chatty``. (Thanks: `tk`_)
Changelog for bugfix release 1.5.1.
2017-03-14 05:52:14 +00:00
* Added ``MATERIALIZED VIEW`` keywords. (Thanks: `Joakim Koljonen`_).
Track recent changes in changelog.
2017-03-11 23:23:48 +00:00
Bug fixes:
----------
* Support unicode chars in expanded mode. (Thanks: `Amjith Ramanujam`_)
Changelog for bugfix release 1.5.1.
2017-03-14 05:52:14 +00:00
* Fixed "set_session cannot be used inside a transaction" when using dsn. (Thanks: `Irina Truong`_).
Find statements inside function body Consider this script ``` CREATE FUNCTION foo() returns text LANGUAGE SQL AS $func$ SELECT 1 FROM Bar; SELECT <cursor> FROM Baz; $func$; ``` The change here is that `SELECT <cursor> FROM Baz;` will be seen as the current statement, instead of the whole function definition. This means we'll no longer get column suggestions from `Bar`.
2016-06-28 08:40:14 +00:00
Changelog update for 1.5.0
2017-03-03 23:55:39 +00:00
1.5.0
=====
Features:
---------
* Upgraded pgspecial to 1.7.0. (See `pgspecial changelog <https://github.com/dbcli/pgspecial/blob/master/changelog.rst>`_ for list of fixes)
* Add a new config setting to allow expandable mode (Thanks: `Jonathan Boudreau <https://github.com/AGhost-7>`_)
* Make pgcli prompt width short when the prompt is too long (Thanks: `Jonathan Virga <https://github.com/jnth>`_)
* Add additional completion for ``ALTER`` keyword (Thanks: `Darik Gamble`_)
* Make the menu size configurable. (Thanks `Darik Gamble`_)
Bug Fixes:
----------
* Handle more connection failure cases. (Thanks: `Amjith Ramanujam`_)
* Fix the connection failure issues with latest psycopg2. (Thanks: `Amjith Ramanujam`_)
Internal Changes:
-----------------
* Add testing for Python 3.5 and 3.6. (Thanks: `Amjith Ramanujam`_)
Release v1.4.0.
2017-01-11 00:35:59 +00:00
1.4.0
=====
Features:
---------
* Search table suggestions using initialisms. (Thanks: `Joakim Koljonen`_).
* Support for table-qualifying column suggestions. (Thanks: `Joakim Koljonen`_).
* Display transaction status in the toolbar. (Thanks: `Joakim Koljonen`_).
* Display vi mode in the toolbar. (Thanks: `Joakim Koljonen`_).
* Added --prompt option. (Thanks: `Irina Truong`_).
Bug Fixes:
----------
* Fix scoping for columns from CTEs. (Thanks: `Joakim Koljonen`_)
* Fix crash after `with`. (Thanks: `Joakim Koljonen`_).
Emanuele Gaifas -> Lele Gaifax
2018-07-24 15:45:13 +00:00
* Fix issue #603 (`\i` raises a TypeError). (Thanks: `Lele Gaifax`_).
Release v1.4.0.
2017-01-11 00:35:59 +00:00
Internal Changes:
-----------------
* Set default data_formatting to nothing. (Thanks: `Amjith Ramanujam`_).
* Increased minimum prompt_toolkit requirement to 1.0.9. (Thanks: `Irina Truong`_).
Update changelog for version 1.3.1
2016-10-26 19:37:46 +00:00
1.3.1
=====
Bug Fixes:
----------
* Fix a crashing bug due to sqlparse upgrade. (Thanks: `Darik Gamble`_)
Changelog and authors update for 1.3.0
2016-10-22 03:47:47 +00:00
1.3.0
=====
IMPORTANT: Python 2.6 is not officially supported anymore.
Features:
---------
* Add delimiters to displayed numbers. This can be configured via the config file. (Thanks: `Sergii`_).
* Fix broken 'SHOW ALL' in redshift. (Thanks: `Manuel Barkhau`_).
* Support configuring keyword casing preferences. (Thanks: `Darik Gamble`_).
* Add a new multi_line_mode option in config file. The values can be `psql` or `safe`. (Thanks: `Joakim Koljonen`_)
Setting ``multi_line_mode = safe`` will make sure that a query will only be executed when Alt+Enter is pressed.
Bug Fixes:
----------
* Fix crash bug with leading parenthesis. (Thanks: `Joakim Koljonen`_).
* Remove cumulative addition of timing data. (Thanks: `Amjith Ramanujam`_).
* Handle unrecognized keywords gracefully. (Thanks: `Darik Gamble`_)
Emanuele Gaifas -> Lele Gaifax
2018-07-24 15:45:13 +00:00
* Use raw strings in regex specifiers. This preemptively fixes a crash in Python 3.6. (Thanks `Lele Gaifax`_)
Changelog and authors update for 1.3.0
2016-10-22 03:47:47 +00:00
Internal Changes:
-----------------
* Set sqlparse version dependency to >0.2.0, <0.3.0. (Thanks: `Amjith Ramanujam`_).
* XDG_CONFIG_HOME support for config file location. (Thanks: `Fabien Meghazi`_).
* Remove Python 2.6 from travis test suite. (Thanks: `Amjith Ramanujam`_)
Update changelog for version 1.2.0 release.
2016-09-01 12:45:18 +00:00
1.2.0
=====
Features:
---------
* Add more specifiers to pgcli prompt. (Thanks: `Julien Rouhaud`_).
``\p`` for port info ``\#`` for super user and ``\i`` for pid.
* Add `\watch` command to periodically execute a command. (Thanks: `Stuart Quin`_).
``> SELECT * FROM django_migrations; \watch 1 /* Runs the command every second */``
* Add command-line option --single-connection to prevent pgcli from using multiple connections. (Thanks: `Joakim Koljonen`_).
* Add priority to the suggestions to sort based on relevance. (Thanks: `Joakim Koljonen`_).
* Configurable null format via the config file. (Thanks: `Adrian Dries`_).
* Add support for CTE aware auto-completion. (Thanks: `Darik Gamble`_).
* Add host and user information to default pgcli prompt. (Thanks: `Lim H`_).
* Better scoping for tables in insert statements to improve suggestions. (Thanks: `Joakim Koljonen`_).
Bug Fixes:
----------
* Do not install setproctitle on cygwin. (Thanks: `Janus Troelsen`_).
* Work around sqlparse crashing after AS keyword. (Thanks: `Joakim Koljonen`_).
* Fix a crashing bug with named queries. (Thanks: `Joakim Koljonen`_).
* Replace timestampz alias since AWS Redshift does not support it. (Thanks: `Tahir Butt`_).
Update Changelog.
2016-09-02 13:47:36 +00:00
* Prevent pgcli from hanging indefinitely when Postgres instance is not running. (Thanks: `Darik Gamble`_)
Update changelog for version 1.2.0 release.
2016-09-01 12:45:18 +00:00
Internal Changes:
-----------------
* Upgrade to sqlparse-0.2.0. (Thanks: `Tiziano Müller`_).
* Upgrade to pgspecial 1.6.0. (Thanks: `Stuart Quin`_).
Update changelog for release 1.1.0.
2016-07-02 06:13:50 +00:00
1.1.0
=====
Features:
---------
* Add support for ``\db`` command. (Thanks: `Irina Truong`_)
Bugs:
-----
* Fix the crash at startup while parsing the postgres url with port number. (Thanks: `Eric Wald`_)
* Fix the crash with Redshift databases. (Thanks: `Darik Gamble`_)
Internal Changes:
-----------------
* Upgrade pgspecial to 1.5.0 and above.
Update changelog for release 1.0.0.
2016-05-12 05:59:49 +00:00
1.0.0
=====
Features:
---------
* Upgrade to prompt-toolkit 1.0.0. (Thanks: `Jonathan Slenders`_).
Update the changelong to include pgspecial upgrade.
2016-06-19 23:26:37 +00:00
* Add support for `\o` command to redirect query output to a file. (Thanks: `Tim Sanders`_).
* Add `\i` path completion. (Thanks: `Anthony Lai`_).
Update changelog for release 1.0.0.
2016-05-12 05:59:49 +00:00
* Connect to a dsn saved in config file. (Thanks: `Rodrigo Ramírez Norambuena`_).
* Upgrade sqlparse requirement to version 0.1.19. (Thanks: `Fernando L. Canizo`_).
* Add timestamptz to DATE custom extension. (Thanks: `Fernando Mora`_).
* Ensure target dir exists when copying config. (Thanks: `David Szotten`_).
* Handle dates that fall in the B.C. range. (Thanks: `Stuart Quin`_).
* Pager is selected from config file or else from environment variable. (Thanks: `Fernando Mora`_).
Update authors and changelog.
2016-06-19 22:15:55 +00:00
* Add support for Amazon Redshift. (Thanks: `Timothy Cleaver`_).
* Add support for Postgres 8.x. (Thanks: `Timothy Cleaver`_ and `Darik Gamble`_)
Update changelog for release 1.0.0.
2016-05-12 05:59:49 +00:00
* Don't error when completing parameter-less functions. (Thanks: `David Szotten`_).
* Concat and return all available notices. (Thanks: `Stuart Quin`_).
* Handle unicode in record type. (Thanks: `Amjith Ramanujam`_).
* Added humanized time display. Connect #396. (Thanks: `Irina Truong`_).
* Add EXPLAIN keyword to the completion list. (Thanks: `Amjith Ramanujam`_).
* Added sdist upload to release script. (Thanks: `Irina Truong`_).
* Sort completions based on most recently used. (Thanks: `Darik Gamble`)
Update authors and changelog.
2016-06-19 22:15:55 +00:00
* Expand '*' into column list during completion. This can be triggered by hitting `<tab>` after the '*' character in the sql while typing. (Thanks: `Joakim Koljonen`_)
* Add a limit to the warning about too many rows. This is controlled by a new config value in ~/.config/pgcli/config. (Thanks: `Anže Pečar`_)
* Improved argument list in function parameter completions. (Thanks: `Joakim Koljonen`_)
* Column suggestions after the COLUMN keyword. (Thanks: `Darik Gamble`_)
* Filter out trigger implemented functions from the suggestion list. (Thanks: `Daniel Rocco`_)
* State of the art JOIN clause completions that suggest entire conditions. (Thanks: `Joakim Koljonen`_)
* Suggest fully formed JOIN clauses based on Foreign Key relations. (Thanks: `Joakim Koljonen`_)
Update the changelong to include pgspecial upgrade.
2016-06-19 23:26:37 +00:00
* Add support for `\dx` meta command to list the installed extensions. (Thanks: `Darik Gamble`_)
* Add support for `\copy` command. (Thanks: `Catherine Devlin`_)
Update changelog for release 1.0.0.
2016-05-12 05:59:49 +00:00
Bugs:
-----
* Fix bug where config writing would leave a '~' dir. (Thanks: `James Munson`_).
* Fix auto-completion breaking for table names with caps. (Thanks: `Anthony Lai`_).
* Fix lexical ordering bug. (Thanks: `Anthony Lai`_).
* Use lexical order to break ties when fuzzy matching. (Thanks: `Daniel Rocco`_).
* Fix the bug in auto-expand mode when there are no rows to display. (Thanks: `Amjith Ramanujam`_).
* Fix broken `\i` after #395. (Thanks: `David Szotten`_).
* Fix multi-way joins in auto-completion. (Thanks: `Darik Gamble`_)
* Display null values as <null> in expanded output. (Thanks: `Amjith Ramanujam`_).
Update authors and changelog.
2016-06-19 22:15:55 +00:00
* Robust support for Postgres version less than 9.x. (Thanks: `Darik Gamble`_)
Update changelog for release 1.0.0.
2016-05-12 05:59:49 +00:00
Internal Changes:
-----------------
* Update config file location in README. (Thanks: `Ari Summer`_).
* Explicitly add wcwidth as a dependency. (Thanks: `Amjith Ramanujam`_).
* Add tests for the format_output. (Thanks: `Amjith Ramanujam`_).
* Lots of tests for pgcompleter. (Thanks: `Darik Gamble`_).
Update the changelong to include pgspecial upgrade.
2016-06-19 23:26:37 +00:00
* Update pgspecial dependency to 1.4.0.
Update changelog for release 1.0.0.
2016-05-12 05:59:49 +00:00
0.20.1
Update the changelong and AUTHORS for 0.20.0 release.
2015-10-31 13:49:50 +00:00
======
Preparing release 0.20.1 with Windows log fix.
2015-11-07 19:23:39 +00:00
Bug Fixes:
----------
Changed my name in changelog.
2017-12-22 18:49:26 +00:00
* Fixed logging in Windows by switching the location of log and history file based on OS. (Thanks: Amjith, `Darik Gamble`_, `Irina Truong`_).
Preparing release 0.20.1 with Windows log fix.
2015-11-07 19:23:39 +00:00
0.20.0
======
Update the changelong and AUTHORS for 0.20.0 release.
2015-10-31 13:49:50 +00:00
Features:
---------
Changed my name in changelog.
2017-12-22 18:49:26 +00:00
* Perform auto-completion refresh in background. (Thanks: Amjith, `Darik Gamble`_, `Irina Truong`_).
Update the changelong and AUTHORS for 0.20.0 release.
2015-10-31 13:49:50 +00:00
When the auto-completion entries are refreshed, the update now happens in a
background thread. This means large databases with thousands of tables are
handled without blocking.
* Add ``CONCURRENTLY`` to keyword completion. (Thanks: `Johannes Hoff`_).
Update the changelong to add \h.
2015-11-01 05:11:24 +00:00
* Add support for ``\h`` command. (Thanks: `Stuart Quin`_).
This is a huge deal. Users can now get help on an SQL command by typing:
``\h COMMAND_NAME`` in the pgcli prompt.
Update the changelong and AUTHORS for 0.20.0 release.
2015-10-31 13:49:50 +00:00
* Add support for ``\x auto``. (Thanks: `Stuart Quin`_).
``\\x auto`` will automatically switch to expanded mode if the output is wider
than the display window.
* Don't hide functions from pg_catalog. (Thanks: `Darik Gamble`_).
* Suggest set-returning functions as tables. (Thanks: `Darik Gamble`_).
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
Functions that return table like results will now be suggested in places of tables.
Update the changelong and AUTHORS for 0.20.0 release.
2015-10-31 13:49:50 +00:00
* Suggest fields from functions used as tables. (Thanks: `Darik Gamble`_).
Changed my name in changelog.
2017-12-22 18:49:26 +00:00
* Using ``pgspecial`` as a separate module. (Thanks: `Irina Truong`_).
Update the changelong and AUTHORS for 0.20.0 release.
2015-10-31 13:49:50 +00:00
* Make "enter" key behave as "tab" key when the completion menu is displayed. (Thanks: `Matheus Rosa`_).
* Support different error-handling options when running multiple queries. (Thanks: `Darik Gamble`_).
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
When ``on_error = STOP`` in the config file, pgcli will abort execution if one of the queries results in an error.
Update the changelong and AUTHORS for 0.20.0 release.
2015-10-31 13:49:50 +00:00
* Hide the password displayed in the process name in ``ps``. (Thanks: `Stuart Quin`_)
Bug Fixes:
----------
* Fix the ordering bug in `\\d+` display, this bug was displaying the wrong table name in the reference. (Thanks: `Tamas Boros`_).
* Only show expanded layout if valid list of headers provided. (Thanks: `Stuart Quin`_).
* Fix suggestions in compound join clauses. (Thanks: `Darik Gamble`_).
* Fix completion refresh in multiple query scenario. (Thanks: `Darik Gamble`_).
* Fix the broken timing information.
* Fix the removal of whitespaces in the output. (Thanks: `Jacek Wielemborek`_)
* Fix PyPI badge. (Thanks: `Artur Dryomov`_).
Improvements:
-------------
* Move config file to `~/.config/pgcli/config` instead of `~/.pgclirc` (Thanks: `inkn`_).
* Move literal definitions to standalone JSON files. (Thanks: `Darik Gamble`_).
Internal Changes:
-----------------
Changed my name in changelog.
2017-12-22 18:49:26 +00:00
* Improvements to integration tests to make it more robust. (Thanks: `Irina Truong`_).
Update the changelong and AUTHORS for 0.20.0 release.
2015-10-31 13:49:50 +00:00
Updated changelog and AUTHORS for v0.19.2.
2015-08-29 05:38:18 +00:00
0.19.2
======
Features:
---------
* Autocompletion for database name in \c and \connect. (Thanks: `Darik Gamble`_).
* Improved multiline query support by correctly handling open quotes. (Thanks: `Darik Gamble`_).
* Added \pager command.
* Enhanced \i to run multiple queries and display the results for each of them
* Added keywords to suggestions after WHERE clause.
Changed my name in changelog.
2017-12-22 18:49:26 +00:00
* Enabled autocompletion in named queries. (Thanks: `Irina Truong`_).
* Path to .pgclirc can be specified in command line. (Thanks: `Irina Truong`_).
* Added support for pg_service_conf file. (Thanks: `Irina Truong`_).
Updated changelog and AUTHORS for v0.19.2.
2015-08-29 05:38:18 +00:00
* Added custom styles. (Contributor: `Darik Gamble`_).
Internal Changes:
-----------------
* More completer test cases. (Thanks: `Darik Gamble`_).
* Updated sqlparse version from 0.1.14 to 0.1.16. (Thanks: `Darik Gamble`_).
* Upgraded to prompt_toolkit 0.46. (Thanks: `Jonathan Slenders`_).
BugFixes:
---------
* Fixed the completer crashing on invalid SQL. (Thanks: `Darik Gamble`_).
* Fixed unicode issues, updated tests and fixed broken tests.
Update changelog for 0.19.1 release.
2015-08-04 14:10:38 +00:00
0.19.1
======
Fix typo in in changelog.
2015-08-10 02:36:11 +00:00
BugFixes:
Update changelog for 0.19.1 release.
2015-08-04 14:10:38 +00:00
---------
* Fix an autocompletion bug that was crashing the completion engine when unknown keyword is entered. (Thanks: `Darik Gamble`_)
Update changelog.
2015-08-03 00:09:17 +00:00
0.19.0
======
Features:
---------
* Wider completion menus can be enabled via the config file. (Thanks: `Jonathan Slenders`_)
Open the config file (~/.pgclirc) and check if you have
``wider_completion_menu`` option available. If not add it in and set it to
``True``.
* Completion menu now has metadata information such as schema, table, column, view, etc., next to the suggestions. (Thanks: `Darik Gamble`_)
* Customizable history file location via config file. (Thanks: `Çağatay Yüksel`_)
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
Add this line to your config file (~/.pgclirc) to customize where to store the history file.
Update changelog.
2015-08-03 00:09:17 +00:00
::
history_file = /path/to/history/file
* Add support for running queries from a file using ``\i`` special command. (Thanks: `Michael Kaminsky`_)
BugFixes:
---------
* Always use utf-8 for database encoding regardless of the default encoding used by the database.
* Fix for None dereference on ``\d schemaname.`` with sequence. (Thanks: `Nathan Jhaveri`_)
Fix a typo in changelog.
2015-08-03 15:49:26 +00:00
* Fix a crashing bug in the autocompletion engine for some ``JOIN`` queries.
Update changelog.
2015-08-03 00:09:17 +00:00
* Handle KeyboardInterrupt in pager and not quit pgcli as a consequence.
Internal Changes:
-----------------
Changed my name in changelog.
2017-12-22 18:49:26 +00:00
* Added more behaviorial tests (Thanks: `Irina Truong`_)
* Added code coverage to the tests. (Thanks: `Irina Truong`_)
* Run behaviorial tests as part of TravisCI (Thanks: `Irina Truong`_)
Update changelog.
2015-08-03 00:09:17 +00:00
* Upgraded prompt_toolkit version to 0.45 (Thanks: `Jonathan Slenders`_)
Fix typos (#1345) Co-authored-by: Irina Truong <i.chernyavska@gmail.com>
2022-06-08 18:38:29 +00:00
* Update the minimum required version of click to 4.1.
Update changelog.
2015-08-03 00:09:17 +00:00
Update Changelog for version 0.18.0.
2015-06-17 01:06:40 +00:00
0.18.0
======
Features:
---------
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Add fuzzy matching for the table names and column names.
Update Changelog for version 0.18.0.
2015-06-17 01:06:40 +00:00
Matching very long table/column names are now easier with fuzzy matching. The
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
fuzzy match works like the fuzzy open in SublimeText or Vim's Ctrl-P plugin.
Update Changelog for version 0.18.0.
2015-06-17 01:06:40 +00:00
eg: Typing ``djmv`` will match `django_migration_views` since it is able to
match parts of the input to the full table name.
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Change the timing information to seconds.
Update Changelog for version 0.18.0.
2015-06-17 01:06:40 +00:00
The ``Command Time`` and ``Format Time`` are now displayed in seconds instead
of a unitless number displayed in scientific notation.
* Support for named queries (favorite queries). (Thanks: `Brett Atoms`_)
Frequently typed queries can now be saved and recalled using a name using
newly added special commands (``\n[+]``, ``\ns``, ``\nd``).
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
eg:
Update Changelog for version 0.18.0.
2015-06-17 01:06:40 +00:00
::
# Save a query
pgcli> \ns simple select * from foo
saved
# List all saved queries
pgcli> \n+
# Execute a saved query
pgcli> \n simple
# Delete a saved query
pgcli> \nd simple
* Pasting queries into the pgcli repl is orders of magnitude faster. (Thanks: `Jonathan Slenders`_)
* Add support for PGPASSWORD environment variable to pass the password for the
Changed my name in changelog.
2017-12-22 18:49:26 +00:00
postgres database. (Thanks: `Irina Truong`_)
Update Changelog for version 0.18.0.
2015-06-17 01:06:40 +00:00
* Add the ability to manually refresh autocompletions by typing ``\#`` or
``\refresh``. This is useful if the database was updated by an external means
and you'd like to refresh the auto-completions to pick up the new change.
Bug Fixes:
----------
* Fix an error when running ``\d table_name`` when running on a table with rules. (Thanks: `Ali Kargın`_)
* Fix a pgcli crash when entering non-ascii characters in Windows. (Thanks: `Darik Gamble`_, `Jonathan Slenders`_)
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Faster rendering of expanded mode output by making the horizontal separator a fixed length string.
* Completion suggestions for the ``\c`` command are not auto-escaped by default.
Update Changelog for version 0.18.0.
2015-06-17 01:06:40 +00:00
Internal Changes:
-----------------
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Complete refactor of handling the back-slash commands.
Update Changelog for version 0.18.0.
2015-06-17 01:06:40 +00:00
* Upgrade prompt_toolkit to 0.42. (Thanks: `Jonathan Slenders`_)
* Change the config file management to use ConfigObj.(Thanks: `Brett Atoms`_)
Changed my name in changelog.
2017-12-22 18:49:26 +00:00
* Add integration tests using ``behave``. (Thanks: `Irina Truong`_)
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
Prep changelog for next release.
2015-04-03 01:31:22 +00:00
0.17.0
======
Features:
---------
Update changelog for 0.17.0 release.
2015-05-25 06:38:39 +00:00
* Add support for auto-completing view names. (Thanks: `Darik Gamble`_)
Add instructions for RPM and DEB package building.
2015-04-15 05:16:13 +00:00
* Add support for building RPM and DEB packages. (Thanks: dp_)
Update changelog for 0.17.0 release.
2015-05-25 06:38:39 +00:00
* Add subsequence matching for completion. (Thanks: `Daniel Rocco`_)
Previously completions only matched a table name if it started with the
partially typed word. Now completions will match even if the partially typed
word is in the middle of a suggestion.
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
eg: When you type 'mig', 'django_migrations' will be suggested.
Update changelog for 0.17.0 release.
2015-05-25 06:38:39 +00:00
* Completion for built-in tables and temporary tables are suggested after entering a prefix of ``pg_``. (Thanks: `Darik Gamble`_)
Changed my name in changelog.
2017-12-22 18:49:26 +00:00
* Add place holder doc strings for special commands that are planned for implementation. (Thanks: `Irina Truong`_)
Release v1.4.0.
2017-01-11 00:35:59 +00:00
* Updated version of prompt_toolkit, now matching braces are highlighted. (Thanks: `Jonathan Slenders`_)
Changed my name in changelog.
2017-12-22 18:49:26 +00:00
* Added support of ``\\e`` command. Queries can be edited in an external editor. (Thanks: `Irina Truong`_)
Update changelog for 0.17.0 release.
2015-05-25 06:38:39 +00:00
eg: When you type ``SELECT * FROM \e`` it will be opened in an external editor.
* Add special command ``\dT`` to show datatypes. (Thanks: `Darik Gamble`_)
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Add auto-completion support for datatypes in CREATE, SELECT etc. (Thanks: `Darik Gamble`_)
Update changelog for 0.17.0 release.
2015-05-25 06:38:39 +00:00
* Improve the auto-completion in WHERE clause with logical operators. (Thanks: `Darik Gamble`_)
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
*
Prep changelog for next release.
2015-04-03 01:31:22 +00:00
Bug Fixes:
----------
Update changelog.
2015-04-06 00:28:47 +00:00
* Fix the table formatting while printing multi-byte characters (Chinese, Japanese etc). (Thanks: `蔡佳男`_)
Update changelog for 0.17.0 release.
2015-05-25 06:38:39 +00:00
* Fix a crash when pg_catalog was present in search path. (Thanks: `Darik Gamble`_)
* Fixed a bug that broke `\\e` when prompt_tookit was updated. (Thanks: `François Pietka`_)
* Fix the display of triggers as shown in the ``\d`` output. (Thanks: `Dimitar Roustchev`_)
* Fix broken auto-completion for INNER JOIN, LEFT JOIN etc. (Thanks: `Darik Gamble`_)
* Fix incorrect super() calls in pgbuffer, pgtoolbar and pgcompleter. No change in functionality but protects against future problems. (Thanks: `Daniel Rocco`_)
* Add missing schema completion for CREATE and DROP statements. (Thanks: `Darik Gamble`_)
* Minor fixes around cursor cleanup.
Prep changelog for next release.
2015-04-03 01:31:22 +00:00
Add a title field and report the notices. Closes #177
2015-03-25 07:22:20 +00:00
0.16.3
======
Bug Fixes:
----------
* Add more SQL keywords for auto-complete suggestion.
Changelog update.
2015-04-03 01:19:07 +00:00
* Messages raised as part of stored procedures are no longer ignored.
Update Changelog.
2015-03-27 04:21:21 +00:00
* Use postgres flavored syntax highlighting instead of generic ANSI SQL.
Add a title field and report the notices. Closes #177
2015-03-25 07:22:20 +00:00
Update changelog.
2015-03-09 01:07:18 +00:00
0.16.2
======
Bug Fixes:
----------
Update changelog.
2015-03-10 07:20:57 +00:00
* Fix a bug where the schema qualifier was ignored by the auto-completion.
Update changelog for 0.17.0 release.
2015-05-25 06:38:39 +00:00
As a result the suggestions for tables vs functions are cleaner. (Thanks: `Darik Gamble`_)
Changelog update.
2015-03-22 20:55:33 +00:00
* Remove scientific notation when formatting large numbers. (Thanks: `Daniel Rocco`_)
Update changelog.
2015-03-09 01:07:18 +00:00
* Add the FUNCTION keyword to auto-completion.
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Display NULL values as <null> instead of empty strings.
Update changelog.
2015-03-14 20:38:07 +00:00
* Fix the completion refresh when ``\connect`` is executed.
Update changelog.
2015-03-09 01:07:18 +00:00
Changelog update.
2015-03-04 07:17:41 +00:00
0.16.1
======
Update changelog.
2015-03-09 01:07:18 +00:00
Changelog update.
2015-03-04 07:17:41 +00:00
Bug Fixes:
----------
* Fix unicode issues with hstore.
* Fix a silent error when database is changed using \\c.
Update changelog.
2015-02-12 08:14:55 +00:00
0.16.0
======
Update changelog.
2015-02-12 21:17:18 +00:00
Features:
---------
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Add \ds special command to show sequences.
Specify how to enable vi bindings in changelog.
2015-03-01 09:19:15 +00:00
* Add Vi mode for keybindings. This can be enabled by adding 'vi = True' in ~/.pgclirc. (Thanks: `Jay Zeng`_)
Changelog update.
2015-02-14 01:03:24 +00:00
* Add a -v/--version flag to pgcli.
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Add completion for TEMPLATE keyword and smart-completion for
Update changelog.
2015-02-27 03:58:03 +00:00
'CREATE DATABASE blah WITH TEMPLATE <tab>'. (Thanks: `Daniel Rocco`_)
Changelog update.
2015-03-01 05:56:43 +00:00
* Add custom decoders to json/jsonb to emulate the behavior of psql. This
removes the unicode prefix (eg: u'Éowyn') in the output. (Thanks: `Daniel Rocco`_)
Update changelog for 0.17.0 release.
2015-05-25 06:38:39 +00:00
* Add \df special command to show functions. (Thanks: `Darik Gamble`_)
* Make suggestions for special commands smarter. eg: \dn - only suggests schemas. (Thanks: `Darik Gamble`_)
Update changelog.
2015-03-01 08:58:02 +00:00
* Print out the version and other meta info about pgcli at startup.
Update changelog.
2015-02-12 08:14:55 +00:00
Update changelog.
2015-02-12 21:17:18 +00:00
Bug Fixes:
----------
Update changelog for 0.17.0 release.
2015-05-25 06:38:39 +00:00
* Fix a rare crash caused by adding new schemas to a database. (Thanks: `Darik Gamble`_)
* Make \dt command honor the explicit schema specified in the arg. (Thanks: `Darik Gamble`_)
Changelog update.
2015-02-13 08:55:42 +00:00
* Print BIGSERIAL type as Integer instead of Float.
Update changelog.
2015-02-27 03:58:03 +00:00
* Show completions for special commands at the beginning of a statement. (Thanks: `Daniel Rocco`_)
Update changelog.
2015-02-27 07:35:56 +00:00
* Allow special commands to work in a multi-statement case where multiple sql
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
statements are separated by semi-colon in the same line.
Update changelog.
2015-02-12 21:17:18 +00:00
Update changelog.
2015-02-12 08:14:55 +00:00
0.15.4
======
* Dummy version to replace accidental PyPI entry deletion.
Override LESS options completely.
2015-02-09 04:33:04 +00:00
0.15.3
======
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Override the LESS options completely instead of appending to it.
Override LESS options completely.
2015-02-09 04:33:04 +00:00
0.15.2
Release v1.4.0.
2017-01-11 00:35:59 +00:00
======
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Revert back to using psycopg2 as the postgres adapter. psycopg2cffi fails for some tests in Python 3.
Override LESS options completely.
2015-02-09 04:33:04 +00:00
0.15.0
Release v1.4.0.
2017-01-11 00:35:59 +00:00
======
Add a test for the boolean printing.
2015-02-01 00:38:47 +00:00
Add completion for COPY command.
2015-02-05 02:32:50 +00:00
Features:
---------
* Add syntax color styles to config.
* Add auto-completion for COPY statements.
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Change Postgres adapter to psycopg2cffi, to make it PyPy compatible.
Update changelog.
2015-02-08 22:09:12 +00:00
Now pgcli can be run by PyPy.
Add completion for COPY command.
2015-02-05 02:32:50 +00:00
Add a test for the boolean printing.
2015-02-01 00:38:47 +00:00
Bug Fixes:
----------
* Treat boolean values as strings instead of ints.
Update changelog for 0.17.0 release.
2015-05-25 06:38:39 +00:00
* Make \di, \dv and \dt to be schema aware. (Thanks: `Darik Gamble`_)
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Make column name display unicode compatible.
Add a test for the boolean printing.
2015-02-01 00:38:47 +00:00
changelog fix.
2015-01-31 23:26:33 +00:00
0.14.0
======
Update changelog.
2015-01-22 05:45:38 +00:00
Features:
---------
Changed my name in changelog.
2017-12-22 18:49:26 +00:00
* Add alias completion support to ON keyword. (Thanks: `Irina Truong`_)
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Add LIMIT keyword to completion.
Update changelog for 0.17.0 release.
2015-05-25 06:38:39 +00:00
* Auto-completion for Postgres schemas. (Thanks: `Darik Gamble`_)
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Better unicode handling for datatypes, dbname and roles.
* Add \timing command to time the sql commands.
Add missing changelog entries.
2015-01-31 23:41:11 +00:00
This can be set via config file (~/.pgclirc) using `timing = True`.
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Add different table styles for displaying output.
Add missing changelog entries.
2015-01-31 23:41:11 +00:00
This can be changed via config file (~/.pgclirc) using `table_format = fancy_grid`.
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Add confirmation before printing results that have more than 1000 rows.
Update changelog.
2015-01-22 05:45:38 +00:00
Bug Fixes:
----------
* Performance improvements to expanded view display (\x).
* Cast bytea files to text while displaying. (Thanks: `Daniel Rocco`_)
* Added a list of reserved words that should be auto-escaped.
Changelog update.
2015-01-30 06:23:09 +00:00
* Auto-completion is now case-insensitive.
Update changelog for 0.17.0 release.
2015-05-25 06:38:39 +00:00
* Fix the broken completion for multiple sql statements. (Thanks: `Darik Gamble`_)
Update changelog.
2015-01-22 05:45:38 +00:00
Prep for release.
2015-01-15 01:12:02 +00:00
0.13.0
======
Changelog update.
2015-01-14 06:16:41 +00:00
Features:
---------
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Add -d/--dbname option to the commandline.
Changelog update.
2015-01-14 06:16:41 +00:00
eg: pgcli -d database
* Add the username as an argument after the database.
eg: pgcli dbname user
Bug Fixes:
----------
* Fix the crash when \c fails.
* Fix the error thrown by \d when triggers are present.
Update changelog for 0.17.0 release.
2015-05-25 06:38:39 +00:00
* Fix broken behavior on \?. (Thanks: `Darik Gamble`_)
Changelog update.
2015-01-14 06:16:41 +00:00
Change the version number in changelog to 0.12.0.
2015-01-13 07:58:51 +00:00
0.12.0
======
Update changelog with 0.12.0 items.
2015-01-10 08:51:45 +00:00
Features:
---------
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Upgrade to prompt_toolkit version 0.26 (Thanks: https://github.com/macobo)
Update changelog with 0.12.0 items.
2015-01-10 08:51:45 +00:00
* Adds Ctrl-left/right to move the cursor one word left/right respectively.
* Internal API changes.
Update changelog for 0.17.0 release.
2015-05-25 06:38:39 +00:00
* IPython integration through `ipython-sql`_ (Thanks: `Darik Gamble`_)
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
* Add an ipython magic extension to embed pgcli inside ipython.
* Results from a pgcli query are sent back to ipython.
Fix typos (#1345) Co-authored-by: Irina Truong <i.chernyavska@gmail.com>
2022-06-08 18:38:29 +00:00
* Multiple sql statements in the same line separated by semi-colon. (Thanks: https://github.com/macobo)
Update changelog with 0.12.0 items.
2015-01-10 08:51:45 +00:00
.. _`ipython-sql`: https://github.com/catherinedevlin/ipython-sql
Changelog update to add the multi-query feature.
2015-01-11 00:48:38 +00:00
Bug Fixes:
----------
* Fix 'message' attribute not found exception in Python 3. (Thanks: https://github.com/GMLudo)
Update changelog to add username used for database name.
2015-01-11 01:06:57 +00:00
* Use the database username as the database name instead of defaulting to OS username. (Thanks: https://github.com/fpietka)
Update changelog.
2015-01-12 08:40:10 +00:00
* Auto-completion for auto-escaped column/table names.
changelog update.
2015-01-13 07:55:46 +00:00
* Fix i-reverse-search to work in prompt_toolkit version 0.26.
Changelog update to add the multi-query feature.
2015-01-11 00:48:38 +00:00
Fix version number in changelog.
2015-01-10 05:17:16 +00:00
0.11.0
Add a changelog.
2015-01-10 01:32:32 +00:00
======
Features:
---------
* Add \dn command. (Thanks: https://github.com/CyberDem0n)
* Add \x command. (Thanks: https://github.com/stuartquin)
* Auto-escape special column/table names. (Thanks: https://github.com/qwesda)
* Cancel a command using Ctrl+C. (Thanks: https://github.com/macobo)
* Faster startup by reading all columns and tables in a single query. (Thanks: https://github.com/macobo)
Update changelog for 0.17.0 release.
2015-05-25 06:38:39 +00:00
* Improved psql compliance with env vars and password prompting. (Thanks: `Darik Gamble`_)
Add keybinding for alt-enter to introduce a line break (#1065) * Add keybinding for alt-enter to introduce a line break. * Update changelog. * Added myself to AUTHORS file * Fixed quote issue by pre-commit
2019-06-03 02:15:16 +00:00
* Pressing Alt-Enter will introduce a line break. This is a way to break up the query into multiple lines without switching to multi-line mode. (Thanks: https://github.com/pabloab).
Add a changelog.
2015-01-10 01:32:32 +00:00
Bug Fixes:
----------
* Fix the broken behavior of \d+. (Thanks: https://github.com/macobo)
* Fix a crash during auto-completion. (Thanks: https://github.com/Erethon)
crediting Catherine Devlin
2018-05-14 20:28:30 +00:00
* Avoid losing pre_run_callables on error in editing. (Thanks: https://github.com/catherinedevlin)
Add a changelog.
2015-01-10 01:32:32 +00:00
Improvements:
-------------
* Faster test runs on TravisCI. (Thanks: https://github.com/macobo)
* Integration tests with Postgres!! (Thanks: https://github.com/macobo)
Update changelog with \? crash fix.
2015-01-15 01:07:29 +00:00
Enable suspend using C-Z. (#970) * Enable suspend using C-Z. * Update changelog.
2018-11-18 03:41:34 +00:00
.. _`Amjith Ramanujam`: https://blog.amjith.com
add feature in changelog
2018-03-29 16:58:43 +00:00
.. _`Andrew Kuchling`: https://github.com/akuchling
Update changelog for 0.17.0 release.
2015-05-25 06:38:39 +00:00
.. _`Darik Gamble`: https://github.com/darikg
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
.. _`Daniel Rocco`: https://github.com/drocco007
.. _`Jay Zeng`: https://github.com/jayzeng
Update changelog.
2015-04-06 00:28:47 +00:00
.. _`蔡佳男`: https://github.com/xalley
Add instructions for RPM and DEB package building.
2015-04-15 05:16:13 +00:00
.. _dp: https://github.com/ceocoder
Update changelog for 0.17.0 release.
2015-05-25 06:38:39 +00:00
.. _`Jonathan Slenders`: https://github.com/jonathanslenders
.. _`Dimitar Roustchev`: https://github.com/droustchev
.. _`François Pietka`: https://github.com/fpietka
Update Changelog for version 0.18.0.
2015-06-17 01:06:40 +00:00
.. _`Ali Kargın`: https://github.com/sancopanco
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
.. _`Brett Atoms`: https://github.com/brettatoms
Update changelog.
2015-08-03 00:09:17 +00:00
.. _`Nathan Jhaveri`: https://github.com/nathanjhaveri
.. _`Çağatay Yüksel`: https://github.com/cagatay
.. _`Michael Kaminsky`: https://github.com/mikekaminsky
Update the changelong and AUTHORS for 0.20.0 release.
2015-10-31 13:49:50 +00:00
.. _`inkn`: inkn
.. _`Johannes Hoff`: Johannes Hoff
.. _`Matheus Rosa`: Matheus Rosa
.. _`Artur Dryomov`: https://github.com/ming13
.. _`Stuart Quin`: https://github.com/stuartquin
.. _`Tamas Boros`: https://github.com/TamasNo1
.. _`Jacek Wielemborek`: https://github.com/d33tah
Update changelog for release 1.0.0.
2016-05-12 05:59:49 +00:00
.. _`Rodrigo Ramírez Norambuena`: https://github.com/roramirez
Update Anthony's github address.
2016-05-26 07:19:56 +00:00
.. _`Anthony Lai`: https://github.com/ajlai
Update changelog for release 1.0.0.
2016-05-12 05:59:49 +00:00
.. _`Ari Summer`: Ari Summer
.. _`David Szotten`: David Szotten
.. _`Fernando L. Canizo`: Fernando L. Canizo
.. _`Tim Sanders`: https://github.com/Gollum999
.. _`Irina Truong`: https://github.com/j-bennet
.. _`James Munson`: https://github.com/jmunson
.. _`Fernando Mora`: https://github.com/fernandomora
.. _`Timothy Cleaver`: Timothy Cleaver
.. _`gtxx`: gtxx
Update authors and changelog.
2016-06-19 22:15:55 +00:00
.. _`Joakim Koljonen`: https://github.com/koljonen
.. _`Anže Pečar`: https://github.com/Smotko
Update the changelong to include pgspecial upgrade.
2016-06-19 23:26:37 +00:00
.. _`Catherine Devlin`: https://github.com/catherinedevlin
Update changelog for release 1.1.0.
2016-07-02 06:13:50 +00:00
.. _`Eric Wald`: https://github.com/eswald
Update changelog for version 1.2.0 release.
2016-09-01 12:45:18 +00:00
.. _`avdd`: https://github.com/avdd
.. _`Adrian Dries`: Adrian Dries
.. _`Julien Rouhaud`: https://github.com/rjuju
.. _`Lim H`: Lim H
.. _`Tahir Butt`: Tahir Butt
.. _`Tiziano Müller`: https://github.com/dev-zero
.. _`Janus Troelsen`: https://github.com/ysangkok
Changelog and authors update for 1.3.0
2016-10-22 03:47:47 +00:00
.. _`Fabien Meghazi`: https://github.com/amigrave
.. _`Manuel Barkhau`: https://github.com/mbarkhau
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
.. _`Sergii`: https://github.com/foxyterkel
Emanuele Gaifas -> Lele Gaifax
2018-07-24 15:45:13 +00:00
.. _`Lele Gaifax`: https://github.com/lelit
Track recent changes in changelog.
2017-03-11 23:23:48 +00:00
.. _`tk`: https://github.com/kanet77
Allow configurable multiline continuation char
2017-03-30 10:12:25 +00:00
.. _`Owen Stephens`: https://github.com/owst
Standardize command line option names This standardizes on the same names as psql and removes some conflicts.
2017-04-05 13:25:04 +00:00
.. _`Russell Davies`: https://github.com/russelldavies
Fix @meeuw broken link
2017-04-27 14:39:33 +00:00
.. _`Dick Marinus`: https://github.com/meeuw
Complete keywords depending on previous token Keywords list is based on https://www.postgresql.org/docs/9.6/static/sql-commands.html.
2017-04-26 10:12:35 +00:00
.. _`Étienne Bersac`: https://github.com/bersace
Edit last-run query in external editor.
2017-05-03 04:31:29 +00:00
.. _`Thomas Roten`: https://github.com/tsroten
Merge remote-tracking branch 'upstream/master' into feature/tox_behave
2017-05-22 18:45:55 +00:00
.. _`Gustavo Castro`: https://github.com/gustavo-castro
Update AUTHORS and changelog.rst
2017-05-25 12:46:51 +00:00
.. _`Alexander Schmolck`: https://github.com/aschmolck
Remove OrderedDict workaround for python < 2.7
2017-08-20 13:33:46 +00:00
.. _`Andrew Speed`: https://github.com/AndrewSpeed
Changelog update to release 1.8.2.
2017-12-05 03:12:11 +00:00
.. _`Dmitry B`: https://github.com/oxitnik
fixed reference
2017-12-16 06:47:22 +00:00
.. _`Marcin Sztolcman`: https://github.com/msztolcman
-- correct name in changelog -- removed extra line from AUTHORS
2017-12-16 23:46:55 +00:00
.. _`Isank`: https://github.com/isank
More changes added to 1.8.2 release.
2017-12-21 04:44:36 +00:00
.. _`Bojan Delić`: https://github.com/delicb
add my github link
2018-01-03 21:10:40 +00:00
.. _`Frederic Aoustin`: https://github.com/fraoustin
Add entries to changelog and AUTHORS
2018-05-14 16:23:28 +00:00
.. _`Jason Ribeiro`: https://github.com/jrib
Update changelog.rst
2018-05-15 05:04:03 +00:00
.. _`Rishi Ramraj`: https://github.com/RishiRamraj
Changelog link.
2018-06-06 16:48:48 +00:00
.. _`Matthieu Guilbert`: https://github.com/gma2th
add me to thanks inline block and to references to me
2018-06-15 20:43:37 +00:00
.. _`Alexandr Korsak`: https://github.com/oivoodoo
Fix changelog
2018-07-04 08:50:39 +00:00
.. _`Saif Hakim`: https://github.com/saifelse
Updated the changelog with the bug fix description
2018-07-06 16:42:53 +00:00
.. _`Artur Balabanov`: https://github.com/arturbalabanov
Changelog.
2018-07-20 01:24:35 +00:00
.. _`Kenny Do`: https://github.com/kennydo
Respect \pset pager on expected behavior "\pset pager" has three possible values: "always", "on", and "off". pgcli previously treated all non-"off" values as "always". This change implements the expected behavior, which is to use the pager when the output is larger than the terminal height (See \pset pager in https://www.postgresql.org/docs/9.2/static/app-psql.html). Pgcli adds to this by also using the pager when the output is wider than the terminal width. Fixes #813
2018-05-15 17:42:21 +00:00
.. _`Max Rothman`: https://github.com/maxrothman
Bugfix for #938: load named queries from provided config file
2018-10-31 17:42:27 +00:00
.. _`Daniel Egger`: https://github.com/DanEEStar
Contrib guide improv (#946) improved DEVELOP docs
2018-11-13 22:01:47 +00:00
.. _`Ignacio Campabadal`: https://github.com/igncampa
Determine hstore OID from the system view (#992) Avoid error message on the server side if hstore extension is not installed in the current database. Issue: https://github.com/dbcli/pgcli/issues/991
2019-01-22 00:00:25 +00:00
.. _`Mikhail Elovskikh`: https://github.com/wronglink
.. _`Marcin Cieślak`: https://github.com/saper
Changelog.
2019-03-05 00:16:47 +00:00
.. _`Scott Brenstuhl`: https://github.com/808sAndBR
.. _`easteregg`: https://github.com/verfriemelt-dot-org
Allow escape to switch to vi navigation mode (#1039)
2019-04-13 20:22:03 +00:00
.. _`Nathan Verzemnieks`: https://github.com/njvrzm
More intelligent dsn format (#1045) * Psycopg2 already has a method to format a dsn. We should use it. Fix for #1043. * Changelog. * pep8.
2019-04-28 22:06:01 +00:00
.. _`raylu`: https://github.com/raylu
lazy load keyring. (#1046) fix issue: https://github.com/dbcli/pgcli/issues/1041
2019-05-01 15:53:55 +00:00
.. _`Zhaolong Zhu`: https://github.com/zzl0
Update changelog.
2019-05-06 14:29:48 +00:00
.. _`Xavier Francisco`: https://github.com/Qu4tro
Merge branch 'master' into pr1047
2019-05-06 18:11:47 +00:00
.. _`VVelox`: https://github.com/VVelox
Allow psycopg2 up to 2.8.2 (#1060) * Allow psycopg2 up to 2.8.2 This fixes the issue with pgcli not working on Arch Linux, since the package `python2-psycopg2` is already on 2.8.2. * Added name to 'AUTHORS' and contribution to 'changelog.rst' referring to #2de6266 * Allow for newer versions of psycopg2 to be used
2019-05-30 04:14:32 +00:00
.. _`Telmo "Trooper"`: https://github.com/telmotrooper
README.rst: tidy up redundant instructions (#1061) * README.rst: tidy up redundant instructions Remove the README section which detailed how to force `psycopg2` 2.7 dependency installation from source rather than binary. `psycopg2` 2.7 would automatically favour installation from binary. A bug affecting some users made it desirable to have the option to install from source instead. The README detailed how to do this using pip's `--no-binary` option (nice!). `psycopg2` 2.8 has now split the binary and source dependencies into different packages with different names (source: [psycopg2 docs](http://initd.org/psycopg/docs/install.html#change-in-binary-packages-between-psycopg-2-7-and-2-8)) which makes the `--no-binary` instructions redundant. To specify source/binary you now need to explicitly specify the desired package. As of #1060, installing `pgcli` from pip will result in the installation of `psycopg2` 2.8 from source. * README: additional instructions for psycopg2 2.7 users Anyone limited to psycopg2 2.7 may still encounter some known issues when installing from binary. Add a link to the README to acknowledge this, and help those users install it from source. * Update changelog.rst * Update AUTHORS * Update changelog
2019-05-30 17:03:47 +00:00
.. _`Alexander Zawadzki`: https://github.com/zadacka
Issue 1019 stacktrace on empty query (#1078) * Added changes to skip empty queries Empty queries consist of one or more semicolons * Reformatted with black * Added contribution to changelog and name to AUTHORS * Black.
2019-07-13 00:24:39 +00:00
.. _`Sebastian Janko`: https://github.com/sebojanko
Add key bindings to consistently move up and down in history (#1084)
2019-07-29 20:00:33 +00:00
.. _`Pedro Ferrari`: https://github.com/petobens
Add my name to changelog.
2020-01-02 23:50:34 +00:00
.. _`BrownShibaDog`: https://github.com/BrownShibaDog
Fix warning raised for using `is not` to compare string literal (#1139) Using `is not` for comparing string literals raises warning that != should be used. Fixes #1138
2020-01-15 04:56:07 +00:00
.. _`thegeorgeous`: https://github.com/thegeorgeous
Drop Python 3.4 support (#1141) * remove python3.4 support. Python 3.4 has reached end-of-life. https://www.python.org/downloads/release/python-340/ * drop maximun version of pytest * update changelog * add laixintao to contributors, delete py34 from tox
2020-01-16 06:45:16 +00:00
.. _`laixintao`: https://github.com/laixintao
Add name
2020-05-26 18:00:05 +00:00
.. _`anthonydb`: https://github.com/anthonydb
add explain visualizer (#1279) * add explain visualizer * format files * remove humanize dependency * disable by default * add explain visualizer * run black
2022-04-04 02:20:02 +00:00
.. _`Daniel Kukula`: https://github.com/dkuku