summaryrefslogtreecommitdiff
path: root/test/dialect/oracle.py
Commit message (Collapse)AuthorAgeFilesLines
* - unit tests have been migrated from unittest to nose.Mike Bayer2009-06-101-397/+0
| | | | | See README.unittests for information on how to run the tests. [ticket:970]
* - Fixed bug which was preventing out params of certain typesMike Bayer2009-01-031-4/+4
| | | | | from being received; thanks a ton to huddlej at wwu.edu ! [ticket:1265]
* - Added OracleNVarchar type, produces NVARCHAR2, and alsoMike Bayer2008-12-281-0/+18
| | | | | | | subclasses Unicode so that convert_unicode=True by default. NVARCHAR2 reflects into this type automatically so these columns pass unicode on a reflected table with no explicit convert_unicode=True flags. [ticket:1233]
* auto_convert_lobs=False honored by OracleBinary, OracleText typesMike Bayer2008-10-241-0/+14
| | | | [ticket:1178]
* - fixed some oracle unit tests in test/sql/Mike Bayer2008-10-241-5/+5
| | | | | - wrote a docstring for oracle dialect, needs formatting perhaps - made FIRST_ROWS optimization optional based on optimize_limits=True, [ticket:536]
* - 0.5.0rc3, dohMike Bayer2008-10-181-5/+5
| | | | | | | | | | | | - 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
* - Oracle will detect string-based statements which containMike Bayer2008-10-071-0/+4
| | | | | comments at the front before a SELECT as SELECT statements. [ticket:1187]
* correct extra space in SQL assertionsMike Bayer2008-09-031-5/+5
|
* - limit/offset no longer uses ROW NUMBER OVER to limit rows,Mike Bayer2008-09-031-15/+20
| | | | | | and instead uses subqueries in conjunction with a special Oracle optimization comment. Allows LIMIT/OFFSET to work in conjunction with DISTINCT. [ticket:536]
* merged [ticket:1062] fix from 0.4 branch r4827Mike Bayer2008-05-301-0/+35
|
* oracle dialect takes schema name into account when checking for existing tablesMike Bayer2008-05-241-1/+39
| | | | of the same name. [ticket:709]
* r4695 merged to trunk; trunk now becomes 0.5.Mike Bayer2008-05-091-3/+3
| | | | 0.4 development continues at /sqlalchemy/branches/rel_0_4
* - merged -r4458:4466 of query_columns branchMike Bayer2008-04-071-3/+3
| | | | | | | - 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.
* some test fixup for oracleMike Bayer2008-04-021-5/+5
|
* continue attempting to get proper count for pybot on 2.5, ensure order_by ↵Mike Bayer2008-04-021-1/+1
| | | | for oracle query
* - added verbose activity to profiling.function_call_countMike Bayer2008-04-011-2/+12
| | | | | - simplified oracle non-ansi join generation, removed hooks from base compiler - removed join() call from _label generation, fixed repeat label gen
* fix up some unit testsMike Bayer2008-04-011-1/+1
|
* - the "owner" keyword on Table is now deprecated, and isMike Bayer2008-03-221-1/+76
| | | | | | | | | | | | | | | | | | | | exactly synonymous with the "schema" keyword. Tables can now be reflected with alternate "owner" attributes, explicitly stated on the Table object or not using "schema". - all of the "magic" searching for synonyms, DBLINKs etc. during table reflection are disabled by default unless you specify "oracle_resolve_synonyms=True" on the Table object. Resolving synonyms necessarily leads to some messy guessing which we'd rather leave off by default. When the flag is set, tables and related tables will be resolved against synonyms in all cases, meaning if a synonym exists for a particular table, reflection will use it when reflecting related tables. This is stickier behavior than before which is why it's off by default.
* - updated the naming scheme of the base test classes in test/testlib/testing.py;Mike Bayer2008-02-111-4/+4
| | | | | 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-0/+9
| | | | | | 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-9/+9
| | | | | | - 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
* - fixed an attribute history bug whereby assigning a new collectionMike Bayer2008-01-071-1/+1
| | | | | | | | | | | to a collection-based attribute which already had pending changes would generate incorrect history [ticket:922] - fixed delete-orphan cascade bug whereby setting the same object twice to a scalar attribute could log it as an orphan [ticket:925] - generative select.order_by(None) / group_by(None) was not managing to reset order by/group by criterion, fixed [ticket:924]
* fix up oracle handling of LOB/string [ticket:902], slight fixes to ↵Mike Bayer2008-01-011-0/+9
| | | | | | defaults.py but we will need to fix up result-type handling some more
* - Removed @testing.supported. Dialects in development or maintained outsideJason Kirtland2007-12-131-28/+27
| | | | | | | | | | | the tree can now run the full suite of tests out of the box. - Migrated most @supported to @fails_on, @fails_on_everything_but, or (last resort) @unsupported. @fails_on revealed a slew of bogus test skippage, which was corrected. - Added @fails_on_everything_but. Yes, the first usage *was* "fails_on_everything_but('postgres')". How did you guess! - Migrated @supported in dialect/* to the new test-class attribute __only_on__. - Test classes can also have __unsupported_on__ and __excluded_on__.
* changed the anonymous numbering scheme to be more appealingMike Bayer2007-12-081-3/+3
| | | | got tests running
* - generation of "unique" bind parameters has been simplified to use the sameMike Bayer2007-12-061-3/+3
| | | | | | | | | | "unique identifier" mechanisms as everything else. This doesn't affect user code, except any code that might have been hardcoded against the generated names. Generated bind params now have the form "<paramname>_<num>", whereas before only the second bind of the same name would have this form. - bindparam() objects themselves can be used as keys for execute(), i.e. statement.execute({bind1:'foo', bind2:'bar'})
* - figured out a way to get previous oracle behavior back. the ROWID thingMike Bayer2007-11-051-3/+8
| | | | is still a pretty thorny issue.
* - adjustments to oracle ROWID logic...recent oid changes mean we have toMike Bayer2007-11-051-3/+3
| | | | | | use "rowid" against the select itself (i.e. its just...'rowid', no table name). seems to work OK but not sure if issues will arise - fixes to oracle bind param stuff to account for recent removal of ClauseParameters object.
* Added a missing @supported.Jason Kirtland2007-10-141-0/+1
|
* - attempted to add a test for #622 / #751, but cant reproduce the failing ↵Mike Bayer2007-10-141-0/+16
| | | | | | | condition - fixed major oracle bug introduced by r3561, since colnames come back as unicode now, need to encode keys in setinputsizes() step
* - fixed Oracle non-ansi join syntaxMike Bayer2007-10-101-0/+3
|
* - the behavior of String/Unicode types regarding that they auto-convertMike Bayer2007-09-261-0/+19
| | | | | | | | | to TEXT/CLOB when no length is present now occurs *only* for an exact type of String or Unicode with no arguments. If you use VARCHAR or NCHAR (subclasses of String/Unicode) with no length, they will be interpreted by the dialect as VARCHAR/NCHAR; no "magic" conversion happens there. This is less surprising behavior and in particular this helps Oracle keep string-based bind parameters as VARCHARs and not CLOBs [ticket:793].
* - added "schema" argument to Sequence; use this with Postgres /Oracle when ↵Mike Bayer2007-09-221-0/+13
| | | | | | the sequence is located in an alternate schema. Implements part of [ticket:584], should fix [ticket:761].
* - omitted 'table' and 'column' from 'from sqlalchemy import *'Jason Kirtland2007-08-211-0/+1
| | | | | | | - also omitted all modules and classes that aren't expicitly public - omitted 'Smallinteger' (small i), but it's still in schema - omitted NullType-related items from types.__all__ - patched up a few tests to use sql.table and sql.column, other related.
* - generalized a SQLCompileTest out of select.py, installedMike Bayer2007-08-131-1/+92
| | | | | into dialect/mssql.py, dialect/oracle.py, sql/generative.py - fixed oracle issues [ticket:732], [ticket:733], [ticket:734]
* merging 0.4 branch to trunk. see CHANGES for details. 0.3 moves to ↵Mike Bayer2007-07-271-0/+32
maintenance branch in branches/rel_0_3.
View Lorry Controller Status