LGO44 commented 1 year ago

Myelectricaldata ne remonte que des zéro pour mes 2 compteurs depuis 3 jours logs: 2023-01-09 09:43:30.423 - INFO : => 0 2023-01-09 09:43:30.424 - INFO : last_month 2023-01-09 09:43:30.429 - INFO : => 0 2023-01-09 09:43:30.430 - INFO : current_month 2023-01-09 09:43:30.435 - INFO : => 0 2023-01-09 09:43:30.436 - INFO : current_month_last_year 2023-01-09 09:43:30.441 - INFO : => 0 2023-01-09 09:43:30.442 - INFO : last_month_last_year 2023-01-09 09:43:30.447 - INFO : => 0 2023-01-09 09:43:30.447 - INFO : current_year 2023-01-09 09:43:30.454 - INFO : => 0 2023-01-09 09:43:30.455 - INFO : current_year_last_year 2023-01-09 09:43:30.460 - INFO : => 0 2023-01-09 09:43:30.461 - INFO : last_year 2023-01-09 09:43:30.465 - INFO : => 0 2023-01-09 09:43:30.466 - INFO : yesterday_hp / yesterday_hc 2023-01-09 09:43:30.471 - INFO : => HC : 0 2023-01-09 09:43:30.472 - INFO : => HP : 0 2023-01-09 09:43:30.473 - INFO : peak_offpeak_percent_hp VS peak_offpeak_percent_hc 2023-01-09 09:43:30.478 - INFO : => 0 2023-01-09 09:43:30.479 - INFO : current_week_evolution 2023-01-09 09:43:30.480 - INFO : => 0 2023-01-09 09:43:30.481 - INFO : current_month_evolution 2023-01-09 09:43:30.482 - INFO : => 0 2023-01-09 09:43:30.482 - INFO : yesterday_evolution 2023-01-09 09:43:30.483 - INFO : yesterday 2023-01-09 09:43:30.488 - INFO : => 0 2023-01-09 09:43:30.488 - INFO : yesterday_1 2023-01-09 09:43:30.493 - INFO : => 0 2023-01-09 09:43:30.494 - INFO : => 0 2023-01-09 09:43:30.494 - INFO : monthly_evolution 2023-01-09 09:43:30.495 - INFO : last_month 2023-01-09 09:43:30.504 - INFO : => 0 2023-01-09 09:43:30.507 - INFO : last_month_last_year 2023-01-09 09:43:30.516 - INFO : => 0 2023-01-09 09:43:30.517 - INFO : => 0 2023-01-09 09:43:30.985 - INFO : current_week 2023-01-09 09:43:30.995 - INFO : => 0 2023-01-09 09:43:31.000 - INFO : last_week 2023-01-09 09:43:31.010 - INFO : => 0 2023-01-09 09:43:31.010 - INFO : current_week_last_year 2023-01-09 09:43:31.020 - INFO : => 0 2023-01-09 09:43:31.020 - INFO : last_month 2023-01-09 09:43:31.028 - INFO : => 0 2023-01-09 09:43:31.032 - INFO : current_month 2023-01-09 09:43:31.041 - INFO : => 0 2023-01-09 09:43:31.041 - INFO : current_month_last_year 2023-01-09 09:43:31.051 - INFO : => 0 2023-01-09 09:43:31.051 - INFO : last_month_last_year 2023-01-09 09:43:31.058 - INFO : => 0 2023-01-09 09:43:31.059 - INFO : current_year 2023-01-09 09:43:31.064 - INFO : => 0 2023-01-09 09:43:31.064 - INFO : current_year_last_year 2023-01-09 09:43:31.075 - INFO : => 0 2023-01-09 09:43:31.077 - INFO : last_year 2023-01-09 09:43:31.082 - INFO : => 0 2023-01-09 09:43:31.083 - INFO : yesterday_hp / yesterday_hc 2023-01-09 09:43:31.089 - INFO : => HC : 0 2023-01-09 09:43:31.089 - INFO : => HP : 0 2023-01-09 09:43:31.090 - INFO : peak_offpeak_percent_hp VS peak_offpeak_percent_hc 2023-01-09 09:43:31.095 - INFO : => 0 2023-01-09 09:43:31.096 - INFO : current_week_evolution 2023-01-09 09:43:31.097 - INFO : => 0 2023-01-09 09:43:31.097 - INFO : current_month_evolution 2023-01-09 09:43:31.098 - INFO : => 0 2023-01-09 09:43:31.099 - INFO : yesterday_evolution 2023-01-09 09:43:31.099 - INFO : yesterday 2023-01-09 09:43:31.111 - INFO : => 0 2023-01-09 09:43:31.112 - INFO : yesterday_1 2023-01-09 09:43:31.124 - INFO : => 0 2023-01-09 09:43:31.126 - INFO : => 0 2023-01-09 09:43:31.127 - INFO : monthly_evolution 2023-01-09 09:43:31.128 - INFO : last_month 2023-01-09 09:43:31.136 - INFO : => 0 2023-01-09 09:43:31.137 - INFO : last_month_last_year 2023-01-09 09:43:31.142 - INFO : => 0 2023-01-09 09:43:31.143 - INFO : => 0 2023-01-09 09:43:31.584 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 09:43:31.590 - INFO : EXPORT TERMINÉ 2023-01-09 09:43:31.590 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 09:43:31.590 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 09:43:31.591 - INFO : EXPORTATION INFLUXDB 2023-01-09 09:43:31.591 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 09:43:31.591 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 09:43:31.591 - INFO : [14881765491878] EXPORTATION DES DONNÉES "CONSUMPTION" DANS INFLUXDB 2023-01-09 09:43:31.592 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 09:43:31.598 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 09:43:31.599 - INFO : [14881765491878] EXPORTATION DES DONNÉES "CONSUMPTION_DETAIL" DANS INFLUXDB 2023-01-09 09:43:31.600 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 09:43:31.605 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 09:43:31.606 - INFO : EXPORT TERMINÉ 2023-01-09 09:43:31.608 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 09:43:31.608 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 09:43:31.609 - INFO : ▌│█║▌║▌║ ____ ║▌║▌║█│▌ 2023-01-09 09:43:31.610 - INFO : ▌│█║▌║▌║ | | | |_ | |() _ () | | | || || | ║▌║▌║█│▌ 2023-01-09 09:43:31.610 - INFO : ▌│█║▌║▌║ | | | ' ` \ | ' \ / \ | '|| | | | | || ' \ | |/ || ' \ | || || | ║▌║▌║█│▌ 2023-01-09 09:43:31.614 - INFO : ▌│█║▌║▌║ | | | | | | | || |) || () || | | | | | | || | | || |_ | | | ||||||_| ║▌║▌║█│▌ 2023-01-09 09:43:31.615 - INFO : ▌│█║▌║▌║ |__||| || ||| ./ __/ || _| || |||| |||||__/|| ||()()() ║▌║▌║█│▌ 2023-01-09 09:43:31.616 - INFO : ▌│█║▌║▌║ |_| ║▌║▌║█│▌ 2023-01-09 09:43:31.617 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Configuration cycle: 3600 debug: false wipe_cache: false wipe_influxdb: false myelectricaldata: xxxxxxxxxx2639: addresses: true enable: true name: "" cache: true consumption: true consumption_detail: true consumption_price_base: 0.1871 consumption_price_hc: 0.1470 consumption_price_hp: 0.1871 consumption_max_date: "2021-06-01" consumption_detail_max_date: "2021-06-01" offpeak_hours_0: 01h30-07h30;12h30-14h30 offpeak_hours_1: 01h30-07h30;12h30-14h30 offpeak_hours_2: 01h30-07h30;12h30-14h30 offpeak_hours_3: 01h30-07h30;12h30-14h30 offpeak_hours_4: 01h30-07h30;12h30-14h30 offpeak_hours_5: 01h30-07h30;12h30-14h30 offpeak_hours_6: 01h30-07h30;12h30-14h30 plan: HP/HC production: false production_detail: false refresh_addresse: false refresh_contract: false token: xxxxxxxxxx xxxxxxxxxx4881765491878: addresses: true enable: true name: "" cache: true consumption: true consumption_detail: true consumption_price_base: 0.1871 consumption_price_hc: 0.1470 consumption_price_hp: 0.1871 consumption_max_date: "2022-12-01" consumption_detail_max_date: "2022-12-01" offpeak_hours_0: 00h50-06h50;14h20-16h20 offpeak_hours_1: 00h50-06h50;14h20-16h20 offpeak_hours_2: 00h50-06h50;14h20-16h20 offpeak_hours_3: 00h50-06h50;14h20-16h20 offpeak_hours_4: 00h50-06h50;14h20-16h20 offpeak_hours_5: 00h50-06h50;14h20-16h20 offpeak_hours_6: 00h50-06h50;14h20-16h20 plan: HP/HC production: false production_detail: false refresh_addresse: false refresh_contract: false token: xxxxxxxxxx home_assistant: enable: true

card_myenedis: true

discovery: true

discovery_prefix: homeassistant mqtt: client_id: myelectricaldata hostname: x.x.x.27 enable: true password: 'yyyyyyyyyyyyyyyyyyy' port: 1883 prefix: myelectricaldata qos: 0 retain: true username: 'homeassistant' influxdb: enable: true hostname: x.x.x.27 port: 8086 token: "home_assistant:**" org: "-" bucket: "myelectricaldata/autogen" method: asynchronous

Type d'installation HassIO ?

Version : 8.1.3-beta1

m4dm4rtig4n commented 1 year ago

Est-ce que tu as bien de la donnée chez Enedis ? Que disent les logs ?

PS : Un peu mise en forme de ta config est la bienvenue par ce que la c'est juste ilisible....

geobar78 commented 1 year ago

Slt tout pareil, ce qui est bizarre c'est que dans les attributs on dirait que pour lui on est tjrs le 7, Enedis a l'air ok car j'ai bien les données qui remontent avec le sensor de saniho qui passe par MED.

ActivationDate 16 août 2014 à 00:00:00 LastUpdate 7 janvier 2023 à 08:56:57 TimeLastCall 7 janvier 2023 à 08:56:57 YesterdayDate 6 janvier 2023 Yesterday 0 YesterdayLastYearDate 7 janvier 2022 YesterdayLastYear 0 Daily 0, 0, 0, 15.6, 20.14, 20.98, 28.87 Current week 85,6 Last week 152,21 Day 1 0 Day 2 0 Day 3 0 Day 4 15,6 Day 5 20,14 Day 6 20,98 Day 7 28,87 Current week last year 195,22 Last month 620,49 Current month 56,73 Current month last year 167,9 Last month last year 932,13 Last year 7 524,87 Current year 56,73 Current year last year 167,9 Dailyweek 2023-01-06, 2023-01-05, 2023-01-04, 2023-01-03, 2023-01-02, 2023-01-01, 2022-12-31 Dailyweek cost 0, 0, 0, 2.2, 2.9, 3, 4.2 Dailyweek costHP 0, 0, 0, 0.9, 1.5, 1.3, 2.7 Dailyweek HP 0, 0, 0, 5.23, 9.17, 7.63, 16.41 Daily cost 0 Yesterday HP cost 0 Yesterday HP 0 Day 1 HP 0 Day 2 HP 0 Day 3 HP 0 Day 4 HP 5 239 Day 5 HP 9 176 Day 6 HP 7 639 Day 7 HP 16 417 Dailyweek costHC 0, 0, 0, 1.3, 1.4, 1.7, 1.5 Dailyweek HC 0, 0, 0, 10.36, 10.96, 13.34, 12.45 Yesterday HC cost 0 Yesterday HC 0 Day 1 HC 0 Day 2 HC 0 Day 3 HC 0 Day 4 HC 10 369 Day 5 HC 10 967 Day 6 HC 13 347 Day 7 HC 12 454 Peak offpeak percent -17,17 Monthly evolution -33,43 Current week evolution -43,76 Current month evolution -66,21 Yesterday evolution 0 ErrorLastCall ErrorLastCallInterne Current week number 01 Offpeak hours enedis Lundi (23H00-7H00);Mardi (23H00-7H00);Mercredi (23H00-7H00);Jeudi (23H00-7H00);Vendredi (23H00-7H00);Samedi (23H00-7H00);Dimanche (23H00-7H00); Offpeak hours

- - 23H00
7H00
- - 23H00
7H00
- - 23H00
7H00
- - 23H00
7H00
- - 23H00
7H00
- - 23H00
7H00
- - 23H00
7H00 Subscribed power 6 kVA

LGO44 commented 1 year ago

Est-ce que tu as bien de la donnée chez Enedis ?

les données Enedis sont enfin arrivées

Que disent les logs ?

Logs de myelectricaldata 2023-01-09 14:43:36.885 - INFO : => 0 2023-01-09 14:43:36.887 - INFO : last_month 2023-01-09 14:43:36.905 - INFO : => 0 2023-01-09 14:43:36.906 - INFO : current_month 2023-01-09 14:43:36.917 - INFO : => 0 2023-01-09 14:43:36.920 - INFO : current_month_last_year 2023-01-09 14:43:36.936 - INFO : => 0 2023-01-09 14:43:36.938 - INFO : last_month_last_year 2023-01-09 14:43:36.953 - INFO : => 0 2023-01-09 14:43:36.955 - INFO : current_year 2023-01-09 14:43:36.966 - INFO : => 0 2023-01-09 14:43:36.970 - INFO : current_year_last_year 2023-01-09 14:43:36.984 - INFO : => 0 2023-01-09 14:43:36.987 - INFO : last_year 2023-01-09 14:43:36.996 - INFO : => 0 2023-01-09 14:43:36.997 - INFO : yesterday_hp / yesterday_hc 2023-01-09 14:43:37.030 - INFO : => HC : 0 2023-01-09 14:43:37.031 - INFO : => HP : 0 2023-01-09 14:43:37.032 - INFO : peak_offpeak_percent_hp VS peak_offpeak_percent_hc 2023-01-09 14:43:37.043 - INFO : => 0 2023-01-09 14:43:37.050 - INFO : current_week_evolution 2023-01-09 14:43:37.052 - INFO : => 0 2023-01-09 14:43:37.053 - INFO : current_month_evolution 2023-01-09 14:43:37.054 - INFO : => 0 2023-01-09 14:43:37.055 - INFO : yesterday_evolution 2023-01-09 14:43:37.055 - INFO : => 0 2023-01-09 14:43:37.056 - INFO : yesterday 2023-01-09 14:43:37.068 - INFO : => 0 2023-01-09 14:43:37.074 - INFO : yesterday_1 2023-01-09 14:43:37.084 - INFO : => 0 2023-01-09 14:43:37.086 - INFO : => 0 2023-01-09 14:43:37.087 - INFO : monthly_evolution 2023-01-09 14:43:37.088 - INFO : last_month 2023-01-09 14:43:37.103 - INFO : => 0 2023-01-09 14:43:37.105 - INFO : last_month_last_year 2023-01-09 14:43:37.117 - INFO : => 0 2023-01-09 14:43:37.129 - INFO : => 0 2023-01-09 14:43:38.268 - INFO : current_week 2023-01-09 14:43:38.310 - INFO : => 0 2023-01-09 14:43:38.318 - INFO : last_week 2023-01-09 14:43:38.364 - INFO : => 0 2023-01-09 14:43:38.367 - INFO : current_week_last_year 2023-01-09 14:43:38.384 - INFO : => 0 2023-01-09 14:43:38.386 - INFO : last_month 2023-01-09 14:43:38.400 - INFO : => 0 2023-01-09 14:43:38.402 - INFO : current_month 2023-01-09 14:43:38.415 - INFO : => 0 2023-01-09 14:43:38.422 - INFO : current_month_last_year 2023-01-09 14:43:38.436 - INFO : => 0 2023-01-09 14:43:38.439 - INFO : last_month_last_year 2023-01-09 14:43:38.454 - INFO : => 0 2023-01-09 14:43:38.456 - INFO : current_year 2023-01-09 14:43:38.469 - INFO : => 0 2023-01-09 14:43:38.470 - INFO : current_year_last_year 2023-01-09 14:43:38.479 - INFO : => 0 2023-01-09 14:43:38.482 - INFO : last_year 2023-01-09 14:43:38.496 - INFO : => 0 2023-01-09 14:43:38.498 - INFO : yesterday_hp / yesterday_hc 2023-01-09 14:43:38.510 - INFO : => HC : 0 2023-01-09 14:43:38.516 - INFO : => HP : 0 2023-01-09 14:43:38.518 - INFO : peak_offpeak_percent_hp VS peak_offpeak_percent_hc 2023-01-09 14:43:38.524 - INFO : => 0 2023-01-09 14:43:38.529 - INFO : current_week_evolution 2023-01-09 14:43:38.530 - INFO : => 0 2023-01-09 14:43:38.531 - INFO : current_month_evolution 2023-01-09 14:43:38.532 - INFO : => 0 2023-01-09 14:43:38.532 - INFO : yesterday_evolution 2023-01-09 14:43:38.532 - INFO : yesterday 2023-01-09 14:43:38.549 - INFO : => 0 2023-01-09 14:43:38.550 - INFO : yesterday_1 2023-01-09 14:43:38.564 - INFO : => 0 2023-01-09 14:43:38.565 - INFO : => 0 2023-01-09 14:43:38.567 - INFO : monthly_evolution 2023-01-09 14:43:38.568 - INFO : last_month 2023-01-09 14:43:38.578 - INFO : => 0 2023-01-09 14:43:38.580 - INFO : last_month_last_year 2023-01-09 14:43:38.592 - INFO : => 0 2023-01-09 14:43:38.593 - INFO : => 0 2023-01-09 14:43:39.747 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 14:43:39.757 - INFO : EXPORT TERMINÉ 2023-01-09 14:43:39.758 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 14:43:39.758 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 14:43:39.758 - INFO : EXPORTATION INFLUXDB 2023-01-09 14:43:39.758 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 14:43:39.758 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 14:43:39.759 - INFO : [14881765491878] EXPORTATION DES DONNÉES "CONSUMPTION" DANS INFLUXDB 2023-01-09 14:43:39.759 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 14:43:39.792 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 14:43:39.796 - INFO : [14881765491878] EXPORTATION DES DONNÉES "CONSUMPTION_DETAIL" DANS INFLUXDB 2023-01-09 14:43:39.802 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 14:43:39.820 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 14:43:39.830 - INFO : EXPORT TERMINÉ 2023-01-09 14:43:39.833 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 14:43:39.836 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-09 14:43:39.837 - INFO : ▌│█║▌║▌║ ____ ║▌║▌║█│▌ 2023-01-09 14:43:39.838 - INFO : ▌│█║▌║▌║ | | | |_ | |() _ () | | | || || | ║▌║▌║█│▌ 2023-01-09 14:43:39.840 - INFO : ▌│█║▌║▌║ | | | ' ` \ | ' \ / \ | '|| | | | | || ' \ | |/ || ' \ | || || | ║▌║▌║█│▌ 2023-01-09 14:43:39.841 - INFO : ▌│█║▌║▌║ | | | | | | | || |) || () || | | | | | | || | | || |_ | | | ||||||_| ║▌║▌║█│▌ 2023-01-09 14:43:39.842 - INFO : ▌│█║▌║▌║ |__||| || ||| ./ __/ || _| || |||| |||||__/|| ||()()() ║▌║▌║█│▌ 2023-01-09 14:43:39.842 - INFO : ▌│█║▌║▌║ |_| ║▌║▌║█│▌ 2023-01-09 14:43:39.843 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

ma configuration ( j'espère plus lisible?)

Configuration cycle: 3600 debug: false wipe_cache: false wipe_influxdb: false

myelectricaldata: xxxxxxxxxx2639: # domicile addresses: true enable: true name: "" cache: true consumption: true consumption_detail: true consumption_price_base: 0.1871 consumption_price_hc: 0.1470 consumption_price_hp: 0.1871 consumption_max_date: "2021-06-01" consumption_detail_max_date: "2021-06-01" offpeak_hours_0: 01h30-07h30;12h30-14h30 offpeak_hours_1: 01h30-07h30;12h30-14h30 offpeak_hours_2: 01h30-07h30;12h30-14h30 offpeak_hours_3: 01h30-07h30;12h30-14h30 offpeak_hours_4: 01h30-07h30;12h30-14h30 offpeak_hours_5: 01h30-07h30;12h30-14h30 offpeak_hours_6: 01h30-07h30;12h30-14h30 plan: HP/HC production: false production_detail: false refresh_addresse: false refresh_contract: false token: xxxxxxxxxx

xxxxxxxxxx4881765491878: # second compteur addresses: true enable: true name: "" cache: true consumption: true consumption_detail: true consumption_price_base: 0.1871 consumption_price_hc: 0.1470 consumption_price_hp: 0.1871 consumption_max_date: "2022-12-01" consumption_detail_max_date: "2022-12-01" offpeak_hours_0: 00h50-06h50;14h20-16h20 offpeak_hours_1: 00h50-06h50;14h20-16h20 offpeak_hours_2: 00h50-06h50;14h20-16h20 offpeak_hours_3: 00h50-06h50;14h20-16h20 offpeak_hours_4: 00h50-06h50;14h20-16h20 offpeak_hours_5: 00h50-06h50;14h20-16h20 offpeak_hours_6: 00h50-06h50;14h20-16h20 plan: HP/HC production: false production_detail: false refresh_addresse: false refresh_contract: false token: xxxxxxxxxx

home_assistant: enable: true discovery_prefix: homeassistant

mqtt: client_id: myelectricaldata hostname: x.x.x.27 enable: true password: 'yyyyyyyyyyyyyyyyyyy' port: 1883 prefix: myelectricaldata qos: 0 retain: true username: 'homeassistant'

influxdb: enable: true hostname: x.x.x.27 port: 8086 token: "home_assistant:**" org: "-" bucket: "myelectricaldata/autogen" method: asynchronous

Video des données myelectricaldata et myenedis

https://user-images.githubusercontent.com/95585425/211331030-4fa677dc-6f5b-484a-b73b-bdce752a7e7c.mp4

valderaplets commented 1 year ago

J'ai la même. Que des 0. Pas de message d'erreur ..

geobar78 commented 1 year ago

Par contre j'ai l'impression que les datas sont sur myelectricaldata_consumption maintenant. j'ai bon ?

valderaplets commented 1 year ago

numPDL: 'XXXXX'
activationDate: '2016-07-19 00:00:00'
lastUpdate: '2023-01-07 08:02:29'
timeLastCall: '2023-01-07 08:02:29'
yesterdayDate: '2023-01-06'
yesterday: 0
yesterdayLastYearDate: '2022-01-07'
yesterdayLastYear: 0
daily:
  - 0
  - 0
  - 0
  - 0
  - 0
  - 0
  - 0
current_week: 0
last_week: 53.19
day_1: 0
day_2: 0
day_3: 0
day_4: 0
day_5: 0
day_6: 0
day_7: 0
current_week_last_year: 63.11
last_month: 231.41
current_month: 0
current_month_last_year: 55.22
last_month_last_year: 228.95
last_year: 2372.24
current_year: 0
current_year_last_year: 55.22
dailyweek:
  - '2023-01-06'
  - '2023-01-05'
  - '2023-01-04'
  - '2023-01-03'
  - '2023-01-02'
  - '2023-01-01'
  - '2022-12-31'
dailyweek_cost:
  - 0
  - 0
  - 0
  - 0
  - 0
  - 0
  - 0
dailyweek_costHP:
  - 0
  - 1
  - 1.1
  - 1.7
  - 1.3
  - 1.4
  - 1.5
dailyweek_HP:
  - 0
  - 5.92
  - 6.28
  - 9.6
  - 7.19
  - 8.1
  - 8.65
daily_cost: 0
yesterday_HP_cost: 0
yesterday_HP: 0
day_1_HP: 0
day_2_HP: 5921
day_3_HP: 6284
day_4_HP: 9603
day_5_HP: 7190
day_6_HP: 8104
day_7_HP: 8655
dailyweek_costHC:
  - 0
  - 0
  - 0
  - 0
  - 0
  - 0
  - 0
dailyweek_HC:
  - 0
  - 0
  - 0
  - 0
  - 0
  - 0
  - 0
yesterday_HC_cost: 0
yesterday_HC: 0
day_1_HC: 0
day_2_HC: 0
day_3_HC: 0
day_4_HC: 0
day_5_HC: 0
day_6_HC: 0
day_7_HC: 0
peak_offpeak_percent: 0
monthly_evolution: 1.07
current_week_evolution: -100
current_month_evolution: -100
yesterday_evolution: 0
friendly_name: myelectricaldata_XXXX
errorLastCall: ''
errorLastCallInterne: ''
current_week_number: '01'
offpeak_hours_enedis: Lundi ();Mardi ();Mercredi ();Jeudi ();Vendredi ();Samedi ();Dimanche ();
offpeak_hours:
  - - - ''
  - - - ''
  - - - ''
  - - - ''
  - - - ''
  - - - ''
  - - - ''
subscribed_power: 6 kVA
unit_of_measurement: kWh

Jib-san commented 1 year ago

Pareil, depuis le début d'année j'ai la conso et le prix à 0. La version 0.8.13-beta1 n'a pas résolu le soucis. Il semble y avoir un soucis avec le calcul HC/HP car les datas HP sont bien là. (j'ai pas de contrat HC/HP)

numPDL: XXXXXXXXXXXXXXX
activationDate: 2021-02-23 00:00:00
lastUpdate: 2023-01-07 09:27:51
timeLastCall: 2023-01-07 09:27:51
yesterdayDate: 2023-01-06
yesterday: 0
yesterdayLastYearDate: 2022-01-07
yesterdayLastYear: 0
daily: 0, 0, 0, 0, 0, 0, 0
current_week: 0
last_week: 28.33
day_1: 0
day_2: 0
day_3: 0
day_4: 0
day_5: 0
day_6: 0
day_7: 0
current_week_last_year: 13.73
last_month: 133.19
current_month: 0
current_month_last_year: 11.81
last_month_last_year: 148.89
last_year: 1592.61
current_year: 0
current_year_last_year: 11.81
dailyweek: 2023-01-06, 2023-01-05, 2023-01-04, 2023-01-03, 2023-01-02, 2023-01-01, 2022-12-31
dailyweek_cost: 0, 0, 0, 0, 0, 0, 0
dailyweek_costHP: 0, 0, 0.3, 0.2, 0.3, 0.3, 0.3
dailyweek_HP: 0, 0, 1.5, 1.49, 1.55, 1.52, 1.54
daily_cost: 0
yesterday_HP_cost: 0
yesterday_HP: 0
day_1_HP: 0
day_2_HP: 0
day_3_HP: 1502
day_4_HP: 1490
day_5_HP: 1550
day_6_HP: 1527
day_7_HP: 1544
dailyweek_costHC: 0, 0, 0, 0, 0, 0, 0
dailyweek_HC: 0, 0, 0, 0, 0, 0, 0
yesterday_HC_cost: 0
yesterday_HC: 0
day_1_HC: 0
day_2_HC: 0
day_3_HC: 0
day_4_HC: 0
day_5_HC: 0
day_6_HC: 0
day_7_HC: 0
peak_offpeak_percent: 0
monthly_evolution: -10.55
current_week_evolution: -100
current_month_evolution: -100
yesterday_evolution: 0
friendly_name: myelectricaldata_XXXXXXXXXXXXXXX
errorLastCall: 
errorLastCallInterne: 
current_week_number: 01
offpeak_hours_enedis: Lundi ();Mardi ();Mercredi ();Jeudi ();Vendredi ();Samedi ();Dimanche ();
offpeak_hours: 
- - - ''
- - - ''
- - - ''
- - - ''
- - - ''
- - - ''
- - - ''
subscribed_power: 6 kVA
unit_of_measurement: kWh

myelecrticaldata_zero_issue_01

LGO44 commented 1 year ago

nouveaux logs au lancement de myelectricaldata

2023-01-10 23:51:27.037 - INFO : - 2022-08 2023-01-10 23:51:27.075 - INFO : - 2022-07 2023-01-10 23:51:27.093 - INFO : - 2022-06 2023-01-10 23:51:27.113 - INFO : - 2022-05 2023-01-10 23:51:27.130 - INFO : - 2022-04 2023-01-10 23:51:27.148 - INFO : - 2022-03 2023-01-10 23:51:27.168 - INFO : - 2022-02 2023-01-10 23:51:27.185 - INFO : - 2022-01 2023-01-10 23:51:27.201 - INFO : - 2021-12 2023-01-10 23:51:27.216 - INFO : - 2021-11 2023-01-10 23:51:27.234 - INFO : - 2021-10 2023-01-10 23:51:27.260 - INFO : - 2021-09 2023-01-10 23:51:27.281 - INFO : - 2021-08 2023-01-10 23:51:27.298 - INFO : - 2021-07 2023-01-10 23:51:27.317 - INFO : - 2021-06 2023-01-10 23:51:27.335 - INFO : - 2021-05 2023-01-10 23:51:27.350 - INFO : - 2021-04 2023-01-10 23:51:27.365 - INFO : - 2021-03 2023-01-10 23:51:27.381 - INFO : - 2021-02 2023-01-10 23:51:27.389 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:27.397 - INFO : [14287554172639] EXPORTATION DES DONNÉES "CONSUMPTION_DETAIL" DANS INFLUXDB 2023-01-10 23:51:27.398 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:28.759 - INFO : - 2022-01 2023-01-10 23:51:29.099 - INFO : - 2022-02 2023-01-10 23:51:29.816 - INFO : - 2022-03 2023-01-10 23:51:30.555 - INFO : - 2022-04 2023-01-10 23:51:31.107 - INFO : - 2022-05 2023-01-10 23:51:31.757 - INFO : - 2022-06 2023-01-10 23:51:32.830 - INFO : - 2022-07 2023-01-10 23:51:33.772 - INFO : - 2022-08 2023-01-10 23:51:34.741 - INFO : - 2022-09 2023-01-10 23:51:36.047 - INFO : - 2022-10 2023-01-10 23:51:36.982 - INFO : - 2022-11 2023-01-10 23:51:37.890 - INFO : - 2022-12 2023-01-10 23:51:38.203 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:38.208 - INFO : EXPORT TERMINÉ 2023-01-10 23:51:38.209 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:38.210 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:38.210 - INFO : ▌│█║▌║▌║ Point de livraison : 14881765491878 ║▌║▌║█│▌ 2023-01-10 23:51:38.211 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:38.211 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:38.211 - INFO : [14881765491878] STATUT DE LA PASSERELLE : 2023-01-10 23:51:38.212 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:38.461 - INFO : status: True 2023-01-10 23:51:38.468 - INFO : information: None 2023-01-10 23:51:38.477 - INFO : nb_client: 877 2023-01-10 23:51:38.478 - INFO : waiting_estimation: 0.0s 2023-01-10 23:51:38.483 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:38.483 - INFO : [14881765491878] CHECK ACCOUNT STATUS : 2023-01-10 23:51:38.488 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:38.711 - INFO : valid: True 2023-01-10 23:51:38.715 - INFO : information: 2023-01-10 23:51:38.716 - INFO : consent_expiration_date: 2026-01-10T21:37:22 2023-01-10 23:51:38.717 - INFO : call_number: 51 2023-01-10 23:51:38.718 - INFO : quota_reached: False 2023-01-10 23:51:38.719 - INFO : quota_limit: 500 2023-01-10 23:51:38.721 - INFO : quota_reset_at: 2023-01-10T23:59:59.999999 2023-01-10 23:51:38.721 - INFO : last_call: 2022-12-11T09:38:45.450247 2023-01-10 23:51:38.722 - INFO : ban: False 2023-01-10 23:51:38.742 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:38.748 - INFO : [14881765491878] RÉCUPÉRATION DU CONTRAT : 2023-01-10 23:51:38.749 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:38.782 - INFO : => Query Cache 2023-01-10 23:51:38.803 - INFO : id: 2 2023-01-10 23:51:38.804 - INFO : usage_point_id: 14881765491878 2023-01-10 23:51:38.805 - INFO : usage_point_status: com 2023-01-10 23:51:38.805 - INFO : meter_type: AMM 2023-01-10 23:51:38.808 - INFO : segment: C5 2023-01-10 23:51:38.810 - INFO : subscribed_power: 6 kVA 2023-01-10 23:51:38.810 - INFO : last_activation_date: 2022-11-16 00:00:00 2023-01-10 23:51:38.810 - INFO : distribution_tariff: BTINFMU4 2023-01-10 23:51:38.810 - INFO : offpeak_hours_0: 0H50-6H50;14H20-16H20 2023-01-10 23:51:38.813 - INFO : offpeak_hours_1: 0H50-6H50;14H20-16H20 2023-01-10 23:51:38.813 - INFO : offpeak_hours_2: 0H50-6H50;14H20-16H20 2023-01-10 23:51:38.814 - INFO : offpeak_hours_3: 0H50-6H50;14H20-16H20 2023-01-10 23:51:38.814 - INFO : offpeak_hours_4: 0H50-6H50;14H20-16H20 2023-01-10 23:51:38.814 - INFO : offpeak_hours_5: 0H50-6H50;14H20-16H20 2023-01-10 23:51:38.814 - INFO : offpeak_hours_6: 0H50-6H50;14H20-16H20 2023-01-10 23:51:38.814 - INFO : contract_status: SERVC 2023-01-10 23:51:38.814 - INFO : last_distribution_tariff_change_date: 2022-11-16 00:00:00 2023-01-10 23:51:38.814 - INFO : count: 0 2023-01-10 23:51:38.822 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:38.825 - INFO : [14881765491878] RÉCUPÉRATION DES COORDONNÉES : 2023-01-10 23:51:38.828 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:38.843 - INFO : => Query Cache 2023-01-10 23:51:38.847 - INFO : id: 2 2023-01-10 23:51:38.848 - INFO : usage_point_id: 14881765491878 2023-01-10 23:51:38.850 - INFO : street: 2023-01-10 23:51:38.851 - INFO : locality: 2023-01-10 23:51:38.854 - INFO : postal_code: 5 2023-01-10 23:51:38.855 - INFO : insee_code: 5 2023-01-10 23:51:38.858 - INFO : city: 2023-01-10 23:51:38.861 - INFO : country: France 2023-01-10 23:51:38.861 - INFO : geo_points: {} 2023-01-10 23:51:38.861 - INFO : count: 0 2023-01-10 23:51:38.862 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:38.862 - INFO : [14881765491878] RÉCUPÉRATION DE LA CONSOMMATION JOURNALIÈRE : 2023-01-10 23:51:38.862 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:38.894 - INFO : Récupération des données : 2020-01-12 => 2023-01-10 2023-01-10 23:51:49.213 - INFO : => Chargement des données depuis MyElectricalData 2020-01-12 => 2023-01-10 2023-01-10 23:51:49.543 - ERROR : (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_daily (id, usage_point_id, date, value, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?)] [parameters: ('f8c85510591bf213aab1c7f22de8f8f8', '14881765491878', '2020-01-12 00:00:00.000000', 0, 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) Traceback (most recent call last): File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: datatype mismatch The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/app/models/query_daily.py", line 104, in run self.db.daily_fail_increment( File "/app/models/database.py", line 720, in daily_fail_increment daily = self.session.scalars(query).one_or_none() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1771, in scalars return self.execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 312, in orm_pre_session_exec session._autoflush() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in autoflush util.raise(e, with_traceback=sys.excinfo()[2]) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3386, in flush self._flush(objects) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3526, in _flush transaction.rollback(_captureexception=True) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in exit compat.raise( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3486, in _flush flush_context.execute() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj _emit_insert_statements( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1097, in _emit_insert_statements c = connection._execute_20( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection return connection._execute_clauseelement( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement ret = self._execute_context( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context self._handle_dbapi_exception( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapiexception util.raise( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_daily (id, usage_point_id, date, value, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?)] [parameters: ('f8c85510591bf213aab1c7f22de8f8f8', '14881765491878', '2020-01-12 00:00:00.000000', 0, 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2023-01-10 23:51:49.574 - ERROR : ═══════════════════════════════════════════════•°• :ERREUR: •°•════════════════════════════════════════════════ 2023-01-10 23:51:49.574 - ERROR : 2023-01-10 23:51:49.574 - ERROR : (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_daily (id, usage_point_id, date, value, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?)] [parameters: ('f8c85510591bf213aab1c7f22de8f8f8', '14881765491878', '2020-01-12 00:00:00.000000', 0, 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2023-01-10 23:51:49.574 - ERROR : 2023-01-10 23:51:49.574 - ERROR : ═══════════════════════════════════════════════════════════════════════════════════════════════════════════════ 2023-01-10 23:51:49.574 - ERROR : ═══════════════════════════════════════════════•°• :ERREUR: •°•════════════════════════════════════════════════ 2023-01-10 23:51:49.574 - ERROR : 2023-01-10 23:51:49.575 - ERROR : Echec de la récupération des données. 2023-01-10 23:51:49.575 - ERROR : => MyElectricalData est indisponible. 2023-01-10 23:51:49.575 - ERROR : => 2020-01-12 -> 2023-01-10 2023-01-10 23:51:49.575 - ERROR : 2023-01-10 23:51:49.575 - ERROR : ═══════════════════════════════════════════════════════════════════════════════════════════════════════════════ 2023-01-10 23:51:49.575 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:49.575 - INFO : [14881765491878] RÉCUPÉRATION DE LA CONSOMMATION DÉTAILLÉE : 2023-01-10 23:51:49.601 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:49.797 - INFO : Récupération des données : 2023-01-03 => 2023-01-10 2023-01-10 23:51:49.839 - INFO : - 11519m absente du relevé. 2023-01-10 23:51:49.848 - INFO : => Chargement des données depuis MyElectricalData 2023-01-03 => 2023-01-10 2023-01-10 23:51:50.238 - ERROR : (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_detail (id, usage_point_id, date, value, interval, measure_type, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('c0fe854d7a18b021533fa71cbf95eada', '14881765491878', '2023-01-03 00:00:00.000000', '68', '30', 'HP', 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) Traceback (most recent call last): File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: datatype mismatch The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/app/models/query_detail.py", line 129, in run self.db.insert_detail( File "/app/models/database.py", line 1029, in insert_detail detail = self.get_detail_date(usage_point_id, date, mesure_type) File "/app/models/database.py", line 927, in get_detail_date return self.session.scalars( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1771, in scalars return self.execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 312, in orm_pre_session_exec session._autoflush() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in autoflush util.raise(e, with_traceback=sys.excinfo()[2]) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3386, in flush self._flush(objects) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3526, in _flush transaction.rollback(_captureexception=True) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in exit compat.raise( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3486, in _flush flush_context.execute() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj _emit_insert_statements( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1097, in _emit_insert_statements c = connection._execute_20( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection return connection._execute_clauseelement( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement ret = self._execute_context( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context self._handle_dbapi_exception( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapiexception util.raise( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_detail (id, usage_point_id, date, value, interval, measure_type, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('c0fe854d7a18b021533fa71cbf95eada', '14881765491878', '2023-01-03 00:00:00.000000', '68', '30', 'HP', 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2023-01-10 23:51:50.245 - ERROR : ═══════════════════════════════════════════════•°• :ERREUR: •°•════════════════════════════════════════════════ 2023-01-10 23:51:50.245 - ERROR : 2023-01-10 23:51:50.245 - ERROR : (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_detail (id, usage_point_id, date, value, interval, measure_type, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('c0fe854d7a18b021533fa71cbf95eada', '14881765491878', '2023-01-03 00:00:00.000000', '68', '30', 'HP', 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2023-01-10 23:51:50.245 - ERROR : 2023-01-10 23:51:50.245 - ERROR : ═══════════════════════════════════════════════════════════════════════════════════════════════════════════════ 2023-01-10 23:51:50.245 - ERROR : ═══════════════════════════════════════════════•°• :ERREUR: •°•════════════════════════════════════════════════ 2023-01-10 23:51:50.246 - ERROR : 2023-01-10 23:51:50.246 - ERROR : Echec de la récupération des données. 2023-01-10 23:51:50.246 - ERROR : => MyElectricalData est indisponible. 2023-01-10 23:51:50.246 - ERROR : => 2022-12-27 -> 2023-01-03 2023-01-10 23:51:50.246 - ERROR : 2023-01-10 23:51:50.246 - ERROR : ═══════════════════════════════════════════════════════════════════════════════════════════════════════════════ 2023-01-10 23:51:50.246 - INFO : Récupération des données : 2022-12-27 => 2023-01-03 2023-01-10 23:51:50.357 - INFO : - 11519m absente du relevé. 2023-01-10 23:51:50.363 - INFO : => Chargement des données depuis MyElectricalData 2022-12-27 => 2023-01-03 2023-01-10 23:51:50.702 - ERROR : (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_detail (id, usage_point_id, date, value, interval, measure_type, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('ab4c11fcda483c815f958cbec305fcc3', '14881765491878', '2022-12-27 00:00:00.000000', '274', '60', 'HC', 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) Traceback (most recent call last): File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: datatype mismatch The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/app/models/query_detail.py", line 129, in run self.db.insert_detail( File "/app/models/database.py", line 1029, in insert_detail detail = self.get_detail_date(usage_point_id, date, mesure_type) File "/app/models/database.py", line 927, in get_detail_date return self.session.scalars( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1771, in scalars return self.execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 312, in orm_pre_session_exec session._autoflush() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in autoflush util.raise(e, with_traceback=sys.excinfo()[2]) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3386, in flush self._flush(objects) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3526, in _flush transaction.rollback(_captureexception=True) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in exit compat.raise( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3486, in _flush flush_context.execute() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj _emit_insert_statements( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1097, in _emit_insert_statements c = connection._execute_20( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection return connection._execute_clauseelement( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement ret = self._execute_context( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context self._handle_dbapi_exception( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapiexception util.raise( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_detail (id, usage_point_id, date, value, interval, measure_type, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('ab4c11fcda483c815f958cbec305fcc3', '14881765491878', '2022-12-27 00:00:00.000000', '274', '60', 'HC', 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2023-01-10 23:51:50.727 - ERROR : ═══════════════════════════════════════════════•°• :ERREUR: •°•════════════════════════════════════════════════ 2023-01-10 23:51:50.727 - ERROR : 2023-01-10 23:51:50.727 - ERROR : (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_detail (id, usage_point_id, date, value, interval, measure_type, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('ab4c11fcda483c815f958cbec305fcc3', '14881765491878', '2022-12-27 00:00:00.000000', '274', '60', 'HC', 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2023-01-10 23:51:50.727 - ERROR : 2023-01-10 23:51:50.727 - ERROR : ═══════════════════════════════════════════════════════════════════════════════════════════════════════════════ 2023-01-10 23:51:50.727 - ERROR : ═══════════════════════════════════════════════•°• :ERREUR: •°•════════════════════════════════════════════════ 2023-01-10 23:51:50.728 - ERROR : 2023-01-10 23:51:50.728 - ERROR : Echec de la récupération des données. 2023-01-10 23:51:50.728 - ERROR : => MyElectricalData est indisponible. 2023-01-10 23:51:50.728 - ERROR : => 2022-12-20 -> 2022-12-27 2023-01-10 23:51:50.728 - ERROR : 2023-01-10 23:51:50.728 - ERROR : ═══════════════════════════════════════════════════════════════════════════════════════════════════════════════ 2023-01-10 23:51:50.728 - INFO : Récupération des données : 2022-12-20 => 2022-12-27 2023-01-10 23:51:50.946 - INFO : - 11519m absente du relevé. 2023-01-10 23:51:50.947 - INFO : => Chargement des données depuis MyElectricalData 2022-12-20 => 2022-12-27 2023-01-10 23:51:51.294 - ERROR : (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_detail (id, usage_point_id, date, value, interval, measure_type, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('32e5e8fc9aad4af7347412abf98c8cc2', '14881765491878', '2022-12-20 00:00:00.000000', '172', '60', 'HC', 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) Traceback (most recent call last): File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: datatype mismatch The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/app/models/query_detail.py", line 129, in run self.db.insert_detail( File "/app/models/database.py", line 1029, in insert_detail detail = self.get_detail_date(usage_point_id, date, mesure_type) File "/app/models/database.py", line 927, in get_detail_date return self.session.scalars( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1771, in scalars return self.execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 312, in orm_pre_session_exec session._autoflush() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in autoflush util.raise(e, with_traceback=sys.excinfo()[2]) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3386, in flush self._flush(objects) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3526, in _flush transaction.rollback(_captureexception=True) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in exit compat.raise( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3486, in _flush flush_context.execute() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj _emit_insert_statements( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1097, in _emit_insert_statements c = connection._execute_20( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection return connection._execute_clauseelement( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement ret = self._execute_context( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context self._handle_dbapi_exception( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapiexception util.raise( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_detail (id, usage_point_id, date, value, interval, measure_type, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('32e5e8fc9aad4af7347412abf98c8cc2', '14881765491878', '2022-12-20 00:00:00.000000', '172', '60', 'HC', 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2023-01-10 23:51:51.315 - ERROR : ═══════════════════════════════════════════════•°• :ERREUR: •°•════════════════════════════════════════════════ 2023-01-10 23:51:51.315 - ERROR : 2023-01-10 23:51:51.315 - ERROR : (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_detail (id, usage_point_id, date, value, interval, measure_type, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('32e5e8fc9aad4af7347412abf98c8cc2', '14881765491878', '2022-12-20 00:00:00.000000', '172', '60', 'HC', 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2023-01-10 23:51:51.315 - ERROR : 2023-01-10 23:51:51.315 - ERROR : ═══════════════════════════════════════════════════════════════════════════════════════════════════════════════ 2023-01-10 23:51:51.316 - ERROR : ═══════════════════════════════════════════════•°• :ERREUR: •°•════════════════════════════════════════════════ 2023-01-10 23:51:51.316 - ERROR : 2023-01-10 23:51:51.316 - ERROR : Echec de la récupération des données. 2023-01-10 23:51:51.316 - ERROR : => MyElectricalData est indisponible. 2023-01-10 23:51:51.316 - ERROR : => 2022-12-13 -> 2022-12-20 2023-01-10 23:51:51.316 - ERROR : 2023-01-10 23:51:51.316 - ERROR : ═══════════════════════════════════════════════════════════════════════════════════════════════════════════════ 2023-01-10 23:51:51.316 - INFO : Récupération des données : 2022-12-13 => 2022-12-20 2023-01-10 23:51:51.427 - INFO : - 11519m absente du relevé. 2023-01-10 23:51:51.440 - INFO : => Chargement des données depuis MyElectricalData 2022-12-13 => 2022-12-20 2023-01-10 23:51:51.715 - ERROR : (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_detail (id, usage_point_id, date, value, interval, measure_type, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('7161d1c022edaa34a26eede5a0ab6792', '14881765491878', '2022-12-13 00:00:00.000000', '0', '60', 'HC', 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) Traceback (most recent call last): File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: datatype mismatch The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/app/models/query_detail.py", line 129, in run self.db.insert_detail( File "/app/models/database.py", line 1029, in insert_detail detail = self.get_detail_date(usage_point_id, date, mesure_type) File "/app/models/database.py", line 927, in get_detail_date return self.session.scalars( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1771, in scalars return self.execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 312, in orm_pre_session_exec session._autoflush() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in autoflush util.raise(e, with_traceback=sys.excinfo()[2]) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3386, in flush self._flush(objects) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3526, in _flush transaction.rollback(_captureexception=True) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in exit compat.raise( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3486, in _flush flush_context.execute() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj _emit_insert_statements( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1097, in _emit_insert_statements c = connection._execute_20( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection return connection._execute_clauseelement( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement ret = self._execute_context( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context self._handle_dbapi_exception( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapiexception util.raise( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_detail (id, usage_point_id, date, value, interval, measure_type, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('7161d1c022edaa34a26eede5a0ab6792', '14881765491878', '2022-12-13 00:00:00.000000', '0', '60', 'HC', 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2023-01-10 23:51:51.727 - ERROR : ═══════════════════════════════════════════════•°• :ERREUR: •°•════════════════════════════════════════════════ 2023-01-10 23:51:51.728 - ERROR : 2023-01-10 23:51:51.728 - ERROR : (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_detail (id, usage_point_id, date, value, interval, measure_type, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('7161d1c022edaa34a26eede5a0ab6792', '14881765491878', '2022-12-13 00:00:00.000000', '0', '60', 'HC', 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2023-01-10 23:51:51.728 - ERROR : 2023-01-10 23:51:51.728 - ERROR : ═══════════════════════════════════════════════════════════════════════════════════════════════════════════════ 2023-01-10 23:51:51.728 - ERROR : ═══════════════════════════════════════════════•°• :ERREUR: •°•════════════════════════════════════════════════ 2023-01-10 23:51:51.740 - ERROR : 2023-01-10 23:51:51.740 - ERROR : Echec de la récupération des données. 2023-01-10 23:51:51.740 - ERROR : => MyElectricalData est indisponible. 2023-01-10 23:51:51.740 - ERROR : => 2022-12-06 -> 2022-12-13 2023-01-10 23:51:51.740 - ERROR : 2023-01-10 23:51:51.740 - ERROR : ═══════════════════════════════════════════════════════════════════════════════════════════════════════════════ 2023-01-10 23:51:51.740 - INFO : Récupération des données : 2022-12-06 => 2022-12-13 2023-01-10 23:51:51.816 - INFO : - 11519m absente du relevé. 2023-01-10 23:51:51.822 - INFO : => Chargement des données depuis MyElectricalData 2022-12-06 => 2022-12-13 2023-01-10 23:51:52.068 - ERROR : (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_detail (id, usage_point_id, date, value, interval, measure_type, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('4d3af6e05e335f0dccdbdce85d6e550b', '14881765491878', '2022-12-06 00:00:00.000000', '225', '60', 'HC', 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) Traceback (most recent call last): File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: datatype mismatch The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/app/models/query_detail.py", line 129, in run self.db.insert_detail( File "/app/models/database.py", line 1029, in insert_detail detail = self.get_detail_date(usage_point_id, date, mesure_type) File "/app/models/database.py", line 927, in get_detail_date return self.session.scalars( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1771, in scalars return self.execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 312, in orm_pre_session_exec session._autoflush() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in autoflush util.raise(e, with_traceback=sys.excinfo()[2]) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3386, in flush self._flush(objects) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3526, in _flush transaction.rollback(_captureexception=True) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in exit compat.raise( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3486, in _flush flush_context.execute() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj _emit_insert_statements( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1097, in _emit_insert_statements c = connection._execute_20( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection return connection._execute_clauseelement( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement ret = self._execute_context( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context self._handle_dbapi_exception( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapiexception util.raise( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_detail (id, usage_point_id, date, value, interval, measure_type, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('4d3af6e05e335f0dccdbdce85d6e550b', '14881765491878', '2022-12-06 00:00:00.000000', '225', '60', 'HC', 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2023-01-10 23:51:52.078 - ERROR : ═══════════════════════════════════════════════•°• :ERREUR: •°•════════════════════════════════════════════════ 2023-01-10 23:51:52.078 - ERROR : 2023-01-10 23:51:52.078 - ERROR : (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_detail (id, usage_point_id, date, value, interval, measure_type, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('4d3af6e05e335f0dccdbdce85d6e550b', '14881765491878', '2022-12-06 00:00:00.000000', '225', '60', 'HC', 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2023-01-10 23:51:52.078 - ERROR : 2023-01-10 23:51:52.078 - ERROR : ═══════════════════════════════════════════════════════════════════════════════════════════════════════════════ 2023-01-10 23:51:52.078 - ERROR : ═══════════════════════════════════════════════•°• :ERREUR: •°•════════════════════════════════════════════════ 2023-01-10 23:51:52.078 - ERROR : 2023-01-10 23:51:52.078 - ERROR : Echec de la récupération des données. 2023-01-10 23:51:52.078 - ERROR : => MyElectricalData est indisponible. 2023-01-10 23:51:52.078 - ERROR : => 2022-11-29 -> 2022-12-06 2023-01-10 23:51:52.079 - ERROR : 2023-01-10 23:51:52.079 - ERROR : ═══════════════════════════════════════════════════════════════════════════════════════════════════════════════ 2023-01-10 23:51:52.079 - INFO : Récupération des données : 2022-12-01 => 2022-12-06 2023-01-10 23:51:52.160 - INFO : - 8639m absente du relevé. 2023-01-10 23:51:52.166 - INFO : => Chargement des données depuis MyElectricalData 2022-12-01 => 2022-12-06 2023-01-10 23:51:52.389 - ERROR : (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_detail (id, usage_point_id, date, value, interval, measure_type, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('2f40bc2ff7267da40669b7aedb23b809', '14881765491878', '2022-12-01 00:00:00.000000', '0', '60', 'HC', 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) Traceback (most recent call last): File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: datatype mismatch The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/app/models/query_detail.py", line 129, in run self.db.insert_detail( File "/app/models/database.py", line 1029, in insert_detail detail = self.get_detail_date(usage_point_id, date, mesure_type) File "/app/models/database.py", line 927, in get_detail_date return self.session.scalars( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1771, in scalars return self.execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 312, in orm_pre_session_exec session._autoflush() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in autoflush util.raise(e, with_traceback=sys.excinfo()[2]) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3386, in flush self._flush(objects) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3526, in _flush transaction.rollback(_captureexception=True) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in exit compat.raise( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3486, in _flush flush_context.execute() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj _emit_insert_statements( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1097, in _emit_insert_statements c = connection._execute_20( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection return connection._execute_clauseelement( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement ret = self._execute_context( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context self._handle_dbapi_exception( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapiexception util.raise( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_detail (id, usage_point_id, date, value, interval, measure_type, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('2f40bc2ff7267da40669b7aedb23b809', '14881765491878', '2022-12-01 00:00:00.000000', '0', '60', 'HC', 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2023-01-10 23:51:52.405 - ERROR : ═══════════════════════════════════════════════•°• :ERREUR: •°•════════════════════════════════════════════════ 2023-01-10 23:51:52.405 - ERROR : 2023-01-10 23:51:52.405 - ERROR : (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (sqlite3.IntegrityError) datatype mismatch [SQL: INSERT INTO consumption_detail (id, usage_point_id, date, value, interval, measure_type, blacklist, fail_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('2f40bc2ff7267da40669b7aedb23b809', '14881765491878', '2022-12-01 00:00:00.000000', '0', '60', 'HC', 0, 0)] (Background on this error at: https://sqlalche.me/e/14/gkpj) 2023-01-10 23:51:52.405 - ERROR : 2023-01-10 23:51:52.405 - ERROR : ═══════════════════════════════════════════════════════════════════════════════════════════════════════════════ 2023-01-10 23:51:52.406 - ERROR : ═══════════════════════════════════════════════•°• :ERREUR: •°•════════════════════════════════════════════════ 2023-01-10 23:51:52.423 - ERROR : 2023-01-10 23:51:52.423 - ERROR : Echec de la récupération des données. 2023-01-10 23:51:52.423 - ERROR : => MyElectricalData est indisponible. 2023-01-10 23:51:52.423 - ERROR : => 2022-12-01 -> 2022-12-06 2023-01-10 23:51:52.423 - ERROR : 2023-01-10 23:51:52.423 - ERROR : ═══════════════════════════════════════════════════════════════════════════════════════════════════════════════ 2023-01-10 23:51:52.424 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:52.424 - INFO : [14881765491878] RÉCUPÉRATION DE LA PUISSANCE MAXIMUN JOURNALIÈRE : 2023-01-10 23:51:52.424 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:52.514 - INFO : Récupération des données : 2022-12-01 => 2023-01-10 2023-01-10 23:51:53.082 - INFO : => Chargement des données depuis MyElectricalData 2022-12-01 => 2023-01-10 2023-01-10 23:51:55.008 - INFO : => 0 2023-01-10 23:51:55.014 - INFO : last_month 2023-01-10 23:51:55.026 - INFO : => 0 2023-01-10 23:51:55.031 - INFO : current_month 2023-01-10 23:51:55.039 - INFO : => 0 2023-01-10 23:51:55.046 - INFO : current_month_last_year 2023-01-10 23:51:55.060 - INFO : => 0 2023-01-10 23:51:55.063 - INFO : last_month_last_year 2023-01-10 23:51:55.073 - INFO : => 0 2023-01-10 23:51:55.078 - INFO : current_year 2023-01-10 23:51:55.088 - INFO : => 0 2023-01-10 23:51:55.093 - INFO : current_year_last_year 2023-01-10 23:51:55.109 - INFO : => 0 2023-01-10 23:51:55.113 - INFO : last_year 2023-01-10 23:51:55.135 - INFO : => 0 2023-01-10 23:51:55.142 - INFO : yesterday_hp / yesterday_hc 2023-01-10 23:51:55.151 - INFO : => HC : 0 2023-01-10 23:51:55.159 - INFO : => HP : 0 2023-01-10 23:51:55.160 - INFO : peak_offpeak_percent_hp VS peak_offpeak_percent_hc 2023-01-10 23:51:55.173 - INFO : => 0 2023-01-10 23:51:55.180 - INFO : current_week_evolution 2023-01-10 23:51:55.181 - INFO : => 0 2023-01-10 23:51:55.183 - INFO : current_month_evolution 2023-01-10 23:51:55.184 - INFO : => 0 2023-01-10 23:51:55.186 - INFO : yesterday_evolution 2023-01-10 23:51:55.188 - INFO : yesterday 2023-01-10 23:51:55.204 - INFO : => 0 2023-01-10 23:51:55.207 - INFO : yesterday_1 2023-01-10 23:51:55.218 - INFO : => 0 2023-01-10 23:51:55.240 - INFO : => 0 2023-01-10 23:51:55.242 - INFO : monthly_evolution 2023-01-10 23:51:55.243 - INFO : last_month 2023-01-10 23:51:55.253 - INFO : => 0 2023-01-10 23:51:55.260 - INFO : last_month_last_year 2023-01-10 23:51:55.274 - INFO : => 0 2023-01-10 23:51:55.279 - INFO : => 0 2023-01-10 23:51:56.515 - INFO : current_week 2023-01-10 23:51:56.534 - INFO : => 0 2023-01-10 23:51:56.536 - INFO : last_week 2023-01-10 23:51:56.549 - INFO : => 0 2023-01-10 23:51:56.552 - INFO : current_week_last_year 2023-01-10 23:51:56.562 - INFO : => 0 2023-01-10 23:51:56.567 - INFO : last_month 2023-01-10 23:51:56.577 - INFO : => 0 2023-01-10 23:51:56.583 - INFO : current_month 2023-01-10 23:51:56.592 - INFO : => 0 2023-01-10 23:51:56.598 - INFO : current_month_last_year 2023-01-10 23:51:56.611 - INFO : => 0 2023-01-10 23:51:56.616 - INFO : last_month_last_year 2023-01-10 23:51:56.630 - INFO : => 0 2023-01-10 23:51:56.631 - INFO : current_year 2023-01-10 23:51:56.642 - INFO : => 0 2023-01-10 23:51:56.648 - INFO : current_year_last_year 2023-01-10 23:51:56.658 - INFO : => 0 2023-01-10 23:51:56.664 - INFO : last_year 2023-01-10 23:51:56.674 - INFO : => 0 2023-01-10 23:51:56.679 - INFO : yesterday_hp / yesterday_hc 2023-01-10 23:51:56.694 - INFO : => HC : 0 2023-01-10 23:51:56.697 - INFO : => HP : 0 2023-01-10 23:51:56.697 - INFO : peak_offpeak_percent_hp VS peak_offpeak_percent_hc 2023-01-10 23:51:56.707 - INFO : => 0 2023-01-10 23:51:56.714 - INFO : current_week_evolution 2023-01-10 23:51:56.715 - INFO : => 0 2023-01-10 23:51:56.715 - INFO : current_month_evolution 2023-01-10 23:51:56.716 - INFO : => 0 2023-01-10 23:51:56.717 - INFO : yesterday_evolution 2023-01-10 23:51:56.718 - INFO : yesterday 2023-01-10 23:51:56.728 - INFO : => 0 2023-01-10 23:51:56.733 - INFO : yesterday_1 2023-01-10 23:51:56.743 - INFO : => 0 2023-01-10 23:51:56.749 - INFO : => 0 2023-01-10 23:51:56.751 - INFO : monthly_evolution 2023-01-10 23:51:56.752 - INFO : last_month 2023-01-10 23:51:56.780 - INFO : => 0 2023-01-10 23:51:56.784 - INFO : last_month_last_year 2023-01-10 23:51:56.801 - INFO : => 0 2023-01-10 23:51:56.808 - INFO : => 0 2023-01-10 23:51:58.068 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:58.074 - INFO : EXPORT TERMINÉ 2023-01-10 23:51:58.074 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:58.074 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:58.074 - INFO : EXPORTATION INFLUXDB 2023-01-10 23:51:58.074 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:58.074 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:58.074 - INFO : [14881765491878] EXPORTATION DES DONNÉES "CONSUMPTION" DANS INFLUXDB 2023-01-10 23:51:58.075 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:58.112 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:58.118 - INFO : [14881765491878] EXPORTATION DES DONNÉES "CONSUMPTION_DETAIL" DANS INFLUXDB 2023-01-10 23:51:58.118 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:58.133 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:58.137 - INFO : EXPORT TERMINÉ 2023-01-10 23:51:58.138 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:58.139 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2023-01-10 23:51:58.141 - INFO : ▌│█║▌║▌║ ____ ║▌║▌║█│▌ 2023-01-10 23:51:58.143 - INFO : ▌│█║▌║▌║ | | | |_ | |() _ () | | | || || | ║▌║▌║█│▌ 2023-01-10 23:51:58.144 - INFO : ▌│█║▌║▌║ | | | ' ` \ | ' \ / \ | '|| | | | | || ' \ | |/ || ' \ | || || | ║▌║▌║█│▌ 2023-01-10 23:51:58.144 - INFO : ▌│█║▌║▌║ | | | | | | | || |) || () || | | | | | | || | | || |_ | | | ||||||_| ║▌║▌║█│▌ 2023-01-10 23:51:58.145 - INFO : ▌│█║▌║▌║ |__||| || ||| ./ __/ || _| || |||| |||||__/|| ||()()() ║▌║▌║█│▌ 2023-01-10 23:51:58.146 - INFO : ▌│█║▌║▌║ |_| ║▌║▌║█│▌ 2023-01-10 23:51:58.146 - INFO : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ◦ ❖ ◦ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

LGO44 commented 1 year ago

Le problème persiste toujours! Les accès à myelectricaldata sont valides cf résultats suivants.

verification des accès : ~ curl -X GET "https://www.myelectricaldata.fr/valid_access/142875541xxxx" -H "Authorization: xxxxxxxxxxxxxxxxx"

{"valid":true,"information":"","consent_expiration_date":"2026-01-14T09:57:31","call_number":12,"quota_reached":false,"quota_limit":50,"quota_reset_at":"2023-01-14T23:59:59.999999","last_call":"2022-12-11T09:38:45.449950","ban":false}#

Accès au données www.myelectricaldat.txt

valderaplets commented 1 year ago

Au temps pour moi :

sensor.myelectricaldata_XXXXX => ne remonte que des 0
sensor.myelectricaldata_consumption_XXXXX => remonte les bonnes valeurs

m4dm4rtig4n commented 1 year ago

@LGO44 c'est ton cache qui est corrompue, wipe le et relance l'importation.

MyElectricalData / myelectricaldata_import

[BUG] - ne remonte que des zéros #268

card_myenedis: true

discovery: true

Est-ce que tu as bien de la donnée chez Enedis ?

Que disent les logs ?

ma configuration ( j'espère plus lisible?)

Video des données myelectricaldata et myenedis