On Mon, Dec 27, 2010 at 7:14 PM, Michal Čihař <michal(a)cihar.com> wrote:
Hi
Dne Sat, 25 Dec 2010 12:35:45 +0100
Dieter Adriaenssens <dieter.adriaenssens(a)gmail.com> napsal(a):
I'd like your opinion about exporting view of
view in xml format.
Aamir Khan prepared a patch [0] that creates an XML export in the way
this is handled in SQL export, ie first all tables and views are
exported. All views are exported as standin tables with the same
structure. Then all views are recreated, first dropping the standin
tables, and creating the real views. The reason for this is to make
sure that when creating a view that uses another view, it at least
exists, thus avoiding an error upon importing it again.
Downside of this is that the xml export of the structure schema gets a
bit confusing with a <pma:table>, <pma:drop> and <pma:view> tag for
every view, as the xml export is intended to be used by custom
scripting.
I don't think that XML should be replacement of the SQL, especially I
don't see need for <pma:drop>. So it should just describe the data and
import should handle such problems.
I have created one test XML file as well as patch to implement
<pma:drop-stand-in> previously <pma:drop> as children of the
<pma:view> and renamed the tag names to make less confusion.
--
Michal Čihař |
http://cihar.com |
http://phpmyadmin.cz
------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel