Commit Graph

  • 37c762622c added some __repr__ functionality Mike Bayer 2006-01-08 19:02:26 +00:00
  • 23b7448075 sqlite/postgres reflection will properly add foreign keys added append_item() method to column to work similarly to table.append_item(), used to append foreign keys to the column (required in mysql) appending new foreign keys will properly replace the old one, so explicitly appending foreign keys to tables will replace those loaded via table reflection (instead of doubling them up) Mike Bayer 2006-01-08 18:11:52 +00:00
  • 4c50fd22ed added count func to mapper Mike Bayer 2006-01-08 07:24:33 +00:00
  • d2d181b6c8 added count() to table, from objects Mike Bayer 2006-01-08 07:12:19 +00:00
  • 2eb45ceba3 added the README to the description Mike Bayer 2006-01-08 07:12:04 +00:00
  • 976b55b08c key/value params on execute() are based off the from objects, not the select list Mike Bayer 2006-01-08 07:11:51 +00:00
  • 66b5aee37c mit license Mike Bayer 2006-01-08 04:16:19 +00:00
  • d7cb91284f removed 'primarytable' keyword argument Mike Bayer 2006-01-08 01:35:56 +00:00
  • e8a90dc0a1 small adjust after mapper/sql overhaul Mike Bayer 2006-01-08 01:35:29 +00:00
  • 4bc49f9976 remove method on HashSet Mike Bayer 2006-01-08 01:34:45 +00:00
  • 77a11675bb added 'import_instance' to properly deal with out-of-imap objects, added assertion upon commit that all mapped objects are properly present in the identity map Mike Bayer 2006-01-08 01:34:13 +00:00
  • a4477a53bb modified 'primarytable' idea and 'inheritance' to work better with improved relational algrebra stuff Mike Bayer 2006-01-08 01:31:23 +00:00
  • 0e8fc7abc2 unit tests to test column/pk/fk exports on relational objects Mike Bayer 2006-01-08 01:30:03 +00:00
  • 64147f5743 moved 'float' test into types test, renamed typetest to overrride test Mike Bayer 2006-01-08 01:28:49 +00:00
  • ccabafde3f misc commenty type stuff Mike Bayer 2006-01-08 01:27:04 +00:00
  • 113398519a improvements to relational algrebra of Alias, Select, Join objects, so that they all report their column lists, primary key, foreign key lists consistently and so that ForeignKey objects can line up tables against relational objects Mike Bayer 2006-01-08 01:26:47 +00:00
  • 8efb6a418b testing backref/lazyload uses mapper.get() Mike Bayer 2006-01-05 05:47:33 +00:00
  • d43cb6dd55 mapper - pks_by_table should store keys in order even tho we dont have a failure case lazyloader can lazyload using mapper.get() if it is appropriate, saves a lot of queries a few more assertions in properties in prep for relations against select statement mappers mapper get() clause is determined upfront to avoid re-generating it Mike Bayer 2006-01-05 05:47:02 +00:00
  • d5536dd30a added compare function to the more basic expression objects adding priamry_key/foreign_keys to selects, alias etc to increase their useability for relating them to tables improved _get_col_by_original to double-check the column it finds Mike Bayer 2006-01-05 05:44:10 +00:00
  • ef3c04aadb better exception catch Mike Bayer 2006-01-05 04:32:54 +00:00
  • 6ea7729bbb added support for foreign keys to work across schemas Mike Bayer 2006-01-05 04:00:21 +00:00
  • c55454e536 outerjoin onclause is optional Mike Bayer 2006-01-04 05:04:42 +00:00
  • e1a0869dff edits Mike Bayer 2006-01-04 05:04:26 +00:00
  • bc20e96f35 copyright->2005,2006 Mike Bayer 2006-01-03 00:49:54 +00:00
  • cc1cd920e0 cleanup to mapper/relation order_by parameter to be more consistently picked up down the chain of engine->mapper->select() documented mapperoption methods Mike Bayer 2006-01-03 00:40:40 +00:00
  • d6174283bc added binary unit tests moved datetest to the types module Mike Bayer 2006-01-03 00:36:45 +00:00
  • 1c49a55650 type objects pass engine around to get a hold of DBAPI type objects added dbapi.Binary creation to base BinaryType fixed MySQL binary type adjustment to Join._match_primaries to work better with self-referential table Mike Bayer 2006-01-03 00:36:16 +00:00
  • ad7938a8e0 remove debugging code Mike Bayer 2006-01-03 00:32:51 +00:00
  • c152cb32b3 trying to get pg1 date type to work, unsuccessful Mike Bayer 2006-01-03 00:32:39 +00:00
  • 8d7c9349b2 moved tables into examples so basic_tree could be simplified Mike Bayer 2006-01-03 00:30:37 +00:00
  • e0e7a37d05 new options, new examples Mike Bayer 2006-01-03 00:29:03 +00:00
  • b769988c9c column.label is now a function; fix byroot example, add 'default_label' accessor to columnimpl Mike Bayer 2006-01-02 05:45:37 +00:00
  • d1f05cbaa3 broke apart deafult ordering into oid or primary key. a DB that has no oids will have a None oid_column attribute. Mike Bayer 2006-01-02 05:40:37 +00:00
  • 0f7484094c order by oid -> order by *default_order_by() when called by mapper layer. - one layer of abstraction between the "oid" and default ordering Mike Bayer 2006-01-02 05:28:05 +00:00
  • 6980730e7d rowid->oid Mike Bayer 2006-01-02 05:22:00 +00:00
  • abf2895a78 changed mysql TIMESTAMP->DATETIME fixed up date unit test RowProxy __iter__ properly routes columns through type processing Mike Bayer 2006-01-02 04:06:57 +00:00
  • a54a34f8f1 factoring out mysql's rowid stuff since its down in the base engine class now Mike Bayer 2006-01-01 21:17:34 +00:00
  • 705f308452 rowid_column becomes more like the "order by column". 'default_ordering' flag sent to create_engine enables whether or not the rowid_column on a Table will be None or not. mappers/relations will by default use the rowid_column for ordering if its not None, else theres no default ordering. still should better define 'default_ordering'/'rowid_column' relationship since its a little kludgy. Mike Bayer 2006-01-01 21:08:22 +00:00
  • 943bb0b0e0 postgres oids say byebye by default, putting hooks in for engines to determine column defaults externally to it having a 'default' property, beefed up unittests to support inserts with/without defaults (will fix oracle unit tests too) Mike Bayer 2006-01-01 20:30:53 +00:00
  • 7228b4210c docdev Mike Bayer 2005-12-31 08:26:48 +00:00
  • da8595e84d added a hook in for 'binary operator', so sqlite can exchange '+' for '||' for a binary clause on a string Mike Bayer 2005-12-31 07:49:33 +00:00
  • 3b6f23145f shuffling to allow standard 'types' module in bindparam allows class-based type in added 'op' to comparemixin to allow custom operators Mike Bayer 2005-12-31 07:49:00 +00:00
  • f3e9dc2c8c fix to ansisql when it tries to determine param-based select clause that its only on a column-type object engine has settable 'paramstyle' attribute Mike Bayer 2005-12-31 07:13:18 +00:00
  • 7553b79721 license switch Mike Bayer 2005-12-31 03:23:12 +00:00
  • b3ce4c409a datetime introspection adjustment license switch Mike Bayer 2005-12-31 03:22:45 +00:00
  • f74910fbd6 some doc changes license move Mike Bayer 2005-12-31 03:21:14 +00:00
  • 5ceef4809d changes related to mapping against arbitrary selects, selects with labels or functions: Mike Bayer 2005-12-30 05:58:45 +00:00
  • 24bb21e8db some adjustments Mike Bayer 2005-12-30 00:49:49 +00:00
  • 232929e2ca roadmap->trailmap Mike Bayer 2005-12-30 00:29:59 +00:00
  • e20c4e6c8f roadmap->trailmap Mike Bayer 2005-12-30 00:29:46 +00:00
  • ee40adf5f8 reworking concept of column lists, "FromObject", "Selectable"; support for types to be propigated into boolean expressions; new label() function/method to make any column/literal/function/bind param into a "foo AS bar" clause, better support in ansisql for this concept; trying to get column list on a select() object to be Column and ColumnClause objects equally, working on mappers that map to those select() objects Mike Bayer 2005-12-30 00:27:46 +00:00
  • eb554a0444 adjustments for oracle sequences Mike Bayer 2005-12-30 00:24:03 +00:00
  • 4372eafaab catching up oracle to current, some tweaks to unittests to work better with oracle, allow different ordering of expected statements. unittests still dont work completely with oracle due to sequence columns in INSERT statements Mike Bayer 2005-12-30 00:23:01 +00:00
  • 1980102244 url change Mike Bayer 2005-12-29 00:43:08 +00:00
  • 9b93554cc0 updates for assignmapper, inherit_condition not required Mike Bayer 2005-12-29 00:42:47 +00:00
  • 4f43a2970c doc updates Mike Bayer 2005-12-29 00:42:16 +00:00
  • aded80c2ae moved _match_primaries from properties to sql.join, so its generalized to all SQL Mike Bayer 2005-12-29 00:42:00 +00:00
  • 38cb94232e removed assignmapper Mike Bayer 2005-12-29 00:41:24 +00:00
  • 0101da1da4 select_by/get_by get SQL clauses as well public-facing columns on the mapper populated based on given properties first, then table columns Mike Bayer 2005-12-29 00:31:56 +00:00
  • 35c7caba9a comments re: partial ordering, association dependencies license for topological Mike Bayer 2005-12-24 17:37:11 +00:00
  • 0407896b0a association object dependency glitches Mike Bayer 2005-12-24 16:54:53 +00:00
  • a941794a0d arg fix in create_engine Mike Bayer 2005-12-24 15:37:18 +00:00
  • 237bf917f7 the 'column' function is optional to point a property to a column when constructing a mapper can also be specified as a list to indicate overlap mapper columns come from its table, no need to add from given columns Mike Bayer 2005-12-24 15:33:47 +00:00
  • a7df1ed619 ColumnProperty -> column Mike Bayer 2005-12-24 15:23:14 +00:00
  • 648a47c824 docstrings Mike Bayer 2005-12-24 15:16:50 +00:00
  • 79843330ae mapper, when updating, only SET's those columns that have changed. this also allows "deferred" column properties to remain untouched by a save operation if they werent affected. Mike Bayer 2005-12-23 05:19:48 +00:00
  • e97211413e added defer and undefer mapper options Mike Bayer 2005-12-23 04:44:44 +00:00
  • 3ec0043ec1 remove debugging/comments Mike Bayer 2005-12-23 01:52:54 +00:00
  • 8111fda29f refactor/cleanup to mapper options methodology to allow for incoming defer/undefer options mapper/relations are stricter about class attributes and primary mapper - is_primary flag on relations fixed (wasnt working before). new primary mappers clear off old class attributes, secondary mappers insure that their property was set up by the primary; otherwise secondary mappers can add behavior to properties that are unmanaged by the primary mapper added "group" option to deferred loaders so a group of properties can be loaded at once mapper adds the "oid" column to the select list if "distinct" is set to true and its using the default "order by oid" ordering (mysql benefits from ansisql fix to only print out unique columns in the select list since its oid is the same as the pk column) fixed unittests to comply with stricter primary mapper rules Mike Bayer 2005-12-23 01:49:44 +00:00
  • dbd407d62a move execute parameter processing from sql.ClauseElement to engine.execute_compiled testbase gets "assert_sql_count" method, moves execution wrapping to pre_exec to accomodate engine change move _get_colparams from Insert/Update to ansisql since it applies to compilation ansisql also insures that select list for columns is unique, helps the mapper with the "distinct" keyword docstrings/cleanup Mike Bayer 2005-12-23 01:37:10 +00:00
  • d22f5edcae deferred property, checks for NULL primary key components and returns None Mike Bayer 2005-12-22 03:25:43 +00:00
  • 9ebac6151a added 'deferred' keyword, allowing deferred loading of a particular column Mike Bayer 2005-12-21 03:44:46 +00:00
  • af28188808 added "late WHERE" compilation to SELECT, adds where criterion based on extra bind parameters specified at compilation/execution time Mike Bayer 2005-12-21 02:36:54 +00:00
  • 3c62b09c5c fix to parameter thing in insert added unicodetype to __all__ for types Mike Bayer 2005-12-20 05:27:13 +00:00
  • ca7a4de712 added assign_mapper Mike Bayer 2005-12-20 05:26:29 +00:00
  • 7e512ec0fc more complete commit when object list is specified Mike Bayer 2005-12-20 05:26:13 +00:00
  • d66fed58cd fix to engine echo, random rundocs Mike Bayer 2005-12-20 05:25:30 +00:00
  • 3ccf340807 in_ clause uses bind params, for typing etc. Mike Bayer 2005-12-20 05:24:51 +00:00
  • 3362991b7c typemap needs lower case keys since result set metadata is not always case-sensitive (like in oracle) Mike Bayer 2005-12-19 08:32:49 +00:00
  • 701e388037 need to do before_insert before populating the insert row Mike Bayer 2005-12-17 19:43:11 +00:00
  • 3e4b0d17a9 fix to oracle function select, users table in test should be non-sequence Mike Bayer 2005-12-17 19:35:00 +00:00
  • d51d1ccaac put an assertion in default test Mike Bayer 2005-12-17 18:50:06 +00:00
  • 40964f68a1 refactoring of execution path, defaults, and treatment of different paramstyles Mike Bayer 2005-12-17 02:49:47 +00:00
  • 5b4c585078 indent.. Mike Bayer 2005-12-16 08:26:58 +00:00
  • 2c82048f07 docstrings, who knew Mike Bayer 2005-12-16 08:26:28 +00:00
  • c46afcd8b6 manytomany test shows that mysql needs column lengths on string to be used as a primary key testbase simplified slightly, allowed by reorganiztion of engine's execution of compiled objects Mike Bayer 2005-12-16 07:19:29 +00:00
  • 6cdba110a4 factored "sequence" execution in postgres in oracle to be generalized to the SQLEngine, to also allow space for "defaults" that may be constants, python functions, or SQL functions/statements Sequence schema object extends from a more generic "Default" object ANSICompiled can convert positinal params back to a dictionary, but the whole issue of parameters and how the engine executes compiled objects with parameters should be revisited mysql has fixes for its "rowid_column" being hidden else it screws up some query construction, also will not use AUTOINCREMENT unless the column is Integer Mike Bayer 2005-12-16 07:18:27 +00:00
  • 1f30247e22 edits Mike Bayer 2005-12-16 05:42:54 +00:00
  • c649d2f03f small tweak to HistoryList to properly report "delete" success, new unit test added to manytomany Mike Bayer 2005-12-15 05:09:44 +00:00
  • 875b1b1954 doc edits Mike Bayer 2005-12-15 04:26:33 +00:00
  • 893ce77682 rethinking sequences model to allow any default values Mike Bayer 2005-12-15 04:25:59 +00:00
  • b7e5d114f5 added select_by, get_by, magic methods Mike Bayer 2005-12-14 05:45:49 +00:00
  • 3cd30fdc70 echo can now be False, True or 'debug'. result sets are printed only if echo is 'debug'. Mike Bayer 2005-12-12 01:56:42 +00:00
  • 83bc03b6d9 more combinations Mike Bayer 2005-12-12 01:46:39 +00:00
  • 8ed282c3c2 added 'order_by' property to mapper constructor added 'no_sort' property to mapper _compile method to disable all ordering mapper _compile will not use its internal order_by if the given statement has an orderby lazyloader order_by used standalone when loading via mapper Mike Bayer 2005-12-12 01:44:58 +00:00
  • 69ad2955bd build in 'backref' property argument Mike Bayer 2005-12-09 05:08:51 +00:00
  • ddf6713472 fixes to the previous checkin with distinct etc Mike Bayer 2005-12-08 03:31:07 +00:00
  • fa43b890bd some enhancemnets to unions, unions and selects need to be more commonly derived, also more tweaks to mapper eager query compilation involving distinct etc. Mike Bayer 2005-12-08 03:03:29 +00:00
  • e2c4d1cc58 more grueling unit tests involving limit, offset and distinct (and unions) Mike Bayer 2005-12-08 03:02:33 +00:00
  • bbda66b73b wording change Mike Bayer 2005-12-07 04:21:38 +00:00