Batch execution of insert SQL using the aiomysql.execemany method
- Linguagem predominante
- Python
- Estrelas
- 1.9k
- Forks
- 272
- Métricas de merge de PRs
- Nenhum PR com merge em 30d
Descrição
When I use the aiomysql.execemany method to batch execute insert SQL, I find that the internal mechanism is for loop to execute all statements, comparison Pymysql.cursors File, found that the regular expression is different.
The comparison is as follows:
aiomysql.cursors File:
```py3
RE_INSERT_VALUES = re.compile(
r"\s*((?:INSERT|REPLACE)\s.+\sVALUES?\s+)" +
r"(\(\s*(?:%s|%\(.+\)s)\s*(?:,\s*(?:%s|%\(.+\)s)\s*)*\))" +
r"(\s*(?:ON DUPLICATE.*)?);?\s*\Z",
re.IGNORECASE | re.DOTALL)
```
pymysql.cursors File:
```py3
RE_INSERT_VALUES = re.compile(
r"\s*((?:INSERT|REPLACE)\b.+\bVALUES?\s*)" +
r"(\(\s*(?:%s|%\(.+\)s)\s*(?:,\s*(?:%s|%\(.+\)s)\s*)*\))" +
r"(\s*(?:ON DUPLICATE.*)?);?\s*\Z",
re.IGNORECASE | re.DOTALL)
```
```py3
my_data_sql = "insert abc(name) values(%s)"
```
I find `insert abc(name) values (%s)` no such problem,but when there is no space between `values` and `(`,have this problem.
I hope it can help me solve my doubts.
Guia de contribuição
Avaliação
Esta issue ainda não foi avaliada.