Participer au site avec un Tip
Rechercher
 
Bug Suggérer des Améliorations / Corrections
Share Partager sur Facebook Partager sur Twitter
Links Notre chaîne YouTube Notre discord

Améliorations / Corrections

Vous avez des améliorations (ou des corrections) à proposer pour ce document : je vous remerçie par avance de m'en faire part, cela m'aide à améliorer le site.

Emplacement :

Description des améliorations :

Contenu du module « sqlalchemy »

Liste des classes du module sqlalchemy

Nom de la classe Description
ARRAY Represent a SQL Array type. [extrait de ARRAY.__doc__]
BIGINT The SQL BIGINT type. [extrait de BIGINT.__doc__]
BigInteger A type for bigger ``int`` integers. [extrait de BigInteger.__doc__]
BINARY The SQL BINARY type. [extrait de BINARY.__doc__]
BLOB The SQL BLOB type. [extrait de BLOB.__doc__]
BOOLEAN The SQL BOOLEAN type. [extrait de BOOLEAN.__doc__]
Boolean A bool datatype. [extrait de Boolean.__doc__]
CHAR The SQL CHAR type. [extrait de CHAR.__doc__]
CheckConstraint A table- or column-level CHECK constraint. [extrait de CheckConstraint.__doc__]
CLOB The CLOB type. [extrait de CLOB.__doc__]
Column Represents a column in a database table. [extrait de Column.__doc__]
ColumnDefault A plain default value on a column. [extrait de ColumnDefault.__doc__]
Computed Defines a generated column, i.e. "GENERATED ALWAYS AS" syntax. [extrait de Computed.__doc__]
Constraint A table-level SQL constraint. [extrait de Constraint.__doc__]
DATE The SQL DATE type. [extrait de DATE.__doc__]
Date A type for ``datetime.date()`` objects. [extrait de Date.__doc__]
DATETIME The SQL DATETIME type. [extrait de DATETIME.__doc__]
DateTime A type for ``datetime.datetime()`` objects. [extrait de DateTime.__doc__]
DDL A literal DDL statement. [extrait de DDL.__doc__]
DECIMAL The SQL DECIMAL type. [extrait de DECIMAL.__doc__]
DefaultClause A DDL-specified DEFAULT column value. [extrait de DefaultClause.__doc__]
Enum Generic Enum Type. [extrait de Enum.__doc__]
FetchedValue A marker for a transparent database-side default. [extrait de FetchedValue.__doc__]
FLOAT The SQL FLOAT type. [extrait de FLOAT.__doc__]
Float Type representing floating point types, such as ``FLOAT`` or ``REAL``. [extrait de Float.__doc__]
ForeignKey Defines a dependency between two columns. [extrait de ForeignKey.__doc__]
ForeignKeyConstraint A table-level FOREIGN KEY constraint. [extrait de ForeignKeyConstraint.__doc__]
Identity Defines an identity column, i.e. "GENERATED { ALWAYS | BY DEFAULT } [extrait de Identity.__doc__]
Index A table-level INDEX. [extrait de Index.__doc__]
INTEGER The SQL INT or INTEGER type. [extrait de INTEGER.__doc__]
Integer A type for ``int`` integers. [extrait de Integer.__doc__]
Interval A type for ``datetime.timedelta()`` objects. [extrait de Interval.__doc__]
JSON Represent a SQL JSON type. [extrait de JSON.__doc__]
LargeBinary A type for large binary byte data. [extrait de LargeBinary.__doc__]
MetaData A collection of :class:`_schema.Table` [extrait de MetaData.__doc__]
NCHAR The SQL NCHAR type. [extrait de NCHAR.__doc__]
NUMERIC The SQL NUMERIC type. [extrait de NUMERIC.__doc__]
Numeric A type for fixed precision numbers, such as ``NUMERIC`` or ``DECIMAL``. [extrait de Numeric.__doc__]
NVARCHAR The SQL NVARCHAR type. [extrait de NVARCHAR.__doc__]
PickleType Holds Python objects, which are serialized using pickle. [extrait de PickleType.__doc__]
PrimaryKeyConstraint A table-level PRIMARY KEY constraint. [extrait de PrimaryKeyConstraint.__doc__]
REAL The SQL REAL type. [extrait de REAL.__doc__]
Sequence Represents a named database sequence. [extrait de Sequence.__doc__]
SMALLINT The SQL SMALLINT type. [extrait de SMALLINT.__doc__]
SmallInteger A type for smaller ``int`` integers. [extrait de SmallInteger.__doc__]
String The base for all string and character types. [extrait de String.__doc__]
Table Represent a table in a database. [extrait de Table.__doc__]
TEXT The SQL TEXT type. [extrait de TEXT.__doc__]
Text A variably sized string type. [extrait de Text.__doc__]
ThreadLocalMetaData A MetaData variant that presents a different ``bind`` in every thread. [extrait de ThreadLocalMetaData.__doc__]
TIME The SQL TIME type. [extrait de TIME.__doc__]
Time A type for ``datetime.time()`` objects. [extrait de Time.__doc__]
TIMESTAMP The SQL TIMESTAMP type. [extrait de TIMESTAMP.__doc__]
TypeDecorator Allows the creation of types which add additional functionality [extrait de TypeDecorator.__doc__]
Unicode A variable length Unicode string type. [extrait de Unicode.__doc__]
UnicodeText An unbounded-length Unicode string type. [extrait de UnicodeText.__doc__]
UniqueConstraint A table-level UNIQUE constraint. [extrait de UniqueConstraint.__doc__]
VARBINARY The SQL VARBINARY type. [extrait de VARBINARY.__doc__]
VARCHAR The SQL VARCHAR type. [extrait de VARCHAR.__doc__]

Liste des fonctions du module sqlalchemy

Signature de la fonction Description
alias(selectable, name=None, flat=False) Return an :class:`_expression.Alias` object. [extrait de alias.__doc__]
all_(expr) Produce an ALL expression. [extrait de all_.__doc__]
and_(*clauses) Produce a conjunction of expressions joined by ``AND``. [extrait de and_.__doc__]
any_(expr) Produce an ANY expression. [extrait de any_.__doc__]
asc(column) Produce an ascending ``ORDER BY`` clause element. [extrait de asc.__doc__]
between(expr, lower_bound, upper_bound, symmetric=False) Produce a ``BETWEEN`` predicate clause. [extrait de between.__doc__]
bindparam(key, value=symbol('NO_ARG'), type_=None, unique=False, required=symbol('NO_ARG'), quote=None, callable_=None, expanding=False, isoutparam=False, literal_execute=False, _compared_to_operator=None, _compared_to_type=None, _is_crud=False) Produce a "bound expression". [extrait de bindparam.__doc__]
case(*whens, **kw) Produce a ``CASE`` expression. [extrait de case.__doc__]
cast(expression, type_) Produce a ``CAST`` expression. [extrait de cast.__doc__]
collate(expression, collation) Return the clause ``expression COLLATE collation``. [extrait de collate.__doc__]
column(text, type_=None, is_literal=False, _selectable=None) Produce a :class:`.ColumnClause` object. [extrait de column.__doc__]
create_engine(url, **kwargs) Create a new :class:`_engine.Engine` instance. [extrait de create_engine.__doc__]
create_mock_engine(url, executor, **kw) Create a "mock" engine used for echoing DDL. [extrait de create_mock_engine.__doc__]
delete(table, whereclause=None, bind=None, returning=None, prefixes=None, **dialect_kw) Construct :class:`_expression.Delete` object. [extrait de delete.__doc__]
desc(column) Produce a descending ``ORDER BY`` clause element. [extrait de desc.__doc__]
distinct(expr) Produce an column-expression-level unary ``DISTINCT`` clause. [extrait de distinct.__doc__]
engine_from_config(configuration, prefix='sqlalchemy.', **kwargs) Create a new Engine instance using a configuration dictionary. [extrait de engine_from_config.__doc__]
except_(*selects, **kwargs) Return an ``EXCEPT`` of multiple selectables. [extrait de except_.__doc__]
except_all(*selects, **kwargs) Return an ``EXCEPT ALL`` of multiple selectables. [extrait de except_all.__doc__]
exists(*args, **kwargs) Construct a new :class:`_expression.Exists` construct. [extrait de exists.__doc__]
extract(field, expr, **kwargs) Return a :class:`.Extract` construct. [extrait de extract.__doc__]
false() Return a :class:`.False_` construct. [extrait de false.__doc__]
func(*c, **kwargs) Generate SQL function expressions. [extrait de __doc__]
funcfilter(func, *criterion) Produce a :class:`.FunctionFilter` object against a function. [extrait de funcfilter.__doc__]
insert(table, values=None, inline=False, bind=None, prefixes=None, returning=None, return_defaults=False, **dialect_kw) Construct an :class:`_expression.Insert` object. [extrait de insert.__doc__]
inspect(subject, raiseerr=True) Produce an inspection object for the given target. [extrait de inspect.__doc__]
intersect(*selects, **kwargs) Return an ``INTERSECT`` of multiple selectables. [extrait de intersect.__doc__]
intersect_all(*selects, **kwargs) Return an ``INTERSECT ALL`` of multiple selectables. [extrait de intersect_all.__doc__]
join(left, right, onclause=None, isouter=False, full=False) Produce a :class:`_expression.Join` object, given two [extrait de join.__doc__]
lambda_stmt(lmb, enable_tracking=True, track_closure_variables=True, track_on=None, global_track_bound_values=True, track_bound_values=True, lambda_cache=None) Produce a SQL statement that is cached as a lambda. [extrait de lambda_stmt.__doc__]
lateral(selectable, name=None) Return a :class:`_expression.Lateral` object. [extrait de lateral.__doc__]
literal(value, type_=None) Return a literal clause, bound to a bind parameter. [extrait de literal.__doc__]
literal_column(text, type_=None) Produce a :class:`.ColumnClause` object that has the [extrait de literal_column.__doc__]
modifier(*c, **kwargs) Generate SQL function expressions. [extrait de __doc__]
not_(clause) Return a negation of the given clause, i.e. ``NOT(clause)``. [extrait de not_.__doc__]
null() Return a constant :class:`.Null` construct. [extrait de null.__doc__]
nulls_first(column) Produce the ``NULLS FIRST`` modifier for an ``ORDER BY`` expression. [extrait de nulls_first.__doc__]
nulls_last(column) Produce the ``NULLS LAST`` modifier for an ``ORDER BY`` expression. [extrait de nulls_last.__doc__]
or_(*clauses) Produce a conjunction of expressions joined by ``OR``. [extrait de or_.__doc__]
outerjoin(left, right, onclause=None, full=False) Return an ``OUTER JOIN`` clause element. [extrait de outerjoin.__doc__]
outparam(key, type_=None) Create an 'OUT' parameter for usage in functions (stored procedures), [extrait de outparam.__doc__]
over(element, partition_by=None, order_by=None, range_=None, rows=None) Produce an :class:`.Over` object against a function. [extrait de over.__doc__]
select(*args, **kw) Create a :class:`.Select` using either the 1.x or 2.0 constructor [extrait de select.__doc__]
subquery(alias, *args, **kwargs) Return an :class:`.Subquery` object derived [extrait de subquery.__doc__]
table(name, *columns, **kw) Produce a new :class:`_expression.TableClause`. [extrait de table.__doc__]
tablesample(selectable, sampling, name=None, seed=None) Return a :class:`_expression.TableSample` object. [extrait de tablesample.__doc__]
text(text, bind=None) Construct a new :class:`_expression.TextClause` clause, [extrait de text.__doc__]
true() Return a constant :class:`.True_` construct. [extrait de true.__doc__]
tuple_(*clauses, **kw) Return a :class:`.Tuple`. [extrait de tuple_.__doc__]
type_coerce(expression, type_) Associate a SQL expression with a particular type, without rendering [extrait de type_coerce.__doc__]
union(*selects, **kwargs) Return a ``UNION`` of multiple selectables. [extrait de union.__doc__]
union_all(*selects, **kwargs) Return a ``UNION ALL`` of multiple selectables. [extrait de union_all.__doc__]
update(table, whereclause=None, values=None, inline=False, bind=None, prefixes=None, returning=None, return_defaults=False, preserve_parameter_order=False, **dialect_kw) Construct an :class:`_expression.Update` object. [extrait de update.__doc__]
values(*columns, **kw) Construct a :class:`_expression.Values` construct. [extrait de values.__doc__]
within_group(element, *order_by) Produce a :class:`.WithinGroup` object against a function. [extrait de within_group.__doc__]

Liste des variables globales du module sqlalchemy

Nom de la variable globale Valeur
BLANK_SCHEMA symbol('blank_schema')
LABEL_STYLE_DEFAULT symbol('LABEL_STYLE_DISAMBIGUATE_ONLY')
LABEL_STYLE_DISAMBIGUATE_ONLY symbol('LABEL_STYLE_DISAMBIGUATE_ONLY')
LABEL_STYLE_NONE symbol('LABEL_STYLE_NONE')
LABEL_STYLE_TABLENAME_PLUS_COL symbol('LABEL_STYLE_TABLENAME_PLUS_COL')

Liste des alias du module sqlalchemy

Nom de l'alias Définition ciblée
INT INTEGER
nullsfirst nulls_first
nullslast nulls_last





Le tutoriel Python complet (Text+Vidéos)
Le tutoriel Python en vidéos
Evaluez vos compétences en Python