module ActiveRecord # This class is used to dump the database schema for some connection to some # output format (i.e., ActiveRecord::Schema). class SchemaDumper #:nodoc: private_class_method :new def self.dump(connection=ActiveRecord::Base.connection, stream=STDOUT) new(connection).dump(stream) stream end def dump(stream) header(stream) tables(stream) trailer(stream) stream end private def initialize(connection) @connection = connection @types = @connection.native_database_types @info = @connection.select_one("SELECT * FROM schema_info") rescue nil end def header(stream) define_params = @info ? ":version => #{@info['version']}" : "" stream.puts <
false" if !columns.detect { |c| c.name == "id" } stream.puts " do |t|" columns.each do |column| next if column.name == "id" stream.print " t.column #{column.name.inspect}, #{column.type.inspect}" stream.print ", :limit => #{column.limit.inspect}" if column.limit != @types[column.type][:limit] stream.print ", :default => #{column.default.inspect}" if column.default stream.print ", :null => false" if !column.null stream.puts end stream.puts " end" stream.puts indexes(table, stream) end def indexes(table, stream) indexes = @connection.indexes(table) indexes.each do |index| stream.print " add_index #{index.table.inspect}, #{index.columns.inspect}, :name => #{index.name.inspect}" stream.print ", :unique => true" if index.unique stream.puts end stream.puts unless indexes.empty? end end end