Обсуждение: [pgadmin-hackers] [question]
Hello Hackers,
/browser/server/children/1/3
We are working with the tree and are looking into the paths that are used to get tree data from the Python backend. We noticed that the path has a component that has to be numeric, but it appears that what this number is, is irrelevant. Here's an example:
/browser/server/children/1/3
So in this case, the '1' seems to be required and appears to represent the server-group, but we're not sure. It appears that the response is the same no matter what number is passed in. Is there any behavior in the application that depends on that number?
Thanks,
Sarah & George
Hi Sarah,
Each number represent mapping of id for the node.
For example in your case,
/browser/<node>/children/< server-group-id>/<server-id>
/browser/server/children/1/3
Here <node> is the type of object (eg: server-group, server, database, table etc) and <server-id> will be the column 'id' of server table(pgadmin4.db), I guess you have multiple entries of a same server with different name in sqltite database.
/browser/<node>/children/< server-group-id>/<server-id>/< database-id>
/browser/database/children/1/ 1/12641
Here < database-id> is OID of connected database.
We follow this same URL object mapping almost everywhere in pgAdmin4.
--
Regards,
On Wed, Apr 12, 2017 at 3:39 AM, Sarah McAlear <smcalear@pivotal.io> wrote:
Hello Hackers,We are working with the tree and are looking into the paths that are used to get tree data from the Python backend. We noticed that the path has a component that has to be numeric, but it appears that what this number is, is irrelevant. Here's an example:
/browser/server/children/1/3So in this case, the '1' seems to be required and appears to represent the server-group, but we're not sure. It appears that the response is the same no matter what number is passed in. Is there any behavior in the application that depends on that number?Thanks,Sarah & George
Hi Murtuza,
Thanks for your response! There is just one little piece of this URL that we can't seem to figure out what it does. The <server-group-id> doesn't seem to change the result of the request. Meaning that if we were to input
browser/server/children/1/3
browser/server/children/684635135/3
browser/server/children/2/3
we would get the same result every time. So while we thought that this was the <server-group-id>, it doesn't seem to matter? So we were wondering if this <server-group-id> is used any other way? Or could it be removed?
Thank you!
Sarah
Sarah
On Wed, Apr 12, 2017 at 9:33 AM, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote:
Hi Sarah,Each number represent mapping of id for the node.For example in your case,/browser/<node>/children/<server-group-id>/<server-id> /browser/server/children/1/3Here <node> is the type of object (eg: server-group, server, database, table etc) and <server-id> will be the column 'id' of server table(pgadmin4.db), I guess you have multiple entries of a same server with different name in sqltite database./browser/<node>/children/<server-group-id>/<server-id>/<data base-id> /browser/database/children/1/1/12641 Here <database-id> is OID of connected database.We follow this same URL object mapping almost everywhere in pgAdmin4.--Regards,On Wed, Apr 12, 2017 at 3:39 AM, Sarah McAlear <smcalear@pivotal.io> wrote:Hello Hackers,We are working with the tree and are looking into the paths that are used to get tree data from the Python backend. We noticed that the path has a component that has to be numeric, but it appears that what this number is, is irrelevant. Here's an example:
/browser/server/children/1/3So in this case, the '1' seems to be required and appears to represent the server-group, but we're not sure. It appears that the response is the same no matter what number is passed in. Is there any behavior in the application that depends on that number?Thanks,Sarah & George
<server-group-id> is just to manage servers in groups in browser tree that the main purpose, <server-id> is unique regardless of server-group id that's why you are getting proper response.
--
Regards,
On Wed, Apr 12, 2017 at 7:21 PM, Sarah McAlear <smcalear@pivotal.io> wrote:
Hi Murtuza,Thanks for your response! There is just one little piece of this URL that we can't seem to figure out what it does. The <server-group-id> doesn't seem to change the result of the request. Meaning that if we were to inputbrowser/server/children/1/3browser/server/children/684635135/3 browser/server/children/2/3we would get the same result every time. So while we thought that this was the <server-group-id>, it doesn't seem to matter? So we were wondering if this <server-group-id> is used any other way? Or could it be removed?Thank you!
SarahOn Wed, Apr 12, 2017 at 9:33 AM, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote: Hi Sarah,Each number represent mapping of id for the node.For example in your case,/browser/<node>/children/<server-group-id>/<server-id> /browser/server/children/1/3Here <node> is the type of object (eg: server-group, server, database, table etc) and <server-id> will be the column 'id' of server table(pgadmin4.db), I guess you have multiple entries of a same server with different name in sqltite database./browser/<node>/children/<server-group-id>/<server-id>/<data base-id> /browser/database/children/1/1/12641 Here <database-id> is OID of connected database.We follow this same URL object mapping almost everywhere in pgAdmin4.--Regards,On Wed, Apr 12, 2017 at 3:39 AM, Sarah McAlear <smcalear@pivotal.io> wrote:Hello Hackers,We are working with the tree and are looking into the paths that are used to get tree data from the Python backend. We noticed that the path has a component that has to be numeric, but it appears that what this number is, is irrelevant. Here's an example:
/browser/server/children/1/3So in this case, the '1' seems to be required and appears to represent the server-group, but we're not sure. It appears that the response is the same no matter what number is passed in. Is there any behavior in the application that depends on that number?Thanks,Sarah & George