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

[AAMIR KHAN]

On Mon, Dec 27, 2010 at 7:14 PM, Michal Čihař <michal at cihar.com> wrote:
> 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.
>
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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>
>