Commit Graph

  • c858ba70b1 reorganized SingletonThreadPool to return distinct connections in the same thread; use_threadlocal behavior is now switchable Mike Bayer 2006-03-16 19:09:53 +00:00
  • 0fb425ac1f added txt2myt.py to the genhtml/runhtml scripts, added exception if required modules arent found. edited tutorial.txt, added particles, etc. added clue that firebird might be supported to dbengine.myt Mike Bayer 2006-03-16 19:08:35 +00:00
  • 49064f9b1e J. Ellis' "Simple" ORM module...for Spyce ! (and others...) Mike Bayer 2006-03-16 17:48:51 +00:00
  • 33e30aacc3 Tutorial draft (not finished) and documentation framework improvements Alexey Shamrin 2006-03-15 13:39:11 +00:00
  • 7f98b58c87 added unique_connection() method to engine, connection pool to return a connection that is not part of the thread-local context or any current transaction Mike Bayer 2006-03-14 19:51:03 +00:00
  • bbf9f191ec fixed attributes bug where if an object is committed, its lazy-loaded list got blown away if it hadnt been loaded Mike Bayer 2006-03-14 16:56:05 +00:00
  • fc43d50cec formatting... Mike Bayer 2006-03-14 16:49:15 +00:00
  • a9f83cf3a6 removed redundant is_dirty function Mike Bayer 2006-03-14 16:24:12 +00:00
  • c081749aa6 more notes, docs rel_0_1_4 Mike Bayer 2006-03-13 17:32:13 +00:00
  • c5bc99b8cb tweak Mike Bayer 2006-03-13 17:18:03 +00:00
  • ae15f93f8d added scalar subqueries within the column clause of another select Mike Bayer 2006-03-13 17:16:52 +00:00
  • 989f77bc4b Fix docstring and exception message in selectone_by Alexey Shamrin 2006-03-13 07:16:53 +00:00
  • 1e5495943b Minor typo: encode and decode are methods. Alexey Shamrin 2006-03-13 07:05:00 +00:00
  • eebf468b35 Fix typos, closing #89, #91, #92 Alexey Shamrin 2006-03-13 06:51:47 +00:00
  • 16d21f6401 added selectfirst_by/selectone_by, selectone throws exception if more than one row returned, courtesy J.Ellis Mike Bayer 2006-03-13 02:53:51 +00:00
  • 4ab782cb0e tweak to get_direction, rolls back a comparison of "foreigntable" to "parent"/"mapper" table to be more constrained. this change was originally in [changeset:1101] to help out the polymorph example but it now works without it. the change breaks the Post/Comment relationship in the ZBlog demo since the Post mapper has the comments table inside of it (also with no workaround). Mike Bayer 2006-03-13 02:39:52 +00:00
  • 479903bebf caveat Mike Bayer 2006-03-13 02:04:13 +00:00
  • 1fc3d22655 oracle is requiring dictionary params to be in a clean dict, added conversion some fixes to unit tests Mike Bayer 2006-03-13 02:00:21 +00:00
  • a579e8f687 small tweak to select in order to fix [ticket:112]...the exported columns when doing select on a select() will be the column names, not the keys. this is with selects that have use_labels=False. which makes sense since using the "key" and not the name implies a label has to be used. Mike Bayer 2006-03-13 01:13:47 +00:00
  • 8690e2e303 tweak to mysql default test Mike Bayer 2006-03-13 01:06:33 +00:00
  • c5e1abc7f7 refactor to Compiled.get_params() to return new ClauseParameters object, a more intelligent bind parameter dictionary that does type conversions late and preserves the unconverted value; used to fix mappers not comparing correct value in post-fetch [ticket:110] removed pre_exec assertion from oracle/firebird regarding "check for sequence/primary key value" fix to Unicode type to check for null, fixes [ticket:109] create_engine() now uses genericized parameters; host/hostname, db/dbname/database, password/passwd, etc. for all engine connections fix to select([func(column)]) so that it creates a FROM clause to the column's table, fixes [ticket:111] doc updates for column defaults, indexes, connection pooling, engine params unit tests for the above bugfixes Mike Bayer 2006-03-13 00:24:54 +00:00
  • 2ce45d70c7 added expire() function + unit test fixes [ticket:95] Mike Bayer 2006-03-10 05:03:17 +00:00
  • d333168e00 utf-8 encoding is switchable at the engine level, ticket [ticket:101] Mike Bayer 2006-03-10 04:47:38 +00:00
  • 612205c3fd committed patch for MSDouble/tinyint from [ticket:106] Mike Bayer 2006-03-10 04:35:34 +00:00
  • 05737ef9fa added exception import Mike Bayer 2006-03-10 04:26:35 +00:00
  • be4373c92d HistoryArrayList checks internal list as a list or dict to clear it Mike Bayer 2006-03-10 04:22:59 +00:00
  • 3f620ec490 overhaul to types system, decoupled base type and engine-specific type into a composed pattern instead of goofy inheritance....gets rid of TypeDecorator (now a no-op) and enables all inhertance Mike Bayer 2006-03-09 18:30:27 +00:00
  • 5207bd4c52 fixed assocaition example Mike Bayer 2006-03-09 15:54:44 +00:00
  • b5060e88ff added 'noninherited table' prop to mapper indicating the "lead" table, in the case of inheritance. relations now create priamry/secondary joins against that lead table. if you want to create it against an inherited table, use explicit join conditions. added 'correlate' argument to CompoundSelect to get polymorph example working again. Mike Bayer 2006-03-09 00:24:15 +00:00
  • f057ed6136 a few tweaks to get table creates/reflection working table names are always reflected back as having lowercase names Mike Bayer 2006-03-08 22:32:55 +00:00
  • 6f3bd2b0d4 tweak to engine param.. Mike Bayer 2006-03-08 22:11:51 +00:00
  • ef6d2c0cf5 added identity() method to mapper, to help get the primary key of an instance. Mike Bayer 2006-03-08 21:55:33 +00:00
  • 376f4af318 added check to relation that will see if the same table is included between the primaryjoin and secondaryjoin, and raises a descriptive exception if so. Mike Bayer 2006-03-08 21:39:53 +00:00
  • 06b8c73ad5 serious overhaul to get eager loads to work inline with an inheriting mapper, when the inheritance/eager loads share the same table. mapper inheritance will also favor the columns from the child table over those of the parent table when assigning column values to object attributes. "correlated subqueries" require a flag "correlated=True" if they are in the FROM clause of another SELECT statement, and they want to be correlated. this flag is set by default when using an "exists" clause. Mike Bayer 2006-03-08 20:51:51 +00:00
  • 3aa4dd6f2b took erroneous 'count' off Alias Mike Bayer 2006-03-08 01:18:26 +00:00
  • e29da1e6ce took excess visit_func out, handled by ansisql compiler Mike Bayer 2006-03-07 05:46:36 +00:00
  • 72a8c3aa22 comment Mike Bayer 2006-03-07 03:17:34 +00:00
  • ab46fefce2 backref() func will also honor lazy=True/False Mike Bayer 2006-03-07 03:16:10 +00:00
  • 55ad2dc22a added backref() function, allows the creation of a backref where you also send keyword arguments that will be placed on the relation Mike Bayer 2006-03-07 03:14:08 +00:00
  • 2d596b61c0 checking in patch for column labels limit at 30 chars...what the heck Mike Bayer 2006-03-06 23:15:47 +00:00
  • 97b1c3a59a patch on index create syntax to fix [ticket:90] so schema name gets included Mike Bayer 2006-03-06 19:09:30 +00:00
  • 32aa76601d fixed bug in eager loading on a many-to-one [ticket:96], added the ticket tests as a unit test eagerload2. got eagerload1 to be a unit test also. Mike Bayer 2006-03-06 19:06:06 +00:00
  • 34cd446912 sqlite likes OFFSET with LIMIT else its buggy Mike Bayer 2006-03-06 17:14:50 +00:00
  • 1644a44628 a mapper with inheritance will place itself as "dependent" on the inherited mapper; even though this is not usually needed, it allows certain exotic combinations of mapper setups to work (i.e. the one in the polymorph example) Mike Bayer 2006-03-06 03:10:46 +00:00
  • a0079b6831 added new 'polymorphic' example. still trying to understand it :) . fixes to relation to enable it to locate "direction" more consistently with inheritance relationships more tweaks to parenthesizing subqueries, unions, etc. Mike Bayer 2006-03-06 02:27:13 +00:00
  • 51acad4b5b more tweak to compoundselect parenthesizing/subquery flag Mike Bayer 2006-03-06 01:17:12 +00:00
  • e59ad037b0 selects within a compound clause dont get parenthesis added fix to ColumnClause Mike Bayer 2006-03-06 01:09:03 +00:00
  • 02b9fa23ce delete tables in an inheritance rel. requires them in reverse Mike Bayer 2006-03-06 01:07:48 +00:00
  • d54b5eba74 added unittest for orm-persisted insert without a postfetch, tweak to engine to only signal postfetch if the passivedefault columns received None/NULL for their parameter (since they dont exec otherwise) Mike Bayer 2006-03-05 21:10:20 +00:00
  • 9446e490cb got mapper to receive the onupdates after updating an instance (also properly receives defaults on inserts)... Mike Bayer 2006-03-05 21:01:21 +00:00
  • 9c4f3c0480 got column onupdate working improvement to Function so that they can more easily be called standalone without having to throw them into a select(). Mike Bayer 2006-03-05 20:31:44 +00:00
  • c1d0c2dffc got column defaults to be executeable Mike Bayer 2006-03-04 20:23:37 +00:00
  • ffc8dfbdec added public-friendly setattr_clean and append_clean Mike Bayer 2006-03-04 20:20:23 +00:00
  • 3cacdfcc31 moved name to 'defaults', going to put more default stuff in Mike Bayer 2006-03-04 19:29:05 +00:00
  • 7c0ff2178b making sequences, column defaults independently executeable Mike Bayer 2006-03-04 19:26:23 +00:00
  • 7ad8cc9420 removed the dependency of ANSICompiler on SQLEngine. you can now make ANSICompilers and compile SQL with no engine at all. Mike Bayer 2006-03-04 18:53:35 +00:00
  • e9999c74e6 initial table reflection support courtesy Andrija Zaric Mike Bayer 2006-03-04 17:46:08 +00:00
  • 59ba54aeb8 changed default "none" parameters to check positional style Mike Bayer 2006-03-04 17:45:19 +00:00
  • 8f7aa2e89c firebird module initial checkin Mike Bayer 2006-03-04 17:41:19 +00:00
  • 730d4c2fcb mr. bangerts surprise paragraph rewrite demands strike again Mike Bayer 2006-03-04 00:29:09 +00:00
  • b87921caf3 rudimentary support for many-to-many relation. Still requires a separately defined intermediate table. jeff 2006-03-03 14:46:39 +00:00
  • 13710ae742 added util.Logger object with configurable thread/timestamp view Mike Bayer 2006-03-03 00:24:41 +00:00
  • 64792659d1 changed ENGINE to TYPE, for mysql 4 compatibility Mike Bayer 2006-03-02 17:38:37 +00:00
  • 9395ebdf70 formatting Mike Bayer 2006-03-02 02:11:51 +00:00
  • ecebb7cd87 its release time rel_0_1_3 Mike Bayer 2006-03-02 01:48:58 +00:00
  • 9985d21385 added objectstore.refresh(), including supporting changes in mapper, attributes, util Mike Bayer 2006-03-02 01:45:31 +00:00
  • 2d47f5a0b9 unicode Mike Bayer 2006-03-02 00:44:18 +00:00
  • cdfcf1ac6b module fix Mike Bayer 2006-03-02 00:42:26 +00:00
  • 413dcdf0f4 engine argument on tables optional test suite uses BaseProxyEngine as a base for the tester engine documented global proxy engine Mike Bayer 2006-03-02 00:38:16 +00:00
  • 834f2caec5 engine property allows polymorphic access to get_engine/set_engine Mike Bayer 2006-03-02 00:30:49 +00:00
  • 2391e6d67a got unicode to do None... Mike Bayer 2006-03-02 00:06:53 +00:00
  • fd8d4a45ea made SchemaEngine more prominent as the base of Table association BaseProxyEngine descends from SchemaEngine fixes to sqlite/postgres reflection to use the correct engine for table lookups Table engine can be none which will default to schema.default_engine (although its still positional for now, so still needs to be explicit to make room for Columns) __init__ sets default_engine to be a blank ProxyEngine fixes to test suite to allow --db proxy.<dbname> to really test proxyengine Mike Bayer 2006-03-01 21:20:59 +00:00
  • fd85670372 postgres leaves parenthesis off functions only for no-argument ANSI functions according to a list Mike Bayer 2006-03-01 19:43:07 +00:00
  • 371a6ca0de Modified mysql to not add AUTOINCREMENT to the first integer primary key if it is also a foreign key. Robert Leftwich 2006-03-01 09:37:45 +00:00
  • e8d8fa14b6 added schema support for postgres column defaults, fix for [ticket:88] Mike Bayer 2006-03-01 07:22:53 +00:00
  • 8d298fa06d update Mike Bayer 2006-03-01 00:11:25 +00:00
  • 7e4d55686c added convert_unicode flag to engine + unittest, does unicode in/out translation on all string/char values when set Mike Bayer 2006-03-01 00:08:01 +00:00
  • 3c6474481d small cleanup courtesy j.ellis Mike Bayer 2006-02-28 23:33:15 +00:00
  • a4ba9b5414 oid inits at compilation time/when needed again, added a unit test Mike Bayer 2006-02-28 23:18:43 +00:00
  • 7c1bb1f7a2 added items() method to RowProxy + unittest, courtesy dialtone@divmod.com Mike Bayer 2006-02-28 22:50:43 +00:00
  • af46b2fc5c took out that "TypeError" wrapper since it blows away stack traces and confuses users Mike Bayer 2006-02-28 02:36:09 +00:00
  • 58dc441d2d fixed an import Mike Bayer 2006-02-27 16:47:08 +00:00
  • 84a43c5cf9 Added code to make foreignkey on ActiveMapper accept a string and create the ForeignKey object on the fly. Also added ability to pass args and kwargs to Column constructor. ActiveMapper columns can have keyword args indexed and unique which will automatically create a index or a unique index. dburi in AutoConnectEngine can be a callable. jeff 2006-02-27 15:36:48 +00:00
  • d368fd17d9 updates Mike Bayer 2006-02-27 06:49:09 +00:00
  • 466e98a51a formatting Mike Bayer 2006-02-27 06:35:46 +00:00
  • 8a7fc55abc got mapper.using() to work, fixed push/pop mapper, custom session assignments Mike Bayer 2006-02-27 02:33:47 +00:00
  • 85bb0b550c doc update for post_update flag Mike Bayer 2006-02-27 01:11:56 +00:00
  • e5415ee9e1 more work on cycles, fleshed out tests for post_update, fix to the delete phase of a one-to-many post update closes [ticket:67] Mike Bayer 2006-02-27 01:05:01 +00:00
  • 60ed421299 imported casacde_mappers Mike Bayer 2006-02-26 23:40:15 +00:00
  • 271da5b885 Merge indexes [1047]:[1048] into trunk (for #6) Jason Pellerin 2006-02-26 22:57:46 +00:00
  • 6aae45aeaa implemented SyncRules for mapper with inheritance relationship, fixes [ticket:81] TableFinder becomes a list-implementing object (should probably create clauseutils or sqlutils for these little helper visitors) Mike Bayer 2006-02-26 22:23:01 +00:00
  • ae6a00ddf4 factored out "syncrule" logic to a separate package, so mapper will be able to make use of it as well as properties. also clarifies the "synchronization" idea Mike Bayer 2006-02-26 21:45:10 +00:00
  • 2959f5d844 place _instance_key on object only when objectstore finally register_clean's on it, to make room for more aggressive "identity map" assertion when modifying objects incoming from a result set Mike Bayer 2006-02-26 21:39:14 +00:00
  • c5fd3d1350 postgres wraps exec's in SQLError catch Mike Bayer 2006-02-26 20:15:02 +00:00
  • a9afbd8943 register_deleted/register_dirty perform pre-check before doing the "validate" operation to cut down on method overhaed Mike Bayer 2006-02-26 19:15:43 +00:00
  • 94d9a375f5 fixed exception import. check for objects being present in the identity map occurs not just at commit time but also when its logged as "dirty" or "deleted". Mike Bayer 2006-02-26 19:09:42 +00:00
  • 1750e5ad75 added test to illustrate wacky inhertitance/many-to-many thing Mike Bayer 2006-02-26 06:17:21 +00:00
  • 0e436bdbee adjustment to compile synchronizers which allows many-to-many synchronize to work even when one side of the relation has both tables in it (new unittest will be added to inheritance.py to show this...) Mike Bayer 2006-02-26 06:14:12 +00:00
  • 770ec1ce7a fixed ticket 72, where a copied clause was using the identical bind param object thereby screwing up a generated statement that included both the original clause and the copied clause, when positional parameters were used Mike Bayer 2006-02-26 02:25:42 +00:00
  • 6bdf9e7eb3 create() statements return the created object so they can be instantiated and create()'ed in one line Mike Bayer 2006-02-26 02:24:42 +00:00