\u3053\u3053\u3067\u306f\u5206\u6790\u30c4\u30fc\u30eb\u306e\u96db\u5f62\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u74b0\u5883\u3092\u69cb\u7bc9\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n
\u9069\u5f53\u306a\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306e\u4e0b\u306b\u3001\u4ee5\u4e0b\u306ezip\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u89e3\u51cd\u3057\u3066\u304f\u3060\u3055\u3044\u3002 \u89e3\u51cd\u3059\u308b\u3068\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u96db\u5f62\u304c\u914d\u7f6e\u3055\u308c\u307e\u3059\u3002\u69cb\u6210\u306f\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3068\u306a\u308a\u307e\u3059\u3002Python\u30d5\u30a1\u30a4\u30eb\u304c\u305f\u3063\u305f\uff12\u3064\u3057\u304b\u306a\u3044\u3053\u3068\u306b\u7740\u76ee\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n \u7c21\u5358\u306b\u3067\u3059\u304c\u3001\u30d5\u30a1\u30a4\u30eb\u3068\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306e\u8aac\u660e\u3092\u3057\u307e\u3059\u3002<\/p>\n Web\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u8d77\u52d5\u3059\u308b\u30e2\u30b8\u30e5\u30fc\u30eb\u3067\u3059\u3002URL\u3054\u3068\u306b\u51e6\u7406\u306e\u30eb\u30fc\u30c6\u30a3\u30f3\u30b0\u3092\u884c\u3044\u307e\u3059\u3002Web\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3068\u3057\u3066flask\u304c\u95a2\u308f\u308b\u306e\u306f\u3053\u306e\u30e2\u30b8\u30e5\u30fc\u30eb\u306e\u307f\u3068\u306a\u308a\u307e\u3059\u3002\u30da\u30fc\u30b8\u4e0b\u90e8\u3067\u3082\u3046\u5c11\u3005\u7d30\u304b\u304f\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n \u30d3\u30b8\u30cd\u30b9\u30ed\u30b8\u30c3\u30af\u306e\u30e2\u30b8\u30e5\u30fc\u30eb\u3067\u3059\u3002\u5206\u6790\u51e6\u7406\uff08\u6563\u5e03\u56f3\u884c\u5217\u306e\u751f\u6210\uff09\u3068DB\u30a2\u30af\u30bb\u30b9\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u3092\u8a18\u8ff0\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n pip\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u5bfe\u8c61\u30e2\u30b8\u30e5\u30fc\u30eb\u3067\u3059\u3002<\/p>\n css\u306a\u3069\u306e\u9759\u7684\u30d5\u30a1\u30a4\u30eb\u3092\u914d\u7f6e\u3059\u308b\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3067\u3059\u3002\u307e\u305f\u3001\u914d\u4e0b\u306eresult\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u306f\u5206\u6790\u3067\u4f5c\u6210\u3057\u305f\u30b0\u30e9\u30d5\u306e\u753b\u50cf\u30c7\u30fc\u30bf\u3092\u683c\u7d0d\u3057\u307e\u3059\u3002<\/p>\n \u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\uff08html\u306e\u96db\u5f62\uff09\u3092\u914d\u7f6e\u3059\u308b\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3067\u3059\u3002\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306f\u89aa\u5b50\u95a2\u4fc2\u304c\u3042\u308a\u3001base.html\u304c\u5171\u901a\u3068\u306a\u308b\u89aa\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3001\u305d\u308c\u4ee5\u5916\u304c\u5b50\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n matplotlib\u3092\u4f7f\u7528\u3057\u307e\u3059\u306e\u3067\u3001Ubunt\u306e\u65b9\u306f\u4ee5\u4e0b\u3067Tkinter\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u304a\u3044\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n pip\u3067\u5fc5\u8981\u306a\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n \u4f7f\u7528\u3059\u308b\u4e3b\u306a\u30e2\u30b8\u30e5\u30fc\u30eb\u306f\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n sqlite3\u30b3\u30de\u30f3\u30c9\u304c\u4f7f\u7528\u3067\u304d\u308b\u3053\u3068\u3092\u524d\u63d0\u3068\u3057\u307e\u3059\u3002\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001sqlite3\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a1\u30a4\u30eb\u304c\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002<\/p>\n \u30c6\u30fc\u30d6\u30eb\u30ec\u30a4\u30a2\u30a6\u30c8\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n Web\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u4e3b\u8ef8\u3068\u306a\u308brun.py\u306b\u3064\u3044\u3066\u3082\u3046\u5c11\u3057\u8aac\u660e\u3055\u305b\u3066\u304f\u3060\u3055\u3044\u3002\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3092\u898b\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n app.config.update\u3067flask\u306e\u8a2d\u5b9a\u3092\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u60c5\u5831\u3068\u3001\u30bb\u30c3\u30b7\u30e7\u30f3\u306b\u5229\u7528\u3059\u308b\u9375\u306e\u5b9a\u6570\u8a2d\u5b9a\u3092\u884c\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n \uff11\uff12\u884c\u76ee\u4ee5\u4e0b\u306eindex\u3001create\u3001analysis\u3001delete\u3001view\u306fWeb\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u753b\u9762\u3084\u51e6\u7406\u306b\u5bfe\u5fdc\u3059\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n @app.route\u30c7\u30b3\u30ec\u30fc\u30bf\u3067URL\u3068\u95a2\u6570\u306e\u3072\u3082\u4ed8\u3051\u306b\u3088\u308a\u30eb\u30fc\u30c6\u30a3\u30f3\u30b0\u3092\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u672c\u8b1b\u5ea7\u3067\u306eURL\u3068\u95a2\u6570\u306e\u5bfe\u5fdc\u306f\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n
\n2018\/4\/21\u8ffd\u8a18\u3000schema.sql\u304c\u6f0f\u308c\u3066\u304a\u308a\u307e\u3057\u305f\u3002\u4e0b\u8a18\u30ea\u30f3\u30af\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u304f\u3060\u3055\u3044\u3002(\u3054\u6307\u6458\u304f\u3060\u3055\u3063\u305f\u65b9\u3042\u308a\u304c\u3068\u3046\u3054\u3056\u3044\u307e\u3059\u3002)<\/font>
\nflask_init_sample<\/a><\/p>\n\r\nflask_sample\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
\u30d5\u30a1\u30a4\u30eb\u3001\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306e\u89e3\u8aac<\/h3>\n
run.py<\/h4>\n
models.py<\/h4>\n
schema.sql<\/h4>\n
requirements.txt<\/h4>\n
static<\/h4>\n
templates<\/h4>\n
\u5fc5\u8981\u306a\u30e2\u30b8\u30e5\u30fc\u30eb\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n
\r\nsudo apt install python-tk tk-dev\r\n<\/pre>\n
\r\npip install -r requirements.txt\r\n<\/pre>\n
\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u69cb\u7bc9<\/h3>\n
\r\nsqlite3 db.sqlite3 < schema.sql\r\n<\/pre>\n
\n\n
\n \n\u30ab\u30e9\u30e0<\/th>\n \u578b<\/th>\n \u5185\u5bb9<\/th>\n<\/tr>\n<\/thead>\n \n id<\/td>\n integer<\/td>\n \u4e3b\u30ad\u30fc<\/td>\n<\/tr>\n \n title<\/td>\n text<\/td>\n \u30bf\u30a4\u30c8\u30eb<\/td>\n<\/tr>\n \n data<\/td>\n text<\/td>\n \u5206\u6790\u5bfe\u8c61\u3068\u306a\u308b\u30c7\u30fc\u30bf\u5185\u5bb9<\/td>\n<\/tr>\n \n img<\/td>\n text<\/td>\n \u753b\u50cf\u51fa\u529b\u30d1\u30b9<\/td>\n<\/tr>\n \n created<\/td>\n datetime<\/td>\n \u4f5c\u6210\u65e5\u6642<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n flask\u3068URL\u30eb\u30fc\u30c6\u30a3\u30f3\u30b0<\/h2>\n
\r\nimport os\r\nfrom flask import Flask, redirect, url_for, render_template\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\n@app.route('\/')\r\ndef index():\r\n """ \u4e00\u89a7\u753b\u9762 """\r\n return render_template('index.html', 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 return redirect(url_for('view', pk=0))\r\n\r\n\r\n@app.route('\/delete\/<pk>')\r\ndef delete(pk):\r\n """ \u7d50\u679c\u524a\u9664\u51e6\u7406 """\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 return render_template('view.html', result={})\r\n\r\n\r\nif __name__ == '__main__':\r\n app.run()\r\n\r\n<\/pre>\n