章：数据库 35 为了设置 Flask、扩展或是我们程序本身的一些行为，我们需要设置和定义一些配 置变量。Flask 提供了一个统一的接口来写入和获取这些配置变 量： Flask.config 字典。配置变量的名称必须使用大写，写入配置的语句一般 会放到扩展类实例化语句之前。 下面写入了一个 SQLALCHEMY_DATABASE_URI 变量来告诉 SQLAlchemy 数据库连 config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////' + os.path. join(app.root_path, 'data.db') 注意 这个配置变量的最后一个单词是 URI，而不是 URL。 对于这个变量值，不同的 DBMS 有不同的格式，对于 SQLite 来说，这个值的格式 如下： sqlite:////数据库文件的绝对地址 数据库文件一般放到项目根目录即可， sqlite3 作为后缀。 另外，如果你使用 Windows 系统，上面的 URI 前缀部分需要写入三个斜线（即 sqlite:/// ）。在本书的示例程序代码里，做了一些兼容性处理，另外还新设 置了一个配置变量，实际的代码如下： 第 5 章：数据库 36 import os import sys from flask import Flask WIN = sys.platform.startswith('win')

type=task_status) args = parser.parse_args() 1.5.3 Response Formats To support other representations (xml, csv, html), you can use the representation() decorator. You need to have a reference to your API. **kwargs): super(Api, self).__init__(*args, **kwargs) self.representations = { 'application/xml': output_xml, 'text/html': output_html, 'text/csv': output_csv, 'application/json': output_json, } 1.5.4 Flask response object. Ex: @api.representation('application/xml') def xml(data, code, headers): resp = make_response(convert_data_to_xml(data), code) resp.headers.extend(headers) return resp resource(*urls

type=task_status) args = parser.parse_args() Response Formats To support other representations (xml, csv, html), you can use the representation() decorator. You need to have a reference to your API. super(Api, self).__init__(*args, **kwargs) self.representations = { 'application/xml': output_xml, 'text/html': output_html, 'text/csv': output_csv, 'application/json': Flask response object. Ex: @api.representation('application/xml') def xml(data, code, headers): resp = make_response(convert_data_to_xml(data), code) resp.headers.extend(headers) return resp

type=task_status) args = parser.parse_args() 1.5.3 Response Formats To support other representations (xml, csv, html), you can use the representation() decorator. You need to have a reference to your API. **kwargs): super(Api, self).__init__(*args, **kwargs) self.representations = { 'application/xml': output_xml, 'text/html': output_html, 'text/csv': output_csv, 'application/json': output_json, } 1.5.4 Flask response object. Ex: @api.representation('application/xml') def xml(data, code, headers): resp = make_response(convert_data_to_xml(data), code) resp.headers.extend(headers) return resp resource(*urls

type=task_status) args = parser.parse_args() 1.5.3 Response Formats To support other representations (xml, csv, html), you can use the representation() decorator. You need to have a reference to your API. **kwargs): super(Api, self).__init__(*args, **kwargs) self.representations = { 'application/xml': output_xml, 'text/html': output_html, 'text/csv': output_csv, 'application/json': output_json, } 1.5.4 Flask response object. Ex: @api.representation('application/xml') def xml(data, code, headers): resp = make_response(convert_data_to_xml(data), code) resp.headers.extend(headers) return resp resource(*urls

type=task_status) args = parser.parse_args() Response Formats To support other representations (xml, csv, html), you can use the representation() decorator. You need to have a reference to your API. super(Api, self).__init__(*args, **kwargs) self.representations = { 'application/xml': output_xml, 'text/html': output_html, 'text/csv': output_csv, 'application/json': Flask response object. Ex: @api.representation('application/xml') def xml(data, code, headers): resp = make_response(convert_data_to_xml(data), code) resp.headers.extend(headers) return resp

type=task_status) args = parser.parse_args() Response Formats To support other representations (xml, csv, html), you can use the representation() decorator. You need to have a reference to your API. super(Api, self).__init__(*args, **kwargs) self.representations = { 'application/xml': output_xml, 'text/html': output_html, 'text/csv': output_csv, 'application/json': Flask response object. Ex: @api.representation('application/xml') def xml(data, code, headers): resp = make_response(convert_data_to_xml(data), code) resp.headers.extend(headers) return resp

enabled for all templates. The following extensions for tem- plates trigger autoescaping: .html, .htm, .xml, .xhtml. Templates loaded from a string will have autoescaping disabled. 1.4.7 Accessing Request Data configured by Flask as follows: • autoescaping is enabled for all templates ending in .html, .htm, .xml as well as .xhtml when using render_template(). • autoescaping is enabled for all strings when using of automatically escaping special characters for you. Special characters in the sense of HTML (or XML, and thus XHTML) are &, >, <, " as well as '. Because these characters carry specific meanings in documents

configured by Flask as follows: autoescaping is enabled for all templates ending in .html, .htm, .xml as well as .xhtml when using render_template(). autoescaping is enabled for all strings when using of automatically escaping special characters for you. Special characters in the sense of HTML (or XML, and thus XHTML) are &, >, <, " as well as '. Because these characters carry specific meanings in documents is widely supported and very easy to parse. It became popular a few years ago and quickly replaced XML as transport format in web applications. Loading jQuery In order to use jQuery, you have to download

type=task_status) args = parser.parse_args() Response Formats To support other representations (xml, csv, html), you can use the representation() decorator. You need to have a reference to your API. super(Api, self).__init__(*args, **kwargs) self.representations = { 'application/xml': output_xml, 'text/html': output_html, 'text/csv': output_csv, 'application/json':