Exemple #1
0
 public function remove(Entity &$Entity)
 {
     if (!is_object($Entity)) {
         $e = new InvalidArgument('$Entity must an Entity class');
         $e->setClassName(get_class());
     }
     $Persistence = Persist::checkPersistenceType($Entity, true);
 }
 public static function execute(array $array = [])
 {
     $array['type'] = explode(' ', $array['sql'])[0];
     $array['fn'] = !empty($array['fn']) ? $array['fn'] : false;
     $array['params'] = !empty($array['params']) ? $array['params'] : [];
     if (empty($array['sql'])) {
         $e = new InvalidArgument('sql params not set in QueryBuilder::execute()');
         $e->setClassName(get_class());
     }
     $Connection = Connection::getConnection();
     $request = $Connection->prepare($array['sql']);
     if ($request->execute($array['params'])) {
         $Logger = new Logger(dirname(dirname(__DIR__)) . '/access.log');
         $Logger->add($array['sql']);
     } else {
         $errorInfo = $request->errorInfo();
         $Logger = new Logger(dirname(dirname(__DIR__)) . '/error.log');
         $Logger->add($array['sql'] . ' | ' . $errorInfo[2]);
     }
     if ($array['type'] == 'SELECT' || $array['fn']) {
         if ($array['fn']) {
             $namespace = 'ORM\\QueryBuilder\\Helper\\' . ucfirst(strtolower($array['fn']));
             $Object = new $namespace($request->fetchAll());
             return $Object->getReturn();
         } else {
             $Hydrate = new Hydrate();
             $Hydrate->setSqlResult($request->fetchAll());
             $Entities = $Hydrate->hydrate();
             if (!empty($array['doRelations']) && is_array($array['doRelations'])) {
                 foreach ($Entities as $k => $Entity) {
                     foreach ($array['doRelations'] as $relation) {
                         $relation = ucfirst(strtolower($relation));
                         $e = 'Entity\\' . $relation;
                         $e = new $e();
                         $setter = 'set' . ucfirst(strtolower($e::TABLE));
                         $getter = 'get' . ucfirst(strtolower($e::TABLE));
                         $Relation = $Entity->{$getter}();
                         switch ($Relation::RELATION_TYPE) {
                             case ManyToOne::RELATION_TYPE:
                                 $EntityManager = new Manager();
                                 $table = 'Entity\\' . $relation;
                                 $table = new $table();
                                 $table = $table::TABLE;
                                 ${$relation} = $EntityManager->getRepository('Entity:' . $relation)->findAll();
                                 $join_id = self::query('SELECT ' . strtolower($table) . '_id as join_id FROM ' . $Entity::TABLE . ' WHERE id = ?', [$Entity->getId()])[0]['join_id'];
                                 foreach (${$relation} as $relationFetch) {
                                     if ($relationFetch->getId() == $join_id) {
                                         $Entities[$k]->{$setter}($relationFetch);
                                     }
                                 }
                         }
                     }
                 }
             }
             return $Entities;
         }
     }
     if ($array['type'] == 'INSERT') {
         return $Connection->lastInsertId();
     }
     if ($array['type'] == 'UPDATE') {
         return true;
     }
 }