PHP Extasy\ORM QueryBuilder::addFields 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: IntegerColumn.php Project: gudwin/extasy

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

Example #3

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 #4

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 #5

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));
 }