hairdresser | universal js library for managing head DOM | Search Engine Optimization library

Here is a solution. I modified it to be more flexible and handle any number of time blocks.

The problem is in the models you defined. Base on the JSON your models will be:

I think you can have a separate new table to handle and map this information. Let's say you have created a table professional_procedures, then you can store the professionalID and the corresponding procedureID in it. Basically having a third table that references both the original tables.

This is a m:n relation and it will be good to have a separate table that contains foreign keys to both the other tables.

Professional (Hairdresser) <===> Professional_Procedures <===> Procedures

Your code is correct except, you are printing before asyncInitState executes completely. See Asynchronous Programming

Try

You have not started the MQTT client network loop so it will not be able receive messages or send a message large the the MTU.

You will also get disconnected after the keep alive period.

Add client.loop_start() before the call to client.connect()

or insert client.loop() after the time.sleep(5000) in the loop in main and it will be better to make it 1000 to the client loop runs at least once a second.

Adding sleeps in callbacks is normally a bad idea as it doesn't stop events from being triggered it just delays them, because they will just be queued up until the sleep times out.

You should set a flag on the first event just after sending the MQTT message which you can then expire using the While True loop in main. If a new event comes in while the flag is still set then you just don't send another MQTT message.

You can use the filtered positional operator $ to update nested arrays.

First of all, you could not use @Model.Products to show all products' info on view.Then, your action code should use Include method to retrieve the navigation properties' value. Finally,refer to my simple demo shown below.

1.Assume that you have below models:

So it was not working when trying to connect to the cloudMQTT server, but when I connected to my MQTT server or the test MQTT server, it worked. There must be an issue dealing with the protocol that the cloud mqttServer uses (MQIsdp) as apposed to the standard MQTT protocol that a normal MQTT server utilizes. I made a change to the connect packet so that it specified the MQTT protocol and pointed the TCP connection to the test server ( test.mosquitto.org ) and I can now Connect and Publish successfully.

For anyone who is just starting out with trying to interface an Arduino with a module like a SIM900 ( GPRS/GSM module ) to a MQTT server, I suggest you grasp a full understanding of standard AT Commands ( To establish a solid TCP connection to server ), how to compile the packets that will be sent through the GPRS module from the Arduino and lastly I suggest not using any code you have not written to achieve this. Learn how to establish the TCP connection with AT commands, then learn how to compile and send a connect packet by compiling the byte array yourself and sending it. Once you understand the packets and the communication between the client and the server, the MQTT world is your oyster.

You can use this code as a guideline but please try write as much of your own as possible: