summaryrefslogtreecommitdiff
path: root/test/sql/labels.py
Commit message (Collapse)AuthorAgeFilesLines
* - unit tests have been migrated from unittest to nose.Mike Bayer2009-06-101-195/+0
| | | | | See README.unittests for information on how to run the tests. [ticket:970]
* - anonymous alias names now truncate down to the max lengthMike Bayer2009-02-101-6/+39
| | | | | allowed by the dialect. More significant on DBs like Oracle with very small character limits. [ticket:1309]
* - Dialects can now generate label names of adjustable length.Mike Bayer2008-11-051-8/+29
| | | | | | | | | | | | | Pass in the argument "label_length=<value>" to create_engine() to adjust how many characters max will be present in dynamically generated column labels, i.e. "somecolumn AS somelabel". Any value less than 6 will result in a label of minimal size, consiting of an underscore and a numeric counter. The compiler uses the value of dialect.max_identifier_length as a default. [ticket:1211] - removed ANON_NAME regular expression, using string patterns now - _generated_label() unicode subclass is used to indicate generated names which are subject to truncation
* - 0.5.0rc3, dohMike Bayer2008-10-181-11/+0
| | | | | | | | | | | | - The internal notion of an "OID" or "ROWID" column has been removed. It's basically not used by any dialect, and the possibility of its usage with psycopg2's cursor.lastrowid is basically gone now that INSERT..RETURNING is available. - Removed "default_order_by()" method on all FromClause objects. - profile/compile/select test is 8 function calls over on buildbot 2.4 for some reason, will adjust after checking the results of this commit
* - merged r4868, disallow overly long names from create/drop, from 0.4 ↵Mike Bayer2008-06-221-0/+9
| | | | branch, [ticket:571]
* Test suite modernization in progress. Big changes:Jason Kirtland2008-05-091-16/+20
| | | | | | | | | | | - @unsupported now only accepts a single target and demands a reason for not running the test. - @exclude also demands an exclusion reason - Greatly expanded @testing.requires.<feature>, eliminating many decorators in the suite and signficantly easing integration of multi-driver support. - New ORM test base class, and a featureful base for mapped tests - Usage of 'global' for shared setup going away, * imports as well
* - merged -r4458:4466 of query_columns branchMike Bayer2008-04-071-1/+1
| | | | | | | - this branch changes query.values() to immediately return an iterator, adds a new "aliased" construct which will be the primary method to get at aliased columns when using values() - tentative ORM versions of _join and _outerjoin are not yet public, would like to integrate with Query better (work continues in the branch) - lots of fixes to expressions regarding cloning and correlation. Some apparent ORM bug-workarounds removed. - to fix a recursion issue with anonymous identifiers, bind parameters generated against columns now just use the name of the column instead of the tablename_columnname label (plus the unique integer counter). this way expensive recursive schemes aren't needed for the anon identifier logic. This, as usual, impacted a ton of compiler unit tests which needed a search-n-replace for the new bind names.
* - updated the naming scheme of the base test classes in test/testlib/testing.py;Mike Bayer2008-02-111-2/+2
| | | | | tests extend from either TestBase or ORMTest, using additional mixins for special assertion methods as needed
* - Oracle assembles the correct columns in the result setMike Bayer2008-01-191-1/+24
| | | | | | column mapping when generating a LIMIT/OFFSET subquery, allows columns to map properly to result sets even if long-name truncation kicks in [ticket:941]
* - testbase is gone, replaced by testenvJason Kirtland2008-01-121-19/+19
| | | | | | - Importing testenv has no side effects- explicit functions provide similar behavior to the old immediate behavior of testbase - testing.db has the configured db - Fixed up the perf/* scripts
* Reworked r4042- undeclared deprecation warnings are now *fatal* to tests. ↵Jason Kirtland2008-01-101-1/+1
| | | | No surprises.
* - fix to anonymous label generation of long table/column names [ticket:806]Mike Bayer2007-10-071-3/+19
|
* - method call removalMike Bayer2007-08-201-2/+2
|
* 1. Module layout. sql.py and related move into a package called "sql".Mike Bayer2007-08-181-1/+1
| | | | | | | | | | | | 2. compiler names changed to be less verbose, unused classes removed. 3. Methods on Dialect which return compilers, schema generators, identifier preparers have changed to direct class references, typically on the Dialect class itself or optionally as attributes on an individual Dialect instance if conditional behavior is needed. This takes away the need for Dialect subclasses to know how to instantiate these objects, and also reduces method overhead by one call for each one. 4. as a result of 3., some internal signatures have changed for things like compiler() (now statement_compiler()), preparer(), etc., mostly in that the dialect needs to be passed explicitly as the first argument (since they are just class references now). The compiler() method on Engine and Connection is now also named statement_compiler(), but as before does not take the dialect as an argument. 5. changed _process_row function on RowProxy to be a class reference, cuts out 50K method calls from insertspeed.py
* merging 0.4 branch to trunk. see CHANGES for details. 0.3 moves to ↵Mike Bayer2007-07-271-6/+12
| | | | maintenance branch in branches/rel_0_3.
* - fix to long name generation when using oid_column as an order byMike Bayer2007-05-071-1/+13
| | | | (oids used heavily in mapper queries)
* Removed an unneeded and troublesome subquery test.Jason Kirtland2007-05-021-5/+0
|
* some notes on a labeling issue that arises when label truncation doesnt ↵Mike Bayer2007-05-011-2/+13
| | | | match col truncation
* - the label() method on ColumnElement will properly propigate theMike Bayer2007-04-291-0/+9
| | | | | TypeEngine of the base element out to the label, including a label() created from a scalar=True select() statement.
* added keys() to ColumnParameters, needed for setbindparamsizes traversalMike Bayer2007-03-281-4/+4
|
* - column label and bind param "truncation" also generateMike Bayer2007-03-281-9/+32
| | | | | | | | | | | deterministic names now, based on their ordering within the full statement being compiled. this means the same statement will produce the same string across application restarts and allowing DB query plan caching to work better. - cleanup to sql.ClauseParameters since it was just falling apart, API made more explicit - many unit test tweaks to adjust for bind params not being "pre" truncated, changes to ClauseParameters
* added label truncation for bind param names which was lost in the previous ↵Mike Bayer2007-03-281-0/+10
| | | | | | related commit. added more tests plus test for column targeting with text() clause.
* - column labels are now generated in the compilation phase, whichMike Bayer2007-03-241-0/+34
means their lengths are dialect-dependent. So on oracle a label that gets truncated to 30 chars will go out to 63 characters on postgres. Also, the true labelname is always attached as the accessor on the parent Selectable so theres no need to be aware of the genrerated label names [ticket:512]. - ResultProxy column targeting is greatly simplified, and relies upon the ANSICompiler's column_labels map to translate the built-in label on a _ColumnClause (which is now considered to be a unique identifier of that column) to the label which was generated at compile time. - still need to put a baseline of ColumnClause targeting for ResultProxy objects that originated from a textual query.