diff options
| author | Khairi Hafsham <jumanjisama@gmail.com> | 2017-02-02 13:02:21 -0500 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2017-02-07 11:21:56 -0500 |
| commit | 772374735da27df1ddb907f4a0f5085b46dbe82b (patch) | |
| tree | 41f88c835a74d4665c97853ae8676a5181d61db3 /test/dialect/mysql/test_query.py | |
| parent | d71f4b47186972c5248c94ee2d04364da95a0965 (diff) | |
| download | sqlalchemy-772374735da27df1ddb907f4a0f5085b46dbe82b.tar.gz | |
Make all tests to be PEP8 compliant
tested using pycodestyle version 2.2.0
Fixes: #3885
Change-Id: I5df43adc3aefe318f9eeab72a078247a548ec566
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/343
Diffstat (limited to 'test/dialect/mysql/test_query.py')
| -rw-r--r-- | test/dialect/mysql/test_query.py | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/test/dialect/mysql/test_query.py b/test/dialect/mysql/test_query.py index c6b7a1036..04f3ca67d 100644 --- a/test/dialect/mysql/test_query.py +++ b/test/dialect/mysql/test_query.py @@ -38,16 +38,16 @@ class MatchTest(fixtures.TestBase): metadata = MetaData(testing.db) cattable = Table('cattable', metadata, - Column('id', Integer, primary_key=True), - Column('description', String(50)), - mysql_engine='MyISAM' - ) + Column('id', Integer, primary_key=True), + Column('description', String(50)), + mysql_engine='MyISAM') matchtable = Table('matchtable', metadata, - Column('id', Integer, primary_key=True), - Column('title', String(200)), - Column('category_id', Integer, ForeignKey('cattable.id')), - mysql_engine='MyISAM' - ) + Column('id', Integer, primary_key=True), + Column('title', String(200)), + Column('category_id', + Integer, + ForeignKey('cattable.id')), + mysql_engine='MyISAM') metadata.create_all() cattable.insert().execute([ @@ -103,7 +103,8 @@ class MatchTest(fixtures.TestBase): # test [ticket:3263] result = testing.db.execute( select([ - matchtable.c.title.match('Agile Ruby Programming').label('ruby'), + matchtable.c.title.match('Agile Ruby Programming') + .label('ruby'), matchtable.c.title.match('Dive Python').label('python'), matchtable.c.title ]).order_by(matchtable.c.id) @@ -149,7 +150,7 @@ class MatchTest(fixtures.TestBase): def test_match_across_joins(self): results = (matchtable.select(). - where(and_(cattable.c.id==matchtable.c.category_id, + where(and_(cattable.c.id == matchtable.c.category_id, or_(cattable.c.description.match('Ruby'), matchtable.c.title.match('nutshell')))). order_by(matchtable.c.id). @@ -211,4 +212,3 @@ class AnyAllTest(fixtures.TablesTest): is_( testing.db.execute(stmt).scalar(), True ) - |