module Foreigner::ConnectionAdapters::Sql2003

Public Instance Methods

add_foreign_key(from_table, to_table, options = {}) click to toggle source
# File lib/foreigner/connection_adapters/sql2003.rb, line 22
def add_foreign_key(from_table, to_table, options = {})
  sql = "ALTER TABLE #{quote_proper_table_name(from_table)} #{add_foreign_key_sql(from_table, to_table, options)}"
  execute(sql)
end
add_foreign_key_sql(from_table, to_table, options = {}) click to toggle source
# File lib/foreigner/connection_adapters/sql2003.rb, line 27
def add_foreign_key_sql(from_table, to_table, options = {})
  column  = options[:column] || "#{to_table.to_s.singularize}_id"
  foreign_key_name = options.key?(:name) ? options[:name].to_s : foreign_key_name(from_table, column)
  primary_key = options[:primary_key] || "id"
  dependency = dependency_sql(options[:dependent])

  sql =
    "ADD CONSTRAINT #{quote_column_name(foreign_key_name)} " +
    "FOREIGN KEY (#{quote_column_name(column)}) " +
    "REFERENCES #{quote_proper_table_name(to_table)}(#{primary_key})"
  sql << " #{dependency}" if dependency.present?
  sql << " #{options[:options]}" if options[:options]

  sql
end
drop_table(*args) click to toggle source
Calls superclass method
# File lib/foreigner/connection_adapters/sql2003.rb, line 8
def drop_table(*args)
  options = args.extract_options!
  if options[:force]
    disable_referential_integrity { super(*(args.dup << options)) }
  else
    super(*(args.dup << options))
  end
end
foreign_key_exists?(from_table, options) click to toggle source
# File lib/foreigner/connection_adapters/sql2003.rb, line 17
def foreign_key_exists?(from_table, options)
  foreign_key_name = decipher_foreign_key_name(from_table, options)
  foreign_keys(from_table).any? { |fk| fk.name == foreign_key_name }
end
proper_table_name(table) click to toggle source
# File lib/foreigner/connection_adapters/sql2003.rb, line 47
def proper_table_name(table)
  # This will normally be a no-op, but prevents the table from being wrapped twice:
  table = Foreigner::SchemaDumper::ClassMethods.remove_prefix_and_suffix(table)
  if ActiveRecord::Migration.instance_methods(false).include? :proper_table_name
    ActiveRecord::Migration.new.proper_table_name(table, options = {
      table_name_prefix: ActiveRecord::Base.table_name_prefix,
      table_name_suffix: ActiveRecord::Base.table_name_suffix
    })
  else
    ActiveRecord::Migrator.proper_table_name(table)
  end
end
quote_proper_table_name(table) click to toggle source
# File lib/foreigner/connection_adapters/sql2003.rb, line 43
def quote_proper_table_name(table)
  quote_table_name(proper_table_name(table))
end
remove_foreign_key(table, options) click to toggle source
# File lib/foreigner/connection_adapters/sql2003.rb, line 60
def remove_foreign_key(table, options)
  execute "ALTER TABLE #{quote_proper_table_name(table)} #{remove_foreign_key_sql(table, options)}"
end
remove_foreign_key_sql(table, options) click to toggle source
# File lib/foreigner/connection_adapters/sql2003.rb, line 64
def remove_foreign_key_sql(table, options)
  foreign_key_name = decipher_foreign_key_name(table, options)
  "DROP CONSTRAINT #{quote_column_name(foreign_key_name)}"
end
supports_foreign_keys?() click to toggle source
# File lib/foreigner/connection_adapters/sql2003.rb, line 4
def supports_foreign_keys?
  true
end

Private Instance Methods

decipher_foreign_key_name(from_table, options) click to toggle source
# File lib/foreigner/connection_adapters/sql2003.rb, line 78
def decipher_foreign_key_name(from_table, options)
  if Hash === options
    options.key?(:name) ? options[:name].to_s : foreign_key_name(from_table, options[:column])
  else
    foreign_key_name(from_table, foreign_key_column(options))
  end
end
dependency_sql(dependency) click to toggle source
# File lib/foreigner/connection_adapters/sql2003.rb, line 86
def dependency_sql(dependency)
  case dependency
    when :nullify then "ON DELETE SET NULL"
    when :delete  then "ON DELETE CASCADE"
    when :restrict then "ON DELETE RESTRICT"
    else ""
  end
end
foreign_key_column(to_table) click to toggle source
# File lib/foreigner/connection_adapters/sql2003.rb, line 74
def foreign_key_column(to_table)
  "#{to_table.to_s.singularize}_id"
end
foreign_key_name(from_table, column) click to toggle source
# File lib/foreigner/connection_adapters/sql2003.rb, line 70
def foreign_key_name(from_table, column)
  "#{from_table}_#{column}_fk"
end