I have an application where I have to schedule management command for periodic entering data into database at a regular time interval daily using cron. So my main question is how to connect this management command in order to run by celery workers that is by using celery beat.
Plus, I have one more concern that can be a topic of its own but still needing your help to resolve. I have implemented management command to enter data into database using pandas and to_sql function into my local mysql storage. But I have an issue here is to how to add a validation logic for that incoming data to eliminate or avoid insertion of duplicate entries wrt to a field. For example in my case I have product model with fields of title and unit_price, so I will check for not creating duplicate product entries again with same product name or title.
Please explain for this and thanks for your kind assistance.