Unfortunately PEP249 does not specify a method to start a transaction. You are free to execute a BEGIN (or START TRANSACTION) statement, however this will likely do nothing on a non-transactional engine like MyISAM,
Your question leads me to another one - PEP249 says:
"Note that if the database supports an auto-commit feature, this must be initially off. An interface method may be provided to turn it back on."
To be honest, mypysql may not follow this strictly, I'll have to check this further and make a fix if necessary.
Best wishes,
Bozhin
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
the current mysql module contains two methods to finish a transaction (commit, rollback). But how can I start one?
Thanks,
maranos
Hi,
Unfortunately PEP249 does not specify a method to start a transaction. You are free to execute a BEGIN (or START TRANSACTION) statement, however this will likely do nothing on a non-transactional engine like MyISAM,
Your question leads me to another one - PEP249 says:
"Note that if the database supports an auto-commit feature, this must be initially off. An interface method may be provided to turn it back on."
To be honest, mypysql may not follow this strictly, I'll have to check this further and make a fix if necessary.
Best wishes,
Bozhin