Commit Graph

  • 71e745e96b - Fixed a couple pyflakes, cleaned up imports & whitespace Jason Kirtland 2008-02-14 20:02:10 +00:00
  • 8dd5eb402e MSSQL now compiles func.now() to CURRENT_TIMESTAMP Rick Morrison 2008-02-14 18:38:24 +00:00
  • 84485fb7bb - fixed bug in result proxy where anonymously generated column labels would not be accessible using their straight string name Mike Bayer 2008-02-14 18:22:47 +00:00
  • eddae08fdf Added EXEC to MSSQL _is_select regexp; should now detect row-returning stored procedures Added experimental implementation of limit/offset using row_number() Rick Morrison 2008-02-14 18:03:57 +00:00
  • a612c8a5e2 a TODO comment Mike Bayer 2008-02-13 17:27:47 +00:00
  • 3b23d1d6d6 0.4.3 edits Jason Kirtland 2008-02-12 21:27:18 +00:00
  • 9fffa2c7e1 - fixed bug introduced in r4070 where union() and other compound selects would not get an OID column if it only contained one selectable element, due to missing return in _proxy_column() - visit_column() calls itself to render a primary key col being used as the interpretation of the oid col instead of relying upon broken partial logic Mike Bayer 2008-02-12 21:16:31 +00:00
  • 85e8cb7ffb add pk cols to assocaition table Mike Bayer 2008-02-12 16:45:39 +00:00
  • adc929c0f1 - Added two new vertical dict mapping examples. Jason Kirtland 2008-02-12 01:44:20 +00:00
  • 6f9aa3a900 - added expire_all() method to Session. Calls expire() for all persistent instances. This is handy in conjunction with ..... Mike Bayer 2008-02-11 19:22:34 +00:00
  • 645fa5255d - Fixed .get(<int>) of a String PK (exposed by pg 8.3) Jason Kirtland 2008-02-11 19:14:38 +00:00
  • c0b5a0446b - updated the naming scheme of the base test classes in test/testlib/testing.py; tests extend from either TestBase or ORMTest, using additional mixins for special assertion methods as needed Mike Bayer 2008-02-11 00:28:39 +00:00
  • 90c572b513 - Table columns and constraints can be overridden on a an existing table (such as a table that was already reflected) using the 'useexisting=True' flag, which now takes into account the arguments passed along with it. - fixed one element of [ticket:910] - refactored reflection test Mike Bayer 2008-02-10 23:39:09 +00:00
  • 1ddf4af355 - Better error messaging on failed collection bulk-assignments Jason Kirtland 2008-02-09 19:15:45 +00:00
  • 7313f5c714 - Note about future CollectionAttributeImp.collection_intrface removal + whitespace cleanup. Jason Kirtland 2008-02-09 18:45:50 +00:00
  • 2269bee87f - Determine the basic collection interface dynamically when adapting a collection to an interable Jason Kirtland 2008-02-09 18:45:11 +00:00
  • 3ab7149e25 added info on foreign_keys attribute Mike Bayer 2008-02-09 17:26:48 +00:00
  • 1a3dc51993 - lazy loader can now handle a join condition where the "bound" column (i.e. the one that gets the parent id sent as a bind parameter) appears more than once in the join condition. Specifically this allows the common task of a relation() which contains a parent-correlated subquery, such as "select only the most recent child item". [ticket:946] - col_is_part_of_mappings made more strict, seems to be OK with tests - memusage will dump out the size list in an assertion fail Mike Bayer 2008-02-09 01:48:19 +00:00
  • 0b890e1ccd heisenbug in aisle 3 Mike Bayer 2008-02-09 01:24:01 +00:00
  • 842934f40c - added generative where(<criterion>) method to delete() and update() constructs which return a new object with criterion joined to existing criterion via AND, just like select().where(). - compile assertions use assertEquals() Mike Bayer 2008-02-08 22:57:45 +00:00
  • 1b228e8481 - Added deferrability support to constraints Jason Kirtland 2008-02-08 20:50:33 +00:00
  • 426b6d9baf - psycopg2 can raise un-str()able exceptions; don't croak when trying to log them Jason Kirtland 2008-02-08 20:38:28 +00:00
  • 21c2976870 Fix: deletes with schemas on MSSQL 2000 [ticket:967] Paul Johnston 2008-02-08 16:48:37 +00:00
  • 2999ea9554 test for session close efficiency Mike Bayer 2008-02-08 15:45:54 +00:00
  • 5049242f3b Fix some mssql unit tests Paul Johnston 2008-02-08 13:45:19 +00:00
  • 7e6cd582ca Strip schema from access tables Paul Johnston 2008-02-08 12:05:28 +00:00
  • 668a8ae21b Avoid using common keywords as field names: the test executes literal selects Lele Gaifax 2008-02-06 17:52:48 +00:00
  • 6e498f1a21 check for unicode first before encoding Mike Bayer 2008-02-06 17:44:48 +00:00
  • 4506425966 unit-of-work flush didn't close the failed transaction when the session was not in a transaction and commiting the transaction failed. Ants Aasma 2008-02-06 17:38:29 +00:00
  • 56410e3158 - Some more reST docstring corrections Jason Kirtland 2008-02-06 01:40:40 +00:00
  • 9bc19046d1 - clean up the print version of the docs a bit [ticket:745] Jason Kirtland 2008-02-06 01:32:33 +00:00
  • b0991bf661 - A few quick docstring typo fixes, including [ticket:766] Jason Kirtland 2008-02-06 01:09:08 +00:00
  • e0f41c6475 C-u 66 C-x f M-q Jason Kirtland 2008-02-06 00:11:05 +00:00
  • 23836ee146 ChangeLog for r4115 Jason Kirtland 2008-02-06 00:01:44 +00:00
  • 5320a47a14 - Enabled schema support on SQLite, added the temporary table namespace to 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... Jason Kirtland 2008-02-05 23:31:14 +00:00
  • 28af2439d9 - doc edits- thanks asmodai! [ticket:906] Jason Kirtland 2008-02-05 20:26:08 +00:00
  • b06491586c better that it doesn't get a scalar loader callable Mike Bayer 2008-02-05 19:42:51 +00:00
  • 2b6e2defe5 expire with synonyms [ticket:964] Mike Bayer 2008-02-05 19:41:51 +00:00
  • 96549e6b8f - Autodetect mysql's ANSI_QUOTES mode, sometimes. [ticket:845] 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) Jason Kirtland 2008-02-05 17:26:35 +00:00
  • dc98505f2f hmmm. Jason Kirtland 2008-02-05 15:34:28 +00:00
  • 6d843aeeb2 - Added free-form DDL statements, can be executed standalone or tied to the DDL create/drop lifecycle of Tables and MetaData. [ticket:903] - Added DDL event hooks, triggers callables before and after create / drop. Jason Kirtland 2008-02-05 05:46:33 +00:00
  • 6c73fbb422 *more* tweaks to avoid DEFAULT VALUES on sqlite Mike Bayer 2008-02-04 22:40:52 +00:00
  • d2f9015c12 lock in replacing '%' with '%%' Mike Bayer 2008-02-04 22:35:29 +00:00
  • bb1dd85dcc - add dummy column to appease older SQLite verisons in unicode.py - add test "escape_literal_column" comiler method to start addressing literal '%' character Mike Bayer 2008-02-04 21:47:42 +00:00
  • 0de289921c - ColumnDefault callables can now be any kind of compliant callable, previously only actual functions were allowed. Jason Kirtland 2008-02-04 20:49:38 +00:00
  • 66df4b4958 forcibly clean out _sessions, _mapper_registry at test start to eliminate leftovers from other unit tests (from other test scripts) still stored in memory Mike Bayer 2008-02-04 20:35:25 +00:00
  • 72184bc814 add some extra assertions to ensure all mappers are gone after clear_mappers() (for [ticket:963]) Mike Bayer 2008-02-04 02:44:04 +00:00
  • b79f23d3d0 - fixed reflection of Time columns on sqlite Jason Kirtland 2008-02-01 08:11:12 +00:00
  • a0ffeb5464 - some consolidation of tests in select.py, moved 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] Mike Bayer 2008-02-01 01:16:18 +00:00
  • 7bf0fca858 - Workaround for datetime quirk, LHS comparisons to SA expressions now work. Jason Kirtland 2008-01-31 21:32:38 +00:00
  • 3aed5fa544 - Friendlier exception messages for unbound, implicit execution - Implicit binding failures now raise UnboundExecutionError Jason Kirtland 2008-01-31 19:48:13 +00:00
  • e1aa7573f2 - added "autocommit=True" kwarg to select() and text(), as well as generative autocommit() method on select(); for statements which modify the database through some user-defined means other than the usual INSERT/UPDATE/ DELETE etc., this flag will enable "autocommit" behavior during execution if no transaction is in progress [ticket:915] Mike Bayer 2008-01-31 17:48:22 +00:00
  • e13fdb965f - implemented RowProxy.__ne__ [ticket:945], thanks knutroy - test coverage for same Jason Kirtland 2008-01-31 04:49:31 +00:00
  • a5b23bda66 - the startswith(), endswith(), and contains() operators now concatenate the wildcard operator with the given operand in SQL, i.e. "'%' || <bindparam>" in all cases, accept text('something') operands properly [ticket:962] Mike Bayer 2008-01-31 03:57:20 +00:00
  • 19c3c4c2e0 escapedefaultstest passes on everything Mike Bayer 2008-01-30 21:33:17 +00:00
  • 2d2042cc2b moved default escaping test to its own test so oracle gets it Mike Bayer 2008-01-30 21:31:32 +00:00
  • d3e6ccc625 - Oracle and others properly encode SQL used for defaults like sequences, etc., even if no unicode idents are used since identifier preparer may return a cached unicode identifier. Mike Bayer 2008-01-30 21:08:11 +00:00
  • 204e7201d2 docstring fix Mike Bayer 2008-01-30 19:19:21 +00:00
  • d2e4c52b9f - next release will be 0.4.3 - fixed merge() collection-doubling bug when merging transient entities with backref'ed collections. [ticket:961] - merge(dont_load=True) does not accept transient entities, this is in continuation with the fact that merge(dont_load=True) does not accept any "dirty" objects either. Mike Bayer 2008-01-30 17:35:20 +00:00
  • da7fef941c - "Passive defaults" and other "inline" defaults can now be loaded during a flush() call if needed; in particular, this allows constructing relations() where a foreign key column references a server-side-generated, non-primary-key column. [ticket:954] Mike Bayer 2008-01-28 23:15:40 +00:00
  • b5dd96590a - Added a simple @future test marker. Jason Kirtland 2008-01-28 19:58:39 +00:00
  • 7ed5faff26 - Fixed little think-o in fails_if Jason Kirtland 2008-01-28 19:52:04 +00:00
  • 88f42cf1f4 - Fixed bug in polymorphic inheritance where incorrect exception is raised when base polymorphic_on column does not correspond to any columns within the local selectable of an inheriting mapper more than one level deep Mike Bayer 2008-01-27 02:21:23 +00:00
  • 63d2ce5191 encourage usage of union() and other composites as module-level Mike Bayer 2008-01-25 20:52:13 +00:00
  • 33a6724e33 - added standalone "query" class attribute generated by a scoped_session. This provides MyClass.query without using Session.mapper. Use via: Mike Bayer 2008-01-25 18:16:12 +00:00
  • fadc61e8ca - Ignore jython debris Jason Kirtland 2008-01-24 19:08:22 +00:00
  • ed74083956 - Flipped join order of __radd__ on association proxied lists. Jason Kirtland 2008-01-24 01:12:46 +00:00
  • e94c3ba27a - IdentitySet binops no longer accept plain sets. Jason Kirtland 2008-01-24 01:00:41 +00:00
  • 42a3344eba A little clarity tweak to r4093 Jason Kirtland 2008-01-24 00:21:58 +00:00
  • f6439ffa2c Corrected behavior of get_cls_kwargs and friends Jason Kirtland 2008-01-24 00:08:40 +00:00
  • 29f7a38ee0 added an intro for the code sample so that its not construed as a "synopsis" Mike Bayer 2008-01-23 20:00:53 +00:00
  • c8b50c1ffb - query.join() can also accept tuples of attribute name/some selectable as arguments. This allows construction of joins *from* subclasses of a polymorphic relation, i.e.: Mike Bayer 2008-01-23 19:20:49 +00:00
  • f980c5c88f Added notes about 2.3 improvements Jason Kirtland 2008-01-23 18:26:50 +00:00
  • bc998a14a5 Edits Jason Kirtland 2008-01-23 18:20:26 +00:00
  • 2dbf2a3ef8 whups, args in wrong order Mike Bayer 2008-01-23 15:21:18 +00:00
  • a829b5c51b more descriptive error message for m2m concurrency error Mike Bayer 2008-01-23 15:18:28 +00:00
  • 74a128c686 more capability added to reduce_columns Mike Bayer 2008-01-23 15:16:43 +00:00
  • 47a8b6d10d - Migrated zoomark to profiling.function_call_count(), tightened up the numbers. Is there variation by platform too? Buildbots will tell... Jason Kirtland 2008-01-22 22:43:04 +00:00
  • 7e0f72cde4 rein in r3840 find and replace rampage Jason Kirtland 2008-01-22 21:32:51 +00:00
  • b3cc2f7e0c - 2.3 fixup part three: 100% on postgres, mysql Jason Kirtland 2008-01-22 21:08:21 +00:00
  • 5bc0fe9e16 - Removed some test bogosity Jason Kirtland 2008-01-22 19:42:12 +00:00
  • 342adac637 - Cover 2.3 Decimal fallback Jason Kirtland 2008-01-22 18:06:46 +00:00
  • 412c80dd6c - 2.3 fixup, part two: 100% passing for sqlite - added 2.4-style binops to util.Set on 2.3 - OrderedSets pickle on 2.3 - more lib/sqlalchemy set vs Set corrections - fixed InstrumentedSet.discard for 2.3 - set, sorted compatibility for test suite - added testing.fails_if decorator Jason Kirtland 2008-01-21 23:19:39 +00:00
  • 08bbc3dfd8 clean up a little close() silliness Mike Bayer 2008-01-20 19:04:06 +00:00
  • 8c3ede4b6f factor create_row_adapter into sql.util.row_adapter Mike Bayer 2008-01-20 05:06:55 +00:00
  • ef63a84a49 further clarification on transaction state Mike Bayer 2008-01-20 04:47:16 +00:00
  • e15f6c7327 fix rollback behavior with transaction context manager and failed two phase transactions Ants Aasma 2008-01-20 04:31:53 +00:00
  • f645c0a420 example of using try-catch to do transaction commit/rollback was wrong in the docs Ants Aasma 2008-01-20 03:39:43 +00:00
  • 9f366afdda - parent transactions weren't started on the connection when adding a connection to a nested session transaction. - session.transaction now always refers to the innermost active transaction, even when commit/rollback are called directly on the session transaction object. - when preparing a two-phase transaction fails on one connection all the connections are rolled back. - two phase transactions can now be prepared. - session.close() didn't close all transactions when nested transactions were used. - rollback() previously erroneously set the current transaction directly to the parent of the transaction that could be rolled back to. - autoflush for commit() wasn't flushing for simple subtransactions. Ants Aasma 2008-01-20 03:22:00 +00:00
  • 4be99db15b - Restored 2.3 compat. in lib/sqlalchemy - Part one of test suite fixes to run on 2.3 Lots of failures still around sets; sets.Set differs from __builtin__.set particularly in the binops. We depend on set extensively now and may need to provide a corrected sets.Set subclass on 2.3. Jason Kirtland 2008-01-19 23:37:11 +00:00
  • 21193cebe2 - Added source transformation framework for non-2.4 parser implementations - test/clone.py can create and update (transformed) copies of the test suite - Added Python 2.4 decorator -> 2.3 source transform Jason Kirtland 2008-01-19 23:11:47 +00:00
  • bd3a65252d - Oracle assembles the correct columns in the result set 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] Mike Bayer 2008-01-19 20:11:29 +00:00
  • 840a2fabb8 - some expression fixup: - the '.c.' attribute on a selectable now gets an entry for every column expression in its columns clause; previously, "unnamed" columns like functions and CASE statements weren't getting put there. Now they will, using their full string representation if no 'name' is available. - The anonymous 'label' generated for otherwise unlabeled functions and expressions now propagates outwards at compile time for expressions like select([select([func.foo()])]) - a CompositeSelect, i.e. any union(), union_all(), intersect(), etc. now asserts that each selectable contains the same number of columns. This conforms to the corresponding SQL requirement. - building on the above ideas, CompositeSelects now build up their ".c." collection based on the names present in the first selectable only; corresponding_column() now works fully for all embedded selectables. Mike Bayer 2008-01-19 18:36:52 +00:00
  • 6d486fb2e7 check for session is none, [ticket:940] Mike Bayer 2008-01-17 16:24:26 +00:00
  • b640456af1 Updated bit about coverage.py Jason Kirtland 2008-01-16 23:53:01 +00:00
  • 55c0ab5b2b - dynamic relations, when referenced, create a strong reference to the parent object so that the query still has a parent to call against even if the parent is only created (and otherwise dereferenced) within the scope of a single expression [ticket:938] Mike Bayer 2008-01-16 22:06:15 +00:00
  • 626e83dc28 - default the root logger level only if unset Jason Kirtland 2008-01-16 18:10:08 +00:00
  • 924b639215 maintain the ordering of the given collection of columns when reducing so that primary key collections remain ordered the same as in the mapped table Mike Bayer 2008-01-15 18:33:30 +00:00
  • 2c06e82557 avoid unnecessary mapper.extension copy Mike Bayer 2008-01-15 18:21:13 +00:00
  • 9eced72c03 finally, a really straightforward reduce() method which reduces cols to the minimal set for every test case I can come up with, and now replaces all the cruft in Mapper._compile_pks() as well as Join.__init_primary_key(). mappers can now handle aliased selects and figure out the correct PKs pretty well [ticket:933] Mike Bayer 2008-01-15 17:59:27 +00:00