summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases/oracle.py
Commit message (Collapse)AuthorAgeFilesLines
* merge 0.6 series to trunk.Mike Bayer2009-08-061-904/+0
|
* backported 0.6 r6084 fix for oracle alias names, [ticket:1309]Mike Bayer2009-07-311-2/+6
|
* happy new yearMike Bayer2009-01-121-1/+1
|
* - Fixed bug which was preventing out params of certain typesMike Bayer2009-01-031-1/+5
| | | | | from being received; thanks a ton to huddlej at wwu.edu ! [ticket:1265]
* - Added OracleNVarchar type, produces NVARCHAR2, and alsoMike Bayer2008-12-281-1/+6
| | | | | | | 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]
* - Reflected foreign keys will properly locateMike Bayer2008-12-261-1/+1
| | | | | | | | | | | | | | | | | | | | | | | their referenced column, even if the column was given a "key" attribute different from the reflected name. This is achieved via a new flag on ForeignKey/ForeignKeyConstraint called "link_to_name", if True means the given name is the referred-to column's name, not its assigned key. [ticket:650] - removed column types from sqlite doc, we aren't going to list out "implementation" types since they aren't significant and are less present in 0.6 - mysql will report on missing reflected foreign key targets in the same way as other dialects (we can improve that to be immediate within reflecttable(), but it should be within ForeignKeyConstraint()). - postgres dialect can reflect table with an include_columns list that doesn't include one or more primary key columns
* removed the "create_execution_context()" method from dialects and replacedMike Bayer2008-12-191-3/+1
| | | | with a more succinct "dialect.execution_ctx_cls" member
* - postgres docstringMike Bayer2008-12-061-17/+26
| | | | | | - insert/update/delete are documented generatively - values({}) is no longer deprecated, thus enabling unicode/Columns as keys
* - Adjusted the format of create_xid() to repairMike Bayer2008-12-051-2/+2
| | | | | | two-phase commit. We now have field reports of Oracle two-phase commit working properly with this change.
* flattened _get_from_objects() into a descriptor/class-bound attributeMike Bayer2008-11-091-2/+1
|
* docstring fixMike Bayer2008-11-071-1/+1
|
* - Simplified the check for ResultProxy "autoclose without results"Mike Bayer2008-11-041-5/+0
| | | | | | to be based solely on presence of cursor.description. All the regexp-based guessing about statements returning rows has been removed [ticket:1212].
* auto_convert_lobs=False honored by OracleBinary, OracleText typesMike Bayer2008-10-241-4/+5
| | | | [ticket:1178]
* - fixed some oracle unit tests in test/sql/Mike Bayer2008-10-241-2/+115
| | | | | - 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-6/+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
* - Oracle will detect string-based statements which containMike Bayer2008-10-071-0/+5
| | | | | comments at the front before a SELECT as SELECT statements. [ticket:1187]
* added BFILE to reflected type names [ticket:1121]Mike Bayer2008-09-031-0/+1
|
* - has_sequence() now takes the current "schema" argument intoMike Bayer2008-09-031-4/+6
| | | | account [ticket:1155]
* - limit/offset no longer uses ROW NUMBER OVER to limit rows,Mike Bayer2008-09-031-15/+43
| | | | | | and instead uses subqueries in conjunction with a special Oracle optimization comment. Allows LIMIT/OFFSET to work in conjunction with DISTINCT. [ticket:536]
* - logging scale-back; the echo_uow flag on Session is deprecated, and unit ↵Mike Bayer2008-08-241-2/+0
| | | | | | | | | | | | of work logging is now class level like all the other logging. - trimmed back the logging API, centralized class_logger() as the single point of configuration for logging, removed per-instance logging checks from ORM. - Engine and Pool logging remain at the instance level. The modulus of "instance ids" has been upped to 65535. I'd like to remove the modulus altogether but I do see a couple of users each month calling create_engine() on a per-request basis, an incorrect practice but I'd rather their applications don't just run out of memory.
* - The 'length' argument to all Numeric types has been renamedMike Bayer2008-08-241-1/+1
| | | | | | | | | | | | | | | | to 'scale'. 'length' is deprecated and is still accepted with a warning. [ticket:827] - The 'length' argument to MSInteger, MSBigInteger, MSTinyInteger, MSSmallInteger and MSYear has been renamed to 'display_width'. [ticket:827] - mysql._Numeric now consumes 'unsigned' and 'zerofill' from the given kw, so that the same kw can be passed along to Numeric and allow the 'length' deprecation logic to still take effect - added testlib.engines.all_dialects() to return a dialect for every db module - informix added to sqlalchemy.databases.__all__. Since other "experimental" dbs like access and sybase are there, informix should be as well.
* - Temporarily rolled back the "ORDER BY" enhancementMike Bayer2008-08-061-1/+0
| | | | | from [ticket:1068]. This feature is on hold pending further development.
* - compiler visit_label() checks a flag "within_order_by" and will render its ↵Mike Bayer2008-08-031-0/+1
| | | | | | | | | | | | | | | | | | | own name and not its contained expression, if the dialect reports true for supports_simple_order_by_label. the flag is not propagated forwards, meant to closely mimic the syntax Postgres expects which is that only a simple name can be in the ORDER BY, not a more complex expression or function call with the label name embedded (mysql and sqlite support more complex expressions). This further sets the standard for propigation of **kwargs within compiler, that we can't just send **kwargs along blindly to each XXX.process() call; whenever a **kwarg needs to propagate through, most methods will have to be aware of it and know when they should send it on forward and when not. This was actually already the case with result_map as well. The supports_simple_order_by dialect flag defaults to True but is conservatively explicitly set to False on all dialects except SQLite/MySQL/Postgres to start. [ticket:1068]
* Added new basic match() operator that performs a full-text search. Supported ↵Michael Trier2008-07-131-1/+2
| | | | on PostgreSQL, SQLite, MySQL, MS-SQL, and Oracle backends.
* - re-fixed the fix to the prefixes fixMike Bayer2008-07-061-9/+1
| | | | | - removed ancient descriptor() functions from dialects; replaced with Dialect.name - removed similarly ancient sys.modules silliness in Engine.name
* merged [ticket:1062] fix from 0.4 branch r4827Mike Bayer2008-05-301-1/+8
|
* oracle dialect takes schema name into account when checking for existing tablesMike Bayer2008-05-241-1/+3
| | | | of the same name. [ticket:709]
* merged r4809 from rel_0_4, oracle fixMike Bayer2008-05-241-2/+2
|
* handle null tablespace_nameJonathan Ellis2008-05-201-2/+2
|
* add CHAR to ischema_names map; some minor cleanupJonathan Ellis2008-05-201-4/+3
|
* Columns now have default= and server_default=. PassiveDefault fades away.Jason Kirtland2008-05-141-1/+1
|
* r4695 merged to trunk; trunk now becomes 0.5.Mike Bayer2008-05-091-39/+39
| | | | 0.4 development continues at /sqlalchemy/branches/rel_0_4
* refactor of default_paramstyle, use paramstyle argument on Dialect to changeMatt Harrison2008-04-071-1/+2
|
* fixed OracleRaw type adaptation [ticket:902]Mike Bayer2008-04-021-3/+4
|
* - Assorted flakes.Jason Kirtland2008-04-021-1/+1
|
* - Revamped the Connection memoize decorator a bit, moved to engineJason Kirtland2008-04-021-3/+3
| | | | | - MySQL character set caching is more aggressive but will invalidate the cache if a SET is issued. - MySQL connection memos are namespaced: info[('mysql', 'server_variable')]
* - More 2.4 generator squashing.Jason Kirtland2008-04-021-1/+1
|
* - added verbose activity to profiling.function_call_countMike Bayer2008-04-011-50/+60
| | | | | - simplified oracle non-ansi join generation, removed hooks from base compiler - removed join() call from _label generation, fixed repeat label gen
* - reverted previous "strings instead of tuples" change due to more specific ↵Mike Bayer2008-03-301-2/+3
| | | | | | test results showing tuples faster - changed cache decorator call on default_schema_name call to a connection.info specific one
* some cache decorator calls...Mike Bayer2008-03-301-7/+3
|
* - the "owner" keyword on Table is now deprecated, and isMike Bayer2008-03-221-68/+69
| | | | | | | | | | | | | | | | | | | | 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.
* reverted r4315 - a basic test works the way it was and fails with this changeMike Bayer2008-03-221-1/+1
|
* Undoing patch #994, for now; more testing needed. Sorry. Also modifying ↵Catherine Devlin2008-03-201-93/+0
| | | | test for query equivalence to account for underscoring of bind variables.
* adding zzzeek's patch from ticket #994, which fixed virtually all remaining ↵Catherine Devlin2008-03-201-0/+93
| | | | broken unit tests in the Oracle module
* bugfix: preserving remote_owner during reflecttable setup of referential ↵Catherine Devlin2008-03-201-1/+1
| | | | integrity
* - some consolidation of tests in select.py, movedMike Bayer2008-02-011-1/+8
| | | | | | | other tests to more specific modules - added "now()" as a generic function; on SQLite and Oracle compiles as "CURRENT_TIMESTAMP"; "now()" on all others [ticket:943]
* - Oracle assembles the correct columns in the result setMike Bayer2008-01-191-1/+1
| | | | | | 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]
* - Warnings are now issued as SAWarning instead of RuntimeWarning; ↵Jason Kirtland2008-01-111-5/+7
| | | | | | util.warn() wraps this up. - SADeprecationWarning has moved to exceptions. An alias remains in logging until 0.5.
* Include column name in length-less String warning (more [ticket:912])Jason Kirtland2008-01-101-30/+30
|
* redid the _for_ddl String/Text deprecation warning correctly [ticket:912]Mike Bayer2008-01-091-1/+1
|
View Lorry Controller Status