Module: Sequel::Postgres::Comment::DatabaseMethods
- Defined in:
- lib/sequel/extensions/pg_comment/database_methods.rb
Overview
Support for setting and retrieving comments on all object types in a PostgreSQL database.
Instance Method Summary collapse
-
#apply_alter_table_generator(name, generator) ⇒ Object
:nodoc: Enhanced version to support setting comments on objects created in a block-form
alter_table
statement. -
#comment_for(object) ⇒ String, NilClass
Retrieve the comment for a database object.
- #comment_on(type, id, comment) ⇒ Object
-
#create_table(*args) ⇒ Object
An enhanced form of the standard
create_table
method, which supports setting a comment in thecreate_table
call when the:comment
option is provided. -
#create_table_from_generator(name, generator, options) ⇒ Object
:nodoc: Enhanced to support creating comments on columns, after the table itself (and hence all its columns) have been created.
-
#create_table_indexes_from_generator(name, generator, options) ⇒ Object
:nodoc: Enhanced to support creating comments on indexes, after the indexes themselves have been created.
-
#create_view(*args) ⇒ Object
An enhanced form of the standard
create_view
method, which supports setting a comment in thecreate_view
call when the:comment
option is provided.
Instance Method Details
#apply_alter_table_generator(name, generator) ⇒ Object
:nodoc:
Enhanced version to support setting comments on objects created in a
block-form alter_table
statement.
145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 |
# File 'lib/sequel/extensions/pg_comment/database_methods.rb', line 145 def apply_alter_table_generator(name, generator) super schema, table = schema_and_table(name) fqtable = [schema, table].compact.map { |e| literal e.to_sym }.join('.') generator.operations.each do |op| if op[:comment] case op[:op] when :add_column comment_on(:column, [name, op[:name]], op[:comment]) when :add_constraint case op[:type] when :primary_key comment_on(:index, "#{name}_pkey".to_sym, op[:comment]) when :foreign_key, :check c_name = op[:name] || "#{name}_#{op[:columns].first}_fkey".to_sym comment_on(:constraint, [name, c_name], op[:comment]) when :unique c_name = op[:name] || ([name] + op[:columns] + ["key"]).join("_").to_sym comment_on(:index, c_name, op[:comment]) end when :add_index c_name = op[:name] || ([name] + op[:columns] + ["index"]).join("_").to_sym comment_on(:index, c_name, op[:comment]) end end end end |
#comment_for(object) ⇒ String, NilClass
Retrieve the comment for a database object.
56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 |
# File 'lib/sequel/extensions/pg_comment/database_methods.rb', line 56 def comment_for(object) object = object.to_s if object.index("__") tbl, col = object.split("__", 2) (select(Sequel.function(:col_description, :c__oid, :a__attnum).as(:comment)). from(Sequel.as(:pg_class, :c)). join(Sequel.as(:pg_attribute, :a), :c__oid => :a__attrelid). where(:c__relname => tbl). and(:a__attname => col).first || {})[:comment] else (select( Sequel.function( :obj_description, Sequel.cast(object, :regclass), "pg_class" ).as(:comment) ).first || {})[:comment] end end |
#comment_on(type, id, comment) ⇒ Object
33 34 35 36 37 38 39 40 41 42 |
# File 'lib/sequel/extensions/pg_comment/database_methods.rb', line 33 def comment_on(type, id, comment) if Sequel::Postgres::Comment::STANDALONE_TYPES.include?(type) comment_on_standalone_type(type, id, comment) elsif Sequel::Postgres::Comment::CONTAINED_TYPES.include?(type) comment_on_contained_type(type, id, comment) else raise Sequel::Error, "Unknown object type: #{type.inspect}" end end |
#create_table(*args) ⇒ Object
An enhanced form of the standard create_table
method, which supports
setting a comment in the create_table
call when the :comment
option
is provided.
86 87 88 89 90 91 92 |
# File 'lib/sequel/extensions/pg_comment/database_methods.rb', line 86 def create_table(*args) super if args.last.is_a?(Hash) && args.last[:comment] comment_on(:table, args.first, args.last[:comment]) end end |
#create_table_from_generator(name, generator, options) ⇒ Object
:nodoc: Enhanced to support creating comments on columns, after the table itself (and hence all its columns) have been created.
98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 |
# File 'lib/sequel/extensions/pg_comment/database_methods.rb', line 98 def create_table_from_generator(name, generator, ) super generator.columns.each do |col| if col[:comment] comment_on(:column, [name, col[:name]], col[:comment]) end end generator.constraints.each do |c| case c[:type] when :primary_key c_name = c[:name] || "#{name}_pkey".to_sym comment_on(:index, c_name, c[:comment]) when :foreign_key, :check if c[:type] == :check && c[:name].nil? raise Sequel::Error, "Setting comments on unnamed check constraints is not supported" end c_name = c[:name] || "#{name}_#{c[:columns].first}_fkey".to_sym comment_on(:constraint, [name, c_name], c[:comment]) when :unique c_name = c[:name] || ([name] + c[:columns] + ["key"]).join("_").to_sym comment_on(:index, c_name, c[:comment]) end end end |
#create_table_indexes_from_generator(name, generator, options) ⇒ Object
:nodoc: Enhanced to support creating comments on indexes, after the indexes themselves have been created.
130 131 132 133 134 135 136 137 138 139 |
# File 'lib/sequel/extensions/pg_comment/database_methods.rb', line 130 def create_table_indexes_from_generator(name, generator, ) super generator.indexes.each do |idx| if idx[:comment] i_name = idx[:name] || ([name] + idx[:columns] + ["index"]).join("_").to_sym comment_on(:index, i_name, idx[:comment]) end end end |
#create_view(*args) ⇒ Object
An enhanced form of the standard create_view
method, which supports
setting a comment in the create_view
call when the :comment
option
is provided.
183 184 185 186 187 188 189 |
# File 'lib/sequel/extensions/pg_comment/database_methods.rb', line 183 def create_view(*args) super if args.last.is_a?(Hash) && args.last[:comment] comment_on(:view, args.first, args.last[:comment]) end end |