-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathflask_api.html
377 lines (309 loc) · 29.9 KB
/
flask_api.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
<!DOCTYPE html>
<html lang="cn">
<head>
<meta charset="utf-8" />
<title>使用python3和flask构建RESTful API(接口测试服务与mockserver工具)</title>
<link rel="stylesheet" href="/theme/css/main.css" />
</head>
<body id="index" class="home">
<header id="banner" class="body">
<h1><a href="/">python自动化测试人工智能 </a></h1>
<nav><ul>
<li><a href="/category/ba-zi.html">八字</a></li>
<li><a href="/category/ce-shi.html">测试</a></li>
<li class="active"><a href="/category/ce-shi-kuang-jia.html">测试框架</a></li>
<li><a href="/category/common.html">common</a></li>
<li><a href="/category/da-shu-ju.html">大数据</a></li>
<li><a href="/category/feng-shui.html">风水</a></li>
<li><a href="/category/ji-qi-xue-xi.html">机器学习</a></li>
<li><a href="/category/jie-meng.html">解梦</a></li>
<li><a href="/category/linux.html">linux</a></li>
<li><a href="/category/python.html">python</a></li>
<li><a href="/category/shu-ji.html">书籍</a></li>
<li><a href="/category/shu-ju-fen-xi.html">数据分析</a></li>
<li><a href="/category/zhong-cao-yao.html">中草药</a></li>
<li><a href="/category/zhong-yi.html">中医</a></li>
</ul></nav>
</header><!-- /#banner -->
<section id="content" class="body">
<article>
<header>
<h1 class="entry-title">
<a href="/flask_api.html" rel="bookmark"
title="Permalink to 使用python3和flask构建RESTful API(接口测试服务与mockserver工具)">使用python3和flask构建RESTful API(接口测试服务与mockserver工具)</a></h1>
</header>
<div class="entry-content">
<footer class="post-info">
<abbr class="published" title="2018-11-30T08:20:00+08:00">
Published: 五 30 十一月 2018
</abbr>
<address class="vcard author">
By <a class="url fn" href="/author/andrew.html">andrew</a>
</address>
<p>In <a href="/category/ce-shi-kuang-jia.html">测试框架</a>.</p>
</footer><!-- /.post-info --> <ul>
<li><a href="https://china-testing.github.io/practices.html">python测试开发项目实战-目录</a></li>
<li><a href="https://china-testing.github.io/flask_books.html">web开发工具flask中文英文书籍下载-持续更新</a></li>
</ul>
<h2 id="_1">引言</h2>
<p>构建RESTful API貌似是开发的工作，和测试有和关系？</p>
<p>其实测试开发需要构建RESTful API的场景很多。比如测试Android应用，一般的接口测试只考虑了服务器端，至于客户端在网络异常或者服务端异常时如何反应，多数天朝的测试人员是没有考虑到的。客户端在对这些异常处理不够充分的时候，会出现崩溃等各种莫名其妙的问题。</p>
<p>为此一些走在前沿的测试人员会自己写一些RESTful API， 把服务端的域名劫持到自己的API，故意返回各种异常，看客户端的稳定性。</p>
<p>另外测试开发的测试工具需要和其他系统对接等场景也经常需要API。</p>
<h2 id="_2">参考资料</h2>
<ul>
<li><a href="https://www.codementor.io/dongido/how-to-build-restful-apis-with-python-and-flask-fh5x7zjrx">How to Build RESTful APIs with Python and Flask</a></li>
<li><a href="https://china-testing.github.io/flask_api.html">本文地址</a></li>
<li><a href="https://github.com/china-testing/python-api-tesing/tree/master/flask/api_demo">本文源码地址</a></li>
<li><a href="https://github.com/china-testing/python-api-tesing">本文涉及的python测试开发库</a> 谢谢点赞！</li>
<li><a href="https://github.com/china-testing/python-api-tesing/blob/master/books.md">本文相关书籍下载</a></li>
</ul>
<h2 id="_3">术语</h2>
<p>REST： REpresentational State Transfer</p>
<h2 id="_4">目标</h2>
<ul>
<li>
<p>GET - /api/Category - Retrieve all categories</p>
</li>
<li>
<p>POST - /api/Category - Add a new category</p>
</li>
<li>
<p>PUT - /api/Category - Update a category</p>
</li>
<li>
<p>DELETE - /api/Category - Delete a category</p>
</li>
<li>
<p>GET - /api/Comment - Retrieve all the stored comments</p>
</li>
<li>
<p>POST - /api/Comment - Add new comment</p>
</li>
</ul>
<h2 id="_5">要求</h2>
<ul>
<li>python3.*</li>
<li>PostgreSQL</li>
</ul>
<h2 id="_6">工程目录</h2>
<div class="highlight"><pre><span></span><span class="n">project</span><span class="o">/</span>
<span class="err">├──</span> <span class="n">app</span><span class="o">.</span><span class="n">py</span>
<span class="err">├──</span> <span class="n">config</span><span class="o">.</span><span class="n">py</span>
<span class="err">├──</span> <span class="n">migrate</span><span class="o">.</span><span class="n">py</span>
<span class="err">├──</span> <span class="n">Model</span><span class="o">.</span><span class="n">py</span>
<span class="err">├──</span> <span class="n">requirements</span><span class="o">.</span><span class="n">txt</span>
<span class="err">├──</span> <span class="n">resources</span>
<span class="err">│</span> <span class="err">└──</span> <span class="n">Hello</span><span class="o">.</span><span class="n">py</span>
<span class="err">│</span> <span class="err">└──</span> <span class="n">Comment</span><span class="o">.</span><span class="n">py</span>
<span class="err">│</span> <span class="err">└──</span> <span class="n">Category</span><span class="o">.</span><span class="n">py</span>
<span class="err">└──</span> <span class="n">run</span><span class="o">.</span><span class="n">py</span>
</pre></div>
<p>requirements.txt的内容如下：</p>
<div class="highlight"><pre><span></span><span class="n">flask</span>
<span class="n">flask_restful</span>
<span class="n">flask_script</span>
<span class="n">flask_migrate</span>
<span class="n">marshmallow</span>
<span class="n">flask_sqlalchemy</span>
<span class="n">flask_marshmallow</span>
<span class="n">marshmallow</span><span class="o">-</span><span class="n">sqlalchemy</span>
<span class="n">psycopg2</span><span class="o">-</span><span class="n">binary</span>
<span class="n">python</span><span class="o">-</span><span class="n">daemon</span>
</pre></div>
<ul>
<li>
<p>flask - Python的微框架</p>
</li>
<li>
<p>flask_restful - 这是Flask的扩展，可快速构建REST API。</p>
</li>
<li>
<p>flask_script - 提供了在Flask中编写外部脚本的支持。</p>
</li>
<li>
<p>flask_migrate - 使用Alembic的Flask应用进行SQLAlchemy数据库迁移。</p>
</li>
<li>
<p>marshmallow - ORM/ODM/框架无关的库，用于复杂数据类型（如对象）和Python数据类型转换。</p>
</li>
<li>
<p>flask_sqlalchemy - Flask扩展，增加了对SQLAlchemy的支持。</p>
</li>
<li>
<p>flask_marshmallow - 这是Flask和marshmallow的中间层。</p>
</li>
<li>
<p>marshmallow-sqlalchemy - 这是sqlalchemy和marshmallow的中间层。</p>
</li>
<li>
<p>psycopg - Python的PostgreSQL API。</p>
</li>
</ul>
<p>安装依赖</p>
<div class="highlight"><pre><span></span><span class="c1"># pip3 install -r requirements.txt</span>
</pre></div>
<h2 id="postgresql">安装配置PostgreSQL</h2>
<p>这里以 Ubuntu 16.04为例：</p>
<div class="highlight"><pre><span></span><span class="c1"># sudo apt-get update && sudo apt-get upgrade</span>
<span class="c1"># apt-get install postgresql postgresql-contrib</span>
<span class="c1"># su - postgres</span>
<span class="err">$</span> <span class="n">createdb</span> <span class="n">api</span>
<span class="err">$</span> <span class="n">createuser</span> <span class="n">andrew</span> <span class="o">--</span><span class="n">pwprompt</span> <span class="c1">#创建用户</span>
<span class="err">$</span> <span class="n">psql</span> <span class="o">-</span><span class="n">d</span> <span class="n">api</span> <span class="o">-</span><span class="n">c</span> <span class="s2">"ALTER USER andrew WITH PASSWORD 'api';"</span>
</pre></div>
<p>参考资料：</p>
<p><a href="https://linode.com/docs/databases/postgresql/how-to-install-postgresql-on-ubuntu-16-04/">How to Install PostgreSQL on Ubuntu 16.04</a></p>
<p><a href="https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-14-04">How To Install and Use PostgreSQL on Ubuntu 14.04</a></p>
<h2 id="_7">配置</h2>
<div class="highlight"><pre><span></span><span class="c1"># -*- coding: utf-8 -*-</span>
<span class="c1"># Author: xurongzhong#126.com </span>
<span class="c1"># 项目实战讨论QQ群630011153 144081101</span>
<span class="c1"># CreateDate: 2018-1-10</span>
<span class="kn">from</span> <span class="nn">flask</span> <span class="kn">import</span> <span class="n">Blueprint</span>
<span class="kn">from</span> <span class="nn">flask_restful</span> <span class="kn">import</span> <span class="n">Api</span>
<span class="kn">from</span> <span class="nn">resources.Hello</span> <span class="kn">import</span> <span class="n">Hello</span>
<span class="kn">from</span> <span class="nn">resources.Category</span> <span class="kn">import</span> <span class="n">CategoryResource</span>
<span class="kn">from</span> <span class="nn">resources.Comment</span> <span class="kn">import</span> <span class="n">CommentResource</span>
<span class="n">api_bp</span> <span class="o">=</span> <span class="n">Blueprint</span><span class="p">(</span><span class="s1">'api'</span><span class="p">,</span> <span class="vm">__name__</span><span class="p">)</span>
<span class="n">api</span> <span class="o">=</span> <span class="n">Api</span><span class="p">(</span><span class="n">api_bp</span><span class="p">)</span>
<span class="c1"># Routes</span>
<span class="n">api</span><span class="o">.</span><span class="n">add_resource</span><span class="p">(</span><span class="n">Hello</span><span class="p">,</span> <span class="s1">'/Hello'</span><span class="p">)</span>
<span class="n">api</span><span class="o">.</span><span class="n">add_resource</span><span class="p">(</span><span class="n">CategoryResource</span><span class="p">,</span> <span class="s1">'/Category'</span><span class="p">)</span>
<span class="n">api</span><span class="o">.</span><span class="n">add_resource</span><span class="p">(</span><span class="n">CommentResource</span><span class="p">,</span> <span class="s1">'/Comment'</span><span class="p">)</span>
</pre></div>
<h2 id="_8">快速入门</h2>
<p>app.py</p>
<div class="highlight"><pre><span></span><span class="kn">from</span> <span class="nn">flask</span> <span class="kn">import</span> <span class="n">Blueprint</span>
<span class="kn">from</span> <span class="nn">flask_restful</span> <span class="kn">import</span> <span class="n">Api</span>
<span class="kn">from</span> <span class="nn">resources.Hello</span> <span class="kn">import</span> <span class="n">Hello</span>
<span class="n">api_bp</span> <span class="o">=</span> <span class="n">Blueprint</span><span class="p">(</span><span class="s1">'api'</span><span class="p">,</span> <span class="vm">__name__</span><span class="p">)</span>
<span class="n">api</span> <span class="o">=</span> <span class="n">Api</span><span class="p">(</span><span class="n">api_bp</span><span class="p">)</span>
<span class="c1"># Route</span>
<span class="n">api</span><span class="o">.</span><span class="n">add_resource</span><span class="p">(</span><span class="n">Hello</span><span class="p">,</span> <span class="s1">'/Hello'</span><span class="p">)</span>
</pre></div>
<p>resource/Hello.py</p>
<div class="highlight"><pre><span></span><span class="ch">#!/usr/bin/python</span>
<span class="c1"># -*- coding: utf-8 -*-</span>
<span class="c1"># Author: xurongzhong#126.com wechat:pythontesting qq:37391319</span>
<span class="c1"># CreateDate: 2018-1-10</span>
<span class="kn">from</span> <span class="nn">flask_restful</span> <span class="kn">import</span> <span class="n">Resource</span>
<span class="k">class</span> <span class="nc">Hello</span><span class="p">(</span><span class="n">Resource</span><span class="p">):</span>
<span class="k">def</span> <span class="nf">get</span><span class="p">(</span><span class="bp">self</span><span class="p">):</span>
<span class="k">return</span> <span class="p">{</span><span class="s2">"message"</span><span class="p">:</span> <span class="s2">"Hello, World!"</span><span class="p">}</span>
<span class="k">def</span> <span class="nf">post</span><span class="p">(</span><span class="bp">self</span><span class="p">):</span>
<span class="k">return</span> <span class="p">{</span><span class="s2">"message"</span><span class="p">:</span> <span class="s2">"Hello, World!"</span><span class="p">}</span>
</pre></div>
<p>run.py</p>
<div class="highlight"><pre><span></span><span class="kn">from</span> <span class="nn">flask</span> <span class="kn">import</span> <span class="n">Flask</span>
<span class="k">def</span> <span class="nf">create_app</span><span class="p">(</span><span class="n">config_filename</span><span class="p">):</span>
<span class="n">app</span> <span class="o">=</span> <span class="n">Flask</span><span class="p">(</span><span class="vm">__name__</span><span class="p">)</span>
<span class="n">app</span><span class="o">.</span><span class="n">config</span><span class="o">.</span><span class="n">from_object</span><span class="p">(</span><span class="n">config_filename</span><span class="p">)</span>
<span class="kn">from</span> <span class="nn">app</span> <span class="kn">import</span> <span class="n">api_bp</span>
<span class="n">app</span><span class="o">.</span><span class="n">register_blueprint</span><span class="p">(</span><span class="n">api_bp</span><span class="p">,</span> <span class="n">url_prefix</span><span class="o">=</span><span class="s1">'/api'</span><span class="p">)</span>
<span class="k">return</span> <span class="n">app</span>
<span class="k">if</span> <span class="vm">__name__</span> <span class="o">==</span> <span class="s2">"__main__"</span><span class="p">:</span>
<span class="n">app</span> <span class="o">=</span> <span class="n">create_app</span><span class="p">(</span><span class="s2">"config"</span><span class="p">)</span>
<span class="n">app</span><span class="o">.</span><span class="n">run</span><span class="p">(</span><span class="n">debug</span><span class="o">=</span><span class="bp">True</span><span class="p">)</span>
</pre></div>
<p>启动服务</p>
<div class="highlight"><pre><span></span><span class="err">$</span> <span class="n">python3</span> <span class="n">run</span><span class="o">.</span><span class="n">py</span>
<span class="o">*</span> <span class="n">Running</span> <span class="n">on</span> <span class="n">http</span><span class="p">:</span><span class="o">//</span><span class="mf">127.0</span><span class="o">.</span><span class="mf">0.1</span><span class="p">:</span><span class="mi">5000</span><span class="o">/</span> <span class="p">(</span><span class="n">Press</span> <span class="n">CTRL</span><span class="o">+</span><span class="n">C</span> <span class="n">to</span> <span class="n">quit</span><span class="p">)</span>
<span class="o">*</span> <span class="n">Restarting</span> <span class="k">with</span> <span class="n">stat</span>
<span class="o">*</span> <span class="n">Debugger</span> <span class="ow">is</span> <span class="n">active</span><span class="err">!</span>
<span class="o">*</span> <span class="n">Debugger</span> <span class="n">PIN</span><span class="p">:</span> <span class="mi">136</span><span class="o">-</span><span class="mi">695</span><span class="o">-</span><span class="mi">873</span>
</pre></div>
<p>用浏览器访问： <a href="http://127.0.0.1:5000/api/Hello">http://127.0.0.1:5000/api/Hello</a></p>
<div class="highlight"><pre><span></span><span class="p">{</span>
<span class="s2">"hello"</span><span class="p">:</span> <span class="s2">"world"</span>
<span class="p">}</span>
</pre></div>
<h2 id="_9">接入数据库</h2>
<div class="highlight"><pre><span></span><span class="kn">from</span> <span class="nn">flask</span> <span class="kn">import</span> <span class="n">Flask</span>
<span class="kn">from</span> <span class="nn">marshmallow</span> <span class="kn">import</span> <span class="n">Schema</span><span class="p">,</span> <span class="n">fields</span><span class="p">,</span> <span class="n">pre_load</span><span class="p">,</span> <span class="n">validate</span>
<span class="kn">from</span> <span class="nn">flask_marshmallow</span> <span class="kn">import</span> <span class="n">Marshmallow</span>
<span class="kn">from</span> <span class="nn">flask_sqlalchemy</span> <span class="kn">import</span> <span class="n">SQLAlchemy</span>
<span class="n">ma</span> <span class="o">=</span> <span class="n">Marshmallow</span><span class="p">()</span>
<span class="n">db</span> <span class="o">=</span> <span class="n">SQLAlchemy</span><span class="p">()</span>
<span class="k">class</span> <span class="nc">Comment</span><span class="p">(</span><span class="n">db</span><span class="o">.</span><span class="n">Model</span><span class="p">):</span>
<span class="n">__tablename__</span> <span class="o">=</span> <span class="s1">'comments'</span>
<span class="nb">id</span> <span class="o">=</span> <span class="n">db</span><span class="o">.</span><span class="n">Column</span><span class="p">(</span><span class="n">db</span><span class="o">.</span><span class="n">Integer</span><span class="p">,</span> <span class="n">primary_key</span><span class="o">=</span><span class="bp">True</span><span class="p">)</span>
<span class="n">comment</span> <span class="o">=</span> <span class="n">db</span><span class="o">.</span><span class="n">Column</span><span class="p">(</span><span class="n">db</span><span class="o">.</span><span class="n">String</span><span class="p">(</span><span class="mi">250</span><span class="p">),</span> <span class="n">nullable</span><span class="o">=</span><span class="bp">False</span><span class="p">)</span>
<span class="n">creation_date</span> <span class="o">=</span> <span class="n">db</span><span class="o">.</span><span class="n">Column</span><span class="p">(</span><span class="n">db</span><span class="o">.</span><span class="n">TIMESTAMP</span><span class="p">,</span> <span class="n">server_default</span><span class="o">=</span><span class="n">db</span><span class="o">.</span><span class="n">func</span><span class="o">.</span><span class="n">current_timestamp</span><span class="p">(),</span> <span class="n">nullable</span><span class="o">=</span><span class="bp">False</span><span class="p">)</span>
<span class="n">category_id</span> <span class="o">=</span> <span class="n">db</span><span class="o">.</span><span class="n">Column</span><span class="p">(</span><span class="n">db</span><span class="o">.</span><span class="n">Integer</span><span class="p">,</span> <span class="n">db</span><span class="o">.</span><span class="n">ForeignKey</span><span class="p">(</span><span class="s1">'categories.id'</span><span class="p">,</span> <span class="n">ondelete</span><span class="o">=</span><span class="s1">'CASCADE'</span><span class="p">),</span> <span class="n">nullable</span><span class="o">=</span><span class="bp">False</span><span class="p">)</span>
<span class="n">category</span> <span class="o">=</span> <span class="n">db</span><span class="o">.</span><span class="n">relationship</span><span class="p">(</span><span class="s1">'Category'</span><span class="p">,</span> <span class="n">backref</span><span class="o">=</span><span class="n">db</span><span class="o">.</span><span class="n">backref</span><span class="p">(</span><span class="s1">'comments'</span><span class="p">,</span> <span class="n">lazy</span><span class="o">=</span><span class="s1">'dynamic'</span> <span class="p">))</span>
<span class="k">def</span> <span class="fm">__init__</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">comment</span><span class="p">,</span> <span class="n">category_id</span><span class="p">):</span>
<span class="bp">self</span><span class="o">.</span><span class="n">comment</span> <span class="o">=</span> <span class="n">comment</span>
<span class="bp">self</span><span class="o">.</span><span class="n">category_id</span> <span class="o">=</span> <span class="n">category_id</span>
<span class="k">class</span> <span class="nc">Category</span><span class="p">(</span><span class="n">db</span><span class="o">.</span><span class="n">Model</span><span class="p">):</span>
<span class="n">__tablename__</span> <span class="o">=</span> <span class="s1">'categories'</span>
<span class="nb">id</span> <span class="o">=</span> <span class="n">db</span><span class="o">.</span><span class="n">Column</span><span class="p">(</span><span class="n">db</span><span class="o">.</span><span class="n">Integer</span><span class="p">,</span> <span class="n">primary_key</span><span class="o">=</span><span class="bp">True</span><span class="p">)</span>
<span class="n">name</span> <span class="o">=</span> <span class="n">db</span><span class="o">.</span><span class="n">Column</span><span class="p">(</span><span class="n">db</span><span class="o">.</span><span class="n">String</span><span class="p">(</span><span class="mi">150</span><span class="p">),</span> <span class="n">unique</span><span class="o">=</span><span class="bp">True</span><span class="p">,</span> <span class="n">nullable</span><span class="o">=</span><span class="bp">False</span><span class="p">)</span>
<span class="k">def</span> <span class="fm">__init__</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">name</span><span class="p">):</span>
<span class="bp">self</span><span class="o">.</span><span class="n">name</span> <span class="o">=</span> <span class="n">name</span>
<span class="k">class</span> <span class="nc">CategorySchema</span><span class="p">(</span><span class="n">ma</span><span class="o">.</span><span class="n">Schema</span><span class="p">):</span>
<span class="nb">id</span> <span class="o">=</span> <span class="n">fields</span><span class="o">.</span><span class="n">Integer</span><span class="p">()</span>
<span class="n">name</span> <span class="o">=</span> <span class="n">fields</span><span class="o">.</span><span class="n">String</span><span class="p">(</span><span class="n">required</span><span class="o">=</span><span class="bp">True</span><span class="p">)</span>
<span class="k">class</span> <span class="nc">CommentSchema</span><span class="p">(</span><span class="n">ma</span><span class="o">.</span><span class="n">Schema</span><span class="p">):</span>
<span class="nb">id</span> <span class="o">=</span> <span class="n">fields</span><span class="o">.</span><span class="n">Integer</span><span class="p">(</span><span class="n">dump_only</span><span class="o">=</span><span class="bp">True</span><span class="p">)</span>
<span class="n">category_id</span> <span class="o">=</span> <span class="n">fields</span><span class="o">.</span><span class="n">Integer</span><span class="p">(</span><span class="n">required</span><span class="o">=</span><span class="bp">True</span><span class="p">)</span>
<span class="n">comment</span> <span class="o">=</span> <span class="n">fields</span><span class="o">.</span><span class="n">String</span><span class="p">(</span><span class="n">required</span><span class="o">=</span><span class="bp">True</span><span class="p">,</span> <span class="n">validate</span><span class="o">=</span><span class="n">validate</span><span class="o">.</span><span class="n">Length</span><span class="p">(</span><span class="mi">1</span><span class="p">))</span>
<span class="n">creation_date</span> <span class="o">=</span> <span class="n">fields</span><span class="o">.</span><span class="n">DateTime</span><span class="p">()</span>
</pre></div>
<p>migrate.py</p>
<div class="highlight"><pre><span></span><span class="kn">from</span> <span class="nn">flask_script</span> <span class="kn">import</span> <span class="n">Manager</span>
<span class="kn">from</span> <span class="nn">flask_migrate</span> <span class="kn">import</span> <span class="n">Migrate</span><span class="p">,</span> <span class="n">MigrateCommand</span>
<span class="kn">from</span> <span class="nn">Model</span> <span class="kn">import</span> <span class="n">db</span>
<span class="kn">from</span> <span class="nn">run</span> <span class="kn">import</span> <span class="n">create_app</span>
<span class="n">app</span> <span class="o">=</span> <span class="n">create_app</span><span class="p">(</span><span class="s1">'config'</span><span class="p">)</span>
<span class="n">migrate</span> <span class="o">=</span> <span class="n">Migrate</span><span class="p">(</span><span class="n">app</span><span class="p">,</span> <span class="n">db</span><span class="p">)</span>
<span class="n">manager</span> <span class="o">=</span> <span class="n">Manager</span><span class="p">(</span><span class="n">app</span><span class="p">)</span>
<span class="n">manager</span><span class="o">.</span><span class="n">add_command</span><span class="p">(</span><span class="s1">'db'</span><span class="p">,</span> <span class="n">MigrateCommand</span><span class="p">)</span>
<span class="k">if</span> <span class="vm">__name__</span> <span class="o">==</span> <span class="s1">'__main__'</span><span class="p">:</span>
<span class="n">manager</span><span class="o">.</span><span class="n">run</span><span class="p">()</span>
</pre></div>
<p>数据迁移</p>
<div class="highlight"><pre><span></span><span class="err">$</span> <span class="n">python3</span> <span class="n">migrate</span><span class="o">.</span><span class="n">py</span> <span class="n">db</span> <span class="n">init</span>
<span class="err">$</span> <span class="n">python3</span> <span class="n">migrate</span><span class="o">.</span><span class="n">py</span> <span class="n">db</span> <span class="n">migrate</span>
<span class="err">$</span> <span class="n">python</span> <span class="n">migrate</span><span class="o">.</span><span class="n">py</span> <span class="n">db</span> <span class="n">upgrade</span>
</pre></div>
<p>修改Category.py 和Comment.py， <a href="https://github.com/china-testing/python-api-tesing/tree/master/flask/api_demo">完整代码</a></p>
<h2 id="_10">测试</h2>
<p>可以使用curl，比如：</p>
<div class="highlight"><pre><span></span><span class="n">curl</span> <span class="n">http</span><span class="p">:</span><span class="o">//</span><span class="mf">127.0</span><span class="o">.</span><span class="mf">0.1</span><span class="p">:</span><span class="mi">5000</span><span class="o">/</span><span class="n">api</span><span class="o">/</span><span class="n">Category</span> <span class="o">--</span><span class="n">data</span> <span class="s1">'{"name":"test5","id":5}'</span> <span class="o">-</span><span class="n">H</span> <span class="s2">"Content-Type: application/json"</span>
</pre></div>
<p>也可以在chrome中使用postman：</p>
<p><img alt="image" src="http://upload-images.jianshu.io/upload_images/12713060-efa788a11a977367.jpg?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240"></p>
<p><img alt="image" src="http://upload-images.jianshu.io/upload_images/12713060-f2313d172060f316.jpg?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240"></p>
<p><img alt="image" src="http://upload-images.jianshu.io/upload_images/12713060-4765a5c2b45fa39e.jpg?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240"></p>
<h2 id="_11">参考资料</h2>
<ul>
<li><a href="https://github.com/china-testing/python-api-tesing/blob/master/books.md">本文相关书籍下载</a></li>
<li>python测试等IT技术支持qq群144081101(后期会录制视频存在该群群文件) 591302926 567351477 </li>
<li>道家技术-手相手诊看相中医等钉钉群21734177 qq群：391441566 184175668 338228106 看手相、面相、舌相、抽签、体质识别。服务费50元每人次起。请联系钉钉或者微信pythontesting</li>
<li><a href="https://china-testing.github.io/python_flask_autotest1.html">本文最新版本地址</a></li>
<li><a href="https://github.com/china-testing/python-api-tesing">本文涉及的python测试开发库</a> 谢谢点赞！</li>
<li><a href="https://china-testing.github.io/testing_training.html">接口自动化性能测试线上培训大纲</a></li>
<li><a href="https://github.com/china-testing/python-api-tesing/tree/master/flask/flask_web_service">本文代码地址</a></li>
</ul>
</div><!-- /.entry-content -->
</article>
</section>
<section id="extras" class="body">
<div class="blogroll">
<h2>links</h2>
<ul>
<li><a href="https://china-testing.github.io/testing_training.html">自动化性能接口测试线上及深圳培训与项目实战 qq群：144081101 591302926</a></li>
<li><a href="http://blog.sciencenet.cn/blog-2604609-1112306.html">pandas数据分析scrapy爬虫 521070358 Py人工智能pandas-opencv 6089740</a></li>
<li><a href="http://blog.sciencenet.cn/blog-2604609-1112306.html">中医解梦看相八字算命qq群 391441566 csdn书籍下载-python爬虫 437355848</a></li>
</ul>
</div><!-- /.blogroll -->
</section><!-- /#extras -->
<footer id="contentinfo" class="body">
<address id="about" class="vcard body">
Proudly powered by <a href="http://getpelican.com/">Pelican</a>, which takes great advantage of <a href="http://python.org">Python</a>.
</address><!-- /#about -->
<p>The theme is by <a href="http://coding.smashingmagazine.com/2009/08/04/designing-a-html-5-layout-from-scratch/">Smashing Magazine</a>, thanks!</p>
</footer><!-- /#contentinfo -->
</body>
</html>