1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109:
<?php
namespace CzProject\SqlGenerator;
class SqlDocument
{
private $statements = array();
public function addStatement(IStatement $statement)
{
$this->statements[] = $statement;
return $this;
}
public function isEmpty()
{
return empty($this->statements);
}
public function toSql(IDriver $driver)
{
$output = '';
foreach ($this->statements as $statement) {
$output .= "\n";
$output .= $statement->toSql($driver);
$output .= "\n";
}
return $output;
}
public function insert($tableName, array $data)
{
$statement = new Statements\Insert($tableName, $data);
$this->addStatement($statement);
return $statement;
}
public function createTable($tableName)
{
$statement = new Statements\CreateTable($tableName);
$this->addStatement($statement);
return $statement;
}
public function dropTable($tableName)
{
$statement = new Statements\DropTable($tableName);
$this->addStatement($statement);
return $statement;
}
public function renameTable($oldTable, $newTable)
{
$statement = new Statements\RenameTable($oldTable, $newTable);
$this->addStatement($statement);
return $statement;
}
public function alterTable($tableName)
{
$statement = new Statements\AlterTable($tableName);
$this->addStatement($statement);
return $statement;
}
}