🔍 Code Extractor

Search Components

Full-Text: Fast keyword matching | Semantic: AI-powered understanding of intent (finds similar concepts)

Search Results for "SQL"

Found 45 matching component(s)

  • class Config

    Configuration class that manages application-wide settings, directory structures, API keys, and operational parameters for a statistical analysis application.

    File: /tf/active/vicechatdev/vice_ai/smartstat_config.py

    configuration settings flask api-keys directory-management

  • class DataSourceType

    An enumeration class that defines the different types of data sources available in the system.

    File: /tf/active/vicechatdev/vice_ai/models.py

    enum enumeration data-source constants type-safety

  • class DataSource

    A dataclass that represents configuration for various data sources, supporting file-based, SQL database, and query-based data access patterns.

    File: /tf/active/vicechatdev/vice_ai/models.py

    dataclass configuration data-source serialization sql

  • class DataAnalysisSession_v1

    A dataclass representing a statistical analysis session that is linked to specific document sections, managing analysis state, messages, plots, and configuration.

    File: /tf/active/vicechatdev/vice_ai/models.py

    dataclass analysis session-management state-tracking data-analysis

  • class DataSourceType_v2

    An enumeration class that defines the different types of data sources available in the system.

    File: /tf/active/vicechatdev/vice_ai/models.py

    enum enumeration data-source constants type-safety

  • class DataSource_v1

    A dataclass that encapsulates configuration for various data sources used in analysis, supporting file-based, SQL database, and query-based data sources.

    File: /tf/active/vicechatdev/vice_ai/models.py

    dataclass configuration data-source sql database

  • class DataAnalysisSession

    A dataclass representing a data analysis session that is linked to a specific text section within a document, managing conversation messages, analysis results, plots, and configuration.

    File: /tf/active/vicechatdev/vice_ai/models.py

    data-analysis session-management dataclass serialization conversation

  • class DataSourceType_v1

    An enumeration class that defines the different types of data sources available in the system.

    File: /tf/active/vicechatdev/vice_ai/smartstat_models.py

    enum enumeration data-source constants type-safety

  • class DataSource_v2

    A dataclass that encapsulates configuration for various data sources including files, SQL databases, and SQL workflow metadata.

    File: /tf/active/vicechatdev/vice_ai/smartstat_models.py

    dataclass configuration data-source sql file-handling

  • class StatisticalSession

    A dataclass representing a statistical analysis session that tracks metadata, configuration, and status of data analysis operations.

    File: /tf/active/vicechatdev/vice_ai/smartstat_models.py

    dataclass session-management statistical-analysis serialization metadata

  • class DatabaseManager_v1

    Database manager for SmartStat following vice_ai patterns

    File: /tf/active/vicechatdev/vice_ai/smartstat_models.py

    class databasemanager

  • function test_enhanced_workflow

    A comprehensive test function that validates the EnhancedSQLWorkflow system by testing component initialization, request parsing, and data assessment capabilities.

    File: /tf/active/vicechatdev/full_smartstat/test_enhanced_workflow.py

    testing integration-test workflow sql data-analysis

  • function test_workflow_progress_structure

    A test function that validates the structure and behavior of a workflow progress tracking system for SQL query processing, including progress states, step transitions, and completion data.

    File: /tf/active/vicechatdev/full_smartstat/test_enhanced_progress.py

    testing workflow progress-tracking sql validation

  • function load_sql_workflow_data

    Flask route handler that processes user natural language queries by leveraging an LLM to generate and execute SQL queries against a database, returning the results for a specific session.

    File: /tf/active/vicechatdev/full_smartstat/app.py

    flask api-endpoint sql-workflow llm-integration natural-language-query

  • function execute_enhanced_workflow_background

    Executes an enhanced SQL workflow in a background thread, retrieving data from a database, processing it through an AI-powered workflow, and automatically triggering statistical analysis on the results.

    File: /tf/active/vicechatdev/full_smartstat/app.py

    background-processing threading sql-workflow data-retrieval ai-powered

  • function get_field_suggestions

    Flask route handler that processes POST requests to generate field suggestions based on a user's natural language request by leveraging an enhanced SQL workflow system.

    File: /tf/active/vicechatdev/full_smartstat/app.py

    flask api-endpoint field-suggestions natural-language-processing database-schema

  • function enhanced_sql_workflow

    Flask route handler that initiates an enhanced SQL workflow with iterative optimization, executing data extraction and analysis in a background thread while providing real-time progress tracking.

    File: /tf/active/vicechatdev/full_smartstat/app.py

    flask api-endpoint sql-workflow async-processing background-thread

  • function enhanced_workflow_progress

    Flask route handler that retrieves and returns the current progress status of an enhanced SQL workflow, including step completion, progress percentage, and final results if completed.

    File: /tf/active/vicechatdev/full_smartstat/app.py

    flask api-endpoint progress-tracking workflow status-monitoring

  • function cancel_enhanced_workflow

    Flask route handler that cancels an in-progress enhanced workflow by workflow ID, returning a JSON response indicating success or failure.

    File: /tf/active/vicechatdev/full_smartstat/app.py

    flask rest-api workflow-management cancellation http-post

  • function load_sql_data

    Flask route handler that loads data from a SQL database using a provided connection string and query, creating a data source for a specific analysis session.

    File: /tf/active/vicechatdev/full_smartstat/app.py

    flask sql database data-loading api-endpoint

  • class QueryIteration

    A dataclass representing a single iteration in an iterative SQL query generation and evaluation workflow, capturing the query, its results, assessment, and improvement suggestions.

    File: /tf/active/vicechatdev/full_smartstat/enhanced_sql_workflow.py

    dataclass sql query-generation iteration evaluation

  • class EnhancedSQLWorkflow

    Enhanced SQL workflow with iterative optimization

    File: /tf/active/vicechatdev/full_smartstat/enhanced_sql_workflow.py

    class enhancedsqlworkflow

  • function query_iteration_to_dict

    Instance method that serializes a QueryIteration object into a dictionary representation, including iteration metadata, SQL query details, data shape, and assessment information.

    File: /tf/active/vicechatdev/full_smartstat/enhanced_sql_workflow.py

    serialization dictionary-conversion data-transformation query-iteration sql-workflow

  • class Config_v1

    Configuration class that centralizes all application settings including Flask configuration, directory paths, API keys, LLM model settings, and statistical analysis parameters.

    File: /tf/active/vicechatdev/full_smartstat/config.py

    configuration settings flask llm openai

  • class TableSelectionResult

    A dataclass that encapsulates the results of a table selection operation, including selected tables, reasoning, confidence score, and suggested joins.

    File: /tf/active/vicechatdev/full_smartstat/two_pass_sql_workflow.py

    dataclass table-selection database query-generation sql

  • class SqlGenerationResult

    A dataclass that encapsulates the results of an SQL query generation operation, including the generated query, explanation, confidence score, and metadata about database objects used.

    File: /tf/active/vicechatdev/full_smartstat/two_pass_sql_workflow.py

    dataclass sql-generation query-metadata result-container database

  • 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

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

  • class TwoPassSqlWorkflow

    Two-pass SQL generation workflow with iteration and error correction

    File: /tf/active/vicechatdev/full_smartstat/two_pass_sql_workflow.py

    class twopasssqlworkflow

  • class StatisticalAnalysisService

    Main service for statistical analysis orchestration

    File: /tf/active/vicechatdev/full_smartstat/services.py

    class statisticalanalysisservice

  • class DataProcessor

    Handles data loading, validation, and preprocessing

    File: /tf/active/vicechatdev/full_smartstat/data_processor.py

    class dataprocessor

  • 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

    database schema metadata introspection SQL

  • 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

    database configuration sql-server connection dataclass

  • class SQLQueryGenerator

    Generates SQL queries based on user requests and database schema

    File: /tf/active/vicechatdev/full_smartstat/sql_query_generator.py

    class sqlquerygenerator

  • 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

    database configuration connection sql config-loading

  • function main_v62

    Demonstrates a SmartStat SQL workflow by loading a database schema, initializing a SQL query generator, and generating SQL queries from natural language requests with detailed output and metadata.

    File: /tf/active/vicechatdev/full_smartstat/demo_sql_workflow.py

    demonstration workflow sql-generation natural-language-processing database-schema

  • 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

    odbc database driver-detection sql-server diagnostics

  • 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

    database sql-server connection-string testing validation

  • function main_v42

    Orchestrates and executes a suite of ODBC connectivity tests for SQL Server, providing formatted output and a summary of test results.

    File: /tf/active/vicechatdev/full_smartstat/test_odbc.py

    testing odbc sql-server connectivity database

  • function demonstrate_sql_workflow_v1

    Demonstrates the enhanced SQL workflow for the SmartStat system by loading configurations, initializing the SQL query generator, testing natural language to SQL conversion, and displaying schema analysis.

    File: /tf/active/vicechatdev/full_smartstat/demo_enhanced_sql_workflow.py

    demonstration testing sql-generation natural-language-processing database-schema

  • class StatisticalAnalysisService_v1

    Main service for statistical analysis orchestration

    File: /tf/active/vicechatdev/smartstat/services.py

    class statisticalanalysisservice

  • class DataProcessor_v1

    Handles data loading, validation, and preprocessing

    File: /tf/active/vicechatdev/smartstat/data_processor.py

    class dataprocessor

  • class SQLQueryGenerator_v1

    Generates SQL queries based on user requests and database schema

    File: /tf/active/vicechatdev/smartstat/sql_query_generator.py

    class sqlquerygenerator

  • function main_v63

    Demonstrates the SmartStat SQL Workflow by loading a database schema, initializing a SQL query generator, and generating SQL queries from natural language requests for various laboratory data analysis scenarios.

    File: /tf/active/vicechatdev/smartstat/demo_sql_workflow.py

    demonstration sql-generation natural-language-processing database-schema workflow

  • function demonstrate_sql_workflow

    Demonstrates the enhanced SQL workflow for the SmartStat system by loading configurations, initializing SQL query generator, testing natural language to SQL conversion, and displaying schema analysis.

    File: /tf/active/vicechatdev/smartstat/demo_enhanced_sql_workflow.py

    demonstration sql-generation natural-language-processing database-schema testing

  • function arglexsort

    Returns the indices that would lexicographically sort multiple arrays, treating them as columns of a structured array.

    File: /tf/active/vicechatdev/patches/util.py

    sorting lexicographical-sort multi-key-sort numpy array-manipulation

Search Examples