tessl/pypi-sqlmodel

SQLModel, SQL databases in Python, designed for simplicity, compatibility, and robustness.

Overall
score

85%

Overview

Eval results

Files

Database Model Inspector

Name: tessl/pypi-sqlmodel
Author: tessl

A utility tool that provides inspection capabilities for database models, allowing users to examine table structure, column metadata, and model properties.

Capabilities

Model Inspection

Retrieves all column names from a database model class @test
Returns column data types for each column in a model @test
Identifies which columns are primary keys @test

Table Metadata Access

Retrieves the table name associated with a model @test

Implementation

@generates

API

def get_column_names(model_class) -> list[str]:
    """
    Returns a list of all column names defined in the given model class.

    Args:
        model_class: A database model class

    Returns:
        A list of column names as strings
    """
    pass

def get_column_types(model_class) -> dict[str, str]:
    """
    Returns a dictionary mapping column names to their SQL type representations.

    Args:
        model_class: A database model class

    Returns:
        A dictionary where keys are column names and values are SQL type strings
    """
    pass

def get_primary_keys(model_class) -> list[str]:
    """
    Returns a list of column names that are marked as primary keys.

    Args:
        model_class: A database model class

    Returns:
        A list of primary key column names
    """
    pass

def get_table_name(model_class) -> str:
    """
    Returns the database table name for the given model class.

    Args:
        model_class: A database model class

    Returns:
        The table name as a string
    """
    pass

Dependencies { .dependencies }

sqlmodel { .dependency }

Provides database ORM and inspection capabilities.

Install with Tessl CLI

npx tessl i tessl/pypi-sqlmodel