cmdc | Maya Python API | REST library

So through some experimentation I was able to determine that I had to cd into the 'functions' directory and also run NPM install. I guess this was a due to a fundamental misunderstanding of how Firebase projects are structured and of node packages.

I would love to learn more so if anyone share some reading about this, it would be appreciated.

Ended up with a script that look like the following.

From a shell script run commands like

you can do it like:

It seems that you are looking for insert ignore MySql syntax. Be careful with sql parameters: if query wants DateTime (@Date parameter), provide DateTime (DateTime.ParseExact and alike):

1. Try to add logs in between lines to find out the bottle neck
2. Read all the records to memory from encrypted db first instead of writing while reading
3. How many rows are there in the db? Do you join all of the 6 tables in your query? Consider sql tuning

First, you need to use parameters to send data to SQL. Never concatenate strings of data to SQL statement. That's a security hole as it's an open door to SQL Injection attacks.
For more information, read How can prepared statements protect from SQL injection attacks? and Microsoft Docs - How to: Perform Parameterized Queries

Second, Never store dates as strings in your database. For date only values, use the Date data type. For time only values, use the Time data type. For date and time values, use the DateTime2 data type (why not use DateTime?).
For more information, read Aaron Bertrand's Bad habits to kick : choosing the wrong data type, and my answer on SO to this question.

Third, you don't need two queries to get the last value of total_sale from the database. You can do that in a single query, without any parameters at all:

@kashi_rock is on the right track but didn't explain the issue very well. When you execute a command, you can either set the CommandType to StoredProcedure and the CommandText to the name of a stored procedure or you can set CommnadType to Text (which is the default) and the CommandText to a SQL statement. You are mixing and matching. You are providing inline SQL but saying that you want to use a stored procedure. Basically, get rid of this line:

MS SQL Server does not support arrays to be given as SP parameters. As you said in your comment, the @ARRAY parameter is not an array either, it is a user defined table type.

Thus you should prepare a System.Data.DataTable in your .net code and pass it as the parameter.

You can find a good example in this question:

How to pass table value parameters to stored procedure from .net code

Your DataTable should contain at least two rows that has the information to fill UserType and parameter1 columns of the table tbl_samplednd1

The LRM says

Because a variable passed by reference may be an automatic variable, a ref argument shall not be used in any context forbidden for automatic variables.

And you cannot pass a bit select of a packed variable by reference, only the whole variable.

There is no easy way to do this without writing separate tasks for each cmd, or a big case statement inside a signal task that selects the interface variable you want to assign.