<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Apr 23, 2007 4:53:05 PM by Hibernate Tools 3.2.0.beta8 -->
<hibernate-mapping>
    <class name="de.fhg.scai.bio.csr.io.database.hibernate.Item" table="ITEM">
        <id name="id" type="int">
            <column name="ID" precision="22" scale="0" />
            <generator class="assigned" />
        </id>
        <property name="type" type="string">
            <column name="TYPE" length="45" />
        </property>
        <set name="moleculeses" inverse="true">
            <key>
                <column name="ITEM_ID" precision="22" scale="0" not-null="true" unique="true" />
            </key>
            <one-to-many class="de.fhg.scai.bio.csr.io.database.hibernate.Molecules" />
        </set>
    </class>
</hibernate-mapping>

<generator class="assigned" />

<generator class="sequence">
            <param name="sequence">item_seq</param>
         </generator>

CREATE TABLE item (
  id INTEGER  NOT NULL ,
  type  VARCHAR(45) NULL,
  PRIMARY KEY(id)
);

CREATE TABLE molecules (
  item_id INTEGER  NOT NULL,
  name VARCHAR(100) NULL,
  smiles VARCHAR(100) NULL,
  iupac VARCHAR(100) NULL,
  inchi VARCHAR(100) NULL,
  formula VARCHAR(100) NULL,
  createBy VARCHAR(100) NULL,
  nofAtoms INT NULL,
  nofBonds INT NULL,
  nofHeavyAtoms INT NULL,
  nofHeavyBonds INT NULL,
  nofFragments INT NULL,
  nofSuperAtoms INT NULL,
  nofRings INT NULL,
  nofRGroups INT NULL,
  medianBondLength DOUBLE PRECISION NULL,
  mass DOUBLE PRECISION NULL,
  directory VARCHAR(100) NULL,
  workflowID INTEGER  NULL,
  PRIMARY KEY(item_id),
  FOREIGN KEY(item_id)
    REFERENCES item(id)
);

CREATE SEQUENCE item_seq
start with 1
increment by 1
nomaxvalue;

package de.fhg.scai.bio.csr.io.database.communication;

public class REStrategy extends DelegatingReverseEngineeringStrategy {

    public REStrategy(ReverseEngineeringStrategy delegate) {
       super(delegate);
    }

    public String columnToPropertyName(TableIdentifier table, String column) {
       if(column.endsWith("PK")) {
          return "id";
       }
       else {
          return super.columnToPropertyName(table, column);
       }
    }
}

    public Properties getTableIdentifierProperties(TableIdentifier identifier) {
       Properties p = new Properties();
       p.put(key, identifier.getName() + "_seq");
       return p;
    }
}

package de.fhg.scai.bio.csr.io.database.communication;

import java.util.Properties;

import org.hibernate.cfg.reveng.DelegatingReverseEngineeringStrategy;
import org.hibernate.cfg.reveng.ReverseEngineeringStrategy;
import org.hibernate.cfg.reveng.TableIdentifier;


public class REStrategy extends DelegatingReverseEngineeringStrategy {

    public REStrategy(ReverseEngineeringStrategy delegate) {
       super(delegate);
    }

    public String columnToPropertyName(TableIdentifier table, String column) {
       if(column.endsWith("PK")) {
          return "id";
       }
       else {
          return super.columnToPropertyName(table, column);
       }
    }
   
    public String getTableIdentifierStrategyName(TableIdentifier tableIdentifier) {
       return "sequence";
    }
   
    public Properties getTableIdentifierProperties(TableIdentifier identifier) {
       Properties p = new Properties();
       p.put("sequence", identifier.getName() + "_seq");
       return p;
    }
   
}

   public Properties getTableIdentifierProperties(TableIdentifier tableIdentifier) {
      if (super.getPrimaryKeyColumnNames(tableIdentifier).contains("ID")) {
         Properties p = new Properties();
         p.put("sequence", tableIdentifier.getName().toLowerCase() + "_seq");
         return p;
      } else {
         return super.getTableIdentifierProperties(tableIdentifier);
      }
   }

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Apr 26, 2007 4:05:11 PM by Hibernate Tools 3.2.0.beta8 -->
<hibernate-mapping>
    <class name="de.fhg.scai.bio.csr.io.database.hibernate.Atoms" table="ATOMS">
        <composite-id name="id" class="de.fhg.scai.bio.csr.io.database.hibernate.AtomsId">
            <key-property name="id" type="int">
                <column name="ID" precision="22" scale="0" />
            </key-property>
            <key-many-to-one name="molecules" class="de.fhg.scai.bio.csr.io.database.hibernate.Molecules">
                <column name="MOLECULES_ITEM_ID" precision="22" scale="0" />
            </key-many-to-one>
        </composite-id>
        <property name="atomlabel" type="string">
            <column name="ATOMLABEL" length="6" />
        </property>
    </class>
</hibernate-mapping>