Thanks, patch applied. On Fri, Jan 19, 2018 at 12:56 PM, Joao De Almeida Pereira < jdealmeidapere...@pivotal.io> wrote:
> Hello Hackers, > I am updating this patch as we found out that the SQL tab was not showing > the functions properly, and we corrected that in the new update patch in > this email > > Thanks > Joao > > On Wed, Jan 17, 2018 at 12:25 PM, Joao De Almeida Pereira < > jdealmeidapere...@pivotal.io> wrote: > >> >> @Dave I sent the new patch with correction in the previous email. Can you >> review it and let us know if it is ok? >> >> >> On Fri, Jan 12, 2018 at 12:48 PM, Joao De Almeida Pereira < >> jdealmeidapere...@pivotal.io> wrote: >> >>> Thanks for the help Murtuza >>> >>> Attached you can find the revisited patch that now displayed all the >>> information about functions in GreenPlum >>> >>> Thanks >>> Joao >>> >>> On Fri, Jan 12, 2018 at 9:51 AM, Murtuza Zabuawala < >>> murtuza.zabuaw...@enterprisedb.com> wrote: >>> >>>> Hi, >>>> >>>> We create collection of existing parameters using function >>>> 'def _format_arguments_from_db(...)' in a file >>>> '../pgadmin4/web/pgadmin/browser/server_groups/servers/datab >>>> ases/schemas/functions/__init__.py' @ line 454, and on client side we >>>> have backbone collection mapped with same id on line 304 (function.js) >>>> >>>> >>>> >>>> -- >>>> Regards, >>>> Murtuza Zabuawala >>>> EnterpriseDB: http://www.enterprisedb.com >>>> The Enterprise PostgreSQL Company >>>> >>>> >>>> On Fri, Jan 12, 2018 at 8:10 PM, Joao De Almeida Pereira < >>>> jdealmeidapere...@pivotal.io> wrote: >>>> >>>>> Hello, >>>>> I changed that function to make the retrieval quicker because the >>>>> return type of all the types in the database for GreenPlum can be quite >>>>> big. >>>>> >>>>> Nevertheless the "Data Types" in the front end do not get filled up >>>>> with the values. >>>>> >>>>> Where is the Javascript code that does the mapping between the call of >>>>> get_types and that table in the screenshot? >>>>> >>>>> Thanks >>>>> Joao >>>>> >>>>> >>>>> On Fri, Jan 12, 2018 at 12:37 AM, Murtuza Zabuawala < >>>>> murtuza.zabuaw...@enterprisedb.com> wrote: >>>>> >>>>>> Hi Joao, >>>>>> >>>>>> We have written common function 'def get_types(...)' in a class >>>>>> called 'DataTypeReader' to fetch datatypes in a file >>>>>> '../pgadmin4/web/pgadmin/browser/server_groups/servers/databases/schemas/utils.py' >>>>>> and we have inherited from DataTypeReader in Function module's >>>>>> 'FunctionView' class to use it check line no. 120 >>>>>> >>>>>> -- >>>>>> Regards, >>>>>> Murtuza Zabuawala >>>>>> EnterpriseDB: http://www.enterprisedb.com >>>>>> The Enterprise PostgreSQL Company >>>>>> >>>>>> >>>>>> On Thu, Jan 11, 2018 at 9:31 PM, Joao De Almeida Pereira < >>>>>> jdealmeidapere...@pivotal.io> wrote: >>>>>> >>>>>>> Hello Hackers, >>>>>>> We had some requests from GreenPlum users to display the functions >>>>>>> node again. >>>>>>> This patch reintroduces functions as a node underneath the Schemas. >>>>>>> >>>>>>> >>>>>>> Unfortunately this patch is not final because I could not find the >>>>>>> place where the Data Type is populated from. (See next image)[image: >>>>>>> Inline image 1] >>>>>>> >>>>>>> Can anyone explain me how these types get populated? >>>>>>> >>>>>>> >>>>>>> >>>>>>> Thanks >>>>>>> Joao >>>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >> > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company