Pymysql | CRUD using Python and Mysql | DB Client library

I have a dag that insert some records in MySQL table and I want to run my dag every 2h. For that I've this code:

From Python 3.9 i'm trying to do a MySql query like this select * from brand WHERE text='L\'Orial'. It works fine from phpMyAdmin but fails from python for all text including quote "'"

I have python 3.5 and 2.7 installed, I only use python 3.4.

When trying to install pip install json2html, it generates the error:

I'm trying to use pytest-mock for mocking. This library is essentially a plugin/wrapper for mock and patch.

My problem is defined as:

I have an application (mymodule.py) that uses SQL Alchemy. Basically, there's a function that defines some objects from SQL Alchemy and returns a dictionary with those objects.

I have a website with a dropdown list and I'd like to assign python function to each option. Once the user will click submit button Python function should be triggered and the user should see the output (in this case it is just print in the console). I am using Flask to run this website.

This is my html code:

I'm learning SQLAlchemy right now, but I've encountered an error that puzzles me. Yes, there are similar questions here on SO already, but none of them seem to be solved.

My goal is to use the ORM mode to query the database. So I create a model:

I'm developing a python application where most of its functions will interact (create, read, update and delete) with a specific table in a MySQL database. I know that I can query this specific table with the following code:

• The work I have done so far - I read all the excel files from directories, edit them as I wish to and create df table

• The works I need to do - My final goal is to create .sql file in current directory. It contains the lines of 1) create the db and tables if they do not exist. 2) Insert the data from the df I have created so that I can import that result sql file. (No connecting directly to my db using pymysql.connect)

My question is that the works I need to do are really generatable? If so, how? I had the thoughts of how to do it as following:

1. f= open("result.sql","w+") to create result .sql file
2. f.write for each lines of statements for creating db and tables
3. INSERT the data from each column of df to each column of db tables

Please help me that I'm doing it right or if not, how can it be done.

Many Thanks

Edit: Since there is possibility that I run my program at computer with no internet connection, I want to avoid the methods that connects to my db from there.

For more details, I need to give this program to someone else. That person runs the program, get the output(.sql file) and give that .sql file to me so that I can import .sql file and get all the data I want to get.

I tried the suggestion to_sql and it was not what I wanted, but instead, I had another thought of just simple use INSERT and SELECT. Another problem is whether I can insert the right data to right columns in db.

For example, I have dataframe

I am trying to catch and count the duplicate entry exception :