Get a SQL fragment by name Args: name: Fragment name (without .sql extension) Returns: SQL fragment content
(self, name: str)
| 44 | self.logger.error(f"Error loading fragment {fragment_file}: {e}") |
| 45 | |
| 46 | def get_fragment(self, name: str) -> str: |
| 47 | """Get a SQL fragment by name |
| 48 | |
| 49 | Args: |
| 50 | name: Fragment name (without .sql extension) |
| 51 | |
| 52 | Returns: |
| 53 | SQL fragment content |
| 54 | """ |
| 55 | if name not in self._fragments_cache: |
| 56 | # Try to load it dynamically |
| 57 | fragment_file = self.fragment_dir / f"{name}.sql" |
| 58 | if fragment_file.exists(): |
| 59 | try: |
| 60 | self._fragments_cache[name] = fragment_file.read_text() |
| 61 | except Exception as e: |
| 62 | if self.logger: |
| 63 | self.logger.error(f"Error loading fragment {name}: {e}") |
| 64 | return f"-- Fragment {name} not found" |
| 65 | |
| 66 | return self._fragments_cache.get(name, f"-- Fragment {name} not found") |
| 67 | |
| 68 | def build_with_clause(self, required_ctes: List[str]) -> str: |
| 69 | """Build a WITH clause with required CTEs |
no test coverage detected