* @copyright 2010-2014 Justin Swanhart and André Rothe * @license http://www.debian.org/misc/bsd.license BSD License (3 Clause) * @version SVN: $Id$ * */ namespace PHPSQLParser\builders; use PHPSQLParser\exceptions\UnableToCreateSQLException; use PHPSQLParser\utils\ExpressionType; /** * This class implements the builder for the PRIMARY KEY statement part of CREATE TABLE. * You can overwrite all functions to achieve another handling. * * @author André Rothe * @license http://www.debian.org/misc/bsd.license BSD License (3 Clause) * */ class PrimaryKeyBuilder implements Builder { protected function buildColumnList($parsed) { $builder = new ColumnListBuilder(); return $builder->build($parsed); } protected function buildConstraint($parsed) { $builder = new ConstraintBuilder(); return $builder->build($parsed); } protected function buildReserved($parsed) { $builder = new ReservedBuilder(); return $builder->build($parsed); } protected function buildIndexType($parsed) { $builder = new IndexTypeBuilder(); return $builder->build($parsed); } protected function buildIndexSize($parsed) { $builder = new IndexSizeBuilder(); return $builder->build($parsed); } protected function buildIndexParser($parsed) { $builder = new IndexParserBuilder(); return $builder->build($parsed); } public function build(array $parsed) { if ($parsed['expr_type'] !== ExpressionType::PRIMARY_KEY) { return ""; } $sql = ""; foreach ($parsed['sub_tree'] as $k => $v) { $len = strlen($sql); $sql .= $this->buildConstraint($v); $sql .= $this->buildReserved($v); $sql .= $this->buildColumnList($v); $sql .= $this->buildIndexType($v); $sql .= $this->buildIndexSize($v); $sql .= $this->buildIndexParser($v); if ($len == strlen($sql)) { throw new UnableToCreateSQLException('CREATE TABLE primary key subtree', $k, $v, 'expr_type'); } $sql .= " "; } return substr($sql, 0, -1); } } ?>