Python testutils.fix_indent函数代码示例

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› Python›Python编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了Python中pyrseas.testutils.fix_indent函数的典型用法代码示例。如果您正苦于以下问题：Python fix_indent函数的具体用法？Python fix_indent怎么用？Python fix_indent使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了fix_indent函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的Python代码示例。

示例1: test_create_aggregate_init_final

 def test_create_aggregate_init_final(self):
     "Create an aggregate with an INITCOND and a FINALFUNC"
     self.db.execute("DROP AGGREGATE IF EXISTS a1(integer)")
     self.db.execute_commit("DROP FUNCTION IF EXISTS f2(integer)")
     self.db.execute_commit(DROP_STMT2)
     inmap = self.std_map()
     inmap['schema public'].update({'function f1(integer, integer)': {
                 'language': 'sql', 'returns': 'integer',
                 'source': SOURCE2,
                 'volatility': 'immutable'}})
     inmap['schema public'].update({'function f2(integer)': {
                 'language': 'sql', 'returns': 'double precision',
                 'source': "SELECT $1::float",
                 'volatility': 'immutable'}})
     inmap['schema public'].update({'aggregate a1(integer)': {
                 'sfunc': 'f1', 'stype': 'integer', 'initcond': '-1',
                 'finalfunc': 'f2(integer)'}})
     dbsql = self.db.process_map(inmap)
     self.assertEqual(fix_indent(dbsql[1]), CREATE_STMT2)
     self.assertEqual(fix_indent(dbsql[2]),
                      "CREATE FUNCTION f2(integer) "
                      "RETURNS double precision LANGUAGE sql IMMUTABLE "
                      "AS $_$SELECT $1::float$_$")
     self.assertEqual(fix_indent(dbsql[3]),
                      "CREATE AGGREGATE a1(integer) "
                      "(SFUNC = f1, STYPE = integer, FINALFUNC = f2, "
                      "INITCOND = '-1')")

开发者ID:rdunklau，项目名称:Pyrseas，代码行数:27，代码来源:test_function.py

示例2: test_create_table_with_defaults

 def test_create_table_with_defaults(self):
     "Create a table with two column DEFAULTs, one referring to a SEQUENCE"
     self.db.execute_commit("DROP SEQUENCE IF EXISTS t1_c1_seq")
     inmap = self.std_map()
     inmap['schema public'].update({'table t1': {
                 'columns': [{'c1': {
                             'type': 'integer',
                             'not_null': True,
                             'default': "nextval('t1_c1_seq'::regclass)"}},
                             {'c2': {'type': 'text', 'not_null': True}},
                             {'c3': {
                             'type': 'date', 'not_null': True,
                             'default': "('now'::text)::date"}}]},
                                    'sequence t1_c1_seq': {
                 'cache_value': 1, 'increment_by': 1, 'max_value': None,
                 'min_value': None, 'start_value': 1}})
     dbsql = self.db.process_map(inmap)
     self.assertEqual(fix_indent(dbsql[0]),
                      "CREATE TABLE t1 (c1 integer NOT NULL, "
                      "c2 text NOT NULL, "
                      "c3 date NOT NULL DEFAULT ('now'::text)::date)")
     self.assertEqual(fix_indent(dbsql[1]),
                      "CREATE SEQUENCE t1_c1_seq START WITH 1 "
                      "INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1")
     self.assertEqual(dbsql[2], "ALTER TABLE t1 ALTER COLUMN c1 "
                      "SET DEFAULT nextval('t1_c1_seq'::regclass)")

开发者ID:rdunklau，项目名称:Pyrseas，代码行数:26，代码来源:test_table.py

示例3: test_create_with_foreign_key

 def test_create_with_foreign_key(self):
     "Create a table with a foreign key constraint"
     inmap = self.std_map()
     inmap['schema public'].update({'table t1': {
                 'columns': [{'c11': {'type': 'integer'}},
                             {'c12': {'type': 'text'}}]},
                                'table t2': {
                 'columns': [{'c21': {'type': 'integer'}},
                             {'c22': {'type': 'text'}},
                             {'c23': {'type': 'integer'}}],
                 'foreign_keys': {'t2_c23_fkey': {
                         'columns': ['c23'],
                         'references': {'columns': ['c11'],
                                        'table': 't1'}}}}})
     sql = self.to_sql(inmap)
     # can't control which table will be created first
     crt1 = 0
     crt2 = 1
     if 't1' in sql[1]:
         crt1 = 1
         crt2 = 0
     self.assertEqual(fix_indent(sql[crt1]),
                          "CREATE TABLE t1 (c11 integer, c12 text)")
     self.assertEqual(fix_indent(sql[crt2]),
                      "CREATE TABLE t2 (c21 integer, c22 text, "
                      "c23 integer)")
     self.assertEqual(fix_indent(sql[2]),
                      "ALTER TABLE t2 ADD CONSTRAINT t2_c23_fkey "
                      "FOREIGN KEY (c23) REFERENCES t1 (c11)")

开发者ID:andreypopp，项目名称:Pyrseas，代码行数:29，代码来源:test_constraint.py

示例4: test_alter_foreign_key2

 def test_alter_foreign_key2(self):
     "Change foreign key: foreign column"
     stmts = ["CREATE TABLE t1 (c11 INTEGER NOT NULL UNIQUE, "
              "c12 INTEGER NOT NULL UNIQUE)",
              "CREATE TABLE t2 (c21 INTEGER PRIMARY KEY NOT NULL, "
              "c22 INTEGER, c23 INTEGER)",
              "ALTER TABLE t2 ADD CONSTRAINT t2_c22_fkey " \
              "FOREIGN KEY (c22) REFERENCES t1 (c11)"]
     inmap = self.std_map()
     inmap['schema public'].update({
         'table t1': {'columns': [
                     {'c11': {'type': 'integer', 'not_null': True}},
                     {'c12': {'type': 'integer', 'not_null': True}}],
                    'unique_constraints': {
                        't1_c11_key': {'columns': ['c11']},
                        't1_c12_key': {'columns': ['c12']}}},
         'table t2': {'columns': [
                     {'c21': {'type': 'integer', 'not_null': True}},
                     {'c22': {'type': 'integer'}},
                     {'c23': {'type': 'integer'}}],
             'primary_key': {'t2_pkey': {'columns': ['c21']}},
             'foreign_keys': {'t2_c22_fkey': {
                 'columns': ['c22'],
                 'references': {'columns': ['c12'],
                                'table': 't1'}}}}})
     sql = self.to_sql(inmap, stmts)
     self.assertEqual(2, len(sql))
     self.assertEqual(fix_indent(sql[0]),
                      'ALTER TABLE t2 DROP CONSTRAINT t2_c22_fkey')
     self.assertEqual(fix_indent(sql[1]),
                      'ALTER TABLE t2 ADD CONSTRAINT t2_c22_fkey ' \
                      'FOREIGN KEY (c22) REFERENCES t1 (c12)')

开发者ID:goldie80，项目名称:Pyrseas，代码行数:32，代码来源:test_constraint.py

示例5: test_create_wrapper_server

 def test_create_wrapper_server(self):
     "Create a foreign data wrapper and its server"
     inmap = self.std_map()
     inmap.update({'foreign data wrapper fdw1': {'server fs1': {}}})
     sql = self.to_sql(inmap)
     assert fix_indent(sql[0]) == CREATE_FDW_STMT
     assert fix_indent(sql[1]) == CREATE_FS_STMT

开发者ID:conor1984，项目名称:Pyrseas，代码行数:7，代码来源:test_foreign.py

示例6: test_create_rule_nothing

 def test_create_rule_nothing(self):
     "Create a rule"
     inmap = self.std_map()
     inmap['schema sd'].update({'table t1': {
         'columns': [{'c1': {'type': 'integer'}}, {'c2': {'type': 'text'}}],
         'rules': {'r1': {'event': 'insert', 'actions': 'NOTHING'}}}})
     sql = self.to_sql(inmap)
     assert fix_indent(sql[0]) == CREATE_TABLE_STMT
     assert fix_indent(sql[1]) == CREATE_STMT % ('INSERT', 'NOTHING')

开发者ID:perseas，项目名称:Pyrseas，代码行数:9，代码来源:test_rule.py

示例7: test_alter_statistics

 def test_alter_statistics(self):
     "Alter a table to add column statistics"
     inmap = self.std_map()
     inmap["schema public"].update(
         {"table t1": {"columns": [{"c1": {"type": "integer", "statistics": 100}}, {"c2": {"type": "text"}}]}}
     )
     sql = self.to_sql(inmap, [CREATE_STMT1, "ALTER TABLE t1 ALTER c2 " "SET STATISTICS 1000"])
     assert fix_indent(sql[0]) == "ALTER TABLE t1 ALTER COLUMN c1 SET STATISTICS 100"
     assert fix_indent(sql[1]) == "ALTER TABLE t1 ALTER COLUMN c2 SET STATISTICS -1"

开发者ID:rhunwicks，项目名称:Pyrseas，代码行数:9，代码来源:test_column.py

示例8: test_change_column_types

 def test_change_column_types(self):
     "Change the datatypes of two columns"
     inmap = self.std_map()
     inmap["schema public"].update(
         {"table t1": {"columns": [{"c1": {"type": "bigint"}}, {"c2": {"type": "varchar(25)"}}]}}
     )
     sql = self.to_sql(inmap, [CREATE_STMT1])
     assert fix_indent(sql[0]) == "ALTER TABLE t1 ALTER COLUMN c1 TYPE bigint"
     assert fix_indent(sql[1]) == "ALTER TABLE t1 ALTER COLUMN c2 TYPE varchar(25)"

开发者ID:rhunwicks，项目名称:Pyrseas，代码行数:9，代码来源:test_column.py

示例9: test_create_wrapper_server_mapping

 def test_create_wrapper_server_mapping(self):
     "Create a FDW, server and user mapping"
     inmap = self.std_map()
     inmap.update({'foreign data wrapper fdw1': {'server fs1': {
         'user mappings': {'PUBLIC': {}}}}})
     sql = self.to_sql(inmap)
     assert fix_indent(sql[0]) == CREATE_FDW_STMT
     assert fix_indent(sql[1]) == CREATE_FS_STMT
     assert fix_indent(sql[2]) == CREATE_UM_STMT

开发者ID:conor1984，项目名称:Pyrseas，代码行数:9，代码来源:test_foreign.py

示例10: test_add_column4

 def test_add_column4(self):
     "Add two columns to a table that has a dropped column"
     stmts = [CREATE_STMT2, DROP_COL_STMT]
     inmap = self.std_map()
     inmap['schema public'].update({'table t1': {
         'columns': [{'c1': {'type': 'integer'}}, {'c2': {'type': 'text'}},
                     {'c3': {'type': 'date'}}, {'c4': {'type': 'text'}}]}})
     sql = self.to_sql(inmap, stmts)
     assert fix_indent(sql[0]) == "ALTER TABLE t1 ADD COLUMN c3 date"
     assert fix_indent(sql[1]) == "ALTER TABLE t1 ADD COLUMN c4 text"

开发者ID:conor1984，项目名称:Pyrseas，代码行数:10，代码来源:test_column.py

示例11: test_create_with_primary_key

 def test_create_with_primary_key(self):
     "Create new table with single column primary key"
     inmap = self.std_map()
     inmap['schema public'].update({'table t1': {
         'columns': [{'c1': {'type': 'text'}}, {'c2': {'type': 'integer'}}],
         'primary_key': {'t1_pkey': {'columns': ['c2']}}}})
     sql = self.to_sql(inmap)
     assert fix_indent(sql[0]) == "CREATE TABLE t1 (c1 text, c2 integer)"
     assert fix_indent(sql[1]) == "ALTER TABLE t1 ADD CONSTRAINT t1_pkey " \
         "PRIMARY KEY (c2)"

开发者ID:court-jus，项目名称:Pyrseas，代码行数:10，代码来源:test_constraint.py

示例12: test_create_w_unique_constraint

 def test_create_w_unique_constraint(self):
     "Create new table with a single column unique constraint"
     inmap = self.std_map()
     inmap['schema public'].update({'table t1': {
         'columns': [{'c1': {'type': 'integer'}}, {'c2': {'type': 'text'}}],
         'unique_constraints': {'t1_c1_key': {'columns': ['c1']}}}})
     sql = self.to_sql(inmap)
     assert fix_indent(sql[0]) == "CREATE TABLE t1 (c1 integer, c2 text)"
     assert fix_indent(sql[1]) == \
         "ALTER TABLE t1 ADD CONSTRAINT t1_c1_key UNIQUE (c1)"

开发者ID:court-jus，项目名称:Pyrseas，代码行数:10，代码来源:test_constraint.py

示例13: test_create_domain_check

 def test_create_domain_check(self):
     "Create a domain with a CHECK constraint"
     inmap = self.std_map()
     inmap['schema sd'].update({'domain d1': {
         'type': 'integer', 'check_constraints': {'d1_check': {
             'expression': '(VALUE >= 1888)'}}}})
     sql = self.to_sql(inmap)
     assert fix_indent(sql[0]) == CREATE_STMT
     assert fix_indent(sql[1]) == "ALTER DOMAIN sd.d1 ADD CONSTRAINT " + \
         "d1_check CHECK (VALUE >= 1888)"

开发者ID:perseas，项目名称:Pyrseas，代码行数:10，代码来源:test_domain.py

示例14: test_drop_add_column3

 def test_drop_add_column3(self):
     "Drop and re-add table columns from table with dropped column"
     stmts = [CREATE_STMT2, DROP_COL_STMT]
     inmap = self.std_map()
     inmap["schema public"].update(
         {"table t1": {"columns": [{"c2": {"type": "text"}}, {"c3": {"type": "date"}}, {"c4": {"type": "text"}}]}}
     )
     sql = self.to_sql(inmap, stmts)
     assert fix_indent(sql[0]) == "ALTER TABLE t1 ADD COLUMN c3 date"
     assert fix_indent(sql[1]) == "ALTER TABLE t1 ADD COLUMN c4 text"
     assert sql[2] == "ALTER TABLE t1 DROP COLUMN c1"

开发者ID:rhunwicks，项目名称:Pyrseas，代码行数:11，代码来源:test_column.py

示例15: test_change_column_types

 def test_change_column_types(self):
     "Change the datatypes of two columns"
     inmap = self.std_map()
     inmap['schema public'].update({'table t1': {
         'columns': [{'c1': {'type': 'bigint'}},
                     {'c2': {'type': 'varchar(25)'}}]}})
     sql = self.to_sql(inmap, [CREATE_STMT1])
     assert fix_indent(sql[0]) == \
         "ALTER TABLE t1 ALTER COLUMN c1 TYPE bigint"
     assert fix_indent(sql[1]) == \
         "ALTER TABLE t1 ALTER COLUMN c2 TYPE varchar(25)"

开发者ID:conor1984，项目名称:Pyrseas，代码行数:11，代码来源:test_column.py

示例16: test_drop_add_column3

 def test_drop_add_column3(self):
     "Drop and re-add table columns from table with dropped column"
     stmts = [CREATE_STMT2, DROP_COL_STMT]
     inmap = self.std_map()
     inmap['schema public'].update({'table t1': {
         'columns': [{'c2': {'type': 'text'}}, {'c3': {'type': 'date'}},
                     {'c4': {'type': 'text'}}]}})
     sql = self.to_sql(inmap, stmts)
     assert fix_indent(sql[0]) == "ALTER TABLE t1 ADD COLUMN c3 date"
     assert fix_indent(sql[1]) == "ALTER TABLE t1 ADD COLUMN c4 text"
     assert sql[2] == "ALTER TABLE t1 DROP COLUMN c1"

开发者ID:conor1984，项目名称:Pyrseas，代码行数:11，代码来源:test_column.py

示例17: test_create_rule_instead

 def test_create_rule_instead(self):
     "Create a rule with an INSTEAD action"
     inmap = self.std_map()
     inmap['schema sd'].update({'table t1': {
         'columns': [{'c1': {'type': 'integer'}}, {'c2': {'type': 'text'}}],
         'rules': {'r1': {'event': 'update', 'instead': True,
                          'actions': 'NOTHING'}}}})
     sql = self.to_sql(inmap)
     assert fix_indent(sql[0]) == CREATE_TABLE_STMT
     assert fix_indent(sql[1]) == "CREATE RULE r1 AS ON UPDATE TO sd.t1 " \
         "DO INSTEAD NOTHING"

开发者ID:perseas，项目名称:Pyrseas，代码行数:11，代码来源:test_rule.py

示例18: test_create_aggregate

 def test_create_aggregate(self):
     "Create a simple aggregate"
     inmap = self.std_map()
     inmap['schema public'].update({'function f1(integer, integer)': {
         'language': 'sql', 'returns': 'integer', 'source': SOURCE2,
         'volatility': 'immutable'}})
     inmap['schema public'].update({'aggregate a1(integer)': {
         'sfunc': 'f1', 'stype': 'integer'}})
     sql = self.to_sql(inmap)
     assert fix_indent(sql[1]) == CREATE_STMT2
     assert fix_indent(sql[2]) == "CREATE AGGREGATE a1(integer) " \
         "(SFUNC = f1, STYPE = integer)"

开发者ID:conor1984，项目名称:Pyrseas，代码行数:12，代码来源:test_function.py

示例19: test_create_event_trigger_simple

 def test_create_event_trigger_simple(self):
     "Create a simple event trigger"
     inmap = self.std_map(plpgsql_installed=True)
     inmap['schema sd'].update({'function f1()': {
         'language': 'plpgsql', 'returns': 'event_trigger',
         'source': FUNC_SRC}})
     inmap.update({'event trigger et1': {
         'enabled': True, 'event': 'ddl_command_end',
         'procedure': 'sd.f1()'}})
     sql = self.to_sql(inmap)
     assert fix_indent(sql[0]) == CREATE_FUNC_STMT
     assert fix_indent(sql[1]) == CREATE_STMT % ''

开发者ID:perseas，项目名称:Pyrseas，代码行数:12，代码来源:test_eventtrig.py

示例20: test_change_column_types

 def test_change_column_types(self):
     "Change the datatypes of two columns"
     self.db.execute_commit(CREATE_STMT1)
     inmap = self.std_map()
     inmap['schema public'].update({'table t1': {
                 'columns': [{'c1': {'type': 'bigint'}},
                             {'c2': {'type': 'varchar(25)'}}]}})
     dbsql = self.db.process_map(inmap)
     self.assertEqual(fix_indent(dbsql[0]),
                      "ALTER TABLE t1 ALTER COLUMN c1 TYPE bigint")
     self.assertEqual(fix_indent(dbsql[1]),
                      "ALTER TABLE t1 ALTER COLUMN c2 TYPE varchar(25)")

开发者ID:rdunklau，项目名称:Pyrseas，代码行数:12，代码来源:test_column.py

注：本文中的pyrseas.testutils.fix_indent函数示例由纯净天空整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

Python fmt.block函数代码示例发布时间：2022-05-27

Python dbobject.split_schema_obj函数代码示例发布时间：2022-05-27

Python util.grid_equal函数代码示例

1 Python 入门教程

Python入门教程 Python 是一种解释型、面向对象、动态数据类型的高级程序设计语言。 P

阅读：13811|2022-01-22

2 Python wikiutil.getFrontPage函数代码示例

Python wikiutil.getFrontPage函数代码示例

阅读：10203|2022-05-24

3 Python 简介

Python 简介 Python 是一个高层次的结合了解释性、编译性、互动性和面向对象的脚本

阅读：4092|2022-01-22

4 Python tests.group函数代码示例

Python tests.group函数代码示例

阅读：4044|2022-05-27

5 Python util.check_if_user_has_permission

Python util.check_if_user_has_permission函数代码示例

阅读：3845|2022-05-27

6 Python 操练实例98

Python 练习实例98 Python 100例题目：从键盘输入一个字符串，将小写字母全部转换成大

阅读：3515|2022-01-22

7 Python 环境搭建

Python 环境搭建本章节我们将向大家介绍如何在本地搭建 Python 开发环境。 Py

阅读：3032|2022-01-22

8 Python output.darkgreen函数代码示例

Python output.darkgreen函数代码示例

阅读：2655|2022-05-25

9 Python 基础语法

Python 基础语法 Python 语言与 Perl，C 和 Java 等语言有许多相似之处。但是，也

阅读：2651|2022-01-22

10 Python 中文编码

Python 中文编码前面章节中我们已经学会了如何用 Python 输出 Hello, World!，英文没

阅读：2303|2022-01-22

客服电话

电子邮件

Python testutils.fix_indent函数代码示例

示例1: test_create_aggregate_init_final

示例2: test_create_table_with_defaults

示例3: test_create_with_foreign_key

示例4: test_alter_foreign_key2

示例5: test_create_wrapper_server

示例6: test_create_rule_nothing

示例7: test_alter_statistics

示例8: test_change_column_types

示例9: test_create_wrapper_server_mapping

示例10: test_add_column4

示例11: test_create_with_primary_key

示例12: test_create_w_unique_constraint

示例13: test_create_domain_check

示例14: test_drop_add_column3

示例15: test_change_column_types

示例16: test_drop_add_column3

示例17: test_create_rule_instead

示例18: test_create_aggregate

示例19: test_create_event_trigger_simple

示例20: test_change_column_types

请发表评论

全部评论

上一篇：

下一篇：

Python util.grid_equal函数代码示例

Python util.get_worker_name函数代码示例

Python util.get_webmention_target函数代

Python util.get_uuid函数代码示例

Python util.get_type_by_name函数代码示例

Python util.grid_equal函数代码示例

Python util.get_worker_name函数代码示例

Python util.get_webmention_target函数代

Python util.get_uuid函数代码示例

Python util.get_type_by_name函数代码示例

Python util.get_stdout函数代码示例

关于我们

产品与服务

解决方案

139-2527-9053