summaryrefslogtreecommitdiff
path: root/examples
Commit message (Collapse)AuthorAgeFilesLines
* - reorganize docs so expression, schema are broken out into subfiles, ↵Mike Bayer2013-08-181-0/+1
| | | | | | they're too big - fix the targeting of module names moved around by using custom handlers for "Bases", etc.
* - changelogMike Bayer2013-08-171-26/+26
| | | | - clean up these tests to not use globals so much, close out the session
* Made primary_key autoincrement=False in versioning example.Patrick R. Schmid2013-07-311-3/+3
|
* modernize this a bitMike Bayer2013-07-271-19/+10
|
* - Improved the examples in ``examples/generic_associations``, includingMike Bayer2013-07-195-48/+194
| | | | | | | | | | | | | | | that ``discriminator_on_association.py`` makes use of single table inheritance do the work with the "discriminator". Also added a true "generic foreign key" example, which works similarly to other popular frameworks in that it uses an open-ended integer to point to any other table, foregoing traditional referential integrity. While we don't recommend this pattern, information wants to be free. Also in 0.8.3. - Added a convenience class decorator :func:`.as_declarative`, is a wrapper for :func:`.declarative_base` which allows an existing base class to be applied using a nifty class-decorated approach. Also in 0.8.3.
* Forgot final check that a delete in a backref also doesn't create a new versionMatt Chisholm2013-06-171-0/+3
| | | | follow up to https://bitbucket.org/zzzeek/sqlalchemy/pull-request/2
* don't create a history entry when an object in a backref has changedMatt Chisholm2013-06-152-3/+42
| | | | The code that determines whether an object in a relation has been added/removed does not take into account that that relation may be a backref. If the relation is a backref, then nothing on the current table is changing, and therefore no history entry should be created.
* Merge branch 'master' into rel_0_9Mike Bayer2013-05-281-1/+1
|\
| * Fixed a small bug in the dogpile example where the generationMike Bayer2013-05-281-1/+1
| | | | | | | | | | of SQL cache keys wasn't applying deduping labels to the statement the same way :class:`.Query` normally does.
* | - the raw 2to3 runMike Bayer2013-04-2729-296/+296
|/ | | | - went through examples/ and cleaned out excess list() calls
* modernize some more examplesMike Bayer2013-04-2710-71/+80
|
* Fixed a long-standing bug in the caching example, whereMike Bayer2013-04-181-14/+5
| | | | | | | | | the limit/offset parameter values wouldn't be taken into account when computing the cache key. The _key_from_query() function has been simplified to work directly from the final compiled statement in order to get at both the full statement as well as the fully processed parameter list.
* - remove erroneous second RelationshipCache classMike Bayer2013-04-181-18/+0
|
* whack more long lines in very old docstringsMike Bayer2013-02-0210-29/+54
|
* Fixed a regression in the examples/dogpile_caching exampleMike Bayer2013-01-081-1/+2
| | | | which was due to the change in #2614.
* fixing InstrumentationManager linksDiana Clarke2012-12-071-3/+14
|
* - converted beaker demo to dogpile.cache, [ticket:2589]Mike Bayer2012-10-2111-413/+418
|
* add a noteMike Bayer2012-08-171-0/+3
|
* - really start making postgis example slick.Mike Bayer2012-08-171-60/+62
|
* - [feature] To complement [ticket:2547], typesMike Bayer2012-08-171-18/+13
| | | | | | | | | | | | | | | | can now provide "bind expressions" and "column expressions" which allow compile-time injection of SQL expressions into statements on a per-column or per-bind level. This is to suit the use case of a type which needs to augment bind- and result- behavior at the SQL level, as opposed to in the Python level. Allows for schemes like transparent encryption/ decryption, usage of Postgis functions, etc. [ticket:1534] - update postgis example fully. - still need to repair the result map propagation here to be transparent for cases like "labeled column".
* - modernize most of the postgis example. would like to do [ticket:1534] also.Mike Bayer2012-08-161-91/+85
| | | | | - we don't have coverage for type-wide instrumentation events, the listener was broke. could break again too.
* update the postgis example to actually work, using the old way (we'll update ↵Mike Bayer2012-08-161-9/+9
| | | | shortly)
* -whitespace bonanza, contdMike Bayer2012-07-2831-153/+153
|
* trailing whitespace bonanzaMike Bayer2012-07-285-34/+34
|
* - [moved] The InstrumentationManager interfaceMike Bayer2012-06-241-108/+11
| | | | | | | | | | | | | and the entire related system of alternate class implementation is now moved out to sqlalchemy.ext.instrumentation. This is a seldom used system that adds significant complexity and overhead to the mechanics of class instrumentation. The new architecture allows it to remain unused until InstrumentationManager is actually imported, at which point it is bootstrapped into the core.
* - [feature] The "deferred declarativeMike Bayer2012-05-172-144/+0
| | | | | | | | | | | | | | | | reflection" system has been moved into the declarative extension itself, using the new DeferredReflection class. This class is now tested with both single and joined table inheritance use cases. [ticket:2485] - [bug] The autoload_replace flag on Table, when False, will cause any reflected foreign key constraints which refer to already-declared columns to be skipped, assuming that the in-Python declared column will take over the task of specifying in-Python ForeignKey or ForeignKeyConstraint declarations.
* - [feature] New standalone function with_polymorphic()Mike Bayer2012-04-232-125/+135
| | | | | | | | | | | provides the functionality of query.with_polymorphic() in a standalone form. It can be applied to any entity within a query, including as the target of a join in place of the "of_type()" modifier. [ticket:2333] - redo a large portion of the inheritance docs in terms of declarative, new with_polymorphic() function - upgrade examples/inheritance/polymorph, rename to "joined"
* - [bug] Altered _params_from_query() functionMike Bayer2012-02-141-4/+8
| | | | | | | in Beaker example to pull bindparams from the fully compiled statement, as a quick means to get everything including subqueries in the columns clause, etc.
* declarartive reflection example didn't actually work for single inheritance, ↵Mike Bayer2012-02-091-0/+11
| | | | added a tweak to make that possible
* - [bug] Improved the "declarative reflection"Mike Bayer2012-01-281-15/+26
| | | | | | | | example to support single-table inheritance, multiple calls to prepare(), tables that are present in alternate schemas, establishing only a subset of classes as reflected.
* declarative reflection exampleMike Bayer2012-01-282-1/+9
|
* - [feature] New declarative reflection exampleMike Bayer2012-01-282-0/+114
| | | | | | added, illustrates how best to mix table reflection with declarative as well as uses some new features from [ticket:2356].
* modernize adjacency list example, use declarativeMike Bayer2012-01-281-61/+48
|
* fix a usage issue hereMike Bayer2012-01-281-0/+3
|
* - [bug] Fixed large_collection.py to close theMike Bayer2012-01-221-1/+2
| | | | session before dropping tables. [ticket:2346]
* - [feature] Simplified the versioning exampleMike Bayer2012-01-223-43/+28
| | | | | | a bit to use a declarative mixin as well as an event listener, instead of a metaclass + SessionExtension. [ticket:2313]
* - Fixed bug in history_meta.py example whereMike Bayer2011-10-172-1/+7
| | | | | | the "unique" flag was not removed from a single-table-inheritance subclass which generates columns to put up onto the base.
* - Adjusted dictlike-polymorphic.py exampleMike Bayer2011-09-261-8/+9
| | | | | to apply the CAST such that it works on PG, other databases. [ticket:2266]
* - Fixed the attribute shard example to checkMike Bayer2011-06-261-11/+13
| | | | | for bind param callable correctly in 0.7 style.
* - Repaired the examples/versioning test runnerMike Bayer2011-06-164-7/+104
| | | | | | | | | | | to not rely upon SQLAlchemy test libs, nosetests must be run from within examples/versioning to get around setup.cfg breaking it. - Tweak to examples/versioning to pick the correct foreign key in a multi-level inheritance situation.
* update for new table modelMike Bayer2011-06-061-6/+21
|
* update docs for generic associationsMike Bayer2011-04-281-3/+10
|
* - removed the ancient "polymorphic association"Mike Bayer2011-04-278-491/+378
| | | | | | | examples and replaced with an updated set of examples that use declarative mixins, "generic_associations". Each presents an alternative table layout.
* - remove test.sql._base, test.engine._base, test.orm._base, move those ↵Mike Bayer2011-03-271-1/+1
| | | | | | | classes to a new test.lib.fixtures module - move testing.TestBase to test.lib.fixtures - massive search and replace
* - The horizontal_shard ShardedSession class accepts the commonMike Bayer2011-03-161-2/+2
| | | | | | | | Session argument "query_cls" as a constructor argument, to enable further subclassing of ShardedQuery. [ticket:2090] - The Beaker caching example allows a "query_cls" argument to the query_callable() function. [ticket:2090]
* - Updated the association, association proxy examplesMike Bayer2011-03-134-187/+255
| | | | | | to use declarative, added a new example dict_of_sets_with_default.py, a "pushing the envelope" example of association proxy.
* - Beaker example now takes into account 'limit'Mike Bayer2011-02-131-2/+5
| | | | | | and 'offset', bind params within embedded FROM clauses (like when you use union() or from_self()) when generating a cache key.
* add example usage for shard_id in context feature [ticket:2031]Mike Bayer2011-01-231-2/+15
|
* - rename hybrid.property_, hybrid.method to hybrid_property, hybrid_method. ↵Mike Bayer2011-01-121-35/+29
| | | | | | | more typing on the import but this is just clearer. - adapt dictlike-polymorphic.py to use hybrid.
* - whitespace removal bonanzaMike Bayer2011-01-0228-288/+288
|
View Lorry Controller Status