mysql 审核引擎 goInception 的基本使用

发布时间:2019-06-14 14:00:04发布者:Mr.Zhang阅读(471)

  官网地址

  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





本文转自博客园,原文地址:https://www.cnblogs.com/djw12333/p/11022285.html