Commit Graph

  • 9fb75f7bb8 - support for inline hyperlinks between HTML-generated docstrings - docstrings for all sql package functions including cross linking. Mike Bayer 2007-04-28 01:50:42 +00:00
  • ef9580f984 extra tests that unneeded UPDATEs dont occur Mike Bayer 2007-04-27 20:13:01 +00:00
  • 0d457d1129 removed unneeded closure function Mike Bayer 2007-04-27 17:36:56 +00:00
  • 14645af693 removed 'unjoined_table', synonymous with local_table Mike Bayer 2007-04-27 17:33:25 +00:00
  • f2a11cc728 - the usual adjustments to relationships between inheriting mappers, in this case establishing relation()s to subclass mappers where the join conditions come from the superclass' table - specifically, places where PropertyLoader limits its search to mapper.local_table had to be expanded to search separately within mapper.mapped_table as well. in the case of determining primary/secondaryjoin, it starts more specifically first with local table then out to mapped table if not found. in the case of determining direction, it starts more generally with mapped table, then if ambiguous direction, goes to the local tables. Mike Bayer 2007-04-27 17:19:39 +00:00
  • 732bc9ecf0 correct typo-equivalent mistakes in some comments/docstrings Gaëtan de Menten 2007-04-27 09:50:00 +00:00
  • 6a30f0ee37 - Fully specify ordering for ordered union test comparison Jason Kirtland 2007-04-27 00:29:23 +00:00
  • 683ff64c4b restored functionality to not issue DELETE for instances that have no _identity_key Mike Bayer 2007-04-27 00:09:25 +00:00
  • eaff9a5aaf decruftify UOW some more....uowdumper always prints out based on polymorphic collections Mike Bayer 2007-04-26 18:14:33 +00:00
  • 28ba749aa5 - generative test doesnt apply to mysql, others - refactoring to unitofwork.py. low-hanging cruft removed, UOWTask structure simplified particuularly with the per-instance sort phase, most methods docstring'ed extensively. this is a merge from the 'uowsimplify' branch. (only slightly simpler, tho) - mapper delete_obj works across multiple mappers to be consistent with the operation of save_obj Mike Bayer 2007-04-26 18:04:09 +00:00
  • d59bf11536 some extra tests for synonyms to relation()s Mike Bayer 2007-04-26 16:40:38 +00:00
  • 6dc8f93962 - _with_parent_criterion generalized into _with_lazy_criterion - _create_lazy_clause now includes a 'reverse_direction' flag to generate lazy criterion in from parent->child or vice versa - changed join_by() in query to use the "reverse" _create_lazy_clause for instance comparisons so conditions like AND can work [ticket:554] Mike Bayer 2007-04-26 16:25:13 +00:00
  • b1ec42fb1d fixed casing of SET clause Mike Bayer 2007-04-26 02:25:56 +00:00
  • 7edf9a3721 - Always propagate constructor exceptions in mapped clases (applied patch in #528) Jason Kirtland 2007-04-25 18:09:25 +00:00
  • 2f547222da - added generative versions of aggregates, i.e. sum(), avg(), etc. to query. used via query.apply_max(), apply_sum(), etc. #552 Mike Bayer 2007-04-25 17:49:26 +00:00
  • 3a0f65b434 revert CSS tweak Mike Bayer 2007-04-25 17:23:42 +00:00
  • 41ff863fc0 #553 propigate index on copied columns Mike Bayer 2007-04-25 17:22:16 +00:00
  • 796d3acf9b some formatting/indentation stuff Mike Bayer 2007-04-25 13:45:31 +00:00
  • 91e449800a wrap __name__ settings in a try/except for 2.3 compat Mike Bayer 2007-04-25 01:04:52 +00:00
  • 6124ef2285 - assign_mapper names methods according to their keys (i.e. __name__) #551 Mike Bayer 2007-04-24 21:55:47 +00:00
  • 38c6c7ffdf - added a col label to help sqlite with order by Mike Bayer 2007-04-24 21:51:40 +00:00
  • a86398fdcf - primary key determination within Join maintains table PK ordering Mike Bayer 2007-04-24 21:45:22 +00:00
  • 49f633b7d1 - fix to case() construct to propigate the type of the first WHEN condition as the return type of the case statement - various unit test tweaks to get oracle working Mike Bayer 2007-04-24 21:33:07 +00:00
  • 898034c214 added an order_by Mike Bayer 2007-04-24 18:51:21 +00:00
  • 088460f222 - Fire delrecord events when items are discard()ed from a set-backed InstrumentedList, just like remove(). Jason Kirtland 2007-04-24 02:03:53 +00:00
  • 075f44b10f dont use assignmapper.flush() Mike Bayer 2007-04-23 20:50:15 +00:00
  • c7729164da - big fix to AssociationProxy so that multiple AssociationProxy objects can be associated with a single association collection. Mike Bayer 2007-04-23 19:53:34 +00:00
  • 8bc6149ee8 - support for SSL arguments given as inline within URL query string, prefixed with "ssl_", courtesy terjeros@gmail.com. Mike Bayer 2007-04-22 17:49:59 +00:00
  • e9c5f5eb01 fix for dbapi() method to be classmethod #546 Mike Bayer 2007-04-22 17:03:35 +00:00
  • 6d6c546b0e a rudimental reconnect/pool auto-dispose test. not super-comprehensive but better than nothing, will close #516 Mike Bayer 2007-04-22 00:30:39 +00:00
  • b41e52f1b7 - informix support added ! courtesy James Zhang - tweak to oracle default execution code to use local connection for compilation - tweak to connection.execute_text() to generate None for parameters when no params sent Mike Bayer 2007-04-21 23:29:03 +00:00
  • 60571ea137 - converted logger.warn() to warnings.warn() - implemented #302 Mike Bayer 2007-04-21 22:54:35 +00:00
  • 6296e343ea non-db identifier length raised arbitrarily high Mike Bayer 2007-04-20 19:34:36 +00:00
  • 952e9cd3ff more comprehensive query docs Mike Bayer 2007-04-20 16:17:52 +00:00
  • b9c148d5be rewrite.... Mike Bayer 2007-04-20 05:14:39 +00:00
  • eaad320a85 - some docstrings - some more test scenarios for raw bind params Mike Bayer 2007-04-20 00:43:56 +00:00
  • 0fe6b80c70 - Promoted mysql's dburl query string helper to util + fixed - Coercing sqlite connect args provided in query string to their expected type (e.g. 'timeout' as float, fixes #544) - Coerce mysql's client_flag to int too Jason Kirtland 2007-04-19 23:44:26 +00:00
  • 42df71d215 support positional parameters at the execute level even for DBs where we dont expect positional Mike Bayer 2007-04-19 23:34:53 +00:00
  • 16e9315e9b unit test with just one param Mike Bayer 2007-04-19 23:24:07 +00:00
  • b9c2c6649c some changelog Mike Bayer 2007-04-19 20:02:02 +00:00
  • 93d212a138 - merged in the combined patch for #474, #475, #476 (attached to #476) and a new set of tests Jason Kirtland 2007-04-19 19:35:03 +00:00
  • 47a6af93d5 - fixed issue where slice assignment on relation properties truncates the relation (#529) - fix for #530, don't require collection classes to respond to len requests Jason Kirtland 2007-04-19 19:07:51 +00:00
  • b90627a44f - tweak to restore Python 2.3 compatability Jason Kirtland 2007-04-19 18:37:19 +00:00
  • 1ad3f6a4bc some docstrings Mike Bayer 2007-04-19 16:00:35 +00:00
  • 4fffc21c87 - the "where" criterion of an update() and delete() now correlates embedded select() statements against the table being updated or deleted. this works the same as nested select() statement correlation, and can be disabled via the correlate=False flag on the embedded select(). Mike Bayer 2007-04-18 22:54:40 +00:00
  • 7efd23b23c - fixed critical issue when, after options(eagerload()) is used, the mapper would then always apply query "wrapping" behavior for all subsequent LIMIT/OFFSET/DISTINCT queries, even if no eager loading was applied on those subsequent queries. Mike Bayer 2007-04-18 22:33:53 +00:00
  • d5c3eb39ca added "is_disconnect()" for firebird Mike Bayer 2007-04-18 21:11:07 +00:00
  • 518d91134c - making progress with session.merge() as well as combining its usage with entity_name [ticket:543] Mike Bayer 2007-04-18 02:16:57 +00:00
  • dd73d31d80 note about elixir Mike Bayer 2007-04-17 21:33:29 +00:00
  • 12f126f30b slight cleanup for #498 Mike Bayer 2007-04-17 21:28:55 +00:00
  • aabb6e530b - the dialects within sqlalchemy.databases become a setuptools entry points. loading the built-in database dialects works the same as always, but if none found will fall back to trying pkg_resources to load an external module [ticket:521] Mike Bayer 2007-04-17 20:49:35 +00:00
  • 8d7a271b86 docs/examples for new with_parent() feature Mike Bayer 2007-04-17 18:15:58 +00:00
  • d3b7114937 - added query.with_parent(someinstance) method. searches for target instance using lazy join criterion from parent instance. takes optional string "property" to isolate the desired relation. also adds static Query.query_from_parent(instance, property) version. [ticket:541] Mike Bayer 2007-04-17 18:04:37 +00:00
  • b81a0132a8 added "recreate()" argument to connection pool classes this method is called when the invalidate() occurs for a disconnect condition, so that the entire pool is recreated, thereby avoiding repeat errors on remaining connections in the pool. dispose() called as well (also fixed up) but cant guarantee all connections closed. Mike Bayer 2007-04-17 00:21:25 +00:00
  • 86fef1e459 - removed meaningless entity_name argument from session.delete() - session.merge() propigates given entity_name to locate that mapper if the given object is transient (and therefore has no entity_name) - some fixes to MockEngine which still is mostly useless for most cases. - unitofwork test used incorrect session.delete() signature Mike Bayer 2007-04-16 22:35:53 +00:00
  • 07cd648f3f - got unicode schemas to work with postgres - unicode schema with mysql slightly improved, still cant do has_table - got reflection of unicode schemas working with sqlite, pg, mysql Mike Bayer 2007-04-15 22:04:53 +00:00
  • ad39d4fc1c more docstrings stuff Mike Bayer 2007-04-14 21:56:21 +00:00
  • f712251d40 added ansisql docs to output, moved exceptions to a more reasonable location Mike Bayer 2007-04-14 21:40:41 +00:00
  • 253f2a92e3 didnt need that method... Mike Bayer 2007-04-14 01:39:00 +00:00
  • bb1ec10f3a some docstrings to provide more detail in the sql package Mike Bayer 2007-04-14 01:28:45 +00:00
  • b9ce8e38c9 - small fix to allow successive compiles of the same SELECT object which features LIMIT/OFFSET. oracle dialect needs to modify the object to have ROW_NUMBER OVER and wasn't performing the full series of steps on successive compiles. Mike Bayer 2007-04-13 22:22:07 +00:00
  • e44857977a [ticket:534] get dictionary append() method properly Mike Bayer 2007-04-11 21:15:11 +00:00
  • aee39b2847 - the "mini" column labels generated when using subqueries, which are to work around glitchy SQLite behavior that doesnt understand "foo.id" as equivalent to "id", are now only generated in the case that those named columns are selected from (part of [ticket:513]) - MS-SQL better detects when a query is a subquery and knows not to generate ORDER BY phrases for those [ticket:513] Mike Bayer 2007-04-11 20:55:27 +00:00
  • 95520005d5 - fix to many-to-many relationships targeting polymorphic mappers [ticket:533] Mike Bayer 2007-04-11 19:37:56 +00:00
  • a4b8112d6d will be 0.3.7 Mike Bayer 2007-04-10 19:18:28 +00:00
  • 73732b8a80 - some cleanup of reflection unit tests - removed silly behavior where sqlite would reflect UNIQUE indexes as part of the primary key (?!) - added __contains__ support to ColumnCollection; contains_column() method should be removed Mike Bayer 2007-04-04 23:06:39 +00:00
  • f4c17daacb explicit zero was failing for float cols Rick Morrison 2007-04-04 15:03:32 +00:00
  • 01683efe1d - slight tweak to raw execute() change to also support tuples, not just lists [ticket:523] Mike Bayer 2007-04-03 18:08:51 +00:00
  • 030ef1f0ef for #516, moved the "disconnect check" step out of pool and back into base.py. dialects have is_disconnect() method now. simpler design which also puts control of the ultimate "execute" call back into the hands of the dialects. Mike Bayer 2007-04-03 16:06:06 +00:00
  • c416dad6c6 - merged the patch from #516 + fixes - improves the framework for auto-invalidation of connections that have lost their underlying database - the error catching/invalidate step is totally moved to the connection pool. - added better condition checking for do_rollback() and do_commit() including SQLError excepetion wrapping Mike Bayer 2007-04-02 22:03:06 +00:00
  • cdceb3c371 - merged the "execcontext" branch, refactors engine/dialect codepaths - much more functionality moved into ExecutionContext, which impacted the API used by dialects to some degree - ResultProxy and subclasses now designed sanely - merged patch for #522, Unicode subclasses String directly, MSNVarchar implements for MS-SQL, removed MSUnicode. - String moves its "VARCHAR"/"TEXT" switchy thing into "get_search_list()" function, which VARCHAR and CHAR can override to not return TEXT in any case (didnt do the latter yet) - implements server side cursors for postgres, unit tests, #514 - includes overhaul of dbapi import strategy #480, all dbapi importing happens in dialect method "dbapi()", is only called inside of create_engine() for default and threadlocal strategies. Dialect subclasses have a datamember "dbapi" referencing the loaded module which may be None. - added "mock" engine strategy, doesnt require DBAPI module and gives you a "Connecition" which just sends all executes to a callable. can be used to create string output of create_all()/drop_all(). Mike Bayer 2007-04-02 21:36:11 +00:00
  • 8607de3159 latest #214 fixups Mike Bayer 2007-03-31 23:49:57 +00:00
  • 849ba3d620 - query strings in unicode URLs get keys encoded to ascii for **kwargs compat Mike Bayer 2007-03-30 15:49:30 +00:00
  • dab9abf789 thank you, SVN, for being completely idiotic and non-intutive. rolling back incorrect checkin to trunk Mike Bayer 2007-03-30 00:01:09 +00:00
  • 6b7bd8fb15 current progress with exec branch Mike Bayer 2007-03-29 23:57:22 +00:00
  • 740733f410 - corresponding to label/bindparam name generataion, eager loaders generate deterministic names for the aliases they create using md5 hashes. Mike Bayer 2007-03-29 00:56:34 +00:00
  • c622b0f59d added example for expressions in updates Mike Bayer 2007-03-28 23:44:13 +00:00
  • 4960e4947c ordering adjustments Mike Bayer 2007-03-28 23:38:28 +00:00
  • e9bbf54b71 added keys() to ColumnParameters, needed for setbindparamsizes traversal Mike Bayer 2007-03-28 23:30:22 +00:00
  • c13846c6b6 - sending None as an argument to func.<something> will produce an argument of NULL Mike Bayer 2007-03-28 23:18:04 +00:00
  • e064aaff14 unit test fix, same child object was being attached to two parents in a one-to-many which produced inconsistent results Mike Bayer 2007-03-28 22:57:00 +00:00
  • 2c49d8d3a4 better explicit PK insert checking Rick Morrison 2007-03-28 22:32:23 +00:00
  • f72bb35718 Change to ParameterClause object change New syntax for adodbapi connection string with port Rick Morrison 2007-03-28 19:13:03 +00:00
  • 5df24224ca error raised if trying to auto-join on a self referential Mike Bayer 2007-03-28 17:48:02 +00:00
  • e7da05f64e added "supports_unicode_statements()" step to dialect/execute_raw so that DB's like oracle can opt out of unicode statement strings Mike Bayer 2007-03-28 15:53:18 +00:00
  • e0b638a704 - column label and bind param "truncation" also generate deterministic names now, based on their ordering within the full statement being compiled. this means the same statement will produce the same string across application restarts and allowing DB query plan caching to work better. - cleanup to sql.ClauseParameters since it was just falling apart, API made more explicit - many unit test tweaks to adjust for bind params not being "pre" truncated, changes to ClauseParameters Mike Bayer 2007-03-28 07:19:14 +00:00
  • ccbcbda43e added label truncation for bind param names which was lost in the previous related commit. added more tests plus test for column targeting with text() clause. Mike Bayer 2007-03-28 01:39:58 +00:00
  • d7c0daf1ec added LONG->OracleText reflection mapping [ticket:393] Mike Bayer 2007-03-28 00:34:25 +00:00
  • cebb673af1 some more docstring patches for [ticket:214] Mike Bayer 2007-03-28 00:23:39 +00:00
  • 0491452799 - fix for fetchmany() "size" argument being positional in most dbapis [ticket:505] Mike Bayer 2007-03-28 00:09:55 +00:00
  • de4c25cd02 - fixes [ticket:185], join object determines primary key and removes columns that are FK's to other columns in the primary key collection. - removed workaround code from query.py get() - removed obsolete inheritance test from mapper - added new get() test to inheritance.py for this particular issue - ColumnCollection has nicer string method Mike Bayer 2007-03-27 22:06:36 +00:00
  • 2fed265b95 - some logging cleanup - added 'encodedname' prop to a few ClauseElements to aid logging Mike Bayer 2007-03-27 21:01:32 +00:00
  • 32440f2b3b - preliminary support for unicode table and column names added. Mike Bayer 2007-03-27 16:04:34 +00:00
  • 363405aa99 msssql: more unit tests now pass Rick Morrison 2007-03-27 05:07:10 +00:00
  • 7300b198b9 - improved/fixed custom collection classes when giving it "set"/ "sets.Set" classes or subclasses (was still looking for append() methods on them during lazy loads) - moved CustomCollectionsTest from unitofwork to relationships - added more custom collections test to attributes module Mike Bayer 2007-03-26 19:59:39 +00:00
  • 748f9b9acf - column labels are now generated in the compilation phase, which means their lengths are dialect-dependent. So on oracle a label that gets truncated to 30 chars will go out to 63 characters on postgres. Also, the true labelname is always attached as the accessor on the parent Selectable so theres no need to be aware of the genrerated label names [ticket:512]. - ResultProxy column targeting is greatly simplified, and relies upon the ANSICompiler's column_labels map to translate the built-in label on a _ColumnClause (which is now considered to be a unique identifier of that column) to the label which was generated at compile time. - still need to put a baseline of ColumnClause targeting for ResultProxy objects that originated from a textual query. Mike Bayer 2007-03-24 19:24:27 +00:00
  • e07cf69def cleanup continued rel_0_3_6 Mike Bayer 2007-03-23 21:38:12 +00:00
  • f99e81fab6 various cleanup, docs and things, getting ready for 0.3.6 Mike Bayer 2007-03-23 21:33:24 +00:00
  • 41039f78e5 documenting generative methods on query Mike Bayer 2007-03-22 23:24:28 +00:00
  • 642cf728b5 - MetaData can bind to an engine either via "url" or "engine" kwargs to constructor, or by using connect() method. BoundMetaData is identical to MetaData except engine_or_url param is required. DynamicMetaData is the same and provides thread-local connections be default. Mike Bayer 2007-03-22 21:18:23 +00:00