Migrate data from django-invitation to django-invitations about comics HOT 1 CLOSED

All Django database migrations shipped with Comics must work both for existing installations that are upgraded and fresh installations without any existing data. Since new installations of Comics 3.0 will never have any trace of django-invitation in their database, we cannot ship a data migration that depends on those database tables being present.

Instead, the following manual data migration will be added to the 3.0 release notes:

Since we've changed invitation system from django-invitation (singular) to django-invitations (plural), a new database table are used to keep track of the invitations. If you want to keep historical data of old invitations, you can migrate the old data into the new table by running the following SQL query:

INSERT INTO invitations_invitation (id, email, accepted, created, key, sent, inviter_id)
SELECT
    invite.id,
    registrant.email,
    'true',
    invite.date_invited,
    COALESCE(NULLIF(invite.key, ''), 'unknown-invite-key-' || invite.id),
    invite.date_invited,
    invite.from_user_id
FROM
    invitation_invitationkey AS invite
    JOIN auth_user AS registrant ON (invite.registrant_id = registrant.id);

SELECT setval('invitations_invitation_id_seq', (SELECT max(id) FROM invitations_invitation))

After the upgrade is done, and you've migrated any invitation data you want to keep, you can optionally delete the old tables as they are no longer in use:

DROP TABLE invitation_invitationkey;
DROP TABLE invitation_invitationuser;

from comics.