summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases
Commit message (Collapse)AuthorAgeFilesLines
...
* *whistle*Jason Kirtland2008-03-301-1/+0
|
* - Removed cache decorator.Jason Kirtland2008-03-301-2/+7
|
* some cache decorator calls...Mike Bayer2008-03-303-18/+9
|
* - schema-qualified tables now will place the schemanameMike Bayer2008-03-301-2/+0
| | | | | | | | | | ahead of the tablename in all column expressions as well as when generating column labels. This prevents cross- schema name collisions in all cases [ticket:999] - the "use_schema" argument to compiler.visit_column() is removed. It uses schema in all cases now. - added a new test to the PG dialect to test roundtrip insert/update/delete/select statements with full schema qualification
* MSSQL fixes for tickets 979, 916, 884Rick Morrison2008-03-301-5/+34
|
* - Added PendingDeprecationWarning supportJason Kirtland2008-03-291-1/+1
| | | | - Deprecation decorator is now a real decorator
* - Added generic func.random (non-standard SQL)Jason Kirtland2008-03-251-0/+6
|
* - 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
* - like() and ilike() take an optional keyword argumentMike Bayer2008-03-191-2/+2
| | | | | | "escape=<somestring>", which is set as the escape character using the syntax "x LIKE y ESCAPE '<somestring>'" [ticket:993]
* check for NoneMike Bayer2008-03-041-1/+3
|
* - postgres PGArray is a "mutable" type by default;Mike Bayer2008-03-041-2/+15
| | | | | when used with the ORM, mutable-style equality/ copy-on-write techniques are used to test for changes.
* - postgres TIMESTAMP renders correctly [ticket:981]Mike Bayer2008-02-271-0/+7
|
* - added exception wrapping/reconnect support to result setMike Bayer2008-02-251-1/+1
| | | | | | fetching. Reconnect works for those databases that raise a catchable data error during results (i.e. doesn't work on MySQL) [ticket:978]
* - Invalid SQLite connection URLs now raise an error.Jason Kirtland2008-02-231-0/+7
|
* get basic compilation working for [ticket:972]Mike Bayer2008-02-171-3/+4
|
* - Fixed a couple pyflakes, cleaned up imports & whitespaceJason Kirtland2008-02-144-4/+4
|
* MSSQL now compiles func.now() to CURRENT_TIMESTAMPRick Morrison2008-02-141-1/+9
|
* Added EXEC to MSSQL _is_select regexp; should now detect row-returning ↵Rick Morrison2008-02-141-8/+40
| | | | | | stored procedures Added experimental implementation of limit/offset using row_number()
* Fix: deletes with schemas on MSSQL 2000 [ticket:967]Paul Johnston2008-02-081-0/+2
|
* Strip schema from access tablesPaul Johnston2008-02-081-0/+7
|
* - Enabled schema support on SQLite, added the temporary table namespace to ↵Jason Kirtland2008-02-051-12/+43
| | | | | | table name reflection - TODO: add sqlite to the standard alternate schema tests. a little tricky, because unlike CREATE SCHEMA, an ATTACH DATABASE won't survive a pool dispose...
* - Autodetect mysql's ANSI_QUOTES mode, sometimes. [ticket:845]Jason Kirtland2008-02-051-8/+67
| | | | | | | The dialect needs a hook run on first pool connect to detect this most of the time, and a refactor with Dialect-per-Connection to get it right all of the time. (It's a connection-session scoped setting with dialect-modifying behavior)
* - fixed reflection of Time columns on sqliteJason Kirtland2008-02-011-27/+29
|
* - some consolidation of tests in select.py, movedMike Bayer2008-02-012-2/+16
| | | | | | | 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 and others properly encode SQL used for defaultsMike Bayer2008-01-301-1/+1
| | | | | | like sequences, etc., even if no unicode idents are used since identifier preparer may return a cached unicode identifier.
* - 2.3 fixup part three: 100% on postgres, mysqlJason Kirtland2008-01-221-1/+1
|
* - 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]
* fixed NOT ILIKEMike Bayer2008-01-111-1/+2
|
* - added "ilike()" operator to column operations.Mike Bayer2008-01-111-1/+2
| | | | | compiles to ILIKE on postgres, lower(x) LIKE lower(y) on all others [ticket:727]
* Reverted to False Firebird's supports_sane_rowcountLele Gaifax2008-01-111-1/+1
| | | | Slipped in: even if it seems it could be set to True, I'm still testing the rowcount affair
* Try to reflect also the Sequence on the PK under FirebirdLele Gaifax2008-01-111-3/+30
|
* - Warnings are now issued as SAWarning instead of RuntimeWarning; ↵Jason Kirtland2008-01-119-36/+40
| | | | | | 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-1010-264/+264
|
* Recognize another Firebird exception in dialect.is_disconnect()Lele Gaifax2008-01-101-0/+2
|
* - finally added PGMacAddr type to postgresMike Bayer2008-01-101-0/+5
| | | | [ticket:580]
* redid the _for_ddl String/Text deprecation warning correctly [ticket:912]Mike Bayer2008-01-0910-11/+11
|
* Fixed reflection of mysql empty string column defaults.Jason Kirtland2008-01-081-1/+1
|
* Fix for ticket [923]Rick Morrison2008-01-071-17/+13
|
* - changed name of TEXT to Text since its a "generic" type; TEXT name isMike Bayer2008-01-0510-19/+19
| | | | | | | deprecated until 0.5. The "upgrading" behavior of String to Text when no length is present is also deprecated until 0.5; will issue a warning when used for CREATE TABLE statements (String with no length for SQL expression purposes is still fine) [ticket:912]
* Added REPLACE statements to mysql autocommit list.Jason Kirtland2008-01-041-1/+1
|
* fix not calling the result processor of PGArray subtypes. (a rather ↵Ants Aasma2008-01-031-1/+1
| | | | embarrasing copypaste error) [ticket:913]
* happy new yearMike Bayer2008-01-017-7/+7
|
* fix up oracle handling of LOB/string [ticket:902], slight fixes to ↵Mike Bayer2008-01-011-7/+6
| | | | | | defaults.py but we will need to fix up result-type handling some more
* - added is_disconnect() support for oracleMike Bayer2007-12-291-0/+6
| | | | | - fixed _handle_dbapi_error to detect endless loops, doesn't call rollback/cursor.close etc. in case of disconnect
* - sqlite SLDate type will not erroneously render "microseconds" portionMike Bayer2007-12-201-1/+4
| | | | of a datetime or time object when sent to the DB.
* Fix for autoload of non-identity PK integer columns [824]Rick Morrison2007-12-191-7/+13
| | | | | | Better datetime checking/conversion for pyodbc adodbapi [842] Fix for autoloading schema-qualified tables [901] Convert_unicode support for all dialects [839]
View Lorry Controller Status