演示数据库事务的简单方法。
duosql的Python项目详细描述
duosql
演示数据库事务的简单方法。
先决条件
- Python3.5+
- tmux
安装
pip3 install duosql
用法
- 创建.duo脚本文件。例如:
# connect commandconnect:mysql -ujohnlinp -psecret somedb# create table and populate dataleft:DROP TABLE IF EXISTS person;left:CREATE TABLE person (id INT NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, age INT NOT NULL, PRIMARY KEY (id));left:INSERT INTO person (name, age) VALUES ('John Lin', 29);# start left transactionleft:SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;left:BEGIN;left:SELECT age FROM person WHERE id = 1;# start right transactionright:BEGIN;right:UPDATE person SET age = 30 WHERE id = 1;# continue left transactionleft:SELECT age FROM person WHERE id = 1;# continue right transactionright:ROLLBACK;
运行
duosql <script-file>
。注意。