Revision history for Perl extension blx::xsdsql 0.01 July 20 18:24 2010 - original version; created by h2xs 1.23 with options -XA -b 5.8.0 -n blx::xsdsql::ut 0.02 December 09 18:48 2010 - add TABLE_PREFIX param to blx::xsdsql::parser::parsefile - exclude dirs if name begin with a point into blx::xsdsql::parser::parsefile::get_db_namespaces - exclude dirs if name begin with a point into blx::xsdsql::parser::generator::get_namespaces - new commands display_namespaces,drop_sequence,create_sequence in xsd2sql.pl - correct the crash if the command is unknow in xsd2sql.pl - new options t,l,p,w in xsd2sql.pl - generic internal params restyle ( Es: my ($self,%params)=@_) in subs - add LEVEL_FILTER and TABLES_FILTER params to blx::xsdsql::generator - add params SCHEMA_NAME and SCHEMA_INSTANCE to blx::xsdsql::xml::new and blx::xsdsql::xml::write - implement a new test suite - implement a xsd groups 0.03 January 04 19:04 2011 - correct bugs in documentation - new commands drop_view, create_view - implement drop view and create view classes - change email address of the author - minor bugs corretted 0.04 January 20 20:08 2011 - correct bugs in documentation - minor bugs corretted - new commands drop_dictionary,create_dictionary,insert_dictionary in xsd2sql.pl - correct bug in create_view for oracle - make clean delete temporary files in test directory 0.05 March 31 17:07 2011 - complete restyle of parsing algorithms - minor bugs corretted 0.06 June 11 12:00 2011 - xsd group implemented - a first implementation of namespace - new options in test.pl/xsd2sql/xml.pl - bugs corrected 0.06.1 June 16 16:13 2011 - corrected algo bugs on param ROOT_TAG_PARAMS of method blx::xsdsql::xml::write 0.06.2 - July 20 18:12 2011 - corrected max int on parser - bug in write mandatory note with value null string - create_view: in the header of views converted comment PATH to ROOTPATH - bug on choice - a default minOccurs for a choice node is 0 and not 1 - bug on choice into a node with maxOccurs > 1 - change the param CHOISE into CHOICE in all modules - correct documentation - add this attribute in class blx::xsdsql::xml::generic::table and new columns in table_dictionary: PARENT_PATH,IS_ROOT_TABLE,IS_UNPATH,IS_INTERNAL_REF,VIEW_NAME - new method blx::xsdsql::xml::generic::table::reset_columns - revised the method blx::xsdsql::xml::generic::table::add_columns - new param FORCE in blx::xsdsql::xml::generic::column::get_sql_name - new attribute CHOICE for class blx::xsdsql::xml::generic::column and new column in column_dictionary - flat the columns of a group with maxoccurs <= 1 into the parent table - new option -X in test.pl (modality change, test.pl use for default xmldiff if is installed) - new option -S in test.pl (modality change, for default test.pl esecute xsd2sql in one step) - new param NO_FLAT_GROUPS in blx::xsdsql::parser::parsefile - correct bug on join a table with maxoccurs > 1 in create view - parser restyling code 0.07.0 - September 5 19:15 2011 - simpleContent implementation - column restyling code - table restyling code - new attribute ATTRIBUTE for class blx::xsdsql::xml::generic::column and new column in column_dictionary - new method blx::xsdsql::path_map::resolve_attributes - attribute implementation - correct documentation - restyle structure of table dictionary - obsolete params TABLE_IS_TYPE,SIMPLE_TYPE,COMPLEX_TYPE,SIMPLE_CONTENT,GROUP_TYPE in blx::xsdsql::xml::generic::table - new param XSD_TYPE in blx::xsdsql::xml::generic::table - correct bug on xseq choice 0.07.1 - September 7 18:05 2011 - xsd2sql.pl - correct warning parser command if $ARGV[0] is not set add attribute EMIT_SCHEMA_DUMPER - exclusion system attribute for nodes at level 1 - correct some tests because not passed if is use diff command 0.08 - - internal version - not published 0.09 - March 6 18:05 2012 - new algorithmics for schema parsing (RINCHI::Xmlschema removing) - multiplies namespace support - support for import,fractionDigit,attributes,custom_header,element_ref,attribute_ref - better algorithm for generate names 0.09.1 - May 10 18:05 2012 - new syntax for perl 5.14 0.09.2 - November 27 - 17:19 2012 - package in form tar.gz for win users (suggest from MITHALDU@cpan.org) 0.09.3 - January 20 - 18:00 2013 - new class method blx::xsdsql::dbconn::get_info - the method blx::xsdsql::dbconn::get_application_avaliables is deprecated, use the new method get_application_availables - the class methods get_applications_classname,get_database_availables,get_application_avaliables of the class blx::xsdsql::dbconn are cached and return a sorted array - the regression test use Test::Database for default (suggest from CHORNY@cpan.org) - test.pl - new option D (do not use Test::Database for connection but the old method) - test.pl - new option F (do not clean the database after tests end) - isql.pl - new option e (use Test::Database for connection) - xml.pl - new option e (use Test::Database for connection) - correct bug to retrieve connection string in blx::xsdsql::dbconn::oracle::dbi - adding META.yml (suggest from CHORNY@cpan.org) - for tests xmldiff is mandatory 0.10.0 - April 11 - 21:25 2013 - the xsd element 'element' support reference external namespace - Ex: (test 38) - test.pl - correct bug - with option T set, the temporary files now are cleaned - the xsd element 'attribute' now support reference external namespace - Ex: (test 38) - for tests xmllint is mandatory - xsd element attributeGroup implemented (test 39) - correct documentation - the method blx::xsdsql::generator::generate force utf8 encoding in output file if the schema encoding is utf8 - xsd element field and selector are ignored - xsd element list implemented (test 40) - xsd element notation implemented (test 41) - xsd element include implemented (test 42) - xsd element redefine simple type implemented (test 43) - correct bug writing xml file in blx::xsdsql::xml (test 37) - correct bug on support multiplies schema files in import (now support many root tables) (test 29) - the method blx::xsdsql::dbconn::get_application_avaliables is eliminated - xsd element complexContent implement (test 44) - xsd element redefine implemented (test 44) - the dictionary tables and the sequence generator are not dependented by the schema - xsd element redefine group type implement (test 45) - correct bug on qualified element ref (test 46) - correct bug on generate sql objects on childs schema at level > 1 (test 47) - correct bug on generate correct xml file (test 47) - the called of the constructors of table/colum class now pass the debug mode - check ok for groups in sequence (test 48) - the static method blx::xsdsql::xsd_parser::get_db_namespaces are dropped - the class blx::xsdsql::IStream is renamed in blx::xsdsql::ios::istream - the class blx::xsdsql::OStream is renamed in blx::xsdsql::ios::ostream - the class blx::xsdsql::log is renamed in blx::xsdsql::ios::debuglogger - correct emitted package name where emitted debug info in module blx::xsdsql::ios::debuglogger - the internal checks are implemented with affirm of the module Carp::Assert - set the env NDEBUG to ignore affirm - new package blx::xsdsql::version contenent the package version - the package blx::xsdsql::ut is renamed in blx::xsdsql::ut::ut and not contain the package version - the package blx::xsdsql::common_interfaces is renamed in blx::xsdsql::ut::common_interfaces - the package blx::xsdsql::default_constructor is deleted - implemented or corrected the types gDay,gMonthday,gYearMonth,gYear (test 3) - xsd entity and dtd tags into xml are now implemented (test 49) - the xsd attribute mixed is implemented (test 50) - the xsd types double and float now are converted into string because the values permitted are *inf* *nan* - the xsd type decimal is converted into a predefined big decimal if it's not possible to determiny numdigits or decimal digits - add tests for delete rows - test.pl for default now delete the rows after the write - use the option W for not delete the rows - the generation of conversion xsd type => sql types are reimplemented - the generation of sql names work with a map of invalid names many big and for all databases - correct a bug into blx::xsdsql::ut::common_interfaces::set_attrs_value - the dictionary has changed: in tables and in columns - it's possible to create the schema object from the dictionary - xml.pl are obsolete and are dropped - use the new program xml_repo.pl - new program xml_repo.pl for create dictionary, import/load schemas and store/put xml - new api - the old API is still usable but has changed; it's preferable to use the new API in module blx::xsdsql::schema_repository - test.pl now use the new API - new db implemented: mysql and DBM - the package Test::Database are excluded - for tests the default database is DBM - now the encoding of an xml file adjust the encoding stream of the output file - new package blx::xsdsql::connection in substitution of package blx::xsdsql::dbconn - the perl namespace blx::xsdsql::xml renamed in blx::xsdsql::schema_repository::sql - add test with node in utf8 code (test 51) - add test with encoding not in utf8 (test 52)