From 97a1fd6c163b3a3b476ecd286e868bc0e586b8d1 Mon Sep 17 00:00:00 2001 From: Rob Berry Date: Sat, 7 Oct 2023 00:13:28 +0100 Subject: 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 Co-authored-by: Rob B Co-authored-by: Irina Truong --- AUTHORS | 1 + 1 file changed, 1 insertion(+) (limited to 'AUTHORS') diff --git a/AUTHORS b/AUTHORS index 9b24c8f6..a4eac9de 100644 --- a/AUTHORS +++ b/AUTHORS @@ -128,6 +128,7 @@ Contributors: * Andy Schoenberger (andyscho) * Damien Baty (dbaty) * blag + * Rob Berry (rob-b) Creator: -------- -- cgit v1.2.3