Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Migración #326

Closed
moacirmoda opened this issue Dec 19, 2016 · 9 comments
Closed

Migración #326

moacirmoda opened this issue Dec 19, 2016 · 9 comments
Assignees
@moacirmoda
Labels
complejidad: alta role: administrador severity: critical tipo: task
Milestone
Sprint Dez 1

Comments

@moacirmoda
Copy link
Contributor

moacirmoda commented Dec 19, 2016 •
edited
Loading

Analisar los archivos generados por Mori e intentar crear un script para migrar databases de proethos1 para proethos2.
@moacirmoda moacirmoda self-assigned this Dec 19, 2016
@moacirmoda moacirmoda added this to the Sprint Dez 1 milestone Dec 19, 2016
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
76094bc
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
5876d0a
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
5b30611
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
75ce6e5
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
8fde926
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
514ada4
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
ad7cfdd
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
0c3ec24
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
3c830c8
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
46cbe3c
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
55972ae
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
078008b
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
53e0401
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
9568e3e
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
d85bc6a
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
61b6aa1
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
2093511
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
3b1a5f4
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
cef03bf
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
b56d44f
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
7c5afda
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
7b8617b
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
4a0ea84
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file, #326
5fe04b3
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file /tmp/pr…
1460594 
…oethos2/demo_proethos-2016-08-31-12-44-01.sql, #326
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding version of proethos1 database to see the diffs in file /tmp/pr…
50ca877 
…oethos2/demo_proethos-2016-08-31-12-52-49.sql, #326
moacirmoda added a commit that referenced this issue Dec 26, 2016
@moacirmoda
adding meeting migration, #326
39acb2c
moacirmoda added a commit that referenced this issue Dec 27, 2016
@moacirmoda
part of submission migration, still broke, #326
b6648dc
@moacirmoda
Copy link
Contributor Author

Comentários de reunión de 05/01/02017, entre @trivasf y @moacirmoda:

  • Problema indentificado: La tabela de países de proethos1 no és igual la tabela de países de Proethos2
    • possível solução: utilizar um pais default no momento da migração
  • Problema identificado: Clinical trials no hay padronización en su registros.
    • medida: @trivasf vas enviar un correo para Honduras y Peru verificando se los registros tienen Clinical trials relacionados.

moacirmoda added a commit that referenced this issue Jan 11, 2017
@moacirmoda
adapting function to use in migration, #326
025d255
moacirmoda added a commit that referenced this issue Jan 11, 2017
@moacirmoda
creating field that I can map already migrated protocols, #326
f2381c5
moacirmoda added a commit that referenced this issue Jan 12, 2017
@moacirmoda
enlarge field sizes, #326
c8e5263
moacirmoda added a commit that referenced this issue Jan 13, 2017
@moacirmoda
advances in migration script, #326
ef6721b
This was referenced Jan 13, 2017
Closed
Closed
Closed
moacirmoda added a commit that referenced this issue Jan 17, 2017
@moacirmoda
adjusts on migration script, #326
6acd934
@moacirmoda
Copy link
Contributor Author

New approach:

  • To create status named "Migration" that equals to Submitted.
  • Committee secretaty analyze and follow or delete protocol.

moacirmoda added a commit that referenced this issue Jan 18, 2017
@moacirmoda
importing revisions and changing all protocols to submitted status, #326
03496f1
@moacirmoda
Copy link
Contributor Author

Yo decidi marcar todos los protocolos migrados como "Submitted" para la secretaria analisar los datos generados.

@moacirmoda
Copy link
Contributor Author

moacirmoda commented Jan 23, 2017 •
edited
Loading

  • Hacer una relación entre los paises de proethos1 y proethos2 para migrar los SubmissionCountry.
SELECT 
	DISTINCT(cep.ctr_country), 
    count(cep.ctr_country),
    pais.pais_nome
FROM `cep_submit_country` as cep,
ajax_pais as pais
WHERE cep.ctr_country = pais.id_pais
GROUP BY ctr_country

@moacirmoda
Copy link
Contributor Author

moacirmoda commented Jan 23, 2017 •
edited
Loading

  • Analisar y migrar campos de ensaios clínicos (nombre y numero del registro)
  • remover validación numerica del campo numero del registro.

moacirmoda added a commit that referenced this issue Jan 27, 2017
@moacirmoda
adding country mapping and adding correclty country in users, #326
1848836
moacirmoda added a commit that referenced this issue Jan 27, 2017
@moacirmoda
adding country mapping to protocols, #326
77a22cd
moacirmoda added a commit that referenced this issue Jan 27, 2017
@moacirmoda
changing field type in ClinicalTrials, #326
f0a0b13
moacirmoda added a commit that referenced this issue Feb 7, 2017
@moacirmoda
resolving error in migration, #326
3285035
moacirmoda added a commit that referenced this issue Feb 7, 2017
@moacirmoda
mapping new countries, #326
8b565b5
@moacirmoda
Copy link
Contributor Author

Migración de Peru: Fue adicionado una nueva relación del país Peru. No hay ensayos clínicos.

@moacirmoda
Copy link
Contributor Author

Vamos aguardar Ovidio analisar los datos en el ambiente consult para después adicionar los datos de Peru.

@renatomurasaki
Copy link
Contributor

Ovidio concluyó la validación y confirmó que todo está ok. Aguardando validación de Jenny por parte de Peru.

@renatomurasaki
Copy link
Contributor

Exportacion de Peru ok. Hay un error al acceder a los documentos adjuntos, pero ya fue abierto issue especifico #340

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@moacirmoda moacirmoda

Labels
complejidad: alta role: administrador severity: critical tipo: task
Projects
None yet
Milestone
Sprint Dez 1
Development

No branches or pull requests
2 participants
@moacirmoda @renatomurasaki