hs.pop('timestamp') if u.table_perm: hs.pop('table_priv') hs.pop('column_priv') elif u.column_perm: hs.pop('column_priv') elif u.proc_perm: hs.pop('proc_priv') newu = rd.stat(**hs) if u.table_perm: newu.perms_fromsetstr(curp.get('table_priv')) elif u.column_perm: newu.perms_fromsetstr(curp.get('column_priv')) elif u.proc_perm: newu.perms_fromsetstr(curp.get('proc_priv')) newu.save() rd.stat_updated(newu.id, u.id) Collector(TableUser, "user privilige tracking", action) def for_action(stream, data, options): col_width = options.get('display_width', 80) server = str(data.server) if data.server is not None else '' if not options.get('header', False): stream.write('{1:15} {2:{0}}\n'.format(col_width-15, server, data)) else: stream.write('{1:15} {2:{0}}\n'.format(col_width-15, 'host', 'grant')) Formatter.proc_for('user', 'text', for_action)
rd.stat_updated(tbl.id, t.id) rd.logger.info("[deleted] %s" % (rd.stat.objects.filter(id=t.id).values())) return rd Collector(TableDefinition, "'create syntax' tracking", action) def for_action(stream, data, options): display_width = options.get('display_width', 80) col_width = display_width/5 server = str(data.server) if data.server is not None else '' database_name = str(data.database_name) if data.database_name is not None else '' table_name = str(data.table_name) if data.table_name is not None else '' if not options.get('header', False): stream.write('{1:^10} {2:^{0}} {3:^{0}} {4:^{0}} {5:^15}\n'.format(col_width, data.status, server[:col_width], database_name[:col_width], table_name[:col_width], str(data.created_at))) if options.get('full', False): stream.write('{1}\n{2:{0}}\n{3:{0}}\n{4}\n'.format(display_width, 'OLD:', data.previous_version.create_syntax if data.previous_version is not None else '', 'NEW:', data.create_syntax)) else: stream.write('{1:^10} {2:^{0}} {3:^{0}} {4:^{0}} {5:^15}\n'.format(col_width, 'status', 'server', 'database name', 'table name', 'created at')) Formatter.proc_for('definition', 'text', for_action)
data.data_length/1024/1024 if data.data_length is not None else '', data.index_length/1024/1024 if data.index_length is not None else '', data.data_free/1024/1024 if data.data_free is not None else '')) else: stream.write('{1:10} {2:{0}} {3:{0}} {4:{0}} {5:^18}\n'.format(col_width, data.status[:10], server[:col_width], database_name[:col_width], table_name[:col_width], (data.data_length + data.index_length)/1024/1024 \ if data.data_length is not None and data.index_length is not None else '')) else: if options.get('full', False): stream.write('{1:^10} {2:^{0}} {3:^{0}} {4:^{0}} {5:^18} {6:^18} {7:^18}\n'.format(col_width, 'status', 'server', 'database name', 'table name', 'data length(mb)', 'index length(mb)', 'data free(mb)')) else: stream.write('{1:^10} {2:^{0}} {3:^{0}} {4:^{0}} {5:^18}\n'.format(col_width, 'status', 'server', 'database name', 'table name', 'size(mb)')) Formatter.proc_for('volume', 'text', for_action)
rd.stat_updated(tbl.id, t.id) rd.logger.info("[deleted] %s" % (rd.stat.objects.filter(id=t.id).values())) return rd Collector(TableView, "'create view' tracking", action) def for_action(stream, data, options): display_width = options.get('display_width', 80) col_width = display_width/5 server = str(data.server) if data.server is not None else '' database_name = str(data.database_name) if data.database_name is not None else '' table_name = str(data.table_name) if data.table_name is not None else '' if not options.get('header', False): stream.write('{1:^10} {2:^{0}} {3:^{0}} {4:^{0}} {5:^15}\n'.format(col_width, data.status, server[:col_width], database_name[:col_width], table_name[:col_width], str(data.created_at))) if options.get('full', False): stream.write('{1}\n{2:{0}}\n{3:{0}}\n{4}\n'.format(display_width, 'OLD:', data.previous_version.create_syntax if data.previous_version is not None else '', 'NEW:', data.create_syntax)) else: stream.write('{1:^10} {2:^{0}} {3:^{0}} {4:^{0}} {5:^15}\n'.format(col_width, 'status', 'server', 'database name', 'table name', 'created at')) Formatter.proc_for('view', 'text', for_action)