advanced code snippet search

Posted By

ctran on 02/20/08


Tagged

migration


Versions (?)

Who likes this?

1 person has marked this snippet as a favorite

webstic


migration_helpers.rb

Published in: Ruby 

URL: http://media.pragprog.com/titles/fr_arr/code/buffet/lib/migration_helpers.rb

Expand | Embed | Plain Text 
  1. #---
  2. # Excerpted from "Advanced Rails Recipes",
  3. # published by The Pragmatic Bookshelf.
  4. # Copyrights apply to this code. It may not be used to create training material, 
  5. # courses, books, articles, and the like. Contact us if you are in doubt.
  6. # We make no guarantees that this code is fit for any purpose. 
  7. # Visit http://www.pragmaticprogrammer.com/titles/fr_arr for more book information.
  8. #---
  9. module MigrationHelpers
  10.  
  11.   def fk(from_table, from_column, to_table)
  12.     execute %(alter table #{from_table}
  13.               add constraint #{constraint_name(from_table, from_column)}
  14.               foreign key (#{from_column})
  15.               references #{to_table}(id))
  16.   end
  17.  
  18.   def drop_fk(from_table, from_column)    
  19.     execute %(alter table #{from_table} 
  20.               drop foreign key #{constraint_name(from_table, from_column)})
  21.   end
  22.  
  23.   def constraint_name(table, column)
  24.     "fk_#{table}_#{column}"
  25.   end
  26.  
  27. end

Report this snippet 

Comments

RSS Icon Subscribe to comments
Posted By: nikejordan1 on August 31, 2010

LRH 2010-8-31 MBT Baridi Shoes Tone, shape and make the most of your free time with this airy and light MBT model. MBT Ema Shoes put 19% less stress or pressure on knee and hip joints, researchers have shown.A durable rubber outsole offers lightweight support with good traction. Antimicrobial Dry&Cool mesh and foam sock lining allows for breathability and assists moisture management. The effects of wearing MBT Ema are truly second to none. Of course, you can also order other MBT Walking Shoes, such as MBT Sport Shoes and MBT Lami Shoes, etc. Sport nutritionists and several thousands of clients agree that MBT Shoes helps to live a healthier, happirer lifestyle. In mbtshoess.com, Our Cheap MBT Shoes in www.mbtshoess.com are waiting for you to choose. All the MBT Shoes Sale are original and can absolutely with the fastest speed to your designated location.

You need to login to post a comment.