diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2013-06-08 14:49:56 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2013-06-08 14:49:56 -0400 |
| commit | 5d4bb7c2133408ca976dc235be7f6abbfde11fd9 (patch) | |
| tree | e83103ffb0bddcfc6a8d3c9c5a9e1ddf6db7ade7 /test/dialect/test_mysql.py | |
| parent | a80bb5393484ed2579266c8780ddea1507515e37 (diff) | |
| download | sqlalchemy-5d4bb7c2133408ca976dc235be7f6abbfde11fd9.tar.gz | |
most of these dialect=mysql.dialect() calls are redundant
Diffstat (limited to 'test/dialect/test_mysql.py')
| -rw-r--r-- | test/dialect/test_mysql.py | 36 |
1 files changed, 13 insertions, 23 deletions
diff --git a/test/dialect/test_mysql.py b/test/dialect/test_mysql.py index 18a37076c..33e2916f4 100644 --- a/test/dialect/test_mysql.py +++ b/test/dialect/test_mysql.py @@ -34,8 +34,7 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): idx = Index('test_idx1', tbl.c.data) self.assert_compile(schema.CreateIndex(idx), - 'CREATE INDEX test_idx1 ON testtbl (data)', - dialect=mysql.dialect()) + 'CREATE INDEX test_idx1 ON testtbl (data)') def test_create_index_with_length(self): m = MetaData() @@ -44,11 +43,9 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): idx2 = Index('test_idx2', tbl.c.data, mysql_length=5) self.assert_compile(schema.CreateIndex(idx1), - 'CREATE INDEX test_idx1 ON testtbl (data(10))', - dialect=mysql.dialect()) + 'CREATE INDEX test_idx1 ON testtbl (data(10))') self.assert_compile(schema.CreateIndex(idx2), - 'CREATE INDEX test_idx2 ON testtbl (data(5))', - dialect=mysql.dialect()) + 'CREATE INDEX test_idx2 ON testtbl (data(5))') def test_create_composite_index_with_length(self): m = MetaData() @@ -65,18 +62,15 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): self.assert_compile( schema.CreateIndex(idx1), - 'CREATE INDEX test_idx1 ON testtbl (a(10), b(20))', - dialect=mysql.dialect() + 'CREATE INDEX test_idx1 ON testtbl (a(10), b(20))' ) self.assert_compile( schema.CreateIndex(idx2), - 'CREATE INDEX test_idx2 ON testtbl (a(15), b)', - dialect=mysql.dialect() + 'CREATE INDEX test_idx2 ON testtbl (a(15), b)' ) self.assert_compile( schema.CreateIndex(idx3), - 'CREATE INDEX test_idx3 ON testtbl (a(30), b(30))', - dialect=mysql.dialect() + 'CREATE INDEX test_idx3 ON testtbl (a(30), b(30))' ) def test_create_index_with_using(self): @@ -86,11 +80,9 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): idx2 = Index('test_idx2', tbl.c.data, mysql_using='hash') self.assert_compile(schema.CreateIndex(idx1), - 'CREATE INDEX test_idx1 ON testtbl (data) USING btree', - dialect=mysql.dialect()) + 'CREATE INDEX test_idx1 ON testtbl (data) USING btree') self.assert_compile(schema.CreateIndex(idx2), - 'CREATE INDEX test_idx2 ON testtbl (data) USING hash', - dialect=mysql.dialect()) + 'CREATE INDEX test_idx2 ON testtbl (data) USING hash') def test_create_pk_plain(self): m = MetaData() @@ -98,8 +90,7 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): PrimaryKeyConstraint('data')) self.assert_compile(schema.CreateTable(tbl), - "CREATE TABLE testtbl (data VARCHAR(255), PRIMARY KEY (data))", - dialect=mysql.dialect()) + "CREATE TABLE testtbl (data VARCHAR(255), PRIMARY KEY (data))") def test_create_pk_with_using(self): m = MetaData() @@ -108,8 +99,7 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): self.assert_compile(schema.CreateTable(tbl), "CREATE TABLE testtbl (data VARCHAR(255), " - "PRIMARY KEY (data) USING btree)", - dialect=mysql.dialect()) + "PRIMARY KEY (data) USING btree)") def test_skip_deferrable_kw(self): m = MetaData() @@ -1180,7 +1170,8 @@ class SQLTest(fixtures.TestBase, AssertsCompiledSQL): exc.CompileError, "VARCHAR requires a length on dialect mysql", type_.compile, - dialect=mysql.dialect()) + dialect=mysql.dialect() + ) t1 = Table('sometable', MetaData(), Column('somecolumn', type_) @@ -1365,8 +1356,7 @@ class SQLTest(fixtures.TestBase, AssertsCompiledSQL): self.assert_compile( schema.CreateIndex(ix1), "CREATE INDEX %s " - "ON %s (%s)" % (exp, tname, cname), - dialect=mysql.dialect() + "ON %s (%s)" % (exp, tname, cname) ) def test_innodb_autoincrement(self): |