summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/schema.py
Commit message (Collapse)AuthorAgeFilesLines
...
* [ticket:282]Mike Bayer2006-08-231-1/+1
|
* working on sequence quoting support....Mike Bayer2006-08-211-7/+17
|
* - postgres reflection moved to use pg_schema tables, can be overriddenMike Bayer2006-08-211-2/+14
| | | | | | | | with use_information_schema=True argument to create_engine [ticket:60], [ticket:71] - added natural_case argument to Table, Column, semi-experimental flag for use with table reflection to help with quoting rules [ticket:155]
* quoting facilities set up so that database-specific quoting can beMike Bayer2006-08-121-0/+11
| | | | | | | turned on for individual table, schema, and column identifiers when used in all queries/creates/drops. Enabled via "quote=True" in Table or Column, as well as "quote_schema=True" in Table. Thanks to Aaron Spike for his excellent efforts. [ticket:155]
* all create()/drop() calls have a keyword argument of "connectable".Mike Bayer2006-08-091-14/+42
| | | | "engine" is deprecated. fixes [ticket:255]
* patch for [ticket:105], adding "owner" support to oracle...not tested yetMike Bayer2006-07-191-0/+3
|
* added table.exists()Mike Bayer2006-07-191-0/+10
|
* added 'checkfirst' argument to table.create()/table.drop()Mike Bayer2006-07-191-6/+6
| | | | some 0.2.6 prep
* added __setitem__ to ConstraintMike Bayer2006-07-181-0/+2
|
* overhaul to schema, addition of ForeignKeyConstraint/Mike Bayer2006-07-141-30/+141
| | | | | | | | PrimaryKeyConstraint objects (also UniqueConstraint not completed yet). table creation and reflection modified to be more oriented towards these new table-level objects. reflection for sqlite/postgres/mysql supports composite foreign keys; oracle/mssql/firebird not converted yet.
* some adjustments to activemapper's objectstore to be composed against ↵Mike Bayer2006-07-011-2/+2
| | | | | | SessionContext DynamicMetaData checks first for _engine before returning
* removed historyarray testMike Bayer2006-06-161-2/+11
| | | | | ForeignKey is more intelligent about locating the parent table it represents, in the case that its attached to a CompoundSelect column which has multiple "originals", some of which might not be schema.Columns
* fixed bug where tables with schema name werent getting indexed in metadata ↵Mike Bayer2006-06-061-5/+2
| | | | correctly
* restored global_connect() function, default table metadataMike Bayer2006-06-021-0/+9
|
* merged 0.2 branch into trunk; 0.1 now in sqlalchemy/branches/rel_0_1Mike Bayer2006-05-251-120/+211
|
* anonymous indexes use column._label to avoid name collisionsMike Bayer2006-05-231-2/+2
|
* had unicode check improperly placedMike Bayer2006-05-061-2/+3
|
* foreignkey checks for unicode incoming stringMike Bayer2006-05-031-1/+2
|
* commented out default schema name checkMike Bayer2006-04-261-1/+1
|
* a little spring cleaning for the util package, etcMike Bayer2006-04-071-2/+2
|
* split up Session into Session/LegacySession, added some new constructor argsMike Bayer2006-04-061-14/+41
| | | | | | | | created AbstractEngine class which provides base for SQLEngine and will also provide base for ConnectionProxy, so SQL binding can be to an engine or specific connection resource ClauseElements get using() method which can take AbstractEngines for execution made more separation between SchemaItems and bound engine
* moves the binding of a TypeEngine object from "schema/statement creation" ↵Mike Bayer2006-04-061-1/+0
| | | | time into "compilation" time
* merged Rick Morrison / Runar Petursson's MS-SQL module, with adjustments to ↵Mike Bayer2006-04-031-2/+5
| | | | alias schema-qualified Table objects
* refactor to Compiled.get_params() to return new ClauseParameters object, a ↵Mike Bayer2006-03-131-1/+1
| | | | | | | | | | | 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
* got column onupdate workingMike Bayer2006-03-051-1/+9
| | | | 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-9/+21
|
* making sequences, column defaults independently executeableMike Bayer2006-03-041-4/+15
|
* engine argument on tables optionalMike Bayer2006-03-021-0/+3
| | | | | test suite uses BaseProxyEngine as a base for the tester engine documented global proxy engine
* made SchemaEngine more prominent as the base of Table associationMike Bayer2006-03-011-4/+9
| | | | | | | | | 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
* Merge indexes [1047]:[1048] into trunk (for #6)Jason Pellerin2006-02-261-20/+79
|
* create() statements return the created object so they can be instantiated andMike Bayer2006-02-261-0/+2
| | | | create()'ed in one line
* merged sql_rearrangement branch , refactors sql package to work standalone withMike Bayer2006-02-251-105/+58
| | | | | clause elements including tables and columns, schema package deals with "physical" representations
* fix to silent "recursive" bug in schema getattr that was somehow running ↵rel_0_1_2Mike Bayer2006-02-241-1/+1
| | | | only 994 times
* fix to EagerLoad where it late-initializes its eager chain, thereby not ↵Mike Bayer2006-02-221-0/+6
| | | | getting messed up by late add_property() calls
* merged eager loading overhaul rev 1001:1009Mike Bayer2006-02-201-1/+4
| | | | | | | | | | | | | | | | | 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-8/+9
|
* added indexes to schema/ansisql/engineMike Bayer2006-02-181-2/+54
| | | | | | slightly different index syntax for mysql fixed mysql Time type to convert from a timedelta to time tweaks to date unit tests for mysql
* added an assertion to insure that a column is only attached to one tableMike Bayer2006-02-171-0/+2
|
* streamlined engine.schemagenerator and engine.schemadropper methodologyMike Bayer2006-02-111-5/+5
| | | | | | 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
* table supports per-engine-type options, ansisql allows enginesMike Bayer2006-02-051-3/+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-0/+12
| | | | fetch the most recently inserted row if a table has PassiveDefault's set on it
* columns can be specified to override those from autoload=TrueMike Bayer2006-02-041-4/+5
|
* refactoring to allow column.label() to work in selects, etc.Mike Bayer2006-01-271-4/+1
| | | | fixed superfluous codeline in ForeignKey
* ai more reasonable hash_key that works across serializationsMike Bayer2006-01-261-0/+6
| | | | might want to get the DB password out of it tho....
* Formatting fix.Robert Leftwich2006-01-161-2/+2
|
* Fixed problem in Column.copy(), _make_proxy() with nullable and hidden not ↵Robert Leftwich2006-01-161-2/+2
| | | | being reflected into new Column. Added test for same. Removed reference to non-existant columns test from list of tests in alltests.
* on foreign key default schema is that of the parent columnMike Bayer2006-01-131-3/+2
|
* indent fixMike Bayer2006-01-111-1/+1
|
* r815@lightspeed: robert | 2006-01-11 10:15:14 +1100Robert Leftwich2006-01-101-1/+1
| | | | Replaced use of repr() with custom identifiers in identity related areas to improve performance
* added some __repr__ functionalityMike Bayer2006-01-081-9/+41
|
View Lorry Controller Status