Browse Components - Code Extractor

function test_pyodbc_import

A diagnostic function that tests whether the pyodbc library can be imported and displays its version information and ODBC compatibility details.

File: /tf/active/vicechatdev/full_smartstat/test_odbc.py | Lines: 52-67

testing diagnostics database pyodbc import-check

function test_connection_string

Tests the format and creation of a SQL Server connection string using SQLAlchemy with ODBC Driver 18, without establishing an actual database connection.

File: /tf/active/vicechatdev/full_smartstat/test_odbc.py | Lines: 31-50

database sql-server connection-string testing validation

function test_odbc_driver

Tests the availability of ODBC drivers on the system, specifically checking for SQL Server drivers and returning a boolean indicating whether SQL Server drivers are found.

File: /tf/active/vicechatdev/full_smartstat/test_odbc.py | Lines: 10-29

odbc database driver-detection sql-server diagnostics

function get_default_schema_file

Returns the absolute file path to the default database schema JSON file (database_schema_20251003_120434.json) located in the same directory as the function.

File: /tf/active/vicechatdev/full_smartstat/sql_query_generator.py | Lines: 1927-1930

file-path configuration database-schema path-resolution utility

function get_default_connection_config

Retrieves the default database connection configuration by loading settings from a sql_config.py file located in the same directory as the function.

File: /tf/active/vicechatdev/full_smartstat/sql_query_generator.py | Lines: 1921-1925

database configuration connection sql config-loading

function load_connection_config

Loads database connection configuration from a specified configuration file and returns a ConnectionConfig object.

File: /tf/active/vicechatdev/full_smartstat/sql_query_generator.py | Lines: 1917-1919

configuration database connection file-loading initialization

function load_database_schema

Loads a database schema from a JSON file and returns it as a DatabaseSchema object.

File: /tf/active/vicechatdev/full_smartstat/sql_query_generator.py | Lines: 1913-1915

database schema json loader deserialization

class SQLQueryGenerator

Generates SQL queries based on user requests and database schema

File: /tf/active/vicechatdev/full_smartstat/sql_query_generator.py | Lines: 347-1909

class sqlquerygenerator

class ConnectionConfig

A dataclass that stores and manages database connection configuration parameters for SQL Server connections, providing methods to load from config files and generate connection strings.

File: /tf/active/vicechatdev/full_smartstat/sql_query_generator.py | Lines: 310-345

database configuration sql-server connection dataclass

class DatabaseSchema

A dataclass that represents comprehensive database schema information, including table structures, columns, relationships, and categorizations for SQL database introspection and query generation.

File: /tf/active/vicechatdev/full_smartstat/sql_query_generator.py | Lines: 18-307

database schema metadata introspection SQL

class DataProcessor

Handles data loading, validation, and preprocessing

File: /tf/active/vicechatdev/full_smartstat/data_processor.py | Lines: 25-637

class dataprocessor

function test_agent_executor

Integration test function that validates the AgentExecutor's ability to generate and execute data analysis projects using synthetic test data.

File: /tf/active/vicechatdev/full_smartstat/debug_agent.py | Lines: 24-101

testing integration-test agent-executor data-analysis pandas

function test_result_type_compatibility

A test function that verifies result type compatibility between enhanced and standard workflows by comparing their result type strings.

File: /tf/active/vicechatdev/full_smartstat/test_enhanced_data_loading.py | Lines: 59-69

testing validation compatibility workflow unit-test

function test_analysis_extraction

A test function that validates the extraction of analysis descriptions from combined request strings containing 'Analysis:' and 'Data:' sections.

File: /tf/active/vicechatdev/full_smartstat/test_enhanced_data_loading.py | Lines: 9-57

testing string-parsing text-extraction validation unit-test

class StatisticalAnalysisService

Main service for statistical analysis orchestration

File: /tf/active/vicechatdev/full_smartstat/services.py | Lines: 76-1564

class statisticalanalysisservice

function safe_json_dumps

Safely serializes Python objects to JSON format, handling NaN values and datetime objects that would otherwise cause serialization errors.

File: /tf/active/vicechatdev/full_smartstat/services.py | Lines: 65-74

json serialization data-conversion nan-handling datetime

function get_manual_relationship_manager

Returns a singleton instance of the ManualRelationshipManager class, creating it on first access using lazy initialization.

File: /tf/active/vicechatdev/full_smartstat/manual_relationships.py | Lines: 158-163

singleton design-pattern global-state lazy-initialization relationship-management

class ManualRelationshipManager

A class that manages manually defined database relationships with persistent JSON storage, allowing users to add, retrieve, update, and remove relationship definitions between database tables.

File: /tf/active/vicechatdev/full_smartstat/manual_relationships.py | Lines: 16-153

database relationships persistence json-storage data-management

class TwoPassSqlWorkflow

Two-pass SQL generation workflow with iteration and error correction

File: /tf/active/vicechatdev/full_smartstat/two_pass_sql_workflow.py | Lines: 47-856

class twopasssqlworkflow

class IterationResult

A dataclass that encapsulates the complete results of a single iteration in a two-pass process, including table selection, SQL generation, and execution outcomes.

File: /tf/active/vicechatdev/full_smartstat/two_pass_sql_workflow.py | Lines: 37-45

dataclass result-container iteration-tracking sql-execution query-generation