qone | generation web query language , extend .NET LINQ | Database library

I have filled arrays in my code, and I want to acces to it by calling its names in function parameters. I was not very accurate, I need to access the arrays names, and the values too. I just paste the whole code to you, maybe I missed something:

Here is the table:

in a Java project + spring, i have these two class and a code to insert data:

Background:

Find the number of times companies move in tandem regarding their Market Capitalization, so for example with company A and company B, they move 3 times together and I would like to divide it when both company A and B show values different than NA (here, 10). I used a logical formula, TRUE when they have the same letter, FALSE when they do not have the same letter and NA when there is one NA value in A or B.

THE PROBLEM IS:

The code I used works with small sets, max 50 companies, then it takes too much time, and I am looking to do it for sets of 100 companies, approxi. 324.000.000 data points

Input (small subset): Dataframe "dat"

I've got a small Node/Express app that simply displays data on a page from several Postgres tables. My database connection/querying function lives in a separate file (db.js) as do my queries (queries.js). My question is how best to handle variable scope in my calls to the db connection function.

Here's an example:

Ok So I have a function that is executed after a customer purchases a digital code. The function is very simple and uses pdo after I thought that would fix it instead of using mysqli. everything works but the username variable does not get put in the table even thought I can echo it out and use it in other sql command just fine but for some reason not this particular line.

Here is the code: