summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/engine.py
Commit message (Collapse)AuthorAgeFilesLines
* merged 0.2 branch into trunk; 0.1 now in sqlalchemy/branches/rel_0_1Mike Bayer2006-05-251-878/+0
|
* added cgi parser for url key/value connect strings, towards [ticket:157]Mike Bayer2006-04-171-5/+3
|
* pool argument adjusts for DBProxy/PoolMike Bayer2006-04-071-3/+6
|
* mapper's querying facilities migrated to new query.Query() object, which can ↵Mike Bayer2006-04-061-0/+11
| | | | | | | | | receive session-specific context via the mapper.using() statement. reuslting object instances will be bound to this session, but query execution still handled by the SQLEngines implicit in the mapper's Table objects. session now propigates to the unitofwork UOWTransaction object, as well as mapper's save_obj/delete_obj via the UOWTransaction it receives. UOWTransaction explicitly calls the Session for the engine corresponding to each Mapper in the flush operation, although the Session does not yet affect the choice of engines used, and mapper save/delete is still using the Table's implicit SQLEngine. changed internal unitofwork commit() method to be called flush(). removed all references to 'engine' from mapper module, including adding insert/update specific SQLEngine methods such as last_inserted_ids, last_inserted_params, etc. to the returned ResultProxy so that Mapper need not know which SQLEngine was used for the execute. changes to unit tests, SelectResults to support the new Query object.
* moves the binding of a TypeEngine object from "schema/statement creation" ↵Mike Bayer2006-04-061-2/+2
| | | | time into "compilation" time
* merged Rick Morrison / Runar Petursson's MS-SQL module, with adjustments to ↵Mike Bayer2006-04-031-4/+4
| | | | alias schema-qualified Table objects
* except it fails a unit test. OK, make it ia KeyErrorMike Bayer2006-03-261-4/+4
|
* util: the __setitem__ method on historyarraylist was meaningless, surprising ↵Mike Bayer2006-03-261-4/+4
| | | | | | | | nobody noticed that. types: added PickleType, its slightly trickier than trivial, so OK now its standard. attributes: the level of pain if an AttributeError occurs inside a CallableProp, in combination with an object that implements __getattr__, is too deep for me to put the users through....so convert AttributeErrors to Assertions... engine: im not a fan of catching universal exceptions and squashing them
* added *args **kwargs pass-thru to transaction()Mike Bayer2006-03-251-3/+5
|
* ResultProxy has an iterator interfaceMike Bayer2006-03-251-0/+8
|
* added "nest_on" option for Session, so nested transactions can occur mostly ↵Mike Bayer2006-03-221-2/+6
| | | | | | at the Session level, fixes [ticket:113]
* rolled back the operationalerror catch...definitely doesnt work right nowMike Bayer2006-03-171-3/+0
|
* put a try/finally to insure that SQLSession is cleaned out on ↵Mike Bayer2006-03-171-6/+10
| | | | rollback/commit regardless of issues
* overhaul to SQLSession change from yesterday, needs to use the threadlocal ↵Mike Bayer2006-03-171-5/+16
| | | | capability of the pool after all
* attempting to catch OperationalErrors and invalidate the connectionMike Bayer2006-03-171-0/+3
|
* fixed nasty transaction counting bug with new session thing + unit testMike Bayer2006-03-171-0/+6
|
* refactor to engine to have a separate SQLSession object. allows nested ↵Mike Bayer2006-03-171-34/+59
| | | | | | | transactions. util.ThreadLocal __hasattr__ method/raise_error param meaningless, removed renamed old engines test to reflection
* SQLSession.....Mike Bayer2006-03-171-1/+3
|
* expanded and integrated qvx's patch for dotted function namesMike Bayer2006-03-161-4/+1
|
* added unique_connection() method to engine, connection pool to return a ↵Mike Bayer2006-03-141-0/+4
| | | | | | connection that is not part of the thread-local context or any current transaction
* oracle is requiring dictionary params to be in a clean dict, added conversionMike Bayer2006-03-131-20/+24
| | | | some fixes to unit tests
* refactor to Compiled.get_params() to return new ClauseParameters object, a ↵Mike Bayer2006-03-131-1/+19
| | | | | | | | | | | 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
* utf-8 encoding is switchable at the engine level, ticket [ticket:101]Mike Bayer2006-03-101-1/+2
|
* serious overhaul to get eager loads to work inline with an inheriting ↵Mike Bayer2006-03-081-0/+2
| | | | 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.
* added unittest for orm-persisted insert without a postfetch, tweak to engine ↵Mike Bayer2006-03-051-2/+2
| | | | to only signal postfetch if the passivedefault columns received None/NULL for their parameter (since they dont exec otherwise)
* got mapper to receive the onupdates after updating an instance (also ↵Mike Bayer2006-03-051-1/+14
| | | | properly receives defaults on inserts)...
* got column onupdate workingMike Bayer2006-03-051-2/+44
| | | | improvement to Function so that they can more easily be called standalone without having to throw them into a select().
* got column defaults to be executeableMike Bayer2006-03-041-0/+11
|
* making sequences, column defaults independently executeableMike Bayer2006-03-041-3/+3
|
* removed the dependency of ANSICompiler on SQLEngine. you can now make ↵Mike Bayer2006-03-041-5/+1
| | | | ANSICompilers and compile SQL with no engine at all.
* changed default "none" parameters to check positional styleMike Bayer2006-03-041-6/+5
|
* added util.Logger object with configurable thread/timestamp viewMike Bayer2006-03-031-6/+3
|
* made SchemaEngine more prominent as the base of Table associationMike Bayer2006-03-011-1/+5
| | | | | | | | | 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
* added convert_unicode flag to engine + unittest, does unicode in/out ↵Mike Bayer2006-03-011-1/+2
| | | | translation on all string/char values when set
* added items() method to RowProxy + unittest, courtesy dialtone@divmod.comMike Bayer2006-02-281-0/+2
|
* fixed an importMike Bayer2006-02-271-0/+1
|
* create() statements return the created object so they can be instantiated andMike Bayer2006-02-261-0/+1
| | | | create()'ed in one line
* merged sql_rearrangement branch , refactors sql package to work standalone withMike Bayer2006-02-251-27/+4
| | | | | clause elements including tables and columns, schema package deals with "physical" representations
* merged eager loading overhaul rev 1001:1009Mike Bayer2006-02-201-3/+6
| | | | | | | | | | | | | | | | | this includes: sql.Alias object keeps track of the immediate thing it aliased as well as the ultimate non-aliased (usually a Table) object, so that proxied columns can have a "parent" attribute some cleanup to SelectBaseMixin.order_by_clause to allow easier access, needs more cleanup engine has been making two ResultProxies all this time, added "return_raw" quickie flag to disable that some cleanup to _get_col_by_original so that it also works for oid columns, new eager load stuff more aggressively aliaseses orderby's so this was needed EagerLoader now makes "chains" of unique aliased eager loaders in all cases. no need for use_alias/selectalias anymore since it aliases every time. properly detects recursive eager loads and terminates them with a lazyloader, instead of raising an exception. totally simplified setup() and init() is more straightforward and has a single codepath now instead of two or three.
* exception package added, support throughoutMike Bayer2006-02-191-12/+12
|
* added indexes to schema/ansisql/engineMike Bayer2006-02-181-6/+14
| | | | | | slightly different index syntax for mysql fixed mysql Time type to convert from a timedelta to time tweaks to date unit tests for mysql
* bind params upon insert are totally column "name" based, so in ↵Mike Bayer2006-02-171-1/+1
| | | | process_defaults set newly acquired parameter by name also
* Modified objectstore to look for primary key param values by column name not ↵Robert Leftwich2006-02-171-3/+3
| | | | key name. Added test for same.
* streamlined engine.schemagenerator and engine.schemadropper methodologyMike Bayer2006-02-111-19/+9
| | | | | | added support for creating PassiveDefault (i.e. regular DEFAULT) on table columns postgres can reflect default values via information_schema added unittests for PassiveDefault values getting created, inserted, coming back in result sets
* derefences connection pool upon dispose()Mike Bayer2006-02-091-0/+1
|
* took out print statementMike Bayer2006-02-071-1/+0
|
* trying to get mappers to support having versions against different tables ↵Mike Bayer2006-02-071-0/+1
| | | | | | | for the same class, that dont affect the original class mapper and create objects with the correct identity key support in EagerLoader to better handle "selectalias" when the eager mapper hits another eager mapper, etc
* table supports per-engine-type options, ansisql allows enginesMike Bayer2006-02-051-1/+1
| | | | | | to add a "post table create" string mysql gets mysql_engine argument InnoDB set as default in engines test
* started PassiveDefault, which is a "database-side" default. mapper will goMike Bayer2006-02-051-1/+11
| | | | fetch the most recently inserted row if a table has PassiveDefault's set on it
* added ISchema object to engine/information_schema, provides somewhat generic ↵Mike Bayer2006-02-041-0/+12
| | | | information_schema access for db's that support it, i.e. postgres, mysql 5
View Lorry Controller Status