summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/engine.py
Commit message (Collapse)AuthorAgeFilesLines
* 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
* Tabs to spacesRobert Leftwich2006-01-291-2/+2
|
* Reworked RowProxy to restore column order preservation and to remove some ↵Robert Leftwich2006-01-291-23/+10
| | | | dictionary-like behaviour that was unnecessary and caused breakage in existing code. Added tests for column preservation.
* Added __len__ to RowProxy to allow len(r) and test for same.Robert Leftwich2006-01-291-0/+2
|
* RowProxy changes - added keys(), used keys() to add more dictionary-like ↵Robert Leftwich2006-01-281-8/+24
| | | | behaviour (values(), iteritems(), iterkeys(), etc). Made parent and row private. Modified tests that used RowProxy.row to use values().
* ai more reasonable hash_key that works across serializationsMike Bayer2006-01-261-0/+5
| | | | might want to get the DB password out of it tho....
* Added column accessor to RowProxy, tests and note in documentation for same.Robert Leftwich2006-01-251-1/+5
|
* added some echo arguments for uow, pool, propigated from the engineMike Bayer2006-01-211-3/+4
|
* added explicit bind parameters and column type maps to text typeMike Bayer2006-01-201-0/+4
| | | | | | | | | text type also parses :<string> into bind param objects bind parameters convert their incoming type using engine.type_descriptor() methods types.adapt_type() adjusted to not do extra work with incoming types, since the bind param change will cause it to be called a lot more added tests to new text type stuff, bind params, fixed some type tests added basic docs for using text with binde params
* dispose() added to pool/engine to allow engines to fall out of scopeMike Bayer2006-01-181-0/+5
|
* misc commenty type stuffMike Bayer2006-01-081-0/+3
|
View Lorry Controller Status