PHP PHPSQLParser PHPSQLCreator::create Examples

create() public method

public create ( $parsed )

Example #1

File: issue101Test.php Project: simha95/php-sql-parser

 public function testIssue101()
 {
     $sql = "SELECT tab.col AS `tab.col`, tab2.col AS `tab2.col` FROM tab, tab2";
     $parser = new PHPSQLParser($sql);
     $p = $parser->parsed;
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue101.sql', false);
     $this->assertSame($expected, $created, 'alias with quotes');
 }

Example #2

File: issue118Test.php Project: simha95/php-sql-parser

 public function testIssue118()
 {
     $query = "select organism_name as reference from organisms group by reference";
     $parser = new PHPSQLParser();
     $p = $parser->parse($query);
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue118.sql', false);
     $this->assertSame($expected, $created, 'alias within group by');
 }

Example #3

File: issue127Test.php Project: simha95/php-sql-parser

 public function testIssue127()
 {
     $query = "UPDATE t1 SET c1 = -c2";
     $parser = new PHPSQLParser();
     $p = $parser->parse($query);
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue127.sql', false);
     $this->assertSame($expected, $created, 'unary operator');
 }

Example #4

File: issue121Test.php Project: simha95/php-sql-parser

 public function testIssue121()
 {
     $query = "CREATE TABLE t (mv DECIMAL(3) DEFAULT 10)";
     $parser = new PHPSQLParser();
     $p = $parser->parse($query);
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue121.sql', false);
     $this->assertSame($expected, $created, 'create table with default value');
 }

Example #5

File: issue141Test.php Project: simha95/php-sql-parser

 public function testIssue141()
 {
     $query = "SELECT f FROM t ORDER BY (f-0.0)";
     $parser = new PHPSQLParser();
     $p = $parser->parse($query);
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue141.sql', false);
     $this->assertSame($expected, $created, 'bracket expressions within order-by');
 }

Example #6

File: issue130Test.php Project: simha95/php-sql-parser

 public function testIssue130()
 {
     $query = "select * from t1 order by c2-c1";
     $parser = new PHPSQLParser();
     $p = $parser->parse($query);
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue130.sql', false);
     $this->assertSame($expected, $created, 'expressions within the ORDER-BY clause');
 }

Example #7

File: issue134Test.php Project: simha95/php-sql-parser

 public function testIssue134()
 {
     $query = "select t1.*\n        from Table1 t1\n        STRAIGHT_JOIN  Table2 t2\n        on t1.CommonID = t2.CommonID\n        where t1.FilterID = 1";
     $parser = new PHPSQLParser();
     $p = $parser->parse($query);
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue134.sql', false);
     $this->assertSame($expected, $created, 'a straight_join within from clause');
 }

Example #8

File: magnusTest.php Project: simha95/php-sql-parser

 public function testMagnus()
 {
     $sql = "SELECT\n         u.`id` AS userid,\n        u.`user` AS username,\n         u.`firstname`,\n        u.`lastname`,\n         u.`email`,\n        CONCAT(19, lastname, 2013) AS test\n         FROM\n        `user` u\n         ORDER BY\n         u.`user` DESC";
     $parser = new PHPSQLParser();
     $parsed = $parser->parse($sql);
     $creator = new PHPSQLCreator();
     $created = $creator->create($parsed);
     $expected = getExpectedValue(dirname(__FILE__), 'magnus.sql', false);
     $this->assertSame($expected, $created, 'Aliases for functions.');
 }

Example #9

File: issue126Test.php Project: simha95/php-sql-parser

 public function testIssue126()
 {
     $query = "DELETE FROM t1";
     $parser = new PHPSQLParser();
     $p = $parser->parse($query);
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue126.sql', false);
     $this->assertSame($expected, $created, 'delete statement');
 }

Example #10

File: issue147Test.php Project: simha95/php-sql-parser

 public function testIssue147()
 {
     $query = "SELECT f FROM t WHERE x in (Select x from y)";
     $parser = new PHPSQLParser();
     $p = $parser->parse($query);
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue147.sql', false);
     $this->assertSame($expected, $created, 'subqueries within WHERE clause');
 }

Example #11

File: issue123Test.php Project: simha95/php-sql-parser

 public function testIssue123()
 {
     $query = "CREATE TABLE t1 (c1 CHAR(3),c2 CHAR(3),KEY(c1))";
     $parser = new PHPSQLParser();
     $p = $parser->parse($query);
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue123.sql', false);
     $this->assertSame($expected, $created, 'create table with key column');
 }

Example #12

File: unionTest.php Project: greenlion/php-sql-parser

 public function testUnion3()
 {
     $sql = "SELECT x FROM ((SELECT y FROM  z  WHERE (y > 2) ) UNION ALL (SELECT a FROM z WHERE (y < 2))) as f ";
     $parser = new PHPSQLParser();
     $creator = new PHPSQLCreator();
     $parsed = $parser->parse($sql);
     $created = $creator->create($parsed);
     $expected = getExpectedValue(dirname(__FILE__), 'union3.sql', false);
     $this->assertEquals($expected, $created, 'complicated mysql union');
 }

Example #13

File: issue131Test.php Project: simha95/php-sql-parser

 public function testIssue131()
 {
     $query = "create unique index i1 using BTREE on t1 (c1(5) DESC, `col 2`(8) ASC) ALGORITHM=DEFAULT using hash LOCK=SHARED";
     $parser = new PHPSQLParser();
     $p = $parser->parse($query);
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue131.sql', false);
     $this->assertSame($expected, $created, 'CREATE INDEX statement');
 }

Example #14

File: issue144Test.php Project: simha95/php-sql-parser

 public function testIssue144()
 {
     $query = "SELECT * FROM TableA JOIN TableB USING(Col1, Col2)";
     $parser = new PHPSQLParser();
     $p = $parser->parse($query);
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue144.sql', false);
     $this->assertSame($expected, $created, 'missing commas in Ref clause');
 }

Example #15

File: issue129Test.php Project: simha95/php-sql-parser

 public function testIssue129()
 {
     $query = "DROP TEMPORARY TABLE IF EXISTS t1, t2 CASCADE";
     $parser = new PHPSQLParser();
     $p = $parser->parse($query);
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue129.sql', false);
     $this->assertSame($expected, $created, 'drop table should not fail');
 }

Example #16

File: issue100Test.php Project: simha95/php-sql-parser

 public function testIssue100()
 {
     $query = "SELECT 0 AS Zero FROM table";
     $parser = new PHPSQLParser();
     $p = $parser->parse($query);
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue100.sql', false);
     $this->assertSame($expected, $created, 'lost alias for constants');
 }

Example #17

File: issue117Test.php Project: simha95/php-sql-parser

 public function testIssue117()
 {
     $sql = "(SELECT x FROM table) ORDER BY x";
     $parser = new PHPSQLParser();
     $p = $parser->parse($sql);
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue117.sql', false);
     $this->assertSame($expected, $created, 'parentheses on the first position of statement');
 }

Example #18

File: issue132Test.php Project: simha95/php-sql-parser

 public function testIssue132()
 {
     $query = "select (c1 - c2) AS c3 from t1";
     $parser = new PHPSQLParser();
     $p = $parser->parse($query);
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue132.sql', false);
     $this->assertSame($expected, $created, 'lost alias of expression');
 }

Example #19

File: issue124Test.php Project: simha95/php-sql-parser

 public function testIssue124()
 {
     $query = "SELECT t1.c1, t2.c2 FROM t1 LEFT JOIN t2 ON (LEFT(t1.c2,6) = t2.c1)";
     $parser = new PHPSQLParser();
     $p = $parser->parse($query);
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue124.sql', false);
     $this->assertSame($expected, $created, 'ref clause with function');
 }

Example #20

File: issue_git10Test.php Project: simha95/php-sql-parser

 public function testIssueGit10()
 {
     $query = "SELECT\nREPLACE( f.web_program,'\n', '' ) AS web_program,\nid AS change_id\nFROM\nfile f\nHAVING\nchange_id > :change_id";
     $parser = new PHPSQLParser();
     $p = $parser->parse($query);
     $creator = new PHPSQLCreator();
     $created = $creator->create($p);
     $expected = getExpectedValue(dirname(__FILE__), 'issue_git10.sql', false);
     $this->assertSame($expected, $created, 'alias references should work in HAVING clauses');
 }