/**
* AddIndex constructor.
* @param string $table
* @param array $columnNames
* @param string $indexName
*/
public function __construct($table, $columnNames, $indexName)
{
$columns = array();
$columnNamesOnly = array();
foreach ($columnNames as $columnName) {
$columnName = str_replace(' ', '', $columnName);
// eg "column_name (10)" => "column_name(10)"
preg_match('/^([\\w]+)(\\(?\\d*\\)?)$/', $columnName, $matches);
// match "column_name" and "column_name(10)"
$nameOnly = $matches[1];
// eg "column_name"
$columnNamesOnly[] = $nameOnly;
$column = "`{$nameOnly}`";
if (!empty($matches[2])) {
$column .= ' ' . $matches[2];
// eg "(10)"
}
$columns[] = $column;
}
if (empty($indexName)) {
$indexName = $this->indexNamePrefix . '_' . implode('_', $columnNamesOnly);
}
$sql = sprintf("ALTER TABLE `%s` ADD %s %s (%s)", $table, $this->indexType, $indexName, implode(', ', $columns));
parent::__construct($sql, array(static::ERROR_CODE_DUPLICATE_KEY, static::ERROR_CODE_KEY_COLUMN_NOT_EXISTS));
}
public function __construct($table, $columnName, $columnType, $placeColumnAfter)
{
$sql = sprintf("ALTER TABLE `%s` ADD COLUMN `%s` %s", $table, $columnName, $columnType);
if (!empty($placeColumnAfter)) {
$sql .= sprintf(' AFTER `%s`', $placeColumnAfter);
}
parent::__construct($sql, static::ERROR_CODE_DUPLICATE_COLUMN);
}
public function __construct($table, $columnName)
{
$sql = sprintf("ALTER TABLE `%s` DROP COLUMN `%s`", $table, $columnName);
if (!empty($placeColumnAfter)) {
$sql .= sprintf(' AFTER `%s`', $placeColumnAfter);
}
parent::__construct($sql, static::ERROR_CODE_COLUMN_NOT_EXISTS);
}
public function __construct($table, $columns)
{
$changes = array();
foreach ($columns as $columnName => $columnType) {
$changes[] = sprintf("CHANGE `%s` `%s` %s", $columnName, $columnName, $columnType);
}
$sql = sprintf("ALTER TABLE `%s` %s", $table, implode(', ', $changes));
parent::__construct($sql, static::ERROR_CODE_UNKNOWN_COLUMN);
}
public function __construct($table, $columns, $placeColumnAfter)
{
$changes = array();
foreach ($columns as $columnName => $columnType) {
$part = sprintf("ADD COLUMN `%s` %s", $columnName, $columnType);
if (!empty($placeColumnAfter)) {
$part .= sprintf(' AFTER `%s`', $placeColumnAfter);
$placeColumnAfter = $columnName;
}
$changes[] = $part;
}
$sql = sprintf("ALTER TABLE `%s` %s", $table, implode(', ', $changes));
parent::__construct($sql, static::ERROR_CODE_DUPLICATE_COLUMN);
}
public function __construct()
{
parent::__construct();
}
/**
*
* @param string|boolean $tabela Define o nome da tabela. Caso não seja definido, usa o nome da classe como tabela
*/
public function __construct($tabela = FALSE)
{
parent::__construct();
$this->erros = array();
$this->mapaSql = $this->prepare = $this->consulta = array();
$this->dt_insert = $this->dt_update = Data::sqlAgora();
if (isset($_SESSION['usuario'])) {
$this->usuarioLogado = unserialize($_SESSION['usuario']);
$this->user_insert = $this->user_last_update = $this->usuarioLogado->get_idUsuario();
$this->tipo_usuario_insert = $this->tipo_usuario_update = $this->usuarioLogado->get_tipoUsuarioAtivo()->get_idTipoUsuario();
} else {
$this->usuarioLogado = null;
$this->user_insert = $this->user_last_update = 0;
}
$this->mapearVar('id', PDO::PARAM_INT, 11, TRUE)->mapearVar('user_insert', PDO::PARAM_INT)->mapearVar('tipo_usuario_insert', PDO::PARAM_INT)->mapearVar('user_last_update', PDO::PARAM_INT)->mapearVar('tipo_usuario_update', PDO::PARAM_INT)->mapearVar('dt_insert', PDO::PARAM_STR, 20, FALSE, 2)->mapearVar('dt_update', PDO::PARAM_STR, 20, FALSE, 2);
$this->tentativasCriar = 5;
$this->autoCriarTabelas = FALSE;
if (is_string($tabela)) {
$this->tabela = $tabela;
$this->setEsquema(substr($this->tabela, 0, strpos($this->tabela, ".")));
} else {
$this->autoEsquema()->setTabela();
}
}
public function __construct($table, $oldColumnName, $newColumnName, $columnType)
{
$sql = sprintf("ALTER TABLE `%s` CHANGE `%s` `%s` %s", $table, $oldColumnName, $newColumnName, $columnType);
parent::__construct($sql, array(static::ERROR_CODE_DUPLICATE_COLUMN, static::ERROR_CODE_UNKNOWN_COLUMN));
}
/**
* AddPrimaryKey constructor.
* @param string $table
* @param array $columnNames
*/
public function __construct($table, $columnNames)
{
$sql = sprintf("ALTER TABLE `%s` ADD PRIMARY KEY(`%s`)", $table, implode('`, `', $columnNames));
parent::__construct($sql, array(static::ERROR_CODE_DUPLICATE_KEY, static::ERROR_CODE_KEY_COLUMN_NOT_EXISTS));
}
public function __construct(\Gacela\Criteria $criteria = null)
{
$this->_operators['null'] = '=';
$this->_operators['notNull'] = '!=';
parent::__construct($criteria);
}
public function __construct()
{
parent::__construct();
$this->countTry = 10;
}
