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)
