groob
alessandrogario
groob
alessandrogario
groob
alessandrogario
groob
alessandrogario
groob
alessandrogario
grahamgilbert
10/09/2020, 1:18 PMgroob
grahamgilbert
10/09/2020, 4:54 PMgroob
grahamgilbert
10/09/2020, 5:32 PMosquery> DELETE from example_table;
(osquery.ExtensionPluginRequest) (len=2) {
(string) (len=6) "action": (string) (len=8) "generate",
(string) (len=7) "context": (string) (len=241) "{\"constraints\":[{\"name\":\"big_int\",\"list\":[],\"affinity\":\"BIGINT\"},{\"name\":\"double\",\"list\":[],\"affinity\":\"DOUBLE\"},{\"name\":\"integer\",\"list\":[],\"affinity\":\"INTEGER\"},{\"name\":\"text\",\"list\":[],\"affinity\":\"TEXT\"}],\"colsUsed\":[],\"colsUsedBitset\":0}"
}
(osquery.ExtensionPluginRequest) (len=3) {
(string) (len=6) "action": (string) (len=6) "delete",
(string) (len=7) "context": (string) (len=18) "{\"constraints\":[]}",
(string) (len=2) "id": (string) (len=1) "0"
}
DLETEEEE
{map[]}
DELETING
osquery> DELETE from example_table where text="wee";
(osquery.ExtensionPluginRequest) (len=2) {
(string) (len=6) "action": (string) (len=8) "generate",
(string) (len=7) "context": (string) (len=268) "{\"constraints\":[{\"name\":\"big_int\",\"list\":[],\"affinity\":\"BIGINT\"},{\"name\":\"double\",\"list\":[],\"affinity\":\"DOUBLE\"},{\"name\":\"integer\",\"list\":[],\"affinity\":\"INTEGER\"},{\"name\":\"text\",\"list\":[{\"op\":2,\"expr\":\"wee\"}],\"affinity\":\"TEXT\"}],\"colsUsed\":[\"text\"],\"colsUsedBitset\":1}"
}
osquery>
groob
alessandrogario
zwass
SELECT
as part of the DELETE
process?grahamgilbert
10/10/2020, 1:10 AMalessandrogario
grahamgilbert
11/05/2020, 8:02 PM