index tag and unique tag exists in dtd but DatabaseIO().write generate XML 
without index and unique elements
------------------------------------------------------------------------------------------------------------

         Key: DDLUTILS-19
         URL: http://issues.apache.org/jira/browse/DDLUTILS-19
     Project: DdlUtils
        Type: Bug
 Environment: Linux Fedora 4 jdk1.5.0_04
    Reporter: Andre Charles Legendre
 Assigned to: Thomas Dudziak 


index tag and unique tag exists in both dtd but I
found no index element nor unique element created when
I have generated XML from our database using
DatabaseIO().write

For example a postgres table created by :

CREATE TABLE MFG_BatchType
  (
    Id            numeric(10,0)   unique not null,
    AD_Client_ID  numeric(10,0)   not null,
    AD_Org_ID     numeric(10,0)   not null,
    IsActive      varchar(1)      not null default 'Y',
    Created       timestamp       not null default CURRENT_TIMESTAMP,
    CreatedBy     numeric(10,0)   not null,
    Updated       timestamp       not null default CURRENT_TIMESTAMP,
    UpdatedBy     numeric(10,0)   not null,
    Name          varchar(200)    not null,
    No_version    varchar(32)     not null,
    Description   varchar(2000)   not null,
    Cycle_Time    numeric(10,0)   not null,
    Cycle_Qty     float8          not null,

    primary key(Id)
  );

CREATE INDEX MFG_BatchTypeNDX1 ON MFG_BatchType(Id);

-- ----------------------------------------------------------------------

COMMENT ON COLUMN MFG_BatchType.Description is 'Cycle, one shot or when 
completed';
COMMENT ON COLUMN MFG_BatchType.Cycle_Time is 'if batch type is cycle';
COMMENT ON COLUMN MFG_BatchType.Cycle_Qty is 'Number of work orders to 
introduce when WIP minimum is reached';

Give this XML :

    <table name="mfg_batchtype">
      <column name="id" primaryKey="false" required="true" type="NUMERIC" 
size="10" autoIncrement="false"/>
      <column name="ad_client_id" primaryKey="false" required="true" 
type="NUMERIC" size="10" autoIncrement="false"/>
      <column name="ad_org_id" primaryKey="false" required="true" 
type="NUMERIC" size="10" autoIncrement="false"/>
      <column name="isactive" primaryKey="false" required="true" type="VARCHAR" 
size="1" default="&apos;Y&apos;::character varying" autoIncrement="false"/>
      <column name="created" primaryKey="false" required="true" 
type="TIMESTAMP" size="8" default="(&apos;now&apos;::text)::timestamp(6) with 
time zone" autoIncrement="false"/>
      <column name="createdby" primaryKey="false" required="true" 
type="NUMERIC" size="10" autoIncrement="false"/>
      <column name="updated" primaryKey="false" required="true" 
type="TIMESTAMP" size="8" default="(&apos;now&apos;::text)::timestamp(6) with 
time zone" autoIncrement="false"/>
      <column name="updatedby" primaryKey="false" required="true" 
type="NUMERIC" size="10" autoIncrement="false"/>
      <column name="name" primaryKey="false" required="true" type="VARCHAR" 
size="200" autoIncrement="false"/>
      <column name="no_version" primaryKey="false" required="true" 
type="VARCHAR" size="32" autoIncrement="false"/>
      <column name="description" primaryKey="false" required="true" 
type="VARCHAR" size="2000" autoIncrement="false"/>
      <column name="cycle_time" primaryKey="false" required="true" 
type="NUMERIC" size="10" autoIncrement="false"/>
      <column name="cycle_qty" primaryKey="false" required="true" type="DOUBLE" 
size="8" autoIncrement="false"/>
    </table>

As you can see index and comment disapear for comment, it is not an issue but 
for index yes.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

Reply via email to