Thread: [pgAdmin4][Patch]: RM #3420 Merge latest code of pgcli with pgAdmin4
Hi Hackers
![](http://www.enterprisedb.com/sites/default/files/EDB-logo-4c.png)
I have merged the latest code of "pgcli" used for auto complete feature in pgAdmin4. We haven't merged that code since last 2 years and they have fixed some bugs and also provided some new features:
- Add support for CTE aware auto-completion.
- Handle unrecognized keywords gracefully.
- Support for table-qualifying column suggestions.
- Add additional completion for ALTER keyword.
- Better suggestions when editing functions.
- Added MATERIALIZED VIEW keywords.
- Completions after ORDER BY and DISTINCT now take account of table aliases.
- Include arguments in function suggestions.
- Add missing keyword COLUMN after DROP
I have also added some feature test for auto complete. Attached is the patch please review it.
-- Akshay Joshi
Sr. Software Architect
![](http://www.enterprisedb.com/sites/default/files/EDB-logo-4c.png)
Phone: +91 20-3058-9517
Mobile: +91 976-788-8246
Mobile: +91 976-788-8246
Attachment
Re: [pgAdmin4][Patch]: RM #3420 Merge latest code of pgcli with pgAdmin4
From
Aditya Toshniwal
Date:
Hi,
Did a basic testing. Looks good to me. Test cases run successfully.
On Fri, Aug 24, 2018 at 10:55 AM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Hi HackersI have merged the latest code of "pgcli" used for auto complete feature in pgAdmin4. We haven't merged that code since last 2 years and they have fixed some bugs and also provided some new features:
- Add support for CTE aware auto-completion.
- Handle unrecognized keywords gracefully.
- Support for table-qualifying column suggestions.
- Add additional completion for ALTER keyword.
- Better suggestions when editing functions.
- Added MATERIALIZED VIEW keywords.
- Completions after ORDER BY and DISTINCT now take account of table aliases.
- Include arguments in function suggestions.
- Add missing keyword COLUMN after DROP
I have also added some feature test for auto complete. Attached is the patch please review it.--Akshay JoshiSr. Software ArchitectPhone: +91 20-3058-9517
Mobile: +91 976-788-8246
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB Software Solutions | Pune
"Don't Complain about Heat, Plant a tree"
Re: [pgAdmin4][Patch]: RM #3420 Merge latest code of pgcli with pgAdmin4
From
Aditya Toshniwal
Date:
Hi Akshay,
Attached is the patch to make autocomplete changes python 2.6 compatible.
Please note, this patch should be applied over your patch.
On Mon, Aug 27, 2018 at 2:28 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi,Did a basic testing. Looks good to me. Test cases run successfully.On Fri, Aug 24, 2018 at 10:55 AM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:Hi HackersI have merged the latest code of "pgcli" used for auto complete feature in pgAdmin4. We haven't merged that code since last 2 years and they have fixed some bugs and also provided some new features:
- Add support for CTE aware auto-completion.
- Handle unrecognized keywords gracefully.
- Support for table-qualifying column suggestions.
- Add additional completion for ALTER keyword.
- Better suggestions when editing functions.
- Added MATERIALIZED VIEW keywords.
- Completions after ORDER BY and DISTINCT now take account of table aliases.
- Include arguments in function suggestions.
- Add missing keyword COLUMN after DROP
I have also added some feature test for auto complete. Attached is the patch please review it.--Akshay JoshiSr. Software ArchitectPhone: +91 20-3058-9517
Mobile: +91 976-788-8246--Thanks and Regards,Aditya ToshniwalSoftware Engineer | EnterpriseDB Software Solutions | Pune"Don't Complain about Heat, Plant a tree"
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB Software Solutions | Pune
"Don't Complain about Heat, Plant a tree"
Attachment
Thanks patch applied.
On Mon, Aug 27, 2018 at 4:22 PM, Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi Akshay,Attached is the patch to make autocomplete changes python 2.6 compatible.Please note, this patch should be applied over your patch.On Mon, Aug 27, 2018 at 2:28 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote: Hi,Did a basic testing. Looks good to me. Test cases run successfully.Hi HackersI have merged the latest code of "pgcli" used for auto complete feature in pgAdmin4. We haven't merged that code since last 2 years and they have fixed some bugs and also provided some new features:
- Add support for CTE aware auto-completion.
- Handle unrecognized keywords gracefully.
- Support for table-qualifying column suggestions.
- Add additional completion for ALTER keyword.
- Better suggestions when editing functions.
- Added MATERIALIZED VIEW keywords.
- Completions after ORDER BY and DISTINCT now take account of table aliases.
- Include arguments in function suggestions.
- Add missing keyword COLUMN after DROP
I have also added some feature test for auto complete. Attached is the patch please review it.--Akshay JoshiSr. Software ArchitectPhone: +91 20-3058-9517
Mobile: +91 976-788-8246--Thanks and Regards,Aditya ToshniwalSoftware Engineer | EnterpriseDB Software Solutions | Pune"Don't Complain about Heat, Plant a tree"--Thanks and Regards,Aditya ToshniwalSoftware Engineer | EnterpriseDB Software Solutions | Pune"Don't Complain about Heat, Plant a tree"
Akshay Joshi
Sr. Software Architect
![](http://www.enterprisedb.com/sites/default/files/EDB-logo-4c.png)
Phone: +91 20-3058-9517
Mobile: +91 976-788-8246
Mobile: +91 976-788-8246