Subject: Re: API for babel.postgresql.org
To: Pavlo Golub <pavlo.golub@cybertec.at>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>,
 pgsql-translators@postgresql.org
References: <73450841-93b9-4372-a879-e43d9b60c2a1@email.android.com>
From: Alexander Lakhin <exclusion@gmail.com>
Message-ID: <b18654e1-b38f-310e-03ee-a75a47cc3537@gmail.com>
Date: Sat, 8 Dec 2018 11:00:06 +0300
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: <73450841-93b9-4372-a879-e43d9b60c2a1@email.android.com>
Content-Type: multipart/alternative;
 boundary="------------5BE95AD73D19DF58565CA1E5"
Content-Language: en-US
Precedence: bulk

This is a multi-part message in MIME format.
--------------5BE95AD73D19DF58565CA1E5
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit

Hello Pavlo,

08.12.2018 10:42, Pavlo Golub wrote:
>
>     What kind of functionality are you hoping such an API would provide?
>
> Dumb and simple. List of languages, list of resources, links to .pot
> and .po files.
>
> Example:
> GET /resources
> GET /languages
> GET /psql.pot
> GET /pt_BR/postgres.po
>
> If it's complicated never mind. I can probably parse html then
I use a bash script to collect all pot's from branches in git:
extract_pot() {
    local version=$1
    local gitdir=$2
    local branch=$3
    mkdir $POTD/$version
    (
    cd $gitdir
    git clean -dfx
    git reset --hard HEAD
    git checkout $branch
    git rebase
    ./configure --enable-nls >/dev/null
    make init-po
    for pot in `find . -name '*.pot'`; do
        cp $pot $POTD/$version/
        echo $pot
    done
    )
}


For me the most inconvenient part was to support several versions of .po
and synchronize between them.
So I use pology (posummit) to get united .po's, which looks like:
#. +> 11 10 9.6 9.5
#: pg_config.c:153
#, c-format
msgid "%s: could not find own program executable\n"
msgstr "%s: не удалось найти свой исполняемый файл\n"

#. +> 11 10 9.6 9.5
#: pg_config.c:180
#, c-format
msgid "%s: invalid argument: %s\n"
msgstr "%s: неверный аргумент: %s\n"

#. +> 9.5
#: pg_config.c:243 pg_config.c:259 pg_config.c:275 pg_config.c:291
#: pg_config.c:307 pg_config.c:323 pg_config.c:339 pg_config.c:355
#: pg_config.c:371
#, c-format
msgid "not recorded\n"
msgstr "не сохранено\n"

I can share my scripts if it can be useful for you.

Best regards,
Alexander

--------------5BE95AD73D19DF58565CA1E5
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">Hello Pavlo,<br>
      <br>
      08.12.2018 10:42, Pavlo Golub wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:73450841-93b9-4372-a879-e43d9b60c2a1@email.android.com">
      <meta http-equiv="content-type" content="text/html; charset=utf-8">
      <div dir="auto">
        <div><br>
          <div class="gmail_extra">
            <div class="gmail_quote">
              <blockquote class="quote" style="margin:0 0 0
                .8ex;border-left:1px #ccc solid;padding-left:1ex">
                <p dir="ltr">What kind of functionality are you hoping
                  such an API would provide?<br>
                </p>
              </blockquote>
            </div>
          </div>
        </div>
        <div dir="auto">Dumb and simple. List of languages, list of
          resources, links to .pot and .po files.</div>
        <div dir="auto"><br>
        </div>
        <div dir="auto">Example:</div>
        <div dir="auto">GET /resources</div>
        <div dir="auto">GET /languages</div>
        <div dir="auto">GET /psql.pot</div>
        <div dir="auto">GET /pt_BR/postgres.po</div>
        <div dir="auto"><br>
        </div>
        <div dir="auto">If it's complicated never mind. I can probably
          parse html then</div>
      </div>
    </blockquote>
    I use a bash script to collect all pot's from branches in git:<br>
    extract_pot() {<br>
        local version=$1<br>
        local gitdir=$2<br>
        local branch=$3<br>
        mkdir $POTD/$version<br>
        (<br>
        cd $gitdir<br>
        git clean -dfx<br>
        git reset --hard HEAD<br>
        git checkout $branch<br>
        git rebase<br>
        ./configure --enable-nls &gt;/dev/null<br>
        make init-po<br>
        for pot in `find . -name '*.pot'`; do<br>
            cp $pot $POTD/$version/<br>
            echo $pot<br>
        done<br>
        )<br>
    }<br>
    <br>
    <br>
    For me the most inconvenient part was to support several versions of
    .po and synchronize between them.<br>
    So I use pology (posummit) to get united .po's, which looks like:<br>
    <tt>#. +&gt; 11 10 9.6 9.5</tt><tt><br>
    </tt><tt>#: pg_config.c:153</tt><tt><br>
    </tt><tt>#, c-format</tt><tt><br>
    </tt><tt>msgid "%s: could not find own program executable\n"</tt><tt><br>
    </tt><tt>msgstr "%s: не удалось найти свой исполняемый файл\n"</tt><tt><br>
    </tt><tt><br>
    </tt><tt>#. +&gt; 11 10 9.6 9.5</tt><tt><br>
    </tt><tt>#: pg_config.c:180</tt><tt><br>
    </tt><tt>#, c-format</tt><tt><br>
    </tt><tt>msgid "%s: invalid argument: %s\n"</tt><tt><br>
    </tt><tt>msgstr "%s: неверный аргумент: %s\n"</tt><tt><br>
    </tt><tt><br>
    </tt><tt>#. +&gt; 9.5</tt><tt><br>
    </tt><tt>#: pg_config.c:243 pg_config.c:259 pg_config.c:275
      pg_config.c:291</tt><tt><br>
    </tt><tt>#: pg_config.c:307 pg_config.c:323 pg_config.c:339
      pg_config.c:355</tt><tt><br>
    </tt><tt>#: pg_config.c:371</tt><tt><br>
    </tt><tt>#, c-format</tt><tt><br>
    </tt><tt>msgid "not recorded\n"</tt><tt><br>
    </tt><tt>msgstr "не сохранено\n"</tt><tt><br>
    </tt><br>
    I can share my scripts if it can be useful for you.<br>
    <br>
    Best regards,<br>
    Alexander<br>
  </body>
</html>

--------------5BE95AD73D19DF58565CA1E5--