Skip to content

graflo.architecture.onto_sql

ColumnInfo

Bases: BaseModel

Column information from PostgreSQL table.

Source code in graflo/architecture/onto_sql.py 
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
class ColumnInfo(BaseModel):
    """Column information from PostgreSQL table."""

    name: str
    type: str
    description: str = ""
    is_nullable: str = "YES"
    column_default: str | None = None
    is_pk: bool = False
    is_unique: bool = False
    ordinal_position: int | None = None
    sample_values: list[str] = []
    """Up to 5 sample values from the column (first rows); empty for vertex/edge ColumnInfo."""

sample_values = [] class-attribute instance-attribute

Up to 5 sample values from the column (first rows); empty for vertex/edge ColumnInfo.

EdgeTableInfo

Bases: BaseModel

Edge table information from schema introspection.

Source code in graflo/architecture/onto_sql.py 
38
39
40
41
42
43
44
45
46
47
48
49
50
class EdgeTableInfo(BaseModel):
    """Edge table information from schema introspection."""

    name: str
    schema_name: str
    columns: list[ColumnInfo]
    primary_key: list[str]
    foreign_keys: list[ForeignKeyInfo]
    source_table: str
    target_table: str
    source_column: str
    target_column: str
    relation: str | None = None

ForeignKeyInfo

Bases: BaseModel

Foreign key relationship information.

Source code in graflo/architecture/onto_sql.py 
19
20
21
22
23
24
25
class ForeignKeyInfo(BaseModel):
    """Foreign key relationship information."""

    column: str
    references_table: str
    references_column: str | None = None
    constraint_name: str | None = None

RawTableInfo

Bases: BaseModel

Raw table metadata: all tables with columns, types, and constraint metadata.

Source code in graflo/architecture/onto_sql.py 
53
54
55
56
57
58
59
60
61
62
class RawTableInfo(BaseModel):
    """Raw table metadata: all tables with columns, types, and constraint metadata."""

    name: str
    schema_name: str
    columns: list[ColumnInfo]
    primary_key: list[str]
    foreign_keys: list[ForeignKeyInfo]
    row_count_estimate: int | None = None
    """Approximate row count from pg_class.reltuples (updated by ANALYZE)."""

row_count_estimate = None class-attribute instance-attribute

Approximate row count from pg_class.reltuples (updated by ANALYZE).

SchemaIntrospectionResult

Bases: BaseModel

Result of PostgreSQL schema introspection.

Source code in graflo/architecture/onto_sql.py 
65
66
67
68
69
70
71
class SchemaIntrospectionResult(BaseModel):
    """Result of PostgreSQL schema introspection."""

    vertex_tables: list[VertexTableInfo]
    edge_tables: list[EdgeTableInfo]
    raw_tables: list[RawTableInfo]
    schema_name: str

VertexTableInfo

Bases: BaseModel

Vertex table information from schema introspection.

Source code in graflo/architecture/onto_sql.py 
28
29
30
31
32
33
34
35
class VertexTableInfo(BaseModel):
    """Vertex table information from schema introspection."""

    name: str
    schema_name: str
    columns: list[ColumnInfo]
    primary_key: list[str]
    foreign_keys: list[ForeignKeyInfo]