Vous êtes un professionnel et vous avez besoin d'une formation ? Calcul scientifique
avec Python Voir le programme détaillé

Classe « Inspector »

Méthode sqlalchemy.Inspector.get_multi_foreign_keys

Signature de la méthode get_multi_foreign_keys

def get_multi_foreign_keys(self, schema: 'Optional[str]' = None, filter_names: 'Optional[Sequence[str]]' = None, kind: 'ObjectKind' = <ObjectKind.TABLE: 1>, scope: 'ObjectScope' = <ObjectScope.DEFAULT: 1>, **kw: 'Any') -> 'Dict[TableKey, List[ReflectedForeignKeyConstraint]]' 

Description

help(Inspector.get_multi_foreign_keys)

Return information about foreign_keys in all tables
in the given schema.

The tables can be filtered by passing the names to use to
``filter_names``.

For each table the value is a list of
:class:`.ReflectedForeignKeyConstraint`.

:param schema: string schema name; if omitted, uses the default schema
 of the database connection.  For special quoting,
 use :class:`.quoted_name`.

:param filter_names: optionally return information only for the
 objects listed here.

:param kind: a :class:`.ObjectKind` that specifies the type of objects
 to reflect. Defaults to ``ObjectKind.TABLE``.

:param scope: a :class:`.ObjectScope` that specifies if foreign keys of
 default, temporary or any tables should be reflected.
 Defaults to ``ObjectScope.DEFAULT``.

:param \**kw: Additional keyword argument to pass to the dialect
 specific implementation. See the documentation of the dialect
 in use for more information.

:return: a dictionary where the keys are two-tuple schema,table-name
 and the values are list of dictionaries, each representing
 a foreign key definition.
 The schema is ``None`` if no schema is provided.

.. versionadded:: 2.0

.. seealso:: :meth:`Inspector.get_foreign_keys`

Vous êtes un professionnel et vous avez besoin d'une formation ? Machine Learning
avec Scikit-Learn Voir le programme détaillé