summaryrefslogtreecommitdiffstats
AgeCommit message (Collapse)Author
2023-11-16___ wip: smaller matrix, faster runs (and failures)dbaty/run_tests_on_windowsDamien Baty
2023-11-16ci: Run tests on Windows in GitHub ActionDamien Baty
2023-11-08Fix changelog date (#1438)Hollis Wu
* Fix changelog date * Add my name to authors
2023-11-06pgclirc: Clarify description of `destructive_warning_restarts_connection` ↵Damien Baty
option (#1437)
2023-10-30Releasing version 4.0.1v4.0.1Irina Truong
2023-10-30Release the pendulum unbump. (#1435)Irina Truong
2023-10-29downgrade pendulum to released version (#1434)Dick Marinus
* downgrade pendulum to released version * install beta version of pendulum for 3.12
2023-10-27Fix readme.Irina Truong
2023-10-27Releasing version 4.0.0v4.0.0Irina Truong
2023-10-27Update changelog before release. (#1432)Irina Truong
2023-10-18confirm_destructive_query: Use confirm rather than prompt (#1410)Sharon Yogev
* confirm_destructive_query: Use confirm rather than prompt * Fix tests
2023-10-12fixed #1403, improved comment handling (#1404)ERYoung11
* fixed #1403, improved comment handling * black + hooks + changelog --------- Co-authored-by: Irina Truong <i.chernyavska@gmail.com>
2023-10-11Drop python 3.7, add 3.12 (#1426)Irina Truong
* 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-07runs test on main branch as well. (#1429)laixintao
* runs test on main branch as well. reasons: - tests passed on PR branches do not mean they will pass on main branch, for e.g. alice changed A in branch-a, bob changed B in branch-b, both tests passed and no conflict, but after merged to main, a bug occurs. - wanna fix the badge in main branch ;D * change the badge status to main branch only.
2023-10-06Merge pull request #1425 from dbcli/j-bennet/update-blackAmjith Ramanujam
Update black
2023-10-06Go back to black 23.3.0 which supports 3.7Irina Truong
2023-10-06Newer black requires 3.8.Irina Truong
2023-10-06Update black.Irina Truong
2023-10-06Allow defining a json file with preferred aliases (#1382)Rob Berry
* 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-06Added \echo & \qecho for Issue #1335 (#1371)ERYoung11
* Added \echo & \qecho for Issue #1335 * black + changelog updates * trying to re-kick build process
2023-09-26Merge pull request #1419 from dbcli/j-bennet/maintainer-contact-infoAmjith Ramanujam
Add maintainer contact info to readme
2023-09-26Add maintainer contact info to readme.Irina Truong
2023-09-26Ask for confirmation to quit cli if a transaction is ongoing. (#1400)Damien Baty
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-12For Python >= 3.11 directly use packaging to compare package versions (#1416)blag
* For Python >= 3.11 directly use packaging to compare package versions * Improve prompt-toolkit check to test for feature explicitly
2023-06-23Fix sql-insert format emits NULL as 'None' (#1409)astroshot
* 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-05-25Update pyev.py (#1406)Daniel Kukula
fix typos
2023-03-18Merge pull request #1399 from dbaty/dbaty/remove_python2_supportAmjith Ramanujam
Remove leftovers of Python 2 support
2023-03-18Apply black (version 23.1.0)Damien Baty
2023-03-18Remove leftovers of Python 2 supportDamien Baty
2023-03-17Merge pull request #1397 from ↵Amjith Ramanujam
dbaty/dbaty/require_transaction_for_destructive_statement feature: Add config option to require a transaction for destructive statements
2023-03-08lint: Remove unused variables and imported functionsDamien Baty
2023-03-08Add config option to require a transaction for destructive statementsDamien Baty
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-02-27fix explain output when running with auto-vertical-output or max_width (#1396)Andy Schoenberger
2023-02-27add comment to pgclirc pager section on default LESS (#1395)Andy Schoenberger
2023-01-03Add config option to always run with a single connection (#1386)Andy Schoenberger
Co-authored-by: Irina Truong <i.chernyavska@gmail.com>
2023-01-02Merge pull request #1390 from dbcli/j-bennet/1373-fix-dsnAmjith Ramanujam
Fix connecting with dsn.
2023-01-02Python -m py.test doesn't work anymore.Irina Truong
2023-01-02Changelog.Irina Truong
2023-01-02Fix connecting with dsn.Irina Truong
2022-11-21fix psycopg.sql.Identifier in \ev handling (#1384)Andy Schoenberger
2022-11-17Add config option to not automatically restart connection on destructive ↵Andy Schoenberger
warning abort; defaults to not restarting. (#1379)
2022-11-11add python 3.11 support (#1356)Dick Marinus
* add python 3.11 support * use beta version * Python 11 is available. Co-authored-by: Irina Truong <i.chernyavska@gmail.com>
2022-11-11Add config option to not automatically retry connections with operational ↵Andy Schoenberger
errors (#1380)
2022-11-11Add CodeQL workflow for GitHub code scanning (#1381)lgtm-com[bot]
Co-authored-by: LGTM Migrator <lgtm-migrator@users.noreply.github.com>
2022-10-27magic: use pgcli.connect_uri instead of connect (#1375)Anna Glasgall
This makes %pgcli work even if you use non-password (e.g. TLS cert) authentication
2022-10-13Changed destructive_warning to take a list of destructive commands (#1328)Rodrigo Neri (Rigo)
* 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-09-15Releasing version 3.5.0v3.5.0Irina Truong
2022-09-15Changelog update to release 3.5.0. (#1369)Irina Truong
2022-09-14Feature: Add new formatter to export data to sql like mycli (#1366)astroshot
* 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-14Merge pull request #1367 from dbcli/j-bennet/1360-esc-enter-safe-multiline-modeAmjith Ramanujam
Esc + Enter should sumbit the query in safe multiline mode.