datacube.drivers.common_psql.transfers_required#

datacube.drivers.common_psql.transfers_required(conn, new_owner, schema, object_type, objects=None, prefix=None)[source]#

Determine which objects in a schema need to be transferred to a new owner.

One and only one of objects or prefix must be specified.

Parameters:

  • conn (Connection) – A SQLAlchemy connection object

  • new_owner (str) – The new owner, the database role that should own the objects.

  • schema (str) – The schema containing the objects.

  • object_type (Literal['tables', 'matviews', 'views']) – The type of objects to check. One of “tables”, “matviews”, “views”.

  • objects (list[str] | None) – A list of object names to check.

  • prefix (str | None) – An object name prefix to check.

Return type:

list[tuple[str, str]]

Returns:

A list of (name, old_owner) tuples of matching objects.