Noah | service platform to make outbound requests | REST library

I'm programming a poll feature for my bot where I can create a poll by chatting with the bot. The "poll" the bot creates is just a basic message where other users can react to vote. I'm struggling with finding a way to tell the bot which emoji I want for each possible answer. My idea right now is to write the bot a single message for each possible answer which contains an emoji and the answer (":white_check_mark: Yes"). In hours of trying and searching I have not found any way to check whether the first part of the message is an emoji. I found many posts about searching for the pattern of ":", "<:" or "

Edit: What I basically just need is a way to check whether a message contains an emoji. However, I was asked to attach my code which would be pretty much to give you an idea of how I'm working. I need to check if a message starts with an emoji because it has to so that the bot knows which emoji he needs to react to the message with and he obviously can't react with something that isn't an emoji.

Thanks Noah

...

I need to check if the first word typed is in my list or not

...

I am trying to transform a table of data--I want the rows to become the columns, and the columns to become the rows (like a total complete pivot). I am using the method from this answer to do so.

If it makes any difference, I am running my own SQL server on a Raspberry Pi using PHPMyAdmin.

The table (truncated) looks like this:

...

I would like to know how to insert new table rows via an on click in JavaScript. At the bottom of the table, there is a row including a textbox for each column. This row contains a "Create" button, which should create a table row, before last row of the table. In addition, if you type some text into the textboxes and then click on the "Create" button, the text should be transferred into the columns of the new created row. Each newcreated row must include two buttons. The first button called, "Change color" changes the color of the entire table row and second button "Delete" deletes the entire table row. I don't know how to assign a new color for each new row to the function on click "change color". Could someone support me that every row gets various colors? I also don't know how to insert a table row, before last row of the table. The buttons "Change color" and "Delete row" are also not functioning.

You can find my Code here: https://jsfiddle.net/NoahSchwarz/j5mtsrbn/2/#&togetherjs=NuUS0LxnsH

...

I have to create a materialized view based on data:-

...

I am trying to upgrade to http/2.0 using a python socket. I have already tried using the upgrade header like so: Connection: Upgrade then Upgrade: h2c. This makes the server respond with a http/1.1 200 OK response. I am now trying to use ALPN via the ssl module.
This is the code for attempting via ALPN:

...

I have a multi-stage Dockerfile for building a Rails app that includes webpacked frontend assets.

The step with RUN bin/rails assets:precompile calls webpack to build all the .js and .css assets to publish to public/packs. This works fine. The problem is, the changes from this RUN step are not persisted. One would expect the following to work:

...

The table I am querying has several thousand rows and numerous fields - I'd like the code to return the top 10 values for a handful of the fields, namely: Forename, Surname and City - I'd also like to see a count of the values returned.

For example

Ranking Forename FName Frequency Surname SName Frequency City City Frequency 1 Liam 830,091 Smith 2,353,709 New York 2,679,785 2 Mary 708,390 Johnson 1,562,990 Los Angeles 413,359 3 Noah 639,592 Williams 792,306 Chicago 393,511 4 Patricia 568,410 Brown 743,346 Houston 367,496 5 William 557,049 Jones 633,933 Phoenix 336,929 6 Linda 497,138 Miller 503,523 Philadelphia 304,638 7 James 490,665 Davis 503,115 San Antonio 255,142 8 Barbara 418,312 Garcia 468,683 San Diego 238,521 9 Logan 399,947 Rodriguez 461,816 Dallas 232,718 10 Elizabeth 399,737 Wilson 436,843 San Jose 213,483

The returned list should be interpreted thus: The most frequently occurring forename in the table is Liam - with 830,091 instances, The 5th most frequently occurring forename is William - with 557,049 instances, The 8th most frequently occurring city is San Diego - with 238,521 instances ...and so on

(N.b. the table does not show there are 2.7m Liams in New York - just that there are 830,091 Liams in the entire table - and that there are 2,679,785 New York addresses in the entire table)

The following produces what I need - but just for the first field (Forename) - I'd like to be able to do the same for three fields

...

Completely new to Linux and Bash scripting and I've been experimenting with the following script :

...