P³ A new story begins

Voici comment se traduit les différentes associations de type One-To-One :

Voici le code PHP produit :

<?php
 
namespace org\rapidoo\demo\onetoone;
 
//-------------------------------------------
//   One-to-one mono navigable with 1 key
//-------------------------------------------
 
class A {
 
    /**
     * The id property.
     * @var int
     */
    private $id;
 
    /**
     * The name property.
     * @var B
     */
    private $b;
 
}
 
class B {
 
    /**
     * The id property.
     * @var int
     */
    private $id;
 
}
 
//-------------------------------------------
//   One-to-one binavigable with 2 keys
//-------------------------------------------
 
class C {
 
    /**
     * The id property.
     * @var int
     */
    private $id;
 
    /**
     * The name property.
     * @var D
     */
    private $d;
 
}
 
class D {
 
    /**
     * The id property.
     * @var int
     */
    private $id;
 
    /**
     * The name property.
     * @var C
     */
    private $c;
}
 
//-------------------------------------------
//   One-to-one binavigable with 1 key
//-------------------------------------------
 
class E {
 
    /**
     * The id property.
     * @var int
     */
    private $id;
 
    /**
     * The name property.
     * @var F
     */
    private $f;
 
}
 
class F {
 
    /**
     * The id property.
     * @var int
     */
    private $id;
 
    /**
     * The name property.
     * @var E
     */
    private $e;
}
 
?>

Le code de mapping relationnel

<?xml version="1.0" encoding="UTF-8"?>
<mapping xmlns="http://schema.emukina.fr/Mapping" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation="http://schema.emukina.fr/Mapping http://schema.emukina.fr/Mapping.xsd" 
package="org.rapidoo.demo.onetoone">
 
	<!-- One-to-one mono navigable with 1 key -->
	<class name="A" table="a">
        <id>
            <property name="id" column="id_a"/>
        </id>
        <one-to-one name="b" column="id_b" type="B" not-null="true"/>
    </class>
    <class  name="B" table="b">
        <id>
            <property name="id" column="id_b"/>
        </id>
    </class>
 
	<!-- One-to-one bi navigable with 2 keys -->
	<class name="C" table="c">
        <id>
            <property name="id" column="id_c"/>
        </id>
        <one-to-one name="d" column="id_d" type="D" not-null="true"/>
    </class>
    <class  name="D" table="d">
        <id>
            <property name="id" column="id_d"/>
        </id>
		<one-to-one name="c" column="id_c" type="C" />
    </class>
 
	<!-- One-to-one bi navigable with 1 key -->
	<class name="E" table="e">
        <id>
            <property name="id" column="id_e"/>
        </id>
        <one-to-one name="f" column="id_f_fk" type="F" not-null="true"/>
    </class>
    <class  name="F" table="f">
        <id>
            <property name="id" column="id_f"/>
        </id>
		<one-to-one name="e" column="id_f" reverse-column="id_f_fk" type="E" not-null="true"/>
    </class>
 
</mapping>

Et enfin le code Sql

---------------------------------------------
--   One-to-one mono navigable with 1 key
---------------------------------------------
 
CREATE TABLE `a` (
    `id_a` INT UNSIGNED  AUTO_INCREMENT,
    `id_b` INT UNSIGNED NOT NULL,
    PRIMARY KEY(`id_a`),
    INDEX `IDX_a_b`(`id_b`) ,
    CONSTRAINT `FK_a_b` FOREIGN KEY (`id_b`) REFERENCES `b`(`id_b`)
);
 
CREATE TABLE `b` (
    `id_b` INT UNSIGNED  AUTO_INCREMENT,
    PRIMARY KEY(`id_b`)
);
 
---------------------------------------------
--   One-to-one binavigable with 2 keys
---------------------------------------------
 
CREATE TABLE `c` (
    `id_c` INT UNSIGNED  AUTO_INCREMENT,
    `id_d` INT UNSIGNED NOT NULL,
    PRIMARY KEY(`id_c`),
    INDEX `IDX_c_d`(`id_d`) ,
    CONSTRAINT `FK_c_d` FOREIGN KEY (`id_d`) REFERENCES `d`(`id_d`)
);
 
CREATE TABLE `d` (
    `id_d` INT UNSIGNED  AUTO_INCREMENT,
    `id_c` INT UNSIGNED NULL,
    PRIMARY KEY(`id_d`),
    INDEX `IDX_d_c`(`id_c`) ,
    CONSTRAINT `FK_d_c` FOREIGN KEY (`id_c`) REFERENCES `c`(`id_c`)
);
 
---------------------------------------------
--   One-to-one binavigable with 1 key
---------------------------------------------
 
CREATE TABLE `e` (
    `id_e` INT UNSIGNED  AUTO_INCREMENT,
    `id_f_fk` INT UNSIGNED ,
    PRIMARY KEY(`id_e`),
    INDEX `IDX_e_f`(`id_f_fk`) ,
    CONSTRAINT `FK_e_f` FOREIGN KEY (`id_f_fk`) REFERENCES `f`(`id_f`)
);
 
CREATE TABLE `f` (
    `id_f` INT UNSIGNED  AUTO_INCREMENT,
    PRIMARY KEY(`id_f`)
);