renovate 0.2.23

use crate::{
    parser::{AlterTable, AlterTableAction, SchemaId, TableRls},
    NodeItem,
};
use pg_query::{protobuf::AlterTableStmt, NodeEnum, NodeRef};

impl NodeItem for TableRls {
    type Inner = AlterTableStmt;

    fn id(&self) -> String {
        self.id.to_string()
    }

    fn type_name(&self) -> &'static str {
        "table RLS"
    }

    fn node(&self) -> &NodeEnum {
        &self.node
    }

    fn inner(&self) -> anyhow::Result<&Self::Inner> {
        match &self.node {
            NodeEnum::AlterTableStmt(stmt) => Ok(stmt),
            _ => anyhow::bail!("not a alter table statement"),
        }
    }

    /// we don't know what the old owner is, so we can only revert to session_user
    fn revert(&self) -> anyhow::Result<NodeEnum> {
        let sql = format!("ALTER TABLE {} DISABLE ROW LEVEL SECURITY", self.id);
        let parsed = pg_query::parse(&sql)?;
        let node = parsed.protobuf.nodes()[0].0;
        match node {
            NodeRef::AlterTableStmt(stmt) => Ok(NodeEnum::AlterTableStmt(stmt.clone())),
            _ => anyhow::bail!("not a alter table RLS statement"),
        }
    }
}

impl TryFrom<AlterTable> for TableRls {
    type Error = anyhow::Error;
    fn try_from(AlterTable { id, action, node }: AlterTable) -> Result<Self, Self::Error> {
        match action {
            AlterTableAction::Rls => Ok(TableRls::new(id, node)),
            _ => anyhow::bail!("not an owner change"),
        }
    }
}

impl TableRls {
    fn new(id: SchemaId, node: NodeEnum) -> Self {
        Self { id, node }
    }
}

#[cfg(test)]
mod tests {
    use super::*;
    use crate::{MigrationPlanner, NodeDiff};

    #[test]
    fn table_rls_should_parse() {
        let sql = "ALTER TABLE foo ENABLE ROW LEVEL SECURITY";
        let parsed: TableRls = sql.parse().unwrap();
        assert_eq!(parsed.id, SchemaId::new("public", "foo"));
    }

    #[test]
    fn table_rls_should_revert() {
        let sql = "ALTER TABLE foo ENABLE ROW LEVEL SECURITY";
        let parsed: TableRls = sql.parse().unwrap();
        let reverted = parsed.revert().unwrap().deparse().unwrap();
        assert_eq!(
            reverted,
            "ALTER TABLE public.foo DISABLE ROW LEVEL SECURITY"
        );
    }

    #[test]
    fn table_rls_should_generate_drop_create_migration() {
        let sql1 = "ALTER TABLE foo ENABLE ROW LEVEL SECURITY";

        let diff: NodeDiff<TableRls> = NodeDiff::with_old(sql1.parse().unwrap());
        let plan = diff.plan().unwrap();
        assert_eq!(plan, &["ALTER TABLE public.foo DISABLE ROW LEVEL SECURITY"]);
    }
}