phinx
phinx copied to clipboard
cakephp
PHP Database Migrations for Everyone
Hello guys, I would like to propose change database abstraction to `doctrine/dbal`. Look at `cakephp/database`'s (v5) dependency tree: ``` /var/www/html $ composer show cakephp/database --tree cakephp/database 5.0.0 Flexible and powerful...
When using virtual column definition with `Literal` class, migration fails with SQL syntax error on MariaDB as `NOT NULL` or `NULL` are not allowed at the end of column definition....
The documentation says to use the following code when deleting a table: ```php $this->table('table')->drop()->save(); ``` https://book.cakephp.org/phinx/0/en/migrations.html#dropping-a-table But in my opinion it's better using: ```php $this->table('table')->drop()->update(); ``` ...because if the table...
Is it also given as default_ Migration_ Add configuration table to the specified table name_ What is the table prefix specified by prefix? such as ``` 'default_ Migration_ Table '=>'...
These methods would be so useful. 1. insertOrUpdate( $insertion, $update ): Inserts a record with the $insertion values or, if it exists, updates the record with the $update values. Please...
Currently, when using the -s option when running seeds with namespaces, the seeds need to be referred to by their fully qualified class name, and cannot be run with only...
# Issue The following error is returned when seeding a Postgres database where the seeds have values in the identity column. ``` [PDOException] SQLSTATE[428C9]: : 7 ERROR: cannot insert a...
Phinx has a serious design issue IMHO. As far as I can tell, there is **no way to inject anything to migrations**. At least there is a way to do...
Looks like phinx just creates/looks for objects in default schema example: SQL Server Create table will create table in dbo schema. Mysql will create table in database (database same as...
We have discovered a bug that occurs when using Phinx with MariaDB, and trying to update a TIMESTAMP column with `current_timestamp()` as default value. **The error:** `PDOException: SQLSTATE[42000]: Syntax error...
