ferment | peer audio publishing and streaming application

JSfiddle code: https://jsfiddle.net/bryanh210/j8yz2sep/3/

I currently have the following code:

I want to build an SQL-based recipe editor for a brewery. I have n recipes:

• Every recipe is part of a category.
• Every category has a list of steps.
• Steps can be reused in the same category several times and in different orders.
• Every step has n set-points.
• Setpoints change based on the recipe.
• The same steps used more than once in the same category could have different setpoints within the same recipe.

I have 3 recipes (BeerA, BeerB and BeerC):

• BeerA and BeerB are lager (category), while BeerC is a stout (category).
• Lager has 5 steps
  (start, fermentation, wait, fermentation, maturation).
• All the steps have 2 set-points
  (time, temperature).

BeerA specific set-points could be:

• Start:
  [10seconds, 30 degrees]
• Fermentation:
  [2 days, 27 degrees]
• Wait:
  [3 hours, 25 degrees]
• Fermentation:
  [3 days, 23 degrees]
• Maturation:
  [5 days, 3 degrees]

BeerB has the same steps, same order, but with different set-points. BeerC has only 3 steps. What would be an example of table design? I was thinking:

• Recipe table
  (RecipeID, RecipeName, categoryID).
• Category table
  (CategoryID, CategoryName).
• Steps table (I need the reference to the category and to the recipe).

How can I deal with steps using different set-points? I believe I need also a Setpoints table, but how to design it?

I am wanting to use the datediff function in mySQL but my code its returning Nulls and I think its because the columns that I am using have a format of MM/DD/YYYY. How could I over come this. This is the code that I have.

Having some issues joining tables. I think my syntax is wrong due to having to call the column names with `` I think it should be an easy fix. When I call it gives me an error code 1052. Column 'Brand.Name' in field is ambiguous.

I have the following sentence:

I am scraping a table in a webpage with BeautifulSoup. I managed to put the text in a txt file.

However, some contains multiple tables inside. I guess that the developers had some aesthetic directive and they couldn't edit the cell any other way to meet their requirements. I have many problems in scraping the tables the way they are, so i was wondering if there exists a way to programmatically edit the HTML in order to extrapolate the txt from those nested tables into the original cell.

Here an example of what I mean.

From a nested table like this

I have written a SQL code in snowflake to create a pivot table. I am using the object of the pivot table in another query but its not being recognized.

I posted this question earlier but left a lot of information out regarding my HTML code so I will update it here.

Right now I have two different functions that calculate the total costs of two different sections on the menu, the Appetizers & Main Dishes. Now what I am trying to do is create a third function that will give me a grand total of both the Appetizers & Main Dishes costs.

I want to trigger this calculation using a submit button and then have the value be displayed through an input text.

Here is what I have tried:

I've been trying to learn Python language for fun and decided it would be best to do it with a project. Since I work in a beer factory, I thought it would be cool to create a simple GUI that would display all tanks on the factory along with each beer it holds and its current status. If I double-click on a tank, it would pop a new window allowing me to edit tank info, but I'm having trouble making the information from the child to display on the parent window (more specifically, I want to change a parent list's item from a combobox on child). Here's an image showing basically what I'm trying to accomplish:

I think that maybe the values are being passed correctly to the list, but they are not being updated to the correspondent Widget to be displayed. I tried calling .update(), .after() and .mainloop() on my function, but nothing changed.
I tried checking other answers, but I was actually hoping there is a way to solve this without resorting to Classes, as I don't quite understand them yet. Here's the simplest smallest version of my code that I could come up with: