[Phpmyadmin-devel] XML export/import : view of view

Michal Čihař michal at cihar.com
Mon Dec 27 14:44:18 CET 2010


Hi

Dne Sat, 25 Dec 2010 12:35:45 +0100
Dieter Adriaenssens <dieter.adriaenssens at 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.

-- 
	Michal Čihař | http://cihar.com | http://phpmyadmin.cz
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20101227/b94235cf/attachment.sig>


More information about the Developers mailing list