Description
Remove the archived tweet field from historical alert SQL/data generation.
The tweet column is planned for removal from the historical alert tables, but AlertTools still writes it through tabela_historico() and write_alerta().
Required work
- remove
tweet from historical alert output generated by tabela_historico();
- remove
tweet from write_alerta() SQL for dengue, chikungunya and zika historical alert tables;
- keep the generated SQL compatible with:
Municipio.Historico_alerta;
Municipio.Historico_alerta_chik;
Municipio.Historico_alerta_zika;
- review exported
getTweet() and mark it deprecated, archived or unused if it is no longer part of active workflows;
- add tests for tweet-free generated data frames and SQL;
- confirm AlertaDengueAnalise can run with the updated AlertTools.
Out of scope
- dropping the database column;
- changing unrelated historical alert fields;
- changing AlertaDengue API behavior;
- changing production data.
Acceptance criteria
tabela_historico() no longer requires or emits tweet;
write_alerta() no longer writes tweet;
- generated SQL does not reference the
tweet column;
- tests cover dengue, chikungunya and zika SQL generation;
- AlertaDengueAnalise integration path is verified;
- database migration in AlertaDengue is unblocked.
Description
Remove the archived
tweetfield from historical alert SQL/data generation.The
tweetcolumn is planned for removal from the historical alert tables, but AlertTools still writes it throughtabela_historico()andwrite_alerta().Required work
tweetfrom historical alert output generated bytabela_historico();tweetfromwrite_alerta()SQL for dengue, chikungunya and zika historical alert tables;Municipio.Historico_alerta;Municipio.Historico_alerta_chik;Municipio.Historico_alerta_zika;getTweet()and mark it deprecated, archived or unused if it is no longer part of active workflows;Out of scope
Acceptance criteria
tabela_historico()no longer requires or emitstweet;write_alerta()no longer writestweet;tweetcolumn;