{"id":3005,"date":"2020-01-08T17:18:59","date_gmt":"2020-01-08T16:18:59","guid":{"rendered":"https:\/\/www.breizh56.fr\/crepp2024\/?page_id=3005"},"modified":"2020-01-17T11:27:33","modified_gmt":"2020-01-17T10:27:33","slug":"domoticz-data","status":"publish","type":"page","link":"https:\/\/www.breizh56.fr\/crepp2024\/domoticz-data\/","title":{"rendered":"Domoticz donn\u00e9es :divers points"},"content":{"rendered":"

<\/h4>\n

 <\/p>\n

sauvegardes des donn\u00e9es Domoticz<\/h4>\n
    \n
  1. la base des donn\u00e9es Domoticz se trouve:\u00a0\u00a0\/home\/pi\/domoticz\/domoticz.db<\/strong><\/li>\n
  2. arr\u00eat de Domoticz par commande:\n
    sudo service domoticz.sh stop<\/strong><\/pre>\n<\/li>\n
  3. copier la base des donn\u00e9es Domoticz:\u00a0\u00a0\/home\/pi\/domoticz\/domoticz.db\u00a0<\/strong>dans un autre r\u00e9pertoire comme \/Documents\/SauvDomoticz\/domoticz_200108.db<\/em><\/li>\n
  4. relancer\u00a0Domoticz par commande:\n
    sudo service domoticz.sh\u00a0restart<\/strong><\/pre>\n<\/li>\n<\/ol>\n
     <\/p>\n
    Traitement des donn\u00e9es sauvegard\u00e9es par SQL:<\/h4>\n
    installation du logiciel sqlite3:<\/strong><\/p>\n
    dans une fen\u00eatre terminal du Rapsberry\/linux tapez<\/p>\n
    sudo apt-get instal sqlite3<\/pre>\n
     <\/p>\n
    .help<\/strong> \u00a0pour lister les commandes sqlite3<\/p>\n
    .quit<\/strong> ou Ctrl+d<\/strong> pour sortir de sqlite3<\/p>\n
    Exportation des donn\u00e9es sauvegard\u00e9es:<\/p>\n
    sqlite3<\/pre>\n
    sqlite>.<\/strong>open domoticz_200108.db \u00a0 \u00a0 \u00a0<-- sauvegarde de la base Domoticz<\/pre>\n
    sqlite>.mode line<\/pre>\n
    sqlite>.tables<\/pre>\n
    la liste de toutes les tables de la base Domoticz s’affiche: jouons avec\u00a0la table Temperature qui contient les donn\u00e9es collect\u00e9es depuis le d\u00e9but.<\/p>\n
    sqlite> SELECT * from Temperature;<\/pre>\n
    \u2014\u2014> 19|12.8|0.0|80|0|9.44|0.0|2020-01-08 11:00:00<\/p>\n
    sqlite>.separator\u00a0 <\/span>\u00ab\u00a0,\u00a0\u00bb\r\nsqlite>\u00a0SELECT * from Temperature;<\/pre>\n
    \u2014\u2014> 19,12.8,0.0,80,0,9.44,0.0,2020-01-08 11:00:00<\/p>\n
    sqlite>.mode line\r\nsqlite>\u00a0SELECT * from Temperature;\u00a0 \u00a0 \u00a0<\/span>\r\n<\/pre>\n
     <\/p>\n
    DeviceRowID = 19<\/i><\/p>\n
    Temperature = 12.8<\/i> \u00a0 \u00a0 \u00a0 <\/span><\/i><\/p>\n
    Chill = 0.0<\/i> \u00a0\u00a0 <\/span><\/i><\/p>\n
    Humidity = 80<\/i> \u00a0 <\/span><\/i><\/p>\n
    Barometer = 0<\/i> \u00a0\u00a0 <\/span><\/i><\/p>\n
    DewPoint = 9.44<\/i> \u00a0\u00a0 <\/span><\/i><\/p>\n
    SetPoint = 0.0<\/i> \u00a0\u00a0 \u00a0 \u00a0 <\/span><\/i><\/p>\n
    Date = 2020-01-08 11:00:00<\/i><\/p>\n
    exportons la table Temperature dans un fichier:<\/p>\n
    sqlite> .mode list<\/b>\r\nsqlite> .separator \";\"<\/b>\r\nsqlite> .output test_file_1.txt<\/b>\r\nsqlite> select * from Temperature;<\/b>\r\nsqlite> .exit<\/b><\/pre>\n
    video:<\/p>\n
    \n