Method get_table_stats

xtop/core/materializer.py:203–226

Get row counts and sizes for materialized tables

(self)

        return result
    
    def get_table_stats(self) -> Dict[str, Dict[str, int]]:
        """Get row counts and sizes for materialized tables"""
        stats = {}
        
        for source, table_name in self.TABLE_NAMES.items():
            try:
                # Get row count
                row_count = self.conn.execute(
                    f"SELECT COUNT(*) FROM {table_name}"
                ).fetchone()[0]
                
                # Get approximate table size (this is a rough estimate)
                col_count = len(self.conn.execute(
                    f"DESCRIBE {table_name}"
                ).fetchall())
                
                stats[source] = {
                    'rows': row_count,
                    'columns': col_count
                }
            except:
                stats[source] = {'rows': 0, 'columns': 0}
        
        return stats