pounce | HTTP benchmark utility | Performance Testing library

I have this data set running into the '00,000 of rows, only 3 is shown here for brevity.

I have a JSON object as below and I need to pass some of the object via a jQuery Attribute tag. I am getting a JSON parse error but I am not sure why.

Context: I have a file that contains several hundred lines of JSON.The T-SQL below is able to convert a single line of the JSON file into tabular form.

Question: I need some help/pointers on how to process the entire JSON file & feed all the lines into the OPENJSON function. Not too familiar with looping & OPENROWSET in T-SQL

Example of what 1 line of the JSON file looks like:

Hi guys im new to programming and I am struggling with an amendment of currency in the store. The code runs but the amount of currency amended is the same for each item, although I have coded it to take different amounts for different items.

I have tried amending each amount but it takes the amount from the first item and applies it to all items

I need to change the structure of JSON data I have in a variable into a different structure

Here's the structure I have now:

I'm having difficulty querying the nested elements of a JSON document using the T-SQL OPENJSON function in SQL Server 2016. I read through the MSDN docs here , here & here yet havent found the correct syntax for the WITH block. My columns keep returning only a single null row.

Can anyone please assist in modifying the T-SQL to achieve query output like this (below)?

Here is the json structure & null output:

I have a simple method to search a pandas dataframe column for a list of keywords; however, I'd like to create a function to pass a word (or words) through so I don't need to continuously update my search list.

My current method:

How do you get objects and their related objects using pure PHP and PDO without running into N+1 hell?

I'm trying to understand the fundamental way to instantiate objects and their relations without using a framework or ORM. Typically when I ask and provide examples, I get responses like "you would never use results that way", etc and it blows my mind considering the examples are so common in the real world I use these types of queries everyday in procedural code...

So, let's say you have a User class, and a PhoneNumber class. A User can have many PhoneNumbers. Well, that's a perfectly normal real-world use-case. You want to get all Users and related PhoneNumbers. How would you retrieve results from PDO, instantiate the User and populate each User's private $phoneNumbers = []; property? My greenhorn OOP mind would say foreach over an associated result set, sorting it by user_id and then looping over that result set instantiating a new User(), setting its properties and looping over each user, instantiating a new PhoneNumber() and pushing it to the property, but that most definitely seems "wrong".

When people say those types of examples are not common-place (still shocked), I always go back to the Amazon/e-commerce example. You have an Order History page. That would have an Order class and an OrderItem class. You can view all of your Orders and the OrderItems purchase on all orders on a single page.

Since I don't want to get pounced on for not having any code, this is definitely incorrect, but this is what I'm trying to understand the "how" of how to instantiate results of object's, and related results for original object's.

In procedural I could do this in a one-query solution. I'd expect at maximum two queries in an OOP solution. One that gets all Orders for a user and one that gets all OrderItems. In the below snippet. $clientOrders contains all order's from a client. Great, I now have all order_id's I would need to get OrderItems from but how to get those results and populate them against each Order?

I have a console application that asks the user to choose one of three options and to be able to open an inventory if desired. However, instead of checking to see if any of the other conditions are true are false, the console just reads the conditions linearly and waits till the first one has been satisfied. So for example, in the code below, it runs the first bit of text, presents the options, and then waits for the user to enter "inventory" without considering the other options. What's up? Why does this happen? and how do I get the console to run through and check whether or not all conditions have been satisfied?

Here's the code