Anomalie #10852
[Migration MaarchCourrier] sql/1904.sql en erreur
Start date:
06/04/2019
Due date:
Tags Courrier:
19.04.17 (Publiée), 20.03.6 (Publié)
Description
Réaliser pour le CD45
a modifier :
CREATE TABLE redirected_baskets ( id serial NOT NULL, actual_user_id INTEGER NOT NULL, owner_user_id INTEGER NOT NULL, basket_id character varying(255) NOT NULL, group_id INTEGER NOT NULL, CONSTRAINT redirected_baskets_pkey PRIMARY KEY (id), CONSTRAINT redirected_baskets_unique_key UNIQUE (owner_user_id, basket_id, group_id) ) WITH (OIDS=FALSE); INSERT INTO redirected_baskets (owner_user_id, actual_user_id, basket_id, group_id) SELECT users.id, us.id, user_abs.basket_id, usergroups.id FROM usergroups, usergroup_content, user_abs, groupbasket, users, users us where usergroup_content.group_id = usergroups.group_id and usergroup_content.user_id = user_abs.user_abs and users.user_id = user_abs.user_abs and us.user_id = user_abs.new_user and groupbasket.group_id = usergroup_content.group_id and groupbasket.basket_id = user_abs.basket_id;
Remplacer par :
CREATE TABLE redirected_baskets ( id serial NOT NULL, actual_user_id INTEGER NOT NULL, owner_user_id INTEGER NOT NULL, basket_id character varying(255) NOT NULL, group_id INTEGER NOT NULL, CONSTRAINT redirected_baskets_pkey PRIMARY KEY (id)--, --CONSTRAINT redirected_baskets_unique_key UNIQUE (owner_user_id, basket_id, group_id) ) WITH (OIDS=FALSE); --Insertion des lignes (avec les doublons dans la table) INSERT INTO redirected_baskets (owner_user_id, actual_user_id, basket_id, group_id) SELECT users.id, us.id, user_abs.basket_id, usergroups.id FROM usergroups, usergroup_content, user_abs, groupbasket, users, users us where usergroup_content.group_id = usergroups.group_id and usergroup_content.user_id = user_abs.user_abs and users.user_id = user_abs.user_abs and us.user_id = user_abs.new_user and groupbasket.group_id = usergroup_content.group_id and groupbasket.basket_id = user_abs.basket_id; --suppression des lignes en doublons DELETE FROM redirected_baskets a USING redirected_baskets b where a.id > b.id AND a.actual_user_id = b.actual_user_id AND a.owner_user_id = b.owner_user_id AND a.basket_id = b.basket_id;
History
#1 Updated by Ludovic ARAUJO almost 3 years ago
- Description updated (diff)
#2 Updated by Emmanuel DILLARD almost 3 years ago
- Status changed from A traiter to Prêt à développer
#3 Updated by Emmanuel DILLARD almost 3 years ago
- Status changed from Prêt à développer to 17
- Assignee set to Ludovic ARAUJO
- Priority changed from 0-Bloquant to 1-Majeur
Réexpliquer la modification effectuée, la raison.
Quel script ?
Avoir la base avant migration.
#4 Updated by Ludovic ARAUJO over 2 years ago
Script de migration 19.04
sql/1904.sql
Erreur sur les bannettes redirigées.
#5 Updated by Ludovic ARAUJO over 2 years ago
- Assignee changed from Ludovic ARAUJO to EDI PO
je n'ai plus la base 18.10.
#9 Updated by Emmanuel DILLARD over 2 years ago
- Status changed from 17 to Etude planifiée
#10 Updated by Emmanuel DILLARD over 2 years ago
- Status changed from Etude planifiée to Prêt à développer
- Assignee changed from EDI PO to Ludovic ARAUJO
#11 Updated by Emmanuel DILLARD over 2 years ago
- Assignee changed from Ludovic ARAUJO to Maarch Courrier DEV TEAM
#12 Updated by Emmanuel DILLARD over 2 years ago
- Project changed from Backlog to CURRENT SPRINT
- Status changed from Prêt à développer to En cours de dev (S)
- Target version changed from 19.04 (Support sécurité) to 20.03 (Support restreint)
- Tags Courrier 19.04.12 added
#13 Updated by Emmanuel DILLARD over 2 years ago
- Project changed from CURRENT SPRINT to Backlog
- Status changed from En cours de dev (S) to Développé / Analysé (S)
#14 Updated by Emmanuel DILLARD over 2 years ago
- Assignee changed from Maarch Courrier DEV TEAM to Ludovic ARAUJO
#19 Updated by Henri QUENEAU about 2 years ago
- Assignee changed from Ludovic ARAUJO to EDI PO
- Priority changed from 1-Majeur to 0-Bloquant
#21 Updated by Henri QUENEAU about 2 years ago
retester en 19.04.15 et ça ne marche toujours pas
#22 Updated by Emmanuel DILLARD about 2 years ago
- Subject changed from [Migration MaarchCourrier] script sql erreur to [Migration MaarchCourrier] sql/1904.sql en erreur
- Status changed from Développé / Analysé (S) to Etude planifiée
#23 Updated by Emmanuel DILLARD about 2 years ago
- Status changed from Etude planifiée to 17
- Assignee changed from EDI PO to Henri QUENEAU
Pouvons nous disposer d'une BDD en erreur ?
#24 Updated by Henri QUENEAU about 2 years ago
- Status changed from 17 to A traiter
- Assignee changed from Henri QUENEAU to EDI PO
Ce sont des bases de client existant depuis longtemps, elles sont volumineuses.
Y a t'il un espace de dépot dédié ?
#25 Updated by Henri QUENEAU about 2 years ago
- Assignee changed from EDI PO to Henri QUENEAU
#27 Updated by Emmanuel DILLARD about 2 years ago
- Status changed from A traiter to Prêt à développer
#28 Updated by Emmanuel DILLARD about 2 years ago
- Status changed from Prêt à développer to 17
#30 Updated by Emmanuel DILLARD almost 2 years ago
- Priority changed from 0-Bloquant to 1-Majeur
Lien sur base Drive à fournir par HQU
#32 Updated by Henri QUENEAU almost 2 years ago
- Status changed from 17 to A traiter
- Assignee changed from Henri QUENEAU to EDI PO
#33 Updated by Emmanuel DILLARD almost 2 years ago
- Status changed from A traiter to Prêt à développer
- Tags Courrier deleted (
19.04.12)
#34 Updated by Emmanuel DILLARD almost 2 years ago
- Project changed from Backlog to CURRENT SPRINT
- Status changed from Prêt à développer to En cours de dev (S)
- Target version changed from 20.03 (Support restreint) to 20.10 Develop
- Tags Courrier 19.04.16 (15/08), 20.03.6 (15/07) added
Enlever les contraintes, insertion, suppression des doublons
#35 Updated by Florian AZIZIAN almost 2 years ago
- Assignee deleted (
EDI PO)
#36 Updated by Florian AZIZIAN almost 2 years ago
- Assignee set to Florian AZIZIAN
#37 Updated by Florian AZIZIAN almost 2 years ago
- Status changed from En cours de dev (S) to Développé / Analysé (S)
#38 Updated by Emmanuel DILLARD almost 2 years ago
- Tags Courrier 19.04.17 (08/07) added
- Tags Courrier deleted (
19.04.16 (15/08))
#39 Updated by Emmanuel DILLARD almost 2 years ago
- Project changed from CURRENT SPRINT to Backlog
#40 Updated by Emmanuel DILLARD almost 2 years ago
- Tags Courrier 19.04.17 (Publiée), 20.03.6 (Publié) added
- Tags Courrier deleted (
19.04.17 (08/07), 20.03.6 (15/07))
#41 Updated by Emmanuel DILLARD 11 months ago
- Project changed from Backlog to Backlog Courrier
- Target version changed from 20.10 Develop to 20.10 (Actif)