Advanced Capstone 3.1 and 3.2

Academy Support
1

https://learninghub.kx.com/forums/topic/advanced-capstone-3-1-and-3-2

Hello! I wanted to ask, firstly, if this is the correct solution for loading the f1 database into the remote server for question 3.1… I am asking because there is no test to check at the end of the 3rd task.

 

hdbH : h : hopen 5099 
f1data : get `:../f1 
hdbH (set; `f1data; f1data) 
hdbH `f1data

 

In parallel, I have more questions about 3.2. Firstly, the .Q.sha1 function does not work on my column string (I have checked that I work with string columns, and not with symbol columns). Even if I write .Q.sha1 “Hello world!” I get an error, therefore I use the .Q.fc function and retrieve the following table (screenshot attached - the api column is also in the table, even though not seen from the picture). Moreover, why were we advised to check the Advanced IPC Module before attempting this exercise, I do not believe this has anything to do with IPC (we are even told to save the variable locally - only for 3.3 we need to load the table into the remote server). In the other case, I am wrong in my thinking, but I have no idea where. The code for 3.2 is shown below

 

show table : read0`:../AdvancedCapstone.Data/users.txt 
show myTable : ([user : ()]; password : (); api : ())  

addToUsers : {[newStr] words : "t" vs newStr;     
      if[[words[0] like "user"] = 0b; `myTable insert (`$words[0]; `$words[1]; `$words[2])];     
      } 
addToUsers each table 
myTable : update string user, string password, string api from myTable 
.perm.users : update .Q.fc password from myTable 
show .perm.users

 

2

Hi,

Can you send me a screenshot of what you mean? There is no combination required.

You can either use the word

each

or the single quotation mark

'

between .Q.sha1 and password. The backtick is not correct here.

No extra libraries are required, these are in built functions within q.

Hope this helps,

Laura

 

3

Dear Laura,

 

Thank you for your help! It works now… I commented out the first two lines at some point through all the checks - this is my mistake.

Thank you for all the help!