Append() закрытый публичный Метод

final public Append ( $QueryString )
Пример #1
0
 private function AppendOnDuplicateKeyUpdate(QueryBuilder $QueryBuilder, $TableName, array $Columns, array $PrimaryKeyIdentifiers)
 {
     $QueryBuilder->Append(' ON DUPLICATE KEY UPDATE ');
     $FirstPrimaryKey = true;
     foreach ($QueryBuilder->Delimit($Columns, ',') as $ColumName => $Column) {
         $ColumnIdentifier = [$TableName, $ColumName];
         if ($FirstPrimaryKey && $Column->IsPrimaryKey()) {
             /*
              * Ugly fix/hack to prevent mysql from updating primary key when encountering
              * a duplicate value on a seperate unique constraint. Sadly Mysql does not support
              * the more robust 'MERGE' operation. Furthermore there is no clean way to throw a 
              * conditional runtime error in Mysql reliably.
              * 
              * Example: Persisting a account entity with a unique username, if the user changes
              * their username and and a duplicate username exists, mysql could attempt to update
              * the other duplicate row with the new values/primary key. This should not be an 
              * issue as then it will fail with a duplicate primary key but could lead to some 
              * wacky edge cases that I want no part in.
              */
             $QueryBuilder->AppendIdentifier('# = IF(', $ColumnIdentifier);
             foreach ($QueryBuilder->Delimit($PrimaryKeyIdentifiers, ' AND ') as $PrimaryKeyIdentifier) {
                 $QueryBuilder->AppendIdentifier('# = VALUES(#)', $PrimaryKeyIdentifier);
             }
             $QueryBuilder->Append(',');
             $QueryBuilder->AppendIdentifier('VALUES(#)', $ColumnIdentifier);
             $QueryBuilder->Append(',');
             $QueryBuilder->Append('(SELECT 1 UNION ALL SELECT 1))');
             $FirstPrimaryKey = false;
         } else {
             $QueryBuilder->AppendIdentifier('# = VALUES(#)', $ColumnIdentifier);
         }
     }
 }
Пример #2
0
 protected function AppendRange(QueryBuilder $QueryBuilder, $Offset, $Limit)
 {
     $QueryBuilder->Append(' ');
     if ($Limit === null) {
         $QueryBuilder->Append('LIMIT 18446744073709551615');
     } else {
         $QueryBuilder->AppendValue('LIMIT #', $Limit, Queries\ParameterType::Integer);
     }
     $QueryBuilder->Append(' ');
     $QueryBuilder->AppendValue('OFFSET #', $Offset, Queries\ParameterType::Integer);
 }
Пример #3
0
 protected function AppendCriterion(QueryBuilder $QueryBuilder, Relational\Criterion $Criterion)
 {
     if ($Criterion->IsConstrained()) {
         $QueryBuilder->Append('WHERE ');
     }
     $QueryBuilder->AppendCriterion($Criterion);
 }
Пример #4
0
 protected function AppendIf(QueryBuilder $QueryBuilder, E\IfExpression $Expression)
 {
     $QueryBuilder->Append('CASE WHEN ');
     $this->Append($QueryBuilder, $Expression->GetConditionExpression());
     $QueryBuilder->Append(' THEN ');
     $this->Append($QueryBuilder, $Expression->GetIfTrueExpression());
     $QueryBuilder->Append(' ELSE ');
     $this->Append($QueryBuilder, $Expression->GetIfFalseExpression());
     $QueryBuilder->Append(' END ');
 }
Пример #5
0
 protected function AppendLiteral(QueryBuilder $QueryBuilder, E\LiteralExpression $Expression)
 {
     $QueryBuilder->Append($Expression->GetString());
 }
Пример #6
0
 public function AppendNotNullable(QueryBuilder $QueryBuilder, Traits\NotNullable $Trait)
 {
     $QueryBuilder->Append('NOT NULL');
 }
Пример #7
0
 public function Index(QueryBuilder $QueryBuilder, Table $Table, Mysql\Tables\Index $Trait)
 {
     $QueryBuilder->AppendIdentifier($this->MapIndexType($Trait->GetType()) . ' INDEX # ', [$Trait->GetName()]);
     $QueryBuilder->Append('(');
     $First = true;
     foreach ($Trait->GetColumns() as $Column) {
         if ($First) {
             $First = false;
         } else {
             $QueryBuilder->Append(',');
         }
         $ColumnName = $Column->GetName();
         $QueryBuilder->AppendIdentifier('#', [$ColumnName]);
         $QueryBuilder->Append(' ' . $this->MapIndexDirection($Trait->GetColumnDirection($QueryBuilder)));
     }
     $QueryBuilder->Append(')');
     $StorageType = $Trait->GetStorageType();
     if ($StorageType !== null) {
         $QueryBuilder->Append('USING' . $this->MapIndexStorageType($Trait->GetStorageType()));
     }
 }
Пример #8
0
 public function AppendDataAsInlineRow(QueryBuilder $QueryBuilder, array $Columns, Relational\ColumnData $ColumnData)
 {
     $QueryBuilder->Append(' SELECT ');
     foreach ($QueryBuilder->Delimit($Columns, ', ') as $Column) {
         $QueryBuilder->AppendExpression(Expression::PersistData($Column, Expression::Constant($ColumnData[$Column])));
     }
 }
Пример #9
0
 protected function AppendIf(QueryBuilder $QueryBuilder, E\IfExpression $Expression)
 {
     $QueryBuilder->Append('IF');
     $QueryBuilder->Append('(');
     $this->Append($QueryBuilder, $Expression->GetConditionExpression());
     $QueryBuilder->Append(',');
     $this->Append($QueryBuilder, $Expression->GetIfTrueExpression());
     $QueryBuilder->Append(',');
     $this->Append($QueryBuilder, $Expression->GetIfFalseExpression());
     $QueryBuilder->Append(')');
 }
Пример #10
0
 private function AppendColumnPosition(QueryBuilder $QueryBuilder, Column $PreviousColumn = null)
 {
     return $PreviousColumn === null ? $QueryBuilder->Append('FIRST') : $QueryBuilder->AppendIdentifier('AFTER #', [$PreviousColumn->GetName()]);
 }