{"id":2788,"date":"2010-04-03T11:12:42","date_gmt":"2010-04-03T15:12:42","guid":{"rendered":"http:\/\/www.schollnick.net\/wordpress\/?page_id=2788"},"modified":"2012-06-20T09:22:58","modified_gmt":"2012-06-20T13:22:58","slug":"indigo-sql-hacking","status":"publish","type":"page","link":"http:\/\/www.schollnick.net\/wordpress\/home-automation\/indigo-sql-hacking\/","title":{"rendered":"Indigo SQL &#8220;Hacking&#8221;"},"content":{"rendered":"<p>Indigo Version 4 Professional has the option to log all your data to an SQL table&#8230;  But I haven&#8217;t seen any significant documentation on this, at this point.<\/p>\n<p>The default sql database filename is sqlite_db, and is located at \/library\/Application Support\/Perceptive Automation\/Indigo 4\/IndigoSqlClient.<\/p>\n<p>Please note, this is not based on any documentation&#8230; \u00c2\u00a0Please feel free to offer suggestions and improvements&#8230;.<\/p>\n<p>The tables contained within the database are:<\/p>\n<ul>\n<li>device_history_basic<\/li>\n<li>device_history_multi_io<\/li>\n<li>variable_history<\/li>\n<li>device_history_hvac<\/li>\n<li>device_history_sprinkler<\/li>\n<\/ul>\n<p>And the structures are as follows:<\/p>\n<p>Table Name: \u00c2\u00a0device_history_basic<\/p>\n<ol>\n<li>id \u00c2\u00a0 \u00c2\u00a0&#8211; INTEGER PRIMARY KEY<\/li>\n<li>ts \u00c2\u00a0 \u00c2\u00a0&#8211; TIMESTAMP DEFAULT CURRENT_TIMESTAMP<\/li>\n<li>dev_name \u00c2\u00a0&#8211; VARCHAR(255) NOT NULL<\/li>\n<li>dev_state \u00c2\u00a0 &#8211; BOOL<\/li>\n<li>dev_value \u00c2\u00a0&#8211; SMALLINT<\/li>\n<\/ol>\n<div id=\"_mcePaste\">Table Name: \u00c2\u00a0device_history_hvac<\/div>\n<div>\n<ol>\n<li>id\t\t\t\tINTEGER PRIMARY KEY,<\/li>\n<li>ts\t\t\t\tTIMESTAMP DEFAULT CURRENT_TIMESTAMP,<\/li>\n<li>dev_name\t\tVARCHAR(255) NOT NULL,<\/li>\n<li>temperature\t\tSMALLINT,<\/li>\n<li>humidity\t\tSMALLINT,<\/li>\n<li>setpoint_cool\tSMALLINT,<\/li>\n<li>setpoint_heat\tSMALLINT,<\/li>\n<li>current_mode\tVARCHAR(255) NOT NULL,<\/li>\n<li>fan_mode\t\tVARCHAR(255) NOT NULL<\/li>\n<\/ol>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Indigo Version 4 Professional has the option to log all your data to an SQL table&#8230; But I haven&#8217;t seen any significant documentation on this, at this point. The default sql database filename is sqlite_db, and is located at \/library\/Application Support\/Perceptive Automation\/Indigo 4\/IndigoSqlClient. Please note, this is not based on any documentation&#8230; \u00c2\u00a0Please feel free <a class=\"read-more\" href=\"http:\/\/www.schollnick.net\/wordpress\/home-automation\/indigo-sql-hacking\/\">[&hellip;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":35,"menu_order":4,"comment_status":"open","ping_status":"open","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"_links":{"self":[{"href":"http:\/\/www.schollnick.net\/wordpress\/wp-json\/wp\/v2\/pages\/2788"}],"collection":[{"href":"http:\/\/www.schollnick.net\/wordpress\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.schollnick.net\/wordpress\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.schollnick.net\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.schollnick.net\/wordpress\/wp-json\/wp\/v2\/comments?post=2788"}],"version-history":[{"count":0,"href":"http:\/\/www.schollnick.net\/wordpress\/wp-json\/wp\/v2\/pages\/2788\/revisions"}],"up":[{"embeddable":true,"href":"http:\/\/www.schollnick.net\/wordpress\/wp-json\/wp\/v2\/pages\/35"}],"wp:attachment":[{"href":"http:\/\/www.schollnick.net\/wordpress\/wp-json\/wp\/v2\/media?parent=2788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<!-- WP Super Cache is installed but broken. The constant WPCACHEHOME must be set in the file wp-config.php and point at the WP Super Cache plugin directory. -->