Hi, for some reason I keep getting this error for 3.6 and I’m not sure what is causing it after trying to debug.
quizItem success description error
exercise1.1 Pass “column file in DB should be renamed to lapId” “”
exercise1.1 Pass “.d file in DB should be renamed to lapId” “”
exercise1.1 Pass “all column files should be in event dir” “”
exercise1.2 Pass “lapId should exist in event table” “”
exercise1.3 Pass “check if all values are correct” “”
exercise1.4 Pass “check if lap table exists” “”
exercise1.4 Pass “create new lap dir in f1 DB” “”
exercise1.4 Pass “create col files for lap table” “”
exercise1.4 Pass “.d file should consist of all col names” “”
exercise1.5 Pass “check if lap table exists in date dir” “”
exercise1.5 Pass “create col files for lap table” “”
exercise1.5 Pass “.d file should consist of all col names” “”
quizItem success description error
exercise2.1 Pass “check if race day in process” “”
exercise2.1 Pass “have correct schema” “”
exercise2.2 Pass “check if lap table in process” “”
exercise2.2 Pass “only contains data for 2nd Jan 2020” “”
exercise2.2 Pass “contain all columns for 2nd Jan 2020” “”
exercise2.3 Pass “not allowed to use select keyword” “”
exercise2.3 Pass “return correct values for temp” “”
exercise2.3 Pass “return correct values for wind” “”
exercise2.3 Pass “return correct values for all” “”
exercise2.4 Pass “when given the wrong option return error " is not a valid option for mysensor - valid options include temptyrewindall"” “”
exercise2.5 Pass “func should return same result as before” “”
exercise2.5 Pass “`p attribute exists” “”
quizItem success description error
exercise3.2 Pass “check password col is updated” “”
exercise3.3 Pass “.perm.users should exist on HDB process” “”
exercise3.4 Pass “define .z.pw on HDB process” “”
exercise3.4 Pass “give access to users with correct password” “”
exercise3.4 Pass “give access to users with wrong password” “”
exercise3.5 Pass “return first element of parse tree” “”
exercise3.5 Pass “return ! if given update query” “”
exercise3.6 Pass “define .z.pg on remote process” “”
exercise3.6 Fail “fiauser can run one function” “sensor”
exercise3.6 Pass “fiauser cant run tables” “”
exercise3.6 Pass “team members can run any function” “”
My code for exercise 3.6:
3.6
test:{[query]
perm:first exec api from .perm.users where user = .z.u;
$[perm=all; value query; perm ~ .perm.parseQuery query; value query; $“notAuthorized” ]
}
hdbH(set; `.z.pg; test)