diff options
author | Michal Čihař <michal@cihar.com> | 2017-01-23 13:43:28 +0100 |
---|---|---|
committer | Michal Čihař <michal@cihar.com> | 2017-01-23 13:43:28 +0100 |
commit | 62e9dd1c5bad5da889b1f186270f6376f571419a (patch) | |
tree | 330588021494c1a224b118d3f78f31564276fc82 | |
parent | 955911f00527a6f178106a270c2091f234fdb18d (diff) | |
download | sql-parser-62e9dd1c5bad5da889b1f186270f6376f571419a.zip sql-parser-62e9dd1c5bad5da889b1f186270f6376f571419a.tar.gz sql-parser-62e9dd1c5bad5da889b1f186270f6376f571419a.tar.bz2 |
Adjust examples to new code
Signed-off-by: Michal Čihař <michal@cihar.com>
-rw-r--r-- | CHANGELOG.md | 1 | ||||
-rw-r--r-- | README.md | 12 |
2 files changed, 7 insertions, 6 deletions
diff --git a/CHANGELOG.md b/CHANGELOG.md index e4362a9..ed0af1d 100644 --- a/CHANGELOG.md +++ b/CHANGELOG.md @@ -3,6 +3,7 @@ ## [Unreleased] * Fixed CLI wrappers for new API. +* Fixed README for new API. ## [4.0.0] - 2017-01-23 @@ -48,8 +48,8 @@ echo SqlParser\Utils\Formatter::format($query, array('type' => 'html')); ### Discoverying query type ```php -use SqlParser\Parser; -use SqlParser\Utils\Query; +use PhpMyAdmin\SqlParser\Parser; +use PhpMyAdmin\SqlParser\Utils\Query; $query = 'OPTIMIZE TABLE tbl'; $parser = new Parser($query); @@ -64,16 +64,16 @@ echo $flags['querytype']; require __DIR__."/vendor/autoload.php"; $query1 = "select * from a"; -$parser = new SqlParser\Parser($query1); +$parser = new PhpMyAdmin\SqlParser\Parser($query1); // inspect query -var_dump($parser->statements[0]); // outputs object(SqlParser\Statements\SelectStatement) +var_dump($parser->statements[0]); // outputs object(PhpMyAdmin\SqlParser\Statements\SelectStatement) // modify query by replacing table a with table b -$table2 = new \SqlParser\Components\Expression("", "b", "", ""); +$table2 = new \PhpMyAdmin\SqlParser\Components\Expression("", "b", "", ""); $parser->statements[0]->from[0] = $table2; -// build query again from an array of object(SqlParser\Statements\SelectStatement) to a string +// build query again from an array of object(PhpMyAdmin\SqlParser\Statements\SelectStatement) to a string $statement = $parser->statements[0]; $query2 = $statement->build(); var_dump($query2); // outputs string(19) "SELECT * FROM `b` " |