[tanaymathur]

Hi Megan,

Please find the code below.

Best Regards,

Tanay

//3.2
.perm.users:("S*S";enlist " ") 0: `$"../AdvancedCapstone.Data/users.txt"
.perm.users:1!(update password:{.Q.sha1 x}each password from .perm.users)
hdbH(set;`.perm.parseQuery;.perm.parseQuery)

// 3.6
hdbH".z.pg:{permission:.perm.users[.z.u;`api];test:.perm.parseQuery[x];$[permission~`all;value x;($[test~permission;value x;:`notAuthorized])]}"

 

[tanaymathur]

sure. Here it is

// 3.1
hdbH:hopen`::5099

[tanaymathur]

Thanks Megan. I was able to run the tests after loading the databse and got the certificate

[tanaymathur]

Hi Megan,

I restarted the workspace again and redefined .z.pg as below which sorted out 3.2 but 3.6 is still getting error

 

hdbH".z.pg:{ user:.z.u;permission:.perm.users[user;`api];test:.perm.parseQuery[x];$[permission~`all;value x;($[test~permission;value x;:`notAuthorized])]}"