build() public static method

public static build ( SetOperation | SetOperation[] $component, array $options = [] ) : string
$component SetOperation | SetOperation[] The component to be built.
$options array Parameters for building.
return string
Exemplo n.º 1
0
 /**
  * @return string
  */
 public function build()
 {
     $ret = 'REPLACE ' . $this->options . ' INTO ' . $this->into;
     if ($this->values != NULL && count($this->values) > 0) {
         $ret .= ' VALUES ' . Array2d::build($this->values);
     } elseif ($this->set != NULL && count($this->set) > 0) {
         $ret .= ' SET ' . SetOperation::build($this->set);
     } elseif ($this->select != NULL && strlen($this->select) > 0) {
         $ret .= ' ' . $this->select->build();
     }
     return $ret;
 }
Exemplo n.º 2
0
 /**
  * @return string
  */
 public function build()
 {
     $ret = 'INSERT ' . $this->options . ' INTO ' . $this->into;
     if ($this->values != NULL && count($this->values) > 0) {
         $ret .= ' VALUES ' . Array2d::build($this->values);
     } elseif ($this->set != NULL && count($this->set) > 0) {
         $ret .= ' SET ' . SetOperation::build($this->set);
     } elseif ($this->select != NULL && count($this->select) > 0) {
         $ret .= ' ' . $this->select->build();
     }
     if ($this->onDuplicateSet != NULL && count($this->onDuplicateSet) > 0) {
         $ret .= ' ON DUPLICATE KEY UPDATE ' . SetOperation::build($this->onDuplicateSet);
     }
     return $ret;
 }
Exemplo n.º 3
0
 /**
  * @return string
  */
 public function build()
 {
     return 'SET ' . OptionsArray::build($this->options) . ' ' . SetOperation::build($this->set);
 }