|
1
|
|
|
# -*- coding: utf-8 -*- |
|
2
|
|
|
# pylint: disable=C0303 |
|
3
|
1 |
|
""" |
|
4
|
|
|
This module contains a basic Connection Table Models |
|
5
|
|
|
""" |
|
6
|
1 |
|
from loglan_db import db |
|
7
|
1 |
|
from loglan_db.model_db import t_name_connect_authors, \ |
|
8
|
|
|
t_name_authors, t_name_words, t_name_connect_words, \ |
|
9
|
|
|
t_name_connect_keys, t_name_keys, t_name_definitions |
|
10
|
|
|
|
|
11
|
|
|
|
|
12
|
1 |
|
t_connect_authors = db.Table( |
|
13
|
|
|
t_name_connect_authors, db.metadata, |
|
14
|
|
|
db.Column('AID', db.ForeignKey(f'{t_name_authors}.id'), primary_key=True), |
|
15
|
|
|
db.Column('WID', db.ForeignKey(f'{t_name_words}.id'), primary_key=True), ) |
|
16
|
|
|
"""`(sqlalchemy.sql.schema.Table)`: |
|
17
|
|
|
Connecting table for "many-to-many" relationship |
|
18
|
|
|
between `BaseAuthor` and `BaseWord` objects""" |
|
19
|
|
|
|
|
20
|
1 |
|
t_connect_words = db.Table( |
|
21
|
|
|
t_name_connect_words, db.metadata, |
|
22
|
|
|
db.Column('parent_id', db.ForeignKey(f'{t_name_words}.id'), primary_key=True), |
|
23
|
|
|
db.Column('child_id', db.ForeignKey(f'{t_name_words}.id'), primary_key=True), ) |
|
24
|
|
|
"""`(sqlalchemy.sql.schema.Table)`: |
|
25
|
|
|
Connecting table for "many-to-many" relationship |
|
26
|
|
|
(parent-child) between `BaseWord` objects""" |
|
27
|
|
|
|
|
28
|
1 |
|
t_connect_keys = db.Table( |
|
29
|
|
|
t_name_connect_keys, db.metadata, |
|
30
|
|
|
db.Column('KID', db.ForeignKey(f'{t_name_keys}.id'), primary_key=True), |
|
31
|
|
|
db.Column('DID', db.ForeignKey(f'{t_name_definitions}.id'), primary_key=True), ) |
|
32
|
1 |
|
"""`(sqlalchemy.sql.schema.Table)`: |
|
33
|
|
|
Connecting table for "many-to-many" relationship |
|
34
|
|
|
between `BaseDefinition` and `BaseKey` objects""" |
|
35
|
|
|
|
torrua /
loglan_db
