欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

mysql 审核引擎 goInception 的基本使用

程序员文章站 2022-03-22 12:45:57
官网地址 github.com 安装 git clone https://github.com/hanchuanchuan/goInception.git cd goInception 修改配置 开启备份 vim config/config.toml [inc] backup_host="127.0 ......

  官网地址

  github.com

  安装

  git clone https://github.com/hanchuanchuan/goinception.git

  cd goinception

  修改配置

  开启备份

  vim config/config.toml

  [inc]

  backup_host="127.0.0.1"

  backup_port=3306

  backup_user="root"

  backup_password="123456"

  启动

  make parser

  go build -o goinception tidb-server/main.go

  ./goinception -config=config/config.toml

  pip install pymysql prettytable

  代码

  import pymysql

  import prettytable as pt

  tb = pt.prettytable()

  sql = '''/*--user=root;--password=123456;--host=192.168.100.90;--check=0;--port=3306;--execute=1;--backup=1;*/

  inception_magic_start;

  use go;无锡男科医院 https://yyk.familydoctor.com.cn/20612/

  create table t1(id int primary key,c1 int,c2 int );

  insert into t1(id,c1,c2) values(1,1,1);

  inception_magic_commit;'''

  conn = pymysql.connect(host='127.0.0.1', user='', passwd='',

  db='', port=4000, charset="utf8mb4")

  cur = conn.cursor()

  ret = cur.execute(sql)

  result = cur.fetchall()

  cur.close()

  conn.close()

  tb.field_names = [i[0] for i in cur.description]

  for row in result:

  tb.add_row(row)

  print(tb)

  结果

  | order_id | stage | error_level | stage_status | error_message | sql | affected_rows | sequence | backup_dbname | execute_time | sqlsha1 | backup_time |

  | 1 | executed | 0 | execute successfully | none | use go | 0 | 1560411582_21_00000000 | none | 0.000 | none | 0 |

  | 2 | executed | 0 | execute successfully | none | create table t1(id int primary key,c1 int,c2 int ) | 0 | 1560411582_21_00000001 | 192_168_100_90_3306_go | 0.006 | none | 0 |

  backup successfully

  | 3 | executed | 0 | execute successfully | none | insert into t1(id,c1,c2) values(1,1,1) | 1 | 1560411582_21_00000002 | 192_168_100_90_3306_go | 0.002 | none | 0.004 |

  backup successfully