Project

General

Profile

Anomalie #10852

[Migration MaarchCourrier] sql/1904.sql en erreur

Added by Ludovic ARAUJO over 3 years ago. Updated over 1 year ago.

Status:
Développé / Analysé (S)
Priority:
1-Majeur
Assignee:
Florian AZIZIAN
Target version:
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 over 3 years ago

  • Description updated (diff)

#2 Updated by Emmanuel DILLARD over 3 years ago

  • Status changed from A traiter to Prêt à embarquer

#3 Updated by Emmanuel DILLARD over 3 years ago

  • Status changed from Prêt à embarquer 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 about 3 years ago

Script de migration 19.04
sql/1904.sql
Erreur sur les bannettes redirigées.

#5 Updated by Ludovic ARAUJO about 3 years ago

  • Assignee changed from Ludovic ARAUJO to EDI PO

je n'ai plus la base 18.10.

#9 Updated by Emmanuel DILLARD almost 3 years ago

  • Status changed from 17 to Etude planifiée

#10 Updated by Emmanuel DILLARD almost 3 years ago

  • Status changed from Etude planifiée to Prêt à embarquer
  • Assignee changed from EDI PO to Ludovic ARAUJO

#11 Updated by Emmanuel DILLARD almost 3 years ago

  • Assignee changed from Ludovic ARAUJO to Maarch Courrier DEV TEAM

#12 Updated by Emmanuel DILLARD almost 3 years ago

  • Project changed from Backlog to CURRENT SPRINT
  • Status changed from Prêt à embarquer 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 almost 3 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 almost 3 years ago

  • Assignee changed from Maarch Courrier DEV TEAM to Ludovic ARAUJO

#19 Updated by Henri QUENEAU over 2 years ago

  • Assignee changed from Ludovic ARAUJO to EDI PO
  • Priority changed from 1-Majeur to 0-Bloquant

#21 Updated by Henri QUENEAU over 2 years ago

retester en 19.04.15 et ça ne marche toujours pas

#22 Updated by Emmanuel DILLARD over 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 over 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 over 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 over 2 years ago

  • Assignee changed from EDI PO to Henri QUENEAU

#27 Updated by Emmanuel DILLARD over 2 years ago

  • Status changed from A traiter to Prêt à embarquer

#28 Updated by Emmanuel DILLARD over 2 years ago

  • Status changed from Prêt à embarquer to 17

#30 Updated by Emmanuel DILLARD over 2 years ago

  • Priority changed from 0-Bloquant to 1-Majeur

Lien sur base Drive à fournir par HQU

#32 Updated by Henri QUENEAU over 2 years ago

  • Status changed from 17 to A traiter
  • Assignee changed from Henri QUENEAU to EDI PO

#33 Updated by Emmanuel DILLARD over 2 years ago

  • Status changed from A traiter to Prêt à embarquer
  • Tags Courrier deleted (19.04.12)

#34 Updated by Emmanuel DILLARD over 2 years ago

  • Project changed from Backlog to CURRENT SPRINT
  • Status changed from Prêt à embarquer 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 over 2 years ago

  • Assignee deleted (EDI PO)

#36 Updated by Florian AZIZIAN over 2 years ago

  • Assignee set to Florian AZIZIAN

#37 Updated by Florian AZIZIAN over 2 years ago

  • Status changed from En cours de dev (S) to Développé / Analysé (S)

#38 Updated by Emmanuel DILLARD over 2 years ago

  • Tags Courrier 19.04.17 (08/07) added
  • Tags Courrier deleted (19.04.16 (15/08))

#39 Updated by Emmanuel DILLARD over 2 years ago

  • Project changed from CURRENT SPRINT to Backlog

#40 Updated by Emmanuel DILLARD over 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 over 1 year ago

  • Project changed from Backlog to Backlog Courrier
  • Target version changed from 20.10 Develop to 20.10 (Actif)

Also available in: Atom PDF