{"id":379,"date":"2021-03-04T19:12:00","date_gmt":"2021-03-04T10:12:00","guid":{"rendered":"https:\/\/sakae-shokai.com\/?p=379"},"modified":"2021-03-03T18:13:56","modified_gmt":"2021-03-03T09:13:56","slug":"esp32%e3%80%80bme680%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%e3%80%80%e3%81%9d%e3%81%ae%ef%bc%92","status":"publish","type":"post","link":"https:\/\/sakae-shokai.com\/wordpress\/?p=379","title":{"rendered":"ESP32\u3000BME680\u3067\u6e2c\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u3068\u3070\u3059\u3000\u305d\u306e\uff12"},"content":{"rendered":"\n<p>\u5148\u65e5BME680\u306e\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u98db\u3070\u3057\u307e\u3057\u305f\u304c\u3001\u30b9\u30bf\u30f3\u30c9\u30a2\u30ed\u30f3\u3067\u81ea\u52d5\u6e2c\u5b9a\u3067\u304d\u308b\u3088\u3046\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u66f4\u65b0\u3057\u307e\u3057\u305f\u3002\u307e\u305f\u3001Wi-Fi\u306b\u63a5\u7d9a\u3057\u3066\u3044\u308b\u969b\u306b\uff2c\uff25\uff24\u3092\u70b9\u706f\u3055\u305b\u308b\u3053\u3068\u3068\u3057\u307e\u3057\u305f\u3002\u30d4\u30f3\uff14\u756a\u306b\u30d7\u30eb\u30a2\u30c3\u30d7\u62b5\u6297\u3092\u4ecb\u3057\u3066\uff2c\uff25\uff24\u3092\u63a5\u7d9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"768\" src=\"https:\/\/sakae-shokai.com\/wordpress\/wp-content\/uploads\/2021\/03\/D51D164C-A4FE-4F57-AE8F-E806E8FBC100-1024x768.jpeg\" alt=\"\" class=\"wp-image-383\" srcset=\"https:\/\/sakae-shokai.com\/wordpress\/wp-content\/uploads\/2021\/03\/D51D164C-A4FE-4F57-AE8F-E806E8FBC100-1024x768.jpeg 1024w, https:\/\/sakae-shokai.com\/wordpress\/wp-content\/uploads\/2021\/03\/D51D164C-A4FE-4F57-AE8F-E806E8FBC100-300x225.jpeg 300w, https:\/\/sakae-shokai.com\/wordpress\/wp-content\/uploads\/2021\/03\/D51D164C-A4FE-4F57-AE8F-E806E8FBC100-768x576.jpeg 768w, https:\/\/sakae-shokai.com\/wordpress\/wp-content\/uploads\/2021\/03\/D51D164C-A4FE-4F57-AE8F-E806E8FBC100-1536x1152.jpeg 1536w, https:\/\/sakae-shokai.com\/wordpress\/wp-content\/uploads\/2021\/03\/D51D164C-A4FE-4F57-AE8F-E806E8FBC100.jpeg 1920w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><figcaption>\u5de6\u4e0a\u306bLED\u3092\u3064\u3051\u3066\u3044\u307e\u3059Wi-Fi\u63a5\u7d9a\u3067\u70b9\u706f\u3057\u307e\u3059\u3002<\/figcaption><\/figure>\n\n\n\n<p>\u4ee5\u4e0b\u304c\u30d7\u30ed\u30b0\u30e9\u30e0\u3067\u3059\u3002\u30d6\u30fc\u30c8\u3057\u305f\u969b\u306b\u81ea\u52d5\u7684\u306b\u8d70\u3089\u305b\u308b\u305f\u3081\u306b\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u540d\u306fmain.py\u306b\u3057\u3066\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:python decode:true \" title=\"main.py\" >from machine import Pin,SoftI2C\nfrom bme680 import *\nimport ntptime\nimport utime\nimport ujson\nimport urequests\n\nUTC_OFFSET=9\np21 = Pin(21, Pin.IN, Pin.PULL_UP)\np23 = Pin(23, Pin.IN, Pin.PULL_UP)\nled = Pin(4, Pin.OUT)\ni2c = SoftI2C(scl=Pin(21), sda=Pin(23))\n\ndef do_connect():\n    import network\n    wlan = network.WLAN(network.STA_IF)\n    wlan.active(True)\n    if not wlan.isconnected():\n        print('connecting to network...')\n        wlan.connect('essid', 'password')\n        while not wlan.isconnected():\n            pass\n    print('network config:', wlan.ifconfig())\n    led.value(1)\n\n     \ndef get_jst():\n    sleep_ms(1000)\n    ntptime.settime()\n    tm=utime.localtime(utime.mktime(utime.localtime())+UTC_OFFSET*3600)\n    jst = str(tm[0])+'\/'+str(tm[1])+'\/'+str(tm[2])+' '+str(tm[3])+':'+str(tm[4])+':'+str(tm[5])\n    return(jst)\n     \ndo_connect()\nprint(get_jst())\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    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***\/datarcv.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)<\/pre><\/div>\n\n\n\n<p>\u3053\u306e\u901a\u308aWi-Fi\u306b\u63a5\u7d9a\u3059\u308b\u3068\uff2c\uff25\uff24\u304c\u3068\u3082\u308a\u307e\u3059\u3002phpMyAdmin\u3067\u78ba\u8a8d\u3059\u308b\u306810\u79d2\u304a\u304d\u306b\u30c7\u30fc\u30bf\u304c\u84c4\u7a4d\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5148\u65e5BME680\u306e\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u98db\u3070\u3057\u307e\u3057\u305f\u304c\u3001\u30b9\u30bf\u30f3\u30c9\u30a2\u30ed\u30f3\u3067\u81ea\u52d5\u6e2c\u5b9a\u3067\u304d\u308b\u3088\u3046\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u66f4\u65b0\u3057\u307e\u3057\u305f\u3002\u307e\u305f\u3001Wi-Fi\u306b\u63a5\u7d9a\u3057\u3066\u3044\u308b\u969b\u306b\uff2c\uff25\uff24\u3092\u70b9\u706f\u3055\u305b\u308b\u3053\u3068\u3068\u3057\u307e\u3057\u305f\u3002\u30d4\u30f3\uff14\u756a\u306b\u30d7\u30eb\u30a2\u30c3\u30d7\u62b5\u6297\u3092\u4ecb\u3057\u3066 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/sakae-shokai.com\/wordpress\/?p=379\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;ESP32\u3000BME680\u3067\u6e2c\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u3068\u3070\u3059\u3000\u305d\u306e\uff12&#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":[46,18,19],"class_list":["post-379","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-esp32","category-mariadb","category-micropython","tag-bme680","tag-esp32","tag-micropython"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/379","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=379"}],"version-history":[{"count":7,"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/379\/revisions"}],"predecessor-version":[{"id":387,"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/379\/revisions\/387"}],"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=379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}