python访问数据库日志_python处理mysql-binlog日志

# -*- coding: UTF-8 -*-

# -*- coding:utf-8 -*-

import re

database = 'use `t451_shangtua_c`/*!*/;\n'

not_database = 'use `ceshi412_shangt`/*!*/;\n'

not_database01 = 'use `t449_shangtua_c`/*!*/;\n'

f = open("123.sql", 'r', encoding='GBK')

newfile = open(file='2.txt', mode='w', encoding='utf-8')

line = f.readline()

while line:

if database == line:

flags = True

else:

flags = False

if flags == True:

# print(line)

#newfile.write(line)

if re.search("^[I|U]+", line):

# print(line)

newfile.write(line)

while flags == True:

line = f.readline()

# if database == line or re.findall('use', line):

if line == not_database or line == not_database01:

break

else:

# print(line)

if re.search("^[I|U]+", line):

# print(line)

newfile.write(line)

line = f.readline()

f.close()

newfile.close()