use std::time::{Instant, SystemTime, UNIX_EPOCH};
use tree_sitter::{Node as TsNode, Parser, Tree};
use crate::types::{
generate_node_id, Edge, EdgeKind, ExtractionResult, Node, NodeKind, UnresolvedRef, Visibility,
};
pub struct SqlExtractor;
struct ExtractionState {
nodes: Vec<Node>,
edges: Vec<Edge>,
unresolved_refs: Vec<UnresolvedRef>,
errors: Vec<String>,
file_path: String,
source: Vec<u8>,
file_node_id: String,
timestamp: u64,
}
impl ExtractionState {
fn new(file_path: &str, source: &str) -> Self {
let timestamp = SystemTime::now()
.duration_since(UNIX_EPOCH)
.unwrap_or_default()
.as_secs();
let file_node_id = generate_node_id(file_path, &NodeKind::File, file_path, 0);
Self {
nodes: Vec::new(),
edges: Vec::new(),
unresolved_refs: Vec::new(),
errors: Vec::new(),
file_path: file_path.to_string(),
source: source.as_bytes().to_vec(),
file_node_id,
timestamp,
}
}
fn node_text(&self, node: TsNode<'_>) -> String {
node.utf8_text(&self.source)
.unwrap_or("<invalid utf8>")
.to_string()
}
}
impl SqlExtractor {
pub fn extract_sql(file_path: &str, source: &str) -> ExtractionResult {
let start = Instant::now();
let mut state = ExtractionState::new(file_path, source);
let tree = match Self::parse_source(source) {
Ok(t) => t,
Err(msg) => {
state.errors.push(msg);
return Self::build_result(state, start);
}
};
let file_node = Node {
id: state.file_node_id.clone(),
kind: NodeKind::File,
name: file_path.to_string(),
qualified_name: file_path.to_string(),
file_path: file_path.to_string(),
start_line: 0,
attrs_start_line: 0,
end_line: source.lines().count().saturating_sub(1) as u32,
start_column: 0,
end_column: 0,
signature: None,
docstring: None,
visibility: Visibility::Pub,
is_async: false,
branches: 0,
loops: 0,
returns: 0,
max_nesting: 0,
unsafe_blocks: 0,
unchecked_calls: 0,
assertions: 0,
updated_at: state.timestamp,
};
state.nodes.push(file_node);
let root = tree.root_node();
Self::visit_children(&mut state, root);
Self::build_result(state, start)
}
fn parse_source(source: &str) -> Result<Tree, String> {
let mut parser = Parser::new();
let language = crate::extraction::ts_provider::language("sql");
parser
.set_language(&language)
.map_err(|e| format!("failed to load SQL grammar: {e}"))?;
parser
.parse(source, None)
.ok_or_else(|| "tree-sitter parse returned None".to_string())
}
fn visit_children(state: &mut ExtractionState, node: TsNode<'_>) {
let mut cursor = node.walk();
if cursor.goto_first_child() {
loop {
Self::visit_node(state, cursor.node());
if !cursor.goto_next_sibling() {
break;
}
}
}
}
fn visit_node(state: &mut ExtractionState, node: TsNode<'_>) {
match node.kind() {
"create_table" | "create_view" => Self::emit_named(state, node, NodeKind::Class),
"create_function" | "create_procedure" => {
Self::emit_named(state, node, NodeKind::Function);
}
_ => Self::visit_children(state, node),
}
}
fn emit_named(state: &mut ExtractionState, node: TsNode<'_>, kind: NodeKind) {
let name = Self::extract_object_name(state, node)
.unwrap_or_else(|| format!("<anonymous_{}>", node.kind()));
let start_line = node.start_position().row as u32;
let end_line = node.end_position().row as u32;
let text = state.node_text(node);
let sig = text.lines().next().map(|l| l.trim().to_string());
let qualified_name = format!("{}::{}", state.file_path, name);
let id = generate_node_id(&state.file_path, &kind, &name, start_line);
let graph_node = Node {
id: id.clone(),
kind,
name,
qualified_name,
file_path: state.file_path.clone(),
start_line,
attrs_start_line: start_line,
end_line,
start_column: node.start_position().column as u32,
end_column: node.end_position().column as u32,
signature: sig,
docstring: None,
visibility: Visibility::Pub,
is_async: false,
branches: 0,
loops: 0,
returns: 0,
max_nesting: 0,
unsafe_blocks: 0,
unchecked_calls: 0,
assertions: 0,
updated_at: state.timestamp,
};
state.nodes.push(graph_node);
state.edges.push(Edge {
source: state.file_node_id.clone(),
target: id,
kind: EdgeKind::Contains,
line: Some(start_line),
});
}
fn extract_object_name(state: &ExtractionState, node: TsNode<'_>) -> Option<String> {
let mut cursor = node.walk();
if cursor.goto_first_child() {
loop {
let child = cursor.node();
if child.kind() == "object_reference" {
let text = state.node_text(child);
let name = text
.split('.')
.next_back()
.unwrap_or(&text)
.trim()
.to_string();
return Some(name);
}
if !cursor.goto_next_sibling() {
break;
}
}
}
None
}
fn build_result(state: ExtractionState, start: Instant) -> ExtractionResult {
ExtractionResult {
nodes: state.nodes,
edges: state.edges,
unresolved_refs: state.unresolved_refs,
errors: state.errors,
duration_ms: start.elapsed().as_millis() as u64,
}
}
}
impl crate::extraction::LanguageExtractor for SqlExtractor {
fn extensions(&self) -> &[&str] {
&["sql"]
}
fn language_name(&self) -> &'static str {
"SQL"
}
fn extract(&self, file_path: &str, source: &str) -> ExtractionResult {
Self::extract_sql(file_path, source)
}
}