DoctrineMigrations | Use Phinx | Data Migration library

Let's take a PostgreSQL DB with the following structure:

(all the relations from top to down are OneToMany)

Where a Brandlift always has exactly 2 brandlift_question each having 1 brandlift_answer (itself having many brandlift_answer_content) by brandlift_respondent

Goal:

Given a 'brand' (let's call it the "flagship brand")
and a brandlift.campaign_id,

for each brand of this brandlift,
retrieve by respondent segment,
the count of brand.id = 'answer_content.brand_id' of the second (right) question answers,
where the previous (left) question answer of the same respondent has an answer_content.brand_id equal to the "flagship brand" id

Sample data (dump) :
https://dbfiddle.uk/?rdbms=postgres_12&fiddle=a127374b9a327204db40dc9f4e769fc1

After I had a bug in php my admin I deleted all the tables from it to solve it.

Now I want to rebuild my database using doctrine migrations (but not the very last migration as it is the one which caused the bug).

How can I make a migration at an previous state?

Edit : by doing the migrate command it recreates my table however everytime I try a new

On Symfony 5 with Doctrine Migrations 2.2.0 I want to execute a custom doctrine migration file. My entities are created with InnoDB utf8mb4_unicode_ci (default value in doctrine.yaml).

When I execute bin/console doctrine:migrations:status --show-versions I get :

I'm using / setting up the Symfony DoctrineMigrationsBundle v2.2 configured as followed:

What is the best way to reset the database along with the migrations.

Here is what I have tried.

1. Delete all migrations along with deleting all the database tables. Then running

php bin/console doctrine:mi:diff

php bin/console doctrine:mi:mi

That does not work.

1. Try running single version at a time like so

php bin/console doctrine:migrations:migrate 'DoctrineMigrations\Version20200722104913'

1. I tried this:

php bin/console doctrine:database:drop --force

php bin/console doctrine:database:create

php bin/console doctrine:mi:mi

The Problem (in detail):

Everything I do leads me to the same result.

Doctrine thinks that I still have some tables to generate which are long gone (Not in the Enitity anymore)

That's why I have this error:

An exception occurred while executing 'DROP TABLE greetings_card_category':

SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'symfony.greetings_card_category'

I also get this warning

[WARNING] You have 6 previously executed migrations in the database that are not registered migrations.

In my migrations Directory I only have two migrations:

There was a recent upgrade to doctrine-migrations version 3, that came as part of a vendor library upgrade, so we are kind of forced to follow now ;)

We configured it like this:

I have a project built on Symfony 3.4 with Flex and I've added phpstan to it for static analysis.

It is complaining about not finding my migration classes:

Class DoctrineMigrations\Version20180831185050 was not found while trying to analyse it - autoloading is probably not configured properly.

Indeed, the files generated by Doctrine Migrations don't fit with the autoloader pattern, but works just fine otherwise.

Is there anything I can do to stop complaining about this?

I follow the book the fast track, chapter '8.7 Migrer la base de données'.

I have my 2 Entities classes properly generated via symfony console make:entity :

I'm trying to create a table into a sql server by making a migration for the entity I just created, but it throws an exception when executing the query: