stuff | Unsorted , raw , ugly & probably poorly usable tools | Hacking library

I'm a student learning about database design and currently learning about the relationships of - one-to-one, one-to-many, many-to-many. I understand the concept well enough, but feel like I'm lacking experience/information on how it would be implemented in a real production scenario.

My question is this

If I have a blog website with a Blog Post as an entity and comments for each blog post, how would you handle the comments in the database?`

Would you use a one-to-many relationship and just store all the comments in a single table. Then link those comments to each blog post and user who created it?

What if each comment had a sub-comment? Would you create a separate table for sub-comments and link it to a single comment? Would that cause too much overhead and confusion within the DB itself?

I get the concepts and all, but don't understand best practices for handling what seems like basic stuff.

Thanks in advance!

I have two google sheets in the same workbook and I am trying to import certain columns from one into the other sheet based on what hour of class was chosen. For example, I have the Date in column A, Name in B, Email in C, and Number in D and other stuff, then the Class in I.

Column A - Date Column B - Name Column C - Email Column D - Number ... Column I - Class

My goal is to import column B through D if column I has a certain class. I tried a using this if statemnt: =if('Confirmação'!I2 = A1,(=importrange("sheet_url","Confirmação!B2:D2")), "NOPE") where A1 has the name of the class to look for, but it resulted in a #Error.

Then I tried a variety of query such as the following: =QUERY({'Confirmação'!B2:D2,'Confirmação'!I2},"Where I = 'Terça 19h English 1'") =QUERY({'Confirmação'!B2:D2, 'Confirmação'!I2},"Where 'Confirmação'!I = 'Terça 19h English 1'")

and also added the IfError: =iferror(QUERY('Confirmação'!B4:I4,"Where I = 'Terça 19h English 1'"),"Vaga")

Could someone correct my functions or help with a google script? Thank you! Very much appreciated! (Sorry about the Portugues-it's a project I am working on in Brazil)

I have a div which with long content and that is why the scrollbar is coming. I want when user click on a button. Then, the div scroll bar goes to end of the content. I tried this way but no luck.

I want to achieve this without using jQuery.

I'm trying for a long time to get my labels on the left side on my input fields. I'm banging my head against the wall. I use a font-awesome icon in the label.

I tried a lot of searches on Google and Stack Overflow and tried stuff like inline-block which I see should work but it didn't work for me. My code so far. I guess it's an easy fix for all the great people that are here.

I am attempting to write a a UI test that taps on a delivered local notification after the device has been locked. I have been successful so far in tapping on a notification that was delivered on the springboard (when the device is already unlocked) but not from the lock screen. Does anyone know if this is possible?

Please note that this is different from questions such as this one, which merely hit the home button to leave the app under test and wait for the notification.

Here is the relevant portion of my test code:

Hey to all in the forum

I use JSF Mojarra implementation, version JSF 2.2

I need desperately a help on this.

1. I have a snippet of my page.
2. I have a custom component "example_result.xhtml" used in the page.
3. I have my BackingBean.java Be aware please that this code is not the real code I made. If you run it, it will be very ugly maybe because I deleted all the css classes and I kept only the hot stuff I need to show you my problem.

Everything is inside 1 form.

The 5 "h:selectManyCheckbox" (in my code I have 8 or 9)

In the form I have 5 "h:selectManyCheckbox" which are using values in the "value" attribute for different cases (javaFrameworks2Values, javaFrameworks3Values,...), and the "f:selectItems" use arrays of "SelectItem" (javaFrameworksSelectItems2, javaFrameworksSelectItems3...) created for these different cases, just to make some examples for me to understand how all the selectOne and selectMany components work. The ideas for this, about different cases were taken from these links: "https://stackoverflow.com/tags/selectonemenu/info" and "https://mkyong.com/jsf2/jsf-2-checkboxes-example".

After I have 2 commandButtons

1 for submit, and 1 for reset the values.

Display the values

After I display the results of the values of the "h:selectManyCheckbox" via the "example_result.xhtml".

You can see the 4th "h:selectManyCheckbox" that is the only one different, because it has the attribute "required" with the attribute "requiredMessage". With it there is a "h:message" to display the validation error.

In the BackingBean (which is Spring Bean, but it works perfectly good - sorry I don't want ejbs 3.x), I have initialized:

1. The values of the SelectItems and
2. The values of the "value" attribute, where the values of the "h:selectManyCheckbox" will be stored to be displayed later. [The code is completely castrated, to make it readable snippet].

When the page is rendered, I select checkBoxes (e.g. the 2 last, because the 2 first are initials) from all the "h:selectManyCheckbox". When I say that select from all, I mean it. And from the 4th with the "required" attribute. I try in the buttons (see in the code) the "Effort 1", or "Effort 2", or "Effort 3" (in the "f:ajax" in the buttons) and the result outputs in the last part are displayed and updated like a candy. Without any problem. To achive this with the composite component I googled and tried a lot. But I made it.

Then it comes the time to try the 4th to see the validation error of the "required" attribute.

I select again from all as before, but not from all. NOT from the 4th "h:selectManyCheckbox" this time. I select nothing from the 4th "h:selectManyCheckbox" to ckeck the validator error message ("requiredMessage"). The result is: It displays the message of error (GOOD until now), BUT this time it does not update anything from the others "h:selectManyCheckbox" to the output results at the end, and it does not reset the values as well as it was doing before (when I selected from all and from the 4th as well).

I understand that it says: as long as in the form the 4th failed with validation error, all the other "h:selectManyCheckbox" will not update the output results (something like wanting to fail all the others too).

But what really happes here?

1. It does not give the values to the "h:selectManyCheckbox", to be updated to the output?
2. It gives the vales to the "h:selectManyCheckbox" normally, BUT it just not updates the output?

The other efforts in the "f:ajax" in the buttons, are just efforts maybe to solve the problem but in these cases they don't even display the error message in the 4th case and of cource they don't update the other output results as well (again). But no message error as well.

I don't know if the problem is clear to you. I can explain in the discussion better so I can clarify the situation better. [To be honnet it took me 1 and half hour to write all this thing]

Thanks a lot in advance

========== Snippet from my page ==========

This probably ins't typical setup, but due to higher decisions we endup having multiple kafka clusters within one app, multiple topics per each, and each might have different serializing strategy. Json/avro. And avro might be with confluent schema registry or using single object encoding.

Well I got it working somehow, by building my own abstractions and registry which analyzes the configuration and creates most of stuff manually, but I feel I needed to repeat stuff like topic names, schema registry url on several places multiple times just to create all needed beans. Ugly as hell.

I'd like to ask, if there is some better way and support for this I just might have overlooked.

I need to create N representations of kafka clusters, configuring it once. Configure topics respective to given kafka cluster, configure confluent schema registry for topics where applicable etc, so that I can create instance of Avro schema file, send it to KafkaTemplate and it will work.

In a django template, I need to use forloop.counter0 to access an element in a list. For instance:

I have something like this: