2010/12/31 Dieter Adriaenssens dieter.adriaenssens@gmail.com:
2010/12/27 AAMIR KHAN ak4u2009@gmail.com:
On Mon, Dec 27, 2010 at 7:14 PM, Michal Čihař michal@cihar.com wrote:
Hi
Dne Sat, 25 Dec 2010 12:35:45 +0100 Dieter Adriaenssens dieter.adriaenssens@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.
Hi Aamir,
I took a look at your patch (xml-view-nested.diff [0]). I don't understand why you keep the stand-in and stand-in-drop in the export, if you go to the trouble of changing the import process to take care of the nested stand-in-drop. Wouldn't it be easier to just have an export of pma:view (without stand-in or drop) and make the necessary changes in import to take care of the view of view problem? (I described how this should work in an earlier post)
[0] http://sourceforge.net/tracker/download.php?group_id=23067&atid=377410&a...
Happy New Year!
Seasonal greetings,
Dieter
Hi Aamir,
I hope you are doing fine.
Are you still working on a patch for the xml export/import of views?
Kind regards,
Dieter