nutshell | Nutshell provider a lightweight dev | Key Value Database library

I need a simple ODBC test scenario on WIN which I can configure very simply and be assured it is working in support of another question at Unix.SE.

In a nutshell I'm trying to setup a PyODBC/Python script connection from Debian 10 (192.168.1.2) to Windows 10 in KVM/QEMU virtual system (192.168.1.12).

First, on the Windows 10/KVM, I see the ODBC Data Source Administrator has a tab File DSN and Microsoft Text Driver. Can I use FileDSN to test Python PyODBC connection to ODBC using a simple CSV file in place of Server?? (My research with ODBC only finds running server instances).

Next, what I tried:

• On Debian I installed ODBC Microsoft driver for Linux.

• Shutdown the Windows 10 firewall, and I can ping in both directions:

  $nmap -p 22 192.168.1.12 # Deb to Win

  > Test-NetConnection 192.168.1.2 -p 22 # Win to Deb

• On Windows 10/KVM I added a FileDSN with Microsoft Text Driver. I created a CSV file (odbc_test_01.csv) with simple header and one row of data (IE. {'ID' : 1, 'NAME' : 'FOO'})

• Created a Jupyter Notebook to make testing easier. Here is my connection string and the results:

  ...

So I decided to tryout functional programming because people say it gives you more control over the programs that you write, it's extremely testable, and it makes code more readable & easy to follow — who wouldn't want that..?

Obviously I decided to try writing a program using the functional paradigm. I got stuck, nearly just as soon as I decided to try writing the thing. I couldn't really figure out how to make all of the program's data immutable. My first thought was to use all const declared variables, since a const variable cannot be re-referenced after the initial assignment, however; I found out that implementing an immutable data structure is quite different from declaring several const variables to store a programs state in. It became quite clear to me that I was going to need immutable objects, with immutable properties, and so forth. After attempting to create an Immutable data structure (example is at the question's bottom). I concluded that that JavaScript doesn't really have a way of implementing Immutable data, at least not a way that is obvious. And now here I am, scratching my head...

What I would like to know is:

"How are the people, who are writing JavaScript programs, using the Functional Programming paradigm implementing immutable data structures when the language doesn't really offer any sort of way implementing immutability?

EDIT: I want to be as clear as possible, because I have struggled with clarity in some of my past questions, so I am just going to sorta meta-explain what I am asking for:

In a nutshell, what I would like to know is: How does a person implement immutable data structures that work for the functional programming paradigm. An example of Any immutable data structure will suffice, or even an immutable object. If the answer involves use 3rd party libraries, other languages, or any other tool that would be great, and an example of what code using those tools might look like would be really excellent.

Below is some code, where I was trying to hack a JS object into being immutable. Its not good code, in fact it throws an error, but it demonstrates my mindset, and what I am trying to solve.

According to the MySQL 8.0 deprecations notes, starting MySQL 9.0 the definition of user variables with DECLARE (e.g. DECLARE studentID INT) will be deprecated:

Support for setting user variables in statements other than SET was deprecated in MySQL 8.0.13. This functionality is subject to removal in MySQL 9.0.

Already nowadays MySQL 8.0.25 raises a warning:

1287 Setting user variables within expressions is deprecated and will be removed in a future release. Consider alternatives: SET variable=expression, ..., or SELECT expression(s) INTO variables(s).

Therefore, I would like to understand how to properly replace DECLARE with SET. Let say, I have the following variables declared:

In my NodeJs application im using jwt to manage the user session, inside a jwt token i store user_role and user_id. This is my route:

I'm building a SharePoint SPFx react app. In a nutshell, the user fills out a form that I created. When the user hit's submit, using PNPJs: https://pnp.github.io/pnpjs/sp/items/ I'm adding the item to a list called Request.

From there I want to send an email that contains the URL link to that item they created. Right now, my code adds the item to the list and I'm able to send an email with no problem. However, I want to get the ID of the item that was just added to the list, so that I can add it to the email.

Here is a striped down snippet of my function that adds items to the Request list.

The following is a quote from Macros: the Plan for Scala 3 from more than 3 years ago:

For instance, one will be able to define a macro annotation @json that adds a JSON serializer to a type.

Any idea how/if this is actually possible in Scala 3?

More generally, is there anything in Scala 3 that can provide "Macro Annotations" functionality? The following is a quote from Macro Annotations - Scala 2.13:

Unlike in the previous versions of macro paradise, macro annotations in 2.0 are done right in the sense that they: 1) apply not just to classes and objects, but to arbitrary definitions, 2) allow expansions of classes to modify or even create companion objects

I'm using Free Product Sample for the WooCommerce plugin and trying to set conditional free shipping only for a Sample product, sample product cost is 0 and therefore I'm trying to hide free shipping unless the order subtotal amount is 0.

To put it in a nutshell:

I want to offer free shipping only for sample products and, the free shipping method should only visible for a product having subtotal = 0

Screenshot for further clarification:

My attempted code:

I haven't worked with PERL for many years and I'm more than a little out of practice.

I'm matching a line in a file based on a regex and search string, when the line matches I do some 'stuff' but where I'm getting stuck is when I try to split the line into 3 variables, where

In a nutshell, I have 3 divs that will have their bg colour randomly changed when clicked. They can only be clicked once, hence the removeEventListener. Am I just trying to over-complicate things?

I have 3 event listeners that all use the same function, but each with its own arguments: