etcetera | etcd client that uses a tagged struct | Key Value Database library

Writing a small program to ask some people their dreams for fun. I'm trying to put the data into an associative array. I want it to come out like this (for example three names:

I have a table called licenses that holds all my users professional license numbers. There is a field, lic_type that holds the official letter code for the professional license, "PN", "RN", "RT", "APRN", "EO", etcetera. There is another column in the same licenses table, number, that holds the numeric portion of the full license information, 2261234, 1234567, etcetera, but the field is not INT it is varchar(18) due to need for some strings (see later in this question). I am NOT able to change the database structure or the type of the number column. Currently, when I concat these two fields together, it should give the full license designation.

For example - if lic_type is "RN" and number is "2676612", then when they are concatenated, they produce the correct license for the individual - RN2676612. However, the database I have received contains SOME entries in number column that contain the full license, i.e. RN2676612, instead of just numbers. Sometimes the letters are not even the right code. For example, the lic-type may be "PN", but they may have entered "LPN2261123", so that I cannot search for the entry in lic_type in the number column.

I need an MySQL query that will return ANY row where number contains any letters and at LEAST one number. I must allow full letter entries in number such as STUDENT or WAITING, but they will always have NO numbers, so, any entry in number that has a letter and a number is invalid and I need to correct. This allows me to bypass all letter numbers when pulling information from fully licensed customers.

Currently, I have tried the following query (in phpMyAdmin):

I have a really stupid question. I have a foreach loop in my project:

@foreach (var item in Model.HallIndex!)

The foreach gives me all the halls in a cinema + the movies which are scheduled in the future, including the time of the movie. So I get this back from the query to my webapp:

Cinema 1

Now playing:

Next movie: SCREAM (3:00 pm)

Cinema 2:

Now playing:

Next movie: TITANIC (8:30 pm)

Etcetera... I think you get it so far. BUT! I would like to use the Hallnumber to get the result of another query, which gets the movie from the database playing now in each hall. So, I need to get a parameter to the Controller.

Edit

This is what I really try to do, but MovieNow doesn't work:

Controller:

Consider the following Enum:

I am wrapping some c++ library code to create a pybind11 module. I adopt the approach described here:

https://github.com/pybind/cmake_example

After building the library, it will be imported in Python using something like:

I have a large number of T-SQL statements logged from a server I manage. I'm trying to boil them down to one instance of each.

Here's one of them:

everyone! I would like to create a dropdown menu in Python using Tkinter. Normally this is easy, but what if I want to create a dropdown menu that displays buttons, which you can click on to perform specific functions? A good example is when you click "File" in most text editors, it shows the options "New", "Open", "Save" etcetera that runs different functions. How do I do that?

I don't have any code to show since this isn't an error, just a general question on how to create a button dropdown menu in Tkinter. Looking forward to your answers! Thanks a lot!

I have a mathematical/programming question about a problem I am trying to solve. Given this simple array of integers:

int[] goals = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10};

Do you know how could I implement a function to pick an element from the array given a distributed probability like the one from this example?:

• The probability of picking goals[0] is 50%
• The probability of picking goals[1] is 30%
• The probability of picking goals[2] is 12%
• The probability of picking goals[3] is 2.5%
• The probability of picking goals[4] is 0.85%
• etcetera

The probability distribution is of my choice, hardcoded to keep things simple.

Thank you very much for your inputs!

I have this script. Can I count $err1, $err2, ... ?