summaryrefslogtreecommitdiff
path: root/test/sql/test_quote.py
Commit message (Collapse)AuthorAgeFilesLines
* Double percent signs based on paramstyle, not dialectMike Bayer2017-04-051-6/+6
| | | | | | | | | | | | This patch moves the "doubling" of percent signs into the base compiler and makes it completely a product of whether or not the paramstyle is format/pyformat or not. Without this paramstyle, percent signs are not doubled across text(), literal_column(), and column(). Change-Id: Ie2f278ab1dbb94b5078f85c0096d74dbfa049197 Fixes: #3740
* Treat collation names as identifiersMike Bayer2017-03-231-0/+17
| | | | | | | | | | | The expression used for COLLATE as rendered by the column-level :func:`.expression.collate` and :meth:`.ColumnOperators.collate` is now quoted as an identifier when the name is case sensitive, e.g. has uppercase characters. Note that this does not impact type-level collation, which is already quoted. Change-Id: I83d5d9cd1e66a4f20b96303bb84c5f360d5d6a1a Fixes: #3785
* Make all tests to be PEP8 compliantKhairi Hafsham2017-02-071-1/+3
| | | | | | | | tested using pycodestyle version 2.2.0 Fixes: #3885 Change-Id: I5df43adc3aefe318f9eeab72a078247a548ec566 Pull-request: https://github.com/zzzeek/sqlalchemy/pull/343
* - update the flake8 rules againMike Bayer2014-07-181-221/+242
| | | | - apply autopep8 + manual fixes to most of test/sql/
* - Fixed regression introduced in 0.9 where new "ORDER BY <labelname>"Mike Bayer2014-04-101-0/+9
| | | | | | feature from :ticket:`1068` would not apply quoting rules to the label name as rendered in the ORDER BY. fix #3020, re: #1068
* - rename __multiple__ to __backend__, and apply __backend__ to a large ↵Mike Bayer2014-03-241-3/+24
| | | | | | number of tests. - move out logging tests from test_execute to test_logging
* - fix propagation of quote flag within _gen_label() so that if theMike Bayer2013-10-051-0/+13
| | | | | | name is already an instance of _anonymous_label(), we don't downgrade it to a plain quoted_name - fixes regression from [ticket:2812]. [ticket:2834]
* - A rework to the way that "quoted" identifiers are handled, in thatMike Bayer2013-08-271-4/+145
| | | | | | | | | | | | | | | | instead of relying upon various ``quote=True`` flags being passed around, these flags are converted into rich string objects with quoting information included at the point at which they are passed to common schema constructs like :class:`.Table`, :class:`.Column`, etc. This solves the issue of various methods that don't correctly honor the "quote" flag such as :meth:`.Engine.has_table` and related methods. The :class:`.quoted_name` object is a string subclass that can also be used explicitly if needed; the object will hold onto the quoting preferences passed and will also bypass the "name normalization" performed by dialects that standardize on uppercase symbols, such as Oracle, Firebird and DB2. The upshot is that the "uppercase" backends can now work with force-quoted names, such as lowercase-quoted names and new reserved words. [ticket:2812]
* Fixed bug in :class:`.CheckConstraint` DDL where the "quote" flag from aMike Bayer2013-07-171-0/+23
| | | | | :class:`.Column` object would not be propagated. Also in 0.8.3, 0.7.11. [ticket:2784]
* - the raw 2to3 runMike Bayer2013-04-271-5/+5
| | | | - went through examples/ and cleaned out excess list() calls
* - adjust this test for the ugly reality of the "name normalize" backends, ↵Mike Bayer2012-11-231-2/+16
| | | | | | | | where because we've decided that "lowercase" is the case insensitive casing, we can't distinguish between case insensitive/not on a database that returns case-insensitive names as UPPERCASE, for names that are UPPERCASE. [ticket:2615]
* just a pep8 pass before I play with these testsDiana Clarke2012-11-231-1/+1
|
* second pass: increasing coverage, and commenting the "why" certain things ↵Diana Clarke2012-11-221-140/+357
| | | | are being tested (when I know) b/c it wasn't initially clear to me why case was being toggled everywhere, etc.
* first pass cleaning up test_labels #2610Diana Clarke2012-11-211-81/+212
|
* this test class had 2 'test_labels' methods, just changing one of them to ↵Diana Clarke2012-11-211-1/+1
| | | | 'test_labels3' for now
* trying different approaches to test layout. in this one, the testing modulesMike Bayer2012-09-271-1/+2
| | | | | | | become an externally usable package but still remains within the main sqlalchemy parent package. in this system, we use kind of an ugly hack to get the noseplugin imported outside of the "sqlalchemy" package, while still making it available within sqlalchemy for usage by third party libraries.
* -whitespace bonanza, contdMike Bayer2012-07-281-7/+7
|
* - [bug] Added support for using the .keyMike Bayer2012-02-051-8/+8
| | | | | | | | | | | | of a Column as a string identifier in a result set row. The .key is currently listed as an "alternate" name for a column, and is superseded by the name of a column which has that key value as its regular name. For the next major release of SQLAlchemy we may reverse this precedence so that .key takes precedence, but this is not decided on yet. [ticket:2392]
* - move all the comments that got shoved below the fixture grabs back upMike Bayer2011-03-271-0/+1
|
* - remove test.sql._base, test.engine._base, test.orm._base, move those ↵Mike Bayer2011-03-271-2/+2
| | | | | | | classes to a new test.lib.fixtures module - move testing.TestBase to test.lib.fixtures - massive search and replace
* Informix and postgresql reserved words changes -- almost done.Jim Phares2011-03-151-0/+12
|
* make it more explicit in tests which dialect we want to use for thingsMike Bayer2011-02-111-0/+2
|
* - whitespace removal bonanzaMike Bayer2011-01-021-2/+2
|
* - ResultProxy and friends always reference the DBAPI connection at the same timeMike Bayer2010-12-051-1/+3
| | | | | | | | as the cursor. There is no reason for CursorFairy - the only use case would be, end-user is using the pool or pool.manage with DBAPI connections, uses a cursor, deferences the owning connection and continues using cursor. This is an almost nonexistent use case and isn't correct usage at a DBAPI level. Take out CursorFairy. - move the "check for a dot in the colname" logic out to the sqlite dialect.
* - move sqlalchemy.test to test.libMike Bayer2010-11-151-1/+1
|
* Because of changes to SQLAlchemy bind parameter placement, removed all ↵Brad Allen2010-03-171-3/+0
| | | | mxodbc test disabling statements having this pattern: @testing.crashes('mssql+mxodbc', """Invalid bind parameter placement:
* Disabling tests for mssql+mxodbc where mxODBC cursor.execute chokes on ↵Brad Allen2010-03-161-0/+4
| | | | invalid placement of bind parameter "?" within the SQL statement.
* fixed the illegal_initial_chars collection + unit test, [ticket:1659]Mike Bayer2010-01-211-2/+9
|
* merge 0.6 series to trunk.Mike Bayer2009-08-061-1/+1
|
* - unit tests have been migrated from unittest to nose.Mike Bayer2009-06-101-0/+210
See README.unittests for information on how to run the tests. [ticket:970]
View Lorry Controller Status