GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  SQL::TRANSLATOR::PRODUCER::XML::SQLFAIRY (3)

.ds Aq ’

NAME

SQL::Translator::Producer::XML::SQLFairy - SQLFairy’s default XML format

CONTENTS

SYNOPSIS



  use SQL::Translator;

  my $t              = SQL::Translator->new(
      from           => MySQL,
      to             => XML-SQLFairy,
      filename       => schema.sql,
      show_warnings  => 1,
  );

  print $t->translate;



DESCRIPTION

Creates XML output of a schema, in the flavor of XML used natively by the SQLFairy project (SQL::Translator). This format is detailed here.

The XML lives in the http://sqlfairy.sourceforge.net/sqlfairy.xml namespace. With a root element of <schema>.

Objects in the schema are mapped to tags of the same name as the objects class (all lowercase).

The attributes of the objects (e.g. $field->name) are mapped to attributes of the tag, except for sql, comments and action, which get mapped to child data elements.

List valued attributes (such as the list of fields in an index) get mapped to comma separated lists of values in the attribute.

Child objects, such as a tables fields, get mapped to child tags wrapped in a set of container tags using the plural of their contained classes name.

An objects’ extra attribute (a hash of arbitrary data) is mapped to a tag called extra, with the hash of data as attributes, sorted into alphabetical order.

e.g.



    <schema name="" database=""
      xmlns="http://sqlfairy.sourceforge.net/sqlfairy.xml">

      <tables>
        <table name="Story" order="1">
          <fields>
            <field name="id" data_type="BIGINT" size="20"
              is_nullable="0" is_auto_increment="1" is_primary_key="1"
              is_foreign_key="0" order="3">
              <extra ZEROFILL="1" />
              <comments></comments>
            </field>
            <field name="created" data_type="datetime" size="0"
              is_nullable="1" is_auto_increment="0" is_primary_key="0"
              is_foreign_key="0" order="1">
              <extra />
              <comments></comments>
            </field>
            ...
          </fields>
          <indices>
            <index name="foobar" type="NORMAL" fields="foo,bar" options="" />
          </indices>
        </table>
      </tables>

      <views>
        <view name="email_list" fields="email" order="1">
          <sql>SELECT email FROM Basic WHERE email IS NOT NULL</sql>
        </view>
      </views>

    </schema>



To see a complete example of the XML translate one of your schema :)



  $ sqlt -f MySQL -t XML-SQLFairy schema.sql



ARGS

add_prefix Set to true to use the default namespace prefix of ’sqlf’, instead of using the default namespace for http://sqlfairy.sourceforge.net/sqlfairy.xml namespace

e.g.



 <!-- add_prefix=0 -->
 <field name="foo" />

 <!-- add_prefix=1 -->
 <sqlf:field name="foo" />



prefix Set to the namespace prefix you want to use for the http://sqlfairy.sourceforge.net/sqlfairy.xml namespace

e.g.



 <!-- prefix=foo -->
 <foo:field name="foo" />



newlines If true (the default) inserts newlines around the XML, otherwise the schema is written on one line.
indent When using newlines the number of whitespace characters to use as the indent. Default is 2, set to 0 to turn off indenting.

LEGACY FORMAT

The previous version of the SQLFairy XML allowed the attributes of the schema objects to be written as either xml attributes or as data elements, in any combination. The old producer could produce attribute only or data element only versions. While this allowed for lots of flexibility in writing the XML the result is a great many possible XML formats, not so good for DTD writing, XPathing etc! So we have moved to a fixed version described above.

This version of the producer will now only produce the new style XML. To convert your old format files simply pass them through the translator :)



 $ sqlt -f XML-SQLFairy -t XML-SQLFairy schema-old.xml > schema-new.xml



AUTHORS

Ken Youens-Clark <kclark@cpan.org>, Darren Chamberlain <darren@cpan.org>, Mark Addison <mark.addison@itn.co.uk>.

SEE ALSO

perl(1), SQL::Translator, SQL::Translator::Parser::XML::SQLFairy, SQL::Translator::Schema, XML::Writer.
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 SQL::TRANSLATOR::PRODUCER::XML::SQLFAIRY (3) 2013-09-26

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.