#!/usr/bin/env python # encoding: utf-8 from colors import ColorsPrint CLP = ColorsPrint() CLP.notify_color('info', '装饰器演示') def decorator(f): def new_f(a, b): print("input", a, b) return f(a, b) return new_f # get square sum @decorator def square_sum(a, b): return a ** 2 + b ** 2 # get square diff @decorator def square_diff(a, b): return a ** 2 - b ** 2 print(square_sum(3, 4)) print(square_diff(3, 4))
#!/usr/bin/env python # -*- coding: utf-8 -*- # @Time : 2016/11/16 17:45 # @Author : GHL # @File : check_sql.py # 从模板中导入某一个类 from colors import ColorsPrint as CLP import re CL = CLP() CL.notify_color('notify', '检查mysql 脚本') class MysqlCheck(object): def __init__(self, filename): self.filename = filename def check_file(self): try: with open(self.filename.decode('utf-8')) as f: # 若路径含有中文open需要做编码处理 contents = f.read() update_reg = re.compile(r"^\s*UPDATE[\s\w.,!=()'`\[\]\n+\-\x80-\xff]*;$", re.I | re.M) alter_reg = re.compile(r"^\s*ALTER[\w\s'`\-()\n.:=%,+\x80-\xff]*;$", re.I | re.M) delete_reg = re.compile(r"^\s*DELETE[\w\s'`.=><!]*;$", re.I | re.M) create_table_reg = re.compile(r'^\s*CREATE TABLE[\w\s.=(),\'`\n+/\-\x80-\xff]*', re.I | re.M) create_view_reg = re.compile(r"^\s*CREATE VIEW[\w\s.=(),'`\n+/\-\x80-\xff]*", re.I | re.M) # utf-8 字符集匹配中文 \x80-\xff unicode 字符集匹配中文为 \u3040-\u309f match_create_table = re.findall(create_table_reg, contents) match_create_view = re.findall(create_view_reg, contents)