MIME-Version: 1.0
References: 
 <CAHBw7oT+50c1+Ns_Yy-x2S6r49Y_iqz_G22NdheWpgzqAjfLHw@mail.gmail.com>
In-Reply-To: 
 <CAHBw7oT+50c1+Ns_Yy-x2S6r49Y_iqz_G22NdheWpgzqAjfLHw@mail.gmail.com>
From: Khushboo Vashi <khushboo.vashi@enterprisedb.com>
Date: Mon, 2 Mar 2020 09:10:56 +0530
Message-ID: 
 <CAFOhELdSHMHicD=Rj2b8mWFgxZNXkWxnp3XY00nupQveyRTg7w@mail.gmail.com>
Subject: Re: 'render_template' server_type/version resolution
To: Radoslaw Garbacz <radoslaw.garbacz@xtremedatainc.com>
Cc: pgadmin-hackers <pgadmin-hackers@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e4001e059fd6f4d3"
Precedence: bulk

--000000000000e4001e059fd6f4d3
Content-Type: text/plain; charset="UTF-8"

Hi,

On Sat, Feb 29, 2020 at 1:56 AM Radoslaw Garbacz <
radoslaw.garbacz@xtremedatainc.com> wrote:

> Hi,
>
> I have a question regarding templates resolution from subdirectories based
> on server version (and type) for 'SQL' templates (e.g. for
> "get_encodinds.sql" in
> "web/pgadmin/browser/server_groups/servers/databases/").
>
> I created a subdirectory matching my pg like db version:
> "web/pgadmin/browser/server_groups/servers/databases/templates/databases/sql/8.1_plus".
> I have also a specific subdir for "server_type_version" (.../dbx_8.1_plus),
> however the server does not seem to be able to find it, and always defaults
> to ".../templates/databases/sql/default".
>
> pgAdmin does not support PostgreSQL absolute versions. However if you want
to make local changes in the template loader mechanism, check the <pgAdmin
Source Dir>/web/pgadmin/utils/versioned_template_loader.py  file to
understand the template loader mapping logic.

Thanks,
Khushboo

> When debugging, I get "self.template_path" as "databases/sql/#80102#"
> (server_type: "dbx", however it's not used for "get_encodings").
>
> So, I'd be grateful to hear how to make it find my modified
> "get_encodings.sql"?
>
BTW: Is it OK if the directory is a link?
>
> --
> Best Regards,
>
> Radoslaw Garbacz
> XtremeData Incorporated
>

--000000000000e4001e059fd6f4d3
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Hi,</div><br><div class=3D"gmail_quote"><=
div dir=3D"ltr" class=3D"gmail_attr">On Sat, Feb 29, 2020 at 1:56 AM Radosl=
aw Garbacz &lt;<a href=3D"mailto:radoslaw.garbacz@xtremedatainc.com">radosl=
aw.garbacz@xtremedatainc.com</a>&gt; wrote:<br></div><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204=
,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"l=
tr"><div dir=3D"ltr"><div dir=3D"ltr"><div>Hi,</div><div><br></div><div>I h=
ave a question regarding templates resolution from subdirectories based on =
server version (and type) for &#39;SQL&#39; templates (e.g. for &quot;get_e=
ncodinds.sql&quot; in &quot;web/pgadmin/browser/server_groups/servers/datab=
ases/&quot;).</div><div><br></div><div>I created a subdirectory matching my=
 pg like db version: &quot;web/pgadmin/browser/server_groups/servers/databa=
ses/templates/databases/sql/8.1_plus&quot;. I have also a specific subdir f=
or &quot;server_type_version&quot; (.../dbx_8.1_plus), however the server d=
oes not seem to be able to find it, and always defaults to &quot;.../templa=
tes/databases/sql/default&quot;.</div><div><br></div></div></div></div></di=
v></div></blockquote><div>pgAdmin does not support PostgreSQL absolute vers=
ions. However if you want to make local changes in the template loader mech=
anism,<span style=3D"font-family:arial,sans-serif">=C2=A0check the</span><s=
pan style=3D"font-family:arial,sans-serif;color:rgb(0,0,0)">=C2=A0</span><s=
pan style=3D"font-family:arial,sans-serif">&lt;pgAdmin Source Dir&gt;/web/p=
gadmin/utils/versioned_template_loader.py=C2=A0 file to understand the temp=
late loader mapping logic.</span></div><div><span style=3D"font-family:aria=
l,sans-serif"><br></span></div><div><span style=3D"font-family:arial,sans-s=
erif">Thanks,</span></div><div><span style=3D"font-family:arial,sans-serif"=
>Khushboo</span></div><blockquote class=3D"gmail_quote" style=3D"margin:0px=
 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><di=
v dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=
=3D"ltr"><div>When debugging, I get &quot;self.template_path&quot; as &quot=
;databases/sql/#80102#&quot; (server_type: &quot;dbx&quot;, however it&#39;=
s not used for &quot;get_encodings&quot;).<br></div><div><br></div><div>So,=
 I&#39;d be grateful to hear how to make it find my modified &quot;get_enco=
dings.sql&quot;?=C2=A0</div></div></div></div></div></div></blockquote><blo=
ckquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left=
:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"=
ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div>BTW: Is it OK =
if the directory is a link?</div><div></div><div></div><div><br>-- <br><div=
 dir=3D"ltr"><div dir=3D"ltr"><div><div dir=3D"ltr"><div>Best Regards,<br><=
br>Radoslaw Garbacz<br></div>XtremeData Incorporated<br></div></div></div><=
/div></div></div></div></div></div></div>
</blockquote></div></div>

--000000000000e4001e059fd6f4d3--