当一个账号绑定有多个电表户号的时候，往数据库写入只会写入第一个户号的数据
Closed this issue · 1 comments
Latezly commented
2024-09-05 03:42:31 [INFO ] ---- Login successfully on https://www.95598.cn/osgweb/login
2024-09-05 03:42:51 [INFO ] ---- There are 2 users in total, there user_id is: ['42xxxxxxxxxxx', '31xxxxxxxxxxx']
2024-09-05 03:43:13 [INFO ] ---- Get electricity charge balance for 42xxxxxxxxxxx successfully, balance is -32.78 CNY.
2024-09-05 03:43:24 [INFO ] ---- Get electricity charge balance for 31xxxxxxxxxxx successfully, balance is 1063.7 CNY.
2024-09-05 03:43:46 [INFO ] ---- Get year power usage for 42xxxxxxxxxxx successfully, usage is 7126 kwh
2024-09-05 03:43:46 [INFO ] ---- Get year power charge for 42xxxxxxxxxxx successfully, yealrly charge is 4806.11 CNY
2024-09-05 03:43:56 [INFO ] ---- Get month power charge for 42xxxxxxxxxxx successfully, 2024-01-01-2024-02-01 usage is 963 KWh, charge is 537.35 CNY.
2024-09-05 03:43:56 [INFO ] ---- Get month power charge for 42xxxxxxxxxxx successfully, 2024-02-01-2024-03-01 usage is 932 KWh, charge is 520.06 CNY.
2024-09-05 03:43:56 [INFO ] ---- Get month power charge for 42xxxxxxxxxxx successfully, 2024-03-01-2024-03-31 usage is 807 KWh, charge is 477.41 CNY.
2024-09-05 03:43:56 [INFO ] ---- Get month power charge for 42xxxxxxxxxxx successfully, 2024-04-01-2024-04-30 usage is 749 KWh, charge is 455.39 CNY.
2024-09-05 03:43:56 [INFO ] ---- Get month power charge for 42xxxxxxxxxxx successfully, 2024-05-01-2024-05-31 usage is 686 KWh, charge is 417.09 CNY.
2024-09-05 03:43:56 [INFO ] ---- Get month power charge for 42xxxxxxxxxxx successfully, 2024-06-01-2024-06-30 usage is 808 KWh, charge is 527.51 CNY.
2024-09-05 03:43:56 [INFO ] ---- Get month power charge for 42xxxxxxxxxxx successfully, 2024-07-01-2024-07-31 usage is 957 KWh, charge is 821.11 CNY.
2024-09-05 03:43:56 [INFO ] ---- Get month power charge for 42xxxxxxxxxxx successfully, 2024-08-01-2024-08-31 usage is 1224 KWh, charge is 1050.19 CNY.
2024-09-05 03:44:16 [INFO ] ---- Database of sgcc_electricity_homeassistant.db created successfully.
2024-09-05 03:44:16 [INFO ] ---- The electricity consumption of 37.41KWh on 2024-09-02 has been successfully deposited into the database
2024-09-05 03:44:16 [INFO ] ---- The electricity consumption of 41.97KWh on 2024-09-01 has been successfully deposited into the database
2024-09-05 03:44:16 [INFO ] ---- The electricity consumption of 37.44KWh on 2024-08-31 has been successfully deposited into the database
2024-09-05 03:44:16 [INFO ] ---- The electricity consumption of 28.31KWh on 2024-08-30 has been successfully deposited into the database
2024-09-05 03:44:16 [INFO ] ---- The electricity consumption of 23.83KWh on 2024-08-29 has been successfully deposited into the database
2024-09-05 03:44:16 [INFO ] ---- Get daily power consumption for 42xxxxxxxxxxx successfully, , 2024-09-02 usage is 37.41 kwh.
2024-09-05 03:44:37 [INFO ] ---- Get year power usage for 31xxxxxxxxxxx successfully, usage is 7293 kwh
2024-09-05 03:44:37 [INFO ] ---- Get year power charge for 31xxxxxxxxxxx successfully, yealrly charge is 4433.6 CNY
2024-09-05 03:44:47 [INFO ] ---- Get month power charge for 31xxxxxxxxxxx successfully, 2024-01-01-2024-02-01 usage is 1070 KWh, charge is 506.2 CNY.
2024-09-05 03:44:47 [INFO ] ---- Get month power charge for 31xxxxxxxxxxx successfully, 2024-02-01-2024-03-01 usage is 885 KWh, charge is 426 CNY.
2024-09-05 03:44:47 [INFO ] ---- Get month power charge for 31xxxxxxxxxxx successfully, 2024-03-10-2024-04-01 usage is 729 KWh, charge is 354.7 CNY.
2024-09-05 03:44:47 [INFO ] ---- Get month power charge for 31xxxxxxxxxxx successfully, 2024-04-01-2024-04-30 usage is 530 KWh, charge is 264.4 CNY.
2024-09-05 03:44:47 [INFO ] ---- Get month power charge for 31xxxxxxxxxxx successfully, 2024-05-01-2024-05-31 usage is 589 KWh, charge is 327.7 CNY.
2024-09-05 03:44:47 [INFO ] ---- Get month power charge for 31xxxxxxxxxxx successfully, 2024-06-01-2024-06-30 usage is 838 KWh, charge is 477.6 CNY.
2024-09-05 03:44:47 [INFO ] ---- Get month power charge for 31xxxxxxxxxxx successfully, -2024-07-31 usage is 1309 KWh, charge is 1013.3 CNY.
2024-09-05 03:44:47 [INFO ] ---- Get month power charge for 31xxxxxxxxxxx successfully, 2024-08-01-2024-08-31 usage is 1343 KWh, charge is 1063.7 CNY.
2024-09-05 03:45:08 [INFO ] ---- The electricity consumption of 26.88KWh on 2024-09-03 has been successfully deposited into the database
2024-09-05 03:45:08 [INFO ] ---- The electricity consumption of 19.96KWh on 2024-09-02 has been successfully deposited into the database
2024-09-05 03:45:08 [INFO ] ---- The electricity consumption of 45.81KWh on 2024-09-01 has been successfully deposited into the database
2024-09-05 03:45:08 [INFO ] ---- The electricity consumption of 49.34KWh on 2024-08-31 has been successfully deposited into the database
2024-09-05 03:45:08 [INFO ] ---- The electricity consumption of 34.34KWh on 2024-08-30 has been successfully deposited into the database
2024-09-05 03:45:08 [INFO ] ---- The electricity consumption of 34.03KWh on 2024-08-29 has been successfully deposited into the database
root@f059f3495ad2:/app# sqlite3 sgcc_electricity_homeassistant.db
SQLite version 3.34.1 2021-01-20 14:10:07
Enter ".help" for usage hints.
sqlite> .database
main: /app/sgcc_electricity_homeassistant.db r/w
sqlite> .table
daily42xxxxxxxxxxx
ARC-MX commented
已修复