search

transparencia-mg / dtamg-py

MIT License
0 stars 0 forks source link

Add retry logic to resources extraction (ie. csv files) from database #16

Closed fjuniorr closed 2 years ago

fjuniorr commented 2 years ago

Fix #9

Branch off #15

gabrielbdornas commented 2 years ago

@fjuniorr fiz o teste rodando o make extract com o banco desligado, sendo retornado o seguinte log:

2022-02-25T10:50:38-0300 ERROR [dtamg_py.utils] (2003, "Can't connect to MySQL server on '192.168.33.11' ([Errno 113] No route to host)")
2022-02-25T10:50:48-0300 INFO  [dtamg_py.utils] 2 retry attempt.
2022-02-25T10:50:51-0300 ERROR [dtamg_py.utils] (2003, "Can't connect to MySQL server on '192.168.33.11' ([Errno 113] No route to host)")
2022-02-25T10:51:01-0300 INFO  [dtamg_py.utils] 3 retry attempt.
2022-02-25T10:51:04-0300 ERROR [dtamg_py.utils] (2003, "Can't connect to MySQL server on '192.168.33.11' ([Errno 113] No route to host)")
2022-02-25T10:51:14-0300 INFO  [dtamg_py.utils] 4 retry attempt.
2022-02-25T10:51:17-0300 ERROR [dtamg_py.utils] (2003, "Can't connect to MySQL server on '192.168.33.11' ([Errno 113] No route to host)")
2022-02-25T10:51:27-0300 INFO  [dtamg_py.utils] 5 retry attempt.
2022-02-25T10:51:30-0300 ERROR [dtamg_py.utils] (2003, "Can't connect to MySQL server on '192.168.33.11' ([Errno 113] No route to host)")
2022-02-25T10:51:40-0300 INFO  [dtamg_py.utils] 6 retry attempt.
2022-02-25T10:51:46-0300 INFO  [dtamg_py.utils] Extraindo recurso ft_receita_v2018...

Assim que o banco foi ligado gerou a conexão e a extração (6 retry attempt).

LGTM :+1: