Exemplos de NilPortugues\Sql\QueryBuilder\Builder MySqlBuilder::write em PHP

Exemplo n.º 1

Arquivo: InstructionFactory.php Projeto: uiot/middleware_mc_srvcl_rest_raise

 /**
  * Get the SQL Instruction String
  * to be used in Prepared Statement
  *
  * @return string
  */
 public function getInstruction()
 {
     return $this->builder->write($this->execute());
 }

Exemplo n.º 2

Arquivo: MySqlBuilderTest.php Projeto: masnathan/sql-query-builder

 /**
  * @test
  */
 public function itShouldWrapColumnAlias()
 {
     $query = new Select('user', array('userId' => 'user_id', 'name' => 'name'));
     $expected = 'SELECT `user`.`user_id` AS `userId`, `user`.`name` AS `name` FROM `user`';
     $this->assertSame($expected, $this->writer->write($query));
 }