Commit Graph

  • 74064ce9fd - fixed Oracle non-ansi join syntax Mike Bayer 2007-10-10 02:30:00 +00:00
  • da45a65a48 - Expanded insert speed test to cover execute as well as executemany Jason Kirtland 2007-10-08 18:51:51 +00:00
  • 57a7a52b56 - Cleaned up visit_insert a bit, inserts are ~3% faster now. Jason Kirtland 2007-10-08 18:19:02 +00:00
  • c931b9d9d1 - a better fix for [ticket:810]. The cause was two phase commit/rollback not opening a new transaction as the dbapi implementations do. Ants Aasma 2007-10-08 16:11:08 +00:00
  • 47d3f45d58 - fix multiple consequent two phase transactions not working with postgres. For some reason implicit transactions are not enough. [ticket:810] - add an option to scoped session mapper extension to not automatically save new objects to session. Ants Aasma 2007-10-08 15:25:51 +00:00
  • 0010807253 Firebird now uses dialect.preparer to format sequences names. UnicodeTest (reflection.py) runs ok now. Roger Demetrescu 2007-10-08 05:07:54 +00:00
  • 2b084b76c0 - Expanded the outer join tests, now covering a situation that looked like it would be wonky in oracle. Jason Kirtland 2007-10-08 03:31:52 +00:00
  • afa713d9e8 - Loosened up test_cant_execute_join for oracle (probably) + bonus typo fix - Some docstring formatting waiting for pg to finish the tests... waiting... Jason Kirtland 2007-10-08 03:01:04 +00:00
  • 849743acac - Added some outerjoin() execution exercises to the query tests. Jason Kirtland 2007-10-08 02:17:07 +00:00
  • 0d9d87560b - No longer using reserved-ish column names in MutableTypesTest. Jason Kirtland 2007-10-07 23:55:59 +00:00
  • 157e43bfad - Actually fixed that testcascade issue. And friends- looks like a cut-n-paste-o. Jason Kirtland 2007-10-07 23:10:14 +00:00
  • 9db4d1f8f5 - Fixed bogus testcascade, also made fixture sequences optional. Jason Kirtland 2007-10-07 22:43:27 +00:00
  • 585b425850 - Squashed assumption of transparent type coercion support in defaults test Jason Kirtland 2007-10-07 21:57:42 +00:00
  • 982b622a37 - Rewrote autoincrement tests: added new scenarios, changed the orm fetchid to explicit test of last_row_ids(), and now testing transactional/autocommit modes separately to help catch any subtle issues that may exist due to assumed cursor state during post_exec(). Jason Kirtland 2007-10-07 18:54:05 +00:00
  • a014d289f6 - Tweaked unordered select tests to not be sensitive to result set order, also split apart some tests (aliases) that sapdb has problems with. Jason Kirtland 2007-10-07 02:01:49 +00:00
  • b27ddac20a - fix to anonymous label generation of long table/column names [ticket:806] Mike Bayer 2007-10-07 01:58:40 +00:00
  • 11c70f9d8d Firebird dialect now uses SingletonThreadPool as its poolclass. (this fixes all "unsuccessful metadata update\n object XXXXX is in use" test errors) Roger Demetrescu 2007-10-07 00:06:05 +00:00
  • 29291f4c32 - oracle does not implicitly convert to unicode for non-typed result sets (i.e. when no TypeEngine/String/Unicode type is even being used; previously it was detecting DBAPI types and converting regardless). should fix [ticket:800] - fixed oracle out_parameters, likely broke in beta6 - fixed oracle _normalize_case for encoded names, gets unicode reflection test to work - a few extra tests tweaked/unsupported for oracle Mike Bayer 2007-10-06 16:12:58 +00:00
  • 84017b1e0b fixed reflection of Column's nullable property [firebird] Roger Demetrescu 2007-10-06 11:10:56 +00:00
  • d87ecbdd00 a typo on postgres returning test version check - change <8.4 -> <8.2 Ants Aasma 2007-10-06 01:31:22 +00:00
  • f97414b520 - null foreign key on a m2o doesn't trigger a lazyload [ticket:803] - slight simpliication to mapper.populate_instance() - lamenting the different codepaths between query._get() and DeferredLoader.lazyload() - query._get() uses all()[0] for single-row load to avoid complexity of first() (same as LazyLoader) Mike Bayer 2007-10-06 01:12:19 +00:00
  • 6695831403 - fixed sqlite reflection of BOOL/BOOLEAN [ticket:808] Mike Bayer 2007-10-05 18:14:11 +00:00
  • af0ca25d10 - Sequences gain a basic dialect-specific kwargs bucket, like Tables. Jason Kirtland 2007-10-04 21:03:29 +00:00
  • 6fb5f1047c Adjusted reserved word reflection test for oracle-style identifier dialects. But probably the CheckConstraint part of this test should just be removed, as it's testing a non-extant feature. Jason Kirtland 2007-10-04 18:31:31 +00:00
  • d154266a65 - Fixed convert_result_value/bind_param compatibility for types without processors. Jason Kirtland 2007-10-04 17:47:29 +00:00
  • 2ca3c38c99 Firebird now passes all tests from /test/engine/reflection.py (except UnicodeTest). Roger Demetrescu 2007-10-04 04:26:57 +00:00
  • f67fcd1822 - move PG RETURNING tests to postgres dialect test - added server_version_info() support for PG dialect - exclude PG versions < 8.4 for RETURNING tests Mike Bayer 2007-10-04 03:19:38 +00:00
  • c25fa30feb Made the regexp detecting the returning token more readable and fixed a couple of corner cases Ants Aasma 2007-10-03 01:06:07 +00:00
  • e82ca71cc5 add support for returning results from inserts and updates for postgresql 8.2+. [ticket:797] Ants Aasma 2007-10-02 23:57:54 +00:00
  • 73b0c40946 - Tweaked the sql.text date test Jason Kirtland 2007-10-02 20:58:58 +00:00
  • 1880e6d8c3 - Unraveled DateTest, removed bogus coverage omission for MySQL TIME types Jason Kirtland 2007-10-02 20:51:17 +00:00
  • ee2247f78f removed unused _fold_identifier_case method Mike Bayer 2007-10-02 15:49:12 +00:00
  • 35ff8ed25e Some fixes on reflection tests (firebird): Roger Demetrescu 2007-10-02 04:44:20 +00:00
  • 3707c9a757 Some fixes on reflection tests (firebird): Roger Demetrescu 2007-10-02 04:43:19 +00:00
  • f0c535403f - The no-arg ResultProxy._row_processor() is now the class attribute _process_row. - Further tiny cleanups in RoxProxy. Jason Kirtland 2007-10-02 01:40:43 +00:00
  • bddc370079 - Removed duplicate RowProxy.__len__ definition and some range(0, 1) lint Jason Kirtland 2007-10-02 00:02:02 +00:00
  • 6d0cf81f74 - ident passed to id_chooser in shard.py always a list Mike Bayer 2007-10-01 19:55:50 +00:00
  • fe3178e224 Make the postgres_where attribute to Index private to postgres module by using a kwargs attribute on the Index. Ants Aasma 2007-10-01 16:29:26 +00:00
  • 0dde728591 - fixed three- and multi-level select and deferred inheritance loading (i.e. abc inheritance with no select_table), [ticket:795] Mike Bayer 2007-09-29 20:17:40 +00:00
  • 4924007317 - added partial index support for postgres - fixed create and drop methods on MockConnection Ants Aasma 2007-09-29 06:21:34 +00:00
  • 51b32cd809 - more docstrings - Selectable is only used as a marker for FromClause (probably should be removed/both classes merged) Mike Bayer 2007-09-28 17:20:24 +00:00
  • e4d7b12c41 - doc updates. generated sql docs are against sql.expression now. - added SessionExtension docs. - removed old sqlconstruction doc. - changed 'copy_collections' flag in Select to '_copy_collections'; its not really "public". Mike Bayer 2007-09-28 16:37:52 +00:00
  • a32ad7b448 firebird doesn't support sane rowcount. Roger Demetrescu 2007-09-28 02:43:41 +00:00
  • f2814d9e1f firebird doesn't support sane rowcount. Roger Demetrescu 2007-09-28 02:43:07 +00:00
  • 30f0f0cf5d - Explicitly close connections in the FOR UPDATE tests. - Minor housekeeping. Jason Kirtland 2007-09-27 23:23:27 +00:00
  • af248f41cc Dropped the leading '__' from generated savepoint names, '_' isn't universally allowed as an initial character for identifiers. Jason Kirtland 2007-09-27 21:27:53 +00:00
  • 475bfc04ac bump to beta7, but might become 0.4.0 Mike Bayer 2007-09-27 17:30:52 +00:00
  • c1221b7cd3 - The IdentifierPreprarer's _requires_quotes test is now regex based. Any out-of-tree dialects that provide custom sets of legal_characters or illegal_initial_characters will need to move to regexes or override _requires_quotes. Jason Kirtland 2007-09-27 17:23:41 +00:00
  • e3b06dc83e zoomark adjustment for the pybot... rel_0_4beta6 Mike Bayer 2007-09-27 00:28:58 +00:00
  • 86a93ee7db test coverage has been added... Mike Bayer 2007-09-27 00:20:17 +00:00
  • 9f7526df52 - adjust server side logic to work with standalone default execution - a little bit of inlining of same Mike Bayer 2007-09-27 00:17:07 +00:00
  • 5d93c8256b - some docstrings for select() - fixed tutorial doctests to adjust for execution changes, session being weak-referencing (reloads objects more frequently which get u'' applied to their __repr__()) Mike Bayer 2007-09-26 23:47:55 +00:00
  • 6f3f85e48c Changed MySQL dialect to use the older LIMIT <offset>, <limit> syntax instead of LIMIT <l> OFFSET <o> for folks using 3.23. ([ticket:794], thanks for the patch!) Jason Kirtland 2007-09-26 23:37:11 +00:00
  • 3a04b7e4d4 Avoid tickling the MySQL-python 1.2.2 executemany parsing bug on a couple tests. Jason Kirtland 2007-09-26 23:35:14 +00:00
  • 32ee73460d add micro-doc for sequence standalone execution Mike Bayer 2007-09-26 23:29:11 +00:00
  • c13eb665aa - added "FETCH" to the keywords detected by Postgres to indicate a result-row holding statement (i.e. in addition to "SELECT"). Mike Bayer 2007-09-26 20:32:19 +00:00
  • ff2a8f24f5 Formatting tweaks Jason Kirtland 2007-09-26 17:40:46 +00:00
  • 1d081a8dec fix comment Mike Bayer 2007-09-26 17:25:23 +00:00
  • 3e672bbfc8 - created a link between QueryContext and SelectionContext; the attribute dictionary of QueryContext is now passed to SelectionContext inside of Query.instances(), allowing messages to be passed between the two stages. - removed the recent "exact match" behavior of Alias objects, they're back to their usual behavior. - tightened up the relationship between the Query's generation of "eager load" aliases, and Query.instances() which actually grabs the eagerly loaded rows. If the aliases were not specifically generated for that statement by EagerLoader, the EagerLoader will not take effect when the rows are fetched. This prevents columns from being grabbed accidentally as being part of an eager load when they were not meant for such, which can happen with textual SQL as well as some inheritance situations. It's particularly important since the "anonymous aliasing" of columns uses simple integer counts now to generate labels. Mike Bayer 2007-09-26 17:08:19 +00:00
  • 9d16ae440b Tightened up time measurement. Jason Kirtland 2007-09-26 16:13:43 +00:00
  • e37a3a961c - the behavior of String/Unicode types regarding that they auto-convert to TEXT/CLOB when no length is present now occurs *only* for an exact type of String or Unicode with no arguments. If you use VARCHAR or NCHAR (subclasses of String/Unicode) with no length, they will be interpreted by the dialect as VARCHAR/NCHAR; no "magic" conversion happens there. This is less surprising behavior and in particular this helps Oracle keep string-based bind parameters as VARCHARs and not CLOBs [ticket:793]. Mike Bayer 2007-09-26 14:55:44 +00:00
  • a0838e0c47 - columns from Alias objects, when used to target result-row columns, must match exactly to the label used in the generated statement. This is so searching for columns in a result row which match aliases won't accidentally match non-aliased columns. fixes errors which can arise in eager loading scenarios. Mike Bayer 2007-09-24 19:27:52 +00:00
  • 6b5543995b - added session.is_modified(obj) method; performs the same "history" comparison operation as occurs within a flush operation; setting include_collections=False gives the same result as is used when the flush determines whether or not to issue an UPDATE for the instance's row. Mike Bayer 2007-09-24 14:51:23 +00:00
  • 8c9795d9e4 added test coverage for r3512 Mike Bayer 2007-09-24 13:51:44 +00:00
  • a4be5e0996 found an errant 2-tuple... Mike Bayer 2007-09-24 13:43:38 +00:00
  • 94aa03c63f fixed session extension bug [ticket:757] Mike Bayer 2007-09-22 18:32:59 +00:00
  • 4be3b2664d fixed firebird visit_alias [ticket:779] Mike Bayer 2007-09-22 18:13:23 +00:00
  • 75c2230476 Added. Jason Kirtland 2007-09-22 18:03:27 +00:00
  • 32dcfdf808 - added "schema" argument to Sequence; use this with Postgres /Oracle when the sequence is located in an alternate schema. Implements part of [ticket:584], should fix [ticket:761]. Mike Bayer 2007-09-22 17:14:15 +00:00
  • 6b0a907fbd - merged sa_entity branch. the big change here is the attributes system deals primarily with the InstanceState and almost never with the instrumented object directly. This reduces lookups and complexity since we need the state for just about everything, now its the one place for everything internally. we also merged the new weak referencing identity map, which will go out in beta6 and we'll see how that goes ! Mike Bayer 2007-09-22 16:55:36 +00:00
  • 7f6bf93da8 - added 'comparator' keyword argument to PickleType. By default, "mutable" PickleType does a "deep compare" of objects using their dumps() representation. But this doesn't work for dictionaries. Pickled objects which provide an adequate __eq__() implementation can be set up with "PickleType(comparator=operator.eq)" [ticket:560] Mike Bayer 2007-09-22 15:55:02 +00:00
  • 927d5d8929 Don't use unicode with pyodbc on UCS-4 platforms [ticket:787] Paul Johnston 2007-09-19 21:46:24 +00:00
  • 68ce4b1636 oops, forgot to commit CHANGES Ants Aasma 2007-09-17 15:46:42 +00:00
  • 9472f3bdba add sqlite reserved words list Ants Aasma 2007-09-17 15:43:02 +00:00
  • 50d86d3cf8 Yet more formatting updates Jason Kirtland 2007-09-11 14:20:29 +00:00
  • 3917a84f00 added support for string date passthru in sqlite (merge of r3322 from trunk) Jason Kirtland 2007-09-10 22:32:11 +00:00
  • e84db3d632 Formatting tweaks. Jason Kirtland 2007-09-10 15:59:58 +00:00
  • 9d5264f9f9 - added 'passive_deletes="all"' flag to relation(), disables all nulling-out of foreign key attributes during a flush where the parent object is deleted. Mike Bayer 2007-09-09 17:01:38 +00:00
  • fbd0a0c725 [ticket:728] foreign key checks for existing reflected FK and replaces itself Mike Bayer 2007-09-08 21:09:50 +00:00
  • dd162c4b30 Tweaked changelog Jason Kirtland 2007-09-08 20:32:14 +00:00
  • 2c48e9949d Tweaked changelog Jason Kirtland 2007-09-08 20:29:07 +00:00
  • 8c14291b6d - adjusted operator precedence of NOT to match '==' and others, so that ~(x <operator> y) produces NOT (x <op> y), which is better compatible with MySQL. [ticket:764]. this doesn't apply to "~(x==y)" as it does in 0.3 since ~(x==y) compiles to "x != y", but still applies to operators like BETWEEN. Mike Bayer 2007-09-08 20:28:26 +00:00
  • b1c0699824 - adjusted operator precedence of NOT to match '==' and others, so that ~(x==y) produces NOT (x=y), which is compatible with MySQL (doesn't like "NOT x=y") [ticket:764] Mike Bayer 2007-09-08 20:19:48 +00:00
  • 5ba8a25afe added assertion case for [ticket:764] Mike Bayer 2007-09-08 20:13:54 +00:00
  • 92c93755be - [ticket:768] dont assume join criterion consists only of column objects Mike Bayer 2007-09-08 20:09:41 +00:00
  • 0ebccb4abd [ticket:768] dont assume join criterion consists only of column objects Mike Bayer 2007-09-08 20:08:41 +00:00
  • fc753a0647 - fixes to ShardedSession to work with deferred columns [ticket:771]. Mike Bayer 2007-09-08 19:51:35 +00:00
  • bf35590e15 Removed DefaultDialect.ischema and information_schema's ISchema (which incidentally had a 'toengine' in it...) Jason Kirtland 2007-09-07 23:13:16 +00:00
  • 179da3ecd9 - merged the unit test for the column_prefix fix that was established in the 0.3 trunk in r2795. the actual "fix" part of it I just happened to spot manually the other day and fixed without testing (forgot what the original failure condition was) in r3449. Mike Bayer 2007-09-07 19:57:01 +00:00
  • 0718103370 Fixed repr() of mysql floats [ticket:775] Added repr testing to mysql dialect Jason Kirtland 2007-09-07 17:58:47 +00:00
  • 64b0267d28 Added 'collection_iter', like 'iter', for anything that implements the @collection.iterator or __iter__ interface. Jason Kirtland 2007-09-07 00:30:53 +00:00
  • 9206d7ed5a Doc updates. Jason Kirtland 2007-09-07 00:21:20 +00:00
  • 22f48d6925 Updated ignores. Jason Kirtland 2007-09-07 00:20:51 +00:00
  • a072e50c9d mysql SETs and ENUMs now unescape embedded quotes before storage in .enums and .values. An ancient bug. Jason Kirtland 2007-09-06 18:46:53 +00:00
  • 4245d75885 associationproxy relies upon a "sweep" through the attributes at the class level, restored the equivalent functionality from previous releases Mike Bayer 2007-09-06 16:58:02 +00:00
  • 986e82700e - column defaults and onupdates, executing inline, will add parenthesis for subqueries and other parenthesis-requiring expressions Mike Bayer 2007-09-06 16:37:37 +00:00
  • 5edafbe955 do the cheaper check first.... Mike Bayer 2007-09-05 23:05:39 +00:00
  • c3c79b997b Fixed reflection of the empty string for mysql enums. Jason Kirtland 2007-09-05 19:39:07 +00:00
  • 9717c71709 merged current entity_management brach r3457-r3462. cleans up '_state' mamangement in attributes, moves __init__() instrumntation into attributes.py, and reduces method call overhead by removing '_state' property. future enhancements may include _state maintaining a weakref to the instance and a strong ref to its __dict__ so that garbage-collected instances can get added to 'dirty', when weak-referenced identity map is used. Mike Bayer 2007-09-05 17:25:32 +00:00
  • 43a927f6e0 Small change in ActiveMapper to make it work with Python 2.3 Paul Johnston 2007-09-04 22:35:00 +00:00