Commit Graph

  • eac7ca356a dan's latest patch for session.identity_key() Mike Bayer 2007-03-22 20:54:52 +00:00
  • ce57c8c0d6 - CLOB type descends from TEXT so it goes to the dialect correctly - oracle CLOB has result value LOB handling Mike Bayer 2007-03-22 17:58:30 +00:00
  • 7a488faf07 - added explicit MSTimeStamp type which takes effect when using types.TIMESTAMP. Mike Bayer 2007-03-22 16:50:38 +00:00
  • cef652a2d6 - slightly better support for bind params as column clauses, either via bindparam() or via literal(), i.e. select([literal('foo')]) - removed "table" argument from column(). this does not add the column to the table anyway so was misleading. - Select _exportable_columns() only exports Selectable instances - Select uses _exportable_columns() when searching for engines instead of _raw_columns for similar reasons (non selectables have no engine) - _BindParamClause no longer has a _make_proxy(). its not a ColumnElement. - _Label detects underlying column element and will generate its own column()._make_proxy() if the element is not a ColumnElement. this allows a Label to be declared for nearly anything and it can export itself as a column on a containing Selectable. Mike Bayer 2007-03-21 20:43:34 +00:00
  • 5b2cc84aa8 contextual_connection() -> contextual_connect() [ticket:515] Mike Bayer 2007-03-20 23:29:31 +00:00
  • e918ea6898 the "tack on the leftover tasks at the end" step of the "circular dependency sort" makes a copy of those tasks with the circular_parent marked. this way the tasks do not iterate through their child items polymorphically, which is necessary because the "circular sort" stores individual subclass tasks separately (i.e. saving/deleting should not traverse polymorhically for those tasks) Mike Bayer 2007-03-20 15:27:34 +00:00
  • f6d48da9de - many-to-many table will be properly handled even for operations that occur on the "backref" side of the operation [ticket:249] Mike Bayer 2007-03-19 17:54:29 +00:00
  • 0a09256619 mssql: now passes still more unit tests, [ticket:481] Rick Morrison 2007-03-19 02:00:32 +00:00
  • 43b70fc86b - added db modules to genned docstrings - had to tweak out latest MS-SQL module change. cant do ImportErrors right now until module importing is moved to the connection phase across all dialects. - took out "his" from url docstrings - postgres doesnt do an import * Mike Bayer 2007-03-18 22:35:19 +00:00
  • 8f788f683b - check for tables in the primaryjoin/secondaryjoin that arent parent of parent/child mappers. dont include those clauses when looking for foreign_keys (which also takes care of remote_side). if those cols are present in foreign_keys, lazyloader makes binds out of them and tries to target those columns on the mapper, raising either the "conflicting column" error if they have the same name, or the "cant find column on mapping" if it has a unique name. added tests for both. Mike Bayer 2007-03-18 21:45:55 +00:00
  • 1c56142219 mssql: cleanup of module importing code; specifiable DB-API module; more explicit ordering of module preferences. [ticket:480] Rick Morrison 2007-03-18 17:14:10 +00:00
  • 1201de2eb5 mssql: optionally use VARCHAR(max) instead of TEXT. [ticket:509] Rick Morrison 2007-03-18 16:25:19 +00:00
  • 037ee9fbf8 - flush fixes on self-referential relationships that contain references to other instances outside of the cyclical chain, when the initial self-referential objects are not actually part of the flush Mike Bayer 2007-03-17 20:46:52 +00:00
  • 45c2e20983 css tag Mike Bayer 2007-03-17 16:58:12 +00:00
  • 229d2ee4e9 integrated docutils formatting into generated documentation; restructuredtext fixes throughout docstrings Mike Bayer 2007-03-17 16:49:45 +00:00
  • 4f63e40616 merged mako doc generation branch Mike Bayer 2007-03-17 15:14:53 +00:00
  • e5f16ff2c4 - added a catchall **kwargs to MSString, to help reflection of obscure types (like "varchar() binary" in MS 4.0) Mike Bayer 2007-03-16 01:48:28 +00:00
  • c249066dbf "alltests" runners call testbase.main(), which takes an optional suite, so that exit code is propigated Mike Bayer 2007-03-15 18:11:05 +00:00
  • 83244ec631 literals in PassiveDefault require text() Mike Bayer 2007-03-15 16:49:47 +00:00
  • 30b20e3c56 MSSQL now passes still more unit tests [ticket:481] Fix to null FLOAT fields in mssql-trusted.patch MSSQL: LIMIT with OFFSET now raises an error MSSQL: can now specify Windows authorization MSSQL: ignores seconds on DATE columns (DATE fix, part 1) Rick Morrison 2007-03-15 02:31:15 +00:00
  • bfbbb2afb1 fix CASE statement when else_ is zero Rick Morrison 2007-03-15 01:58:46 +00:00
  • a5bf257126 - eager loading will not "aliasize" "order by" clauses that were placed in the select statement by something other than the eager loader itself, to fix possibility of dupe columns as illustrated in [ticket:495]. however, this means you have to be more careful with the columns placed in the "order by" of Query.select(), that you have explicitly named them in your criterion (i.e. you cant rely on the eager loader adding them in for you) Mike Bayer 2007-03-14 23:48:07 +00:00
  • 485fb57fc7 - added a handy multi-use "identity_key()" method to Session, allowing the generation of identity keys for primary key values, instances, and rows, courtesy Daniel Miller Mike Bayer 2007-03-13 03:45:28 +00:00
  • f18f2f50cb some docs Mike Bayer 2007-03-13 02:45:40 +00:00
  • 0e058d4b6c some formatting Mike Bayer 2007-03-13 02:37:44 +00:00
  • 6a3c374b95 - for hackers, refactored the "visitor" system of ClauseElement and SchemaItem so that the traversal of items is controlled by the ClauseVisitor itself, using the method visitor.traverse(item). accept_visitor() methods can still be called directly but will not do any traversal of child items. ClauseElement/SchemaItem now have a configurable get_children() method to return the collection of child elements for each parent object. This allows the full traversal of items to be clear and unambiguous (as well as loggable), with an easy method of limiting a traversal (just pass flags which are picked up by appropriate get_children() methods). [ticket:501] - accept_schema_visitor() methods removed, replaced with get_children(schema_visitor=True) - various docstring/changelog cleanup/reformatting Mike Bayer 2007-03-11 20:52:02 +00:00
  • 320cb9b75f - oracle: - got binary working for any size input ! cx_oracle works fine, it was my fault as BINARY was being passed and not BLOB for setinputsizes (also unit tests werent even setting input sizes). - auto_setinputsizes defaults to True for Oracle, fixed cases where it improperly propigated bad types. Mike Bayer 2007-03-10 23:31:40 +00:00
  • dc2d085a75 - Query has add_entity() and add_column() generative methods. these will add the given mapper/class or ColumnElement to the query at compile time, and apply them to the instances method. the user is responsible for constructing reasonable join conditions (otherwise you can get full cartesian products). result set is the list of tuples, non-uniqued. - fixed multi-mapper instances() to pad out shorter results with None so zip() gets everything Mike Bayer 2007-03-10 03:41:55 +00:00
  • b2e04755cc - the full featureset of the SelectResults extension has been merged into a new set of methods available off of Query. These methods all provide "generative" behavior, whereby the Query is copied and a new one returned with additional criterion added. The new methods include: Mike Bayer 2007-03-10 02:49:12 +00:00
  • 585eacba01 cleanup of reversed Mike Bayer 2007-03-09 00:12:49 +00:00
  • c7a6d735ca - fixed usage of 2.4-only "reversed" in topological.py [ticket:506] Mike Bayer 2007-03-08 23:14:25 +00:00
  • 46b82976bf - fixed use_alter flag on ForeignKeyConstraint [ticket:503] Mike Bayer 2007-03-07 18:05:39 +00:00
  • 231acabf72 - options() method on SelectResults now implemented "generatively" like the rest of the SelectResults methods [ticket:472] Mike Bayer 2007-03-07 01:31:41 +00:00
  • 08e0bd1aa7 need an "alias()" on map to a select Mike Bayer 2007-03-06 18:39:27 +00:00
  • b401cd2ea7 decorated ImportError thrown when the <database>:// module isnt found Mike Bayer 2007-03-06 17:17:27 +00:00
  • 7b43cd5092 added "enable_typechecks=True" flag on relation so the new type check from #500 can be disabled, since people are going to want to disable it. Mike Bayer 2007-03-06 16:47:43 +00:00
  • 9154e1eff1 - added concept of 'require_embedded' to corresponding_column. requires that the target column be present in a sub-element of the target selectable. - embedded logic above more appropriate for ClauseAdapter functionality since its trying to "pull up" clauses that represent columns within a larger union up to the level of the union itself. - the "direction" test against the "foreign_keys" collection apparently works for an exact "column 'x' is present in the collection", no proxy relationships needed. fixes the case of relating a selectable/alias to one of its underlying tables, probably fixes other scenarios Mike Bayer 2007-03-05 23:08:52 +00:00
  • 7693a680ed - put an aggressive check for "flushing object A with a collection of B's, but you put a C in the collection" error condition - **even if C is a subclass of B**, unless B's mapper loads polymorphically. Otherwise, the collection will later load a "B" which should be a "C" (since its not polymorphic) which breaks in bi-directional relationships (i.e. C has its A, but A's backref will lazyload it as a different instance of type "B") [ticket:500] Mike Bayer 2007-03-05 05:12:09 +00:00
  • eb75392529 dont continue remote table if warning Mike Bayer 2007-03-04 18:09:43 +00:00
  • bc1cc72d89 "modernized" polymorph test, name change to "test_roundtrip" Mike Bayer 2007-03-03 21:25:44 +00:00
  • e736817a92 - bindparam() names are now repeatable! specify two distinct bindparam()s with the same name in a single statement, and the key will be shared. proper positional/named args translate at compile time. for the old behavior of "aliasing" bind parameters with conflicting names, specify "unique=True" - this option is still used internally for all the auto-genererated (value-based) bind parameters. Mike Bayer 2007-03-03 21:02:26 +00:00
  • c8a78834f5 cleanup; removed "separate foreign key" tests, polymorphic joined-table inheritance requires the same pk col name across tables; added additional polymorphic load assertions Mike Bayer 2007-03-03 20:24:13 +00:00
  • 2a77850707 - added "fold_equivalents" argument to Join.select(), which removes 'duplicate' columns from the resulting column clause that are known to be equivalent based on the join condition. this is of great usage when constructing subqueries of joins which Postgres complains about if duplicate column names are present. - added support to polymorphic stuff for more than one "equivalent column", when trying to target columns in the polymorphic union; this applies to multi-leveled inheritance - put above-two concepts together to get the abc_inheritance tests to work with postgres Mike Bayer 2007-03-02 21:22:14 +00:00
  • 7e2ae824a5 - use_labels flag on select() wont auto-create labels for literal text column elements, since we can make no assumptions about the text. to create labels for literal columns, you can say "somecol AS somelabel", or use literal_column("somecol").label("somelabel") - quoting wont occur for literal columns when they are "proxied" into the column collection for their selectable (is_literal flag is propigated) Mike Bayer 2007-03-01 20:14:17 +00:00
  • d94384253f added a unit test for nested session transactions Mike Bayer 2007-02-28 21:42:54 +00:00
  • 7970f8193e a generating testcase that tests a three-level inheritance chain (A->B->C) and all one-to-many and many-to-one relationships between all distinct A,B,C. still needs support for foreign key to parent table not the same col as the pk col Mike Bayer 2007-02-28 03:35:32 +00:00
  • e878ec167e this test works with both one to many and many to one, but i think its intended to be one-to-many Mike Bayer 2007-02-28 01:25:52 +00:00
  • ba5337982e - fixed function execution with explicit connections, when you dont explicitly say "select()" off the function, i.e. conn.execute(func.dosomething()) Mike Bayer 2007-02-27 19:04:43 +00:00
  • 962c22c9ed migrated (most) docstrings to pep-257 format, docstring generator using straight <pre> + trim() func for now. applies most of [ticket:214], compliemnts of Lele Gaifax Mike Bayer 2007-02-25 22:44:52 +00:00
  • 8fa3becd5f - more fixes to polymorphic relations, involving proper lazy-clause generation on many-to-one relationships to polymorphic mappers [ticket:493] Mike Bayer 2007-02-25 01:27:15 +00:00
  • abc9971544 fix typo Mike Bayer 2007-02-25 01:24:33 +00:00
  • 777037d46d - added "refresh-expire" cascade [ticket:492] Mike Bayer 2007-02-24 21:58:38 +00:00
  • 41802e102c - correlated subqueries work inside of ORDER BY, GROUP BY Mike Bayer 2007-02-24 00:17:08 +00:00
  • 736bc3bd51 - exists() becomes useable as a standalone selectable, not just in a WHERE clause Mike Bayer 2007-02-23 20:46:27 +00:00
  • f0b72859f9 - a full select() construct can be passed to query.select() (which worked anyway), but also query.selectfirst(), query.selectone() which will be used as is (i.e. no query is compiled). works similarly to sending the results to instances(). Mike Bayer 2007-02-22 22:59:51 +00:00
  • b59f4d1a4a restored sequence back, needed by PG for the unit test rel_0_3_5 Mike Bayer 2007-02-22 03:51:21 +00:00
  • 275640dc61 - added selectfirst(), selectfirst_by() to assign_mapper [ticket:467] Mike Bayer 2007-02-22 03:16:58 +00:00
  • 66623acb4b added collengths to use varchar instead of TEXT Mike Bayer 2007-02-22 03:13:43 +00:00
  • 67baacf01b - removed deprecated method of specifying custom collections on classes; you must now use the "collection_class" option. the old way was beginning to produce conflicts when people used assign_mapper(), which now patches an "options" method, in conjunction with a relationship named "options". (relationships take precedence over monkeypatched assign_mapper methods). Mike Bayer 2007-02-21 21:55:45 +00:00
  • 8d45eb6af0 formatting fix Mike Bayer 2007-02-21 21:35:51 +00:00
  • f803cbc63d formatting/cleanup Mike Bayer 2007-02-21 21:34:40 +00:00
  • e5c06951dd - eager relation loading bug fixed for eager relation on multiple descendant classes [ticket:486] Mike Bayer 2007-02-21 20:57:31 +00:00
  • 6834dcac1c Tested with pymssql 0.8.0 mssql: added query_timeout, fixes for passing auto_insert in dburl Rick Morrison 2007-02-21 01:38:58 +00:00
  • bd2f52a7e3 fix to the fix for [ticket:454], prevent other mappers in a load operation from using the main extension option send to the query (i.e. mappers used for eager loads etc). Mike Bayer 2007-02-20 18:01:16 +00:00
  • fa46e0ec66 - added "contains_alias()" option for result set mapping to an alias of the mapped table Mike Bayer 2007-02-20 02:12:46 +00:00
  • ae000fb550 - added "alias" argument to contains_eager(). use it to specify the string name or Alias instance of an alias used in the query for the eagerly loaded child items. easier to use than "decorator" Mike Bayer 2007-02-20 01:04:07 +00:00
  • eb311db5ec - moved SynonymProperty to interfaces, since its more generalized and synonym-aware operations take place without knowning so much about properties - mapper options like eagerload(), lazyload(), deferred(), will work for "synonym()" relationships [ticket:485] Mike Bayer 2007-02-20 00:09:37 +00:00
  • 0911d4a61e Rick Morrison 2007-02-19 19:03:33 +00:00
  • f3055fe4ac removed not-always-applicable check for "polymorphic_identity" Mike Bayer 2007-02-19 07:06:38 +00:00
  • 07c12d6738 - documented foreign_keys argument - 0.3.5 markers Mike Bayer 2007-02-19 04:46:08 +00:00
  • 6458a670c0 reverted unit test change Mike Bayer 2007-02-19 04:36:18 +00:00
  • b880049b50 - oracle issues a log warning when a related table cant be reflected due to certain permission errors [ticket:363] Mike Bayer 2007-02-19 04:28:51 +00:00
  • e7ac502b81 Completed previously missed patches from tickets 422 and 415 get unit tests to work with pyodbc [ticket:481] fix blank password on adodbapi [ticket:371] Rick Morrison 2007-02-18 19:43:05 +00:00
  • 3b3d94c9ab - modified patch for [ticket:379] - detecting synonyms, dblinks in reflection. test passes except for DBLINK which I cannot get to work on my oracle-xe database. - probable (also untested) fix for [ticket:363], better error message if we get None back for remote table information (which is due to rights) Mike Bayer 2007-02-17 23:40:31 +00:00
  • 2019974544 - fixes to tometadata() operation to propigate Constraints at column and table level Mike Bayer 2007-02-17 19:08:36 +00:00
  • b5bb6bb06d - fixed generation of CHECK constraints on columns [ticket:464] Mike Bayer 2007-02-17 03:46:13 +00:00
  • f4b1484ff5 - extension() query option propigates to Mapper._instance() method so that all loading-related methods get called [ticket:454] Mike Bayer 2007-02-17 03:14:36 +00:00
  • 3e5eeb064a - moved change for [ticket:466] to ansisql, since thats the syntax for all databases. the change is across all dialects, not just oracle Mike Bayer 2007-02-17 02:39:28 +00:00
  • 123498ee1f added PGInet type [ticket:444] Mike Bayer 2007-02-17 02:36:11 +00:00
  • 225e51a796 - added a Sequence to the unicode test tables to help Oracle - fixed named PrimaryKeyConstraint generation on oracle [ticket:466] courtesy andrija at gmail Mike Bayer 2007-02-17 02:31:56 +00:00
  • ffd0e0e181 [ticket:463] fix to OrderedSet Mike Bayer 2007-02-17 02:23:10 +00:00
  • 8cf4e15c92 commented out ImportError for now; will issue new ticket for handling dialect importerrors more effectively Mike Bayer 2007-02-17 01:49:52 +00:00
  • 5f83c55fc7 - fixed oracle list of binary types to check for their presence in the module (such as BFILE not in all versions of cx_Oracle) - removed oracle-handicap from binary unit test to test [ticket:435] fix, added an extra row containing None Mike Bayer 2007-02-17 01:18:54 +00:00
  • 67f020f69c - small fix to BoundMetaData to accept unicode or string URLs Mike Bayer 2007-02-17 00:09:48 +00:00
  • f4c7027950 better MSSSQL support for implicit sequences and auto-insert, ticket 415 Rick Morrison 2007-02-16 17:26:47 +00:00
  • fc53d244b7 Fix Fix for adodbapi bug introduced by ticket 419 Rick Morrison 2007-02-16 17:12:49 +00:00
  • c3e6960e03 Func rewrite for better unittest compatibility Simplified transaction handling for pymssql Rick Morrison 2007-02-16 17:06:17 +00:00
  • d1319e62b2 dont do RAWTOHEX on None Mike Bayer 2007-02-15 17:19:13 +00:00
  • 40a29d198a - some cleanup to the unitofwork test suite (needs much more) - fixed relationship deletion error when one-to-many child item is moved to a new parent in a single unit of work [ticket:478] Mike Bayer 2007-02-15 02:07:06 +00:00
  • 66a74c136f revert old unittest patch for MSSQL Rick Morrison 2007-02-15 00:22:07 +00:00
  • d796ed2f8e MSSSQL is now passing unit tests (well, some) thanks to Paul Johnston Rick Morrison 2007-02-15 00:13:01 +00:00
  • d4326560c3 run-time selectable DB-API modules for mssql [ticket:419] preliminary support for pyodbc Rick Morrison 2007-02-14 23:58:51 +00:00
  • cd2ea14a78 Fix for ticket 473 Rick Morrison 2007-02-14 23:36:56 +00:00
  • 8fd07eaafa Fix query.get for MSSQL tables with schema specified Rick Morrison 2007-02-14 23:16:22 +00:00
  • 902cd69528 - fixed relationship deletion error where parent/child with a single column as PK/FK on the child would raise a "blank out the primary key" error, if manually deleted or "delete" cascade without "delete-orphan" was used Mike Bayer 2007-02-14 02:00:49 +00:00
  • e7aaeb2852 - fixed argument passing to straight textual execute() on engine, connection. can handle *args or a list instance for positional, **kwargs or a dict instance for named args, or a list of list or dicts to invoke executemany() Mike Bayer 2007-02-13 22:53:05 +00:00
  • 238e8620ee - fix for very large topological sorts, courtesy ants.aasma at gmail [ticket:423] Mike Bayer 2007-02-13 01:25:51 +00:00
  • 8cc35f6d65 - added support for py2.5 "with" statement with SessionTransaction [ticket:468] Mike Bayer 2007-02-10 23:45:08 +00:00
  • ace7e3a4f1 - added options() method to SelectResults, equivalent to query.options() [ticket:472] Mike Bayer 2007-02-10 23:41:56 +00:00
  • 1da55184e5 - implemented foreign_keys argument on relation() [ticket:385] - PropertyLoader figures out accurate remote_side collection based on foreign_keys, legacy foreignkey, primary/secondaryjoin/polymorphic - reworked lazyloader, sync to work straight off foreign_keys/ remote_side collections Mike Bayer 2007-02-10 23:39:06 +00:00