Commit Graph

  • 154d0b0288 oops, double row echo removed Mike Bayer 2006-10-12 17:06:48 +00:00
  • 71c5570d86 added debug-level row echoing to RowProxy (moved from ResultProxy) Mike Bayer 2006-10-12 17:05:47 +00:00
  • c934ae44a8 - ResultProxy.fetchall() internally uses DBAPI fetchall() for better efficiency, added to mapper iteration as well (courtesy Michael Twomey) Mike Bayer 2006-10-12 17:02:12 +00:00
  • e16bfad407 - fixes to Date/Time (SLDate/SLTime) types; works as good as postgres now [ticket:335] Mike Bayer 2006-10-12 01:12:17 +00:00
  • 74b3c501ba _sort_tables uses local tables [ticket:322] Mike Bayer 2006-10-12 00:57:28 +00:00
  • f5cfa86e94 added PGBigInteger type Mike Bayer 2006-10-11 19:48:52 +00:00
  • 98f66013a9 remove unused set Mike Bayer 2006-10-08 22:05:26 +00:00
  • 35bb8f1f68 dont create dependency processor if viewonly=True Mike Bayer 2006-10-08 21:17:54 +00:00
  • aba46c4eee logging of syncrules Mike Bayer 2006-10-08 20:38:03 +00:00
  • f3cfde955c more adjustments to #321 Mike Bayer 2006-10-08 20:24:30 +00:00
  • 4f50685d0b add table name to save_obj log Mike Bayer 2006-10-08 20:05:37 +00:00
  • f6b766fb18 row-switch test should be per-instance, not per table per instance Mike Bayer 2006-10-08 19:56:29 +00:00
  • fa4e9782ea added correct insert ordering Mike Bayer 2006-10-08 19:38:56 +00:00
  • ef77cfa61b - mapper.save_obj() now functions across all mappers in its polymorphic series, UOWTask calls mapper appropriately in this manner - polymorphic mappers (i.e. using inheritance) now produces INSERT statements in order of tables across all inherited classes [ticket:321] Mike Bayer 2006-10-08 19:30:00 +00:00
  • b0ffcbc264 more fixup to self referential composite primary key mappings Mike Bayer 2006-10-08 03:16:38 +00:00
  • 8aa6a24fbb this test works better with session clears in between Mike Bayer 2006-10-08 02:51:30 +00:00
  • 51f16d1498 - the "foreign_key" attribute on Column and ColumnElement in general is deprecated, in favor of the "foreign_keys" list/set-based attribute, which takes into account multiple foreign keys on one column. "foreign_key" will return the first element in the "foreign_keys" list/set or None if the list is empty. - added a user test to the relationships test, testing various new things this change allows Mike Bayer 2006-10-08 02:46:40 +00:00
  • 758828ed54 assorted firebird fixes from Lele Gaifax Mike Bayer 2006-10-07 00:54:14 +00:00
  • 427baabc66 some cleanup Mike Bayer 2006-10-07 00:50:14 +00:00
  • e74bae4c3f improved exceptions for closed connections Mike Bayer 2006-10-07 00:49:44 +00:00
  • 702348b48f fix "no engine found" to raise explicit error, [ticket:326] Mike Bayer 2006-10-06 15:50:27 +00:00
  • 9400b4d6a2 rollback last change until we figure out how to check for engine without exception Mike Bayer 2006-10-06 15:38:12 +00:00
  • f7f1426dab better error message for unconnected DynamicMetaData [ticket:326] Mike Bayer 2006-10-06 15:34:08 +00:00
  • 24c29b9ae7 add compound-where example Jonathan Ellis 2006-10-05 16:27:33 +00:00
  • 8b1afef6e9 [ticket:324] Mike Bayer 2006-10-05 01:39:44 +00:00
  • f61cd50128 r/m sqlsoup.NoSuchTableError (SA proper takes care of that now) add sqlsoup.PKNotFoundError Jonathan Ellis 2006-10-04 22:03:15 +00:00
  • 2eac1481f3 continued cleanup Mike Bayer 2006-10-04 00:09:18 +00:00
  • 4c23534039 various cleanup etc. Mike Bayer 2006-10-04 00:00:22 +00:00
  • 6f1eb443a3 - "custom list classes" is now implemented via the "collection_class" keyword argument to relation(). the old way still works but is deprecated [ticket:212] Mike Bayer 2006-10-03 23:38:48 +00:00
  • bbd7c66056 - Function objects know what to do in a FROM clause now. their behavior should be the same, except now you can also do things like select(['*'], from_obj=[func.my_function()]) to get multiple columns from the result, or even use sql.column() constructs to name the return columns [ticket:172]. generally only postgres understands the syntax (and possibly oracle). Mike Bayer 2006-10-03 23:00:04 +00:00
  • ec6d7b3900 formatting fixup, etc. Mike Bayer 2006-10-03 22:56:54 +00:00
  • 73f145dc0e - added auto_setinputsizes=False to oracle dialect. if true, all executions will get setinputsizes called ahead of time. - some tweaks to the types unittest for oracle. oracle types still need lots more work. Mike Bayer 2006-10-03 21:47:48 +00:00
  • 08ea8fefa4 fixed super call Mike Bayer 2006-10-03 21:12:42 +00:00
  • c28bd008dd - removed "extension()" MapperOption - TypeEngine objects can report on DBAPI types - added set_input_sizes() to default dialect - oracle dialect gets Timestamp type added, may need to call set_input_sizes() to make it work with sub-second resolution [ticket:304] Mike Bayer 2006-10-03 21:08:14 +00:00
  • beff0e1e13 - merged loader_strategies branch into trunk. - this is a wide refactoring to "attribute loader" and "options" architectures. ColumnProperty and PropertyLoader define their loading behaivor via switchable "strategies", and MapperOptions no longer use mapper/property copying in order to function; they are instead propigated via QueryContext and SelectionContext objects at query/instnaces time. All of the copying of mappers and properties that was used to handle inheritance as well as options() has been removed and the structure of mappers and properties is much simpler and more clearly laid out. Mike Bayer 2006-10-03 16:47:14 +00:00
  • 7a2194e6c0 - added profiling to massave - adjusted the formatting for per-instance loggers to limit the number of loggers that get created in memory. Mike Bayer 2006-10-01 23:15:53 +00:00
  • 8d3a76aac9 adjustment to default timeout Mike Bayer 2006-10-01 23:14:27 +00:00
  • a96bbd36ab edits Mike Bayer 2006-10-01 16:53:19 +00:00
  • 6b69fe51de further str() on values that may come back as unicode Mike Bayer 2006-10-01 16:41:49 +00:00
  • d7d5eccd3f [ticket:318] has a user receiving back a unicode from a SHOW CREATE TABLE for some reason Mike Bayer 2006-10-01 16:35:45 +00:00
  • 8a1706b494 - fixed condition that occurred during reflection when a primary key column was explciitly overridden, where the PrimaryKeyConstraint would get both the reflected and the programmatic column doubled up Mike Bayer 2006-09-30 16:26:52 +00:00
  • 7242a617cf long changelist, adding some formatting Mike Bayer 2006-09-30 04:52:38 +00:00
  • d117a15020 - internal refactoring to mapper instances() method to use a SelectionContext object to track state during the operation. SLIGHT API BREAKAGE: the append_result() and populate_instances() methods on MapperExtension have a slightly different method signature now as a result of the change; hoping that these methods are not in widespread use as of yet. Mike Bayer 2006-09-30 04:40:15 +00:00
  • 3c19b41b60 - doc edit - i have no idea what a SynonymProperty was supposed to be for Mike Bayer 2006-09-30 03:10:21 +00:00
  • bd13d4ed2e - added some dependency logging - moved the ClauseSynchronizer compile from properties to dependency where its used Mike Bayer 2006-09-29 23:46:57 +00:00
  • a5f2a617da remove print statement Mike Bayer 2006-09-29 21:52:28 +00:00
  • 56e04db226 mass saver for profiling mem usage.... Mike Bayer 2006-09-29 20:50:13 +00:00
  • aa83929317 [ticket:309] Mike Bayer 2006-09-29 20:41:37 +00:00
  • a7644ef885 tweaks for mysql Mike Bayer 2006-09-29 20:28:43 +00:00
  • e2e952c2c3 fix PK redefinition Rick Morrison 2006-09-29 20:08:37 +00:00
  • 2ca81bb4c7 more edits Mike Bayer 2006-09-29 17:19:56 +00:00
  • 5dbab063fe rearrangement of docs for [ticket:310] Mike Bayer 2006-09-29 15:44:17 +00:00
  • 28b9012bf1 raise proper AttributeError Mike Bayer 2006-09-28 22:22:03 +00:00
  • 7a6e671199 - more adjustments to the eager load table finder to work with existing mappings against selects and query-created limit/offset subselects - added eagertest3 to orm/alltests.py Mike Bayer 2006-09-28 05:26:26 +00:00
  • 35fe9f7b58 the new eagerloading test suite mentioned in the previous commit Mike Bayer 2006-09-28 04:54:52 +00:00
  • 2fad6acf54 - added test suite to test improved from_obj/join behavior with Query/eagerloading/SelectResults - EagerLoader looks more carefully for the correct Table/Join/FromClause to bind its outer join onto - sqlite boolean datatype converts bind params from python booleans to integer - took out assertion raise from 'name' property of CompoundSelect Mike Bayer 2006-09-28 04:53:00 +00:00
  • 93caa5da2e decruftify Mike Bayer 2006-09-28 02:13:37 +00:00
  • 252d692c34 - pool will auto-close open cursors, or can be configured to raise an error instead - consolidated scalar() calls into ResultProxy scalar(), fixed ResultProxy scalar() to apply typing rules - general de-cruftification of ClauseElement/Compiled (yes i know theres crufty things everywhere) Mike Bayer 2006-09-28 01:46:16 +00:00
  • a81bd92d6e - specifying joins in the from_obj argument of query.select() will replace the main table of the query, if the table is somewhere within the given from_obj. this makes it possible to produce custom joins and outerjoins in queries without the main table getting added twice. [ticket:315] - added join_to and outerjoin_to transformative methods to SelectResults, to build up join/outerjoin conditions based on property names. also added select_from to explicitly set from_obj parameter. - factored "results" arrays from the mapper test suite and into the "tables" mapper - added "viewonly" param to docs Mike Bayer 2006-09-27 07:08:26 +00:00
  • df9c1a10b5 - added an automatic "row switch" feature to mapping, which will detect a pending instance/deleted instance pair with the same identity key and convert the INSERT/DELETE to a single UPDATE - "association" mappings simplified to take advantage of automatic "row switch" feature - fixes [ticket:311] Mike Bayer 2006-09-27 05:08:22 +00:00
  • b4112538db NCHAR and NVARCHAR support for MS-SQL. Patch from Kent Johnson Rick Morrison 2006-09-27 00:01:16 +00:00
  • 3db04a868c added "viewonly" flag to allow relations that dont affect flush() Mike Bayer 2006-09-26 22:38:35 +00:00
  • 1469040e24 Simplified MSSQL table reflection code added support for multi-column foreign keys Rick Morrison 2006-09-26 21:33:33 +00:00
  • f6594a32dc fix misspelled func calls Rick Morrison 2006-09-26 14:35:49 +00:00
  • 6ad6e099e8 commented out open cursor check, until resolution of [ticket:312] Mike Bayer 2006-09-26 14:23:45 +00:00
  • 9a36771499 made echo param more doc-friendly Mike Bayer 2006-09-25 16:29:51 +00:00
  • 46dcf1fa5d doc edits, moved object display in uowdumper to be hex, fixed test runner in parseconnect Mike Bayer 2006-09-25 16:22:32 +00:00
  • e812785c2d - logging is now implemented via standard python "logging" module. "echo" keyword parameters are still functional but set/unset log levels for their respective classes/instances. all logging can be controlled directly through the Python API by setting INFO and DEBUG levels for loggers in the "sqlalchemy" namespace. class-level logging is under "sqlalchemy.<module>.<classname>", instance-level logging under "sqlalchemy.<module>.<classname>.<hexid>". Test suite includes "--log-info" and "--log-debug" arguments which work independently of --verbose/--quiet. Logging added to orm to allow tracking of mapper configurations, row iteration fixes [ticket:229] [ticket:79] Mike Bayer 2006-09-24 23:59:22 +00:00
  • 7daa9e1d6a spelling fix Mike Bayer 2006-09-24 20:51:53 +00:00
  • 7354979c3d onupdate/ondelete fix Mike Bayer 2006-09-23 23:06:54 +00:00
  • 66a152bb77 descriptive error message when an executioncontext-requiring call is called off a ResultProxy which was created via literal statement execution and therefore does not have an execution context. Mike Bayer 2006-09-23 23:03:50 +00:00
  • 929d09a2ed added MSSQL changes Rick Morrison 2006-09-23 21:55:39 +00:00
  • facbaa3333 Fixes use of port for pymssql Introduces new auto_indentity_insert option Fixes bug #261 Rick Morrison 2006-09-23 21:42:34 +00:00
  • a786629351 added scalar() to ResultProxy Mike Bayer 2006-09-23 21:13:10 +00:00
  • 88e98c367e mutable flag Mike Bayer 2006-09-23 21:06:42 +00:00
  • 3e871d2755 - added "mutable" flag to PickleType, set to False to allow old (faster) behavior - fix attribute unit test - attributes have explicit flag for "mutable_scalars", propigated by ColumnProperty Mike Bayer 2006-09-23 21:02:33 +00:00
  • 7d74fc7785 - added "pickleable" module to test suite to have cPickle-compatible test objects - added copy_function, compare_function arguments to InstrumentedAttribute - added MutableType mixin, copy_value/compare_values methods to TypeEngine, PickleType - ColumnProperty and DeferredProperty propigate the TypeEngine copy/compare methods to the attribute instrumentation - cleanup of UnitOfWork, removed unused methods - UnitOfWork "dirty" list is calculated across the total collection of persistent objects when called, no longer has register_dirty. - attribute system can still report "modified" status fairly quickly, but does extra work for InstrumentedAttributes that have detected a "mutable" type where catching the __set__() event is not enough (i.e. PickleTypes) - attribute tracking modified to be more intelligent about detecting changes, particularly with mutable types. TypeEngine objects now take a greater role in defining how to compare two scalar instances, including the addition of a MutableType mixin which is implemented by PickleType. unit-of-work now tracks the "dirty" list as an expression of all persistent objects where the attribute manager detects changes. The basic issue thats fixed is detecting changes on PickleType objects, but also generalizes type handling and "modified" object checking to be more complete and extensible. Mike Bayer 2006-09-23 20:26:20 +00:00
  • 68e893d21a - connection pool tracks open cursors and raises an error if connection is returned to pool with cursors still opened. fixes issues with MySQL, others Mike Bayer 2006-09-23 20:18:41 +00:00
  • 372a8d76a6 - added autoincrement=True to Column; will disable schema generation of SERIAL/AUTO_INCREMENT/identity seq for postgres/mysql/mssql if explicitly set to False. #303 Mike Bayer 2006-09-23 17:21:56 +00:00
  • 9047fab83b remove delete-orphan cascade from self referential mappers Mike Bayer 2006-09-23 16:37:43 +00:00
  • f6baed941d - fixed unfortunate mutating-dictionary glitch from previous checkin - added "batch=True" flag to mapper; if False, save_obj will fully save one object at a time including calls to before_XXXX and after_XXXX Mike Bayer 2006-09-23 00:06:10 +00:00
  • 2e6a25f479 future log lines Mike Bayer 2006-09-22 23:04:40 +00:00
  • 5b99ac8fc1 fix to reset_class_managed to look at noninherited attributes only; an artifact of compilation brought this up Mike Bayer 2006-09-22 22:55:10 +00:00
  • 8f540ba992 - fix to deferred group loading Mike Bayer 2006-09-22 20:14:42 +00:00
  • d407289e41 - ForeignKey reports better error message for column not found - change in verbiage when join conditions are figured out (and fail) Mike Bayer 2006-09-22 17:10:53 +00:00
  • 8f41fed5a2 - moved selectresults test from orm to ext package - renamed objectstore test suite to unitofwork - added additional "eagerdegrade" tests to mapper, to test fixes from #308 Mike Bayer 2006-09-22 00:33:44 +00:00
  • b986e0b517 - adjustments to eager loading so that its "eager chain" is kept separate from the normal mapper setup, thereby preventing conflicts with lazy loader operation, fixes [ticket:308] Mike Bayer 2006-09-21 20:26:33 +00:00
  • 887fdc87ef - BooleanExpression includes new "negate" argument to specify the appropriate negation operator if one is available. - calling a negation on an "IN" or "IS" clause will result in "NOT IN", "IS NOT" (as opposed to NOT (x IN y)). Mike Bayer 2006-09-21 17:15:33 +00:00
  • 399865aad0 case sensitive function seems to return a string in some cases Mike Bayer 2006-09-21 17:12:35 +00:00
  • 3e94bbdba8 check for mapper or class, raise exception otherwise [ticket:305] Mike Bayer 2006-09-20 00:26:38 +00:00
  • 0044c26368 - post_update behavior improved; does a better job at not updating too many rows, updates only required columns [ticket:208] Mike Bayer 2006-09-19 17:49:51 +00:00
  • 5c1e1c28da no SERIAL for smallinteger columns Mike Bayer 2006-09-19 01:37:14 +00:00
  • 0ecde01dd0 no KeyError if url params not provided Mike Bayer 2006-09-19 01:21:39 +00:00
  • cc88f1e8c3 - added an implicit close() on the cursor in ResultProxy when the result closes - added scalar() method to ComposedSQLEngine Mike Bayer 2006-09-14 16:45:46 +00:00
  • 3dd5d834ad added extract() function to sql dialect Mike Bayer 2006-09-14 16:41:18 +00:00
  • b8474a4da8 moved "c.name" to "c.key" for processing defaults since bind params use column key Mike Bayer 2006-09-12 21:44:17 +00:00
  • a88e4c9a2b - fixed bug where Connection wouldnt lose its Transaction after commit/rollback Mike Bayer 2006-09-12 20:06:42 +00:00
  • 8a3cfd2ddd removed lockmode from get_by Mike Bayer 2006-09-11 03:17:25 +00:00
  • 5157ce1658 sqlite doesnt support FOR UPDATE Mike Bayer 2006-09-11 00:23:48 +00:00
  • 13aa802836 ConcurrentModificationExecption Mike Bayer 2006-09-11 00:23:31 +00:00