Example #1
0
 public function onUpdate(QueryBuilder $query)
 {
     $query->setSet($this->fieldName, serialize($this->value));
 }
Example #2
0
 public function onCreateTable(QueryBuilder $queryBuilder)
 {
     $queryBuilder->addFields(sprintf('`%s` int not null auto_increment', $this->fieldName));
     $queryBuilder->addFields(sprintf('primary key (`%s`) ', $this->fieldName));
     $queryBuilder->setTableOptions('AUTO_INCREMENT=1');
 }
Example #3
0
 public function onCreateTable(QueryBuilder $queryBuilder)
 {
     $queryBuilder->addFields(sprintf('`%s` datetime not null default "0000-00-00 00:00:00"', $this->fieldName));
 }
Example #4
0
 public function onCreateTable(QueryBuilder $queryBuilder)
 {
     $queryBuilder->addFields(sprintf('`%s` varchar(255) not null default ""', $this->fieldName));
 }
Example #5
0
 public function onCreateTable(QueryBuilder $queryBuilder)
 {
     $queryBuilder->addFields(sprintf('`%s` int unsigned not null default 0', $this->fieldName));
 }
Example #6
0
 public function onCreateTable(QueryBuilder $queryBuilder)
 {
     $queryBuilder->addFields(sprintf('`%s` text null', $this->fieldName));
 }
Example #7
0
 public function createDatabaseTable($dropTable = false)
 {
     $fields = $this->getFieldsInfo();
     if ($dropTable) {
         $this->dropTable();
     }
     $queryBuilder = new QueryBuilder('create');
     $queryBuilder->setTableName($fields['table']);
     foreach ($this->columns as $column) {
         $column->onCreateTable($queryBuilder);
     }
     $sql = $queryBuilder->prepare();
     DB::post($sql);
 }