Age | Commit message (Collapse) | Author |
|
* Fix changelog date
* Add my name to authors
|
|
|
|
|
|
* downgrade pendulum to released version
* install beta version of pendulum for 3.12
|
|
|
|
* confirm_destructive_query: Use confirm rather than prompt
* Fix tests
|
|
* fixed #1403, improved comment handling
* black + hooks + changelog
---------
Co-authored-by: Irina Truong <i.chernyavska@gmail.com>
|
|
* 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.
|
|
* 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>
|
|
* Added \echo & \qecho for Issue #1335
* black + changelog updates
* trying to re-kick build process
|
|
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.
|
|
* For Python >= 3.11 directly use packaging to compare package versions
* Improve prompt-toolkit check to test for feature explicitly
|
|
* 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 ====
|
|
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.
|
|
|
|
|
|
Co-authored-by: Irina Truong <i.chernyavska@gmail.com>
|
|
|
|
|
|
warning abort; defaults to not restarting. (#1379)
|
|
errors (#1380)
|
|
This makes %pgcli work even if you use non-password (e.g. TLS cert)
authentication
|
|
* 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
|
|
|
|
* 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
|
|
|
|
Show status in csv format.
|
|
|
|
|
|
|
|
|
|
Co-authored-by: Irina Truong <i.chernyavska@gmail.com>
|
|
* 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>
|
|
|
|
|
|
* add explain visualizer
* format files
* remove humanize dependency
* disable by default
* add explain visualizer
* run black
|
|
|
|
|
|
* Prepare to release 3.4.0.
* Add the TBD section.
|
|
* Add initial sshtunnel support
* Force CI to rerun.
* Fix unit test for 3.6.
* Black.
Co-authored-by: Irina Truong <i.chernyavska@gmail.com>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
* Re-run last query with bare `\watch`
* add test
* clean up post test refactor
* lint
* rerun tests
|
|
* Add setting in config to truncate field value.
* Black.
* Changelog.
* Fix tests.
|
|
|
|
* 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.
|