Home
Downloads
Features
Tutorials
Community
SIDE Application Repository
Professional Support
Languages Languages :  English

We can import, in BlueXML Developer Studio, data managed by data base. For this, we use DBDesigner. This tutorial demonstrates how to use this with a simple example.

Simple example

SQL Script : 

CREATE TABLE company (
 name CHAR(50) NOT NULL,
 www CHAR(100) NOT NULL,
 CA DOUBLE NOT NULL,
 PRIMARY KEY(name)
);

CREATE TABLE contact (
 id INTEGER(10) UNSIGNED NOT NULL,
 firstName CHAR(50) NOT NULL,
 lastName CHAR(50) NOT NULL,
 companyName CHAR(50) NOT NULL,
 PRIMARY KEY(id),
 INDEX companyName(companyName),
 FOREIGN KEY(companyName)
   REFERENCES company(name)
     ON DELETE NO ACTION
     ON UPDATE NO ACTION
);

File saved with DBDesigner :

BDD2BLUEXML demo 01.gif
<?xml version="1.0" standalone="yes" ?>
<DBMODEL Version="4.0">
    <SETTINGS>
        <GLOBALSETTINGS ModelName="export" IDModel="0" IDVersion="0" VersionStr="1.0.0.0"
            Comments="" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL"
            ZoomFac="100.00" XPos="0" YPos="0" DefaultDataType="5" DefaultTablePrefix="0"
            DefSaveDBConn="" DefSyncDBConn="" DefQueryDBConn="" Printer="" HPageCount="4.0"
            PageAspectRatio="1.440892512336408" PageOrientation="1"
            PageFormat="A4 (210x297 mm, 8.26x11.7 inches)" SelectedPages="" UsePositionGrid="0"
            PositionGridX="20" PositionGridY="20" TableNameInRefs="0" DefaultTableType="0"
            ActivateRefDefForNewRelations="1" FKPrefix="" FKPostfix="" CreateFKRefDefIndex="0"
            DBQuoteCharacter="`" CreateSQLforLinkedObjects="0" DefModelFont="Tahoma"
            CanvasWidth="4096" CanvasHeight="2842"/>
        <DATATYPEGROUPS>
            <DATATYPEGROUP Name="Numeric Types" Icon="1"/>
            <DATATYPEGROUP Name="Date and Time Types" Icon="2"/>
            <DATATYPEGROUP Name="String Types" Icon="3"/>
            <DATATYPEGROUP Name="Blob and Text Types" Icon="4"/>
            <DATATYPEGROUP Name="User defined Types" Icon="5"/>
            <DATATYPEGROUP Name="Geographic Types" Icon="6"/>
        </DATATYPEGROUPS>
        <DATATYPES>
            <DATATYPE ID="1" IDGroup="0" TypeName="TINYINT"
                Description="A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255."
                ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="length"/>
                </PARAMS>
                <OPTIONS>
                    <OPTION Name="UNSIGNED" Default="1"/>
                    <OPTION Name="ZEROFILL" Default="0"/>
                </OPTIONS>
            </DATATYPE>
            <DATATYPE ID="2" IDGroup="0" TypeName="SMALLINT"
                Description="A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535."
                ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="length"/>
                </PARAMS>
                <OPTIONS>
                    <OPTION Name="UNSIGNED" Default="1"/>
                    <OPTION Name="ZEROFILL" Default="0"/>
                </OPTIONS>
            </DATATYPE>
            <DATATYPE ID="3" IDGroup="0" TypeName="MEDIUMINT"
                Description="A medium-size integer. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215."
                ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="length"/>
                </PARAMS>
                <OPTIONS>
                    <OPTION Name="UNSIGNED" Default="1"/>
                    <OPTION Name="ZEROFILL" Default="0"/>
                </OPTIONS>
            </DATATYPE>
            <DATATYPE ID="4" IDGroup="0" TypeName="INT"
                Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295."
                ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="length"/>
                </PARAMS>
                <OPTIONS>
                    <OPTION Name="UNSIGNED" Default="0"/>
                    <OPTION Name="ZEROFILL" Default="0"/>
                </OPTIONS>
            </DATATYPE>
            <DATATYPE ID="5" IDGroup="0" TypeName="INTEGER"
                Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295."
                ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="length"/>
                </PARAMS>
                <OPTIONS>
                    <OPTION Name="UNSIGNED" Default="1"/>
                    <OPTION Name="ZEROFILL" Default="0"/>
                </OPTIONS>
            </DATATYPE>
            <DATATYPE ID="6" IDGroup="0" TypeName="BIGINT"
                Description="A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615."
                ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="length"/>
                </PARAMS>
                <OPTIONS>
                    <OPTION Name="UNSIGNED" Default="0"/>
                    <OPTION Name="ZEROFILL" Default="0"/>
                </OPTIONS>
            </DATATYPE>
            <DATATYPE ID="7" IDGroup="0" TypeName="FLOAT"
                Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38."
                ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="precision"/>
                </PARAMS>
                <OPTIONS>
                    <OPTION Name="ZEROFILL" Default="0"/>
                </OPTIONS>
            </DATATYPE>
            <DATATYPE ID="8" IDGroup="0" TypeName="FLOAT"
                Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38."
                ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="length"/>
                    <PARAM Name="decimals"/>
                </PARAMS>
                <OPTIONS>
                    <OPTION Name="ZEROFILL" Default="0"/>
                </OPTIONS>
            </DATATYPE>
            <DATATYPE ID="9" IDGroup="0" TypeName="DOUBLE"
                Description="A normal-size (double-precision) floating-point number. Cannot be unsigned. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308."
                ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="length"/>
                    <PARAM Name="decimals"/>
                </PARAMS>
                <OPTIONS>
                    <OPTION Name="ZEROFILL" Default="0"/>
                </OPTIONS>
            </DATATYPE>
            <DATATYPE ID="10" IDGroup="0" TypeName="DOUBLE PRECISION"
                Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1"
                ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0"
                PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="length"/>
                    <PARAM Name="decimals"/>
                </PARAMS>
                <OPTIONS>
                    <OPTION Name="ZEROFILL" Default="0"/>
                </OPTIONS>
            </DATATYPE>
            <DATATYPE ID="11" IDGroup="0" TypeName="REAL"
                Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1"
                ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0"
                PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="length"/>
                    <PARAM Name="decimals"/>
                </PARAMS>
                <OPTIONS>
                    <OPTION Name="ZEROFILL" Default="0"/>
                </OPTIONS>
            </DATATYPE>
            <DATATYPE ID="12" IDGroup="0" TypeName="DECIMAL"
                Description="An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR column."
                ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="length"/>
                    <PARAM Name="decimals"/>
                </PARAMS>
                <OPTIONS>
                    <OPTION Name="ZEROFILL" Default="0"/>
                </OPTIONS>
            </DATATYPE>
            <DATATYPE ID="13" IDGroup="0" TypeName="NUMERIC"
                Description="This is a synonym for DECIMAL." ParamCount="2" OptionCount="1"
                ParamRequired="1" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0"
                PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="length"/>
                    <PARAM Name="decimals"/>
                </PARAMS>
                <OPTIONS>
                    <OPTION Name="ZEROFILL" Default="0"/>
                </OPTIONS>
            </DATATYPE>
            <DATATYPE ID="14" IDGroup="1" TypeName="DATE"
                Description="A date. The supported range is \a1000-01-01\a to \a9999-12-31\a."
                ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="15" IDGroup="1" TypeName="DATETIME"
                Description="A date and time combination. The supported range is \a1000-01-01 00:00:00\a to \a9999-12-31 23:59:59\a."
                ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="16" IDGroup="1" TypeName="TIMESTAMP"
                Description="A timestamp. The range is \a1970-01-01 00:00:00\a to sometime in the year 2037. The length can be 14 (or missing), 12, 10, 8, 6, 4, or 2 representing YYYYMMDDHHMMSS, ... , YYYYMMDD, ... , YY formats."
                ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="length"/>
                </PARAMS>
            </DATATYPE>
            <DATATYPE ID="17" IDGroup="1" TypeName="TIME"
                Description="A time. The range is \a-838:59:59\a to \a838:59:59\a." ParamCount="0"
                OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0"
                PhysicalMapping="0" PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="18" IDGroup="1" TypeName="YEAR"
                Description="A year in 2- or 4-digit format (default is 4-digit)." ParamCount="1"
                OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0"
                PhysicalMapping="0" PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="length"/>
                </PARAMS>
            </DATATYPE>
            <DATATYPE ID="19" IDGroup="2" TypeName="CHAR"
                Description="A fixed-length string (1 to 255 characters) that is always right-padded with spaces to the specified length when stored. values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given."
                ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="length"/>
                </PARAMS>
                <OPTIONS>
                    <OPTION Name="BINARY" Default="0"/>
                </OPTIONS>
            </DATATYPE>
            <DATATYPE ID="20" IDGroup="2" TypeName="VARCHAR"
                Description="A variable-length string (1 to 255 characters). Values are sorted and compared in case-sensitive fashion unless the BINARY keyword is given."
                ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="length"/>
                </PARAMS>
                <OPTIONS>
                    <OPTION Name="BINARY" Default="0"/>
                </OPTIONS>
            </DATATYPE>
            <DATATYPE ID="21" IDGroup="2" TypeName="BIT"
                Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0"
                ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0"
                PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="22" IDGroup="2" TypeName="BOOL"
                Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0"
                ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0"
                PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="23" IDGroup="3" TypeName="TINYBLOB"
                Description="A column maximum length of 255 (2^8 - 1) characters. Values are sorted and compared in case-sensitive fashion."
                ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="24" IDGroup="3" TypeName="BLOB"
                Description="A column maximum length of 65535 (2^16 - 1) characters. Values are sorted and compared in case-sensitive fashion."
                ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="25" IDGroup="3" TypeName="MEDIUMBLOB"
                Description="A column maximum length of 16777215 (2^24 - 1) characters. Values are sorted and compared in case-sensitive fashion."
                ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="26" IDGroup="3" TypeName="LONGBLOB"
                Description="A column maximum length of 4294967295 (2^32 - 1) characters. Values are sorted and compared in case-sensitive fashion."
                ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="27" IDGroup="3" TypeName="TINYTEXT"
                Description="A column maximum length of 255 (2^8 - 1) characters." ParamCount="0"
                OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0"
                PhysicalMapping="0" PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="28" IDGroup="3" TypeName="TEXT"
                Description="A column maximum length of 65535 (2^16 - 1) characters." ParamCount="0"
                OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0"
                PhysicalMapping="0" PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="29" IDGroup="3" TypeName="MEDIUMTEXT"
                Description="A column maximum length of 16777215 (2^24 - 1) characters."
                ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="30" IDGroup="3" TypeName="LONGTEXT"
                Description="A column maximum length of 4294967295 (2^32 - 1) characters."
                ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="31" IDGroup="3" TypeName="ENUM"
                Description="An enumeration. A string object that can have only one value, chosen from the list of values."
                ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="values"/>
                </PARAMS>
            </DATATYPE>
            <DATATYPE ID="32" IDGroup="3" TypeName="SET"
                Description="A set. A string object that can have zero or more values, each of which must be chosen from the list of values."
                ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="">
                <PARAMS>
                    <PARAM Name="values"/>
                </PARAMS>
            </DATATYPE>
            <DATATYPE ID="33" IDGroup="4" TypeName="Varchar(20)" Description="" ParamCount="0"
                OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0"
                PhysicalMapping="0" PhysicalTypeName="">
                <OPTIONS>
                    <OPTION Name="BINARY" Default="0"/>
                </OPTIONS>
            </DATATYPE>
            <DATATYPE ID="34" IDGroup="4" TypeName="Varchar(45)" Description="" ParamCount="0"
                OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0"
                PhysicalMapping="0" PhysicalTypeName="">
                <OPTIONS>
                    <OPTION Name="BINARY" Default="0"/>
                </OPTIONS>
            </DATATYPE>
            <DATATYPE ID="35" IDGroup="4" TypeName="Varchar(255)" Description="" ParamCount="0"
                OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0"
                PhysicalMapping="0" PhysicalTypeName="">
                <OPTIONS>
                    <OPTION Name="BINARY" Default="0"/>
                </OPTIONS>
            </DATATYPE>
            <DATATYPE ID="36" IDGroup="5" TypeName="GEOMETRY" Description="Geographic Datatype"
                ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="38" IDGroup="5" TypeName="LINESTRING" Description="Geographic Datatype"
                ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="39" IDGroup="5" TypeName="POLYGON" Description="Geographic Datatype"
                ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="40" IDGroup="5" TypeName="MULTIPOINT" Description="Geographic Datatype"
                ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="41" IDGroup="5" TypeName="MULTILINESTRING"
                Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0"
                EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="42" IDGroup="5" TypeName="MULTIPOLYGON" Description="Geographic Datatype"
                ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0"
                SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName=""> </DATATYPE>
            <DATATYPE ID="43" IDGroup="5" TypeName="GEOMETRYCOLLECTION"
                Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0"
                EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName=""
            > </DATATYPE>
        </DATATYPES>
        <COMMON_DATATYPES>
            <COMMON_DATATYPE ID="5"/>
            <COMMON_DATATYPE ID="8"/>
            <COMMON_DATATYPE ID="20"/>
            <COMMON_DATATYPE ID="15"/>
            <COMMON_DATATYPE ID="22"/>
            <COMMON_DATATYPE ID="28"/>
            <COMMON_DATATYPE ID="26"/>
            <COMMON_DATATYPE ID="33"/>
            <COMMON_DATATYPE ID="34"/>
            <COMMON_DATATYPE ID="35"/>
        </COMMON_DATATYPES>
        <TABLEPREFIXES>
            <TABLEPREFIX Name="Defaut (pas de pr\233fixe)"/>
        </TABLEPREFIXES>
        <REGIONCOLORS>
            <REGIONCOLOR Color="Red=#FFEEEC"/>
            <REGIONCOLOR Color="Yellow=#FEFDED"/>
            <REGIONCOLOR Color="Green=#EAFFE5"/>
            <REGIONCOLOR Color="Cyan=#ECFDFF"/>
            <REGIONCOLOR Color="Blue=#F0F1FE"/>
            <REGIONCOLOR Color="Magenta=#FFEBFA"/>
        </REGIONCOLORS>
        <POSITIONMARKERS>
            <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0"/>
            <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0"/>
            <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0"/>
            <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0"/>
            <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0"/>
            <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0"/>
            <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0"/>
            <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0"/>
            <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0"/>
            <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0"/>
            <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0"/>
        </POSITIONMARKERS>
    </SETTINGS>
    <METADATA>
        <REGIONS> </REGIONS>
        <TABLES>
            <TABLE ID="1048" Tablename="company" PrevTableName="" XPos="80" YPos="40" TableType="0"
                TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0"
                StandardInserts="\n"
                TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n"
                Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1"
                OrderPos="2">
                <COLUMNS>
                    <COLUMN ID="1050" ColName="name" PrevColName="" Pos="1" idDatatype="20"
                        DatatypeParams="" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0"
                        IsForeignKey="0" DefaultValue="" Comments="">
                        <OPTIONSELECTED>
                            <OPTIONSELECT Value="0"/>
                        </OPTIONSELECTED>
                    </COLUMN>
                    <COLUMN ID="1051" ColName="www" PrevColName="" Pos="2" idDatatype="20"
                        DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0"
                        IsForeignKey="0" DefaultValue="" Comments="">
                        <OPTIONSELECTED>
                            <OPTIONSELECT Value="0"/>
                        </OPTIONSELECTED>
                    </COLUMN>
                    <COLUMN ID="1052" ColName="CA" PrevColName="" Pos="3" idDatatype="9"
                        DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0"
                        IsForeignKey="0" DefaultValue="" Comments="">
                        <OPTIONSELECTED>
                            <OPTIONSELECT Value="0"/>
                        </OPTIONSELECTED>
                    </COLUMN>
                </COLUMNS>
                <RELATIONS_START>
                    <RELATION_START ID="1060"/>
                </RELATIONS_START>
                <INDICES>
                    <INDEX ID="1053" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
                        <INDEXCOLUMNS>
                            <INDEXCOLUMN idColumn="1050" LengthParam="0"/>
                        </INDEXCOLUMNS>
                    </INDEX>
                </INDICES>
            </TABLE>
            <TABLE ID="1049" Tablename="contact" PrevTableName="" XPos="303" YPos="163"
                TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0"
                StandardInserts="\n"
                TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n"
                Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1"
                OrderPos="3">
                <COLUMNS>
                    <COLUMN ID="1054" ColName="id" PrevColName="" Pos="1" idDatatype="5"
                        DatatypeParams="(10)" Width="0" Prec="0" PrimaryKey="1" NotNull="1"
                        AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
                        <OPTIONSELECTED>
                            <OPTIONSELECT Value="1"/>
                            <OPTIONSELECT Value="0"/>
                        </OPTIONSELECTED>
                    </COLUMN>
                    <COLUMN ID="1068" ColName="companyName" PrevColName="" Pos="1" idDatatype="20"
                        DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0"
                        IsForeignKey="1" DefaultValue="" Comments="">
                        <OPTIONSELECTED>
                            <OPTIONSELECT Value="0"/>
                        </OPTIONSELECTED>
                    </COLUMN>
                    <COLUMN ID="1055" ColName="firstName" PrevColName="" Pos="2" idDatatype="20"
                        DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0"
                        IsForeignKey="0" DefaultValue="" Comments="">
                        <OPTIONSELECTED>
                            <OPTIONSELECT Value="0"/>
                        </OPTIONSELECTED>
                    </COLUMN>
                    <COLUMN ID="1056" ColName="lastName" PrevColName="" Pos="3" idDatatype="20"
                        DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0"
                        IsForeignKey="0" DefaultValue="" Comments="">
                        <OPTIONSELECTED>
                            <OPTIONSELECT Value="0"/>
                        </OPTIONSELECTED>
                    </COLUMN>
                </COLUMNS>
                <RELATIONS_END>
                    <RELATION_END ID="1060"/>
                </RELATIONS_END>
                <INDICES>
                    <INDEX ID="1058" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
                        <INDEXCOLUMNS>
                            <INDEXCOLUMN idColumn="1054" LengthParam="0"/>
                        </INDEXCOLUMNS>
                    </INDEX>
                </INDICES>
            </TABLE>
        </TABLES>
        <RELATIONS>
            <RELATION ID="1060" RelationName="contacts" Kind="2" SrcTable="1048" DestTable="1049"
                FKFields="name=companyName\n" FKFieldsComments="\n" relDirection="2" MidOffset="0"
                OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0"
                StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0"
                EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0"
                RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1"
                Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="4"/>
        </RELATIONS>
        <NOTES> </NOTES>
        <IMAGES> </IMAGES>
    </METADATA>
    <PLUGINDATA>
        <PLUGINDATARECORDS> </PLUGINDATARECORDS>
    </PLUGINDATA>
    <QUERYDATA>
        <QUERYRECORDS> </QUERYRECORDS>
    </QUERYDATA>
    <LINKEDMODELS> </LINKEDMODELS>
</DBMODEL>

Integration

We copy this XML file in an Eclipse project. In the contexual menu of the XML file, we select BlueXML Transformations > Generate DataBase Schema from DB Designer. We obtain an intermediate file : 

<?xml version="1.0" encoding="UTF-8"?>
<Package name="export">
    <Table id="_1048" name="company" description="">
        <Columns>
            <Column id="_1050" name="name" title="name" description="" type="String"
                isPrimaryKey="1" isForeignKey="0" notNull="1" autoInc="0" defaultValue=""/>
            <Column id="_1051" name="www" title="www" description="" type="String" isPrimaryKey="0"
                isForeignKey="0" notNull="1" autoInc="0" defaultValue=""/>
            <Column id="_1052" name="CA" title="CA" description="" type="Double" isPrimaryKey="0"
                isForeignKey="0" notNull="1" autoInc="0" defaultValue=""/>
        </Columns>
        <RelationsStart>
            <RelationRef ref="_1060"/>
        </RelationsStart>
        <Indices>
            <Index id="_1053" name="PRIMARY" kind="0">
                <IndexColumns>
                    <IndexColumn idColumn="_1050"/>
                </IndexColumns>
            </Index>
        </Indices>
    </Table>
    <Table id="_1049" name="contact" description="">
        <Columns>
            <Column id="_1054" name="id" title="id" description="" type="Integer" isPrimaryKey="1"
                isForeignKey="0" notNull="1" autoInc="0" defaultValue=""/>
            <Column id="_1068" name="companyName" title="companyName" description="" type="String"
                isPrimaryKey="0" isForeignKey="1" notNull="1" autoInc="0" defaultValue=""/>
            <Column id="_1055" name="firstName" title="firstName" description="" type="String"
                isPrimaryKey="0" isForeignKey="0" notNull="1" autoInc="0" defaultValue=""/>
            <Column id="_1056" name="lastName" title="lastName" description="" type="String"
                isPrimaryKey="0" isForeignKey="0" notNull="1" autoInc="0" defaultValue=""/>
        </Columns>
        <RelationsEnd>
            <RelationRef ref="_1060"/>
        </RelationsEnd>
        <Indices>
            <Index id="_1058" name="PRIMARY" kind="0">
                <IndexColumns>
                    <IndexColumn idColumn="_1054"/>
                </IndexColumns>
            </Index>
        </Indices>
    </Table>
    <Relation id="_1060" name="contacts" description="" SrcTable="_1048" DestTable="_1049"
        MinDest="0" MaxDest="-1"/>
</Package>

On the new file, we select on the contectual menu BlueXML Transformations > Generate OBL Model from DataBase Schema. We obtain an OBL file : 

<?xml version="1.0" encoding="UTF-8"?>
<MMUseCase:Package xmlns:MMUseCase="http://MMUseCase" xmlns:xmi="http://www.omg.org/XMI"
    xmi:version="2.0" xmi:id="N65536" name="ImportDBDesigner">
    <packageSet xmi:id="N65537" name="export">
        <classSet xmi:id="_1048" name="company" title="company" description="" associations="_1060 ">
            <attributes xmi:id="_1050" name="name" typ="String" title="name" description=""/>
            <attributes xmi:id="_1051" name="www" typ="String" title="www" description=""/>
            <attributes xmi:id="_1052" name="CA" typ="double" title="CA" description=""/>
        </classSet>
        <classSet xmi:id="_1049" name="contact" title="contact" description="" associations="_1060 ">
            <attributes xmi:id="_1054" name="id" typ="int" title="id" description=""/>
            <attributes xmi:id="_1068" name="companyName" typ="String" title="companyName"
                description=""/>
            <attributes xmi:id="_1055" name="firstName" typ="String" title="firstName"
                description=""/>
            <attributes xmi:id="_1056" name="lastName" typ="String" title="lastName" description=""
            />
        </classSet>
        <associationSet xmi:id="_1060" name="contacts" description="" source="_1048"
            destination="_1049" minSRC="" maxSRC="" minTARGET="0" maxTARGET="-1"/>
    </packageSet>
</MMUseCase:Package>

We can now create an OBLDI file to show graphicly the model. We choose on the contextual menu of the OBL file New > Other.... After we select Topcased > Topcased Diagrams > BlueXML Diagram. We create a model diagram from an existing model. We select class diagram as root diagram. We can intialize the diagram with existing model objects.

BDD2BLUEXML demo 02.gif

Technical informations

More informations !

Retrieved from "http://www1.side-labs.org/wiki/index.php?title=BDD2BlueXML&oldid=4052"