I was trying to write a Polyfill for array sorting in javascript. However it turns out that the comparator doesn't cause any effect on the Polyfill. Any ideas how to make it work? const arrA = [2, 3, 4, 1,…
I have a table companies in which there are some duplicated rows I found with a simple GROUP BY name. This companies table has a PRIMARY KEY id which is referenced in several other tables, under the name company_id, which…
I have 2 queries that return the same object for earliest and latest datasets. eg : earliestDataset = [ {'id' : 123, 'highlights': 2, 'created_date': 2024-01-01, 'saves':5, 'wins':3}, {'id' : 124, 'highlights': 3, 'created_date': 2024-01-03, 'saves':2, 'wins':1}, {'id' : 253,…
Lets say I have two objects, for example const obj1 = { a: [{asd1: 1}, {asd2: 2}, {asd3: 3}] } const obj2 = { a: [{asd4: 4}], b: [{a: "asd"}, {b: "asd"}] } I have to merge the two objects…
I have a JSON object where there are duplicate keys. I want to merge all the values as a string under one key using a ";" separator input: { "1061": "GROCERY", "1073": "GM-HBC", "4220": "PRODUCE", "958": "MEAT", "958": "DAIRY", "958":…
Coming from SQL Server where I know that the MERGE command needs some extra care like locking hints to be an atomic operation, I now take my fist steps with PostgreSQL. I now came to a point where I would…
I have a list of objects, and I want to merge consecutive repeated values. In this list of objects we have three values of (B) and three values of (A). If the values are repeated and consecutive, I want to…
i have an array (0,...,n) and with several object. The array can be of any length. array = {{name: alice, age: 18, hobby: dance}, {name:bob, age: 27, hobby: cars}, {name: chloe, age:45, hobby: painting}}; Now I want a new array.…
I have the following array which represents a working schedule: Array ( ..., [1] => Array ( [TIME] => Array ( [0] => Array ( [FROM] => 10:00 [TO] => 20:00 ) ) [DAYS] => Array ( [0] => 5…
How I can merge this 2 querys to 1? $query1 = mysqli_query($_connect, 'SELECT `id` FROM `callers` ORDER BY `id` DESC LIMIT 1') or die(); $result1 = mysqli_fetch_object($query1); $query2 = mysqli_query($_connect, 'SELECT SUM(`calls`) AS "total" FROM `callers`') or die(); $result2 =…