PHP Extasy\ORM QueryBuilder Examples

Example #1

File: BelongsTo.php Project: gudwin/extasy

 public function onCreateTable(\Extasy\ORM\QueryBuilder $queryBuilder)
 {
     $queryBuilder->addFields(sprintf('`%s` int not null default 0', $this->szFieldName));
     if (!empty($this->fieldInfo['index'])) {
         $queryBuilder->addFields(sprintf('index `search_%s` (`%s`)', $this->szFieldName, $this->szFieldName));
     }
 }

Example #2

File: TimeAccess.php Project: gudwin/extasy

 public function onUpdate(\Extasy\ORM\QueryBuilder $query)
 {
     $query->setSet($this->szFieldName, serialize($this->aValue));
 }

Example #3

File: IntegerColumn.php Project: gudwin/extasy

 public function onCreateTable(\Extasy\ORM\QueryBuilder $queryBuilder)
 {
     $queryBuilder->addFields(sprintf('`%s` int not null default 0', $this->szFieldName));
 }

Example #4

File: Graphical_text.php Project: gudwin/extasy

 public function Update(\Extasy\ORM\QueryBuilder $query)
 {
     $query->setSet($this->szFieldName, $this->aValue);
     $this->generateImage();
 }

Example #5

File: Index.php Project: gudwin/extasy

 public function onCreateTable(\Extasy\ORM\QueryBuilder $queryBuilder)
 {
     $queryBuilder->addFields(sprintf('`%s` int not null auto_increment', $this->szFieldName));
     $queryBuilder->addFields(sprintf('primary key (`%s`) ', $this->szFieldName));
     $queryBuilder->setTableOptions('AUTO_INCREMENT=1');
 }

Example #6

File: Limited_text.php Project: gudwin/extasy

 function onUpdate(\Extasy\ORM\QueryBuilder $query)
 {
     $this->formatValue();
     //
     $query->setSet($this->szFieldName, $this->aValue);
 }

Example #7

File: Model.php Project: gudwin/extasy

 public function createDatabaseTable($dropTable = false)
 {
     $fields = static::getFieldsInfo();
     if ($dropTable) {
         $sql = sprintf('DROP TABLE IF EXISTS `%s`', $fields['table']);
         DB::post($sql);
     }
     $queryBuilder = new \Extasy\ORM\QueryBuilder('create');
     $queryBuilder->setTableName($fields['table']);
     foreach ($this->columns as $column) {
         $column->onCreateTable($queryBuilder);
     }
     $sql = $queryBuilder->prepare();
     DB::post($sql);
 }

Example #8

File: Calculated.php Project: gudwin/extasy

 function onUpdate(\Extasy\ORM\QueryBuilder $query)
 {
     $this->aValue = $this->calculateValue();
     $query->setSet($this->szFieldName, $this->aValue);
 }

Example #9

File: Model.php Project: gudwin/extasy

 public function delete()
 {
     $queryBuilder = new QueryBuilder('delete');
     $queryBuilder->setFrom(static::getTableName());
     foreach ($this->columns as $column) {
         $column->onDelete($queryBuilder);
     }
     $sql = $queryBuilder->prepare();
     DB::post($sql);
     EventController::callEvent('document_delete', $this);
     // unset all columns
     foreach ($this->columns as $key => $row) {
         unset($this->columns[$key]);
     }
     $this->columns = [];
 }

Example #10

File: Static_rubricator.php Project: gudwin/extasy

 /**
  * (non-PHPdoc)
  * @see \Extasy\Columns\BaseColumn::onInsert()
  */
 function onInsert(\Extasy\ORM\QueryBuilder $query)
 {
     $values = serialize($this->aValue);
     $query->setSet($this->szFieldName, $this->aValue);
 }

Example #11

File: testResultColumn.php Project: gudwin/extasy

 /**
  * 
  */
 public function onUpdate(\Extasy\ORM\QueryBuilder $query)
 {
     $value = $this->getSerializedValue();
     $query->setSet($this->szFieldName, $value);
 }

Example #12

File: Datetime.php Project: gudwin/extasy

 public function onCreateTable(\Extasy\ORM\QueryBuilder $queryBuilder)
 {
     $queryBuilder->addFields(sprintf('`%s` datetime not null default "0000-00-00 00:00:00"', $this->szFieldName));
 }

Example #13

File: Boolean.php Project: gudwin/extasy

 public function onCreateTable(\Extasy\ORM\QueryBuilder $queryBuilder)
 {
     $queryBuilder->addFields(sprintf('`%s` bool not null default 0', $this->szFieldName));
     $queryBuilder->addFields(sprintf('index `search_%s` (`%s`)', $this->szFieldName, $this->szFieldName));
 }