Sha256: c72b273632edff5cf1ad390b3df90645293892998fad61556b5c58b7232423d6
Contents?: true
Size: 716 Bytes
Versions: 43
Compression:
Stored size: 716 Bytes
Contents
require 'mysql'
class Mysql
def summary
self.list_tables.each do |tbl|
next if tbl =~ /^tws/
puts "+" * 160
puts "%80s" % tbl
puts "+" * 160
columns = self.query("select * from #{tbl}").fetch_hash.keys
columns.in_chunks_of(6).each do |chunk|
puts "%-25s " * chunk.size % chunk
end
puts "\n\n"
end
end
end
class Array
def chunks(number_of_chunks)
chunks_of( (self.size/number_of_chunks.to_f).ceil )
end
def in_chunks_of(chunk_size)
nchunks = (self.size/chunk_size.to_f).ceil
chunks = Array.new(nchunks) { [] }
self.each_with_index do |item,index|
chunks[ index/chunk_size ] << item
end
return chunks
end
end
Version data entries
43 entries across 43 versions & 3 rubygems