예제 #1
0
 private function __construct($dbHandle, $sql, $boundValues, $pdoExecutor)
 {
     $this->_boundValues = $boundValues;
     $this->_dbHandle = $dbHandle;
     $this->_sql = $sql;
     $this->_humanizedSql = QueryHumanizer::humanize($sql);
     $this->_pdoExecutor = $pdoExecutor;
 }
예제 #2
0
 /**
  * @test
  */
 public function shouldNotHumanizeAllAliases()
 {
     //given
     $sql = "SELECT acl.id_group_acl AS id_menu, ts.id_submenu, acl.group_acl AS menu_name, ts.nazwa AS submenu_name, link, new_link, id, acl.group_acl AS acl_group_acl, acl.id_group_acl AS acl_id_group_acl FROM t_submenu AS ts LEFT JOIN t_acl_group AS acl ON acl.id_group_acl = ts.id_menu ORDER BY acl.kolejnosc, ts.kolejnosc, ts.nazwa";
     //when
     $humanized = QueryHumanizer::humanize($sql);
     //then
     $this->assertEquals("SELECT acl.id_group_acl AS id_menu, ts.id_submenu, acl.group_acl AS menu_name, ts.nazwa AS submenu_name, link, new_link, id, acl.group_acl AS acl_group_acl, acl.id_group_acl AS acl_id_group_acl FROM t_submenu AS ts LEFT JOIN t_acl_group AS acl ON acl.id_group_acl = ts.id_menu ORDER BY acl.kolejnosc, ts.kolejnosc, ts.nazwa", $humanized);
 }