diff options
| author | saarni <saarni@gmail.com> | 2016-05-26 10:15:24 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2016-06-15 14:42:08 -0400 |
| commit | 20f2f5b169d35cfee7cc21ff697e23fd00858171 (patch) | |
| tree | 5c6a893dadb8d64b84b1f89879ffb8fc747d048f /lib/sqlalchemy/sql/expression.py | |
| parent | 0620a76b582cc93d55e3ddfb74ac22682e148a36 (diff) | |
| download | sqlalchemy-20f2f5b169d35cfee7cc21ff697e23fd00858171.tar.gz | |
Add TABLESAMPLE clause support.
The TABLESAMPLE clause allows randomly selecting an approximate percentage
of rows from a table. At least DB2, Microsoft SQL Server and recent
Postgresql support this standard clause.
Fixes: #3718
Change-Id: I3fb8b9223e12a57100df30876b461884c58d72fa
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/277
Diffstat (limited to 'lib/sqlalchemy/sql/expression.py')
| -rw-r--r-- | lib/sqlalchemy/sql/expression.py | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/lib/sqlalchemy/sql/expression.py b/lib/sqlalchemy/sql/expression.py index 97f74d4e4..cbb123ec6 100644 --- a/lib/sqlalchemy/sql/expression.py +++ b/lib/sqlalchemy/sql/expression.py @@ -26,7 +26,8 @@ __all__ = [ 'nullslast', 'or_', 'outparam', 'outerjoin', 'over', 'select', 'subquery', 'table', 'text', - 'tuple_', 'type_coerce', 'union', 'union_all', 'update', 'within_group'] + 'tuple_', 'type_coerce', 'union', 'union_all', 'update', 'within_group', + 'TableSample', 'tablesample'] from .visitors import Visitable @@ -49,7 +50,7 @@ from .base import ColumnCollection, Generative, Executable, \ from .selectable import Alias, Join, Select, Selectable, TableClause, \ CompoundSelect, CTE, FromClause, FromGrouping, Lateral, SelectBase, \ alias, GenerativeSelect, subquery, HasCTE, HasPrefixes, HasSuffixes, \ - lateral, Exists, ScalarSelect, TextAsFrom + lateral, Exists, ScalarSelect, TextAsFrom, TableSample, tablesample from .dml import Insert, Update, Delete, UpdateBase, ValuesBase |