CtrlK
BlogDocsLog inGet started
Tessl Logo

tessl/pypi-sqlmodel

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

Overall
score

85%

Overview
Eval results
Files

Evaluation results

100%

Product Inventory Query System

Query Building with Select

Criteria
Without context
With context

select() usage

100%

100%

where() filtering

100%

100%

Multiple where() conditions

100%

100%

or_() for categories

100%

100%

order_by() sorting

100%

100%

offset() pagination

100%

100%

limit() pagination

100%

100%

session.exec() execution

100%

100%

100%

25%

Product Catalog Database Model

Field Configuration and Column Definition

Criteria
Without context
With context

Primary Key Configuration

100%

100%

Unique Constraints

100%

100%

String Length Constraints

100%

100%

Numeric Validation

0%

100%

Decimal Precision

33%

100%

Foreign Key Definition

100%

100%

Cascade Deletion

100%

100%

Default Values

100%

100%

Relationship Configuration

100%

100%

100%

User Profile Manager

UUID Primary Keys

Criteria
Without context
With context

UUID field type

100%

100%

Primary key configuration

100%

100%

Automatic UUID generation

100%

100%

SQLModel table definition

100%

100%

Session operations

100%

100%

UUID-based retrieval

100%

100%

100%

Hero Team Management System

Custom Relationship Loading Strategies

Criteria
Without context
With context

Model Definition

100%

100%

Relationship Setup

100%

100%

Default Lazy Loading

100%

100%

Joined Loading

100%

100%

Selectin Loading

100%

100%

15%

-5%

Employee Management System with Role-Based Polymorphism

Polymorphic Inheritance

Criteria
Without context
With context

Base model configuration

0%

0%

Discriminator column definition

33%

33%

Subclass polymorphic identity

0%

0%

Subclass inheritance structure

0%

0%

Polymorphic query usage

33%

0%

Session and CRUD

100%

100%

100%

Task Management Database

Database Engine and Table Creation

Criteria
Without context
With context

SQLModel class usage

100%

100%

Field definitions

100%

100%

Engine creation

100%

100%

Table creation

100%

100%

Session initialization

100%

100%

100%

Database Connection Pool Manager

Connection Pooling

Criteria
Without context
With context

Uses create_engine

100%

100%

Production pool_size

100%

100%

Production max_overflow

100%

100%

Production pool_timeout

100%

100%

Production pool_pre_ping

100%

100%

Test StaticPool

100%

100%

100%

Library Management System

Relationship Definition

Criteria
Without context
With context

Relationship() Usage

100%

100%

back_populates Configuration

100%

100%

Foreign Key Definition

100%

100%

Many-to-Many Link Model

100%

100%

Cascade Delete Configuration

100%

100%

SET NULL Behavior

100%

100%

Link Table Structure

100%

100%

31%

-20%

Product API Service

FastAPI Integration

Criteria
Without context
With context

SQLModel Database Model

60%

100%

Create Input Model

86%

0%

Public Output Model

0%

0%

Update Input Model

90%

0%

Decimal Field Configuration

50%

100%

FastAPI Endpoint Definition

66%

40%

Session Dependency

0%

0%

ORM to Pydantic Conversion

50%

0%

100%

Database Model Inspector

Inspection and Metadata

Criteria
Without context
With context

Uses inspect()

100%

100%

Accesses column information

100%

100%

Retrieves column types

100%

100%

Identifies primary keys

100%

100%

Accesses table metadata

100%

100%

Install with Tessl CLI

npx tessl i tessl/pypi-sqlmodel
Evaluated
Agent
Codex

Table of Contents