relations
Package handles relations on models, returning related models on calls and exposing QuerySetProxy for m2m and reverse relations.
AliasManager
Keep all aliases of relations between different tables. One global instance is shared between all models.
Source code in ormar\relations\alias_manager.py
29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 |
|
reversed_aliases: Dict
property
Returns swapped key-value pairs from aliases where alias is the key.
Returns:
Type | Description |
---|---|
Dict
|
dictionary of prefix to relation |
add_alias(alias_key)
Adds alias to the dictionary of aliases under given key.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
alias_key |
str
|
key of relation to generate alias for |
required |
Returns:
Type | Description |
---|---|
str
|
generated alias |
Source code in ormar\relations\alias_manager.py
146 147 148 149 150 151 152 153 154 155 156 157 |
|
add_relation_type(source_model, relation_name, reverse_name=None)
Registers the relations defined in ormar models. Given the relation it registers also the reverse side of this relation.
Used by both ForeignKey and ManyToMany relations.
Each relation is registered as Model name and relation name. Each alias registered has to be unique.
Aliases are used to construct joins to assure proper links between tables. That way you can link to the same target tables from multiple fields on one model as well as from multiple different models in one join.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
source_model |
Type[Model]
|
model with relation defined |
required |
relation_name |
str
|
name of the relation to define |
required |
reverse_name |
Optional[str]
|
name of related_name fo given relation for m2m relations |
None
|
Returns:
Type | Description |
---|---|
None
|
none |
Source code in ormar\relations\alias_manager.py
108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 |
|
prefixed_columns(alias, table, fields=None)
staticmethod
Creates a list of aliases sqlalchemy text clauses from string alias and sqlalchemy.Table.
Optional list of fields to include can be passed to extract only those columns. List has to have sqlalchemy names of columns (ormar aliases) not the ormar ones.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
alias |
str
|
alias of given table |
required |
table |
Table
|
table from which fields should be aliased |
required |
fields |
Optional[List]
|
fields to include |
None
|
Returns:
Type | Description |
---|---|
List[text]
|
list of sqlalchemy text clauses with "column name as aliased name" |
Source code in ormar\relations\alias_manager.py
60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 |
|
prefixed_table_name(alias, table)
Creates text clause with table name with aliased name.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
alias |
str
|
alias of given table |
required |
table |
Table
|
table |
required |
Returns:
Type | Description |
---|---|
sqlalchemy text clause
|
sqlalchemy text clause as "table_name aliased_name" |
Source code in ormar\relations\alias_manager.py
93 94 95 96 97 98 99 100 101 102 103 104 105 106 |
|
resolve_relation_alias(from_model, relation_name)
Given model and relation name returns the alias for this relation.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
from_model |
Union[Type[Model], Type[ModelRow]]
|
model with relation defined |
required |
relation_name |
str
|
name of the relation field |
required |
Returns:
Type | Description |
---|---|
str
|
alias of the relation |
Source code in ormar\relations\alias_manager.py
159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 |
|
resolve_relation_alias_after_complex(source_model, relation_str, relation_field)
Given source model and relation string returns the alias for this complex relation if it exists, otherwise fallback to normal relation from a relation field definition.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
relation_field |
ForeignKeyField
|
field with direct relation definition |
required |
source_model |
Union[Type[Model], Type[ModelRow]]
|
model with query starts |
required |
relation_str |
str
|
string with relation joins defined |
required |
Returns:
Type | Description |
---|---|
str
|
alias of the relation |
Source code in ormar\relations\alias_manager.py
175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 |
|
Relation
Bases: Generic[T]
Keeps related Models and handles adding/removing of the children.
Source code in ormar\relations\relation.py
40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 |
|
__init__(manager, type_, field_name, to, through=None)
Initialize the Relation and keep the related models either as instances of passed Model, or as a RelationProxy which is basically a list of models with some special behavior, as it exposes QuerySetProxy and allows querying the related models already pre filtered by parent model.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
manager |
RelationsManager
|
reference to relation manager |
required |
type_ |
RelationType
|
type of the relation |
required |
field_name |
str
|
name of the relation field |
required |
to |
Type[T]
|
model to which relation leads to |
required |
through |
Optional[Type[Model]]
|
model through which relation goes for m2m relations |
None
|
Source code in ormar\relations\relation.py
45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 |
|
add(child)
Adds child Model to relation, either sets child as related model or adds it to the list in RelationProxy depending on relation type.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
child |
Model
|
model to add to relation |
required |
Source code in ormar\relations\relation.py
146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 |
|
get()
Return the related model or models from RelationProxy.
Returns:
Type | Description |
---|---|
Optional[Union[List[Model], Model]]
|
related model/models if set |
Source code in ormar\relations\relation.py
195 196 197 198 199 200 201 202 203 204 |
|
remove(child)
Removes child Model from relation, either sets None as related model or removes it from the list in RelationProxy depending on relation type.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
child |
Union[NewBaseModel, Type[NewBaseModel]]
|
model to remove from relation |
required |
Source code in ormar\relations\relation.py
176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 |
|
RelationType
Bases: Enum
Different types of relations supported by ormar:
- ForeignKey = PRIMARY
- reverse ForeignKey = REVERSE
- ManyToMany = MULTIPLE
Source code in ormar\relations\relation.py
25 26 27 28 29 30 31 32 33 34 35 36 37 |
|
RelationsManager
Manages relations on a Model, each Model has it's own instance.
Source code in ormar\relations\relation_manager.py
12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 |
|
__contains__(item)
Checks if relation with given name is already registered.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
item |
str
|
name of attribute |
required |
Returns:
Type | Description |
---|---|
bool
|
result of the check |
Source code in ormar\relations\relation_manager.py
29 30 31 32 33 34 35 36 37 38 |
|
add(parent, child, field)
staticmethod
Adds relation on both sides -> meaning on both child and parent models. One side of the relation is always weakref proxy to avoid circular refs.
Based on the side from which relation is added and relation name actual names of parent and child relations are established. The related models are registered on both ends.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
parent |
Model
|
parent model on which relation should be registered |
required |
child |
Model
|
child model to register |
required |
field |
ForeignKeyField
|
field with relation definition |
required |
Source code in ormar\relations\relation_manager.py
59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 |
|
get(name)
Returns the related model/models if relation is set. Actual call is delegated to Relation instance registered under relation name.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
name |
str
|
name of the relation |
required |
Returns:
Type | Description |
---|---|
Optional[Union[Model, List[Model]]
|
related model or list of related models if set |
Source code in ormar\relations\relation_manager.py
44 45 46 47 48 49 50 51 52 53 54 55 56 57 |
|
remove(name, child)
Removes given child from relation with given name. Since you can have many relations between two models you need to pass a name of relation from which you want to remove the child.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
name |
str
|
name of the relation |
required |
child |
Union[NewBaseModel, Type[NewBaseModel]]
|
child to remove from relation |
required |
Source code in ormar\relations\relation_manager.py
90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 |
|
remove_parent(item, parent, name)
staticmethod
Removes given parent from relation with given name. Since you can have many relations between two models you need to pass a name of relation from which you want to remove the parent.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
item |
Union[NewBaseModel, Type[NewBaseModel]]
|
model with parent registered |
required |
parent |
Model
|
parent Model |
required |
name |
str
|
name of the relation |
required |
Source code in ormar\relations\relation_manager.py
107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 |
|
get_relations_sides_and_names(to_field, parent, child)
Determines the names of child and parent relations names, as well as changes one of the sides of the relation into weakref.proxy to model.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
to_field |
ForeignKeyField
|
field with relation definition |
required |
parent |
Model
|
parent model |
required |
child |
Model
|
child model |
required |
Returns:
Type | Description |
---|---|
Tuple["Model", "Model", str, str]
|
parent, child, child_name, to_name |
Source code in ormar\relations\utils.py
10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
|