Python pyodbc.dialect函数代码示例

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

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

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

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

示例1: test_pyodbc_disconnect

    def test_pyodbc_disconnect(self):
        dialect = pyodbc.dialect()

        class MockDBAPIError(Exception):
            pass

        class MockProgrammingError(MockDBAPIError):
            pass

        dialect.dbapi = Mock(
            Error=MockDBAPIError, ProgrammingError=MockProgrammingError)

        for error in [
            MockDBAPIError("[%s] some pyodbc message" % code)
            for code in [
                '08S01', '01002', '08003', '08007',
                '08S02', '08001', 'HYT00', 'HY010']
        ] + [
            MockProgrammingError(message)
            for message in [
                "(some pyodbc stuff) The cursor's connection has been closed.",
                "(some pyodbc stuff) Attempt to use a closed connection."
            ]
        ]:
            eq_(dialect.is_disconnect(error, None, None), True)

        eq_(dialect.is_disconnect(
            MockProgrammingError("not an error"), None, None), False)

开发者ID:nakagami，项目名称:sqlalchemy，代码行数:28，代码来源:test_engine.py

示例2: test_pyodbc_host_no_driver

    def test_pyodbc_host_no_driver(self):
        dialect = pyodbc.dialect()
        u = url.make_url("mssql://username:[email protected]/database")

        def go():
            return dialect.create_connect_args(u)

        connection = assert_warnings(
            go,
            [
                "No driver name specified; this is expected by "
                "PyODBC when using DSN-less connections"
            ],
        )

        eq_(
            [
                [
                    "Server=hostspec;Database=database;UI"
                    "D=username;PWD=password"
                ],
                {},
            ],
            connection,
        )

开发者ID:monetate，项目名称:sqlalchemy，代码行数:25，代码来源:test_engine.py

示例3: test_pyodbc_odbc_connect_with_dsn

 def test_pyodbc_odbc_connect_with_dsn(self):
     dialect = pyodbc.dialect()
     u = url.make_url(
         "mssql:///?odbc_connect=dsn%3Dmydsn%3BDatabase" "%3Ddatabase%3BUID%3Dusername%3BPWD%3Dpassword"
     )
     connection = dialect.create_connect_args(u)
     eq_([["dsn=mydsn;Database=database;UID=username;PWD=password"], {}], connection)

开发者ID:balagopalraj，项目名称:clearlinux，代码行数:7，代码来源:test_engine.py

示例4: test_pyodbc_connect_dsn_extra

 def test_pyodbc_connect_dsn_extra(self):
     dialect = pyodbc.dialect()
     u = url.make_url("mssql://username:[email protected]/?LANGUAGE=us_" "english&foo=bar")
     connection = dialect.create_connect_args(u)
     dsn_string = connection[0][0]
     assert ";LANGUAGE=us_english" in dsn_string
     assert ";foo=bar" in dsn_string

开发者ID:balagopalraj，项目名称:clearlinux，代码行数:7，代码来源:test_engine.py

示例5: test_pyodbc_connect_comma_port

 def test_pyodbc_connect_comma_port(self):
     dialect = pyodbc.dialect()
     u = \
         url.make_url('mssql://username:[email protected]:12345/data'
                      'base')
     connection = dialect.create_connect_args(u)
     eq_([['DRIVER={SQL Server};Server=hostspec,12345;Database=datab'
         'ase;UID=username;PWD=password'], {}], connection)

开发者ID:23andMe，项目名称:sqlalchemy，代码行数:8，代码来源:test_engine.py

示例6: test_pyodbc_hostname

 def test_pyodbc_hostname(self):
     dialect = pyodbc.dialect()
     u = url.make_url(
         'mssql://username:[email protected]/database?driver=SQL+Server'
     )
     connection = dialect.create_connect_args(u)
     eq_([['DRIVER={SQL Server};Server=hostspec;Database=database;UI'
         'D=username;PWD=password'], {}], connection)

开发者ID:anti-social，项目名称:sqlalchemy，代码行数:8，代码来源:test_engine.py

示例7: test_pyodbc_connect_config_port

 def test_pyodbc_connect_config_port(self):
     dialect = pyodbc.dialect()
     u = \
         url.make_url('mssql://username:[email protected]/database?p'
                      'ort=12345')
     connection = dialect.create_connect_args(u)
     eq_([['DRIVER={SQL Server};Server=hostspec;Database=database;UI'
         'D=username;PWD=password;port=12345'], {}], connection)

开发者ID:23andMe，项目名称:sqlalchemy，代码行数:8，代码来源:test_engine.py

示例8: test_pyodbc_connect_comma_port

 def test_pyodbc_connect_comma_port(self):
     dialect = pyodbc.dialect()
     u = url.make_url("mssql://username:[email protected]:12345/data" "base")
     connection = dialect.create_connect_args(u)
     eq_(
         [["DRIVER={SQL Server};Server=hostspec,12345;Database=datab" "ase;UID=username;PWD=password"], {}],
         connection,
     )

开发者ID:balagopalraj，项目名称:clearlinux，代码行数:8，代码来源:test_engine.py

示例9: test_pyodbc_odbc_connect

 def test_pyodbc_odbc_connect(self):
     dialect = pyodbc.dialect()
     u = \
         url.make_url('mssql:///?odbc_connect=DRIVER%3D%7BSQL+Server'
                      '%7D%3BServer%3Dhostspec%3BDatabase%3Ddatabase'
                      '%3BUID%3Dusername%3BPWD%3Dpassword')
     connection = dialect.create_connect_args(u)
     eq_([['DRIVER={SQL Server};Server=hostspec;Database=database;UI'
         'D=username;PWD=password'], {}], connection)

开发者ID:23andMe，项目名称:sqlalchemy，代码行数:9，代码来源:test_engine.py

示例10: test_pyodbc_odbc_connect_ignores_other_values

 def test_pyodbc_odbc_connect_ignores_other_values(self):
     dialect = pyodbc.dialect()
     u = \
         url.make_url('mssql://userdiff:[email protected]/dbdiff?od'
                      'bc_connect=DRIVER%3D%7BSQL+Server%7D%3BServer'
                      '%3Dhostspec%3BDatabase%3Ddatabase%3BUID%3Duse'
                      'rname%3BPWD%3Dpassword')
     connection = dialect.create_connect_args(u)
     eq_([['DRIVER={SQL Server};Server=hostspec;Database=database;UI'
         'D=username;PWD=password'], {}], connection)

开发者ID:23andMe，项目名称:sqlalchemy，代码行数:10，代码来源:test_engine.py

示例11: test_pyodbc_extra_connect

 def test_pyodbc_extra_connect(self):
     dialect = pyodbc.dialect()
     u = \
         url.make_url('mssql://username:[email protected]/database?L'
                      'ANGUAGE=us_english&foo=bar')
     connection = dialect.create_connect_args(u)
     eq_(connection[1], {})
     eq_(connection[0][0]
         in ('DRIVER={SQL Server};Server=hostspec;Database=database;'
         'UID=username;PWD=password;foo=bar;LANGUAGE=us_english',
         'DRIVER={SQL Server};Server=hostspec;Database=database;UID='
         'username;PWD=password;LANGUAGE=us_english;foo=bar'), True)

开发者ID:23andMe，项目名称:sqlalchemy，代码行数:12，代码来源:test_engine.py

示例12: test_pyodbc_extra_connect

 def test_pyodbc_extra_connect(self):
     dialect = pyodbc.dialect()
     u = url.make_url("mssql://username:[email protected]/database?L" "ANGUAGE=us_english&foo=bar")
     connection = dialect.create_connect_args(u)
     eq_(connection[1], {})
     eq_(
         connection[0][0]
         in (
             "DRIVER={SQL Server};Server=hostspec;Database=database;"
             "UID=username;PWD=password;foo=bar;LANGUAGE=us_english",
             "DRIVER={SQL Server};Server=hostspec;Database=database;UID="
             "username;PWD=password;LANGUAGE=us_english;foo=bar",
         ),
         True,
     )

开发者ID:balagopalraj，项目名称:clearlinux，代码行数:15，代码来源:test_engine.py

示例13: test_pyodbc_connect_config_port

 def test_pyodbc_connect_config_port(self):
     dialect = pyodbc.dialect()
     u = url.make_url(
         "mssql://username:[email protected]/database?p"
         "ort=12345&driver=SQL+Server"
     )
     connection = dialect.create_connect_args(u)
     eq_(
         [
             [
                 "DRIVER={SQL Server};Server=hostspec;Database=database;UI"
                 "D=username;PWD=password;port=12345"
             ],
             {},
         ],
         connection,
     )

开发者ID:monetate，项目名称:sqlalchemy，代码行数:17，代码来源:test_engine.py

示例14: test_pyodbc_odbc_connect

 def test_pyodbc_odbc_connect(self):
     dialect = pyodbc.dialect()
     u = url.make_url(
         "mssql:///?odbc_connect=DRIVER%3D%7BSQL+Server"
         "%7D%3BServer%3Dhostspec%3BDatabase%3Ddatabase"
         "%3BUID%3Dusername%3BPWD%3Dpassword"
     )
     connection = dialect.create_connect_args(u)
     eq_(
         [
             [
                 "DRIVER={SQL Server};Server=hostspec;Database=database;UI"
                 "D=username;PWD=password"
             ],
             {},
         ],
         connection,
     )

开发者ID:monetate，项目名称:sqlalchemy，代码行数:18，代码来源:test_engine.py

示例15: test_pyodbc_odbc_connect_ignores_other_values

 def test_pyodbc_odbc_connect_ignores_other_values(self):
     dialect = pyodbc.dialect()
     u = url.make_url(
         "mssql://userdiff:[email protected]/dbdiff?od"
         "bc_connect=DRIVER%3D%7BSQL+Server%7D%3BServer"
         "%3Dhostspec%3BDatabase%3Ddatabase%3BUID%3Duse"
         "rname%3BPWD%3Dpassword"
     )
     connection = dialect.create_connect_args(u)
     eq_(
         [
             [
                 "DRIVER={SQL Server};Server=hostspec;Database=database;UI"
                 "D=username;PWD=password"
             ],
             {},
         ],
         connection,
     )

开发者ID:monetate，项目名称:sqlalchemy，代码行数:19，代码来源:test_engine.py

示例16: test_pyodbc_token_injection

    def test_pyodbc_token_injection(self):
        token1 = "someuser%3BPORT%3D50001"
        token2 = "somepw%3BPORT%3D50001"
        token3 = "somehost%3BPORT%3D50001"
        token4 = "somedb%3BPORT%3D50001"

        u = url.make_url(
            'mssql+pyodbc://%s:%[email protected]%s/%s?driver=foob' % (
                token1, token2, token3, token4
            )
        )
        dialect = pyodbc.dialect()
        connection = dialect.create_connect_args(u)
        eq_(
            [[
                "DRIVER={foob};Server=somehost%3BPORT%3D50001;"
                "Database=somedb%3BPORT%3D50001;UID='someuser;PORT=50001';"
                "PWD='somepw;PORT=50001'"], {}],
            connection
        )

开发者ID:anti-social，项目名称:sqlalchemy，代码行数:20，代码来源:test_engine.py

示例17: test_pyodbc_connect_dsn_non_trusted

 def test_pyodbc_connect_dsn_non_trusted(self):
     dialect = pyodbc.dialect()
     u = url.make_url('mssql://username:[email protected]')
     connection = dialect.create_connect_args(u)
     eq_([['dsn=mydsn;UID=username;PWD=password'], {}], connection)

开发者ID:23andMe，项目名称:sqlalchemy，代码行数:5，代码来源:test_engine.py

示例18: test_pyodbc_connect_old_style_dsn_trusted

 def test_pyodbc_connect_old_style_dsn_trusted(self):
     dialect = pyodbc.dialect()
     u = url.make_url('mssql:///?dsn=mydsn')
     connection = dialect.create_connect_args(u)
     eq_([['dsn=mydsn;Trusted_Connection=Yes'], {}], connection)

开发者ID:23andMe，项目名称:sqlalchemy，代码行数:5，代码来源:test_engine.py

示例19: test_pyodbc_connect_dsn_trusted

 def test_pyodbc_connect_dsn_trusted(self):
     dialect = pyodbc.dialect()
     u = url.make_url("mssql://mydsn")
     connection = dialect.create_connect_args(u)
     eq_([["dsn=mydsn;Trusted_Connection=Yes"], {}], connection)

开发者ID:monetate，项目名称:sqlalchemy，代码行数:5，代码来源:test_engine.py

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

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

Python util.grid_equal函数代码示例

1 Python 入门教程

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

阅读：13806|2022-01-22

2 Python wikiutil.getFrontPage函数代码示例

Python wikiutil.getFrontPage函数代码示例

阅读：10193|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 等语言有许多相似之处。但是，也

阅读：2649|2022-01-22

10 Python 中文编码

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

阅读：2302|2022-01-22

客服电话

电子邮件

Python pyodbc.dialect函数代码示例

示例1: test_pyodbc_disconnect

示例2: test_pyodbc_host_no_driver

示例3: test_pyodbc_odbc_connect_with_dsn

示例4: test_pyodbc_connect_dsn_extra

示例5: test_pyodbc_connect_comma_port

示例6: test_pyodbc_hostname

示例7: test_pyodbc_connect_config_port

示例8: test_pyodbc_connect_comma_port

示例9: test_pyodbc_odbc_connect

示例10: test_pyodbc_odbc_connect_ignores_other_values

示例11: test_pyodbc_extra_connect

示例12: test_pyodbc_extra_connect

示例13: test_pyodbc_connect_config_port

示例14: test_pyodbc_odbc_connect

示例15: test_pyodbc_odbc_connect_ignores_other_values

示例16: test_pyodbc_token_injection

示例17: test_pyodbc_connect_dsn_non_trusted

示例18: test_pyodbc_connect_old_style_dsn_trusted

示例19: test_pyodbc_connect_dsn_trusted

请发表评论

全部评论

上一篇：

下一篇：

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