{"id":1710,"date":"2018-03-30T14:19:41","date_gmt":"2018-03-30T05:19:41","guid":{"rendered":"http:\/\/www.python.ambitious-engineer.com\/?p=1710"},"modified":"2018-11-04T22:38:25","modified_gmt":"2018-11-04T13:38:25","slug":"flask%e3%81%a7%e4%bd%9c%e3%82%8b%e7%b0%a1%e6%98%93%e5%88%86%e6%9e%90%e3%83%84%e3%83%bc%e3%83%ab-%e8%a3%9c%e8%b6%b3","status":"publish","type":"post","link":"https:\/\/www.python.ambitious-engineer.com\/archives\/1710","title":{"rendered":"Flask\u3067\u4f5c\u308b\u7c21\u6613\u5206\u6790\u30c4\u30fc\u30eb \u88dc\u8db3"},"content":{"rendered":"

\u88dc\u8db3\u3068\u3057\u3066\u5b8c\u6210\u5f8c\u306e\u69cb\u6210\u3068\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3092\u63b2\u8f09\u3057\u307e\u3059\u3002<\/p>\n

\u30d7\u30ed\u30b8\u30a7\u30af\u30c8<\/h2>\n

\u69cb\u6210\u306f\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n

\r\n.\r\n\u251c\u2500\u2500 db.sqlite3\r\n\u251c\u2500\u2500 models.py\r\n\u251c\u2500\u2500 requirements.txt\r\n\u251c\u2500\u2500 run.py\r\n\u251c\u2500\u2500 schema.sql\r\n\u251c\u2500\u2500 static\r\n\u2502\u00a0\u00a0 \u251c\u2500\u2500 result\r\n\u2502\u00a0\u00a0 \u2514\u2500\u2500 style.css\r\n\u2514\u2500\u2500 templates\r\n    \u251c\u2500\u2500 base.html\r\n    \u251c\u2500\u2500 edit.html\r\n    \u251c\u2500\u2500 index.html\r\n    \u2514\u2500\u2500 view.html\r\n\r\n<\/pre>\n
schema.sql<\/h3>\n
\r\ndrop table if exists results;\r\ncreate table results (\r\n  `id` integer primary key autoincrement,\r\n  `title` text not null,\r\n  `data` text not null,\r\n  `img` text not null,\r\n  `created` datetime default CURRENT_TIMESTAMP\r\n);\r\n<\/pre>\n
requirements.txt<\/h3>\n
\u5229\u7528\u3059\u308b\u30e9\u30a4\u30d6\u30e9\u30ea\u306f\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3059\u3002(2018\/4\/21 \u4fee\u6b63 scipy\u3092\u8ffd\u8a18\u3057\u307e\u3057\u305f\u3002)<\/p>\n
\r\nclick==6.7\r\ncycler==0.10.0\r\nFlask==0.12.2\r\nitsdangerous==0.24\r\nJinja2==2.10\r\nkiwisolver==1.0.1\r\nMarkupSafe==1.0\r\nmatplotlib==2.2.0\r\nnumpy==1.14.1\r\npandas==0.22.0\r\npyparsing==2.2.0\r\npython-dateutil==2.6.1\r\npytz==2018.3\r\nscipy==1.0.1\r\nsix==1.11.0\r\nWerkzeug==0.14.1\r\n<\/pre>\n
Python\u30b3\u30fc\u30c9<\/h2>\n
run.py<\/h3>\n
\r\nimport os\r\nimport sqlite3\r\nfrom flask import Flask, request, g, redirect, url_for, render_template, flash\r\nimport models\r\n\r\napp = Flask(__name__)\r\napp.config.from_object(__name__)\r\n\r\napp.config.update(dict(\r\n    DATABASE=os.path.join(app.root_path, 'db.sqlite3'),\r\n    SECRET_KEY='foo-baa',\r\n))\r\n\r\n\r\ndef connect_db():\r\n    """ \u30c7\u30fc\u30bf\u30d9\u30b9\u63a5\u7d9a\u306b\u63a5\u7d9a\u3057\u307e\u3059 """\r\n    con = sqlite3.connect(app.config['DATABASE'])\r\n    con.row_factory = sqlite3.Row\r\n    return con\r\n\r\n\r\ndef get_db():\r\n    """ connection\u3092\u53d6\u5f97\u3057\u307e\u3059 """\r\n    if not hasattr(g, 'sqlite_db'):\r\n        g.sqlite_db = connect_db()\r\n    return g.sqlite_db\r\n\r\n\r\n@app.teardown_appcontext\r\ndef close_db(error):\r\n    """ db\u63a5\u7d9a\u3092close\u3057\u307e\u3059 """\r\n    if hasattr(g, 'sqlite_db'):\r\n        g.sqlite_db.close()\r\n\r\n\r\n# \u4ee5\u4e0b\u3001\u753b\u9762\u306b\u95a2\u308f\u308b\u30e1\u30bd\u30c3\u30c9\r\n\r\n@app.route('\/')\r\ndef index():\r\n    """ \u4e00\u89a7\u753b\u9762 """\r\n    con = get_db()\r\n    results = models.select_all(con)\r\n    return render_template('index.html', results=results)\r\n\r\n\r\n@app.route('\/create')\r\ndef create():\r\n    """ \u65b0\u898f\u4f5c\u6210\u753b\u9762 """\r\n    return render_template('edit.html')\r\n\r\n\r\n@app.route('\/analysis', methods=['POST'])\r\ndef analysis():\r\n    """ \u5206\u6790\u5b9f\u884c\u51e6\u7406 """\r\n\r\n    title = request.form['title']\r\n    data = request.form['data']\r\n    img = models.create_scatter(data)\r\n\r\n    con = get_db()\r\n\r\n    pk = models.insert(con, title, data, img)\r\n    flash('\u767b\u9332\u51e6\u7406\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002')\r\n    return redirect(url_for('view', pk=pk))\r\n\r\n\r\n@app.route('\/delete\/<pk>', methods=['POST'])\r\ndef delete(pk):\r\n    """ \u7d50\u679c\u524a\u9664\u51e6\u7406 """\r\n    con = get_db()\r\n    models.delete(con, pk)\r\n    flash('\u524a\u9664\u51e6\u7406\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002')\r\n    return redirect(url_for('index'))\r\n\r\n\r\n@app.route('\/view\/<pk>')\r\ndef view(pk):\r\n    """ \u7d50\u679c\u53c2\u7167\u51e6\u7406 """\r\n    con = get_db()\r\n    result = models.select(con, pk)\r\n    return render_template('view.html', result=result)\r\n\r\n\r\nif __name__ == '__main__':\r\n    app.run()\r\n\r\n<\/pre>\n
models.py<\/h3>\n
\r\n"""\r\n\u30d3\u30b8\u30cd\u30b9\u30ed\u30b8\u30c3\u30af\u30e2\u30b8\u30e5\u30fc\u30eb\r\n"""\r\nfrom matplotlib import pyplot as plt\r\nfrom pandas.plotting import scatter_matrix\r\nimport pandas as pd\r\nimport time\r\nimport io\r\n\r\n\r\ndef create_scatter(data):\r\n    data = data.replace(',', '\\t').replace(' ', '\\t')\r\n    df = pd.read_csv(io.StringIO(data), sep='\\t')\r\n\r\n    # \u30d7\u30ed\u30c3\u30c8\u30de\u30fc\u30ab\u30fc\u306e\u5927\u304d\u3055\u3001\u8272\u3001\u900f\u660e\u5ea6\u3092\u5909\u66f4\r\n    scatter_matrix(df, diagonal='kde', color='#AAAAFF', edgecolors='#0000FF', alpha=0.5)\r\n\r\n    # \u30d5\u30a1\u30a4\u30eb\u540d\r\n    filename = time.strftime('%Y%m%d%H%M%S') + ".png"\r\n\r\n    # \u4fdd\u5b58\u5148\u306e\u30d1\u30b9\r\n    save_path = ".\/static\/result\/" + filename\r\n\r\n    # \u8868\u793a\u7528URL\r\n    url = "result\/" + filename\r\n\r\n    # \u4fdd\u5b58\u51e6\u7406\u3092\u884c\u3046\r\n    plt.savefig(save_path)\r\n\r\n    # plt\u3092close\r\n    plt.close()\r\n\r\n    return url\r\n\r\n\r\ndef select_all(con):\r\n    """ SELECT\u3059\u308b """\r\n    cur = con.execute('select id, title, data, img, created from results order by id desc')\r\n    return cur.fetchall()\r\n\r\n\r\ndef select(con, pk):\r\n    """ \u6307\u5b9a\u3057\u305f\u30ad\u30fc\u306e\u30c7\u30fc\u30bf\u3092SELECT\u3059\u308b """\r\n    cur = con.execute('select id, title, data, img, created from results where id=?', (pk,))\r\n    return cur.fetchone()\r\n\r\n\r\ndef insert(con, title, data, img):\r\n    """ INSERT\u3059\u308b """\r\n    cur = con.cursor()\r\n    cur.execute('insert into results (title, data, img) values (?, ?, ?)', [title, data, img])\r\n\r\n    pk = cur.lastrowid\r\n    con.commit()\r\n\r\n    return pk\r\n\r\n\r\ndef delete(con, pk):\r\n    """ \u6307\u5b9a\u3057\u305f\u30ad\u30fc\u306e\u30c7\u30fc\u30bf\u3092DELETE\u3059\u308b """\r\n    cur = con.cursor()\r\n    cur.execute('delete from results where id=?', (pk,))\r\n    con.commit()\r\n\r\n<\/pre>\n
\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/h2>\n
base.html<\/h3>\n
\r\n<!doctype html>\r\n<title>\u7c21\u6613\u5206\u6790\u30c4\u30fc\u30eb<\/title>\r\n<head>\r\n    <title>\u7c21\u6613\u5206\u6790\u30c4\u30fc\u30eb<\/title>\r\n    <script src="https:\/\/code.jquery.com\/jquery-3.2.1.slim.min.js"\r\n            integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr\/rE9\/Qpg6aAZGJwFDMVNA\/GpGFF93hXpG5KkN"\r\n            crossorigin="anonymous"><\/script>\r\n    <script src="https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/popper.js\/1.12.9\/umd\/popper.min.js"\r\n            integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K\/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q"\r\n            crossorigin="anonymous"><\/script>\r\n    <script src="https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/4.0.0\/js\/bootstrap.min.js"\r\n            integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe\/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl"\r\n            crossorigin="anonymous"><\/script>\r\n    <link rel="stylesheet" href="https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/4.0.0\/css\/bootstrap.min.css"\r\n          integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW\/dAiS6JXm" crossorigin="anonymous">\r\n    <link rel="stylesheet" type=text\/css href="{{ url_for('static', filename='style.css') }}">\r\n<\/head>\r\n<body>\r\n\r\n<header>\r\n    <div class="navbar navbar-dark bg-dark box-shadow">\r\n        <div class="container d-flex justify-content-between">\r\n            <a href="\/" class="navbar-brand d-flex align-items-center">\r\n                <strong>\u7c21\u6613\u5206\u6790\u30c4\u30fc\u30eb<\/strong>\r\n            <\/a>\r\n        <\/div>\r\n    <\/div>\r\n<\/header>\r\n\r\n<div class="container">\r\n    {% for message in get_flashed_messages() %}\r\n    <div class="alert alert-success">{{ message }}<\/div>\r\n    {% endfor %} {% block body %}{% endblock %}\r\n<\/div>\r\n<\/body>\r\n<\/html>\r\n\r\n<\/pre>\n
edit.html<\/h3>\n
\r\n{% extends "base.html" %}\r\n{% block body %}\r\n<h1>\u65b0\u898f\u5206\u6790<\/h1>\r\n<form action="{{ url_for('analysis') }}" method="post">\r\n\r\n    <label>\u30bf\u30a4\u30c8\u30eb<\/label>\r\n    <input class="form-control" type="text" size="30" name="title">\r\n    <label>\u5206\u6790\u30c7\u30fc\u30bf<\/label>\r\n    <textarea class="form-control" name="data" rows="5"><\/textarea>\r\n    <input class="btn btn-primary" type="submit" value="\u9001\u4fe1">\r\n\r\n<\/form>\r\n{% endblock %}\r\n<\/pre>\n
index.html<\/h3>\n
\r\n{% extends "base.html" %}\r\n{% block body %}\r\n<h1>\u5206\u6790\u4e00\u89a7<\/h1>\r\n<a href="\/create">\u65b0\u898f\u5206\u6790<\/a>\r\n<table class="table table-striped table-hover">\r\n    <tr>\r\n        <th>id<\/th>\r\n        <th>title<\/th>\r\n        <th>date<\/th>\r\n        <th>\u64cd\u4f5c<\/th>\r\n    <\/tr>\r\n    {% for result in results %}\r\n    <tr>\r\n        <td>{{ result.id }}<\/td>\r\n        <td>{{ result.title|safe}}<\/td>\r\n        <td>{{ result.created }}<\/td>\r\n        <td>\r\n            <a href="\/view\/{{ result.id }}"><button class="btn btn-primary">\u53c2\u7167<\/button><\/a>\r\n            <form action="\/delete\/{{ result.id }}" style="display: inline" method="post">\r\n                <input class="btn btn-danger" type="submit" value="\u524a\u9664" onclick='return confirm("\u524a\u9664\u3057\u307e\u3059\u304c\u3088\u308d\u3057\u3044\u3067\u3059\u304b\uff1f")';>\r\n            <\/form>\r\n\r\n        <\/td>\r\n    <\/tr>\r\n    {% endfor %}\r\n\r\n<\/table>\r\n\r\n{% endblock %}\r\n<\/pre>\n
2018\/4\/27 index.html\u306edelete\u90e8\u5206\u306b\u8aa4\u8a18\u304c\u3042\u3063\u305f\u305f\u3081\u4fee\u6b63\u3057\u307e\u3057\u305f\u3002(\u3054\u6307\u6458\u304f\u3060\u3055\u3063\u305f\u65b9\u3042\u308a\u304c\u3068\u3046\u3054\u3056\u3044\u307e\u3059\u3002)<\/font><\/p>\n
view.html<\/h3>\n
\r\n{% extends "base.html" %}\r\n{% block body %}\r\n<h1>\u7d50\u679c\u53c2\u7167<\/h1>\r\n\r\n<h3>{{ result.id }}:{{ result.title|safe}}<\/h3>\r\n<p>{{ result.created }}<\/p>\r\n<div class="row">\r\n    <img src="{{ url_for('static', filename=result.img) }}">\r\n<\/div>\r\n\r\n<div class="row">\r\n    <textarea class="form-control" name="data" rows="5">{{result.data}}<\/textarea>\r\n<\/div>\r\n\r\n<br><br>\r\n{% endblock %}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
\u88dc\u8db3\u3068\u3057\u3066\u5b8c\u6210\u5f8c\u306e\u69cb\u6210\u3068\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3092\u63b2\u8f09\u3057\u307e\u3059\u3002 \u30d7\u30ed\u30b8\u30a7\u30af\u30c8 \u69cb\u6210\u306f\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3068\u306a\u308a\u307e\u3059\u3002 schema.sql requirements.txt \u5229\u7528\u3059\u308b\u30e9\u30a4\u30d6\u30e9\u30ea\u306f\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3059\u3002(2018\/4\/21 \u4fee\u6b63 ...<\/p>\n","protected":false},"author":1,"featured_media":1721,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[153,3,9],"tags":[171,170],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.python.ambitious-engineer.com\/wp-json\/wp\/v2\/posts\/1710"}],"collection":[{"href":"https:\/\/www.python.ambitious-engineer.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.python.ambitious-engineer.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.python.ambitious-engineer.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.python.ambitious-engineer.com\/wp-json\/wp\/v2\/comments?post=1710"}],"version-history":[{"count":5,"href":"https:\/\/www.python.ambitious-engineer.com\/wp-json\/wp\/v2\/posts\/1710\/revisions"}],"predecessor-version":[{"id":1974,"href":"https:\/\/www.python.ambitious-engineer.com\/wp-json\/wp\/v2\/posts\/1710\/revisions\/1974"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.python.ambitious-engineer.com\/wp-json\/wp\/v2\/media\/1721"}],"wp:attachment":[{"href":"https:\/\/www.python.ambitious-engineer.com\/wp-json\/wp\/v2\/media?parent=1710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.python.ambitious-engineer.com\/wp-json\/wp\/v2\/categories?post=1710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.python.ambitious-engineer.com\/wp-json\/wp\/v2\/tags?post=1710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}