Python sqlparse.format函数代码示例

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

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

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

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

示例1: test_issue40

def test_issue40():
    # make sure identifier lists in subselects are grouped
    p = sqlparse.parse(('SELECT id, name FROM '
                        '(SELECT id, name FROM bar) as foo'))[0]
    assert len(p.tokens) == 7
    assert p.tokens[2].__class__ == sql.IdentifierList
    assert p.tokens[-1].__class__ == sql.Identifier
    assert p.tokens[-1].get_name() == 'foo'
    sp = p.tokens[-1].tokens[0]
    assert sp.tokens[3].__class__ == sql.IdentifierList
    # make sure that formatting works as expected
    s = sqlparse.format('SELECT id ==  name FROM '
                        '(SELECT id, name FROM bar)', reindent=True)
    assert s == '\n'.join([
        'SELECT id == name',
        'FROM',
        '  (SELECT id,',
        '          name',
        '   FROM bar)'])

    s = sqlparse.format('SELECT id ==  name FROM '
                        '(SELECT id, name FROM bar) as foo', reindent=True)
    assert s == '\n'.join([
        'SELECT id == name',
        'FROM',
        '  (SELECT id,',
        '          name',
        '   FROM bar) as foo'])

开发者ID:andialbrecht，项目名称:sqlparse，代码行数:28，代码来源:test_regressions.py

示例2: _printSql

	def _printSql(self, q):
		if self.print_sqls:
			self._printLine()
			if HAS_SQLPARSE:
				print sqlparse.format(q, reindent=True, keyword_case='upper')
			else:
				print q

开发者ID:CloudServer，项目名称:postgresql-perf-tools，代码行数:7，代码来源:pg-info.py

示例3: test_issue40

 def test_issue40(self):
     # make sure identifier lists in subselects are grouped
     p = sqlparse.parse(('SELECT id, name FROM '
                         '(SELECT id, name FROM bar) as foo'))[0]
     self.assertEqual(len(p.tokens), 7)
     self.assertEqual(p.tokens[2].__class__, sql.IdentifierList)
     self.assertEqual(p.tokens[-1].__class__, sql.Identifier)
     self.assertEqual(p.tokens[-1].get_name(), u'foo')
     sp = p.tokens[-1].tokens[0]
     self.assertEqual(sp.tokens[3].__class__, sql.IdentifierList)
     # make sure that formatting works as expected
     self.ndiffAssertEqual(
         sqlparse.format(('SELECT id, name FROM '
                          '(SELECT id, name FROM bar)'),
                         reindent=True),
         ('SELECT id,\n'
          '       name\n'
          'FROM\n'
          '  (SELECT id,\n'
          '          name\n'
          '   FROM bar)'))
     self.ndiffAssertEqual(
         sqlparse.format(('SELECT id, name FROM '
                          '(SELECT id, name FROM bar) as foo'),
                         reindent=True),
         ('SELECT id,\n'
          '       name\n'
          'FROM\n'
          '  (SELECT id,\n'
          '          name\n'
          '   FROM bar) as foo'))

开发者ID:ChimmyTee，项目名称:oh-mainline，代码行数:31，代码来源:test_regressions.py

示例4: do_query_tag_report

def do_query_tag_report(query_tag, i, days, start, end, no_show_sql):
    first = True
    print('\nSlow report for tag #{} {}\n'.format(i+1,query_tag))
    for file in gfiles(days, start, end):
        with open(file, 'r') as f:
            date, time = get_report_date(f)
            qdata, sql = head_match(f, query_tag, 70)
            hdata = top_head(f, 70)
            if first:
                first = False
                if not no_show_sql:
                    try:
                        print(sqlparse.format('\n'.join(sql), reindent=True, keyword_case='upper'))
                    except IndexError, e:
                        print(sqlparse.format('\n'.join(sql), keyword_case='upper'))
                    print('')

                print('{0:10} {1:8}  {2:>10}   {3:>9}   {4:>9}   {5:>12}   {6:>11s}  '
                      '{7:>6s}  {8:>12s} {9:>11s} {10:11s}'.format(
                            'Date',
                            'Time',
                            'Count',
                            'Exec_Time',
                            'Lock_Time',
                            'QAve_Resp',
                            '%Qexec_time',  #6
                            '%Count',
                            'Tot_Q_Count',
                            'Tot_time',
                            'Tot_ave_resp'
                            ))
        format_query_tag(date, time, qdata, hdata)

开发者ID:markgruen，项目名称:query-digest-historical-reporter，代码行数:32，代码来源:report_slow.py

示例5: new_linelist_from_gfall

def new_linelist_from_gfall(new_dbname, select_atom=None):
    print "Reading lines from Kurucz gfall"
    conn = sqlite3.connect(new_dbname)
    conn.create_function('pow', 2, math.pow)
    conn.create_function('convert_air2vacuum', 1, convert_air2vacuum)
    curs = conn.cursor()
    curs.execute(sql_stmts.linelist_create_stmt)
    if select_atom is None:
        elem_select_stmt = ""
    else:
        elem_select_stmt = " and elem in (%s)" % (','.join(map(str, select_atom)),)

    insert_fromgfall_stmt = sql_stmts.linelist_insert_stmt + sql_stmts.linelist_select_stmt % {'hc':hc, 'where_stmt':elem_select_stmt}
    
    if sqlparse_available:
        print sqlparse.format(insert_fromgfall_stmt, reindent=True)
    else:
        print insert_fromgfall_stmt
    
    curs.execute(insert_fromgfall_stmt)
    
    conn.commit()
    print "%d lines in database" % (conn.execute('select count(atom) from lines').fetchone()[0])
    print "updating oscillator strengths"
    
    conn.execute(update_oscillator_stmt)
    conn.commit()
    return conn

开发者ID:tardis-sn，项目名称:tardisatomic，代码行数:28，代码来源:construct_atom_db.py

示例6: test_identifiercase

 def test_identifiercase(self):
     sql = 'select * from bar; -- select foo\n'
     res = sqlparse.format(sql, identifier_case='upper')
     assert res == 'select * from BAR; -- select foo\n'
     res = sqlparse.format(sql, identifier_case='capitalize')
     assert res == 'select * from Bar; -- select foo\n'
     res = sqlparse.format(sql.upper(), identifier_case='lower')
     assert res == 'SELECT * FROM bar; -- SELECT FOO\n'

开发者ID:pjdelport，项目名称:sqlparse，代码行数:8，代码来源:test_format.py

示例7: test_php

 def test_php(self):
     sql = 'select * from foo;'
     f = lambda sql: sqlparse.format(sql, output_format='php')
     self.ndiffAssertEqual(f(sql), '$sql = "select * from foo;";')
     f = lambda sql: sqlparse.format(sql, output_format='php',
                                     reindent=True)
     self.ndiffAssertEqual(f(sql), ('$sql  = "select * ";\n'
                                    '$sql .= "from foo;";'))

开发者ID:Greg-J，项目名称:sqlparse，代码行数:8，代码来源:test_format.py

示例8: test_python

 def test_python(self):
     sql = 'select * from foo;'
     f = lambda sql: sqlparse.format(sql, output_format='python')
     self.ndiffAssertEqual(f(sql), "sql = 'select * from foo;'")
     f = lambda sql: sqlparse.format(sql, output_format='python',
                                     reindent=True)
     self.ndiffAssertEqual(f(sql), ("sql = ('select * '\n"
                                    "       'from foo;')"))

开发者ID:Greg-J，项目名称:sqlparse，代码行数:8，代码来源:test_format.py

示例9: test_keywordcase

 def test_keywordcase(self):
     sql = 'select * from bar; -- select foo\n'
     res = sqlparse.format(sql, keyword_case='upper')
     assert res == 'SELECT * FROM bar; -- select foo\n'
     res = sqlparse.format(sql, keyword_case='capitalize')
     assert res == 'Select * From bar; -- select foo\n'
     res = sqlparse.format(sql.upper(), keyword_case='lower')
     assert res == 'select * from BAR; -- SELECT FOO\n'

开发者ID:pjdelport，项目名称:sqlparse，代码行数:8，代码来源:test_format.py

示例10: print_sql

def print_sql(show_queries=True):
    print "Total Run Time: %s"%(datetime.now()-start_time)
    print "Total Postgres Time: %s"%sum([float(query['time']) for query in con.queries[query_count:]])
    print "Queries: %s"%(len(con.queries)-query_count)

    if show_queries:
        for query in con.queries[query_count:]:
            print "\nPostgres Time: %s"%query['time']
            print sqlparse.format(query['sql'], reindent=True, keyword_case='upper')

开发者ID:hobson，项目名称:Efficient-Django-QuerySet-Use，代码行数:9，代码来源:__init__.py

示例11: test_python

 def test_python(self):
     sql = 'select * from foo;'
     f = lambda sql: sqlparse.format(sql, output_format='python')
     assert f(sql) == "sql = 'select * from foo;'"
     f = lambda sql: sqlparse.format(sql, output_format='python',
                                     reindent=True)
     assert f(sql) == '\n'.join([
         "sql = ('select * '",
         "       'from foo;')"])

开发者ID:pjdelport，项目名称:sqlparse，代码行数:9，代码来源:test_format.py

示例12: test_php

 def test_php(self):
     sql = 'select * from foo;'
     f = lambda sql: sqlparse.format(sql, output_format='php')
     assert f(sql) == '$sql = "select * from foo;";'
     f = lambda sql: sqlparse.format(sql, output_format='php',
                                     reindent=True)
     assert f(sql) == '\n'.join([
         '$sql  = "select * ";',
         '$sql .= "from foo;";'])

开发者ID:pjdelport，项目名称:sqlparse，代码行数:9，代码来源:test_format.py

示例13: print_sql

def print_sql(qs):
    q = qs.query.as_sql()
    statement = q[0] % q[1]
    try:
        import sqlparse
        print sqlparse.format(statement, reindent=True, keyword_case='upper')
    except ImportError:
        import warnings
        warnings.warn("sqlparse not installed")
        print statement

开发者ID:peterbe，项目名称:kl，代码行数:10，代码来源:utils.py

示例14: test_strip_comments_single

 def test_strip_comments_single(self):
     sql = 'select *-- statement starts here\nfrom foo'
     res = sqlparse.format(sql, strip_comments=True)
     assert res == 'select * from foo'
     sql = 'select * -- statement starts here\nfrom foo'
     res = sqlparse.format(sql, strip_comments=True)
     assert res == 'select * from foo'
     sql = 'select-- foo\nfrom -- bar\nwhere'
     res = sqlparse.format(sql, strip_comments=True)
     assert res == 'select from where'

开发者ID:pjdelport，项目名称:sqlparse，代码行数:10，代码来源:test_format.py

示例15: test_keywordcase

 def test_keywordcase(self):
     sql = 'select * from bar; -- select foo\n'
     res = sqlparse.format(sql, keyword_case='upper')
     self.ndiffAssertEqual(res, 'SELECT * FROM bar; -- select foo\n')
     res = sqlparse.format(sql, keyword_case='capitalize')
     self.ndiffAssertEqual(res, 'Select * From bar; -- select foo\n')
     res = sqlparse.format(sql.upper(), keyword_case='lower')
     self.ndiffAssertEqual(res, 'select * from BAR; -- SELECT FOO\n')
     self.assertRaises(SQLParseError, sqlparse.format, sql,
                       keyword_case='foo')

开发者ID:Greg-J，项目名称:sqlparse，代码行数:10，代码来源:test_format.py

示例16: execute

 def execute(self, sql, params=()):
     try:
         return self.cursor.execute(sql, params)
     finally:
         raw_sql = self.db.ops.last_executed_query(self.cursor, sql, params)
         if sqlparse:
             print sqlparse.format(raw_sql, reindent=True)
         else:
             print raw_sql
         print

开发者ID:rickeyski，项目名称:django-extensions，代码行数:10，代码来源:shell_plus.py

示例17: test_strip_comments_single

 def test_strip_comments_single(self):
     sql = 'select *-- statement starts here\nfrom foo'
     res = sqlparse.format(sql, strip_comments=True)
     self.ndiffAssertEqual(res, 'select * from foo')
     sql = 'select * -- statement starts here\nfrom foo'
     res = sqlparse.format(sql, strip_comments=True)
     self.ndiffAssertEqual(res, 'select * from foo')
     sql = 'select-- foo\nfrom -- bar\nwhere'
     res = sqlparse.format(sql, strip_comments=True)
     self.ndiffAssertEqual(res, 'select from where')
     self.assertRaises(SQLParseError, sqlparse.format, sql,
                       strip_comments=None)

开发者ID:Greg-J，项目名称:sqlparse，代码行数:12，代码来源:test_format.py

示例18: test_identifiercase

 def test_identifiercase(self):
     sql = 'select * from bar; -- select foo\n'
     res = sqlparse.format(sql, identifier_case='upper')
     self.ndiffAssertEqual(res, 'select * from BAR; -- select foo\n')
     res = sqlparse.format(sql, identifier_case='capitalize')
     self.ndiffAssertEqual(res, 'select * from Bar; -- select foo\n')
     res = sqlparse.format(sql.upper(), identifier_case='lower')
     self.ndiffAssertEqual(res, 'SELECT * FROM bar; -- SELECT FOO\n')
     self.assertRaises(SQLParseError, sqlparse.format, sql,
                       identifier_case='foo')
     sql = 'select * from "foo"."bar"'
     res = sqlparse.format(sql, identifier_case="upper")
     self.ndiffAssertEqual(res, 'select * from "foo"."bar"')

开发者ID:Greg-J，项目名称:sqlparse，代码行数:13，代码来源:test_format.py

示例19: test_strip_comments_multi

 def test_strip_comments_multi(self):
     sql = '/* sql starts here */\nselect'
     res = sqlparse.format(sql, strip_comments=True)
     self.ndiffAssertEqual(res, 'select')
     sql = '/* sql starts here */ select'
     res = sqlparse.format(sql, strip_comments=True)
     self.ndiffAssertEqual(res, 'select')
     sql = '/*\n * sql starts here\n */\nselect'
     res = sqlparse.format(sql, strip_comments=True)
     self.ndiffAssertEqual(res, 'select')
     sql = 'select (/* sql starts here */ select 2)'
     res = sqlparse.format(sql, strip_comments=True)
     self.ndiffAssertEqual(res, 'select (select 2)')

开发者ID:Greg-J，项目名称:sqlparse，代码行数:13，代码来源:test_format.py

示例20: execute

 def execute(self, sql, params=()):
     starttime = datetime.now()
     try:
         return self.cursor.execute(sql, params)
     finally:
         raw_sql = self.db.ops.last_executed_query(self.cursor, sql, params)
         execution_time = datetime.now() - starttime
         if sqlparse:
             print sqlparse.format(raw_sql, reindent=True)
         else:
             print raw_sql
         print
         print 'Execution time: %fs' % execution_time.total_seconds()
         print

开发者ID:AliLozano，项目名称:django-extensions，代码行数:14，代码来源:shell_plus.py

注：本文中的sqlparse.format函数示例由纯净天空整理自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 sqlparse.parse函数代码示例发布时间：2022-05-27

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

Python util.grid_equal函数代码示例

1 Python 入门教程

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

阅读：13806|2022-01-22

2 Python wikiutil.getFrontPage函数代码示例

Python wikiutil.getFrontPage函数代码示例

阅读：10192|2022-05-24

3 Python 简介

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

阅读：4089|2022-01-22

4 Python tests.group函数代码示例

Python tests.group函数代码示例

阅读：4043|2022-05-27

5 Python util.check_if_user_has_permission

Python util.check_if_user_has_permission函数代码示例

阅读：3844|2022-05-27

6 Python 操练实例98

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

阅读：3510|2022-01-22

7 Python 环境搭建

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

阅读：3030|2022-01-22

8 Python output.darkgreen函数代码示例

Python output.darkgreen函数代码示例

阅读：2653|2022-05-25

9 Python 基础语法

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

阅读：2648|2022-01-22

10 Python 中文编码

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

阅读：2302|2022-01-22

客服电话

电子邮件

Python sqlparse.format函数代码示例

示例1: test_issue40

示例2: _printSql

示例3: test_issue40

示例4: do_query_tag_report

示例5: new_linelist_from_gfall

示例6: test_identifiercase

示例7: test_php

示例8: test_python

示例9: test_keywordcase

示例10: print_sql

示例11: test_python

示例12: test_php

示例13: print_sql

示例14: test_strip_comments_single

示例15: test_keywordcase

示例16: execute

示例17: test_strip_comments_single

示例18: test_identifiercase

示例19: test_strip_comments_multi

示例20: execute

请发表评论

全部评论

上一篇：

下一篇：

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