summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases
Commit message (Collapse)AuthorAgeFilesLines
* - Got PG server side cursors back into shape, added fixedMike Bayer2008-04-021-9/+14
| | | | | | | unit tests as part of the default test suite. Added better uniqueness to the cursor ID [ticket:1001] - update().values() and insert().values() take keyword arguments.
* fixed OracleRaw type adaptation [ticket:902]Mike Bayer2008-04-021-3/+4
|
* some fixes to the MS-SQL aliasing so that result_map is properly populatedMike Bayer2008-04-021-3/+9
|
* - Assorted flakes.Jason Kirtland2008-04-021-1/+1
|
* - Revamped the Connection memoize decorator a bit, moved to engineJason Kirtland2008-04-023-54/+58
| | | | | - 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
* MSSQL adjustments to pyodbc connection string buildingRick Morrison2008-03-311-38/+5
|
* Add a new 'driver' keyword to the MSSQL pyodbc Dialect.Rick Morrison2008-03-311-24/+14
| | | | Refresh items that were recently reverted by another checkin
* - reverted previous "strings instead of tuples" change due to more specific ↵Mike Bayer2008-03-303-11/+10
| | | | | | test results showing tuples faster - changed cache decorator call on default_schema_name call to a connection.info specific one
* *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
|
View Lorry Controller Status