db | simple package for the Fuel PHP framework | SQL Database library

I'm creating an application where the user can post information and see the information posted, something like a forum. I created a list where the publications stored in the database are shown, so on the main page that list is shown with the title, description, date, etc. of each publication. Now, what I'm trying to do is select anyone of the posts in the list and then display the full information of the selected post in other view. I'm using a MVC view with its respective controller to consume the API.

The code on the API controller to get the info of the selected post:

So I created a poll model in my Django app. I'm going thorugh the polling app tutorial posted on the Django website, however, I'm using a remote MySQL database rather than a SQLite database.

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 am trying to create an app in which the user has the option to query the database by entering information into one of two entry boxes. I want to be able to use a single select statement and conditionally query the database based on what box the user enter their information into. I currently am trying to use a CASE clause, but I believe that it is running into an error when I try to include a WHERE clause in the THEN argument. Here is what I am currently working with:

I'm writing a Firebase function (Gist) which

1. Queries a realtime database ref (events) in the following fashion:

   await admin.database().ref('/events_geo').once('value').then(snapshots => {

2. Iterates through all the events

   snapshots.forEach(snapshot => {

3. Events are filtered by a criteria for further processing

4. Several queries are fired off towards realtime DB to get details related to the event

   await database().ref("/ratings").orderByChild('fk_event').equalTo(snapshot.key).once('value').then(snapshots => {

5. Data is prepared for SendGrid and the processing is finished

All of the data processing works perfectly fine but I can't get the outer await (point 1 in my list) to wait for the inner awaits (queries towards realtime DB) and thus when SendGrid should be called the data is empty. The data arrives a little while later. Example output from Firebase function logs can be seen below:

10:54:12.642 AM Function execution started

10:54:13.945 AM There are no emails to be sent in afterEventHostMailGoodRating

10:54:14.048 AM There are no emails to be sent in afterEventHostMailBadRating

10:54:14.052 AM Function execution took 1412 ms, finished with status: 'ok'

10:54:14.148 AM

Super hyggelig aften :)

super oplevelse, ... long string generated

Gist showing the function in question

I'm probably mixing up my async/awaits because of the awaits inside the await. But I don't see how else the code could be written without splitting it out into many atomic pieces but that would still require stitching a bunch of awaits together and make it harder to read.

So, two questions in total. Can this code work and what would be the ideal way to handle this pattern of making further processing on top of data fetched from Realtime DB?

Best regards, Simon

Ansible 2.11.0

I have a shell script that accepts 2 parameters that I want to run on a Windows host, but want to run it inside git-bash.exe. I've tried this,

I am using class based projection with constructor expressions. here is a sample code form my work

I'm using Postman to test my JPA delete method and when I test it, it returns a 200 response, but does not actually delete from my DB.

Repo -

I've created a simple VBA interface to connect Excel to a MySQL DB. The VBA part acts as a preview of data for the user to choose what item he wants to import to the Excel sheet.

Until now I've work with a very complete set of data, but I got to a Table which (because of the nature of the items) some fields are NULL.

Now every time I try to check the values in the VBA I get the Run-time error 13 Type mismatch in the listview component. At first I though it was a field with DECIMAL typing, but after changing it to a DOUBLE (for testing) the problem persisted, and it was until I notice that if only checks columns with no NULL value, the problem disappears. Off course I can't omit this values.

I tried some .Tostring functions but with no success. And I failed to implement a IF to check for NULL in the obj.

This is my code: