Bonjour et merci à toi pour ton aide, donc ça je l’avais fait la semaine, ça a bien démarré mais il ne me remontait que de fausses infos et jamais celle de la veille, j’ai donc laissé tourné la semaine et chaque jour pareille… Là aujourd’hui j’ai mit à jour l’addons, j’ai refait le consentement comme mentionné et vérifié que la collecte des données est bine active sur enedis, voici les retours:
➜ ~ curl -X GET "https://www.myelectricaldata.fr/valid_access/24323878276236" -H "Authorization: Rk_AMzlSHCUbwhVVJ69LipkE3eBuVQS1EHaVS2YupZQ="
{"valid":true,"information":"","consent_expiration_date":"2025-12-11T14:02:04","call_number":0,"quota_reached":false,"quota_limit":50,"quota_reset_at":"2022-12-11T23:59:59.999999","last_call":"2022-12-11T14:02:04.100252","ban":false}#
➜ ~ curl -X GET "https://www.myelectricaldata.fr/consumption_load_curve/24323878276236/start/2022-12-03/end/2022-12-10" -H "Authorization: Rk_AMzlSHCUbwhVVJ69LipkE3eBuVQS1EHaVS2YupZQ=" | jq
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 30612 100 30612 0 0 5672 0 0:00:05 0:00:05 --:--:-- 7363
{
"meter_reading": {
"usage_point_id": "24323878276236",
"start": "2022-12-03",
"end": "2022-12-10",
"quality": "BRUT",
"reading_type": {
"measurement_kind": "power",
"unit": "W",
"aggregate": "average"
},
"interval_reading": [
{
"value": "518",
"date": "2022-12-03 00:30:00",
"interval_length": "PT30M",
"measure_type": "B"
},
{
"value": "974",
"date": "2022-12-03 01:00:00",
"interval_length": "PT30M",
"measure_type": "B"
},
{
"value": "534",
"date": "2022-12-03 01:30:00",
"interval_length": "PT30M",
"measure_type": "B"
},
{
"value": "536",
"date": "2022-12-03 02:00:00",
"interval_length": "PT30M",
"measure_type": "B"
},
{
"value": "922",
"date": "2022-12-03 02:30:00",
"interval_length": "PT30M",
"measure_type": "B"
},
{
"value": "694",
"date": "2022-12-03 03:00:00",
"interval_length": "PT30M",
"measure_type": "B"
},
{
"value": "508",
"date": "2022-12-03 03:30:00",
"interval_length": "PT30M",
"measure_type": "B"
},
{
"value": "608",
"date": "2022-12-03 04:00:00",
"interval_length": "PT30M",
"measure_type": "B"
},
{
"value": "930",
"date": "2022-12-03 04:30:00",
"interval_length": "PT30M",
"measure_type": "B"
},
{
"value": "518",
"date": "2022-12-03 05:00:00",
"interval_length": "PT30M",
"measure_type": "B"
},
{
"value": "494",
"date": "2022-12-03 05:30:00",
"interval_length": "PT30M",
"measure_type": "B"
},
{
"value": "892",
"date": "2022-12-03 06:00:00",
"interval_length": "PT30M",
"measure_type": "B"
},
{
"value": "648",
"date": "2022-12-03 06:30:00",
"interval_length": "PT30M",
"measure_type": "B"
},
{
"value": "470",
"date": "2022-12-03 07:00:00",
"interval_length": "PT30M",
"measure_type": "B"
},
{
"value": "598",
"date": "2022-12-03 07:30:00",
"interval_length": "PT30M",
"measure_type": "B"
},
{
"value": "1424",
"date": "2022-12-03 08:00:00",
"interval_length": "PT30M",
"measure_type": "B"
},
{
"value": "714",
"date": "2022-12-03 08:30:00",
"interval_length": "PT30M",
"measure_type": "B"
},
{
"value": "2400",
"date": "2022-12-03 09:00:00",
"interval_length": "PT30M",
"measure_type": "B"
},
{
"value": "2230",
Je n’ai pas tout mit
et quand je démarre l’addons MyElectricalData :
Starting...
/etc/cont-init.d/00-banner.sh: executing
-----------------------------------------------------------
Add-on: MyElectricalData
Use Enedis Gateway API to send data in your MQTT Broker (latest channel)
-----------------------------------------------------------
Add-on version: 0.8.8
You are running the latest version of this add-on.
System: Home Assistant OS 9.3 (aarch64 / raspberrypi3-64)
Home Assistant Core: 2022.12.1
Home Assistant Supervisor: 2022.11.2
-----------------------------------------------------------
Please, share the above information when looking for help
or support in, e.g., GitHub, forums
https://github.com/alexbelgium/hassio-addons
-----------------------------------------------------------
/etc/cont-init.d/00-global_var.sh: executing
CONFIG_LOCATION='/config/enedisgateway2mqtt/config.yaml'
TZ='Europe/Paris'
mqtt_autodiscover='true'
verbose='true'
/etc/cont-init.d/01-custom_script.sh: executing
[14:16:11] INFO: Execute /config/enedisgateway2mqtt.sh if existing
[14:16:11] INFO: ... no script found
/etc/cont-init.d/91-mqtt_autodiscover.sh: executing
[14:16:12] INFO: mqtt_autodiscover is defined in options, attempting autodiscovery...
[14:16:12] INFO: ... MQTT service found, fetching server detail (you can enter those manually in your config file) ...
Config file is a valid yaml
creating symlink
[14:17:20] INFO: Using database file found in /config/enedisgateway2mqtt/enedisgateway.db
[14:17:20] INFO: Starting the app
INFO [alembic.runtime.migration] Context impl SQLiteImpl.
INFO [alembic.runtime.migration] Will assume non-transactional DDL.
2022-12-11 14:17:28.523 - WARNING : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ▲ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2022-12-11 14:17:28.524 - WARNING : MIGRATION DE L'ANCIENNE BASE DE DONNÉES VERS LA NOUVELLE STRUCTURE.
2022-12-11 14:17:28.526 - WARNING : ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ▲ ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
2022-12-11 14:17:28.529 - WARNING : Migration des "consumption_daily"
2022-12-11 14:17:28.703 - WARNING : - 2022 => 5.75kW
2022-12-11 14:17:28.827 - WARNING : Migration des "consumption_detail"
2022-12-11 14:17:29.086 - WARNING : - 2022-03 => 0.62kW
2022-12-11 14:17:29.561 - WARNING : - 2022-04 => 530.95kW
2022-12-11 14:17:30.360 - WARNING : - 2022-05 => 549.33kW
2022-12-11 14:17:30.982 - WARNING : - 2022-06 => 412.24kW
2022-12-11 14:17:31.488 - WARNING : - 2022-07 => 386.93kW
2022-12-11 14:17:32.162 - WARNING : - 2022-08 => 559.67kW
2022-12-11 14:17:32.838 - WARNING : - 2022-09 => 659.71kW
2022-12-11 14:17:33.405 - WARNING : - 2022-10 => 421.87kW
2022-12-11 14:17:33.878 - WARNING : - 2022-11 => 297.81kW
2022-12-11 14:17:35.864 - WARNING : Migration des "production_daily"
2022-12-11 14:17:35.873 - WARNING : Migration des "production_detail"
2022-12-11 14:17:35.892 - INFO : Configure Databases
/app/models/database.py:114: SAWarning: Column 'consumption_daily.id' is marked as a member of the primary key for table 'consumption_daily', but has no Python-side or server-side default generator indicated, nor does it indicate 'autoincrement=True' or 'nullable=True', and no explicit value is passed. Primary key columns typically may not store NULL.
day = self.session.scalars(query).one_or_none()
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: NOT NULL constraint failed: consumption_daily.id
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/app/main.py", line 9, in <module>
from models.ajax import Ajax
File "/app/models/ajax.py", line 3, in <module>
from models.jobs import Job
File "/app/models/jobs.py", line 6, in <module>
from models.database import Database
File "/app/models/database.py", line 1141, in <module>
Database().init_database()
File "/app/models/database.py", line 114, in init_database
day = 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.exc_info()[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(_capture_exception=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 1238, in _emit_insert_statements
result = 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_dbapi_exception
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) NOT NULL constraint failed: consumption_daily.id
[SQL: INSERT INTO consumption_daily (usage_point_id, date, value, blacklist, fail_count) VALUES (?, ?, ?, ?, ?)]
[parameters: ('24323878276236', '2022-03-02 00:00:00.000000', 5755, 0, 0)]
(Background on this error at: https://sqlalche.me/e/14/gkpj)
[14:17:38] FATAL: The app has crashed. Are you sure you entered the correct config options?
Mon fichier de configuration n’a pas changé, je suis nul mais de ce que je comprends on dirait une erreur du coté de la database.
Merci d’avance pour ton aide