drone ai and django dashboard -- 2

I've got a research project that consists of connecting iot devices to an app, and will work toward building a dashboard with visualization.

This job will basically be done by me, but I would need all the help I need, in the area of reviewing my project details and actual coding.

I have configured the physical setup and django on raspi.( [login to view URL]) I have added Django with Ajax to fetch the arduino sensor data to sqlite3 db and display in the Django api app.

The first task is; to add some visualization using Plotly, Tableau and/or other libraries; to create modular scripts of my existing codes; and to connect with Lorawan, wifi or bluetooh for the basis of task2.

The second task is to add more module on top of the task 1 such as envs sensors and expand to create on appinventor platform based on raspberrypi and task1 setup.

The third and the last task is to use a jetson board (hopefully in conjunction with task1 and 2) with a drone configuration in [login to view URL] details depend on the other two tasks, but open cv for line tracking and machine learning is going to be implemented.

During the course of the project of two months, in addition to the tasks above, I will need advanced Django tutoring ( my skills are so and so), db implementation (ERDB, schema, script, data processing) and a several presentation sessions of full life cycle of deeplearning. (zoom)

Project term: 2 months

my budget: 500usd

skills required: django, python, db, git , docker and data science(ml/opencv etc)

read the following script and tell me what it does

sql = f'''

SELECT *

FROM (

SELECT

cast((SELECT @ROWNUM := @ROWNUM + 1) as integer) AS rnum,

d_id, img_path, img_name,address, id

FROM common_dronedatamodels T

,(SELECT @ROWNUM := 0 ) TMP

where T.d_id='{group_id}'

ORDER BY ID ASC

) as B

ORDER BY [login to view URL] DESC

LIMIT {start}, 10;

'''

[login to view URL](sql)

boards_obj = dictFectchAll(cursor)

context = {'board_list': boards_obj, "commonPage":commonPage}

return render(request, 'board/[login to view URL]', context)

Python Django Git Docker Deep Learning

Project ID: #27545597

About the project