dsl-parse 3.0.0

Facade over sqlparser / pg_query producing a unified SQL Statement representation for duck-sqllsp.
Documentation
use dsl_parse::{Dialect, StatementKind, parse};

#[test]
fn create_table_collects_columns() {
  let sql = "CREATE TABLE IF NOT EXISTS users (id UUID PRIMARY KEY DEFAULT gen_random_uuid(), email TEXT NOT NULL);";
  let p = parse(sql, Dialect::Postgres);
  assert!(p.errors.is_empty(), "errors: {:?}", p.errors);
  let StatementKind::CreateTable(c) = &p.statements[0].kind else {
    panic!("expected CreateTable, got {:?}", p.statements[0].kind);
  };
  assert!(c.if_not_exists);
  assert_eq!(c.table.name, "users");
  assert_eq!(c.columns.len(), 2);
  assert_eq!(c.columns[0].name, "id");
  assert!(!c.columns[0].nullable, "PK is implicitly NOT NULL");
  assert!(!c.columns[1].nullable, "explicit NOT NULL");
}

#[test]
fn drop_table_collects_targets() {
  let p = parse("DROP TABLE IF EXISTS users, sessions;", Dialect::Postgres);
  let StatementKind::DropTable(d) = &p.statements[0].kind else { panic!() };
  assert!(d.if_exists);
  assert_eq!(d.tables.len(), 2);
}

#[test]
fn alter_table_keeps_target() {
  let p = parse("ALTER TABLE users ADD COLUMN role TEXT;", Dialect::Postgres);
  let StatementKind::AlterTable(a) = &p.statements[0].kind else { panic!() };
  assert_eq!(a.table.name, "users");
}