Comments (6)
@xmnlab se quiser, é só me dizer qual a query que tem que tem que ser executada que eu coloco ela pra rodar no crontab junto com a que atualiza a materialized view de total por UF.
from alertadengue.
no fim do dia vou dar um PR e te informo aqui o que tem que ser agendado :)
agradecido!
from alertadengue.
na raiz do projeto foi criado uma pasta chamada sql (depois se quiserem trocar, fiquem a vontade) e foi criado um script chamado create_uf_total_chik_view.sql
quando foi pro master ai vai precisar executar esse script.
se quiser dar uma revisada também fique a vontade :)
from alertadengue.
@xmnlab eu vi o comentário na outra issue antes. Dei uma olhada já, e parece tudo certinho. Para a outra view, no cron, nós usamos o REFRES MATERIALIZED VIEW
para atualizar, mas talvez seja melhor rodar o sql completo. Vou deixar essa issue aberta (mudei o asignee pra mim) pra quando fizermos o merge eu atualizar a crontab no servidor.
from alertadengue.
Só um comentário: estamos tentando obter os dados para as demais cidades do RJ, mas por enquanto só temos os dados de Chikungunya para a capital.
from alertadengue.
@xmnlab já adicionei a atualização dessa view no cron. Usei a solução com REFRESH MATERIALIZED VIEW
por que o CREATE
falha quando a view já existe.
from alertadengue.
Related Issues (20)
- feat: Remove 'E-Vigilância' component
- Error in docker container wait on CI
- Memcached is not accessible through the external port to release the cache
- Inconsistencies in 2021 notification table data causing duplicates estimated cases HOT 1
- Enhance visibility of 'Technical Reports' link on 'About Us' page
- Error: Null value in total_cases when querying the historico_alerta table
- Deprecated usage of `float` on single element series
- Error: Date for last update in alert pages doesn't display correctly
- Error: 'Connection' object has no attribute 'cursor' HOT 1
- High latency on homepage due to NotificationResume count_cities_by_uf method in the query execution
- Remove cronjob from dockerfile for Django web container to use celery beat
- Fix valueError in data parsing function
- Refactor `load_sinan` command for DBF upload HOT 1
- [State Alert Refactor] Verify aggregations that generate the charts for the states
- [Alert State Refactor] Fix Last Update date in the State page HOT 2
- Improve logging during upload of SINAN table
- Transformar o Site em um PWA
- Date chart and disease chart not displaying correctly after modal close
- [celery] trigger episcanner tasks when SINAN file is uploaded
- [BUGFIX] "config" method is not defined, should be "os.getenv" HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from alertadengue.