Exemplos de SQLBuilder\Universal\Query SelectQuery::option em PHP

Exemplo n.º 1

Arquivo: SelectQueryTest.php Projeto: Ruyka/SQLBuilder

 public function testSelectMultipleOptions()
 {
     $query = new SelectQuery();
     $query->option(['SQL_SMALL_RESULT', 'SQL_CALC_FOUND_ROWS', 'MAX_STATEMENT_TIME = 20']);
     $query->select('id');
     $query->from('users', 'u');
     $this->assertSqlStrings($query, [[new MySQLDriver(), "SELECT SQL_SMALL_RESULT SQL_CALC_FOUND_ROWS MAX_STATEMENT_TIME = 20 id FROM users AS u"]]);
 }