Sync deputies once a month

This table, "deputy", was added because I wanted to show if a deputy is still active on their detail page, and this table has a column called ultimoStatus_situacao with this information.

This table, "deputy", was added because I wanted to show if a deputy is still active on their detail page, and this table has a column called **ultimoStatus_situacao** with this information.

aniram commented

2026-10-05 17:40:35 +00:00

Author

Owner

I cannot add it to the sync script because it is supposed to be synced more or less once a month and not daily. Add it to a separate cronjob when the time comes.

aniram closed this issue

2026-10-05 17:42:14 +00:00

aniram added reference fix/show-amendments-sum-in-detail-page

2026-10-05 17:44:03 +00:00

aniram changed reference from ~~fix/show-amendments-sum-in-detail-page~~ to feat/add-sync-of-deputies-from-JSON-API

2026-10-05 17:44:35 +00:00

aniram commented

2026-10-05 17:55:16 +00:00

Author

Owner

@aniram wrote in #143 (comment):

This will probably solve problems like this one

This problem here was not purely related to the fact that this deputy was from a different legislature but also due to the detail page using the SUM function which returns NULL in their case while the expected return type was float64.
I've set it to a float64 pointer for now but the best solution is for the detail page to be of the member's last legislature and MAYBE also show other legislatures if possible, currently it fetches data from the current legislature only except for the projects section since its data comes from across all legislatures.
This endpoint gives us all legislatures the deputy was elected for: https://dadosabertos.camara.leg.br/api/v2/deputados/<MEMBER_ID>/historico

We could also hide certain parts of the detail page according to the legislature.

@aniram wrote in https://git.marinabsa.com/overdrives/chambersbr/issues/143#issuecomment-1204: > This will probably solve problems like this one This problem here was not purely related to the fact that this deputy was from a different legislature but also due to the detail page using the SUM function which returns NULL in their case while the expected return type was float64. I've set it to a float64 pointer for now but the best solution is for the detail page to be of the member's last legislature and MAYBE also show other legislatures if possible, currently it fetches data from the current legislature only except for the projects section since its data comes from across all legislatures. This endpoint gives us all legislatures the deputy was elected for: `https://dadosabertos.camara.leg.br/api/v2/deputados/<MEMBER_ID>/historico` We could also hide certain parts of the detail page according to the legislature.

aniram referenced this issue

2026-10-05 18:13:50 +00:00

Navigate between legislatures in Detail Page #153

Rows
Columns

Sync deputies once a month #143