{"id":8264,"date":"2024-02-28T18:24:59","date_gmt":"2024-02-28T09:24:59","guid":{"rendered":"https:\/\/arakoki70.com\/?p=8264"},"modified":"2024-12-15T15:54:49","modified_gmt":"2024-12-15T06:54:49","slug":"python%e3%81%a7-mariadb%e3%81%8b%e3%82%89%e5%8f%a4%e3%81%84%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e5%89%8a%e9%99%a4%e3%81%97-csv%e3%81%ab%e3%82%a8%e3%82%af%e3%82%b9%e3%83%9d%e3%83%bc%e3%83%88%e3%81%99","status":"publish","type":"post","link":"https:\/\/arakoki70.com\/?p=8264","title":{"rendered":"Python\u3067 MariaDB\u304b\u3089\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057 CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b"},"content":{"rendered":"<div style=\"background: #f5f5f5; padding: 10px; border: 2px solid #800000; text-align: center; box-shadow: 5px 5px 5px #aaa; font-size: 16px;\"><span style=\"font-size: 14pt;\"><strong><span style=\"font-size: 12pt;\">Ubuntu Desktop 22.04 LTS \u30ce\u30a6\u30cf\u30a6<\/span><br \/>\r\nPython + MariaDB<br \/>\r\n\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057 CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8<\/strong><\/span><\/div>\r\n<div>\u00a0<\/div>\r\n<div>Ubuntu 22.04 \u306e\u74b0\u5883\u3067\u3001Python\u3092\u4f7f\u7528\u3057\u3066MariaDB\u306e\u30c6\u30fc\u30d6\u30eb\u304b\u30891\u30ab\u6708\u4ee5\u4e0a\u7d4c\u904e\u3057\u305f\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057\u3001\u305d\u306e\u30c7\u30fc\u30bf\u3092CSV\u30d5\u30a1\u30a4\u30eb\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b\u3002<\/div>\r\n<div>\u00a0<\/div>\r\n<div><a href=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/02\/db-delete_0011.png\" data-rel=\"lightbox-gallery-gsoo7CsA\" data-rl_title=\"db-delete_0011\" data-rl_caption=\"\" title=\"db-delete_0011\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8265\" src=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/02\/db-delete_0011.png\" alt=\"\u5b9f\u884c\u7d50\u679c\uff1a\u524a\u9664\u3055\u308c\u305f\u884c\u6570\u304c\u8868\u793a\u3055\u308c\u308b\" width=\"600\" height=\"113\" \/><\/a><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u4ee5\u4e0b\u3001MariaDB\u304b\u3089\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u30af\u30ea\u30fc\u30f3\u30a2\u30c3\u30d7\u3057\u305f\u8a18\u9332\u3002<\/div>\r\n<div><!--more--><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\t<p>&nbsp;<\/p>\n\t<div align=\"center\" style=\"font-size:8pt;\">\u30b9\u30dd\u30f3\u30b5\u30fc \u30ea\u30f3\u30af<br \/>\n<!-- \t<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script> -->\n\t<!-- \u8a18\u4e8b\u30fb\u30ec\u30b9\u30dd\u30f3\u30b7\u30d6-7 -->\n\t<ins class=\"adsbygoogle\"\n     style=\"display:block\"\n     data-ad-client=\"ca-pub-3816629014893825\"\n     data-ad-slot=\"1428770894\"\n     data-ad-format=\"auto\"\n     data-full-width-responsive=\"true\"><\/ins>\n\t<script>\n\t(adsbygoogle = window.adsbygoogle || []).push({});\n\t<\/script>\n\t<amp-ad width=\"100vw\" height=\"320\"\n     type=\"adsense\"\n     data-ad-client=\"ca-pub-3816629014893825\"\n     data-ad-slot=\"1428770894\"\n     data-auto-format=\"rspv\"\n     data-full-width=\"\">\n\t <div overflow=\"\"><\/div>\n\t<\/amp-ad>\n\t<\/div>\n\t<p>&nbsp;<\/p>\n<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div style=\"border: 1px solid #c0c0c0; padding: 7px; background: #f5f5f5; border-radius: 8px; position: relative; top: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 16px;\">\r\n<div><strong><span style=\"font-size: 14pt;\">\u3000\u76ee\u3000\u6b21<\/span><\/strong><\/div>\r\n<div style=\"margin-left: 20pt; line-height: 200%;\"><span style=\"color: magenta;\">1.\u3000<\/span><a href=\"#title1\"><strong>\u5fc5\u8981\u306a\u30e9\u30a4\u30d6\u30e9\u30ea<\/strong><\/a><br \/>\r\n<span style=\"color: magenta;\">2.\u3000<\/span><a href=\"#title2\"><strong>Python\u30b9\u30af\u30ea\u30d7\u30c8<\/strong><\/a><br \/>\r\n<span style=\"color: magenta;\">3.\u3000<\/span><a href=\"#title3\"><strong>\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u8aac\u660e<\/strong><\/a><br \/>\r\n<span style=\"color: magenta;\">4.\u3000<\/span><a href=\"#title4\"><strong>\u5b9a\u671f\u7684\u306a\u30af\u30ea\u30fc\u30cb\u30f3\u30b0<\/strong><\/a><\/div>\r\n<\/div>\r\n<div>\u00a0<\/div>\r\n<div id=\"title1\">\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div style=\"border: 1px solid #800000; padding: 5px 10px 3px 10px; background: #c5ff88;\"><strong>1. \u5fc5\u8981\u306a\u30e9\u30a4\u30d6\u30e9\u30ea<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u3053\u306e\u4f5c\u696d\u3092\u884c\u3046\u305f\u3081\u306b\u306f\u3001Python\u306bmysql-connector-python\u3068\u3044\u3046\u30e9\u30a4\u30d6\u30e9\u30ea\u304c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30b3\u30de\u30f3\u30c9\u3002<\/div>\r\n<div style=\"border: 1px solid #4169e1; padding: 5px 10px 3px 10px; background: #f0f8ff; border-radius: 5px; position: relative; top: 0px;\"><strong>pip install mysql-connector-python<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div id=\"title2\">\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div style=\"border: 1px solid #800000; padding: 5px 10px 3px 10px; background: #c5ff88;\"><strong>2. Python\u30b9\u30af\u30ea\u30d7\u30c8<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u5fc5\u8981\u306a\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u3001MariaDB\u306b\u63a5\u7d9a\u3059\u308b\u3002<\/div>\r\n<pre><code class=\u201dhljs python\"><span class=\"hljs-comment\"># -*- coding: utf-8 -*-<\/span>\r\n\r\n<span class=\"hljs-keyword\">import<\/span> mysql.connector\r\n<span class=\"hljs-keyword\">from<\/span> mysql.connector <span class=\"hljs-keyword\">import<\/span> Error\r\n<span class=\"hljs-keyword\">import<\/span> csv\r\n<span class=\"hljs-keyword\">from<\/span> datetime <span class=\"hljs-keyword\">import<\/span> datetime, timedelta\r\n\r\n<span class=\"hljs-comment\"># MariaDB\u306e\u63a5\u7d9a\u8a2d\u5b9a<\/span>\r\nconfig = {\r\n    <span class=\"hljs-string\">'user'<\/span>: <span class=\"hljs-string\">'\u30e6\u30fc\u30b6\u30fc\u540d'<\/span>,\r\n    <span class=\"hljs-string\">'password'<\/span>: <span class=\"hljs-string\">'\u30d1\u30b9\u30ef\u30fc\u30c9'<\/span>,\r\n    <span class=\"hljs-string\">'host'<\/span>: <span class=\"hljs-string\">'localhost'<\/span>,\r\n    <span class=\"hljs-string\">'database'<\/span>: <span class=\"hljs-string\">'\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d'<\/span>,\r\n    <span class=\"hljs-string\">'raise_on_warnings'<\/span>: <span class=\"hljs-literal\">True<\/span>,\r\n}\r\n\r\n<span class=\"hljs-keyword\">try<\/span>:\r\n    <span class=\"hljs-comment\"># \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a<\/span>\r\n    connection = mysql.connector.connect(**config)\r\n    <span class=\"hljs-keyword\">if<\/span> connection.is_connected():\r\n        print(<span class=\"hljs-string\">'MariaDB\u306b\u63a5\u7d9a\u3057\u307e\u3057\u305f\u3002'<\/span>)\r\n        cursor = connection.cursor()\r\n\r\n        <span class=\"hljs-comment\"># \u73fe\u5728\u65e5\u3088\u308a1\u30ab\u6708\u4ee5\u4e0a\u524d\u306e\u65e5\u4ed8\u3092\u8a08\u7b97<\/span>\r\n        one_month_ago = datetime.now() - timedelta(days=<span class=\"hljs-number\">30<\/span>)\r\n\r\n        <span class=\"hljs-comment\"># \u53e4\u3044\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3059\u308b\u30af\u30a8\u30ea<\/span>\r\n        select_query = <span class=\"hljs-string\">f\"\"\"\r\n        SELECT * FROM \u30c6\u30fc\u30d6\u30eb\u540d\r\n        WHERE \u65e5\u4ed8\u30ab\u30e9\u30e0 &lt; '<span class=\"hljs-subst\">{one_month_ago.strftime(<span class=\"hljs-string\">'%Y-%m-%d'<\/span>)}<\/span>';\r\n        \"\"\"<\/span>\r\n\r\n        <span class=\"hljs-comment\"># \u9078\u629e\u3057\u305f\u30c7\u30fc\u30bf\u3092CSV\u306b\u66f8\u304d\u51fa\u3059<\/span>\r\n        cursor.execute(select_query)\r\n        result = cursor.fetchall()\r\n        <span class=\"hljs-keyword\">with<\/span> open(<span class=\"hljs-string\">'expired_data.csv'<\/span>, <span class=\"hljs-string\">'w'<\/span>, newline=<span class=\"hljs-string\">''<\/span>) <span class=\"hljs-keyword\">as<\/span> f:\r\n            writer = csv.writer(f)\r\n            <span class=\"hljs-comment\"># CSV\u30d8\u30c3\u30c0\u30fc\u3092\u66f8\u304d\u8fbc\u3080<\/span>\r\n            writer.writerow([i[<span class=\"hljs-number\">0<\/span>] <span class=\"hljs-keyword\">for<\/span> i <span class=\"hljs-keyword\">in<\/span> cursor.description])\r\n            <span class=\"hljs-comment\"># \u30c7\u30fc\u30bf\u3092\u66f8\u304d\u8fbc\u3080<\/span>\r\n            writer.writerows(result)\r\n        \r\n        print(<span class=\"hljs-string\">'CSV\u30d5\u30a1\u30a4\u30eb\u306b\u66f8\u304d\u51fa\u3057\u307e\u3057\u305f\u3002'<\/span>)\r\n\r\n        <span class=\"hljs-comment\"># \u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3059\u308b\u30af\u30a8\u30ea<\/span>\r\n        delete_query = <span class=\"hljs-string\">f\"\"\"\r\n        DELETE FROM \u30c6\u30fc\u30d6\u30eb\u540d\r\n        WHERE \u65e5\u4ed8\u30ab\u30e9\u30e0 &lt; '<span class=\"hljs-subst\">{one_month_ago.strftime(<span class=\"hljs-string\">'%Y-%m-%d'<\/span>)}<\/span>';\r\n        \"\"\"<\/span>\r\n        \r\n        <span class=\"hljs-comment\"># \u30c7\u30fc\u30bf\u3092\u524a\u9664<\/span>\r\n        cursor.execute(delete_query)\r\n        connection.commit()\r\n        print(<span class=\"hljs-string\">f\"<span class=\"hljs-subst\">{cursor.rowcount}<\/span>\u884c\u306e\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057\u307e\u3057\u305f\u3002\"<\/span>)\r\n\r\n<span class=\"hljs-keyword\">except<\/span> Error <span class=\"hljs-keyword\">as<\/span> e:\r\n    print(<span class=\"hljs-string\">f\"\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3057\u305f: <span class=\"hljs-subst\">{e}<\/span>\"<\/span>)\r\n<span class=\"hljs-keyword\">finally<\/span>:\r\n    <span class=\"hljs-keyword\">if<\/span> (connection.is_connected()):\r\n        cursor.close()\r\n        connection.close()\r\n        print(<span class=\"hljs-string\">'MariaDB\u306e\u63a5\u7d9a\u3092\u9589\u3058\u307e\u3057\u305f\u3002'<\/span>)<\/code><\/pre>\r\n<div>\u00a0<\/div>\r\n<div>\u5b9f\u884c\u7d50\u679c\uff1a\u524a\u9664\u3055\u308c\u305f\u884c\u6570\u304c\u8868\u793a\u3055\u308c\u308b\u3002<br \/>\r\n<a href=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/02\/db-delete_0011.png\" data-rel=\"lightbox-gallery-gsoo7CsA\" data-rl_title=\"db-delete_0011\" data-rl_caption=\"\" title=\"db-delete_0011\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8265\" src=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/02\/db-delete_0011.png\" alt=\"\u5b9f\u884c\u7d50\u679c\uff1a\u524a\u9664\u3055\u308c\u305f\u884c\u6570\u304c\u8868\u793a\u3055\u308c\u308b\" width=\"600\" height=\"113\" \/><\/a><\/div>\r\n<div>\u00a0<\/div>\r\n<div>CSV\u30d5\u30a1\u30a4\u30eb\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3055\u308c\u305f\u53e4\u3044\u30c7\u30fc\u30bf\u3002<br \/>\r\n<a href=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/02\/db-delete_0021.png\" data-rel=\"lightbox-gallery-gsoo7CsA\" data-rl_title=\"db-delete_0021\" data-rl_caption=\"\" title=\"db-delete_0021\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8266\" src=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/02\/db-delete_0021.png\" alt=\"CSV\u30d5\u30a1\u30a4\u30eb\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3055\u308c\u305f\u53e4\u3044\u30c7\u30fc\u30bf\" width=\"800\" height=\"581\" \/><\/a><\/div>\r\n<div>\u00a0<\/div>\r\n<div>CSV\u30d5\u30a1\u30a4\u30eb\u306e\u30d8\u30c3\u30c0\u30fc\u884c\u3068\u3057\u3066\u300c\u5217\u306e\u540d\u524d\u300d\u304c\u6700\u521d\u306e\u884c\u306b\u66f8\u304d\u8fbc\u307e\u308c\u3066\u3044\u308b\u3002<\/div>\r\n<div>\u00a0<\/div>\r\n<div id=\"title3\">\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div style=\"border: 1px solid #800000; padding: 5px 10px 3px 10px; background: #c5ff88;\"><strong>3. \u30b9\u30af\u30ea\u30d7\u30c8\u306e\u8aac\u660e<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u4e0a\u8a18\u30b9\u30af\u30ea\u30d7\u30c8\u306f\u3001\u6307\u5b9a\u3057\u305f\u30c6\u30fc\u30d6\u30eb\u304b\u30891\u30ab\u6708\u4ee5\u4e0a\u524d\u306e\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3001\u305d\u308c\u3092CSV\u30d5\u30a1\u30a4\u30eb\u306b\u4fdd\u5b58\u3057\u305f\u5f8c\u3001\u305d\u306e\u30c7\u30fc\u30bf\u3092\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u524a\u9664\u3057\u307e\u3059\u3002<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u73fe\u5728\u65e5\u3088\u308a1\u30ab\u6708\u4ee5\u4e0a\u524d\u306e\u65e5\u4ed8\u3092\u8a08\u7b97\uff1a<span style=\"color: #0000ff;\"><strong>timedelta<\/strong><\/span>\u3092\u4f7f\u3046\u3002<\/div>\r\n<pre><code class=\u201dhljs python\">        <span class=\"hljs-comment\"># \u73fe\u5728\u65e5\u3088\u308a1\u30ab\u6708\u4ee5\u4e0a\u524d\u306e\u65e5\u4ed8\u3092\u8a08\u7b97<\/span>\r\n        one_month_ago = datetime.now() - timedelta(days=<span class=\"hljs-number\">30<\/span>)\r\n<\/code><\/pre>\r\n<div>\u00a0<\/div>\r\n<div>\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3059\u308b\u30af\u30a8\u30ea\uff1aSELECT\u3002<\/div>\r\n<pre><code class=\u201dhljs python\">        <span class=\"hljs-comment\"># \u53e4\u3044\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3059\u308b\u30af\u30a8\u30ea<\/span>\r\n        select_query = <span class=\"hljs-string\">f\"\"\"\r\n        SELECT * FROM meas_value\r\n        WHERE nitiji &lt; '<span class=\"hljs-subst\">{one_month_ago.strftime(<span class=\"hljs-string\">'%Y-%m-%d'<\/span>)}<\/span>';\r\n        \"\"\"<\/span>\r\n<\/code><\/pre>\r\n<div>\u00a0<\/div>\r\n<div>\u9078\u629e\u3057\u305f\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u3001CSV\u306b\u66f8\u304d\u51fa\u3059\u7b87\u6240\u3002<br \/>\r\n\u30fbopen()\u306e\u7b2c\u4e00\u5f15\u6570\u306b\u306f\u3001CSV\u30d5\u30a1\u30a4\u30eb\u3078\u306e\u30d1\u30b9\u3092\u6307\u5b9a\u3059\u308b\u3002<br \/>\r\n\u3000\u7b2c\u4e8c\u5f15\u6570\u306f\u300cmode\u300d\u3067\u3001\u66f8\u304d\u8fbc\u307f\u30e2\u30fc\u30c9\u3092'<span style=\"color: #ff0000;\"><b>w<\/b><\/span>'\u3068\u3059\u308b\u3068\u4e0a\u66f8\u304d\u3068\u306a\u308a\u3001\u5143\u306e\u5185\u5bb9\u306f\u524a\u9664\u3055\u308c\u308b\u3002<br \/>\r\n\u30fbcursor.description \u304b\u3089\u5404\u5217\u306e\u540d\u524d (name\u5c5e\u6027) \u3092\u62bd\u51fa\u3057\u3001\u305d\u308c\u3092CSV\u30d5\u30a1\u30a4\u30eb\u306e\u30d8\u30c3\u30c0\u30fc\u3068\u3057\u3066\u66f8\u304d\u8fbc\u3080\u305f\u3081\u306e\u884c\u3067\u3001\u5217\u306e\u540d\u524d\u304cCSV\u30d5\u30a1\u30a4\u30eb\u306e\u30d8\u30c3\u30c0\u30fc\u884c\u3068\u3057\u3066\u6700\u521d\u306e\u884c\u306b\u66f8\u304d\u8fbc\u307e\u308c\u308b\u3002<\/div>\r\n<pre><code class=\u201dhljs python\">        <span class=\"hljs-comment\"># \u9078\u629e\u3057\u305f\u30c7\u30fc\u30bf\u3092CSV\u306b\u66f8\u304d\u51fa\u3059<\/span>\r\n        cursor.execute(select_query)\r\n        result = cursor.fetchall()\r\n        <span class=\"hljs-keyword\">with<\/span> open(<span class=\"hljs-string\">'work\/expired_data_01.csv'<\/span>, <span class=\"hljs-string\">'w'<\/span>, newline=<span class=\"hljs-string\">''<\/span>) <span class=\"hljs-keyword\">as<\/span> f:\r\n            writer = csv.writer(f)\r\n            <span class=\"hljs-comment\"># CSV\u30d8\u30c3\u30c0\u30fc\u3092\u66f8\u304d\u8fbc\u3080<\/span>\r\n            writer.writerow([i[<span class=\"hljs-number\">0<\/span>] <span class=\"hljs-keyword\">for<\/span> i <span class=\"hljs-keyword\">in<\/span> cursor.description])\r\n            <span class=\"hljs-comment\"># \u30c7\u30fc\u30bf\u3092\u66f8\u304d\u8fbc\u3080<\/span>\r\n            writer.writerows(result)<\/code><\/pre>\r\n<div>\u00a0<\/div>\r\n<div>2\u56de\u76ee\u4ee5\u964d\u3001\u65e2\u5b58\u306eCSV\u30d5\u30a1\u30a4\u30eb\u306b\u8ffd\u8a18\u3057\u305f\u3044\u5834\u5408\u306f\u3001 open()\u306e\u8ffd\u8a18\u30e2\u30fc\u30c9\u2018<strong><span style=\"color: #ff0000;\">a<\/span><\/strong>\u2019 \u3067\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304f\u3002<\/div>\r\n<pre><code class=\u201dhljs python\">        <span class=\"hljs-comment\"># \u9078\u629e\u3057\u305f\u30c7\u30fc\u30bf\u3092CSV\u306b\u66f8\u304d\u51fa\u3059<\/span>\r\n        cursor.execute(select_query)\r\n        result = cursor.fetchall()\r\n        <span class=\"hljs-keyword\">with<\/span> open(<span class=\"hljs-string\">'work\/expired_data_01.csv'<\/span>, <span class=\"hljs-string\">'a'<\/span>, newline=<span class=\"hljs-string\">''<\/span>) <span class=\"hljs-keyword\">as<\/span> f:\r\n            writer = csv.writer(f)\r\n            <span class=\"hljs-comment\"># \u30c7\u30fc\u30bf\u3092\u66f8\u304d\u8fbc\u3080<\/span>\r\n            writer.writerows(result)<\/code><\/pre>\r\n<div>\u00a0<\/div>\r\n<div>\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3059\u308b\u30af\u30a8\u30ea\uff1aDELETE \u3002<\/div>\r\n<pre><code class=\u201dhljs python\">        <span class=\"hljs-comment\"># \u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3059\u308b\u30af\u30a8\u30ea<\/span>\r\n        delete_query = <span class=\"hljs-string\">f\"\"\"\r\n        DELETE FROM meas_value\r\n        WHERE nitiji &lt; '<span class=\"hljs-subst\">{one_month_ago.strftime(<span class=\"hljs-string\">'%Y-%m-%d'<\/span>)}<\/span>';\r\n        \"\"\"<\/span><\/code><\/pre>\r\n<div>\u00a0<\/div>\r\n<div>\u30c7\u30fc\u30bf\u3092\u524a\u9664\uff1aexecute\u30e1\u30bd\u30c3\u30c9\u3067SQL\u6587\u306e\u5b9f\u884c\u3002<br \/>\r\n\u300ccursor.rowcount\u300d\u3067\u3001\u524a\u9664\u3055\u308c\u305f\u884c\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u3002<\/div>\r\n<pre><code class=\u201dhljs python\">        <span class=\"hljs-comment\"># \u30c7\u30fc\u30bf\u3092\u524a\u9664<\/span>\r\n        cursor.execute(delete_query)\r\n        connection.commit()\r\n        print(<span class=\"hljs-string\">f\"<span class=\"hljs-subst\">{cursor.rowcount}<\/span>\u884c\u306e\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057\u307e\u3057\u305f\u3002\"<\/span>)<\/code><\/pre>\r\n<div>\u00a0<\/div>\r\n<div id=\"title4\">\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div style=\"border: 1px solid #800000; padding: 5px 10px 3px 10px; background: #c5ff88;\"><strong>4. \u5b9a\u671f\u7684\u306a\u30af\u30ea\u30fc\u30cb\u30f3\u30b0<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u3053\u306e\u4f5c\u696d\u3092\u300ccron\u300d\u3067\u5b9a\u671f\u7684\u306b\u5b9f\u884c\u3059\u308b\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u6700\u9069\u306a\u72b6\u614b\u306b\u4fdd\u3064\u3053\u3068\u304c\u3067\u304d\u308b\u3002<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<p>&nbsp;<\/p>\r\n<p style=\"text-align: right;\">\u4ee5\u4e0a\u3002<br \/>\r\n(2024.02.28)<\/p>\r\n<div style=\"clear: both;\">\u00a0<\/div>\r\n<div>\t<p>&nbsp;<\/p>\n\t<div align=\"center\" style=\"font-size:8pt;\">\u30b9\u30dd\u30f3\u30b5\u30fc \u30ea\u30f3\u30af<br \/>\n<!-- \t<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script> -->\n\t<!-- \u8a18\u4e8b\u30fb\u30ec\u30b9\u30dd\u30f3\u30b7\u30d6-7 -->\n\t<ins class=\"adsbygoogle\"\n     style=\"display:block\"\n     data-ad-client=\"ca-pub-3816629014893825\"\n     data-ad-slot=\"1428770894\"\n     data-ad-format=\"auto\"\n     data-full-width-responsive=\"true\"><\/ins>\n\t<script>\n\t(adsbygoogle = window.adsbygoogle || []).push({});\n\t<\/script>\n\t<amp-ad width=\"100vw\" height=\"320\"\n     type=\"adsense\"\n     data-ad-client=\"ca-pub-3816629014893825\"\n     data-ad-slot=\"1428770894\"\n     data-auto-format=\"rspv\"\n     data-full-width=\"\">\n\t <div overflow=\"\"><\/div>\n\t<\/amp-ad>\n\t<\/div>\n\n\t<p>&nbsp;<\/p>\n\n\t<p align=\"center\">\n\t<amp-social-share type=\"email\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"facebook\" data-param-app_id=\"131027923993169\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"linkedin\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"pinterest\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"tumblr\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"twitter\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"whatsapp\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"line\"><\/amp-social-share>\n\t<\/p>\n\n\t<p>&nbsp;<\/p>\n\t\n\t<!-- \u95a2\u9023\u30fb\u30ec\u30b9\u30dd\u30f3\u30b7\u30d6 kanren-70 -->\n\t<div align=\"center\">\n\t\n\t<ins class=\"adsbygoogle\"\n     style=\"display:block\"\n     data-ad-format=\"autorelaxed\"\n     data-ad-client=\"ca-pub-3816629014893825\"\n     data-ad-slot=\"8839675487\"><\/ins>\n\t<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n\t<\/script>\n\t\n\t<amp-ad width=\"100vw\" height=\"320\"\n\t\ttype=\"adsense\"\n\t\tdata-ad-client=\"ca-pub-3816629014893825\"\n\t\tdata-ad-slot=\"8839675487\"\n\t\tdata-auto-format=\"mcrspv\"\n\t\tdata-full-width=\"\">\n\t\t<div overflow=\"\"><\/div>\n\t<\/amp-ad>\n\t\n\t<\/div>\n\t\n\t<div> <\/div>\n\n\t<p>&nbsp;<\/p>\n<\/div>\r\n<div>\u00a0<\/div>","protected":false},"excerpt":{"rendered":"Ubuntu Desktop 22.04 LTS \u30ce\u30a6\u30cf\u30a6 Python + MariaDB \u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057 CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8 \u00a0 Ubuntu 22.04 \u306e\u74b0\u5883\u3067\u3001Python\u3092\u4f7f\u7528\u3057\u3066MariaDB\u306e\u30c6\u30fc\u30d6 &hellip; <p class=\"link-more\"><a href=\"https:\/\/arakoki70.com\/?p=8264\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;Python\u3067 MariaDB\u304b\u3089\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057 CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>","protected":false},"author":1,"featured_media":8266,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[110],"tags":[],"class_list":["post-8264","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-02python"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Python\u3067 MariaDB\u304b\u3089\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057 CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b - \u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/arakoki70.com\/?p=8264\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Python\u3067 MariaDB\u304b\u3089\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057 CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b - \u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c\" \/>\n<meta property=\"og:description\" content=\"Ubuntu Desktop 22.04 LTS \u30ce\u30a6\u30cf\u30a6 Python + MariaDB \u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057 CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8 \u00a0 Ubuntu 22.04 \u306e\u74b0\u5883\u3067\u3001Python\u3092\u4f7f\u7528\u3057\u3066MariaDB\u306e\u30c6\u30fc\u30d6 &hellip; &quot;Python\u3067 MariaDB\u304b\u3089\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057 CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b&quot; \u306e\u7d9a\u304d\u3092\u8aad\u3080\" \/>\n<meta property=\"og:url\" content=\"https:\/\/arakoki70.com\/?p=8264\" \/>\n<meta property=\"og:site_name\" content=\"\u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-28T09:24:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-15T06:54:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/02\/db-delete_0021.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"581\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"tacsan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@hermione2207\" \/>\n<meta name=\"twitter:site\" content=\"@hermione2207\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"tacsan\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"9\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8264#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8264\"},\"author\":{\"name\":\"tacsan\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/#\\\/schema\\\/person\\\/d5fdbdb63e731d3f2d43880ccade4451\"},\"headline\":\"Python\u3067 MariaDB\u304b\u3089\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057 CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b\",\"datePublished\":\"2024-02-28T09:24:59+00:00\",\"dateModified\":\"2024-12-15T06:54:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8264\"},\"wordCount\":53,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/#\\\/schema\\\/person\\\/d5fdbdb63e731d3f2d43880ccade4451\"},\"image\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8264#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/db-delete_0021.png\",\"articleSection\":[\"02 Python + MariaDB\"],\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/arakoki70.com\\\/?p=8264#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8264\",\"url\":\"https:\\\/\\\/arakoki70.com\\\/?p=8264\",\"name\":\"Python\u3067 MariaDB\u304b\u3089\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057 CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b - \u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8264#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8264#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/db-delete_0021.png\",\"datePublished\":\"2024-02-28T09:24:59+00:00\",\"dateModified\":\"2024-12-15T06:54:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8264#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/arakoki70.com\\\/?p=8264\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8264#primaryimage\",\"url\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/db-delete_0021.png\",\"contentUrl\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/db-delete_0021.png\",\"width\":800,\"height\":581,\"caption\":\"CSV\u30d5\u30a1\u30a4\u30eb\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3055\u308c\u305f\u53e4\u3044\u30c7\u30fc\u30bf\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8264#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\\\/\\\/arakoki70.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Python\u3067 MariaDB\u304b\u3089\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057 CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/#website\",\"url\":\"https:\\\/\\\/arakoki70.com\\\/\",\"name\":\"\u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c\",\"description\":\"Around 70&#039;s \u30d6\u30ed\u30b0\u3078\u306e\u8a18\u4e8b\u6295\u7a3f\u304c\u751f\u6d3b\u76ee\u6a19\u306b \u30fb\u30fb\u30fb \u307e\u3060\u307e\u3060\u8f1d\u304f\",\"publisher\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/#\\\/schema\\\/person\\\/d5fdbdb63e731d3f2d43880ccade4451\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/arakoki70.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/arakoki70.com\\\/#\\\/schema\\\/person\\\/d5fdbdb63e731d3f2d43880ccade4451\",\"name\":\"tacsan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/raspberry-toumei_4.png\",\"url\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/raspberry-toumei_4.png\",\"contentUrl\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/raspberry-toumei_4.png\",\"width\":80,\"height\":102,\"caption\":\"tacsan\"},\"logo\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/raspberry-toumei_4.png\"},\"sameAs\":[\"https:\\\/\\\/arakoki70.com\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Python\u3067 MariaDB\u304b\u3089\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057 CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b - \u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/arakoki70.com\/?p=8264","og_locale":"ja_JP","og_type":"article","og_title":"Python\u3067 MariaDB\u304b\u3089\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057 CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b - \u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c","og_description":"Ubuntu Desktop 22.04 LTS \u30ce\u30a6\u30cf\u30a6 Python + MariaDB \u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057 CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8 \u00a0 Ubuntu 22.04 \u306e\u74b0\u5883\u3067\u3001Python\u3092\u4f7f\u7528\u3057\u3066MariaDB\u306e\u30c6\u30fc\u30d6 &hellip; \"Python\u3067 MariaDB\u304b\u3089\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057 CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b\" \u306e\u7d9a\u304d\u3092\u8aad\u3080","og_url":"https:\/\/arakoki70.com\/?p=8264","og_site_name":"\u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c","article_published_time":"2024-02-28T09:24:59+00:00","article_modified_time":"2024-12-15T06:54:49+00:00","og_image":[{"width":800,"height":581,"url":"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/02\/db-delete_0021.png","type":"image\/png"}],"author":"tacsan","twitter_card":"summary_large_image","twitter_creator":"@hermione2207","twitter_site":"@hermione2207","twitter_misc":{"\u57f7\u7b46\u8005":"tacsan","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"9\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/arakoki70.com\/?p=8264#article","isPartOf":{"@id":"https:\/\/arakoki70.com\/?p=8264"},"author":{"name":"tacsan","@id":"https:\/\/arakoki70.com\/#\/schema\/person\/d5fdbdb63e731d3f2d43880ccade4451"},"headline":"Python\u3067 MariaDB\u304b\u3089\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057 CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b","datePublished":"2024-02-28T09:24:59+00:00","dateModified":"2024-12-15T06:54:49+00:00","mainEntityOfPage":{"@id":"https:\/\/arakoki70.com\/?p=8264"},"wordCount":53,"commentCount":0,"publisher":{"@id":"https:\/\/arakoki70.com\/#\/schema\/person\/d5fdbdb63e731d3f2d43880ccade4451"},"image":{"@id":"https:\/\/arakoki70.com\/?p=8264#primaryimage"},"thumbnailUrl":"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/02\/db-delete_0021.png","articleSection":["02 Python + MariaDB"],"inLanguage":"ja","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/arakoki70.com\/?p=8264#respond"]}]},{"@type":"WebPage","@id":"https:\/\/arakoki70.com\/?p=8264","url":"https:\/\/arakoki70.com\/?p=8264","name":"Python\u3067 MariaDB\u304b\u3089\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057 CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b - \u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c","isPartOf":{"@id":"https:\/\/arakoki70.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/arakoki70.com\/?p=8264#primaryimage"},"image":{"@id":"https:\/\/arakoki70.com\/?p=8264#primaryimage"},"thumbnailUrl":"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/02\/db-delete_0021.png","datePublished":"2024-02-28T09:24:59+00:00","dateModified":"2024-12-15T06:54:49+00:00","breadcrumb":{"@id":"https:\/\/arakoki70.com\/?p=8264#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/arakoki70.com\/?p=8264"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/arakoki70.com\/?p=8264#primaryimage","url":"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/02\/db-delete_0021.png","contentUrl":"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/02\/db-delete_0021.png","width":800,"height":581,"caption":"CSV\u30d5\u30a1\u30a4\u30eb\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3055\u308c\u305f\u53e4\u3044\u30c7\u30fc\u30bf"},{"@type":"BreadcrumbList","@id":"https:\/\/arakoki70.com\/?p=8264#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/arakoki70.com\/"},{"@type":"ListItem","position":2,"name":"Python\u3067 MariaDB\u304b\u3089\u53e4\u3044\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057 CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b"}]},{"@type":"WebSite","@id":"https:\/\/arakoki70.com\/#website","url":"https:\/\/arakoki70.com\/","name":"\u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c","description":"Around 70&#039;s \u30d6\u30ed\u30b0\u3078\u306e\u8a18\u4e8b\u6295\u7a3f\u304c\u751f\u6d3b\u76ee\u6a19\u306b \u30fb\u30fb\u30fb \u307e\u3060\u307e\u3060\u8f1d\u304f","publisher":{"@id":"https:\/\/arakoki70.com\/#\/schema\/person\/d5fdbdb63e731d3f2d43880ccade4451"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/arakoki70.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":["Person","Organization"],"@id":"https:\/\/arakoki70.com\/#\/schema\/person\/d5fdbdb63e731d3f2d43880ccade4451","name":"tacsan","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/arakoki70.com\/wp-content\/uploads\/2019\/12\/raspberry-toumei_4.png","url":"https:\/\/arakoki70.com\/wp-content\/uploads\/2019\/12\/raspberry-toumei_4.png","contentUrl":"https:\/\/arakoki70.com\/wp-content\/uploads\/2019\/12\/raspberry-toumei_4.png","width":80,"height":102,"caption":"tacsan"},"logo":{"@id":"https:\/\/arakoki70.com\/wp-content\/uploads\/2019\/12\/raspberry-toumei_4.png"},"sameAs":["https:\/\/arakoki70.com\/"]}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/posts\/8264","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/arakoki70.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8264"}],"version-history":[{"count":0,"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/posts\/8264\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/media\/8266"}],"wp:attachment":[{"href":"https:\/\/arakoki70.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8264"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arakoki70.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8264"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arakoki70.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}