Skip to content

enums

Defines statement types and table writing types

StatementType

Bases: StrEnum

Type of Statements we will deal with

Source code in xerini/enums.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
34
35
36
class StatementType(StrEnum):
    """Type of Statements we will deal with"""

    MOVEMENT = auto()
    UPDATE = auto()
    VIEW = auto()
    IGNORE_ME = auto()

    @classmethod
    def from_query_type(cls, smd_qt: Optional[QueryType] = None):
        """Maps QueryTypes to StatementTypes"""
        ans = cls.IGNORE_ME
        if smd_qt in {QueryType.INSERT, QueryType.CREATE}:
            ans = cls.MOVEMENT
        elif smd_qt in {
            QueryType.UPDATE,
            QueryType.DELETE,
            QueryType.ALTER,
            QueryType.DROP,
            QueryType.TRUNCATE,
        }:
            ans = cls.UPDATE
        elif smd_qt == QueryType.SELECT:
            ans = cls.VIEW
        else:
            pass
        return ans

from_query_type(smd_qt=None) classmethod

Maps QueryTypes to StatementTypes

Source code in xerini/enums.py 
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
@classmethod
def from_query_type(cls, smd_qt: Optional[QueryType] = None):
    """Maps QueryTypes to StatementTypes"""
    ans = cls.IGNORE_ME
    if smd_qt in {QueryType.INSERT, QueryType.CREATE}:
        ans = cls.MOVEMENT
    elif smd_qt in {
        QueryType.UPDATE,
        QueryType.DELETE,
        QueryType.ALTER,
        QueryType.DROP,
        QueryType.TRUNCATE,
    }:
        ans = cls.UPDATE
    elif smd_qt == QueryType.SELECT:
        ans = cls.VIEW
    else:
        pass
    return ans

TableWriteType

Bases: StrEnum

Type of writing being done by a statement

Source code in xerini/enums.py 
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
class TableWriteType(StrEnum):
    """Type of writing being done by a statement"""

    UPDATING = auto()
    REBUILDING = auto()
    DELETING = auto()
    NO_WRITING = auto()

    @classmethod
    def from_statement_query(
        cls, stmt_tp: StatementType, qry_tp: Optional[QueryType] = None
    ):
        """Maps (StatementType, QueryType) to TableWriteType"""
        ans = TableWriteType.NO_WRITING
        if stmt_tp in {StatementType.UPDATE, StatementType.MOVEMENT} and qry_tp in {
            QueryType.INSERT,
            QueryType.UPDATE,
            QueryType.ALTER,
        }:
            ans = TableWriteType.UPDATING
        elif qry_tp in {QueryType.CREATE}:
            ans = TableWriteType.REBUILDING
        elif qry_tp in {QueryType.DROP, QueryType.TRUNCATE, QueryType.DELETE}:
            ans = TableWriteType.DELETING
        else:
            pass
        return ans

from_statement_query(stmt_tp, qry_tp=None) classmethod

Maps (StatementType, QueryType) to TableWriteType

Source code in xerini/enums.py 
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
@classmethod
def from_statement_query(
    cls, stmt_tp: StatementType, qry_tp: Optional[QueryType] = None
):
    """Maps (StatementType, QueryType) to TableWriteType"""
    ans = TableWriteType.NO_WRITING
    if stmt_tp in {StatementType.UPDATE, StatementType.MOVEMENT} and qry_tp in {
        QueryType.INSERT,
        QueryType.UPDATE,
        QueryType.ALTER,
    }:
        ans = TableWriteType.UPDATING
    elif qry_tp in {QueryType.CREATE}:
        ans = TableWriteType.REBUILDING
    elif qry_tp in {QueryType.DROP, QueryType.TRUNCATE, QueryType.DELETE}:
        ans = TableWriteType.DELETING
    else:
        pass
    return ans