- more quoting fixes for [ticket:450]...quoting more aggressive (but still skips already-quoted literals)

- got mysql to have "format" as default paramstyle even if mysql module not available, allows unit tests
to pass in non-mysql system for [ticket:457].  all the dialects should be changed to pass in their usual
paramstyle.

1 files changed, 6 insertions, 0 deletions

diff --git a/test/sql/quote.py b/test/sql/quote.py
index 607a595d3..403ae2d42 100644
--- a/test/sql/quote.py
+++ b/test/sql/quote.py
@@ -97,10 +97,16 @@ class QuoteTest(PersistTest):
         x = select([table.c.col1.label("ImATable_col1")]).alias("SomeAlias")
         assert str(select([x.c.ImATable_col1])) == '''SELECT "SomeAlias"."ImATable_col1" \nFROM (SELECT "ImATable".col1 AS "ImATable_col1" \nFROM "ImATable") AS "SomeAlias"'''
 
+        # note that 'foo' and 'FooCol' are literals already quoted
         x = select([sql.column("'foo'").label("somelabel")], from_obj=[table]).alias("AnAlias")
         x = x.select()
+        #print x
         assert str(x) == '''SELECT "AnAlias".somelabel \nFROM (SELECT 'foo' AS somelabel \nFROM "ImATable") AS "AnAlias"'''
         
+        x = select([sql.column("'FooCol'").label("SomeLabel")], from_obj=[table])
+        x = x.select()
+        assert str(x) == '''SELECT "SomeLabel" \nFROM (SELECT 'FooCol' AS "SomeLabel" \nFROM "ImATable")'''
+        
     def testlabelsnocase(self):
         metadata = MetaData()
         table1 = Table('SomeCase1', metadata,