pirogue.MultipleInheritance

class pirogue.MultipleInheritance(definition: dict, pg_service: str | None = None, variables: dict = {}, create_joins: bool = False, drop: bool = False)[source]

Creates a view for multiple inheritance objects with associated triggers to edit data.

__init__(definition: dict, pg_service: str | None = None, variables: dict = {}, create_joins: bool = False, drop: bool = False)[source]

Produces the SQL code of the join table and triggers

Parameters:

  • definition – the YAML definition of the multiple inheritance

  • pg_service – if not given, it is determined using environment variable PGSERVICE

  • variables – dictionary for variables to be used in SQL deltas ( name => value )

  • create_joins – if True, simple joins will be created for all joined tables

  • drop – if True, will drop any existing view, type or trigger that will be created later

Methods

__init__(definition[, pg_service, ...])

Produces the SQL code of the join table and triggers

create()

Creates the merge view on the specified service Returns True in case of success