Re: [pgadmin4] Creating a new Node in ACI Tree

Hi Joao,

On Fri, Feb 23, 2018 at 11:23 PM, Joao De Almeida Pereira <jdealmeidapereira@pivotal.io> wrote:

Hello Murtuza,

Do we have to have that present in python in order for it to work in the javascript?

 

​No, Just create a node modal in JS with sample fields like Name/Comment etc.

There are two flags in node modal, 

one of which responsible for displaying reversed engineered sql (flag: hasSQL)

​, other is responsible for displaying Dependancies and Dependants of the node on their respective Panel (flag: 

hasDepends)

-- Murtuza

​

 

I am asking this because we didn't saw any request to the backend trying to fetch this information.

Thanks

Joao

On Fri, Feb 23, 2018 at 11:12 AM Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote:

Hi Joao,

Just like 'nodes' & 'children' operation, You have to implement several other methods,

'obj' - To create, update, delete & properties for External Tables

Ref: ../foreign_tables/__init__.py: 193

Which will call associated methods, def create(..), def update(...), def delete(...) & def properties(...)

'sql' - Displays reversed engineered sql on SQL panel

Which will call to method def sql(...) method

'msql' - Displays reversed engineered sql on Create/Properties dialog

Which will call to method def msql(...) method

'stats' -Displays object statistics sql on Statistics panel

Which will call to method def statistics(...) method

'dependency' - Displays object dependencies on Dependencies panel

Which will call to method def dependencies(...) method

'dependent' - Displays object dependents on SQL panel

Which will call to method def dependents(...) method

Hope that helps.

--

Regards,

Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Fri, Feb 23, 2018 at 9:08 PM, Joao De Almeida Pereira <jdealmeidapereira@pivotal.io> wrote:

Hello Hackers,

Need some pointers while creating new node on ACI Tree. 

In GreenPlum there is a concept of External Tables that are more or less similar to Foreign Wrappers, but different. So we started implementing a new node for it.

We copied the Foreign Wrappers node and started it playing with it. The current status:

We can see the External Tables node, when we open it we see the External Tables.

The problem that we are facing now is when we select a table and then press the tabs 'SQL' or Properties nothing happens. What do we need to do in order for this to work?

Maybe the choice of foreign Wrappers was not the best to start off, but we would appreciate some help to make this work.

Attached you can find the code that I currently have.

Thanks

Joao