Verify that public views are defined the way they should be (matching whitelist/greylist)
Closed, DeclinedPublic
Actions

Assigned To

None

Authored By

	yuvipanda
	Dec 29 2014, 9:02 PM

Description

This would have us get the sql used to define the view, parse it, and verify that it matches what is present in whitelist / greylist.

Related Objects

Mentioned In: rOSLA971fb4e69052: Add report that verifies view definitions

Event Timeline

Could use https://pypi.python.org/pypi/sqlparse

yuvipanda moved this task from Backlog to Doing on the LabsDB-Auditor board.Jan 5 2015, 1:20 PM

yuvipanda merged a task: T85783: Verify that public view definitions match labsdb model.

https://gerrit.wikimedia.org/r/#/c/182848/ just implements a manual parser by itself :) Parses only a subset of SQL that's useful in view definers, after some re based cleanup (eugh).

yuvipanda mentioned this in rOSLA971fb4e69052: Add report that verifies view definitions.Mar 12 2015, 4:03 AM

Aklapper added a project: Cloud-Services.Oct 24 2015, 8:01 PM

• chasemp triaged this task as Low priority.Nov 30 2015, 5:12 PM

• chasemp subscribed.

• Phabricator_maintenance removed a subscriber: yuvipanda.Jun 7 2017, 6:56 PM

• chasemp closed this task as Declined.Jul 5 2017, 6:39 PM

Verify that public views are defined the way they should be (matching whitelist/greylist)Closed, DeclinedPublicActions

Description

Related Objects

Event Timeline

Verify that public views are defined the way they should be (matching whitelist/greylist)
Closed, DeclinedPublic
Actions