/** * 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; }