[Koha-bugs] [Bug 13897] Use XML files for installer data

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13897

--- Comment #11 from Bernardo Gonzalez Kriegel <bgkriegel at gmail.com> ---
(In reply to Jonathan Druart from comment #9)
> Hola Bernado,
> I like the idea, but not XML, neither the MySQL only limitation.

Salut Jonathan,
I don't like XML either, nor the MySQL only. 
Just remember that I was thinking in translations, and xml support it's
included right now.
But yaml can be handled.

> Why not write our own stuff, yml-based?

No problem, I'll write a POC patch, but have a question:

Do you think the sequence 
 a) Read YAML > Write $tmp/out.sql > DBIx_::RunSQL->run_sql_file($tmp/out.sql) 
is a valid approach, or
 b) Read YAML > Insert into DB somehow 
it's better?
I suppose b) is slower.

(In reply to Martin Renvoize from comment #10)
> This looks good. My only slight concern is whether it ties us more strictly
> to MySQL or in particular a particular MySQL version. (I'm not sure how
> widely supported the MySQL XML dump format is.. do they change the format
> when new feature are introduced for example and does MariaDB support it
> natively too).
> 
> Perhaps we could use the well supported and maintained SQL::Translator to
> produce something similar in XML, YAML or JSON as our middle format ?
Hi Martin,
SQL::Translator documentation states: "Presently only the definition parts of
SQL are handled (CREATE, ALTER), not the manipulation of data (INSERT, UPDATE,
DELETE)."

And this files normally do INSERTs, don't know if it's useful in this case.

-- 
You are receiving this mail because:
You are watching all bug changes.