本文整理汇总了Python中sqlalchemy.dialects.mysql.base.dialect函数的典型用法代码示例。如果您正苦于以下问题:Python dialect函数的具体用法?Python dialect怎么用?Python dialect使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了dialect函数的11个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的Python代码示例。
示例1: test_varchar_raise
def test_varchar_raise(self):
for type_ in (
String,
VARCHAR,
String(),
VARCHAR(),
NVARCHAR(),
Unicode,
Unicode(),
):
type_ = sqltypes.to_instance(type_)
assert_raises_message(
exc.CompileError,
"VARCHAR requires a length on dialect mysql",
type_.compile,
dialect=mysql.dialect()
)
t1 = Table('sometable', MetaData(),
Column('somecolumn', type_)
)
assert_raises_message(
exc.CompileError,
r"\(in table 'sometable', column 'somecolumn'\)\: "
r"(?:N)?VARCHAR requires a length on dialect mysql",
schema.CreateTable(t1).compile,
dialect=mysql.dialect()
)
开发者ID:23andMe,项目名称:sqlalchemy,代码行数:28,代码来源:test_compiler.py
示例2: test_cast_grouped_expression_pre_4
def test_cast_grouped_expression_pre_4(self):
dialect = mysql.dialect()
dialect.server_version_info = (3, 2, 3)
self.assert_compile(
cast(sql.column('x') + sql.column('y'), Integer),
"(x + y)",
dialect=dialect
)
开发者ID:23andMe,项目名称:sqlalchemy,代码行数:8,代码来源:test_compiler.py
示例3: test_cast_grouped_expression_pre_4
def test_cast_grouped_expression_pre_4(self):
dialect = mysql.dialect()
dialect.server_version_info = (3, 2, 3)
with expect_warnings("Current MySQL version does not support CAST;"):
self.assert_compile(
cast(sql.column('x') + sql.column('y'), Integer),
"(x + y)",
dialect=dialect
)
开发者ID:robin900,项目名称:sqlalchemy,代码行数:9,代码来源:test_compiler.py
示例4: test_no_cast_pre_4
def test_no_cast_pre_4(self):
self.assert_compile(
cast(Column("foo", Integer), String), "CAST(foo AS CHAR)"
)
dialect = mysql.dialect()
dialect.server_version_info = (3, 2, 3)
with expect_warnings("Current MySQL version does not support CAST;"):
self.assert_compile(
cast(Column("foo", Integer), String), "foo", dialect=dialect
)
开发者ID:monetate,项目名称:sqlalchemy,代码行数:10,代码来源:test_compiler.py
示例5: test_no_cast_pre_4
def test_no_cast_pre_4(self):
self.assert_compile(
cast(Column('foo', Integer), String),
"CAST(foo AS CHAR)",
)
dialect = mysql.dialect()
dialect.server_version_info = (3, 2, 3)
self.assert_compile(
cast(Column('foo', Integer), String),
"foo",
dialect=dialect
)
开发者ID:23andMe,项目名称:sqlalchemy,代码行数:12,代码来源:test_compiler.py
示例6: test_match_kw_raises
def test_match_kw_raises(self):
m = MetaData()
Table("t1", m, Column("id", Integer, primary_key=True))
t2 = Table("t2", m, Column("id", Integer, ForeignKey("t1.id", match="XYZ"), primary_key=True))
assert_raises_message(
exc.CompileError,
"MySQL ignores the 'MATCH' keyword while at the same time causes "
"ON UPDATE/ON DELETE clauses to be ignored.",
schema.CreateTable(t2).compile,
dialect=mysql.dialect(),
)
开发者ID:lelit,项目名称:sqlalchemy,代码行数:12,代码来源:test_compiler.py
示例7: test_backslash_escaping
def test_backslash_escaping(self):
self.assert_compile(
sql.column('foo').like('bar', escape='\\'),
"foo LIKE %s ESCAPE '\\\\'"
)
dialect = mysql.dialect()
dialect._backslash_escapes=False
self.assert_compile(
sql.column('foo').like('bar', escape='\\'),
"foo LIKE %s ESCAPE '\\'",
dialect=dialect
)
开发者ID:23andMe,项目名称:sqlalchemy,代码行数:13,代码来源:test_compiler.py
示例8: test_backslash_escaping
def test_backslash_escaping(self):
self.assert_compile(
sql.column("foo").like("bar", escape="\\"),
"foo LIKE %s ESCAPE '\\\\'",
)
dialect = mysql.dialect()
dialect._backslash_escapes = False
self.assert_compile(
sql.column("foo").like("bar", escape="\\"),
"foo LIKE %s ESCAPE '\\'",
dialect=dialect,
)
开发者ID:monetate,项目名称:sqlalchemy,代码行数:13,代码来源:test_compiler.py
示例9: test_drop_constraint_mysql
def test_drop_constraint_mysql(self):
m = MetaData()
table_name = "testtbl"
constraint_name = "constraint"
constraint = CheckConstraint("data IS NOT NULL", name=constraint_name)
tbl = Table(table_name, m, Column("data", String(255)), constraint)
dialect = mysql.dialect()
self.assert_compile(
schema.DropConstraint(constraint),
"ALTER TABLE %s DROP CHECK `%s`"
% (table_name, constraint_name),
dialect=dialect
)
开发者ID:monetate,项目名称:sqlalchemy,代码行数:13,代码来源:test_compiler.py
示例10: test_drop_constraint_mariadb
def test_drop_constraint_mariadb(self):
m = MetaData()
table_name = "testtbl"
constraint_name = "constraint"
constraint = CheckConstraint("data IS NOT NULL", name=constraint_name)
tbl = Table(table_name, m, Column("data", String(255)), constraint)
dialect = mysql.dialect()
dialect.server_version_info = (10, 1, 1, "MariaDB")
self.assert_compile(
schema.DropConstraint(constraint),
"ALTER TABLE %s DROP CONSTRAINT `%s`"
% (table_name, constraint_name),
dialect=dialect
)
开发者ID:monetate,项目名称:sqlalchemy,代码行数:14,代码来源:test_compiler.py
示例11: setup
def setup(self):
dialect = mysql.dialect()
self.parser = mysql.MySQLTableDefinitionParser(dialect, dialect.identifier_preparer)
开发者ID:DeepakAlevoor,项目名称:sqlalchemy,代码行数:3,代码来源:test_reflection.py
注:本文中的sqlalchemy.dialects.mysql.base.dialect函数示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论