{"id":8971,"date":"2022-08-14T19:00:00","date_gmt":"2022-08-14T10:00:00","guid":{"rendered":"https:\/\/taki-lab.site\/bocci\/?p=8971"},"modified":"2022-08-13T12:30:44","modified_gmt":"2022-08-13T03:30:44","slug":"rust%e5%8b%89%e5%bc%b7%e4%b8%ad%e3%80%818-13%e3%81%ae%e7%a9%8d%e3%81%bf%e4%b8%8a%e3%81%92","status":"publish","type":"post","link":"https:\/\/taki-lab.site\/bocci\/?p=8971","title":{"rendered":"RUST\u52c9\u5f37\u4e2d\u30018\/13\u306e\u7a4d\u307f\u4e0a\u3052"},"content":{"rendered":"\n<p>\u524d\u56de\u306e\u7d9a\u304d\u3002<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-\u81ea\u5206\u3001\u307c\u3063\u3061\u3067\u3059\u304c\u4f55\u304b\uff1f wp-block-embed-\u81ea\u5206\u3001\u307c\u3063\u3061\u3067\u3059\u304c\u4f55\u304b\uff1f\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"IpUSbIQdt2\"><a href=\"https:\/\/taki-lab.site\/bocci\/?p=8891\">RUST\u52c9\u5f37\u4e2d\u30017\/31\u306e\u7a4d\u307f\u4e0a\u3052<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;RUST\u52c9\u5f37\u4e2d\u30017\/31\u306e\u7a4d\u307f\u4e0a\u3052&#8221; &#8212; \u81ea\u5206\u3001\u307c\u3063\u3061\u3067\u3059\u304c\u4f55\u304b\uff1f\" src=\"https:\/\/taki-lab.site\/bocci\/?p=8891&#038;embed=true#?secret=ZmzFE1bGQl#?secret=IpUSbIQdt2\" data-secret=\"IpUSbIQdt2\" width=\"474\" height=\"267\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>index\u306b\u30c0\u30df\u30fc\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3057\u305f\u304c\u3001<\/p>\n\n\n\n<p>\u3053\u306e\u90e8\u5206\u3092\u5b9f\u969b\u306eDB\u306e\u30c7\u30fc\u30bf\u3092\u8868\u793a\u3059\u308b\u3088\u3046\u306b\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>use actix_web::{get, web, App, HttpResponse, HttpServer, ResponseError};\nuse thiserror::Error;\nuse askama::Template;\nuse r2d2::Pool;\nuse r2d2_sqlite::SqliteConnectionManager;\nuse rusqlite::params;\n\nstruct TodoEntry {\n    id: u32,\n    text: String,\n}\n\n#&#91;derive(Template)]\n#&#91;template(path = \"index.html\")]\nstruct IndexTemplate {\n    entries: Vec&lt;TodoEntry&gt;,\n}\n\n#&#91;derive(Error, Debug)]\nenum MyError {\n    #&#91;error(\"Failed to render HTML\")]\n    AskamaError(#&#91;from] askama::Error),\n\n    #&#91;error(\"Failed to get connection\")]\n    ConnectionPoolError(#&#91;from] r2d2::Error),\n\n    #&#91;error(\"Failed SQL execution\")]\n    SqliteError(#&#91;from] rusqlite::Error),\n}\n\nimpl ResponseError for MyError {}\n\n#&#91;get(\"\/\")]\nasync fn index(db: web::Data&lt;Pool&lt;SqliteConnectionManager&gt;&gt;) -&gt; Result&lt;HttpResponse, MyError&gt; {\n    let conn = db.get()?;\n    let mut statement = conn.prepare(\"SELECT id, text FROM todo\")?;\n    let rows = statement.query_map(params!&#91;], |row| {\n        let id = row.get(0)?;\n        let text = row.get(1)?;\n        Ok(TodoEntry { id, text })\n    })?;\n\n    let mut entries = Vec::new();\n    for row in rows {\n        entries.push(row?);\n    }\n\n    let html = IndexTemplate { entries };\n    let response_body = html.render()?;\n    Ok(HttpResponse::Ok()\n        .content_type(\"text\/html\")\n        .body(response_body))\n}\n\n\n\n#&#91;actix_rt::main]\nasync fn main() -&gt; Result&lt;(), actix_web::Error&gt; {\n    let manager = SqliteConnectionManager::file(\"todo.db\");\n    let pool = Pool::new(manager).expect(\"Failed to inithialize the connection pool.\");\n    let conn = pool.get().expect(\"Failed to get the connection from the pool.\");\n    conn.execute(\n        \"CREATE TABLE IF NOT EXISTS todo (\n            id INTEGER PRIMARY KEY AUTOINCREMENT,\n            text TEXT NOT NULL\n        )\",\n        params!&#91;],\n    )\n    .expect(\"Failed to create a table 'todo'.\");\n    HttpServer::new(move || App::new().service(index).app_data(pool.clone()))\n        .bind(\"0.0.0.0:8080\")?\n        .run()\n        .await?;\n    Ok(())\n}\n<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"413\" height=\"140\" data-attachment-id=\"8974\" data-permalink=\"https:\/\/taki-lab.site\/bocci\/?attachment_id=8974\" data-orig-file=\"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-13-104452.png?fit=413%2C140&amp;ssl=1\" data-orig-size=\"413,140\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Screenshot-2022-08-13-104452\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-13-104452.png?fit=413%2C140&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-13-104452.png?resize=413%2C140&#038;ssl=1\" alt=\"\" class=\"wp-image-8974\" srcset=\"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-13-104452.png?w=413&amp;ssl=1 413w, https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-13-104452.png?resize=300%2C102&amp;ssl=1 300w\" sizes=\"auto, (max-width: 413px) 100vw, 413px\" \/><\/figure>\n\n\n\n<p>\u524d\u56de\u306e\u8a18\u4e8b\u3067\u3001<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>\u30c6\u30ad\u30b9\u30c8\u3067\u306fdata(pool.clone())\u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3057\u305f\u304c\u3001<br>\u30ef\u30fc\u30cb\u30f3\u30b0\u304c\u51fa\u308b\u306e\u3067\u3001\u8abf\u3079\u305f\u3068\u3053\u308d\u3001<br>\u63a8\u5968\u3055\u308c\u3066\u3044\u306a\u3044\u51e6\u7406\u306a\u306e\u3067\u3001app_data\u3092\u4f7f\u3048\u3001\u3068\u8a00\u3046\u3053\u3068\u3067\u3057\u305f\u3002<\/p><\/blockquote>\n\n\n\n<p>\u3068\u66f8\u304d\u307e\u3057\u305f\u304c\u3001<\/p>\n\n\n\n<p>app_data()\u3092\u4f7f\u7528\u3059\u308b\u3068\u3046\u307e\u304f\u52d5\u4f5c\u305b\u305a\u3001<\/p>\n\n\n\n<p>\u89e3\u6c7a\u7b56\u304c\u898b\u3064\u304b\u3089\u306a\u3044\u306e\u3067\u3001<\/p>\n\n\n\n<p>\u3072\u3068\u307e\u305adata()\u306b\u623b\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p><\/p>\n\n\n\n<a href=\"\/\/blog.with2.net\/link\/?2023426:9200\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2019\/12\/a72f208ffbb7386a5edac6282ebb8d1b.png?w=474\" title=\"\u65e5\u3005\u306e\u51fa\u6765\u4e8b\u30e9\u30f3\u30ad\u30f3\u30b0\"><\/a>\n","protected":false},"excerpt":{"rendered":"<p>\u524d\u56de\u306e\u7d9a\u304d\u3002 index\u306b\u30c0\u30df\u30fc\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3057\u305f\u304c\u3001 \u3053\u306e\u90e8\u5206\u3092\u5b9f\u969b\u306eDB\u306e\u30c7\u30fc\u30bf\u3092\u8868\u793a\u3059\u308b\u3088\u3046\u306b\u3057\u3066\u3044\u307e\u3059\u3002 \u524d\u56de\u306e\u8a18\u4e8b\u3067\u3001 \u30c6\u30ad\u30b9\u30c8\u3067\u306fdata(pool.clone())\u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3057\u305f\u304c\u3001\u30ef\u30fc\u30cb\u30f3\u30b0\u304c\u51fa &hellip; <a href=\"https:\/\/taki-lab.site\/bocci\/?p=8971\" class=\"more-link\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">RUST\u52c9\u5f37\u4e2d\u30018\/13\u306e\u7a4d\u307f\u4e0a\u3052<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[2542,3],"tags":[],"class_list":["post-8971","post","type-post","status-publish","format-standard","hentry","category-rust","category-3"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8SDbY-2kH","jetpack-related-posts":[{"id":8891,"url":"https:\/\/taki-lab.site\/bocci\/?p=8891","url_meta":{"origin":8971,"position":0},"title":"RUST\u52c9\u5f37\u4e2d\u30017\/31\u306e\u7a4d\u307f\u4e0a\u3052","author":"taki","date":"2022\u5e748\u67082\u65e5","format":false,"excerpt":"https:\/\/taki-lab.site\/bocci\/?p=8831 askama\u30af\u30ec\u30fc\u30c8\u3092\u4f7f\u7528\u3059\u2026","rel":"","context":"Rust","block_context":{"text":"Rust","link":"https:\/\/taki-lab.site\/bocci\/?cat=2542"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2022\/07\/Screenshot-2022-07-31-100956.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":8047,"url":"https:\/\/taki-lab.site\/bocci\/?p=8047","url_meta":{"origin":8971,"position":1},"title":"Rust\u52c9\u5f37\u4e2d\u30013\/27\u306e\u7a4d\u307f\u4e0a\u3052","author":"taki","date":"2022\u5e743\u670827\u65e5","format":false,"excerpt":"\u3053\u306e\u672c\u3092\u4f7f\u7528\u3057\u3066\u52c9\u5f37\u3057\u3066\u3044\u307e\u3059\u3002 \u672c\u65e5\u306f\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u304b\u3089\u5f15\u6570\u3092\u53d6\u5f97\u3059\u308b\u51e6\u7406\u3002 Clap\u3092\u4f7f\u7528\u3059\u308b\u65b9\u2026","rel":"","context":"Rust","block_context":{"text":"Rust","link":"https:\/\/taki-lab.site\/bocci\/?cat=2542"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8638,"url":"https:\/\/taki-lab.site\/bocci\/?p=8638","url_meta":{"origin":8971,"position":2},"title":"RUST\u52c9\u5f37\u4e2d\u30016\/26\u306e\u7a4d\u307f\u4e0a\u3052","author":"taki","date":"2022\u5e746\u670828\u65e5","format":false,"excerpt":"\u524d\u56de\u306e\u7d9a\u304d https:\/\/taki-lab.site\/bocci\/?p=8476 \u4eca\u56de\u306fthise\u2026","rel":"","context":"Rust","block_context":{"text":"Rust","link":"https:\/\/taki-lab.site\/bocci\/?cat=2542"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8084,"url":"https:\/\/taki-lab.site\/bocci\/?p=8084","url_meta":{"origin":8971,"position":3},"title":"RUST\u52c9\u5f37\u4e2d\u30014\/3\u306e\u7a4d\u307f\u4e0a\u3052","author":"taki","date":"2022\u5e744\u67083\u65e5","format":false,"excerpt":"https:\/\/taki-lab.site\/bocci\/?p=8047 \u524d\u56de\u306e\u7d9a\u304d\u3002 \u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u2026","rel":"","context":"Rust","block_context":{"text":"Rust","link":"https:\/\/taki-lab.site\/bocci\/?cat=2542"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8831,"url":"https:\/\/taki-lab.site\/bocci\/?p=8831","url_meta":{"origin":8971,"position":4},"title":"RUST\u52c9\u5f37\u4e2d\u30017\/24\u306e\u7a4d\u307f\u4e0a\u3052","author":"taki","date":"2022\u5e747\u670826\u65e5","format":false,"excerpt":"https:\/\/taki-lab.site\/bocci\/?p=8785 \u30a8\u30e9\u30fc\u306e\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0\u5b9a\u7fa9\u3092\u8ffd\u2026","rel":"","context":"Rust","block_context":{"text":"Rust","link":"https:\/\/taki-lab.site\/bocci\/?cat=2542"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8208,"url":"https:\/\/taki-lab.site\/bocci\/?p=8208","url_meta":{"origin":8971,"position":5},"title":"RUST\u52c9\u5f37\u4e2d\u30014\/23\u306e\u7a4d\u307f\u4e0a\u3052","author":"taki","date":"2022\u5e744\u670826\u65e5","format":false,"excerpt":"https:\/\/taki-lab.site\/bocci\/?p=8084 \u524d\u56de\u306e\u7d9a\u304d\u3002 \u9006\u30dd\u30fc\u30e9\u30f3\u30c9\u8a18\u2026","rel":"","context":"\u51fa\u6765\u4e8b","block_context":{"text":"\u51fa\u6765\u4e8b","link":"https:\/\/taki-lab.site\/bocci\/?cat=9"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=\/wp\/v2\/posts\/8971","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8971"}],"version-history":[{"count":3,"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=\/wp\/v2\/posts\/8971\/revisions"}],"predecessor-version":[{"id":8984,"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=\/wp\/v2\/posts\/8971\/revisions\/8984"}],"wp:attachment":[{"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8971"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8971"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8971"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}