Class: Dbsketch::Rendering::SQL::IndexRenderer
- Inherits:
-
Object
- Object
- Dbsketch::Rendering::SQL::IndexRenderer
- Defined in:
- lib/dbsketch/rendering/sql/index_renderer.rb
Instance Method Summary collapse
Instance Method Details
#create(index) ⇒ Object
13 14 15 16 17 18 |
# File 'lib/dbsketch/rendering/sql/index_renderer.rb', line 13 def create index ### Preconditions raise ArgumentError, "index is not a Dbsketch::Model::Index" unless index.is_a? Dbsketch::Model::Index ### "create index #{index.name} on #{index.target.name} (#{index.columns.map {|c| c.name }.join(", ")})" end |
#drop(index) ⇒ Object
20 21 22 23 24 25 |
# File 'lib/dbsketch/rendering/sql/index_renderer.rb', line 20 def drop index ### Preconditions raise ArgumentError, "index is not a Dbsketch::Model::Index" unless index.is_a? Dbsketch::Model::Index ### "if exists(select * from sysindexes where name = '#{index.name}') drop index #{index.name} on #{index.target.name}" end |