summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/dialects/oracle
Commit message (Collapse)AuthorAgeFilesLines
* get nested joins to render on oracle 8Mike Bayer2013-06-081-3/+10
|
* - additional oracle fixes. cx_oracle under py3k is complaining about tuples ↵Mike Bayer2013-05-271-0/+5
| | | | | | | to executemany(), so just unconditionally turn this into a list - this one test segfaults only on py3k + cx_oracle
* - oracle py3k fixMike Bayer2013-05-271-1/+3
|
* a few more oracle fixesMike Bayer2013-05-261-11/+11
|
* cleanup for oracleMike Bayer2013-05-262-60/+57
|
* - the raw 2to3 runMike Bayer2013-04-273-65/+66
| | | | - went through examples/ and cleaned out excess list() calls
* oracle doesn't have TRUE/FALSE, put 1/0 here, see how that goesMike Bayer2013-04-261-0/+6
|
* - remove all compat items that are pre-2.5 (hooray)Mike Bayer2013-03-091-1/+1
| | | | | | - other cleanup - don't need compat.decimal, that approach never panned out. hopefully outside libs aren't pulling it in, they shouldn't be
* happy new year (see #2645)Diana Clarke2013-01-014-4/+4
|
* Fixed table reflection for Oracle when accessing a synonym that refersMike Bayer2012-12-091-58/+93
| | | | | | | | | | to a DBLINK remote database; while the syntax has been present in the Oracle dialect for some time, up until now it has never been tested. The syntax has been tested against a sample database linking to itself, however there's still some uncertainty as to what should be used for the "owner" when querying the remote database for table information. Currently, the value of "username" from user_db_links is used to match the "owner". [ticket:2619]
* The Oracle LONG type, while an unbounded text type, does not appearMike Bayer2012-12-061-0/+11
| | | | | | | to use the cx_Oracle.LOB type when result rows are returned, so the dialect has been repaired to exclude LONG from having cx_Oracle.LOB filtering applied. Also in 0.7.10. [ticket:2620]
* Repaired the usage of ``.prepare()`` in conjunction withMike Bayer2012-12-061-9/+50
| | | | | | | | | | | cx_Oracle so that a return value of ``False`` will result in no call to ``connection.commit()``, hence avoiding "no transaction" errors. Two-phase transactions have now been shown to work in a rudimental fashion with SQLAlchemy and cx_oracle, however are subject to caveats observed with the driver; check the documentation for details. Also in 0.7.10. [ticket:2611]
* kill me now, pep8 pass, so closeDiana Clarke2012-11-203-46/+55
|
* just a pep8 passDiana Clarke2012-11-202-22/+15
|
* juts a 'expected 2 blank lines' pep8 passDiana Clarke2012-11-193-1/+31
|
* Fixed bug in type_coerce() whereby typing informationMike Bayer2012-11-122-3/+3
| | | | | | | | could be lost if the statement were used as a subquery inside of another statement, as well as other similar situations. Among other things, would cause typing information to be lost when the Oracle/mssql dialects would apply limit/offset wrappings. [ticket:2603]
* - rework the sphinx customizations into distinct modulesMike Bayer2012-10-193-24/+20
| | | | | | | - build a new Sphinx extension that allows dialect info to be entered as directives which is then rendered consistently throughout all dialect/dbapi sections - break out the "empty_strings" requirement for oracle test
* - move out maxdbMike Bayer2012-10-181-3/+0
| | | | | | - begin consolidating docs for dialects to be more self contained - add a separate section for "external" dialects - not sure how we're going to go with this yet.
* - [bug] The CreateIndex construct in OracleMike Bayer2012-09-301-0/+4
| | | | | | | | will now schema-qualify the name of the index to be that of the parent table. Previously this name was omitted which apparently creates the index in the default schema, rather than that of the table.
* - [feature] The types of columns excluded from theMike Bayer2012-09-051-22/+41
| | | | | | | | setinputsizes() set can be customized by sending a list of string DBAPI type names to exclude. This list was previously fixed. The list also now defaults to STRING, UNICODE, removing CLOB, NCLOB from the list. [ticket:2469]
* - refine oracle returning some more to use purely positional approachMike Bayer2012-08-252-22/+22
|
* - more oracle tweaks for returning; the method here is still kind of brittle ↵Mike Bayer2012-08-251-5/+6
| | | | | | and might have issues with pks, multiple function calls
* a few oracle fixesMike Bayer2012-08-251-1/+2
|
* - [bug] Fixed cextension bug whereby theMike Bayer2012-08-221-3/+5
| | | | | | | | | | | | | | | | | | | "ambiguous column error" would fail to function properly if the given index were a Column object and not a string. Note there are still some column-targeting issues here which are fixed in 0.8. [ticket:2553] - find more cases where column targeting is being inaccurate, add more information to result_map to better differentiate "ambiguous" results from "present" or "not present". In particular, result_map is sensitive to dupes, even though no error is raised; the conflicting columns are added to the "obj" member of the tuple so that the two are both directly accessible in the result proxy - handwringing over the damn "name fallback" thing in results. can't really make it perfect yet - fix up oracle returning clause. not sure why its guarding against labels, remove that for now and see what the bot says.
* - update all the visit_mod() functions with new naming schemeMike Bayer2012-08-141-2/+3
| | | | | | - visit_mods all seemed to not propagate **kw down to process(). this is [ticket:2548] which may be backported to 0.7 pending a test case to illustrate wrong behavior.
* - fix concat() operator, testsMike Bayer2012-08-141-3/+4
| | | | | | | | - [feature] Custom unary operators can now be used by combining operators.custom_op() with UnaryExpression(). - clean up the operator dispatch system and make it more consistent. This does change the compiler contract for custom ops.
* - [bug] Fixed compiler bug whereby a givenMike Bayer2012-08-121-1/+1
| | | | | | select() would be modified if it had an "offset" attribute, causing the construct to not compile correctly a second time. [ticket:2545]
* - break out engine/base.py into base, interfaces, result, util.Mike Bayer2012-08-072-9/+9
| | | | - remove deprecated 0.7 engine methods
* -whitespace bonanza, contdMike Bayer2012-07-281-54/+54
|
* trailing whitespace bonanzaMike Bayer2012-07-281-48/+48
|
* - pass kw through hereMike Bayer2012-06-251-3/+3
|
* Add some `Sphinx` paragraph level versions informations markups,Mike Bayer2012-06-082-9/+15
| | | | such as ``.. versionadded::``, ``.. versionchanged::`` and ``.. deprecated::``.
* - [bug] Added ROWID to oracle.*, [ticket:2483]Mike Bayer2012-05-171-1/+1
| | | | Also in 0.7.8.
* - [bug] Quoting information is now passed alongMike Bayer2012-05-041-2/+3
| | | | | | | | from a Column with quote=True when generating a same-named bound parameter to the bindparam() object, as is the case in generated INSERT and UPDATE statements, so that unknown reserved names can be fully supported. [ticket:2437]
* deprecate inspector.get_primary_keys() in favor of inspector.get_pk_constraint()Diana Clarke2012-04-021-27/+6
| | | | - see #2422
* - [bug] Added 'LEVEL' to the list of reservedMike Bayer2012-03-141-1/+1
| | | | words for Oracle. [ticket:2435]
* - [feature] Added a new oracle create_engine() flagMike Bayer2012-02-121-4/+28
| | | | | | | coerce_to_decimal=False, disables the precision numeric handling which can add lots of overhead by converting all numeric values to Decimal. [ticket:2399]
* - Added missing compilation support forMike Bayer2012-02-121-0/+3
| | | | | LONG [ticket:2401] - broke out oracle tests for types that only require dialect
* - [bug] A significant change to how labelingMike Bayer2012-02-051-1/+1
| | | | | | | | | | | | | | is applied to columns in SELECT statements allows "truncated" labels, that is label names that are generated in Python which exceed the maximum identifier length (note this is configurable via label_length on create_engine()), to be properly referenced when rendered inside of a subquery, as well as to be present in a result set row using their original in-Python names. [ticket:2396] - apply pep8 to test_labels
* - [bug] Added ORA-03135 to the never endingMike Bayer2012-01-251-1/+3
| | | | | list of oracle "connection lost" errors [ticket:2388]
* happy new yearMike Bayer2012-01-044-4/+4
|
* marathon doc updating session including a rewrite of unicode paragraphsMike Bayer2011-12-041-0/+2
|
* - The String type now generates VARCHAR2 on OracleMike Bayer2011-09-241-9/+24
| | | | | | | | | | | | | which is recommended as the default VARCHAR. Added an explicit VARCHAR2 and NVARCHAR2 to the Oracle dialect as well. Using NVARCHAR still generates "NVARCHAR2" - there is no "NVARCHAR" on Oracle - this remains a slight breakage of the "uppercase types always give exactly that" policy. VARCHAR still generates "VARCHAR", keeping with the policy. If Oracle were to ever define "VARCHAR" as something different as they claim (IMHO this will never happen), the type would be available. [ticket:2252]
* - Fixed ReturningResultProxy for zxjdbc dialect.Mike Bayer2011-09-211-1/+2
| | | | [ticket:2272]. Also in 0.6.9
* - added CURRENT to reserved word list.Mike Bayer2011-07-241-1/+1
| | | | [ticket:2212] Also in 0.6.9.
* - repaired the oracle.RAW type which did notMike Bayer2011-07-191-3/+6
| | | | | generate the correct DDL. [ticket:2220] Also in 0.6.9.
* - Failures on connect which raise dbapi.ErrorMike Bayer2011-07-011-2/+5
| | | | | | | | | | | | will forward the error to dialect.is_disconnect() and set the "connection_invalidated" flag if the dialect knows this to be a potentially "retryable" condition. Only Oracle ORA-01033 implemented for now. [ticket:2201] - Added ORA-01033 to disconnect codes, which can be caught during a connection event. [ticket:2201]
* - Added ORA-00028 to disconnect codes, useMike Bayer2011-06-221-1/+5
| | | | | cx_oracle _Error.code to get at the code, [ticket:2200]. Also in 0.6.9.
* - The limit/offset keywords to select() as wellMike Bayer2011-04-071-8/+31
| | | | | | | | | | | as the value passed to select.limit()/offset() will be coerced to integer. [ticket:2116] (also in 0.6.7) - Oracle dialect adds use_binds_for_limits=False create_engine() flag, will render the LIMIT/OFFSET values inline instead of as binds, reported to modify the execution plan used by Oracle. [ticket:2116] (Also in 0.6.7)
* - Using column names that would require quotesMike Bayer2011-03-271-2/+7
| | | | | | | | | for the column itself or for a name-generated bind parameter, such as names with special characters, underscores, non-ascii characters, now properly translate bind parameter keys when talking to cx_oracle. [ticket:2100] (Also in 0.6.7)
View Lorry Controller Status