src/flowcode/ceibo/builder/QueryBuilder.php
public static function buildRelationQuery($entity, Relation $relation) {
        $relQuery = "";
        $getid = "getId";
        if ($relation->getCardinality() == Relation::$manyToMany) {
            $m = "get" . $relation->getName();
            $relQuery .= "INSERT INTO " . $relation->getTable() . " (" . $relation->getLocalColumn() . ", " . $relation->getForeignColumn() . ") ";
            $relQuery .= "VALUES (:" . $relation->getLocalColumn() . ", :" . $relation->getForeignColumn() . ");";
        }
        if ($relation->getCardinality() == Relation::$oneToMany) {
            $relMapper = MapperBuilder::buildFromName($this->mapping, $relation->getEntity());
            $m = "get" . $relation->getName();
            foreach ($entity->$m() as $rel) {
                $setid = "set" . $relMapper->getNameForColumn($relation->getForeignColumn());
                $rel->$setid($entity->$getid());
                $relQuery .= $this->buildInsertQuery($rel);
            }
        }


        return $relQuery;
    }
public static function buildRelationQuery($entity, Relation $relation) {
        $relQuery = "";
        $getid = "getId";
        if ($relation->getCardinality() == Relation::$manyToMany) {
            $m = "get" . $relation->getName();
            $relQuery .= "INSERT INTO " . $relation->getTable() . " (" . $relation->getLocalColumn() . ", " . $relation->getForeignColumn() . ") ";
            $relQuery .= "VALUES (:" . $relation->getLocalColumn() . ", :" . $relation->getForeignColumn() . ");";
        }
        if ($relation->getCardinality() == Relation::$oneToMany) {
            $relMapper = MapperBuilder::buildFromName($this->mapping, $relation->getEntity());
            $m = "get" . $relation->getName();
            foreach ($entity->$m() as $rel) {
                $setid = "set" . $relMapper->getNameForColumn($relation->getForeignColumn());
                $rel->$setid($entity->$getid());
                $relQuery .= $this->buildInsertQuery($rel);
            }
        }


        return $relQuery;
    }
public static function buildRelationQuery ( $ entity , Relation $ relation ) { $ relQuery = "" ; $ getid = "getId" ; if ( $ relation -> getCardinality ( ) == Relation :: $ manyToMany ) { $ m = "get" . $ relation -> getName ( ) ; $ relQuery .= "INSERT INTO " . $ relation -> getTable ( ) . " (" . $ relation -> getLocalColumn ( ) . ", " . $ relation -> getForeignColumn ( ) . ") " ; $ relQuery .= "VALUES (:" . $ relation -> getLocalColumn ( ) . ", :" . $ relation -> getForeignColumn ( ) . ");" ; } if ( $ relation -> getCardinality ( ) == Relation :: $ oneToMany ) { $ relMapper = MapperBuilder :: buildFromName ( $ this -> mapping , $ relation -> getEntity ( ) ) ; $ m = "get" . $ relation -> getName ( ) ; foreach ( $ entity -> $ m ( ) as $ rel ) { $ setid = "set" . $ relMapper -> getNameForColumn ( $ relation -> getForeignColumn ( ) ) ; $ rel -> $ setid ( $ entity -> $ getid ( ) ) ; $ relQuery .= $ this -> buildInsertQuery ( $ rel ) ; } } return $ relQuery ; }
Return the insert relation query.
@param type $entity
@param Relation $relation
@return string $query.
Return the insert relation query .