public inbox for [email protected]  
help / color / mirror / Atom feed
From: Dave Page <[email protected]>
To: [email protected]
Subject: pgAdmin 4 commit: Fix function signature generation for reverse enginee
Date: Wed, 14 Sep 2016 09:59:14 +0000
Message-ID: <[email protected]> (raw)
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgadmin-hackers>

Fix function signature generation for reverse engineered SQL. Fixes #1674

1) In SQL pane, the signature in comments had arguments with name and type, Now it will show arguments with type only.

2) There is no indent+newline between arguments (there isn't even a space). - Fixed

3) The default value for the last argument is omitted. - Fixed
Last argument is omitted because the value for the last argument we got from table is empty.
Now we form function signature in the get_definition.sql using 'pg_catalog.pg_get_function_arguments' method.

Above changes will reflect in Functions, Procedures & Trigger function Nodes.

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=f2469d113c97b8d2f434af54fa76d0195af2f...
Author: Surinder Kumar <[email protected]>

Modified Files
--------------
.../databases/schemas/functions/__init__.py        | 61 +++++++++++++++++-----
.../templates/function/pg/sql/9.1_plus/create.sql  |  4 ++
.../function/pg/sql/9.1_plus/get_definition.sql    |  3 +-
.../templates/function/pg/sql/9.2_plus/create.sql  |  4 ++
.../function/pg/sql/9.2_plus/get_definition.sql    |  3 +-
.../templates/function/pg/sql/9.5_plus/create.sql  |  6 ++-
.../function/pg/sql/9.5_plus/get_definition.sql    |  3 +-
.../function/ppas/sql/9.1_plus/create.sql          |  4 ++
.../function/ppas/sql/9.1_plus/get_definition.sql  |  3 +-
.../function/ppas/sql/9.2_plus/create.sql          |  4 ++
.../function/ppas/sql/9.2_plus/get_definition.sql  |  3 +-
.../function/ppas/sql/9.5_plus/create.sql          |  4 ++
.../function/ppas/sql/9.5_plus/get_definition.sql  |  3 +-
.../procedure/ppas/sql/9.1_plus/create.sql         |  7 ++-
.../procedure/ppas/sql/9.1_plus/get_definition.sql |  4 +-
.../procedure/ppas/sql/9.2_plus/create.sql         |  7 ++-
.../procedure/ppas/sql/9.2_plus/get_definition.sql |  4 +-
.../procedure/ppas/sql/9.5_plus/create.sql         |  4 ++
.../procedure/ppas/sql/9.5_plus/get_definition.sql |  4 +-
.../pg/sql/9.1_plus/get_definition.sql             |  3 +-
.../pg/sql/9.2_plus/get_definition.sql             |  3 +-
.../pg/sql/9.5_plus/get_definition.sql             |  3 +-
.../ppas/sql/9.1_plus/get_definition.sql           |  3 +-
.../ppas/sql/9.2_plus/get_definition.sql           |  3 +-
.../ppas/sql/9.5_plus/get_definition.sql           |  3 +-
25 files changed, 120 insertions(+), 33 deletions(-)


-- 
Sent via pgadmin-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: pgAdmin 4 commit: Fix function signature generation for reverse enginee
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox