thanks for the description. i figured it as far as that:
you need in postgresql (this is tested only from zope with zsql method,
since some other things don't work in the ZBabel Produkt with
select distinct Phrases.*
WHERE md5Hash not in
from Phrases as c, Phrases as d
where c.md5Hash = d.md5Hash and c.lang <> d.lang and c.lang='<dtml-var
and lang <>'<dtml-var srcLang>'
insert into Phrases (phrase_id,lang,md5Hash,renderPath,renderText)
<dtml-sqlvar lang type=nb>,
<dtml-sqlvar md5Hash type=nb>,
<dtml-sqlvar renderPath type=nb>,
<dtml-sqlvar renderText type=nb>
all other sqlFunctions seam to work (out of zope ZSQL method)
i attache the ZBabel.sql for postgres.
the examples are handgenerated so the hashes are fake.
until now this just fakes the ability of ZBabel on Postgres on a ZSQL
Method level for testing purposes.
I get errors:
when i first want to view a page with the <dtml-babel src=uk dst=de>
error value: error: attribute 'phrases_phrase_id_seq' not found
probably that helps anybody
> | What does the whole thing do anyway?
> Finds all the phrases that don't have a translation for the language
> selected. It's hard to find things that don't exist in databases without
> nested selects which MySQL did not have at the time.
> MySQL was chosen precisely because it is restricted, and is basically the
> lowest common denominator when it comes to SQL.
> I do recall however, that postgres only implements INNER and OUTER joins
> although I don't know the status of the JOIN stuff in postgres at this time.
> | Has anybody ported ZBabel already?
> Someone was going to send me patches for postgres, but, I never received
> I'll happily integrate patches, although, automatically selecting the
> right query based on database type will be required so that several releases
> aren't required. I don't think that that's a hard thing to achieve.
soli-con Engineering Zanger
Dipl.-Ing. (FH) Olaf Marc Zanger
3013 Bern / Switzerland
Fon: +41-31-332 9782
Mob: +41-76-572 9782
org:soli-con Engineering Zanger
note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A