Method handle_information_schema_tables_query

src/session/db_handler.rs:2639–2705

Handle information_schema.tables query

(&self, query: &str, session_id: &Uuid)

    
    /// Handle information_schema.tables query
    async fn handle_information_schema_tables_query(&self, query: &str, session_id: &Uuid) -> Result<DbResponse, PgSqliteError> {
        debug!("Handling information_schema.tables query: {}", query);
        
        // Check if this is a simple table_name only query
        if query.contains("SELECT table_name") && !query.contains("table_catalog") {
            // Simple query - just return table names
            let tables_query = "SELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%' AND name NOT LIKE '__pgsqlite_%' ORDER BY name";
            
            return self.connection_manager.execute_with_session(session_id, |conn| {
                let mut stmt = conn.prepare(tables_query)?;
                let rows: Result<Vec<_>, _> = stmt.query_map([], |row| {
                    let table_name: String = row.get(0)?;
                    Ok(vec![Some(table_name.into_bytes())])
                })?.collect();
                
                Ok(DbResponse {
                    columns: vec!["table_name".to_string()],
                    rows: rows?,
                    rows_affected: 0,
                })
            });
        }
        
        // Full information_schema.tables query
        let tables_query = "SELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%' AND name NOT LIKE '__pgsqlite_%' ORDER BY name";
        
        self.connection_manager.execute_with_session(session_id, |conn| {
            let mut stmt = conn.prepare(tables_query)?;
            let rows: Result<Vec<_>, _> = stmt.query_map([], |row| {
                let table_name: String = row.get(0)?;
                // Return full information_schema.tables row
                Ok(vec![
                    Some("main".to_string().into_bytes()),      // table_catalog
                    Some("public".to_string().into_bytes()),    // table_schema  
                    Some(table_name.into_bytes()),              // table_name
                    Some("BASE TABLE".to_string().into_bytes()), // table_type
                    None,                                       // self_referencing_column_name
                    None,                                       // reference_generation
                    None,                                       // user_defined_type_catalog
                    None,                                       // user_defined_type_schema
                    None,                                       // user_defined_type_name
                    None,                                       // is_insertable_into
                    None,                                       // is_typed
                    None,                                       // commit_action
                ])
            })?.collect();
            
            Ok(DbResponse {
                columns: vec![
                    "table_catalog".to_string(),
                    "table_schema".to_string(),
                    "table_name".to_string(),
                    "table_type".to_string(),
                    "self_referencing_column_name".to_string(),
                    "reference_generation".to_string(),
                    "user_defined_type_catalog".to_string(),
                    "user_defined_type_schema".to_string(),
                    "user_defined_type_name".to_string(),