Investigate of old data must be migrated
Closed, ResolvedPublic12 Story Points

Tobi_WMDE_SW updated the task description. (Show Details)
Tobi_WMDE_SW raised the priority of this task from to Normal.
Tobi_WMDE_SW set Security to None.
Tobi_WMDE_SW edited a custom field.
Tobi_WMDE_SW added subscribers: Aklapper, Tobi_WMDE_SW.

At the moment it looks like we won't have many changes to the DB schema that would justify the complexity of this task. I'd propose we drastically reduce the complexity of this task (to 5), add comments comments here if we make changes to the DB and how to (manually) incorporate those changes into an existing database.

Fundraising Store 2.0: Changed date fields in donation and added a subscription table. Removed GUID from membership table.

Migration SQL can be generated with the command

vendor/bin/doctrine orm:schema-tool:update

Do we actually need this for the first demo version? If so, we ought to get to it. I want to help with this, though am not sure what exactly needs doing, where the existing db is, etc.

I did this for the test database and the updates went through without a hitch. We still need to check if the test-backend broke or not.

We need to make sure that the data is retained when applying changes and (as @gabriel-wmde already stated) that the "backend application" still works.

kai.nissen changed the point value for this task from 5 to 20.Jun 3 2016, 3:21 PM

Tested the migration on in the test database with all the data. Took 8 minutes, but had no errors:

mysql> ALTER TABLE spenden CHANGE dt_new dt_new DATETIME NOT NULL;
Query OK, 1765420 rows affected (7 min 27.92 sec)
Records: 1765420  Duplicates: 0  Warnings: 0

mysql> ALTER TABLE request DROP type, DROP guid, CHANGE timestamp timestamp DATETIME NOT NULL, CHANGE dob dob DATE DEFAULT NULL;
Query OK, 17801 rows affected (0.48 sec)
Records: 17801  Duplicates: 0  Warnings: 0

Is this done now?

gabriel-wmde renamed this task from [WMDE-Fundraising] Migrate old data to Investigate of old data must be migrated.Jun 13 2016, 12:30 PM
gabriel-wmde changed the point value for this task from 20 to 12.
gabriel-wmde closed this task as Resolved.

This is done, with a followup here: T137703