I am new to python,earlier I used to develop in PHP. With PHP, I used MySQL as the back end Database.There I had different libraries,MySQL classes with easy to use functions available open , also we used an internally developed MySQL classes to work with the database operations. MySQL helper classes with functions written to manage queries.Such as a Pre-defined functions which could be invoked to do specific operation.
If I am giving an associative array to be inputted into the MySQL,where keys are field names and values ,the associated values for the MySQL row.
In this case,the function would normally takes the array split it and help in DB insertion.It also would look into common issues like SQL injection.
Now with python,I started using MySQLdb with basic queries.I would like to know if there any fine and reliable helper classes with MySQL functions written in the 'Pythonic' way optimized for MySQL?