{"id":373,"date":"2021-03-03T17:06:10","date_gmt":"2021-03-03T08:06:10","guid":{"rendered":"https:\/\/sakae-shokai.com\/?p=373"},"modified":"2021-03-03T17:06:10","modified_gmt":"2021-03-03T08:06:10","slug":"esp32-%e8%a4%87%e5%90%88%e3%82%bb%e3%83%b3%e3%82%b5bme680%e3%81%a7%e6%b8%ac%e5%ae%9a%e3%81%97%e3%81%9f%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92mariadb%e3%81%ab%e3%81%a8%e3%81%b0%e3%81%99","status":"publish","type":"post","link":"https:\/\/sakae-shokai.com\/wordpress\/?p=373","title":{"rendered":"ESP32 \u8907\u5408\u30bb\u30f3\u30b5BME680\u3067\u6e2c\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u3068\u3070\u3059"},"content":{"rendered":"\n<p>\u5148\u65e5\u4ed5\u5165\u308c\u305fBME680\u3092\u7528\u3044\u3066\u6e29\u5ea6\u3001\u6e7f\u5ea6\u3001\u6c17\u5727\u3001\u30ac\u30b9\u6fc3\u5ea6\u3092\u6e2c\u5b9a\u3057\u3066MariaDB\u306b\u98db\u3070\u3057\u3066\u8a18\u9332\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002\u4eca\u56de\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u3067\u3059\u3002\u5148\u306bWi-Fi\u306b\u3064\u306a\u3044\u3067\u304b\u3089run\u3055\u305b\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><\/div>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:python decode:true \" title=\"bmetest2.py\">import ujson\nimport urequests\n\nfrom machine import Pin,I2C\nfrom time import sleep\nfrom bme680 import *\np21 = Pin(21, Pin.IN, Pin.PULL_UP)\np23 = Pin(23, Pin.IN, Pin.PULL_UP)\n\ni2c = I2C(scl=Pin(21), sda=Pin(23))\n\nwhile True:\n  try:\n    bme = BME680_I2C(i2c=i2c) \n    temp = str(round(bme.temperature, 2))\n    hum = str(round(bme.humidity, 2))\n    pres = str(round(bme.pressure, 2))\n    gas = str(round(bme.gas\/1000, 2))\n\n    print('Temperature:', temp)\n    print('Humidity:', hum)\n    print('Pressure:', pres)\n    print('Gas:', gas)\n\n    dict = {\n            \"temp_value\":temp,\n            \"hum_value\":hum,\n            \"pres_value\":pres,\n            \"gas_value\":gas\n            }\n    response = urequests.post(\n            'https:\/\/***url***\/postrcv.php',\n            data=ujson.dumps(dict).encode(\"utf-8\"),\n                headers={'Content-Type': 'application\/json'}\n            )\n    print  (response.text)\n  except OSError as e:\n    print('Failed to read sensor.')\n \n  sleep(10)\n  <\/pre><\/div>\n\n\n\n<p>\u5b9f\u884c\u7d50\u679c\u3067\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>C:\\Users\\&gt;ampy -p com3 run c:\\micropython\\posttest8.py\nWarning: I2C(-1, ...) is deprecated, use SoftI2C(...) instead\nTemperature: 17.36\nHumidity: 54.01\nPressure: 1019.21\nGas: 56.24\n\"temp=17.36 , hum=54.01 , pres=1019.21, gas=56.24\"New record created successfully\nTemperature: 17.35\nHumidity: 54.14\nPressure: 1019.22\nGas: 54.43\n\"temp=17.35 , hum=54.14 , pres=1019.22, gas=54.43\"New record created successfully\nTemperature: 17.41\nHumidity: 54.15\nPressure: 1019.24\nGas: 53.23\n\"temp=17.41 , hum=54.15 , pres=1019.24, gas=53.23\"New record created successfully\nTemperature: 17.48\nHumidity: 54.03\nPressure: 1019.2\nGas: 52.34\n\"temp=17.48 , hum=54.03 , pres=1019.2, gas=52.34\"New record created successfully\n\nAborted!<\/code><\/pre>\n\n\n\n<p>\u3057\u3063\u304b\u308a\u306810\u79d2\u304a\u304d\u306bDB\u306b\u8a18\u9332\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u6b21\u56de\u306f\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u898b\u76f4\u3057\u3001\u5358\u72ec\u3067\u81ea\u52d5\u904b\u8ee2\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5148\u65e5\u4ed5\u5165\u308c\u305fBME680\u3092\u7528\u3044\u3066\u6e29\u5ea6\u3001\u6e7f\u5ea6\u3001\u6c17\u5727\u3001\u30ac\u30b9\u6fc3\u5ea6\u3092\u6e2c\u5b9a\u3057\u3066MariaDB\u306b\u98db\u3070\u3057\u3066\u8a18\u9332\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002\u4eca\u56de\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u3067\u3059\u3002\u5148\u306bWi-Fi\u306b\u3064\u306a\u3044\u3067\u304b\u3089run\u3055\u305b\u307e\u3059\u3002 \u5b9f\u884c\u7d50\u679c\u3067\u3059\u3002 \u3057\u3063\u304b\u308a\u306810\u79d2\u304a\u304d\u306b &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/sakae-shokai.com\/wordpress\/?p=373\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;ESP32 \u8907\u5408\u30bb\u30f3\u30b5BME680\u3067\u6e2c\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u3068\u3070\u3059&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":234,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,39,16],"tags":[18,40,19],"class_list":["post-373","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-esp32","category-mariadb","category-micropython","tag-esp32","tag-mariadb","tag-micropython"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/373","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=373"}],"version-history":[{"count":5,"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/373\/revisions"}],"predecessor-version":[{"id":378,"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/373\/revisions\/378"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/234"}],"wp:attachment":[{"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}