NAME

blx::xsdsql::generator - generate the files for create table ,drop table ,add primary key,drop sequence,create sequence,drop view,create view

SYNOPSIS

use blx::xsdsql::generator

DESCRIPTION

this package is a class - instance it with the method new

VERSION

0.10.0

FUNCTIONS

new - constructor

    PARAMS
        BINDING                => binding instance
        EXTRA_TABLES        => extra tables instance

generate - generate a file

    PARAMS:
        SCHEMA                 => schema object generated by blx::xsdsql::parser::parse (is't not mandatory for generate the extra tables object)
        FD                  => streamer class, file descriptor  , array or string  (default *STDOUT)
        COMMAND              => create_table|drop_table|addpk|drop_sequence|create_sequence|drop_dictionary|drop_extra_tables|create_dictionary|create_extra_tables
                               for compatibility drop_dictionary is synonimous of drop_extra_tables and create_dictionary is synonimous od create_extra_tables
        LEVEL_FILTER          => <n> -  produce code only for tables at level <n> (n >= 0) - root has level 0  (default none)
        TABLES_FILTER          => [<name>] - produce code only for tables in  <name> - <name> is a table_name or a xml_path
        MAX_VIEW_COLUMNS     =>  produce view code only for views with columns number <= MAX_VIEW_COLUMNS -
                            -1 is a system limit (database depend)
                            false is no limit (the default)
        MAX_VIEW_JOINS         =>  produce view code only for views with join number <= MAX_VIEW_JOINS -
                            -1 is a system limit (database depend)
                            false is no limit (the default)
        NO_EMIT_COMMENTS    => if true not emit the sql comments - default false

    the method return a self to object

get_namespaces - static method

    the method return an array of namespace founded

EXPORT

None by default.

EXPORT_OK

None

SEE ALSO

See blx::xsdsql::parser for parse a xsd file (schema file) and blx::xsdsql::xml for read/write a xml file into/from a database

AUTHOR

lorenzo.bellotti, <pauseblx@gmail.com>

COPYRIGHT AND LICENSE

Copyright (C) 2010 by lorenzo.bellotti

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

See http://www.perl.com/perl/misc/Artistic.html